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:
Result:
have fun
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
have fun
Attachments
You must be registered for see attachments list
Last edited: