Difference between revisions of "Template:World summary sophont"

From Traveller Wiki - Science-Fiction Adventure in the Far future
Jump to navigation Jump to search
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{#cargo_query:
 
{{#cargo_query:
 
   tables=Sophonts
 
   tables=Sophonts
   |fields=name, CONCAT('{{#if: {{#pos:{{{1}}}|(|0}} |Home|Present}}') = Home, CONCAT('{{#if: {{{1|}}}|{{#sub:{{{1|}}}|-1}}|0}}')= Percent, CONCAT(name) = text
+
   |fields=name, CONCAT('{{#if: {{#pos:{{{1}}}|(|0}} |Home|Present}}') = Home, CONCAT('{{#if: {{{1|}}}|{{#sub:{{{1|}}}|-1}}|0}}')= Percent, CONCAT(name) = text, existing, status
 
   |where=code = "{{#if: {{{1|}}}|{{#if: {{#pos:{{{1}}}|(|0}} | {{#sub:{{{1}}}|1|4}} | {{#sub:{{{1}}}|0|-1}} }}|}}"
 
   |where=code = "{{#if: {{{1|}}}|{{#if: {{#pos:{{{1}}}|(|0}} | {{#sub:{{{1}}}|1|4}} | {{#sub:{{{1}}}|0|-1}} }}|}}"
 
   |format=template
 
   |format=template
 
   |template=World summary sophont.layout
 
   |template=World summary sophont.layout
 
   |default=
 
   |default=
}}
+
}}<noinclude>
<noinclude>
+
A template to expand the sophonts, one at a time. Used as part of the World Summary list at the start of a world article. See also [[Template:World summary sophont.layout]]
A template to expand the sophonts, one at a time. Used as part of the World Summary list at the start of a world article
 
 
[[Category:Text Expansion Templates|World]][[Category: Cargo Templates|World]]
 
[[Category:Text Expansion Templates|World]][[Category: Cargo Templates|World]]
 
</noinclude>
 
</noinclude>

Revision as of 21:46, 18 August 2019

Unknown column 'code' in 'where clause'

A template to expand the sophonts, one at a time. Used as part of the World Summary list at the start of a world article. See also Template:World summary sophont.layout