[RELEASE] Shard data base clean command
good luck
PHP Code:
use mydbname;
delete from _Chest;
delete from _ChestInfo;
delete from _User;
delete from _OpenMarket;
delete from _AccountJID;
delete from _InvCOS;
delete from _CharCOS;
delete from _CharTrijobSafeTrade;
delete from _CharTrijob;
delete from _CharSkill;
delete from _CharSkillMastery;
delete from _Inventory;
delete from _StaticAvatar;
delete from _InventoryForAvatar;
delete from _Friend;
delete from _TimedJob;
delete from _TrainingCampMember;
delete from _GuildMember;
delete from _Memo;
delete from _BlockedWhisperers;
delete from _Char;
delete from _InventoryForLinkedStorage;
delete from _Items;
delete from _ItemPool;
delete from _GuildChest;
delete from _GPHistory;
delete from _AlliedClans;
delete from _SiegeFortressStruct;
delete from _SiegeFortressObject;
delete from _SiegeFortressItemForge;
delete from _SiegeFortress;
delete from _Guild;
go
Re: [RELEASE] Shard data base clean command
If you use this - you'll delete to much data ^^
for example _Items table there need to be left 1st row so where ItemID > '0'
That's just an example (there's some stuff with ID 0 which should remain in db)
