NEED HELP WITH NPC REMOVER!

[jorgefelix]

hELLO I WANT TO REMOVE THE NPC IN DW ( FOR ITEM CLOTH AND WEAPON ) HOW CAN I DO IT TO REMOVE THOSE 2 NPC ?

[​Exo]

PHP Code:

DELETE NST
FROM   Tab_RefTactics T
JOIN   _RefObjCommon Obj
on     T.dwObjID = Obj.ID
JOIN   Tab_RefNest NST
ON     T.dwTacticsID = NST.dwTacticsID
WHERE Obj.CodeName128 Like 'NPC_CODE_HERE' 


This would do it. [remove the npc spawn]

[jorgefelix]

not helpful at all

[​Exo]

Originally Posted by jorgefelix

not helpful at all

Okaay(inslowvoice), how was this 'not helpful' this probably does what you asked for [Removing an NPC].

[Memoirs]

Originally Posted by jorgefelix

not helpful at all

*****, it works just fine, use your brain

[Zodiao]

If I'm right, he wanted to know how to do that = learn, not just do it = wannabe
Giving out a query was not helpful if he didn't understand what it does..

If so:
Then you need to:
------------------
1-Get ID from _RefObjCommon

 Select ID from _RefobjCommon where CodeName128 like '%NPC_CODE_HERE(WC IS the donwhang shortcode)%'

2- Check dwTacticsID based on dwobjID

 Select dwTacticsID from Tab_Reftactics where dwObjID='ID you got from RefOBjcommon'

3- delete it:

DELETE FROM TAB_REFNEST WHERE DwTacticsID='ID you got from 2nd query'

-------------------
IF not then you don't need to understand, you want ready work, and you shouldn't be doing this.

[​Exo]

Urghh, whatever, not used to seeing people seeking information these days even tho, the query should give all the needed info.