[vSRO] Counting Total Monster Spawns Categorized by Level

Results 1 to 3 of 3
  1. #1
    Don't touch my Nutella! Witchy Moo is offline
    True MemberRank
    Aug 2013 Join Date
    SingaporeLocation
    209Posts

    [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:
    Click image for larger version. 

Name:	total-monster.jpg 
Views:	192 
Size:	63.7 KB 
ID:	152327
    have fun ;)
    Last edited by Witchy Moo; 23-06-15 at 08:12 PM.


  2. #2
    Newbie jaiker10 is offline
    MemberRank
    May 2018 Join Date
    1Posts

    Re: [vSRO] Counting Total Monster Spawns Categorized by Level

    Db sro_vt_shard ?

  3. #3
    Moderator Blacksheep25 is offline
    ModeratorRank
    Jan 2009 Join Date
    AustraliaLocation
    703Posts

    Re: [vSRO] Counting Total Monster Spawns Categorized by Level

    Quote Originally Posted by jaiker10 View Post
    Db sro_vt_shard ?
    yes, because it needs to query the tables in the shard db to find the values.
    [Silkroad Online * Section Moderator]
    General Blacksheep25

    Level: 125

    “Most people quit because they look how far they have to go, not how far they have come"



Advertisement