SQL Server ile New Query açarak NPC niz ile ilgili alanları düzeltirseniz sorunsuz silinecektir !
--NOT: YEDEK ALMAYI UNUTMAYIN !
--NOT: YEDEK ALMAYI UNUTMAYIN !
SQL:
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_MALL')))delete from Tab_RefNest where dwTacticsID = ( select dwTacticsID from Tab_RefTactics where dwObjID = ( select ID from _RefObjCommon where CodeName128 like 'NPC_MALL'))
delete from Tab_RefTactics where dwTacticsID = ( select dwTacticsID from Tab_RefTactics where dwObjID = ( select ID from _RefObjCommon where CodeName128 like 'NPC_MALL'))
delete from _RefObjChar where ID = ( select Link from _RefObjCommon where CodeName128 like 'NPC_MALL' )
delete from _RefObjCommon where CodeName128 Like '%NPC_MALL'
delete from _RefShop where CodeName128 like '%NPC_MALL'
delete from _RefShopGroup where CodeName128 like '%NPC_MALL'
delete from _RefShopItemGroup where CodeName128 like '%NPC_MALL'
delete from _RefShopTab where CodeName128 like '%NPC_MALL'
delete from _RefShopTabGroup where CodeName128 like '%NPC_MALL'
delete from _RefMappingShopGroup where RefShopCodeName like '%NPC_MALL'
delete from _RefMappingShopWithTab where RefShopCodeName like '%NPC_MALL'
