Light source: Difference between revisions
(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> | ||
Revision as of 15:24, 1 October 2021
A light source is any item that provides light, revealing objects and creatures in the tiles around it, which would otherwise be obscured in darkness. Tiles beyond their normal radius are not fully illuminated and will not be in color.
Light sources are particularly important for navigating underground or at night.
List of Light Sources
The following items and creatures emit light to the specified radius. Note that the radius extends outwards. For example, an item with a light radius of 1 lights up its own tile and the 4 tiles directly adjacent to it. In addition to these objects, helmets modded with the lanterned mod also act as light sources.
Equipment and Objects
Function: CargoSQLQuery::run Query: SELECT CONCAT('{{favilink page|',CONCAT(`PP`.`_pageName`),'}}') AS `Light Source`,`PP`.`LightRadius` AS `Radius` FROM `PhysicalProperties` `PP`,`CreatureFactions` `CF` LEFT OUTER JOIN `GeneralData` `GD` ON ((`PP`.`JoinKey`=`GD`.`JoinKey`) AND (`CF`.`ObjectID`=`GD`.`ObjectID`)) WHERE `PP`.`LightRadius` IS NOT NULL AND `PP`.`LightRadius` > 0 AND `PP`.`_pageNamespace`='0' AND `CF`.`Value` IS NULL GROUP BY `GD`.`JoinKey` ORDER BY `PP`.`LightRadius` DESC,`GD`.`_pageTitle` LIMIT 100
Lanterned Helmets
Other Lanterned Objects
Item | Light Radius |
---|---|
![]() |
7 |
Creatures
Function: CargoSQLQuery::run Query: SELECT CONCAT('{{favilink page|',CONCAT(`PP`.`_pageName`),'}}') AS `Light Source`,`PP`.`LightRadius` AS `Radius` FROM `PhysicalProperties` `PP`,`CreatureFactions` `CF` LEFT OUTER JOIN `GeneralData` `GD` ON ((`PP`.`JoinKey`=`GD`.`JoinKey`) AND (`CF`.`ObjectID`=`GD`.`ObjectID`)) WHERE `PP`.`LightRadius` IS NOT NULL AND `PP`.`LightRadius` > 0 AND `PP`.`_pageNamespace`='0' AND `CF`.`Value` IS NOT NULL GROUP BY `GD`.`JoinKey` ORDER BY `PP`.`LightRadius` DESC,`GD`.`_pageTitle` LIMIT 100