U can use my querry to get the RefNestID by Codename128
Quote:
USE [SRO_VT_SHARD]
SELECT [dwNestID] FROM [dbo].[Tab_RefNest] WHERE dwTacticsID =
( SELECT [dwTacticsID] FROM [dbo].[Tab_RefTactics] WHERE dwObjID =
(select ID from _RefObjCommon where CodeName128 like 'MOB_RM_ROC') )
|
Replace SELECT [dwNestID] with DELETE and replace MOB_RM_ROC with your NPC name to be deleted.
For teleports, Set RegionID, OffsetX, OffsetY, OffsetZ to 0 (am not sure if it will work)
Take a Back up first.