Template:GetMobDrops: Difference between revisions
imported>Starfox9507 Created page with "<!-- SELECT mob_droplist.itemRate, mob_droplist.dropType, mob_droplist.groupId, mob_droplist.groupRate,zone_settings.name AS zoneName, item_basic.name AS itemName --> Work in progres... <includeonly><onlyinclude> {{#get_db_data:db = droprates | parameters={{PAGENAMEE}} | data=zone=zoneName,item=itemName,rate=itemRate }} {| class="wikitable" ! zone !! item !! rate{{#for_external_table:<nowiki/> {{!}}- {{!}} {{{zone}}} {{!}}{{!}} {{{item}}} {{!}}{{!}} {{{rate}}}..." |
imported>.mythicangel No edit summary |
||
| (16 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| ⚫ | |||
SELECT mob_droplist.itemRate, mob_droplist.dropType, mob_droplist.groupId, mob_droplist.groupRate,zone_settings.name AS zoneName, item_basic.name AS itemName |
|||
| ⚫ | |||
| ⚫ | |||
<includeonly><onlyinclude> |
<includeonly><onlyinclude> |
||
{{#get_db_data:db = spawncount |
|||
| parameters={{{mob name|{{PAGENAMEE}}}}} |
|||
| data= mobcount=mobcount, zonename=zonename |
|||
}}<!-- |
|||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
{{#get_db_data:db = droprates |
{{#get_db_data:db = droprates |
||
| parameters={{PAGENAMEE}} |
| parameters={{{mob name|{{PAGENAMEE}}}}} |
||
| data=zone=zoneName,item=itemName,rate=itemRate |
| data=zone=zoneName,item=itemName,rate=itemRate |
||
}}<!-- |
|||
-->{| class="wikitable" |
|||
! zone !! item !! rate{{#for_external_table:|<nowiki/> |
|||
{{!}}- |
|||
{{!}} [[{{{zone}}}]] {{!}}{{!}} {{{item}}} {{!}}{{!}} {{#expr:{{{rate}}} / 10}}% |
|||
| ⚫ | |||
<!--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, zoneSpawn=zonename |
|||
}} |
}} |
||
{{#get_db_data:db = droprates |
|||
| parameters={{{mob name|{{PAGENAMEE}}}}} |
|||
| data=zoneDrop=zoneName,item=itemName,rate=itemRate |
|||
}}<!-- |
|||
-->{| class="mobs horizon-table table-xl" |
|||
! Zone !! Drops !! Spawns{{#for_external_table:|<nowiki/> |
|||
{{!}}- |
|||
{{!}} [[{{{zoneSpawn}}}]] {{!}}{{!}} [[{{{item}}}]] {{#expr:{{{rate}}} / 10}}% {{!}}{{!}} {{{count}}} |
|||
}} |}</onlyinclude></includeonly> |
|||
==Usage== |
|||
| ⚫ | |||
===Examples=== |
|||
<pre>{{GetMobDrops|mob name=Seeker_Bats}}</pre> |
|||
{{GetMobDrops|mob name=Seeker_Bats}} |
|||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
Latest revision as of 07:50, 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).
Error: No "from / join on" parameter specified.{| class="mobs horizon-table table-xl"
! Zone !! Drops !! Spawns |}
