Deleting Npcs

12/15/2014 16:11 rosoares#1
Hello everyone , Im using a db with some npcs which I got no interest , can someone tell me how to delete them?
12/16/2014 04:29 Eslam Galull#2
you can simply remove the spwan from RefNest !
12/16/2014 17:29 rosoares#3
Quote:
Originally Posted by its.soul View Post
you can simply remove the spwan from RefNest !
well i could delete it from there , but how do i find the id from the npcs ?
12/16/2014 17:47 WickedNite.#4
Quote:
Originally Posted by rosoares View Post
well i could delete it from there , but how do i find the id from the npcs ?
RefObjCommon ID -> reftactics then dwtacticsID in refnest
12/16/2014 17:57 ​Exo#5
PHP Code:
USE SRO_VT_SHARD
DECLARE @RefID int
SELECT @RefID = R.dwTacticsID
FROM Tab_RefTactics R
JOIN _RefObjCommon O
ON O.ID = R.dwObjID
WHERE O.CodeName128 LIKE 'NPC_CODE'
DELETE FROM Tab_RefNest WHERE dwTacticsID = @RefID 
Hf
12/16/2014 18:19 rosoares#6
thanks for the help guys