Light source: Difference between revisions

704 bytes added ,  15:24, 1 October 2021
Update with lanterned modded items
(separate the query into objects & creatures)
(Update with lanterned modded items)
Line 19: Line 19:
|order by=PP.LightRadius DESC,GD._pageTitle
|order by=PP.LightRadius DESC,GD._pageTitle
}}
}}
</div>
<div style="margin-right: 2.5em;">
=== 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}}
=== 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}}
</div>
</div>