网狐6603清理金币大于100W的用户

自助开通VIP,整站资源任意下载

/****** Script for SelectTopNRows command from SSMS

UserID=3418 billyhero

UserID=3390 divinity

UserID=3392 guoguo

******/

--金币大于100W

SELECT *

FROM [QPTreasureDB].[dbo].[GameScoreInfo] where Score>1000000 or InsureScore>1000000

or Score+InsureScore > 1000000 order by Score desc

UPDATE

[QPTreasureDB].[dbo].[GameScoreInfo] SET Score=0,InsureScore=0 where Score>1000000 or InsureScore>1000000

or Score+InsureScore > 1000000

select * from QPAccountsDB.dbo.AccountsInfo where accounts like'%divin%'

select * from QPAccountsDB.dbo.AccountsInfo where UserID=7484

网狐6603清理金币大于100W的用户-第1张

UPDATE

[QPTreasureDB].[dbo].[GameScoreInfo] SET Score=0,InsureScore=100000000 where UserID=3392

go

update accountsinfo set userright=536870912 where UserID = 3418

SELECT TOP 20 * FROM GameScoreInfo

WHERE

UserID NOT IN

(SELECT TOP 0 UserID FROM GameScoreInfo WHERE (Score>1000000 or InsureScore>1000000 or Score+InsureScore > 1000000))

网狐6603清理金币大于100W的用户-第2张

and (Score>1000000 or InsureScore>1000000 or Score+InsureScore > 1000000)

SELECT COUNT(UserID) FROM GameScoreInfo WHERE (Score>1000000 or InsureScore>1000000 or Score+InsureScore > 1000000)


本站源码仅做学术研究,自娱自乐使用,不得用于赌博性质的非法商业用途!转载请说明出处!
棋牌资源网 » 网狐6603清理金币大于100W的用户

发表评论

欢迎 访客 发表评论

这里有你所需要的,找专业的人做专业的事!

本站演示 联系客服