Food: Difference between revisions
Jump to navigation
Jump to search
(Created page with "{{stub}} Food is a type of item that can be consumed or cooked with to satiate hunger or thirst. {{#cargo_query:table=Food,GeneralData|join on=Food._pageName=GeneralD...") |
m (Fix database error caused by CONCAT on List of Page field [CookEffect]) |
||
Line 2: | Line 2: | ||
Food is a type of item that can be consumed or cooked with to satiate [[hunger]] or [[thirst]]. | Food is a type of item that can be consumed or cooked with to satiate [[hunger]] or [[thirst]]. | ||
{{#cargo_query: | {{ #cargo_query: | ||
tables = Food, GeneralData | |||
|join on = Food._pageName = GeneralData._pageName | |||
|fields = CONCAT('[[File:', Image, '|20px]] [[',Food._pageName,']]') = Food, Hunger, Thirst, Description, CookEffect = Cooking Effect | |||
|where = Food._pageNamespace='0' | |||
|format = dynamic table | |||
|rows per page = 30 | |||
|details fields = Description }} | |||
<!-- TODO: Fix CookEffect formatting. Not sure how page lists are formatted since SQL functions do not work. --> |
Revision as of 12:48, 22 February 2020
This article is a stub. You can help Caves of Qud Wiki by expanding it. |
This article is a stub. You can help Caves of Qud Wiki by expanding it.
Food is a type of item that can be consumed or cooked with to satiate hunger or thirst.
Error 1052: Column 'Description' in field list is ambiguous (localhost)
Function: CargoSQLQuery::run Query: SELECT CONCAT('File:', Image, ' ',`Food`.`_pageName`,'') AS `Food`,`Hunger` AS `Hunger`,`Thirst` AS `Thirst`,`Description` AS `Description`,`CookEffect__full` AS `Cooking Effect` FROM `Food` LEFT OUTER JOIN `GeneralData` ON ((`Food`.`_pageName`=`GeneralData`.`_pageName`)) WHERE `Food`.`_pageNamespace`='0' ORDER BY CONCAT('File:', Image, ' ',`Food`.`_pageName`,''),`Hunger`,`Thirst`,`Description`,`Food`.`CookEffect__full` LIMIT 100