Template:ITEM ALL DROPLISTS: Difference between revisions
Jump to navigation
Jump to search
Created page with "<noinclude> {{#template_params:itemName (label=Item Name)|mobName (label=Mob Name)}} {{#cargo_declare:_table=ITEM_ALL_DROPLISTS|itemName=Text|mobName=Text|}} </noinclude> <includeonly>{{#cargo_store:_table=ITEM_ALL_DROPLISTS}} {{#template_display:_format=sections}}</includeonly>" |
No edit summary |
||
| Line 1: | Line 1: | ||
{{#get_db_data: | |||
db=Derp | |||
|from=mob_droplist, mob_groups, item_basic, item_names | |||
|where=mob_groups.mg_name = REPLACE('{{PAGENAME}}', ' ', '_') | |||
AND mob_droplist.md_dropId = mob_groups.mg_dropid | |||
AND item_basic.ib_itemid = mob_droplist.md_itemId | |||
AND item_basic.ib_itemid = item_names.in_item_id | |||
|order by=mg_name, md_dropId, md_groupId, md_itemId | |||
|data= | |||
groupID=md_groupID, itemID=md_itemId, itemDisplayName=in_properFullName, itemSearchName=REPLACE(in_shortName,' ','_'), itemRate=ROUND(md_itemRate / 10, 1) | |||
}} | |||
{| class="wikitable" | |||
! scope="row" colspan="5" | Drops | |||
|- | |||
! Group ID !! Item ID !! BG Wiki !! FFXIAH !! Item Rate | |||
{{#for_external_table:| | |||
{{!}}- | |||
{{!}} {{{groupID}}} | |||
{{!}} {{{itemID}}} | |||
{{!}} [https://www.bg-wiki.com/ffxi/{{{itemSearchName|}}} {{{itemDisplayName}}}] | |||
{{!}} [https://www.ffxiah.com/item/{{{itemID|}}} {{ucfirst:{{{itemDisplayName}}}}}] | |||
{{!}} {{{itemRate}}}% | |||
}} | |||
|} | |||
{{#clear_external_data:}} | |||
<noinclude> | <noinclude> | ||
{{#template_params:itemName (label=Item Name)|mobName (label=Mob Name)}} | {{#template_params:itemName (label=Item Name)|mobName (label=Mob Name)}} | ||
Revision as of 15:40, 16 August 2023
Error: Incomplete information for this database ID Derp (type).
Error: Incomplete information for this database ID Derp (user/user file).
Error: Incomplete information for this database ID Derp (name).
Error: Incomplete information for this database ID Derp (server).
| Drops | ||||
|---|---|---|---|---|
| Group ID | Item ID | BG Wiki | FFXIAH | Item Rate |
{{#template_params:itemName (label=Item Name)|mobName (label=Mob Name)}}
This template defines the table "ITEM_ALL_DROPLISTS". This table has not been created yet.