- Joined
- Jul 24, 2011
- Messages
- 806
- Reaction score
- 615
Run on Server01 database.. It will remove all AuthType=2 user from a dungeon rankings (solo)
I release this for give more power to Kome Keto!
Code:
DELETE w FROM [Server01].[dbo].[cabal_DungeonRankingSingle_table] w
INNER JOIN Account.dbo.cabal_auth_table x
ON ROUND(w.CharIdx/8, 0, 1) = x.UserNum
WHERE AuthType='2'
I release this for give more power to Kome Keto!