$row[treename]"; if( $row[branch] ) { //explode on commas $branches = explode(",",$row[branch]); $count = 0; $branchstr = ""; foreach($branches as $branch) { $count++; $brquery = "SELECT description FROM $branches_table WHERE branch = \"$branch\" and gedcom = \"$tree\""; $brresult = mysql_query($brquery) or die ("$text[cannotexecutequery]: $brquery"); $brrow = mysql_fetch_assoc($brresult); $branchstr .= $brrow[description] ? $brrow[description] : $branch; if($count < count($branches)) $branchstr .= ", "; mysql_free_result($brresult); } if( $branchstr ) $treestr = $treestr . " | $branchstr"; } mysql_free_result($result); $indmedia = getMedia($row,"I"); writelog( "" . xmlcharacters("$text[indinfofor] $logname ($personID)") . "" ); $flags[tabs] = $tngconfig[tabs]; tng_header( $namestr, $flags ); $photostr = showSmallPhoto( $personID, $namestr, $row[allow_living], 0 ); if( $row[allow_living] ) { $citekey = $personID . "_"; $cite = reorderCitation( $citekey ); $citekey = $personID . "_NAME"; $cite2 .= reorderCitation( $citekey ); if( $cite2 ) $cite .= $cite ? ", $cite2" : $cite2; if( $cite ) $namestr .= "^[$cite]"; } echo tng_DrawHeading( $photostr, $namestr, getYears( $row ) ); echo tng_coreicons(); $persontext = ""; $persontext .= "

\n"; if( $tng_extras ) { $media = ""; $tableid = "media"; $cellnumber = 0; foreach( $mediatypes as $mediatype ) { $mediatypeID = $mediatype[ID]; $newmedia = writeMedia( $indmedia, $mediatypeID ); if( $newmedia ) { $media .= $newmedia; $media .= showBreak(); } } if( $media ) { $persontext .= beginSection("media"); $persontext .= "\n"; $persontext .= $media; $persontext .= "\n"; $persontext .= endSection("media"); } } $persontext .= beginSection("info"); $persontext .= "\n"; resetEvents(); if($row[allow_living] ) { if( $row[title] ) $persontext .= showEvent( array( "text"=>$text[title], "fact"=>$row[title], "event"=>"TITL", "entity"=>$personID, "type"=>"I" ) ); if( $row[suffix] ) $persontext .= showEvent( array( "text"=>$text[suffix], "fact"=>$row[suffix], "event"=>"NSFX", "entity"=>$personID, "type"=>"I" ) ); if( $row[nickname] ) $persontext .= showEvent( array( "text"=>$text[nickname], "fact"=>$row[nickname], "event"=>"NICK", "entity"=>$personID, "type"=>"I" ) ); setEvent( array( "text"=>$text[born], "fact"=>$stdex[BIRT], "date"=>$row[birthdate], "place"=>$row[birthplace], "event"=>"BIRT", "entity"=>$personID, "type"=>"I" ), $row[birthdatetr] ); setEvent( array( "text"=>$text[christened], "fact"=>$stdex[CHR], "date"=>$row[altbirthdate], "place"=>$row[altbirthplace], "event"=>"CHR", "entity"=>$personID, "type"=>"I" ), $row[altbirthdatetr] ); } if ( $row[sex] == "M" ) { $sex = $text[male]; $spouse = "wife"; $self = "husband"; $spouseorder = "husborder"; } else if ($row[sex] == "F" ) { $sex = $text[female]; $spouse = "husband"; $self = "wife"; $spouseorder = "wifeorder"; } else { $sex = $text[unknown]; $spouseorder = ""; } setEvent( array( "text"=>$text[gender], "fact"=>$sex ), $nodate ); if( $row[allow_living] ) { if( $allow_lds ) { setEvent( array( "text"=>$text[baptizedlds], "fact"=>$stdex[BAPL], "date"=>$row[baptdate], "place"=>$row[baptplace], "event"=>"BAPL", "entity"=>$personID, "type"=>"I" ), $row[baptdatetr] ); setEvent( array( "text"=>$text[endowedlds], "fact"=>$stdex[ENDL], "date"=>$row[endldate], "place"=>$row[endlplace], "event"=>"ENDL", "entity"=>$personID, "type"=>"I" ), $row[endldatetr] ); } //do custom events $query = "SELECT display, eventdate, eventdatetr, eventplace, age, agency, cause, addressID, info, tag, description, eventID FROM $events_table, $eventtypes_table WHERE persfamID = \"$personID\" AND $events_table.eventtypeID = $eventtypes_table.eventtypeID AND gedcom = \"$tree\" AND keep = \"1\" AND parenttag = \"\" ORDER BY ordernum, tag, description, eventdatetr, info, eventID"; $custevents = mysql_query($query) or die ("$text[cannotexecutequery]: $query"); while ( $custevent = mysql_fetch_assoc( $custevents ) ) { $displayval = getEventDisplay( $custevent[display] ); $eventID = $custevent[eventID]; $key = "cust$eventID"; $fact = array(); if( $custevent[info] ) { $fact = checkXnote( $custevent[info] ); if( $fact[1] ) { $xnote = $fact[1]; array_pop( $fact ); } } $extras = getFact( $custevent ); $fact = ( count( $fact ) && $fact[0] != "" ) ? array_merge( $fact, $extras ) : $extras; setEvent( array( "text"=>$displayval, "date"=>$custevent[eventdate], "place"=>$custevent[eventplace], "fact"=>$fact, "xnote"=>$xnote, "event"=>$eventID, "entity"=>$personID, "type"=>"I" ), $custevent[eventdatetr] ); } mysql_free_result( $custevents ); setEvent( array( "text"=>$text[died], "fact"=>$stdex[DEAT], "date"=>$row[deathdate], "place"=>$row[deathplace], "event"=>"DEAT", "entity"=>$personID, "type"=>"I" ), $row[deathdatetr] ); setEvent( array( "text"=>$text[buried], "fact"=>$stdex[BURI], "date"=>$row[burialdate], "place"=>$row[burialplace], "event"=>"BURI", "entity"=>$personID, "type"=>"I" ), $row[burialdatetr] ); } ksort( $events ); foreach( $events as $event ) $persontext .= showEvent( $event ); $query = "SELECT passocID, relationship FROM $assoc_table WHERE gedcom = \"$tree\" AND personID = \"$personID\""; $assocresult = mysql_query($query) or die ("$text[cannotexecutequery]: $query"); while($assoc = mysql_fetch_assoc( $assocresult ) ) { $persontext .= showEvent( array( "text"=>$text[association], "fact"=>formatAssoc($assoc) ) ); } mysql_free_result( $assocresult ); $persontext .= showEvent( array( "text"=>$text[personid], "date"=>$personID, "place"=>$treestr, "np"=>1 ) ); if( $row[changedate] || ( $allow_edit && $rightbranch ) ) { $row[changedate] = displayDate( $row[changedate] ); if( $allow_edit && $rightbranch ) { if( $row[changedate] ) $row[changedate] .= " | "; $row[changedate] .= "$text[edit]"; } $persontext .= showEvent( array( "text"=>$text[lastmodified], "fact"=>$row[changedate] ) ); } $persontext .= showBreak(); //do parents $query = "SELECT personID, familyID, sealdate, sealplace, relationship FROM $children_table WHERE personID = \"$personID\" AND gedcom = \"$tree\" ORDER BY parentorder"; $parents = mysql_query($query) or die ("$text[cannotexecutequery]: $query"); if ( $parents && mysql_num_rows( $parents ) ) { while ( $parent = mysql_fetch_assoc( $parents ) ) { getCitations( $personID . "::" . $parent[familyID] ); $query = "SELECT personID, lastname, lnprefix, firstname, suffix, nameorder, birthdate, birthplace, altbirthdate, altbirthplace, $people_table.living, $people_table.branch FROM $people_table, $families_table WHERE $people_table.personID = $families_table.husband AND $families_table.familyID = \"$parent[familyID]\" AND $people_table.gedcom = \"$tree\" AND $families_table.gedcom = \"$tree\""; $gotfather = mysql_query($query) or die ("$text[cannotexecutequery]: $query"); if( $gotfather ) { $fathrow = mysql_fetch_assoc( $gotfather ); $birthinfo = getBirthInfo( $fathrow ); $fathrow[allow_living] = !$fathrow[living] || $livedefault == 2 || ( $allow_living && checkbranch( $fathrow[branch] ) ) ? 1 : 0; if( $fathrow[firstname] || $fathrow[lastname] ) { $fathname = getName( $fathrow ); $fatherlink = "$fathname"; } else $fatherlink = ""; if( $fathrow[allow_living] ) $fatherlink .= $birthinfo; $persontext .= showEvent( array( "text"=>$text[father], "fact"=>$fatherlink ) ); mysql_free_result( $gotfather ); } $query = "SELECT personID, lastname, lnprefix, firstname, suffix, nameorder, birthdate, birthplace, altbirthdate, altbirthplace, $people_table.living, $people_table.branch FROM $people_table, $families_table WHERE $people_table.personID = $families_table.wife AND $families_table.familyID = \"$parent[familyID]\" AND $people_table.gedcom = \"$tree\" AND $families_table.gedcom = \"$tree\""; $gotmother = mysql_query($query) or die ("$text[cannotexecutequery]: $query"); if( $gotmother ) { $mothrow = mysql_fetch_assoc( $gotmother ); $birthinfo = getBirthInfo( $mothrow ); $mothrow[allow_living] = !$mothrow[living] || $livedefault == 2 || ( $allow_living && checkbranch( $mothrow[branch] ) ) ? 1 : 0; if( $mothrow[firstname] || $mothrow[lastname] ) { $mothname = getName( $mothrow ); $motherlink = "$mothname"; } else $motherlink = ""; if( $mothrow[allow_living] ) $motherlink .= $birthinfo; $persontext .= showEvent( array( "text"=>$text[mother], "fact"=>$motherlink ) ); mysql_free_result( $gotmother ); } if( $row[allow_living] && $parent[relationship] ) $persontext .= showEvent( array( "text"=>$text[relationship], "fact"=>$parent[relationship] ) ); if( $row[allow_living] && $allow_lds ) $persontext .= showEvent( array( "text"=>$text[sealedplds], "date"=>$parent[sealdate], "place"=>$parent[sealplace], "event"=>"SLGC", "entity"=>"$personID::$parent[familyID]", "type"=>"C" ) ); $query = "SELECT living, branch FROM $families_table WHERE $families_table.familyID = \"$parent[familyID]\" AND $families_table.gedcom = \"$tree\""; $gotparents = mysql_query($query) or die ("$text[cannotexecutequery]: $query"); $parentrow = mysql_fetch_assoc( $gotparents ); mysql_free_result($gotparents); $parent[personID] = ""; $rightfbranch = checkbranch( $parentrow[branch] ) ? 1 : 0; $parent[allow_living] = !$parentrow[living] || $livedefault == 2 || ( $allow_living && $rightfbranch ) ? 1 : 0; $fammedia = getMedia($parent,"F"); foreach( $mediatypes as $mediatype ) { $mediatypeID = $mediatype[ID]; $persontext .= writeMedia( $fammedia, $mediatypeID ); } $persontext .= showEvent( array( "text"=>$text[familyid], "date"=>$parent[familyID], "place"=>"$text[groupsheet]", "np"=>1 ) ); $persontext .= showBreak(); } mysql_free_result($parents); } //do marriages if( $spouseorder ) $query = "SELECT $spouse, familyID, living, branch, marrdate, marrdatetr, marrplace, marrtype, divdate, divdatetr, divplace, sealdate, sealdatetr, sealplace, DATE_FORMAT(changedate,\"%d %b %Y %H:%i:%s\") as changedate FROM $families_table WHERE $families_table.$self = \"$personID\" AND gedcom = \"$tree\" ORDER BY $spouseorder"; else $query = "SELECT husband, wife, familyID, living, branch, marrdate, marrdatetr, marrplace, marrtype, divdate, divdatetr, divplace, sealdate, sealdatetr, sealplace, DATE_FORMAT(changedate,\"%d %b %Y %H:%i:%s\") as changedate FROM $families_table WHERE ($families_table.husband = \"$personID\" OR $families_table.wife = \"$personID\") AND gedcom = \"$tree\""; $marriages= mysql_query($query) or die ("$text[cannotexecutequery]: $query"); $marrtot = mysql_num_rows($marriages); if( !$marrtot ) { $query = "SELECT husband, wife, familyID, living, branch, marrdate, marrdatetr, marrplace, marrtype, divdate, divdatetr, divplace, sealdate, sealdatetr, sealplace, DATE_FORMAT(changedate,\"%d %b %Y\") as changedate FROM $families_table WHERE ($families_table.husband = \"$personID\" OR $families_table.wife = \"$personID\") AND gedcom = \"$tree\""; $marriages= mysql_query($query) or die ("$text[cannotexecutequery]: $query"); $marrtot = mysql_num_rows($marriages); $spouseorder = 0; } $marrcount = 1; while ( $marriagerow = mysql_fetch_assoc( $marriages ) ) { $famnotes = getNotes( $marriagerow[familyID], "F" ); getCitations( $marriagerow[familyID] ); $stdexf = getStdExtras( $marriagerow[familyID] ); if( $marriagerow[marrtype] ) { if( !is_array( $stdexf[MARR] ) ) $stdexf[MARR] = array(); array_unshift( $stdexf[MARR], "$text[type]: $marriagerow[marrtype]" ); } if( !$spouseorder ) $spouse = $marriagerow[husband] == $personID ? wife : husband; unset($spouserow); unset($birthinfo); if( $marriagerow[$spouse] ) { $query = "SELECT personID, lastname, lnprefix, firstname, suffix, nameorder, birthdate, birthplace, altbirthdate, altbirthplace, living, branch FROM $people_table WHERE personID = \"$marriagerow[$spouse]\" AND gedcom = \"$tree\""; $spouseresult= mysql_query($query) or die ("$text[cannotexecutequery]: $query"); $spouserow = mysql_fetch_assoc( $spouseresult ); $birthinfo = getBirthInfo( $spouserow ); $spouserow[allow_living] = !$spouserow[living] || $livedefault == 2 || ( $allow_living && checkbranch( $spouserow[branch] ) ) ? 1 : 0; if( $spouserow[firstname] || $spouserow[lastname] ) { $spousename = getName( $spouserow ); $spouselink = "$spousename"; } if( $spouserow[allow_living] ) $spouselink .= $birthinfo; } else $spouselink = ""; $marrstr = $marrtot > 1 ? " $marrcount" : ""; if( $spouserow[allow_living] ) $persontext .= showEvent( array( "text"=>"$text[family]$marrstr", "fact"=>$spouselink, "entity"=>$marriagerow[familyID], "type"=>"F" ) ); else $persontext .= showEvent( array( "text"=>"$text[family]$marrstr", "fact"=>$spouselink ) ); $rightfbranch = checkbranch( $marriagerow[branch] ) ? 1 : 0; $marriagerow[allow_living] = !$marriagerow[living] || $livedefault == 2 || ( $allow_living && $rightfbranch ) ? 1 : 0; $fammedia = getMedia($marriagerow,"F"); if( $marriagerow[allow_living] ) { resetEvents(); setEvent( array( "text"=>$text[married], "fact"=>$stdexf[MARR], "date"=>$marriagerow[marrdate], "place"=>$marriagerow[marrplace], "event"=>"MARR", "entity"=>$marriagerow[familyID], "type"=>"F" ), $marriagerow[marrdatetr] ); setEvent( array( "text"=>$text[divorced], "fact"=>$stdexf[DIV], "date"=>$marriagerow[divdate], "place"=>$marriagerow[divplace], "event"=>"DIV", "entity"=>$marriagerow[familyID], "type"=>"F" ), $marriagerow[divdatetr] ); if( $allow_lds ) { setEvent( array( "text"=>$text[sealedslds], "fact"=>$stdexf[SLGS], "date"=>$marriagerow[sealdate], "place"=>$marriagerow[sealplace], "event"=>"SLGS", "entity"=>$marriagerow[familyID], "type"=>"F" ), $marriagerow[sealdatetr] ); } $query = "SELECT display, eventdate, eventdatetr, eventplace, age, agency, cause, addressID, info, tag, description, eventID FROM $events_table, $eventtypes_table WHERE persfamID = \"$marriagerow[familyID]\" AND $events_table.eventtypeID = $eventtypes_table.eventtypeID AND gedcom = \"$tree\" AND keep = \"1\" AND parenttag = \"\" ORDER BY ordernum, tag, description, eventdatetr, info, eventID"; $custevents = mysql_query($query) or die ("Cannot execute $query query"); while ( $custevent = mysql_fetch_assoc( $custevents ) ) { $displayval = getEventDisplay( $custevent[display] ); $eventID = $custevent[eventID]; $key = "cust$eventID"; $fact = array(); if( $custevent[info] ) { $fact = checkXnote( $custevent[info] ); if( $fact[1] ) { $xnote = $fact[1]; array_pop( $fact ); } } $extras = getFact( $custevent ); $fact = ( count( $fact ) && $fact[0] != "" ) ? array_merge( $fact, $extras ) : $extras; setEvent( array( "text"=>$displayval, "date"=>$custevent[eventdate], "place"=>$custevent[eventplace], "fact"=>$fact, "xnote"=>$xnote, "event"=>$eventID, "entity"=>$marriagerow[familyID], "type"=>"F" ), $custevent[eventdatetr] ); } mysql_free_result( $custevents ); ksort( $events ); foreach( $events as $event ) $persontext .= showEvent( $event ); $famnotes2 = ""; if( !$notestogether ) $famnotes2 = buildNotes( $famnotes, $marriagerow[familyID] ); else $famnotes2 = buildGenNotes( $famnotes, $marriagerow[familyID], "--x-general-x--" ); if( $famnotes2 ) { $persontext .= "\n"; $persontext .= "\n"; $persontext .= "\n"; $persontext .= "\n"; } } $marrcount++; //do children $query = "SELECT $people_table.personID as pID, firstname, lnprefix, lastname, suffix, nameorder, birthdate, birthplace, altbirthdate, altbirthplace, haskids, living, branch FROM $people_table, $children_table WHERE $people_table.personID = $children_table.personID AND $children_table.familyID = \"$marriagerow[familyID]\" AND $people_table.gedcom = \"$tree\" AND $children_table.gedcom = \"$tree\" ORDER BY ordernum"; $children= mysql_query($query) or die ("$text[cannotexecutequery]: $query"); if( $children && mysql_num_rows( $children ) ) { $persontext .= "\n"; $persontext .= "\n"; $persontext .= "\n"; $persontext .= "\n"; mysql_free_result( $children ); } foreach( $mediatypes as $mediatype ) { $mediatypeID = $mediatype[ID]; $persontext .= writeMedia( $fammedia, $mediatypeID ); } if( $marriagerow[changedate] || ( $allow_edit && $rightfbranch ) ) { $marriagerow[changedate] = displayDate( $marriagerow[changedate] ); if( $allow_edit && $rightfbranch ) { if( $marriagerow[changedate] ) $marriagerow[changedate] .= " | "; $marriagerow[changedate] .= "$text[edit]"; } $persontext .= showEvent( array( "text"=>$text[lastmodified], "fact"=>$marriagerow[changedate] ) ); } $persontext .= showEvent( array( "text"=>$text[familyid], "date"=>$marriagerow[familyID], "place"=>"$text[groupsheet]", "np"=>1 ) ); $persontext .= showBreak(); } mysql_free_result($marriages); $persontext .= "

$text[notes]

$famnotes2

$text[children]

\n"; $kidcount = 1; $persontext .= "\n"; while ( $child = mysql_fetch_assoc( $children ) ) { $ifkids = $child[haskids] ? ">" : " "; $birthinfo = getBirthInfo( $child ); $child[allow_living] = !$child[living] || $livedefault == 2 || ( $allow_living && checkbranch( $child[branch] ) ) ? 1 : 0; if( $child[firstname] || $child[lastname] ) { $childname = getName( $child ); $persontext .= "\n"; $kidcount++; } } $persontext .= " $ifkids $kidcount. $childname"; if( $child[allow_living] ) $persontext .= $birthinfo; $persontext .= " \n"; $persontext .= "

\n"; $persontext .= endSection("info"); if( !$tng_extras ) { $media = ""; $tableid = "media"; $cellnumber = 0; foreach( $mediatypes as $mediatype ) { $mediatypeID = $mediatype[ID]; $newmedia = writeMedia( $indmedia, $mediatypeID ); if( $newmedia ) { $media .= $newmedia; $media .= showBreak(); } } if( $media ) { $persontext .= beginSection("media"); $persontext .= "\n"; $persontext .= $media; $persontext .= "\n"; $persontext .= endSection("media"); } } if( $row[allow_living] ) { if( !$notestogether ) $notes = buildNotes( $indnotes, $personID ); else $notes = buildGenNotes( $indnotes, $personID, "--x-general-x--,NAME" ); if( $notes ) { $persontext .= beginSection("notes"); $persontext .= "\n"; $persontext .= "\n"; $persontext .= "\n"; $persontext .= "\n"; $persontext .= "\n"; $persontext .= showBreak(); $persontext .= "

$text[notes]

$notes

\n"; $persontext .= endSection("notes"); } } elseif( $row[living] ) { $notes = 1; $persontext .= beginSection("notes"); $persontext .= "\n"; $persontext .= "\n"; $persontext .= "\n"; $persontext .= "\n"; $persontext .= "\n"; $persontext .= showBreak(); $persontext .= "

$text[notes]

$text[livingnote]

\n"; $persontext .= endSection("notes"); } if( $citedispctr ) { $persontext .= beginSection("citations"); $persontext .= "\n"; $persontext .= "\n"; $persontext .= "\n"; $persontext .= "\n"; $persontext .= "\n"; $persontext .= "

$text[sources]

"; $citectr = 1; foreach( $citestring as $cite ) { $persontext .= " $cite "; $count = count($citestring); if( $citectr < count($citestring) ) $persontext .= " "; $persontext .= " \n"; $citectr++; } $persontext .= "

\n"; $persontext .= endSection("citations"); } $persontext .= "

\n"; $tng_alink = $tng_plink = $tng_mlink = "lightlink"; if( $media || $notes || $citedispctr ) { if( $tngconfig[istart] ) { if( $tng_extras ) $tng_mlink = "lightlink3"; else $tng_plink = "lightlink3"; } else $tng_alink = "lightlink3"; $innermenu = "$text[persinfo]    |    \n"; if( $media ) $innermenu .= "$text[media]    |    \n"; if( $notes ) $innermenu .= "$text[notes]    |    \n"; if( $citedispctr ) $innermenu .= "$text[sources]    |    \n"; $innermenu .= "$text[all]\n"; } else $innermenu = "$text[persinfo]\n"; echo tng_menu( "I", "person", $personID, $innermenu ); ?>
var elementcw; if( document.getElementById('info1') ) elementcw = document.getElementById('info1').clientWidth; else elementcw = document.getElementById('$firstsectionsave" . "1').clientWidth; if( !elementcw ) { elementcw = 100; elementcwadj = 92; if( document.getElementById('info1') ) document.getElementById('info1').width = elementcw; } else elementcwadj = elementcw - 8;\n"; if( $media ) $flags[more] .= "document.getElementById('media1').width = elementcwadj;\n"; if( $notes ) $flags[more] .= "document.getElementById('notes1').width = elementcwadj;\n"; if( $citedispctr ) $flags[more] .= "document.getElementById('citations1').width = elementcwadj;\n"; $flags[more] .= ""; tng_footer( $flags ); ?>