User:Teamtoto/Sandbox: Difference between revisions

Jump to navigation Jump to search
m
no edit summary
mNo edit summary
mNo edit summary
 
(41 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{#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
{{#invoke:Sandbox/User:Teamtoto/LuaModule|test}}
  WHEN FLOOR(Shots*1.3) > FLOOR(Shots + 1) THEN FLOOR(Shots * 1.3)
<!--{{Teamtoto/EncounterTable|roll=each
  ELSE FLOOR(Shots + 1)
|{{EncounterTable/Row|weight=95|table=Artifact 0C}}
END), '-', FLOOR(Shots* 1.6))=Shots (Cooled), CONCAT(CASE
|{{EncounterTable/Row|weight=5|table=Artifact 0R}}
WHEN Shots%4 = 0 THEN FLOOR(Shots * 2)
}}
ELSE 2 * FLOOR(Shots) + (8-(Shots*2)%8)
{{#invoke:CargoQuery| main
END) = Volume, CONCAT(15 + GD.Tier,'%') = Water usage chance|where= Shots > 1 AND GD._pageNamespace = 0|format = table|orderby=GD.Tier ASC}}
| tables = GeneralData=GD, Characters = C, CreatureFactions = CF
| join = C.ObjectID = GD.ObjectID, C.ObjectID = CF.ObjectID
| where = C.Demeanor = "aggressive" AND (C._pageNamespace= '0' OR C._pageNamespace = '10002')
|group by = GD.ObjectID
| fields = {{favilink format args}}
| default = {{Template Error|Creature level and faction}}
| one_to_many= CONCAT(' ([[', CF.Faction, ']])')=outro, C.ObjectID
| one_to_many_group=C.ObjectID
| one_to_many_sep=,
| template = favilink format
| format = ul
| columns = 2
}}
{{#invoke:CargoQuery|main
| tables=GeneralData=GD, _pageData=PD
| join= GD._pageName=PD._pageName
| fields={{favilink format args}}
| where=PD._categories HOLDS "Liquid_Containers" AND GD._pageNamespace = "0"
| template=favilink format
| format = ul
| columns = 2
}}
{{#invoke:CargoQuery|main
| tables=GeneralData=GD, PhysicalProperties=PP
| join =GD.ObjectID= PP.JoinKey
| fields={{favilink format args}}
| where=PP.Volume > 0 AND GD._pageNamespace = "0"
| template=favilink format
| format = ul
| columns = 2
}}-->

Navigation menu