تغبر اسم ال npc من.textdata_object
تحذف npc
كود PHP:
use SRO_VT_SHARD
delete from Tab_RefHive where dwHiveID = ( select dwHiveID from Tab_RefNest where dwTacticsID = ( select dwTacticsID from Tab_RefTactics where dwObjID = ( select ID from _RefObjCommon where CodeName128 like 'NPC_AVATARN_')))
delete from Tab_RefNest where dwTacticsID = ( select dwTacticsID from Tab_RefTactics where dwObjID = ( select ID from _RefObjCommon where CodeName128 like 'NPC_AVATARN_'))
delete from Tab_RefTactics where dwTacticsID = ( select dwTacticsID from Tab_RefTactics where dwObjID = ( select ID from _RefObjCommon where CodeName128 like 'NPC_AVATARN_'))
delete from _RefObjChar where ID = ( select Link from _RefObjCommon where CodeName128 like 'NPC_AVATARN_' )
delete from _RefObjCommon where CodeName128 Like '%AVATARN_'
delete from _RefShop where CodeName128 like '%AVATARN_'
delete from _RefShopGroup where CodeName128 like '%AVATARN_'
delete from _RefShopItemGroup where CodeName128 like '%AVATARN_'
delete from _RefShopTab where CodeName128 like '%AVATARN_'
delete from _RefShopTabGroup where CodeName128 like '%AVATARN_'
delete from _RefMappingShopGroup where RefShopCodeName like '%AVATARN_'
delete from _RefMappingShopWithTab where RefShopCodeName like '%AVATARN_'
06-06-2014 05:56 PM