8,290
edits
m (Fixes deprecated math tag formatting) |
m (Update cargo query to use new MissileWeaponData table) |
||
Line 31: | Line 31: | ||
== Table == | == Table == | ||
The following weapons can be {{name}}: | The following weapons can be {{name}}: | ||
{{#cargo_query:tables=ItemsTable=IT, GeneralData=GD | {{#cargo_query:tables=ItemsTable=IT, GeneralData=GD, MissileWeaponData=MWD | ||
|join on=IT.JoinKey=GD.JoinKey | |join on=IT.JoinKey=GD.JoinKey,IT.JoinKey=MWD.JoinKey | ||
|fields=CONCAT('{{((}}favilink page {{!}}', IT._pageName, '{{))}}')=Gun | |fields=CONCAT('{{((}}favilink page {{!}}', IT._pageName, '{{))}}')=Gun | ||
, GD.Tier=Tier | , GD.Tier=Tier | ||
, Shots=Shots (Base) | , MWD.Shots=Shots (Base) | ||
, CONCAT(CASE | , CONCAT(CASE | ||
WHEN Shots+1 >= FLOOR(Shots*1.3) | WHEN MWD.Shots+1 >= FLOOR(MWD.Shots*1.3) | ||
THEN | THEN | ||
CASE | CASE | ||
WHEN FLOOR(Shots*1.6) > Shots+1 | WHEN FLOOR(MWD.Shots*1.6) > MWD.Shots+1 | ||
THEN CONCAT(Shots+1, '-', FLOOR(Shots*1.6)) | THEN CONCAT(MWD.Shots+1, '-', FLOOR(MWD.Shots*1.6)) | ||
ELSE Shots+1 | ELSE MWD.Shots+1 | ||
END | END | ||
ELSE | ELSE | ||
CASE | CASE | ||
WHEN FLOOR(Shots*1.6) > FLOOR(Shots*1.3) | WHEN FLOOR(MWD.Shots*1.6) > FLOOR(MWD.Shots*1.3) | ||
THEN CONCAT(FLOOR(Shots*1.3), '-', FLOOR(Shots*1.6)) | THEN CONCAT(FLOOR(MWD.Shots*1.3), '-', FLOOR(MWD.Shots*1.6)) | ||
ELSE FLOOR(Shots*1.3) | ELSE FLOOR(MWD.Shots*1.3) | ||
END | END | ||
END)=Shots (Cooled) | END)=Shots (Cooled) | ||
, CONCAT(CASE | , CONCAT(CASE | ||
WHEN Shots%4 = 0 THEN FLOOR(Shots * 2) | WHEN MWD.Shots%4 = 0 THEN FLOOR(MWD.Shots * 2) | ||
ELSE 2 * FLOOR(Shots) + (8-(Shots*2)%8) | ELSE 2 * FLOOR(MWD.Shots) + (8-(MWD.Shots*2)%8) | ||
END) = Volume | END) = Volume | ||
, CONCAT(15 - GD.Tier,'%') = Water Usage Chance | , CONCAT(15 - GD.Tier,'%') = Water Usage Chance | ||
|where= Shots > 1 AND Shots = AmmoPerAction AND GD._pageNamespace = 0 | |where= MWD.Shots > 1 AND MWD.Shots = MWD.AmmoPerAction AND GD._pageNamespace = 0 | ||
|format = table | |format = table | ||
|order by=GD.Tier ASC | |order by=GD.Tier ASC |