User:Teamtoto/Sandbox: Difference between revisions

← Older edit

User:Teamtoto/Sandbox (view source)

Revision as of 23:01, 30 July 2023

233 bytes removed , 23:01, 30 July 2023

m

no edit summary

Teamtoto

Bureaucrats, Interface administrators, Suppressors, Administrators

8,756

edits

@@ Line 1: / Line 1: @@
+{{#invoke:Sandbox/User:Teamtoto/LuaModule|test}}
 <!--{{Teamtoto/EncounterTable|roll=each
 |{{EncounterTable/Row|weight=95|table=Artifact 0C}}
 |{{EncounterTable/Row|weight=5|table=Artifact 0R}}
 }}
 {{#invoke:CargoQuery| main
 | tables = GeneralData=GD, Characters = C, CreatureFactions = CF
@@ Line 18: / Line 18: @@
 | columns = 2
 }}
-{{#invoke:cargo_query|main
+{{#invoke:CargoQuery|main
-| table=Factions=F
+| tables=GeneralData=GD, _pageData=PD
-| fields = FLOOR(5)= mintier, FLOOR(7)= maxtier, F._pageName=faction
+| join= GD._pageName=PD._pageName
-| template = possible cultists
+| fields={{favilink format args}}
-| delimiter = </br>
+| where=PD._categories HOLDS "Liquid_Containers" AND GD._pageNamespace = "0"
-|where = F.Old="1" AND IsVisible="1"
+| 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
 }}-->
-<table class="wikitable"><tr><th>Blueprint</th><th>Body Parts</th></tr>
-{{#invoke:CargoQuery|main
- |table=Anatomies=A
- |fields=Name=blueprint
- |one_to_many=(CONCAT("<li> [[List of Body Parts#",
-   BaseType, "{{!}}",
-   COALESCE(CONCAT(Laterality, " "), ""),
-   Type, "]]",
-   (CASE
-     WHEN childType <> ""
-     THEN CONCAT("<ul><li>",
-                  childType, " (",
-                  childBaseType, ")</ul>")
-     ELSE ""
-     END)))=bodyparts
- |one_to_many_group=blueprint
- |one_to_many_sep=&nbsp;
- | template=Anatomy Table Row
- | delimiter = </br>
- | limit = 1000
-}}</table>