8,290
edits
(Add list of equipment by resistance) |
(add cooking resistances) |
||
Line 38: | Line 38: | ||
| where=IT.WornOn IS NOT NULL AND (PP.HeatResist IS NOT NULL OR PP.ColdResist IS NOT NULL OR PP.AcidResist IS NOT NULL OR PP.ElectricResist IS NOT NULL) | | where=IT.WornOn IS NOT NULL AND (PP.HeatResist IS NOT NULL OR PP.ColdResist IS NOT NULL OR PP.AcidResist IS NOT NULL OR PP.ElectricResist IS NOT NULL) | ||
| order by=TotalResistance DESC | | order by=TotalResistance DESC | ||
| format=table | |||
| limit=500 | |||
}} | |||
== Resistances Granted by Cooking Effects == | |||
[[cooking effects|Cooking]] with certain ingredients can grant temporary resistances. | |||
=== Basic Effects === | |||
{{#cargo_query: | |||
| tables=CookingEffects=CE,CookingEffects__UnitEffects=CEUE | |||
| join on=CE._ID=CEUE._rowID | |||
| fields= | |||
CE._pageName=Effect, | |||
CEUE._value=Basic Effect | |||
| where=CEUE._value LIKE '%Resist%' | |||
| group by=CE._pageName,CEUE._value | |||
| format=table | |||
}} | |||
=== Triggered Effects === | |||
{{#cargo_query: | |||
| tables=CookingEffects=CE,CookingEffects__TriggeredEffects=CETE | |||
| join on=CE._ID=CETE._rowID | |||
| fields= | |||
CE._pageName=Effect, | |||
CETE._value=Triggered Effect | |||
| where=CETE._value LIKE '%Resist%' | |||
| group by=CE._pageName,CETE._value | |||
| format=table | | format=table | ||
}} | }} | ||
[[Category:Mechanics]] | [[Category:Mechanics]] |