Query Remove Monster or NPC Complett from Spawn

[NorseGodTyr]

Hey Elitepvper Community
i see much Threadssome ppl looking for it how i can delete Monster or NPC from spawn ? i have check my query folder and found one

USE SRO_VT_SHARD /* Delete Monster or NPC spawn */

DECLARE @Monster_or_NPC VARCHAR (max)

SET @Monster_or_NPC = 'MOB_NPC_CODENAME128' -- MonsterCodeName in Table _RefobjCommon

-- ©NorseGodTyr

DELETE FROM [SRO_VT_SHARD].[dbo].[Tab_RefHive]
Where dwHiveID IN (Select dwHiveID FROM [SRO_VT_SHARD].[dbo].[Tab_RefNest]
Where dwTacticsID IN (Select dwTacticsID FROM [SRO_VT_SHARD].[dbo].[Tab_RefTactics]
Where dwObjID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefObjCommon Where Codename128 LIKE @Monster_or_NPC)))

DELETE FROM [SRO_VT_SHARD].[dbo].[Tab_RefNest]
Where dwTacticsID IN (Select dwTacticsID FROM [SRO_VT_SHARD].[dbo].[Tab_RefTactics]
Where dwObjID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefObjCommon Where Codename128 LIKE @Monster_or_NPC) )

DELETE FROM [SRO_VT_SHARD].[dbo].[Tab_RefTactics]
Where dwTacticsID IN (Select dwTacticsID FROM [SRO_VT_SHARD].[dbo].[Tab_RefTactics]
Where dwObjID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefObjCommon Where Codename128 LIKE @Monster_or_NPC) )

[devdash]

Originally Posted by NorseGodTyr

Hey Elitepvper Community
i see much Threadssome ppl looking for it how i can delete Monster or NPC from spawn ? i have check my query folder and found one

this query may do bugs later, because sometimes the RefHive line used by diffrent RefNest, and your query will delete the RefHive that linked with the RefNest.


correct me if iam wrong please...[Learning still]

[NorseGodTyr]

Originally Posted by alydandy

this query may do bugs later, because sometimes the RefHive line used by diffrent RefNest, and your query will delete the RefHive that linked with the RefNest.


correct me if iam wrong please...[Learning still]

na here will nothing bugging your server ! he the query is search every ID and delete the correct ID from the linked mob also work 100% fine

Originally Posted by alydandy

this query may do bugs later, because sometimes the RefHive line used by diffrent RefNest, and your query will delete the RefHive that linked with the RefNest.


correct me if iam wrong please...[Learning still]

by every query is check if the dwTacticsID exsists

Where dwTacticsID IN (Select dwTacticsID FROM [SRO_VT_SHARD].[dbo].[Tab_RefTactics]
Where dwObjID IN (SELECT ID FROM SRO_VT_SHARD.dbo._RefObjCommon Where Codename128 LIKE @Monster_or_NPC) )

[hoangphan7]

Only you need delete it from Tab_Refnest

PHP Code:

use sro_vt_shard
go
delete from Tab_RefNest
where dwTacticsID in (select dwTacticsID from Tab_RefTactics 
where dwObjID in (select id from _RefObjCommon where CodeName128 like 'MOB%')
) 


[devdash]

Originally Posted by NorseGodTyr

na here will nothing bugging your server ! he the query is search every ID and delete the correct ID from the linked mob also work 100% fine



by every query is check if the dwTacticsID exsists

welldone then, i will use it probably really soon.

thanks for sharing <3

[NorseGodTyr]

Originally Posted by hoangphan7

Only you need delete it from Tab_Refnest

PHP Code:

use sro_vt_shard
go
delete from Tab_RefNest
where dwTacticsID in (select dwTacticsID from Tab_RefTactics 
where dwObjID in (select id from _RefObjCommon where CodeName128 like 'MOB%')
) 


If you do not want this line you can delete it completely !!!