Difference between revisions of "Equipment DescList"
From Titan's Teeth
Dicemonger (talk | contribs) |
Dicemonger (talk | contribs) |
||
| Line 8: | Line 8: | ||
-->{{#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="}}"}}) {{#ifeq: {{{3|}}}|Yes| AND Hidden="Yes"| AND Hidden<>"Yes"}} | + | |where=({{#if: {{{2|}}}|(Category="{{#replace:{{{1}}}|,|" OR Category="}}") AND (SubCategory="{{#replace:{{{2}}}|,|" OR SubCategory="}}")|Category="{{#replace:{{{1}}}|,|" OR Category="}}"}}) {{#ifeq: {{{3|}}}|Yes| AND Hidden="Yes"| AND Hidden<>"Yes")}} |
|order by=Name | |order by=Name | ||
|fields=_pageName = Page,Name,Fluff,Description,Benefit,Note,Hidden | |fields=_pageName = Page,Name,Fluff,Description,Benefit,Note,Hidden | ||
Revision as of 00:51, 31 August 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)
- 3: Show Hidden? Yes (defaults No)
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `_pageName` AS `Page`,`Name` AS `Name`,`Fluff` AS `Fluff`,`Description` AS `Description`,`Benefit` AS `Benefit`,`Note` AS `Note`,`Hidden` AS `Hidden` FROM `cargo__Equipment` WHERE (Category="{{{1}}}") AND Hidden<>"Yes") 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 ') ORDER BY `Name` LIMIT 100' at line 1 (localhost)