JanGanSRO
11-04-2016, 10:32 PM
حاجة بسيطة كدة
فى قاعده البيانات الخاصه بيك
اكيد حتلاقى كاركترات كتير عند خانه Deleted = 1
فى جدول _char
لو حابب تتخلص من كل الكاركترات دى بضغطه واحدة علشان لو عندك كاركترات كتير ممسوحه
الامر دة حينفذ المطلوب
حتنفذ الامر دة الاول علشاع تعرف عدد الجداول و الخانات Check & make Bacup if you will have any problem after deleted
use sro_vt_shard
select * from _StaticAvatar where CharID in (select CharID from _Char where Deleted =1)
select * from _TimedJob where CharID in (select CharID from _Char where Deleted =1)
select * from _CharSkill where CharID in (select CharID from _Char where Deleted =1)
select * from _CharSkillMastery where CharID in (select CharID from _Char where Deleted =1)
select * from _Inventory where CharID in (select CharID from _Char where Deleted =1)
select * from _Friend where CharID in (select CharID from _Char where Deleted =1)
select * from _Friend where FriendCharID in (select CharID from _Char where Deleted =1)
select * from _Memo where CharID in (select CharID from _Char where Deleted =1)
select * from _Char where Deleted =1
بعد ما تاخود باك اب علشان لو حصل معاك مشكله بعد المسح مع العلم ان بازن الله مفيش اى مشاكل و مجربه عندى
حتنفذ الامر دة و هو دة الامر الخاص بالمسح
use sro_vt_shard
delete from _StaticAvatar where CharID in (select CharID from _Char where Deleted =1)
delete from _TimedJob where CharID in (select CharID from _Char where Deleted =1)
delete from _CharSkill where CharID in (select CharID from _Char where Deleted =1)
delete from _CharSkillMastery where CharID in (select CharID from _Char where Deleted =1)
delete from _Inventory where CharID in (select CharID from _Char where Deleted =1)
delete from _Friend where CharID in (select CharID from _Char where Deleted =1)
delete from _Friend where FriendCharID in (select CharID from _Char where Deleted =1)
delete from _Memo where CharID in (select CharID from _Char where Deleted =1)
delete from _Char where Deleted =1
تحياتى للجميع
فى قاعده البيانات الخاصه بيك
اكيد حتلاقى كاركترات كتير عند خانه Deleted = 1
فى جدول _char
لو حابب تتخلص من كل الكاركترات دى بضغطه واحدة علشان لو عندك كاركترات كتير ممسوحه
الامر دة حينفذ المطلوب
حتنفذ الامر دة الاول علشاع تعرف عدد الجداول و الخانات Check & make Bacup if you will have any problem after deleted
use sro_vt_shard
select * from _StaticAvatar where CharID in (select CharID from _Char where Deleted =1)
select * from _TimedJob where CharID in (select CharID from _Char where Deleted =1)
select * from _CharSkill where CharID in (select CharID from _Char where Deleted =1)
select * from _CharSkillMastery where CharID in (select CharID from _Char where Deleted =1)
select * from _Inventory where CharID in (select CharID from _Char where Deleted =1)
select * from _Friend where CharID in (select CharID from _Char where Deleted =1)
select * from _Friend where FriendCharID in (select CharID from _Char where Deleted =1)
select * from _Memo where CharID in (select CharID from _Char where Deleted =1)
select * from _Char where Deleted =1
بعد ما تاخود باك اب علشان لو حصل معاك مشكله بعد المسح مع العلم ان بازن الله مفيش اى مشاكل و مجربه عندى
حتنفذ الامر دة و هو دة الامر الخاص بالمسح
use sro_vt_shard
delete from _StaticAvatar where CharID in (select CharID from _Char where Deleted =1)
delete from _TimedJob where CharID in (select CharID from _Char where Deleted =1)
delete from _CharSkill where CharID in (select CharID from _Char where Deleted =1)
delete from _CharSkillMastery where CharID in (select CharID from _Char where Deleted =1)
delete from _Inventory where CharID in (select CharID from _Char where Deleted =1)
delete from _Friend where CharID in (select CharID from _Char where Deleted =1)
delete from _Friend where FriendCharID in (select CharID from _Char where Deleted =1)
delete from _Memo where CharID in (select CharID from _Char where Deleted =1)
delete from _Char where Deleted =1
تحياتى للجميع