8,290
edits
(add cooking resistances) |
(Improved queries with ingredients) |
||
Line 47: | Line 47: | ||
=== Basic Effects === | === Basic Effects === | ||
{{#cargo_query: | {{#cargo_query: | ||
| tables=CookingEffects=CE,CookingEffects__UnitEffects=CEUE | | tables=CookingEffects=CE,CookingEffects__UnitEffects=CEUE,Liquids__CookEffect=LCE,Liquids=L,Food__CookEffect=FCE,Food=F | ||
| join on=CE._ID=CEUE._rowID | | join on=CE._ID=CEUE._rowID,CE.PlainName=LCE._value,LCE._rowID=L._ID,CE.PlainName=FCE._value,FCE._rowID=F._ID | ||
| fields= | | fields= | ||
CONCAT( | |||
CEUE._value= | '{{(}}favilink id{{!}}', | ||
CASE WHEN L.ObjectID IS NOT NULL | |||
THEN L.ObjectID | |||
ELSE F.ObjectID | |||
END, | |||
'{{)}}' | |||
)=Ingredient, | |||
CEUE._value=Cooking Effect, | |||
CE._pageName=Effect Category | |||
| where=CEUE._value LIKE '%Resist%' | | where=CEUE._value LIKE '%Resist%' | ||
| format=table | | format=table | ||
}} | }} | ||
Line 59: | Line 66: | ||
=== Triggered Effects === | === Triggered Effects === | ||
{{#cargo_query: | {{#cargo_query: | ||
| tables=CookingEffects=CE,CookingEffects__TriggeredEffects=CETE | | tables=CookingEffects=CE,CookingEffects__TriggeredEffects=CETE,Liquids__CookEffect=LCE,Liquids=L,Food__CookEffect=FCE,Food=F | ||
| join on=CE._ID=CETE._rowID | | join on=CE._ID=CETE._rowID,CE.PlainName=LCE._value,LCE._rowID=L._ID,CE.PlainName=FCE._value,FCE._rowID=F._ID | ||
| fields= | | fields= | ||
CONCAT( | |||
CETE._value= | '{{(}}favilink id{{!}}', | ||
CASE WHEN L.ObjectID IS NOT NULL | |||
THEN L.ObjectID | |||
ELSE F.ObjectID | |||
END, | |||
'{{)}}' | |||
)=Ingredient, | |||
CETE._value=Cooking Effect, | |||
CE._pageName=Effect Category | |||
| where=CETE._value LIKE '%Resist%' | | where=CETE._value LIKE '%Resist%' | ||
| format=table | | format=table | ||
}} | }} | ||
[[Category:Mechanics]] | [[Category:Mechanics]] |