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
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%