there is any code 2 clean the database?

Quote:

Originally Posted by Synx7 Code: truncate table _UserTradeConflictJob delete from _TrainingCamp truncate table _TrainingCampBuffStatus truncate table _TrainingCampHonorRank truncate table _TrainingCampHonorRankUpdateDate truncate table _TrainingCampMember truncate table _TrainingCampSubMentorHonorPoint truncate table _BlockedWhisperers truncate table _SiegeFortressItemForge truncate table _CharTrijobSafeTrade truncate table _SiegeFortressObject truncate table _TrainingCampMember delete from _CharTrijob truncate table _SiegeFortressStruct truncate table _InventoryForLinkedStorage truncate table _OpenMarket truncate table _ChestInfo truncate table _InventoryForAvatar truncate table _TradeEquipInventory truncate table _TradeBagInventory truncate table _CharAlchemy_MK_Recipe truncate table _CharSkill truncate table _CharSkillMastery truncate table _GuildMember truncate table _Inventory truncate table _StaticAvatar truncate table _User truncate table _Friend truncate table _Memo truncate table _TimedJob truncate table _InvCOS delete from _CharCOS where ID > 0 delete from _Char where charid > 0 delete from _SiegeFortress truncate table _Chest truncate table _ItemPool delete from _Items where ID64 > 0 delete from _AccountJID truncate table _GuildChest update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0 truncate table _GuildWar delete from _Guild where ID > 0 delete from _AlliedClans where ID > 0 truncate table _CharNameList truncate table _CharQuest truncate table _ClientConfig truncate table _DeletedChar exec _LinkRefRegions