Liquid-cooled: Difference between revisions

Liquid-cooled (view source)

Revision as of 15:55, 22 December 2020

227 bytes added , 15:55, 22 December 2020

Adjust to avoid redundant integer range (4-4)

Egocarib

Bureaucrats, Interface administrators, Administrators

8,290

edits

@@ Line 31: / Line 31: @@
 == Table ==
 The following weapons can be {{name}}:
-{{#cargo_query:tables=ItemsTable=IT, GeneralData=GD|join on=IT.JoinKey=GD.JoinKey|fields=CONCAT('{{((}}favilink page {{!}}', IT._pageName, '{{))}}')=Gun, Shots, GD.Tier=Tier, CONCAT(CONCAT(CASE
+{{#cargo_query:tables=ItemsTable=IT, GeneralData=GD
-   WHEN FLOOR(Shots*1.3) > FLOOR(Shots + 1) THEN FLOOR(Shots * 1.3)
+|join on=IT.JoinKey=GD.JoinKey
-   ELSE FLOOR(Shots + 1)
+|fields=CONCAT('{{((}}favilink page {{!}}', IT._pageName, '{{))}}')=Gun
-END), '-', FLOOR(Shots* 1.6))=Shots (Cooled), CONCAT(CASE
+, GD.Tier=Tier
+, Shots=Shots (Base)
+, CONCAT(CASE
+  WHEN Shots+1 >= FLOOR(Shots*1.3)
+  THEN
+    CASE
+      WHEN FLOOR(Shots*1.6) > Shots+1
+      THEN CONCAT(Shots+1, '-', FLOOR(Shots*1.6))
+      ELSE Shots+1
+    END
+  ELSE
+    CASE
+      WHEN FLOOR(Shots*1.6) > FLOOR(Shots*1.3)
+      THEN CONCAT(FLOOR(Shots*1.3), '-', FLOOR(Shots*1.6))
+      ELSE FLOOR(Shots*1.3)
+    END
+  END)=Shots (Cooled)
+, CONCAT(CASE
    WHEN Shots%4 = 0 THEN FLOOR(Shots * 2)
    ELSE 2 * FLOOR(Shots) + (8-(Shots*2)%8)
-END) = Volume, CONCAT(15 - GD.Tier,'%') = Water usage chance|where= Shots > 1 AND Shots = AmmoPerAction AND GD._pageNamespace = 0|format = table|order by=GD.Tier ASC}}
+  END) = Volume
+, CONCAT(15 - GD.Tier,'%') = Water Usage Chance
+|where= Shots > 1 AND Shots = AmmoPerAction AND GD._pageNamespace = 0
+|format = table
+|order by=GD.Tier ASC
+}}
 {{Mod Navbox}}