Template:Infobox individual/marriages: Difference between revisions

From 'City of Adelaide' History and Genealogy Site
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
<includeonly>XXXXX{{#get_db_data:db=tng_db
<includeonly>{{#get_db_data:db=tng_db
   |from=tng_children LEFT JOIN tng_people ON tng_children.personID=tng_people.personID
   |from=tng_children LEFT JOIN tng_people ON tng_children.personID=tng_people.personID
   |where=tng_children.familyID='{{{TNGfamilyID}}}'
   |where=tng_children.familyID='{{{TNGfamilyID}}}'
   |order by=tng_people.birthdate ASC
   |order by=tng_people.birthdate ASC
   |data={{{TNGfamilyID}}}childID=tng_children.personID,{{{TNGfamilyID}}}childlastname=tng_people.lastname,{{{TNGfamilyID}}}childfirstname=tng_people.firstname,{{{TNGfamilyID}}}childbirthdate=tng_people.birthdate,{{{TNGfamilyID}}}childdeathdate=tng_people.deathdate}}YYYY<!--
   |data={{{TNGfamilyID}}}childID=tng_children.personID,{{{TNGfamilyID}}}childlastname=tng_people.lastname,{{{TNGfamilyID}}}childfirstname=tng_people.firstname,{{{TNGfamilyID}}}childbirthdate=tng_people.birthdate,{{{TNGfamilyID}}}childdeathdate=tng_people.deathdate}}<!--


-->{{Infobox | subbox = yes
-->{{Infobox | child = yes
| titlestyle = background: {{Roleclass colour|{{lc:{{#iferror:{{#external_value:TNGrole}}}}}}|3}}; font-size:100%;
| titlestyle = background: {{Roleclass colour|{{lc:{{#iferror:{{#external_value:TNGrole}}}}}}|3}}; font-size:100%;
| title      = {{TNGfamily|{{{TNGfamilyID}}}}}
| title      = XXXX{{TNGfamily|{{{TNGfamilyID}}}}}YYYY
| label4    = Spouse
| label4    = Spouse
|  data4    = {{#switch:{{lc:{{#iferror:{{#external_value:TNGgender}}}}}}|
|  data4    = {{#switch:{{lc:{{#iferror:{{#external_value:TNGgender}}}}}}|

Revision as of 07:04, 2 October 2014

{{#invoke:documentation|main|_content={{ {{#invoke:documentation|contentTitle}}}}}}