8,290
edits
m (exclude natural weapons from the eligible items table) |
(Add NPC equipment) |
||
Line 29: | Line 29: | ||
CONCAT('{{(}}qud text{{!}}&C',GD.Tier,'%{{)}} or {{(}}qud text{{!}}&C',GD.Tier+1,'%{{)}}') = Chance to Dismember | CONCAT('{{(}}qud text{{!}}&C',GD.Tier,'%{{)}} or {{(}}qud text{{!}}&C',GD.Tier+1,'%{{)}}') = Chance to Dismember | ||
| where = M.SupportedMods HOLDS 'BeamWeaponMods' AND EI.Info LIKE '%EnergyAmmoLoader,,,%' AND GD._pageNamespace='0' | | where = M.SupportedMods HOLDS 'BeamWeaponMods' AND EI.Info LIKE '%EnergyAmmoLoader,,,%' AND GD._pageNamespace='0' | ||
| order by = GD.Tier DESC,GD.PlainName | |||
| format = table | |||
}} | |||
== Eligible NPC Equipment== | |||
{{#cargo_query: | |||
| tables = Modability=M,GeneralData=GD,ItemsTable=IT,ExtraInfo=EI | |||
| join on = M.JoinKey=GD.JoinKey,M.JoinKey=IT.JoinKey,M.JoinKey=EI.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, | |||
CONCAT('{{(}}qud text{{!}}&C',GD.Tier,'%{{)}} or {{(}}qud text{{!}}&C',GD.Tier+1,'%{{)}}') = Chance to Dismember | |||
| where = M.SupportedMods HOLDS 'BeamWeaponMods' AND EI.Info LIKE '%EnergyAmmoLoader,,,%' AND GD._pageNamespace<>'0' | |||
| order by = GD.Tier DESC,GD.PlainName | | order by = GD.Tier DESC,GD.PlainName | ||
| format = table | | format = table |