[Mahmoud Rashwan]

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

حضرتك الكيوري اللي فوق زاي اللي تحت ايه الأختلاف مش فاهم



بص يا أستاذي العزيز عشان متلفش حوالين نفسك
عشان تمسح Npc أستخدم الكيوري ده

use SRO_VT_SHARD 
Delete from Tab_RefHive where dwHiveID IN ( select dwHiveID from Tab_RefNest where dwTacticsID IN ( select dwTacticsID from Tab_RefTactics where dwObjID IN ( select ID from _RefObjCommon where CodeName128 like 'Codename NPC%'))) 
Delete from Tab_RefNest where dwTacticsID IN ( select dwTacticsID from Tab_RefTactics where dwObjID IN ( select ID from _RefObjCommon where CodeName128 like 'Codename NPC%')) 
Delete from Tab_RefTactics where dwTacticsID IN ( select dwTacticsID from Tab_RefTactics where dwObjID IN ( select ID from _RefObjCommon where CodeName128 like 'Codename NPC%'))   
Delete from _RefObjChar where ID IN ( select Link from _RefObjCommon where CodeName128 like 'Codename NPC%' ) 
Delete from _RefObjCommon where CodeName128 Like '%Codename NPC%' 
Delete from _RefShop where CodeName128 like '%Codename NPC%' 
Delete from _RefShopGroup where CodeName128 like '%Codename NPC%' 
Delete from _RefShopItemGroup where CodeName128 like '%Codename NPC%' 
Delete from _RefShopTab where CodeName128 like '%Codename NPC%' 
Delete from _RefShopTabGroup where CodeName128 like '%Codename NPC%' 
Delete from _RefMappingShopGroup where RefShopCodeName like '%Codename NPC%' 
Delete from _RefMappingShopWithTab where RefShopCodeName like '%Codename NPC%'

تمـ التعديل