Query Remove Monster or NPC Complett from Spawn

04/10/2019 12:13 NorseGodTyr#1

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

Quote:

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) )

04/10/2019 13:21 devdash#2

Quote:

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]

04/10/2019 13:31 NorseGodTyr#3

Quote:

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

Quote:

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

Quote:

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) )

04/10/2019 16:47 hoangphan7#4

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%')
)

04/11/2019 08:45 devdash#5

Quote:

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

04/11/2019 14:10 NorseGodTyr#6

Quote:

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 !!! :)