Properties: Difference between revisions
Jump to navigation
Jump to search
(Add queries for EMP-sensitive things) |
mNo edit summary |
||
Line 33: | Line 33: | ||
| fields= | | fields= | ||
CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Object | CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Object | ||
| where=EI.Info LIKE '%EMP Sensitive,,,%' AND GD._pageNamespace = 0 AND GD.Categories = 'Furniture' | | where=EI.Info LIKE '%EMP Sensitive,,,%' AND GD._pageNamespace = 0 AND (GD.Categories = 'Furniture' OR GD.Categories = 'Chairs') | ||
| format=ul | |||
| order by=GD._pageName | |||
}} | |||
==== EMP-Sensitive Walls ==== | |||
{{#cargo_query: | |||
| tables=GeneralData=GD,ExtraInfo=EI | |||
| join on=GD.JoinKey=EI.JoinKey | |||
| fields= | |||
CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Object | |||
| where=EI.Info LIKE '%EMP Sensitive,,,%' AND GD._pageNamespace = 0 AND (GD.Categories = 'Walls' OR GD.Categories = 'Wall Traps') | |||
| format=ul | | format=ul | ||
| order by=GD._pageName | | order by=GD._pageName | ||
Line 56: | Line 66: | ||
CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Object | CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Object | ||
| where=EI.Info LIKE '%EMP Sensitive,,,%' AND GD._pageNamespace = 0 AND (GD.Categories = 'Rifles' OR GD.Categories = 'Pistols' OR GD.Categories = 'Bows' OR GD.Categories = 'Heavy Weapons' OR GD.Categories = 'Thrown Weapons' OR GD.ObjectID = 'Point-Defense Drone') | | where=EI.Info LIKE '%EMP Sensitive,,,%' AND GD._pageNamespace = 0 AND (GD.Categories = 'Rifles' OR GD.Categories = 'Pistols' OR GD.Categories = 'Bows' OR GD.Categories = 'Heavy Weapons' OR GD.Categories = 'Thrown Weapons' OR GD.ObjectID = 'Point-Defense Drone') | ||
| format=ul | | format=ul | ||
| order by=GD._pageName | | order by=GD._pageName | ||
Line 86: | Line 84: | ||
</div> | </div> | ||
<div style="margin-right: 2.5em;"> | <div style="margin-right: 2.5em;"> | ||
==== Other EMP-Sensitive Objects ==== | ==== Other EMP-Sensitive Equipment/Objects ==== | ||
{{#cargo_query: | {{#cargo_query: | ||
| tables=GeneralData=GD,ExtraInfo=EI | | tables=GeneralData=GD,ExtraInfo=EI,CreatureFactions=CF | ||
| join on=GD.JoinKey=EI | | join on=GD.JoinKey=EI.JoinKey,GD.ObjectID=CF.ObjectID | ||
| fields= | | fields= | ||
CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Object | CONCAT('{{((}}favilink id{{!}}',CONCAT(GD.ObjectID),'{{))}}')=Object | ||
| where=EI.Info LIKE '%EMP Sensitive,,,%' AND GD._pageNamespace = 0 AND CF.Value | | where=EI.Info LIKE '%EMP Sensitive,,,%' AND GD._pageNamespace = 0 AND CF.Value IS NULL AND (GD.Categories <> 'Melee Weapons' AND GD.Categories <> 'Axes' AND GD.Categories <> 'Long Blades' AND GD.Categories <> 'Short Blades' AND GD.Categories <> 'Cudgels' AND GD.Categories <> 'Rifles' AND GD.Categories <> 'Pistols' AND GD.Categories <> 'Bows' AND GD.Categories <> 'Heavy Weapons' AND GD.Categories <> 'Thrown Weapons' AND GD.ObjectID <> 'Point-Defense Drone' AND GD.Categories <> 'Furniture' AND GD.Categories <> 'Chairs' AND GD.Categories <> 'Walls' AND GD.Categories <> 'Wall Traps') | ||
| format=ul | | format=ul | ||
| order by= | | order by=GD._pageName | ||
}} | }} | ||
</div> | </div> |