Difference between revisions of "Equipment Table"
From Titan's Teeth
Dicemonger (talk | contribs) |
Dicemonger (talk | contribs) |
||
| Line 7: | Line 7: | ||
-->{{#cargo_query:tables=Equipment | -->{{#cargo_query:tables=Equipment | ||
| − | |where={{#if: {{{2|}}}|(Category="{{#replace:{{{1}}}|,|" OR Category="}}") AND (SubCategory="{{#replace:{{{2}}}|,|" OR SubCategory="}}")|Category="{{#replace:{{{1}}}|,|" OR Category="}}"}} | + | |where={{#if: {{{2|}}}|(Category="{{#replace:{{{1}}}|,|" OR Category="}}") AND (SubCategory="{{#replace:{{{2}}}|,|" OR SubCategory="}}")|Category="{{#replace:{{{1}}}|,|" OR Category="}}"}} AND Hidden == 0 |
|order by=Name | |order by=Name | ||
|fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Item,Cost,Weight,Short | |fields=CONCAT( '[[', _pageName, '|', Name, ']]' ) = Item,Cost,Weight,Short | ||
|format=table | |format=table | ||
}} | }} | ||
Revision as of 16:07, 9 January 2020
All lower-case
- 1: category. Multiple categories can be added to the table with comma-separation (weapons,armor)
- 2: subcategory (optional). Multiple subcategories can be added to the table with comma-separation (camping,survival)
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`,`Cost` AS `Cost`,`Weight` AS `Weight`,`Short` AS `Short` FROM `cargo__Equipment` WHERE Category="{{{1}}}" AND Hidden == 0 ORDER BY `Name` LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '== 0 ORDER BY `Name` LIMIT 100' at line 1 (localhost)