Energy-loaded missile weapons: Difference between revisions
Jump to navigation
Jump to search
m (Update to use new Cargo table) |
No edit summary |
||
Line 3: | Line 3: | ||
Energy-loaded missile weapons are most commonly powered by [[energy cell]]s, but can also be powered from other sources, such as onboard power systems or [[Electrical Generation]]. | Energy-loaded missile weapons are most commonly powered by [[energy cell]]s, but can also be powered from other sources, such as onboard power systems or [[Electrical Generation]]. | ||
{{#cargo_query:tables=MissileWeaponData=MWD,GeneralData=GD,ArtifactData=AD | The following energy-loaded missile weapons gain a +2 bonus to their damage dice when [[overloaded]]: | ||
|join on=MWD.JoinKey=GD.JoinKey,MWD.JoinKey=AD.JoinKey | |||
|fields=CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Name,AD.ChargeUsed=Energy use,CONCAT('{{(}}#replace:',MWD.AmmoDamageTypes,'{{!}}</br>{{!}}, {{)}}')=Damage types | {{#cargo_query:tables=MissileWeaponData=MWD,GeneralData=GD,ArtifactData=AD,ExtraInfo=EI,ItemsTable=IT | ||
|where=AD.ChargeUsed IS NOT NULL | |join on=MWD.JoinKey=GD.JoinKey,MWD.JoinKey=AD.JoinKey,MWD.JoinKey=EI.JoinKey,MWD.JoinKey=IT.JoinKey | ||
|fields= | |||
CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Name, | |||
AD.ChargeUsed=Energy use, | |||
CONCAT('{{(}}#replace:',MWD.AmmoDamageTypes,'{{!}}</br>{{!}}, {{)}}')=Damage types, | |||
CONCAT('{{Heart}}',IT.Damage,'+2')=Damage When Overloaded | |||
|where=AD.ChargeUsed IS NOT NULL AND EI.Info LIKE '%EnergyAmmoLoader,,,%' | |||
|format=table | |||
}} | |||
The following energy-loaded missile weapons gain a different bonus to damage dice when [[overloaded]]: | |||
{{#cargo_query:tables=MissileWeaponData=MWD,GeneralData=GD,ArtifactData=AD,ExtraInfo=EI | |||
|join on=MWD.JoinKey=GD.JoinKey,MWD.JoinKey=AD.JoinKey,MWD.JoinKey=EI.JoinKey | |||
|fields= | |||
CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Name, | |||
AD.ChargeUsed=Energy use, | |||
CONCAT('{{(}}#replace:',MWD.AmmoDamageTypes,'{{!}}</br>{{!}}, {{)}}')=Damage types, | |||
CONCAT( | |||
CASE | |||
WHEN GD.PlainName = 'arc winder' | |||
THEN '{{Heart|W}}???' | |||
WHEN GD.PlainName = 'high-voltage arc winder' | |||
THEN '{{Heart|W}}???' | |||
END)=Damage When Overloaded | |||
|where=AD.ChargeUsed IS NOT NULL AND EI.Info NOT LIKE '%EnergyAmmoLoader,,,%' | |||
|format=table | |format=table | ||
}} | }} |