298
edits
Light source: Difference between revisions
Fix cargo query errors
m (excerpt note) |
(Fix cargo query errors) |
||
| Line 14: | Line 14: | ||
<div style="margin-right: 2.5em;"> | <div style="margin-right: 2.5em;"> | ||
=== Equipment and Objects === | === Equipment and Objects === | ||
{{#cargo_query:tables=PhysicalProperties=PP | {{#cargo_query: | ||
tables=PhysicalProperties=PP, GeneralData=GD, CreatureFactions=CF | |||
|fields=CONCAT('{{((}}favilink page{{!}}',CONCAT(PP._pageName),'{{))}}')=Light Source,PP.LightRadius=Radius | |fields=CONCAT('{{((}}favilink page{{!}}',CONCAT(PP._pageName),'{{))}}')=Light Source,PP.LightRadius=Radius | ||
|where=PP.LightRadius IS NOT NULL AND PP.LightRadius > 0 AND PP._pageNamespace='0' AND CF.Value IS NULL | |where=PP.LightRadius IS NOT NULL AND PP.LightRadius > 0 AND PP._pageNamespace='0' AND CF.Value IS NULL | ||
|join on=PP.JoinKey = GD.JoinKey, GD.ObjectID = CF.ObjectID | |||
|group by=GD.JoinKey | |||
|order by=PP.LightRadius DESC, GD._pageTitle ASC | |||
|format=table | |format=table | ||
}} | }} | ||
</div> | </div> | ||
| Line 26: | Line 27: | ||
<div style="margin-right: 2.5em;"> | <div style="margin-right: 2.5em;"> | ||
=== Lanterned Helmets === | === Lanterned Helmets === | ||
{{#cargo_query:table=ItemsTable=IT,GeneralData=GD|join on=IT.JoinKey=GD.JoinKey|fields=CONCAT('{{(}}favilink{{!}}', PlainName, '{{!}}prefix:&ylant&Ye&Wr&Yn&yed{{)}}')=Item, FLOOR(1 + Tier)= Light Radius|where=GD.ParentObject WITHIN 'BaseHelmet' AND GD._pageNamespace = '0'|order by = Light Radius DESC}} | {{#cargo_query:table=ItemsTable=IT,GeneralData=GD | ||
|join on=IT.JoinKey=GD.JoinKey | |||
|fields=CONCAT('{{(}}favilink{{!}}', PlainName, '{{!}}prefix:&ylant&Ye&Wr&Yn&yed{{)}}')=Item, FLOOR(1 + Tier)= Light Radius | |||
|where=GD.ParentObject WITHIN 'BaseHelmet' AND GD._pageNamespace = '0' | |||
|order by = Light Radius DESC | |||
}} | |||
=== Other Lanterned Objects === | === Other Lanterned Objects === | ||
{{#cargo_query:table=ItemsTable=IT,GeneralData=GD|join on=IT.JoinKey=GD.JoinKey|fields=CONCAT('{{((}}favilink{{!}}', PlainName, '{{!}}prefix:&ylant&Ye&Wr&Yn&yed{{)}}')=Item, FLOOR(1 + Tier)= Light Radius|where=GD.ObjectID = 'Strength Exo' AND GD._pageNamespace = '0'|order by = Light Radius DESC}} | {{#cargo_query:table=ItemsTable=IT,GeneralData=GD | ||
|join on=IT.JoinKey=GD.JoinKey | |||
|fields=CONCAT('{{((}}favilink{{!}}', PlainName, '{{!}}prefix:&ylant&Ye&Wr&Yn&yed{{)}}')=Item, FLOOR(1 + Tier)= Light Radius | |||
|where=GD.ObjectID = 'Strength Exo' AND GD._pageNamespace = '0' | |||
|order by = Light Radius DESC | |||
}} | |||
</div> | </div> | ||
<div style="margin-right: 2.5em;"> | <div style="margin-right: 2.5em;"> | ||
=== Creatures === | === Creatures === | ||
{{#cargo_query:tables=PhysicalProperties=PP | {{#cargo_query: | ||
tables=PhysicalProperties=PP, GeneralData=GD, CreatureFactions=CF | |||
|fields=CONCAT('{{((}}favilink page{{!}}',CONCAT(PP._pageName),'{{))}}')=Light Source,PP.LightRadius=Radius | |fields=CONCAT('{{((}}favilink page{{!}}',CONCAT(PP._pageName),'{{))}}')=Light Source,PP.LightRadius=Radius | ||
|where=PP.LightRadius IS NOT NULL AND PP.LightRadius > 0 AND PP._pageNamespace='0' AND CF.Value IS NOT NULL | |where=PP.LightRadius IS NOT NULL AND PP.LightRadius > 0 AND PP._pageNamespace='0' AND CF.Value IS NOT NULL | ||
|join on=PP.JoinKey = GD.JoinKey, GD.ObjectID = CF.ObjectID | |||
|group by=GD.JoinKey | |||
|order by=PP.LightRadius DESC, GD._pageTitle ASC | |||
|format=table | |format=table | ||
}} | }} | ||
</div> | </div> | ||