[ღ♥Alexandria♥ღ]

(¯`·.» الان و حصريا علي سيلك رود عرب ازاي تحزف your new Buged NPC ! «.·`¯)

////////////////////**By mneam001 Alexandria**////////////////
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_'
////////////////////**By mneam001 alexandria**////////////////
delete from _RefShop where CodeName128 like '%AVATARN_'
delete from _RefShopGroup where CodeName128 like '%AVATARN_'
delete from _RefShopItemGroup where CodeName128 like '%AVATARN_'
////////////////////**By mneam001 Alexandria**////////////////
delete from _RefShopTab where CodeName128 like '%AVATARN_'
delete from _RefShopTabGroup where CodeName128 like '%AVATARN_'
////////////////////**By mneam001 Alexandria**////////////////
delete from _RefMappingShopGroup where RefShopCodeName like '%AVATARN_'
delete from _RefMappingShopWithTab where RefShopCodeName like '%AVATARN_'  

تحياتي MneaM001