User:Teamtoto/Sandbox: Difference between revisions

609 bytes removed ,  23:01, 30 July 2023
m
no edit summary
mNo edit summary
mNo edit summary
 
(12 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>Blueprint</th>
<th>Body Parts</th>
</tr>
{{#invoke:CargoQuery|main
{{#invoke:CargoQuery|main
|table=Anatomies=A
| tables=GeneralData=GD, _pageData=PD
|fields=Name=blueprint
| join= GD._pageName=PD._pageName
|one_to_many=(CONCAT("<li> [[List of Body Parts#",
| fields={{favilink format args}}
  BaseType, "{{!}}",
| where=PD._categories HOLDS "Liquid_Containers" AND GD._pageNamespace = "0"
  COALESCE(CONCAT(Laterality, " "), ""),
| template=favilink format
  Type, "]]",
| format = ul
  (CASE
| columns = 2
    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>
{{#invoke:CargoQuery|main
<!--{{#invoke:CargoQuery|main
| tables=GeneralData=GD, PhysicalProperties=PP
|table=Anatomies=A
| join =GD.ObjectID= PP.JoinKey
|fields=Name
| fields={{favilink format args}}
|one_to_many=(CONCAT("<li> [[List of Body Parts&#35;", BaseType, "!", COALESCE(CONCAT(Laterality, " "), ""), Type, "]]"))=A
| where=PP.Volume > 0 AND GD._pageNamespace = "0"
|one_to_many_group=Name
| template=favilink format
|one_to_many_sep=&nbsp;
| format = ul
| format = table
| columns = 2
| limit = 1000
}}-->
}}-->
TODO: concat laterality and include child stuff, format it prettier?