Difference between revisions of "Equipment Table Variable"
From Titan's Teeth
Dicemonger (talk | contribs) |
Dicemonger (talk | contribs) |
||
| Line 11: | Line 11: | ||
|where=Category="{{{category}}}" {{#if:{{{subcategory|}}}|AND SubCategory="{{{subcategory}}}"|}} {{#ifeq:{{{hidden|}}}|yes||AND Hidden is NULL}} | |where=Category="{{{category}}}" {{#if:{{{subcategory|}}}|AND SubCategory="{{{subcategory}}}"|}} {{#ifeq:{{{hidden|}}}|yes||AND Hidden is NULL}} | ||
|order by=Name | |order by=Name | ||
| − | |fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Item,Cost,Weight{{#ifeq:{{{craftDC|}}}|yes|,CraftDC = Craft DC}},Short | + | |fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Item,CONCAT( CostGp ' gp' ) = Cost,Weight{{#ifeq:{{{craftDC|}}}|yes|,CraftDC = Craft DC}},Short |
|format=table | |format=table | ||
}} | }} | ||
Revision as of 16:55, 9 January 2020
All lower-case
- category = Multiple categories can be added to the table with comma-separation (weapons,armor)
- subcategory (optional) = Multiple subcategories can be added to the table with comma-separation (camping,survival)
- craftDC (optional) = If yes, then show Craft DC in tables
- hidden (optional) = If yes, then hidden equipment is shown
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT CONCAT( '', Name, '' ) AS `Item`,CONCAT( CostGp ' gp' ) AS `Cost`,`Weight` AS `Weight`,`Short` AS `Short` FROM `cargo__Equipment` WHERE Category="{{{category}}}" AND Hidden is NULL ORDER BY `Name` LIMIT 100 Function: CargoSQLQuery::run Error: 1583 Incorrect parameters in the call to native function 'concat' (localhost)