User:Teamtoto/Sandbox: Difference between revisions

User:Teamtoto/Sandbox (view source)

66 bytes removed , 03:04, 22 December 2020

m

no edit summary

8,756

edits

@@ Line 1: / Line 1: @@
-{{#cargo_query:tables=ItemsTable=IT, GeneralData=GD|join on=IT.JoinKey=GD.JoinKey|fields=IT._pageName=Gun, Shots, GD.Tier=Tier, CONCAT(FLOOR(Shots*1.3), '-', FLOOR(Shots* 1.6))=Shots (Cooled), (2 * FLOOR(Shots)) = Volume, CONCAT(15 + GD.Tier,'%') = Water usage chance|where= Shots > 1 AND Shots%4 = 0 AND GD._pageNamespace = 0|format = table}}
+{{#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
+   WHEN FLOOR(Shots*1.3) > FLOOR(Shots + 1) THEN FLOOR(Shots * 1.3)
-{{#cargo_query:table=ItemsTable=IT, GeneralData=GD|join on=IT.JoinKey=GD.JoinKey|fields=IT._pageName=Gun, Shots, CONCAT(FLOOR(Shots*1.3), '-', FLOOR(Shots* 1.6))=Shots (Cooled), (2 * FLOOR(Shots) + (8-(Shots*2)%8)) = Volume, CONCAT(15 + GD.Tier,'%') = Water usage chance|where= Shots > 1 AND Shots%4 <> 0 AND GD._pageNamespace = 0|format = table}}
+   WHEN FLOOR(Shots*1.3) <= FLOOR(Shots + 1) THEN FLOOR(Shots + 1)
+END), '-', FLOOR(Shots* 1.6))=Shots (Cooled), CONCAT(CASE
+WHEN Shots%4 = 0 THEN FLOOR(Shots * 2)
+WHEN Shots%4 <> 0 THEN 2 * FLOOR(Shots) + (8-(Shots*2)%8)
+END) = Volume, CONCAT(15 + GD.Tier,'%') = Water usage chance|where= Shots > 1 AND GD._pageNamespace = 0|format = table|orderby=GD.Tier ASC}}