Food: Difference between revisions

Food (view source)

143 bytes added , 12:48, 22 February 2020

m

Fix database error caused by CONCAT on List of Page field [CookEffect]

99

edits

@@ Line 2: / Line 2: @@
 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=GeneralData._pageName|fields=CONCAT('[[File:',Image,'|20px]] [[',Food._pageName,']]')=Food,Hunger,Thirst,Description,CONCAT('[[',CookEffect,' (cooking effect)]]')=Cooking Effect|where=Food._pageNamespace='0'|format=dynamic table|rows per page = 30|details fields=Description}}
+{{  #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. -->