الموضوع: Quere
عرض مشاركة واحدة
قديم 21-06-2015, 03:36 PM   #4

MikrotikBody
عضو مميز



الصورة الرمزية MikrotikBody


• الانـتـسـاب » May 2013
• رقـم العـضـويـة » 111830
• المشـــاركـات » 885
• الـدولـة » Giza
• الـهـوايـة » Photoshop & 3d
• اسـم الـسـيـرفـر » Private Server
• الـجـنـس » Male
• نقـاط التقييم » 11
MikrotikBody صـاعـد

MikrotikBody غير متواجد حالياً


إرسال رسالة عبر Yahoo إلى MikrotikBody

افتراضي رد: 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'


توقيع MikrotikBody :
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]