Template:GetMobDrops: Difference between revisions
From HorizonXI Wiki
Starfox9507 (talk | contribs) (Created page with "<!-- SELECT mob_droplist.itemRate, mob_droplist.dropType, mob_droplist.groupId, mob_droplist.groupRate,zone_settings.name AS zoneName, item_basic.name AS itemName --> Work in progres... <includeonly><onlyinclude> {{#get_db_data:db = droprates | parameters={{PAGENAMEE}} | data=zone=zoneName,item=itemName,rate=itemRate }} {| class="wikitable" ! zone !! item !! rate{{#for_external_table:<nowiki/> {{!}}- {{!}} {{{zone}}} {{!}}{{!}} {{{item}}} {{!}}{{!}} {{{rate}}}...") |
.mythicangel (talk | contribs) No edit summary |
||
| (12 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
<includeonly><onlyinclude> | <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 | {{#get_db_data:db = droprates | ||
| parameters={{PAGENAMEE}} | | parameters={{{mob name|{{PAGENAMEE}}}}} | ||
| data=zone=zoneName,item=itemName,rate=itemRate | | data=zone=zoneName,item=itemName,rate=itemRate | ||
}}<!-- | |||
-->{| class="wikitable" | |||
! zone !! item !! rate{{#for_external_table:|<nowiki/> | |||
{{!}}- | |||
{{!}} [[{{{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> | |||
==Usage== | |||
Work in progress... | |||
===Examples=== | |||
<pre>{{GetMobDrops|mob name=Seeker_Bats}}</pre> | |||
{{GetMobDrops|mob name=Seeker_Bats}} | |||
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% |
