Template:GetMobDrops: Difference between revisions
From HorizonXI Wiki
Starfox9507 (talk | contribs) No edit summary |
.mythicangel (talk | contribs) No edit summary |
||
| Line 20: | Line 20: | ||
{{!}}- | {{!}}- | ||
{{!}} [[{{{zone}}}]] {{!}}{{!}} {{{item}}} {{!}}{{!}} {{#expr:{{{rate}}} / 10}}% | {{!}} [[{{{zone}}}]] {{!}}{{!}} {{{item}}} {{!}}{{!}} {{#expr:{{{rate}}} / 10}}% | ||
}} |}</onlyinclude></includeonly> | |||
<onlyinclude><includeonly> | |||
{{#get_db_data:db = spawncount | |||
| parameters={{{mob name|{{PAGENAMEE}}}}} | |||
| data= count=mobcount, zone=zonename | |||
}} | |||
{{#get_db_data:db = droprates | |||
| from=spawncount tbn1, droprates tbn2 | |||
| join on=tbn1.zoneName = tbn2.zoneName | |||
| where=mobName={{PAGENAMEE}} | |||
| group by=zoneName | |||
| parameters={{{mob name|{{PAGENAMEE}}}}} | |||
| data=zone=zoneName,item=itemName,rate=itemRate | |||
}}<!-- | |||
-->{| class="mobs horizon-table table-xl" | |||
! Zone !! Drops !! Spawns{{#for_external_table:|<nowiki/> | |||
{{!}}- | |||
{{!}} {{{zone}}} {{!}}{{!}} {{{item}}} {{#expr:{{{rate}}} / 10}}% {{!}}{{!}} {{{count}}} | |||
}} |}</onlyinclude></includeonly> | }} |}</onlyinclude></includeonly> | ||
Revision as of 03:47, 21 September 2024
Usage
Work in progress...
Examples
{{GetMobDrops|mob name=Seeker_Bats}}
| zonename | mobcount |
|---|---|
| Qufim_Island | 13
|
| Ranguemont_Pass | 25
|
| Korroloka_Tunnel | 60
|
| Lower_Delkfutts_Tower | 27
|
| Ordelles_Caves | 19
|
| Maze_of_Shakhrami | 9 |
| zone | item | rate |
|---|---|---|
| Qufim_Island | bat_wing | 15%
|
| Ranguemont_Pass | bat_wing | 15%
|
| Ranguemont_Pass | bat_fang | 5%
|
| Korroloka_Tunnel | bat_wing | 15%
|
| Korroloka_Tunnel | vial_of_fiend_blood | 10%
|
| Korroloka_Tunnel | bat_fang | 5%
|
| Lower_Delkfutts_Tower | bat_wing | 15%
|
| Ordelles_Caves | bat_wing | 15%
|
| Maze_of_Shakhrami | bat_wing | 24% |
| Zone | Drops | Spawns |
|---|---|---|
| Qufim_Island | bat_wing 15% | 13
|
| Ranguemont_Pass | bat_wing 15% | 25
|
| Ranguemont_Pass | bat_fang 5% | 60
|
| Korroloka_Tunnel | bat_wing 15% | 27
|
| Korroloka_Tunnel | vial_of_fiend_blood 10% | 19
|
| Korroloka_Tunnel | bat_fang 5% | 9
|
| Lower_Delkfutts_Tower | bat_wing 15% |
|
| Ordelles_Caves | bat_wing 15% |
|
| Maze_of_Shakhrami | bat_wing 24% |
