Difference between revisions of "Poison Table"
From Titan's Teeth
Dicemonger (talk | contribs) |
Dicemonger (talk | contribs) |
||
| Line 5: | Line 5: | ||
</noinclude><!-- | </noinclude><!-- | ||
| − | -->{{#cargo_query:tables=Equipment | + | -->{{#cargo_query:tables=Equipment, Poison |
|join on=Poison.Name = Equipment.Name | |join on=Poison.Name = Equipment.Name | ||
|where=Category="Poison" {{#ifeq:{{{hidden|}}}|yes||AND Hidden is NULL}} | |where=Category="Poison" {{#ifeq:{{{hidden|}}}|yes||AND Hidden is NULL}} | ||
Revision as of 18:20, 9 January 2020
All lower-case
- 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`,`PoisonType` AS `Type`,CONCAT(FortDC, RefDC, WillDC) AS `DC`,`Onset` AS `Onset`,`Frequency` AS `Frequency`,`ShortEffect` AS `Effect`,`Cure` AS `Cure`,CONCAT( CostGp, ' gp' ) AS `Price` FROM `cargo__Poison` LEFT OUTER JOIN `cargo__Equipment` ON ((`cargo__Poison`.`Name`=`cargo__Equipment`.`Name`)) WHERE Category="Poison" AND Hidden is NULL ORDER BY `Name` LIMIT 100 Function: CargoSQLQuery::run Error: 1052 Column '_pageName' in field list is ambiguous (localhost)