User:Teamtoto/Sandbox: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
Line 18: | Line 18: | ||
| columns = 2 | | columns = 2 | ||
}} | }} | ||
{{#invoke:cargo_query|main | {{#invoke:infoxbox|infobox | ||
|rows={{infobox row||Extra info:</br><ul><li>fhdsjfksd</ul>{{#invoke:cargo_query|main | |||
| table=Factions=F | | table=Factions=F | ||
| fields = FLOOR(5)= mintier, FLOOR(7)= maxtier, F._pageName=faction | | fields = FLOOR(5)= mintier, FLOOR(7)= maxtier, F._pageName=faction | ||
Line 24: | Line 25: | ||
| delimiter = </br> | | delimiter = </br> | ||
|where = F.Old="1" AND IsVisible="1" | |where = F.Old="1" AND IsVisible="1" | ||
}}--> | }} }} }}--> | ||
< | {{#invoke:infobox|infobox | ||
|rows={{infobox row||Extra info:</br><ul><li>fhdsjfksd</ul><hr>}} | |||
{{infobox row|field=<div style="text-align:center;padding:2px"><b>Body Plan: {{{bodytype}}}</b></div>}} | |||
{{#invoke:CargoQuery|main | {{infobox row||{{#invoke:CargoQuery|main | ||
|table=Anatomies=A | |table=Anatomies=A | ||
| where = Name="{{{name|Turret}}}" | | where = Name="{{{name|Turret}}}" | ||
|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=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 | ||
| format=ul | |||
| template=single query result | | template=single query result | ||
| delimiter = </br> | | delimiter = </br> | ||
| limit = 1000 | | limit = 1000 | ||
}} | }}}}}} | ||
<table class="wikitable"><tr><th>Blueprint</th><th>Body Parts</th></tr> | <table class="wikitable"><tr><th>Blueprint</th><th>Body Parts</th></tr> |