Difference between revisions of "Template:World summary sophont"

From Traveller Wiki - Science-Fiction Adventure in the Far future
Jump to navigation Jump to search
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, extinct
 
   |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

Revision as of 07:55, 15 April 2016

Error: No field named "extinct" found for any of the specified database tables.

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