Template:GetMobDrops: Difference between revisions
From HorizonXI Wiki
m (some table styling) |
.mythicangel (talk | contribs) No edit summary |
||
| (10 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
<includeonly><onlyinclude>{{#get_db_data:db = droprates | <includeonly><onlyinclude> | ||
{{#get_db_data:db = spawncount | |||
| parameters={{{mob name|{{PAGENAMEE}}}}} | |||
| data= mobcount=mobcount, zonename=zonename | |||
}}<!-- | |||
-->{| class="wikitable" | |||
! zonename !! mobcount{{#for_external_table:|<nowiki/> | |||
{{!}}- | |||
{{!}} {{{zonename}}} {{!}}{{!}} {{{mobcount}}} | |||
}} | |||
|} | |||
<!-- | |||
--><br> | |||
{{#get_db_data:db = droprates | |||
| parameters={{{mob name|{{PAGENAMEE}}}}} | | parameters={{{mob name|{{PAGENAMEE}}}}} | ||
| data=zone=zoneName,item=itemName,rate=itemRate | | data=zone=zoneName,item=itemName,rate=itemRate | ||
}}<!-- | }}<!-- | ||
-->{| class=" | -->{| class="wikitable" | ||
! zone !! item !! rate{{#for_external_table:<nowiki/> | ! zone !! item !! rate{{#for_external_table:|<nowiki/> | ||
{{!}}- | {{!}}- | ||
{{!}} [[{{{zone}}}]] {{!}}{{!}} {{{item}}} {{!}}{{!}} {{{rate}}} | {{!}} [[{{{zone}}}]] {{!}}{{!}} {{{item}}} {{!}}{{!}} {{#expr:{{{rate}}} / 10}}% | ||
}} |}</onlyinclude></includeonly> | |||
<onlyinclude><includeonly> | |||
{{#get_db_data:db = spawncount | |||
| parameters={{{mob name|{{PAGENAMEE}}}}} | |||
| data= count=mobcount, zone=zonename | |||
}} | }} | ||
|}</onlyinclude></includeonly> | {{#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> | |||
==Usage== | ==Usage== | ||
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% |
