Zerar todos os vips:
Update memb_info set AccountLevel = 0


Colocar X dias vip para todos:
Update memb_info set AccountLevel = TIPOVIP, AccountExpireDate = getdate()+DIAS


Excluir cash(WC,WP,GP) de todos (Season 6+)
Delete from CashShopData


Zerar Master Skill Tree de todas as contas(deve ser executado com o servidor Offline)
Delete from MasterSkillTreeData


Excluir itens do báu(deve ser executado com o servidor Offline)
Delete from Warehouse
Delete from ExtWarehouse
Delete from WarehouseGuild (Se usa louis emulator update 11+)


Excluir todas as guilds(deve ser executado com o servidor Offline):
Delete from GuildMember
Delete from Guild


Resetar o Inventory(deve ser executado com o servidor Offline):
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 0) where Character.Class = 0 or Character.Class = 1 or Character.Class = 2
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 16) where Character.Class = 16 or Character.Class = 17 or Character.Class = 18
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 32) where Character.Class = 32 or Character.Class = 33 or Character.Class = 34
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 48) where Character.Class = 48 or Character.Class = 49 or Character.Class = 50
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 64) where Character.Class = 64 or Character.Class = 65 or Character.Class = 66
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 80) where Character.Class = 80 or Character.Class = 81 or Character.Class = 82
Update Character set Inventory = (Select Inventory from DefaultClassType where Class = 96) where Character.Class = 96 or Character.Class = 97 or Character.Class = 98


Se precisarem de mais algo é só pedir.


Bjos
Louis