[Guide] Useful codes for Admins

[Dungeon]

Edit Resets :

UPDATE Character SET Resets=[COLOR=Red]Resets here[/COLOR] WHERE name ='[COLOR=Red]Char here[/COLOR]'

Block Account:

UPDATE MEMB_INFO SET bloc_code=1 WHERE memb___id='[COLOR=Red]Account here[/COLOR]'

UnBlock Account:

UPDATE MEMB_INFO SET bloc_code=0 WHERE memb___id='[COLOR=Red]Account here[/COLOR]'

UnBlock All Accounts:

UPDATE MEMB_INFO SET bloc_code=0

Accounts Online:

SELECT memb___id FROM MEMB_STAT WHERE ConnectStat=1

Make Someone GM:

UPDATE Character SET CtlCode=8 WHERE Name='[COLOR=Red]Char here[/COLOR]'

Credits goes to me

 

[Angerfist]

10/10