Template:GetMobDrops: Difference between revisions

From HorizonXI Wiki
No edit summary
No edit summary
Line 29: Line 29:
}}
}}
{{#get_db_data:db = droprates
{{#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}}}}}
  | parameters={{{mob name|{{PAGENAMEE}}}}}
  | data=zone=zoneName,item=itemName,rate=itemRate
  | data=zone=zoneName,item=itemName,rate=itemRate

Revision as of 07:36, 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
[[{{{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