1 Attachment(s)
[vSRO] Counting Total Monster Spawns Categorized by Level
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) -- Only select Regular and Elite, add 3,8 for uniques
AND f.ContinentName NOT LIKE 'GOD_TOGUI' -- Not including FGW monsters
AND (d.[Service] = 1 AND d.Codename128 LIKE 'MOB_%' AND d.Codename128 NOT LIKE 'MOB_GOD_%') -- Not including FGW monsters
GROUP BY d.CodeName128, e.Lvl, d.Rarity ORDER BY e.Lvl ASC
Result:
Attachment 152327
have fun ;)
Re: [vSRO] Counting Total Monster Spawns Categorized by Level
Re: [vSRO] Counting Total Monster Spawns Categorized by Level
Quote:
Originally Posted by
jaiker10
Db sro_vt_shard ?
yes, because it needs to query the tables in the shard db to find the values.