21-06-2015, 03:36 PM
|
#4
|
|
• الانـتـسـاب » May 2013
|
• رقـم العـضـويـة » 111830
|
• المشـــاركـات » 885
|
• الـدولـة » Giza
|
• الـهـوايـة » Photoshop & 3d
|
• اسـم الـسـيـرفـر » Private Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 11
|
|
|
رد: Quere
أتفضل لمسح أكونت واحد
كود:
DELETE from _BlockedWhisperers where OwnerID in (select CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _Items where ID64 In (SELECT ItemID from _Inventory where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')) and not ID64 = 0
DELETE FROM _Items where ID64 In (SELECT ItemID from _ItemPool where ItemID in (SELECT ItemID from _ItemPool where ItemID in (SELECT ItemID from _Inventory where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name'))))
DELETE from _ItemPool where ItemID in (SELECT ItemID from _Inventory where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name'))
DELETE from _Chest where UserJID in (SELECT UserJID from _User where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name'))
DELETE from _Inventory where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _CharSkill where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _CharSkillMastery where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _CharTrijobSafeTrade where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _CharTrijob where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _ClientConfig where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _DeletedChar where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _CharQuest where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _CharCollectionBook where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _CharNickNameList where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _CharNameList where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _Friend where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _InventoryForAvatar where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _Memo where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _StaticAvatar where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _InvCOS where CosID in (SELECT ID FROM _CharCOS where OwnerCharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name'))
DELETE FROM _CharCOS where OwnerCharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _User where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _TimedJob where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _TrainingCampSubMentorHonorPoint where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _Friend where FriendCharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _GuildMember where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _TrainingCampMember where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name')
DELETE FROM _AccountJID WHERE JID in (SELECT UserJID from _User where CharID in (SELECT CharID FROM _Char where CharName16 = 'Char Name'))
DELETE FROM _Char where CharName16 = 'Char Name'
|
|
|