Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[vSRO] Counting Total Monster Spawns Categorized by Level

Experienced Elementalist
Joined
Aug 22, 2013
Messages
208
Reaction score
125
hey ;)

Here I'll share simple query about how to count total monster spawn categorized by their level, this should match total monster spawn you get when using gm command /worldstatus

This prolly useless to you but if you find it useful, feel free to develop it to match your needs ;)

Now the boring part:
Code:
/*
 * Count total monster spawn categorized by level
 * Witchy Moo, 20150622
 */
SELECT d.CodeName128 AS 'Monster Code', e.Lvl AS 'Level', SUM(a.dwMaxTotalCount) AS 'Max Spawn'
FROM Tab_RefNest a 
INNER JOIN Tab_RefTactics b ON a.dwTacticsID = b.dwTacticsID
JOIN Tab_RefHive c ON a.dwHiveID = c.dwHiveID
JOIN _RefObjCommon d ON b.dwObjID = d.ID
JOIN _RefObjChar e ON d.Link = e.ID
JOIN _RefRegion f ON a.nRegionDBID = f.wRegionID
WHERE d.Rarity IN (0,6)    [COLOR=#008000]-- Only select Regular and Elite, add 3,8 for uniques[/COLOR]
AND f.ContinentName NOT LIKE 'GOD_TOGUI'    [COLOR=#008000]-- Not including FGW monsters[/COLOR]
AND (d.[Service] = 1 AND d.Codename128 LIKE 'MOB_%' AND d.Codename128 NOT LIKE 'MOB_GOD_%')   [COLOR=#008000]-- Not including FGW monsters[/COLOR]
GROUP BY d.CodeName128, e.Lvl, d.Rarity ORDER BY e.Lvl ASC
Result:
total-monster - [vSRO] Counting Total Monster Spawns Categorized by Level - RaGEZONE Forums
have fun ;)
 

Attachments

You must be registered for see attachments list
Last edited:
Back
Top