Food: Difference between revisions

27 bytes removed ,  13:57, 22 February 2020
m
Fix CookEffect formatting
m (Fix database error caused by CONCAT on List of Page field [CookEffect])
m (Fix CookEffect formatting)
Line 3: Line 3:


{{  #cargo_query:
{{  #cargo_query:
     tables = Food, GeneralData
     tables = Food, Food__CookEffect, GeneralData
     |join on = Food._pageName = GeneralData._pageName
     |join on = Food._pageName = GeneralData._pageName, Food._ID = Food__CookEffect._rowID
     |fields = CONCAT('[[File:', Image, '|20px]] [[',Food._pageName,']]') = Food, Hunger, Thirst, Description, CookEffect = Cooking Effect
     |fields = CONCAT('[[File:', Image, '|20px]] [[',Food._pageName,']]') = Food, Hunger, Thirst, Description, CONCAT('[[', Food__CookEffect._value, ']]') = Cooking Effect
     |where = Food._pageNamespace='0'
     |where = Food._pageNamespace='0'
     |format = dynamic table
     |format = dynamic table
     |rows per page = 30
     |rows per page = 30
     |details fields = Description }}
     |details fields = Description }}
<!-- TODO: Fix CookEffect formatting. Not sure how page lists are formatted since SQL functions do not work. -->