NEED HELP WITH NPC REMOVER!

02/03/2015 05:00 jorgefelix#1

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

02/03/2015 11:31 Exo#2

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]

02/04/2015 00:52 jorgefelix#3

not helpful at all

02/04/2015 01:39 Exo#4

Quote:

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].

02/04/2015 15:26 Memoirs#5

Quote:

Originally Posted by jorgefelix

not helpful at all

lmfao, it works just fine, use your brain :p

02/04/2015 19:13 Zodiao#6

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

Code:

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

2- Check dwTacticsID based on dwobjID

Code:

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

3- delete it:

Code:

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.

02/04/2015 21:10 Exo#7

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