Complete Query for Modifying Monsters in vSRO

[Kabloz]

I don't know if this query will help you or not, but I made it for epvp and beginner editors. It may be useful for them.


Changing the Location of a Mob in the Town
The second part it helps change the location of the mob if you want to replace it. This is dependent on the town, meaning if you want to replace all mobs in a town with one type of mob, you can use this query.
​

** Find the Location of a Specific Mob

USE SRO_VT_SHARD  
SELECT s.CodeName128, a.ContinentName  
FROM dbo.tab_refnest i  
INNER JOIN dbo._RefRegion a ON a.wRegionID = i.nRegionDBID  
INNER JOIN dbo.Tab_RefTactics x ON i.dwTacticsID = x.dwTacticsID  
INNER JOIN dbo._RefObjCommon s ON x.dwObjID = s.ID  
WHERE s.CodeName128 LIKE 'MOB_KK_YETI'

This query retrieves the location of the mob, for example, if it is in Oasis_Kingdom. If you want to replace all mobs in Oasis_Kingdom with another mob of your choice, use the next query.​

** Replace All Mobs in a Specific Town with Another Mob

USE SRO_VT_SHARD  
UPDATE x SET x.dwObjID = [COLOR="Red"]NEW_MOB_ID_HERE [/COLOR] 
FROM dbo.tab_refnest i  
INNER JOIN dbo._RefRegion a ON a.wRegionID = i.nRegionDBID  
INNER JOIN dbo.Tab_RefTactics x ON i.dwTacticsID = x.dwTacticsID  
INNER JOIN dbo._RefObjCommon s ON x.dwObjID = s.ID  
WHERE a.ContinentName LIKE 'TOWN_NAME_HERE'

You can get the town name from _RefRegionBindAssocServer or _RefRegion.​

** Increase the Number of Mobs in a Specific Town

UPDATE i SET i.dwMaxTotalCount = 4  
FROM dbo.tab_refnest i  
INNER JOIN dbo._RefRegion a ON a.wRegionID = i.nRegionDBID  
WHERE a.ContinentName LIKE 'ARABIA_FIELD_02'

This query increases the number of mobs in a specific town.
​

** Delete Specific Mobs from the Game

USE SRO_VT_SHARD  
DELETE i  
FROM dbo.tab_refnest i  
INNER JOIN dbo.Tab_RefTactics x ON i.dwTacticsID = x.dwTacticsID  
INNER JOIN dbo._RefObjCommon s ON x.dwObjID = s.ID  
WHERE s.CodeName128 LIKE 'MOB_'

This query deletes specific mobs from the game.

Copyright © Kabloz™. Do not copy to other forums under your name.
​