Query to Remove spot by monster ID or Name

[Eroticus]

Query to Remove spot by monster ID or Name

Thanks .

[MentaL]

[Isoline]

never tested it...make sure you make a backup ! hopefully it will help you

/*Delete mob Spawn by Isoline */


USE [SRO_TW_SHARD]
Update Tab_RefNest Set
fLocalPosX=NULL ,
fLocalPosY=NULL ,
fLocalPosZ=NULL
WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'YOUR MOB CODE NAME'))

[Eroticus]

never tested it...make sure you make a backup ! hopefully it will help you

Msg 512, Level 16, State 1, Line 1
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.