Template:GetMobDrops: Difference between revisions

Revision as of 03:47, 21 September 2024

Work in progress...

{{GetMobDrops|mob name=Seeker_Bats}}

zone	item	rate
[[{{{zone}}}]]	{{{item}}}	Expression error: Unrecognized punctuation character "{".%
[[{{{zone}}}]]	{{{item}}}	Expression error: Unrecognized punctuation character "{".%
[[{{{zone}}}]]	{{{item}}}	Expression error: Unrecognized punctuation character "{".%
[[{{{zone}}}]]	{{{item}}}	Expression error: Unrecognized punctuation character "{".%
[[{{{zone}}}]]	{{{item}}}	Expression error: Unrecognized punctuation character "{".%
[[{{{zone}}}]]	{{{item}}}	Expression error: Unrecognized punctuation character "{".%

Zone	Drops	Spawns
Qufim_Island	{{{item}}} Expression error: Unrecognized punctuation character "{".%	13
Ranguemont_Pass	{{{item}}} Expression error: Unrecognized punctuation character "{".%	25
Korroloka_Tunnel	{{{item}}} Expression error: Unrecognized punctuation character "{".%	60
Lower_Delkfutts_Tower	{{{item}}} Expression error: Unrecognized punctuation character "{".%	27
Ordelles_Caves	{{{item}}} Expression error: Unrecognized punctuation character "{".%	19
Maze_of_Shakhrami	{{{item}}} Expression error: Unrecognized punctuation character "{".%	9

@@ Line 20: / Line 20: @@
 {{!}}-
 {{!}} [[{{{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>