User:Teamtoto/Sandbox: Difference between revisions

820 bytes removed ,  23:01, 30 July 2023
m
no edit summary
mNo edit summary
mNo edit summary
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{#invoke:Sandbox/User:Teamtoto/LuaModule|test}}
<!--{{Teamtoto/EncounterTable|roll=each
<!--{{Teamtoto/EncounterTable|roll=each
|{{EncounterTable/Row|weight=95|table=Artifact 0C}}
|{{EncounterTable/Row|weight=95|table=Artifact 0C}}
|{{EncounterTable/Row|weight=5|table=Artifact 0R}}
|{{EncounterTable/Row|weight=5|table=Artifact 0R}}
}}
}}
{{#invoke:CargoQuery| main
{{#invoke:CargoQuery| main
| tables = GeneralData=GD, Characters = C, CreatureFactions = CF
| tables = GeneralData=GD, Characters = C, CreatureFactions = CF
Line 18: Line 18:
| columns = 2
| columns = 2
}}
}}
{{#invoke:cargo_query|main
| table=Factions=F
| fields = FLOOR(5)= mintier, FLOOR(7)= maxtier, F._pageName=faction
| template = possible cultists
| delimiter = </br>
|where = F.Old="1" AND IsVisible="1"
}}-->
<table class="wikitable"><tr><th>Body Parts of a {{{name|Turret}}}</th></tr><tr><td>
<ul><li>[[List of Body Parts#Body|Body]]
<li>[[List of Body Parts#Floating Nearby|Floating Nearby]]
{{#invoke:CargoQuery|main
{{#invoke:CargoQuery|main
|table=Anatomies=A
| tables=GeneralData=GD, _pageData=PD
| where = Name="{{{name|Turret}}}"
| join= GD._pageName=PD._pageName
|fields=CONCAT("<li> [[List of Body Parts#", BaseType, "{{!}}", COALESCE(CONCAT(Laterality, " "), ""), Type, "]]", (CASE WHEN childType <> "" THEN CONCAT("<ul><li> [[List of Body Parts#", childBaseType, "{{!}}", COALESCE(CONCAT(childLaterality, " "), ""), childType, "]]</ul>") ELSE "" END))=Page
| fields={{favilink format args}}
| template=single query result
| where=PD._categories HOLDS "Liquid_Containers" AND GD._pageNamespace = "0"
| delimiter = </br>
| template=favilink format
| limit = 1000
| format = ul
| columns = 2
}}
}}
</ul></td></tr></table>
<table class="wikitable"><tr><th>Blueprint</th><th>Body Parts</th></tr>
{{#invoke:CargoQuery|main
{{#invoke:CargoQuery|main
|table=Anatomies=A
| tables=GeneralData=GD, PhysicalProperties=PP
|fields=Name=blueprint
| join =GD.ObjectID= PP.JoinKey
|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
| fields={{favilink format args}}
|one_to_many_group=blueprint
| where=PP.Volume > 0 AND GD._pageNamespace = "0"
|one_to_many_sep=&nbsp;
| template=favilink format
| template=Anatomy Table Row
| format = ul
| delimiter = </br>
| columns = 2
| limit = 1000
}}-->
}}</table>