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>" |
mNo edit summary |
||
| (11 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
<noinclude> | <noinclude> | ||
This is the text displayed on the Template page | |||
</noinclude> | </noinclude> | ||
<includeonly>{{# | <includeonly> | ||
{{# | {{#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="6" | Drops | |||
|- | |||
! Group ID !! Item ID !! Caldera Wiki !! BG Wiki !! FFXIAH !! Item Rate | |||
{{#for_external_table:| | |||
{{!}}- | |||
{{!}} {{{groupID}}} | |||
{{!}} {{{itemID}}} | |||
{{!}} [[{{#createpageifnotex:{{{itemDisplayName}}}|The content of test page 1}}{{{itemDisplayName}}}]] | |||
{{!}} [https://www.bg-wiki.com/ffxi/{{{itemSearchName|}}} {{{itemDisplayName}}}] | |||
{{!}} [https://www.ffxiah.com/item/{{{itemID|}}} {{ucfirst:{{{itemDisplayName}}}}}] | |||
{{!}} {{{itemRate}}}% | |||
}} | |||
|} | |||
</includeonly> | |||
Latest revision as of 15:53, 16 August 2023
This is the text displayed on the Template page