Difference between revisions of "Poison Table"
From Titan's Teeth
Dicemonger (talk | contribs) |
Dicemonger (talk | contribs) |
||
| Line 9: | Line 9: | ||
|where=Category="Poison" {{#ifeq:{{{hidden|}}}|yes||AND Hidden is NULL}} | |where=Category="Poison" {{#ifeq:{{{hidden|}}}|yes||AND Hidden is NULL}} | ||
|order by=Name | |order by=Name | ||
| − | |fields=CONCAT( '[[', Equipment._pageName, '|', Name, ']]' ) = Item,PoisonType=Type,CONCAT(FortDC, RefDC, WillDC) = DC,Onset,Frequency,ShortEffect=Effect,Cure,CONCAT( CostGp, ' gp' ) = Price | + | |fields=CONCAT( '[[', Equipment._pageName, '|', Equipment.Name, ']]' ) = Item,PoisonType=Type,CONCAT(FortDC, RefDC, WillDC) = DC,Onset,Frequency,ShortEffect=Effect,Cure,CONCAT( CostGp, ' gp' ) = Price |
|format=table | |format=table | ||
}} | }} | ||
Revision as of 18:26, 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( '', `cargo__Equipment`.`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 'Name' in order clause is ambiguous (localhost)