Template:Item icon: Difference between revisions
(Section it better. Move copy-ready templates up) |
(Fix display and sql) |
||
| Line 1: | Line 1: | ||
<includeonly><onlyinclude> | <includeonly><onlyinclude>{{#cargo_query: | ||
tables=item_icon | tables=item_icon | ||
|fields=icon | |fields=icon | ||
|where=item_icon.name={{{name}}} | |where=item_icon.name='{{{name}}}' | ||
|limit=1 | |limit=1 | ||
| | |default= | ||
| | |template=ItemIcon_Internal | ||
}} {{#if:{{{ | }}{{#if:{{{showname|}}}|[[{{{name}}}]] }}</onlyinclude></includeonly><noinclude> | ||
<!-- Cargo table definition --> | <!-- Cargo table definition --> | ||
Revision as of 07:07, 5 September 2023
This template defines the table "item_icon". View table.
This template fetches an icon for an item using Cargo. It also declares the Cargo table for the "item_icon" table that stores this information. The information is uploaded using the standard item descriptions.
Usage:{{ItemIcon
|name=the name of the icon page
|size=(optional) the size of the icon
|show_name=(optional) Whether to show the name. Any value will show the name of the item as a link. Omit to hide it.
}}
Templates
Copy-ready template (no item name): {{ItemIcon|name=}}
Copy-ready template (with item name): {{ItemIcon|name=|show_name=true}}
Examples
Function: CargoSQLQuery::run Query: SELECT `cargo__item_icon`.`_pageID` AS `cargo_backlink_page_id_item_icon`,`icon` AS `icon` FROM `cargo__item_icon` WHERE `cargo__item_icon`.`name`='Potion of Healing' ORDER BY `cargo__item_icon`.`_pageID`,`icon` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `cargo__item_icon`.`_pageID` AS `cargo_backlink_page_id_item_icon`,`icon` AS `icon` FROM `cargo__item_icon` WHERE `cargo__item_icon`.`name`='Potion of Healing' ORDER BY `cargo__item_icon`.`_pageID`,`icon` LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `cargo__item_icon`.`_pageID` AS `cargo_backlink_page_id_item_icon`,`icon` AS `icon` FROM `cargo__item_icon` WHERE `cargo__item_icon`.`name`='Potion of Healing' ORDER BY `cargo__item_icon`.`_pageID`,`icon` LIMIT 100