بعد اذن المحترفين ممكن مساعده

[عمرو شوقى]

انا عايز امسح npc من اللعبه امسحو ازاى

[Dev.Sawy]

اولا علشان تمسح Npc لازم تجيب ال ID بتاعو
دي Query تجيب بيها ID NPC

كود PHP:
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'NPC_YUI_DANGERS'
ولما تطلع الID هتاخدو Copy وتحطو في الQuery دي

كود PHP:
delete from Tab_RefNest
where dwTacticsID=(Select dwTacticsID from Tab_RefTactics where dwObjID='12345')
----------------------------- دا كدا مسح الNPC

[Dev.Sawy]

Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'NPC_YUI_DANGERS

[Dev.Sawy]

اولا علشان تمسح Npc لازم تجيب ال ID بتاعو
دي Query تجيب بيها ID NPC

Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'NPC_YUI_DANGERS'
ولما تطلع الID هتاخدو Copy وتحطو في الQuery دي
delete from Tab_RefNest
where dwTacticsID=(Select dwTacticsID from Tab_RefTactics where dwObjID='12345')

[gameman]

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 'Your NPC Name in refobjcommon')))
delete from Tab_RefNest where dwTacticsID = ( select dwTacticsID from Tab_RefTactics where dwObjID = ( select ID from _RefObjCommon where CodeName128 like 'Your NPC Name in refobjcommon'))
delete from Tab_RefTactics where dwTacticsID = ( select dwTacticsID from Tab_RefTactics where dwObjID = ( select ID from _RefObjCommon where CodeName128 like 'Your NPC Name in refobjcommon'))
delete from _RefObjChar where ID = ( select Link from _RefObjCommon where CodeName128 like 'Your NPC Name in refobjcommon' )
delete from _RefObjCommon where CodeName128 Like 'Your NPC Name in refobjcommon'
delete from _RefShop where CodeName128 like 'Your NPC Name in refobjcommon'
delete from _RefShopGroup where CodeName128 like 'Your NPC Name in refobjcommon'
delete from _RefShopItemGroup where CodeName128 like 'Your NPC Name in refobjcommon'
delete from _RefShopTab where CodeName128 like 'Your NPC Name in refobjcommon'
delete from _RefShopTabGroup where CodeName128 like 'Your NPC Name in refobjcommon'

انبست يا معلم

[gameman]

نسيت اقلك انا مش محترف :) عادي ولا ايية :innocent:

[عمرو شوقى]

تسلم ياباشا و الف شكر