Deleting Npcs

[rosoares]

Hello everyone , Im using a db with some npcs which I got no interest , can someone tell me how to delete them?

[Eslam Galull]

you can simply remove the spwan from RefNest !

[rosoares]

Originally Posted by its.soul

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 ?

[WickedNite.]

Originally Posted by rosoares

well i could delete it from there , but how do i find the id from the npcs ?

RefObjCommon ID -> reftactics then dwtacticsID in refnest

[​Exo]

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

[rosoares]

thanks for the help guys