TRUNCATE TABLE characters;
TRUNCATE TABLE guild_data;
TRUNCATE TABLE guild_application;
TRUNCATE TABLE guild_logs;
TRUNCATE TABLE guild_ranks;
TRUNCATE TABLE account_data;
TRUNCATE TABLE guild_items;
TRUNCATE TABLE guilds;
TRUNCATE TABLE playervip;
TRUNCATE TABLE playeronlinecount;
TRUNCATE TABLE playermagics;
TRUNCATE TABLE playeritemslog;
TRUNCATE TABLE playeritems;
TRUNCATE TABLE playercooldowns;
TRUNCATE TABLE playercashlog;
TRUNCATE TABLE playlog;
update siege_warfare set guildid=0,attack_guildid=0 where entry=1;
update world_global_variables set text='0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,' where entry=1; |