Beamsplitter: Difference between revisions

807 bytes added ,  16:49, 8 December 2021
m
separate out NPC equipment
m (note about drawback.)
m (separate out NPC equipment)
Line 24: Line 24:
   | fields = CONCAT('{{(}}favilink id{{!}}',M.ObjectID,'{{)}}') = Item,
   | fields = CONCAT('{{(}}favilink id{{!}}',M.ObjectID,'{{)}}') = Item,
             GD.Tier
             GD.Tier
   | where = M.SupportedMods HOLDS 'BeamWeaponMods'
   | where = M.SupportedMods HOLDS 'BeamWeaponMods' AND GD._pageNamespace = '0'
  | order by = GD.Tier DESC,GD.PlainName
  | format = table
}}
 
== Eligible NPC Equipment ==
{{#cargo_query:
  | tables = Modability=M,GeneralData=GD
  | join on = M.JoinKey=GD.JoinKey
  | fields = CONCAT(CASE
                WHEN GD.ObjectID = 'Naser Cannon'
                THEN '{{(}}favilink{{!}}galgal{{!}}possessive{{)}}'
                WHEN GD.ObjectID = 'LightLock'
                THEN '{{(}}favilink{{!}}conservator{{!}}possessive{{)}}'
                WHEN GD.ObjectID = 'Point-Defense Laser'
                THEN '{{(}}favilink{{!}}anomaly extinguisher{{!}}possessive{{)}}'
                ELSE ''
            END,'{{(}}favilink id{{!}}',M.ObjectID,'{{)}}')=Item,
            GD.Tier
  | where = M.SupportedMods HOLDS 'BeamWeaponMods' AND GD._pageNamespace <> '0'
   | order by = GD.Tier DESC,GD.PlainName
   | order by = GD.Tier DESC,GD.PlainName
   | format = table
   | format = table