Template:Recipes
This template is used to display a list of items, and their crafting requirements / deconstruction yields.
Syntax
{{ Recipes | fabricator OR medicalfabricator OR deconstructor | width = <customwidth> (default 70) | everything = yes | material = <Custom Material> | exclude = <Term to exclude>}}
everything | If this is set to yes (or any non-null value), then all the items are displayed. This is meant to be used on the main fabricator/deconstructor pages for example. For individual pages, this parameter shouldn't be specified. |
fabricator | displays the list of items that can be fabricated in the standard fabricator with the current item.
|
medicalfabricator | displays the list of items that can be fabricated in the medical fabricator with the current item.
|
deconstructor | displays the list of items that can be deconstructed into the current item, but can't be crafted using the current item.
|
material | sets a custom material to be listed. If omitted, it will default to the page name. Note that all items which have this term in their name will be listed, so the "exclude" parameter may be necessary as well. |
exclude | excludes a string from the query. This is useful in case the current item's name is also contained in another item's name, such as "Diving Suit" is contained in "Combat Diving Suit". |
exclude2 | same as above, useful if one exclusion isn't enough. |
Examples
In the following examples, "material" is always specified because it would otherwise default to the page name. On an item's page, it can be omitted.
{{Recipes|fabricator|material=Diving Suit}}
gives:
Crafting Materials | Crafting Talent, Skill, Time | Item | Deconstruction Time | Deconstruction Yield Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'HOLDS LIKE "%Hyperlink%" ORDER BY `cargo__Items`.`_pageID`,`cargo__Items`.`n...' at line 1
Function: CargoSQLQuery::run Query: SELECT `cargo__Items`.`_pageID` AS `cargo_backlink_page_id_Items`,`cargo__Items`.`name` AS `name`,`cargo__Items`.`icon` AS `icon`,`cargo__Items`.`fabricatormaterials` AS `fabricatormaterials`,`cargo__Items`.`fabricatortime` AS `fabricatortime`,`cargo__Items`.`fabricatorskill` AS `fabricatorskill`,`cargo__Items`.`fabricatorskill2` AS `fabricatorskill2`,`cargo__Items`.`fabricatorskilllevel` AS `fabricatorskilllevel`,`cargo__Items`.`fabricatorskilllevel2` AS `fabricatorskilllevel2`,`cargo__Items`.`fabricatormaterialsalt` AS `fabricatormaterialsalt`,`cargo__Items`.`fabricatortimealt` AS `fabricatortimealt`,`cargo__Items`.`fabricatorskilllevelalt` AS `fabricatorskilllevelalt`,`cargo__Items`.`deconstructormaterials` AS `deconstructormaterials`,`cargo__Items`.`deconstructortime` AS `deconstructortime`,`cargo__Items`.`talent` AS `talent` FROM `cargo__Items` WHERE `cargo__Items`.`fabricatormaterials` HOLDS LIKE "%Hyperlink%" ORDER BY `cargo__Items`.`_pageID`,`cargo__Items`.`name`,`cargo__Items`.`icon`,`cargo__Items`.`fabricatormaterials`,`cargo__Items`.`fabricatortime` LIMIT 100 |
---|
{{Recipes|deconstructor|material=Plastic|width=40}}
gives:
Crafting Materials | Crafting Talent, Skill, Time | Item | Deconstruction Time | Deconstruction Yield Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'HOLDS LIKE "%Hyperlink%" ORDER BY `cargo__Items`.`_pageID`,`cargo__Items`.`n...' at line 1
Function: CargoSQLQuery::run Query: SELECT `cargo__Items`.`_pageID` AS `cargo_backlink_page_id_Items`,`cargo__Items`.`name` AS `name`,`cargo__Items`.`icon` AS `icon`,`cargo__Items`.`fabricatormaterials` AS `fabricatormaterials`,`cargo__Items`.`fabricatortime` AS `fabricatortime`,`cargo__Items`.`fabricatorskill` AS `fabricatorskill`,`cargo__Items`.`fabricatorskill2` AS `fabricatorskill2`,`cargo__Items`.`fabricatorskilllevel` AS `fabricatorskilllevel`,`cargo__Items`.`fabricatorskilllevel2` AS `fabricatorskilllevel2`,`cargo__Items`.`fabricatormaterialsalt` AS `fabricatormaterialsalt`,`cargo__Items`.`fabricatortimealt` AS `fabricatortimealt`,`cargo__Items`.`fabricatorskilllevelalt` AS `fabricatorskilllevelalt`,`cargo__Items`.`deconstructormaterials` AS `deconstructormaterials`,`cargo__Items`.`deconstructortime` AS `deconstructortime`,`cargo__Items`.`talent` AS `talent` FROM `cargo__Items` WHERE `cargo__Items`.`fabricatormaterials` HOLDS LIKE "%Hyperlink%" ORDER BY `cargo__Items`.`_pageID`,`cargo__Items`.`name`,`cargo__Items`.`icon`,`cargo__Items`.`fabricatormaterials`,`cargo__Items`.`fabricatortime` LIMIT 100 |
---|
{{Recipes|deconstructor|material=Titanium|width=40}}
gives:
Crafting Materials | Crafting Talent, Skill, Time | Item | Deconstruction Time | Deconstruction Yield Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'HOLDS LIKE "%Hyperlink%" ORDER BY `cargo__Items`.`_pageID`,`cargo__Items`.`n...' at line 1
Function: CargoSQLQuery::run Query: SELECT `cargo__Items`.`_pageID` AS `cargo_backlink_page_id_Items`,`cargo__Items`.`name` AS `name`,`cargo__Items`.`icon` AS `icon`,`cargo__Items`.`fabricatormaterials` AS `fabricatormaterials`,`cargo__Items`.`fabricatortime` AS `fabricatortime`,`cargo__Items`.`fabricatorskill` AS `fabricatorskill`,`cargo__Items`.`fabricatorskill2` AS `fabricatorskill2`,`cargo__Items`.`fabricatorskilllevel` AS `fabricatorskilllevel`,`cargo__Items`.`fabricatorskilllevel2` AS `fabricatorskilllevel2`,`cargo__Items`.`fabricatormaterialsalt` AS `fabricatormaterialsalt`,`cargo__Items`.`fabricatortimealt` AS `fabricatortimealt`,`cargo__Items`.`fabricatorskilllevelalt` AS `fabricatorskilllevelalt`,`cargo__Items`.`deconstructormaterials` AS `deconstructormaterials`,`cargo__Items`.`deconstructortime` AS `deconstructortime`,`cargo__Items`.`talent` AS `talent` FROM `cargo__Items` WHERE `cargo__Items`.`fabricatormaterials` HOLDS LIKE "%Hyperlink%" ORDER BY `cargo__Items`.`_pageID`,`cargo__Items`.`name`,`cargo__Items`.`icon`,`cargo__Items`.`fabricatormaterials`,`cargo__Items`.`fabricatortime` LIMIT 100 |
---|
{{Recipes|deconstructor|material=Titanium|exclude=Alloy|width=40}}
gives:
Crafting Materials | Crafting Talent, Skill, Time | Item | Deconstruction Time | Deconstruction Yield Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'HOLDS LIKE "%Hyperlink%" ORDER BY `cargo__Items`.`_pageID`,`cargo__Items`.`n...' at line 1
Function: CargoSQLQuery::run Query: SELECT `cargo__Items`.`_pageID` AS `cargo_backlink_page_id_Items`,`cargo__Items`.`name` AS `name`,`cargo__Items`.`icon` AS `icon`,`cargo__Items`.`fabricatormaterials` AS `fabricatormaterials`,`cargo__Items`.`fabricatortime` AS `fabricatortime`,`cargo__Items`.`fabricatorskill` AS `fabricatorskill`,`cargo__Items`.`fabricatorskill2` AS `fabricatorskill2`,`cargo__Items`.`fabricatorskilllevel` AS `fabricatorskilllevel`,`cargo__Items`.`fabricatorskilllevel2` AS `fabricatorskilllevel2`,`cargo__Items`.`fabricatormaterialsalt` AS `fabricatormaterialsalt`,`cargo__Items`.`fabricatortimealt` AS `fabricatortimealt`,`cargo__Items`.`fabricatorskilllevelalt` AS `fabricatorskilllevelalt`,`cargo__Items`.`deconstructormaterials` AS `deconstructormaterials`,`cargo__Items`.`deconstructortime` AS `deconstructortime`,`cargo__Items`.`talent` AS `talent` FROM `cargo__Items` WHERE `cargo__Items`.`fabricatormaterials` HOLDS LIKE "%Hyperlink%" ORDER BY `cargo__Items`.`_pageID`,`cargo__Items`.`name`,`cargo__Items`.`icon`,`cargo__Items`.`fabricatormaterials`,`cargo__Items`.`fabricatortime` LIMIT 100 |
---|
{{Recipes|deconstructor|material=Sodium|allowfab=1|width=40}}
gives:
Crafting Materials | Crafting Talent, Skill, Time | Item | Deconstruction Time | Deconstruction Yield Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'HOLDS LIKE "%Hyperlink%" ORDER BY `cargo__Items`.`_pageID`,`cargo__Items`.`n...' at line 1
Function: CargoSQLQuery::run Query: SELECT `cargo__Items`.`_pageID` AS `cargo_backlink_page_id_Items`,`cargo__Items`.`name` AS `name`,`cargo__Items`.`icon` AS `icon`,`cargo__Items`.`fabricatormaterials` AS `fabricatormaterials`,`cargo__Items`.`fabricatortime` AS `fabricatortime`,`cargo__Items`.`fabricatorskill` AS `fabricatorskill`,`cargo__Items`.`fabricatorskill2` AS `fabricatorskill2`,`cargo__Items`.`fabricatorskilllevel` AS `fabricatorskilllevel`,`cargo__Items`.`fabricatorskilllevel2` AS `fabricatorskilllevel2`,`cargo__Items`.`fabricatormaterialsalt` AS `fabricatormaterialsalt`,`cargo__Items`.`fabricatortimealt` AS `fabricatortimealt`,`cargo__Items`.`fabricatorskilllevelalt` AS `fabricatorskilllevelalt`,`cargo__Items`.`deconstructormaterials` AS `deconstructormaterials`,`cargo__Items`.`deconstructortime` AS `deconstructortime`,`cargo__Items`.`talent` AS `talent` FROM `cargo__Items` WHERE `cargo__Items`.`fabricatormaterials` HOLDS LIKE "%Hyperlink%" ORDER BY `cargo__Items`.`_pageID`,`cargo__Items`.`name`,`cargo__Items`.`icon`,`cargo__Items`.`fabricatormaterials`,`cargo__Items`.`fabricatortime` LIMIT 100 |
---|
The above documentation is transcluded from Template:Recipes/doc. (edit | history)