User:Teamtoto/Sandbox: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
Line 25: | Line 25: | ||
|where = F.Old="1" AND IsVisible="1" | |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 | |||
|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= | |||
| template=Anatomy Table Row | |||
| delimiter = </br> | |||
| limit = 1000 | |||
}} | |||
</table> | |||
<!--{{#invoke:CargoQuery|main | |||
|table=Anatomies=A | |table=Anatomies=A | ||
|fields=Name | |fields=Name | ||
|one_to_many=Type | |one_to_many=(CONCAT("<li> [[List of Body Parts#", BaseType, "!", COALESCE(CONCAT(Laterality, " "), ""), Type, "]]"))=A | ||
|one_to_many_group=Name | |one_to_many_group=Name | ||
|one_to_many_sep= | |one_to_many_sep= | ||
|format = table | | format = table | ||
| limit = 1000 | | limit = 1000 | ||
}} | }}--> | ||
TODO: concat laterality and include child stuff, format it prettier? | TODO: concat laterality and include child stuff, format it prettier? |
Revision as of 16:37, 8 June 2021
Blueprint | Body Parts |
---|---|
AirWell | |
AnimalBed | |
AnimalChair | |
Bed | |
BipedalRobot | |
Bird | |
BoneWall | |
Bush | |
Cactus | |
Chair | |
Chalkboard | |
Clam | |
ClothWall | |
Crab | |
Door | |
Echinoid | |
Fish | |
Flower | |
Frog | |
Fungus | |
FungusWall | |
GlassWall | |
HexapedalRobot | |
Hexapod | |
HoverRobot | |
Humanoid | |
HumanoidOctohedron | |
HumanoidRobot | |
Insect | |
IronMaiden | |
Jelly | |
LeatherWall | |
MetalBed | |
MetalChair | |
MetalDoor | |
MetalWall | |
Mirror | |
Motes | |
Nest | |
Octohedron | |
Oddity | |
Ooze | |
Pillow | |
PlantWall | |
PlasticBed | |
PlasticChair | |
Pottery | |
Quadruped | |
QuadrupedalRobot | |
RailedMechanism | |
RockingChair | |
Slug | |
SlugWithHands | |
Snail | |
Snake | |
Spider | |
Star | |
Svardym | |
Table | |
TailedBiped | |
Three-Pointed Star | |
TreadedRobot | |
Tree | |
TripedalRobot | |
Turret | |
VanedMechanism | |
Vine | |
Wall | |
WheeledCreature | |
WheeledRobot | |
WheelRobot | |
WoodenHumanoid | |
WoodWall | |
Worm |
TODO: concat laterality and include child stuff, format it prettier?