User:Teamtoto/Sandbox: Difference between revisions

From Caves of Qud Wiki
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>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
|table=Anatomies=A
| where = Name="{{{name|Turret}}}"
|fields=CONCAT("<li> [[List of Body Parts#", BaseType, "{{!}}", COALESCE(CONCAT(Laterality, " "), ""), Type, "]]", (CASE WHEN childType <> "" THEN CONCAT("<ul><li>", childType, " (", childBaseType, ")</ul>") ELSE "" END))=Page
| template=single query result
| delimiter = </br>
| limit = 1000
}}
</ul></td></tr></table>
<table class="wikitable"><tr><th>Blueprint</th><th>Body Parts</th></tr>
<table class="wikitable"><tr><th>Blueprint</th><th>Body Parts</th></tr>
{{#invoke:CargoQuery|main
{{#invoke:CargoQuery|main
  |table=Anatomies=A
  |table=Anatomies=A
  |fields=Name=blueprint
  |fields=Name=blueprint
  |one_to_many=(CONCAT("<li> [[List of Body Parts#",  
  |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
  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_group=blueprint
  |one_to_many_sep=&nbsp;
  |one_to_many_sep=&nbsp;

Revision as of 17:12, 8 June 2021

Body Parts of a Turret









































































BlueprintBody 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