Complete Query for Modifying Monsters in vSRO

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

Code:

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

Code:

USE SRO_VT_SHARD  
UPDATE x SET x.dwObjID = 'NEW_MOB_ID_HERE'
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' AND i.dwMaxTotalCount <> 1 AND s.CodeName128 NOT LIKE '%god%'

You can get the town name from _RefRegionBindAssocServer or _RefRegion.

** Increase the Number of Mobs in a Specific Town

Code:

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' AND i.dwMaxTotalCount <> 1

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

** Delete Specific Mobs from the Game

Code:

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.

How to Get All Monsters by World ID

Description:
This SQL query is used to retrieve all monsters associated with a specific game world in database, filtered by GameWorldID.

Note:
This thread will be updated occasionally with new queries and insights.

Query:

Code:

SELECT DISTINCT k.*
FROM dbo.tab_refhive i
INNER JOIN dbo.tab_refnest a ON a.dwHiveID = i.dwHiveID
INNER JOIN dbo.Tab_RefTactics x ON a.dwTacticsID = x.dwTacticsID
INNER JOIN dbo._RefObjCommon k ON x.dwObjID = k.ID
WHERE i.GameWorldID = 86 AND k.Service = 1