Template:Individual infobox/marriages: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 9: | Line 9: | ||
|#default = {{TNGperson|{{{TNGwife|}}}|biobd}} | |#default = {{TNGperson|{{{TNGwife|}}}|biobd}} | ||
}} | }} | ||
{{!}}- | |||
{{#if:{{{TNGmarrdate|}}}| | {{#if:{{{TNGmarrdate|}}}| | ||
! style="padding-right: 1em;" {{!}} Married | |||
{{!}} {{{TNGmarrdate}}} | |||
}} | |||
{{!}}- | {{!}}- | ||
{{#if:{{{TNGmarrplace|}}}| | {{#if:{{{TNGmarrplace|}}}| | ||
! style="padding-right: 1em;" {{!}} Married place | |||
! style="padding-right: 1em;" {{!}} Married place | {{!}} {{{TNGmarrplace}}} | ||
{{!}} {{{TNGmarrplace} | }} | ||
{{#get_db_data:db=tng_db | {{#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 | ||
| Line 23: | Line 24: | ||
|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}} | |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}} | ||
{{!}}- | |||
{{#if:{{#iferror:{{#external_value:{{{TNGfamilyID}}}childID}}}}| | {{#if:{{#iferror:{{#external_value:{{{TNGfamilyID}}}childID}}}}| | ||
! style="padding-right: 1em; border-top: {{Individual infobox/style|section_border}}" {{!}} Children | ! style="padding-right: 1em; border-top: {{Individual infobox/style|section_border}}" {{!}} Children | ||
{{!}}{{#display_external_table:template=Individual infobox/children|data=childID={{{TNGfamilyID}}}childID,childlastname={{{TNGfamilyID}}}childlastname,childfirstname={{{TNGfamilyID}}}childfirstname,childbirthdate={{{TNGfamilyID}}}childbirthdate,childdeathdate={{{TNGfamilyID}}}childdeathdate}} }}</includeonly><noinclude> | {{!}}style="padding-right: 1em; border-top: {{Individual infobox/style|section_border}}" {{!}} {{#display_external_table:template=Individual infobox/children|data=childID={{{TNGfamilyID}}}childID,childlastname={{{TNGfamilyID}}}childlastname,childfirstname={{{TNGfamilyID}}}childfirstname,childbirthdate={{{TNGfamilyID}}}childbirthdate,childdeathdate={{{TNGfamilyID}}}childdeathdate}} }}</includeonly><noinclude> | ||
[[Category:Data retrieval templates]] | [[Category:Data retrieval templates]] | ||
{{documentation}} | {{documentation}} | ||
</noinclude> | </noinclude> | ||
Revision as of 10:47, 1 October 2014
{{#invoke:documentation|main|_content={{ {{#invoke:documentation|contentTitle}}}}}}