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=Poison.Name | |order by=Poison.Name | ||
| − | |fields=CONCAT( '[[', Poison._pageName, '|', Poison.Name, ']]' ) = Item,PoisonType=Type,CONCAT( | + | |fields=CONCAT( '[[', Poison._pageName, '|', Poison.Name, ']]' ) = Item,PoisonType=Type,CONCAT(ISNULL(FortDC,''), ISNULL(RefDC,''), ISNULL(WillDC,'')) = DC,Onset,Frequency,ShortEffect=Effect,Cure,CONCAT( CostGp, ' gp' ) = Price |
|format=table | |format=table | ||
}} | }} | ||
Revision as of 18:33, 9 January 2020
All lower-case
- hidden (optional) = If yes, then hidden equipment is shown
Error: The SQL function "ISNULL()" is not allowed.