Template:GetMobDrops: Difference between revisions

Latest revision as of 07:50, 21 September 2024

Work in progress...

{{GetMobDrops|mob name=Seeker_Bats}}

@@ Line 22: / Line 22: @@
 }} |}</onlyinclude></includeonly>
+<!--This would need a while loop on the item from droprates to combine them into the zone name from spawncount. -->
 <onlyinclude><includeonly>
 {{#get_db_data:db = spawncount
   | parameters={{{mob name|{{PAGENAMEE}}}}}
-  | data= count=mobcount, zone=zonename
+  | data= count=mobcount, zoneSpawn=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
+  | data=zoneDrop=zoneName,item=itemName,rate=itemRate
 }}<!--
 -->{| class="mobs horizon-table table-xl"
 ! Zone !! Drops !! Spawns{{#for_external_table:|<nowiki/>
 {{!}}-
-{{!}} {{{zone}}} {{!}}{{!}} {{{item}}} {{#expr:{{{rate}}} / 10}}% {{!}}{{!}} {{{count}}}
+{{!}} [[{{{zoneSpawn}}}]] {{!}}{{!}} [[{{{item}}}]] {{#expr:{{{rate}}} / 10}}% {{!}}{{!}} {{{count}}}
 }} |}</onlyinclude></includeonly>