Query to delete

[CrowZZ]

Would anyone have a query that only accounts and characters ???:blush:

 

[samus]

this is for wipe all db , less EventData

To view the content, you need to sign in or register

 

[Onplay]

bro how to delete One Account Only .....bcos have problem .........

 

[CrowZZ]

thank you very much brothers​

 

[S37uP!Update]

this is for wipe all db , less EventData

To view the content, you need to sign in or register

Ok, after using this sql query you have to reset the IDENTITY of account in database, for example if you last created account has UserNum 1000, if you only use this query to wipe, after wipe the next account created will start from 1001,1002,1003, etc.
So if you want to start form UserNum 1 use this query also.

Use all cabal online databases, not on EventData.

/*Reset Identity on tables with identity column*/
exec sp_MSforeachtable 'IF OBJECTPROPERTY(OBJECT_ID(''?''), ''TableHasIdentity'') = 1 BEGIN DBCC CHECKIDENT (''?'',RESEED,0) END'