Template:GetMobDrops: Difference between revisions
imported>Starfox9507 No edit summary |
imported>.mythicangel 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}}
Error: Incomplete information for this database ID spawncount (type).
Error: Incomplete information for this database ID spawncount (user/user file).
Error: Incomplete information for this database ID spawncount (name).
Error: Incomplete information for this database ID spawncount (server).
Error: No "from / join on" parameter specified.{| class="wikitable"
! zonename !! mobcount
|}
Error: Incomplete information for this database ID droprates (type).
Error: Incomplete information for this database ID droprates (user/user file).
Error: Incomplete information for this database ID droprates (name).
Error: Incomplete information for this database ID droprates (server).
Error: No "from / join on" parameter specified.{| class="wikitable"
! zone !! item !! rate |}
Error: Incomplete information for this database ID spawncount (type).
Error: Incomplete information for this database ID spawncount (user/user file).
Error: Incomplete information for this database ID spawncount (name).
Error: Incomplete information for this database ID spawncount (server).
Error: No "from / join on" parameter specified.
Error: Incomplete information for this database ID droprates (type).
Error: Incomplete information for this database ID droprates (user/user file).
Error: Incomplete information for this database ID droprates (name).
Error: Incomplete information for this database ID droprates (server).{| class="mobs horizon-table table-xl"
! Zone !! Drops !! Spawns |}
