Same Person Link

Same Person Link
Summary	Adds a Same Person Link row to the Personal Information section of the Individual page (getperson.php)
Validation	Mod is XHTML compliant.
Mod Updated	16 December 2022
Download link	for TNG 14.0 TNG 13.0 same_person_link_v13.0.0.7b.zip for TNG 12.0 same_person_link_v12.0.0.5.zip for TNG 11.0 same_person_link_v11.0.0.3.zip Language Files for older versions French Language file Dutch Language file German Language file PortugueseBR Language file [Show Previous Versions] for TNG 10.1.0 same_person_link_v10.1.0.5a.zip if using Simple SEO mod for TNG 10.1.0 same_person_link_v10.1.0.5.zip for TNG 10.0.3 same_person_link_v10.0.3.3.zip for TNG 10.0 same_person_link_v10.0.0.1.zip Language files are same as V9 for TNG 9.1 same_person_link_v9.1.0.6.zip [Hide Previous Versions]
Download stats	View download counts View Multi-Tree mods statistics
Author(s)	Ken Roy with help from Mike Bluett, Bart Degryse, and Roger Moffat
Homepage	Same Person Link (this page)
Mod Support	TNG Community Forums
Contact Developer	TNG Community Forums
Latest Mod	13.0.0.7b for TNG V13+ 12.0.0.5 for TNG V12+ 11.0.0.3 for TNG V11 10.1.0.5a for TNG V10.1 if using Simple SEO mod 10.1.0.5 for TNG V10.1 10.0.3.3 for TNG V10.0.3 10.0.0.1 for TNG V10 9.1.0.6 for TNG V9.1-v9.2.2
Min TNG V	9.1.0
Max TNG V	14+
Files modified	See TNG Modules Impacted
Related Mods	Tree ID Mod
Notes	Requires creation of the Same Person Link table

Introduction

Since TNG does not support merging individuals from one tree into another tree, the Same Person Link mod was developed to show the connections. A Same Person Link is a record that shows two people as the same person:

• in a different tree on the same TNG site - in this case the reciprocal link will be automatically displayed when viewing the person in the other tree
• on a different TNG web site
• or on a different non-TNG web site.

External site links are not restricted to TNG sites only but can be created to any other web site that contains information on the person.

Same Person Links

You can create Same Person Links to

• a personID in another tree on your own web site
• a person on another web site

When linking to a personID in another tree on your own web site, the easiest way to find the needed personIDs is to use the Find Person dialog within the Same Person Link dialogs. You can also use the Search People dialog. To make it easier to find the needed information, you might want to install the Tree ID Mod which adds the treeID to the search results.

Restrictions

Note that when creating Same Person Links to another tree on your site, there is only one record created in the database table. You can only edit Same Person Links between two people from the Source person, but not from the Target person. If you are editing the person a Same Person Link points to you will not be able to edit that link from that Target person.

For example, Person 1, Tree 1 is linked to Person 2, Tree 2. The link was set up from person 1's page and the link details are obtainable by clicking on the "same person link" (which is highlighted by a green dot). Now, if we go to the corresponding Person 2 page, no link is indicated.

Therefore you should probably create your Same Person Links from the same tree so as to not get confused.

If you have the same person in multiple trees on your site, it will require that you create multiple Same Person Links as well as create them from tree 2 pointing to the same person in tree 3, 4, etc.

Deleting a Person With Links Assigned

When deleting person's who have same person links assigned,

1. At first, delete the same person link, and
2. then the person.

Otherwise the same person link remains as orphan link in the database. If possible, set Setup >> Configuration >> General Settings >> Re-use deleted IDs to "No" to avoid that possible orphaned Same Person Links will be automatically re-assigned to newly created persons.

Known Problems

If your site is still setup using a TNG charset of ISO-8859-? with a latin1 encoded database, the AJAX dialogs used in this mod will mangle the accents used in names and links.

I have not found a way to fix this problem and so am indicating that the mod is supported only in UTF-8 environments (unless you do not use any accents). See Changing to UTF-8 on how to convert your ISO-8859-? and latin1 database to a UTF-8 environment

Developer

Mod developer is Ken Roy with extensive help from

Mike Bluett to debug the AJAX dialogs,

Bart Degryse to get the Same Person Link table changes borrowed his Persistent Bookmarks mod working correctly,

Several beta testers, especially Roger Moffat who updated the Help screen, tweaked the External Link display sentence, and helped convert the mod to Same Person Link to better describe its functionality

Danish translations provided by Mogens C. Fenger

German and PortugueseBR translations provided by Carlos A. Heuser

Revision History

Mod Version	Date	Contents
13.0.0.7b	17 Dec 2022	updated to eliminate PHP Notice: Undefined variable: newtable on first time install. If table is already created there is not need to update to this version.
13.0.0.7a	6 Jun 2021	updated to eliminate the Install depdendency with the Make associations sortable mod. Our thanks to Michel Kirschr for providing the mod change
13.0.0.7	2 Nov 2020	updated to prevent Same Person Link table from being created with the wrong collation sequence and position for MySQL 8. Our thanks to Brent Hemphill for providing the code eliminate PHP warnings and notices in PHP 7.4+
13.0.0.6	23 Sep 2020	updated for new TNG v13
12.0.0.5	9 Feb 2019	updated for new TNG v12 custom text file standards
11.0.0.3	16 Apr 2016	Remove some mods to admin_genconfig.php to resolve the warning issued when saving the General Settings. Fixed the code to create the Same Person Link table for first time installs.
11.0.0.2	9 Apr 2016	Fixed for first time installs using Mod Manager. There are no coding changes, so if you have installed V11.0.0.1, just download V11.0.0.2 to have the latest version and save it in your mods folder. It will show installed. Then delete the v11.0.0.1 file.
11.0.0.1	23 Mar 2016	Fixed the typo in one of the copy statements in V11.0.0.1
11.0.0.0	7 Mar 2016	Updated for TNG 11.
10.1.0.5a	2 Nov 2015	Only cfg file was updated to resolve a conflict introduced by the Simple SEO mod. There were no code changes made in subfolder modules so it was not updated to expedite posting of this new version. If you do not use the Simple SEO mod, there is no need to upgrade to this version of the mod.
10.1.0.5	25 Jan 2015	Updated for TNG 10.1. Changes required in creating new Same Person Link table, if one did not exist.
10.1.0.4	11 Jan 2015	Updated for MySQLi changes and Mod Manager updates in TNG 10.1
10.0.3.3	23 Aug 2014	Updated for Mod Manager Upgrade testing targeted for TNG v10.0.3
10.0.0.1	28 Apr 2014	Updated to remove the hard-code tng_trees table and to provide values for Not Null fields required by MySQL 5.5 Changes were provided by Ian Fettes
10.0.0.0	6 Feb 2014	Updated for TNG V10 table layout change in Admin >> Setup >> General Settings
9.1.0.6	26 Jan 2013	Fix problem where mysql_free_result was not within the if statement checking for Living or Private on Living and Private pages when not logged in
9.1.0.5	25 Jan 2013	renamed the mod to Same Person Link fixed the Edit dialog to update the Same Person Link Tree ID and Same Person Link Tree Name fields in the database and in the Same Person Link list dialog added Help file to the zip file package, includes extensive re-write of the help file by Roger Moffat increased the size of the Same Person Link Name field added 2 new fields to support External site links to other than TNG sites - External Tree Name (optional) and External Site Name changed the URL to be the complete URL. For an external TNG site this includes the getperson.php?personID= and tree= to position directly to the person increased the size of the Same Person Link Note field
9.1.0.4	15 Jan 2013	Added Edit parameter to control whether Same Person Links open in a separate window (defaults to No) Fixed Add Same Person Links dialog so that the TreeID and Treename for the first tree in the pull down list is already primed
9.1.0.3	14 Jan 2013	Initial beta test release of the mod for TNG 9.1
9.1.0.2	15 Dec 2012	Initial test version of the mod for TNG 9.1 was never released
9.0.0.1	5 Oct 2012	Initial test version of the mod was never released
9.0.0.0	6 Jun 2012	Initial version of the mod was never released since you had to manually create the table entries

Automated Install

1. Download the appropriate mod version from the status box above.
2. Extract the zip file into your /mods folder (unzip the .zip file and upload the same_person_link_v9.x.x.x.cfg file and the same_person_link folder to your site's /mods folder.)
3. Follow the normal automated installation for Mod Manager, as shown in the example Mod Manager - Installing Config Files

Upgrade to new version

1. Remove the existing same_person_link.cfg
2. Install the new version of the mod using the Automated Install procedure

First Time Post Installation

The following apply to first time install only.

TNG version:

≤ 10.1.3

• In TNG V10.1.3 and before, use Admin >> Setup >> General Settings >> Table Names to create the tng_sameperson table by clicking the Create button after installing the Same Person Link mod

once the Same Person Link table (tng_sameperson) is created the button is changed to Rename in the mod versions prior to TNG V11

TNG version:

≥ 11.0.0

• In TNG V11 and after,

1. Use the Mod Manager Create Same Person Table button to create the required tng_sameperson table after installing the Same Person Link mod

If you forget to create the Same Person Link table, when you access an individual page, you will get an error from the new same person links query added to getperson.php

2. If you want the Same Person Links on your own site to open in a new window, go to the Mod Manager and using Edit Option change the option from N to Y

3. You must do a force page reload after installing the mod to get the updated selectutil.js file. See Bypassing Browser Cache

Custom Text Additions

Note that config file only includes the English language changes, so if you support multiple languages you will need to modify the config file to add the custom text for those other languages.

The following custom text will be added to your English/cust_text.php file by this mod. If you are using other languages, you must add these lines to each of your language cust_text.php files with appropriate translations of course.

// Same Person Link  default localization for table maintenance
$admtext['sameperson'] = 'Same Person Link';
// Same Person Link(s) default localization
$admtext['samepersonlinks'] = 'Same Person Link(s)';
$admtext['entersamepersonID'] = "Please enter the Person ID for the same person link.";
$admtext['entersamepersontreeID'] = "Please enter the Tree ID for the same person link.";
$admtext['entersamepersontreename'] = "Please enter the Tree Name for the same person link.";
$admtext['entersamepersonwebsite'] = "Please enter the web site URL for the same person link.";
$admtext['enterabssamepersonname'] = "Please enter the Person Name for the external link.";
$admtext['enterabssamepersontreename'] = "Please enter the Tree Name for the external link.";
$admtext['enterabssamepersonsitename'] = "Please enter the Site Name for the external link.";
$admtext['enterabssamepersonwebsite'] = "Please enter the web site URL for the external link.";
$admtext['confdeletesameperson'] = "Are you sure you want to delete this same person link?";
$admtext['linkfromtree'] = 'Links from this person';
$admtext['linktype'] = 'Type';
$admtext['linktotree'] = 'Links to same person';
$admtext['samepersontree'] = 'Same Person Link(s)';
$admtext['samepersonid'] = 'Same PersonID';
$admtext['samepersontreeid'] = 'Same Person Tree ID';
$admtext['samepersontreename'] = 'Same Person Tree Name';
$admtext['samepersonwebsite'] = 'External Site URL';
$admtext['modifysamepersontree'] = 'Modify Same Person Links:';
$admtext['addnewsamepersontree'] = 'Add Same Person Links:';
$admtext['changestosamepersons'] = 'Changes to Same Person Links';
$admtext['samepersonselecttreeid'] = ' or Select Tree from list';
$admtext['findsameperson'] = 'Find person in other Tree';
$admtext['revlink'] = 'Rev';
$admtext['reverselink'] = 'Reverse Link';
$admtext['linkexternal'] = 'Create as an external link to another site';
$admtext['extsameperson'] = 'External Link';
$admtext['extlink'] = 'Ext';
$admtext['samepersonnote'] = 'Same Person Note';
$admtext['samepersonname'] = "External Person Name";
$admtext['samepersonexttreename'] = 'External Tree Name';
$admtext['samepersonsitename'] = "External Site Name";
$admtext['samepersonhdrpersonid'] = 'Person<br />&nbsp;ID';
$admtext['samepersonhdrtreeid'] = 'Tree<br />&nbsp;ID';
$admtext['samepersonextnote'] = 'External Link Note';
$text['sameperson'] = 'Same&nbsp;Person&nbsp;Link';
$text['samepersonis'] = 'This person is also ';
$text['samepersonin'] = ' in the ';
$text['samepersonmysite'] = ' tree on this site';
$text['samepersoninext'] = ' in the tree ';
$text['samepersonat'] = ' at ';

You can download the French language file for an example of how to construct the language file config file for your other languages.

Overriding Custom Text

If you would prefer that the Individual (getperson.php) page displays a different row heading and a slightly different sentence, you could install a custom mod after installing the Same Person Link mod to override some of the custom text variables. This technique eliminates the Clean Up error you get on the Mod Manager screen caused by manually changing the $text variable values. For example, the following is a sample mod that would accomplish this without having to modify the Same Person Link mod source and show both mods as installed.

%name:Same Person Link - mine%
%version:v9.1.0.5%
%description:This  mod overrides some of the text variables for the Same Person Link row  to the Personal Information section on the Individual page  (getperson.php). <br /><br />
Mod developer is Ken  Roy.  For additional details see <a  href="http://tng91beta.royandboucher.com/wiki/index.php?title=Same_Person_Link"  target="_blank">Same Person Link</a><br /><br />%

%target:languages/English/cust_text.php%
%location:%
?>
%end:%
%insert:before%
// Same Person Link - my overrides
$text['sameperson'] = 'Links&nbsp;to';
$text['samepersonis'] = '';
$text['samepersonat'] = ' on the following web site ';
%end:%

%target:languages/English-UTF8/cust_text.php%
%location:%
?>
%end:%
%insert:before%
// Same Person Link - my overrides
$text['sameperson'] = 'Links&nbsp;to';
$text['samepersonis'] = '';
$text['samepersonat'] = ' on the following web site ';
%end:%

The resulting display after installing the override mod would then be

Visualization

Visitor

The Same Person Link mod adds a new row on the person Individual page for each same person link that is created. You can create a link to another tree on your own site, or a link to a cousin's TNG site, or to any web site that contains information on the person.

Administrator

The TNG Administrator can use the Same Person Link dialog from the Edit Person page, to add a same person link to another tree on their own site, a link to a cousin's TNG site, or a link to any other web site that contains information on the person.

Add Same Person Link

When you first access the Same Person Link dialog, TNG will put you in the Add Same Person Link dialog.

The default is to automatically create a record that provides the reciprocal link from the other tree on your site back to this person, unless you check the box to Create as an external link to another site Select the Tree ID and Tree Name from the pull down selection list
click the Find icon to get to the Find Person ID and then Enter the last name and first name for the person in the Find dialog boxes click the link for the correct person to add the PersonID to the Same Person PersonID
If you click the box to Create as an external link to another site you must enter the External Person Name External Tree Name (optionally) External Site Name External Site URL, which for another TNG site needs to be the complete URL including the getperson.php?personID= and tree= parameters to position directly to the person External Link Note (optionally)

Same Person Link List

When you click Save, the Same Person Links list will be displayed.

Edit Same Person Link

You can Edit the Same Person Link

Delete Same Person Link

or delete an existing link.

Finding Candidates

You can use the People Search to find candidates that can be cross linked across trees.

Shown with the Tree ID Mod installed

A people search will also reveal merge candidates

Sites using this mod

If you download and install this mod, please add your TNG site to the table below:

URL	User	Note	Mod-Version	TNG-Version	User-language
Our Acadian, French-Canadian, and Maine Ancestors	Ken Roy	Link to another tree and Link to another TNG site	13.0.0.7b	TNG 14.0.4	EN, FR
Clan Moffat Genealogy Online	Roger Moffat	Robert Moffat links from Clan Moffat Genealogy to Clan Moffat UK	10.0.0.0	10.0.0	EN
Mitchell Families Online	Roger Mitchell	Sample page not available (Living Persons)	9.1.0.6	9.1.1	EN
Our Family Histories	Bryan S. Larson	William Draper, Jr. links from my site to GenMayle.com	10.0.0.0	10.0.0	EN
Nordic Ancestry	Mogens C. Fenger	Translated into Danish	10.0.0.1	10.0.1	EN, DA
Bush Family Genealogy	Chuck Bush	Linked my tree to my wife's tree, same webhost different domains	9.1.0.6	9.1.1	EN
Jessen Family Genealogy	Chad Jessen	Landmark, Gulbrand Tomasson links to a tree on Ancestry.com	9.1.0.6	9.1.1	EN
Steve's Family Tree	Steve Overton	Link individuals between trees as well as other TNG sites.	10.0.0.0	10.0.0	EN
Brazilian-German family trees	Carlos A. Heuser	Link individuals between trees as well as other TNG sites.	9.1.0.6	9.1.1	EN DE PT-BR
Kemp(e) Family History	Andrew Kemp		see Andrew Kemp	see Andrew Kemp	EN
Norwegians of Dodge & Olmsted Counties, Minnesota	Sam Clark	Link to another tree	9.1.0.6	9.2.2	EN, NO, DA, DE, NE
Hooley Family Links	Rick Hooley	Public/Private	See Here	See Here	EN
DJCM.DK	Claus Martinussen	Link individuals between trees	10.1.0.5a	10.1.3	DA, EN
Brady Family Tree in Western Australia	Darryl Brady	Public site	10.1.0.5	10.1.1	EN, DE
Luithlenfamilie	Ingo Wagner	Not a Public site	11.0.0.3	11.1.2	DE, EN, NO, FR
Families all over the World	Hans Weebers	Public/Private	11.0.0.1	11.0.0.0	NL/DE/ENG/FR
OurLife Family History - McMullen Clan	Sean Thompson	Not a public site.	11.0.0.3	11.1.0	EN
Koufos Family History	Stephen Koufos		11.0.0.3	11.0.2	EN, DE, GR, PO
Bartlett, Lorenz, McCown, McMahan and Sherman Families	Sheryl Perry		11.0.0.3	11.0.2	EN
Martius family	Hendrik Martius	Half public	11.0.0.3	12.0.3	DE, EN, FR, NL
Schuster-Pippersteiner	Ingrid Schuster	Public site / Translated into German and Czech	13.0.0.7b	14.0	GE, EN, CZ
Racines Luxo-hennuyères	Michel Kirsch	Public site (registration)	13.0.0.6	13.0.3	FR/EN/GE/DU/ES
Joseph Oran Holtz Genealogy Pages	Jim Holt	Private	See Here	See Here	EN
Kielakowie.com	Janusz Kielak	Public site	13.0.0.7a	14.0.1	PL, EN, DE

Same Person Link Examples

The following are some Same Person Link examples

• Nicolas Roy links from Antoine Roy tree to Nicolas Roy tree on same web site
• Jacob Bourgeois links to Jacques (Jacob) Bourgeois) on another TNG User site
• Robert Moffat links from Clan Moffat Genealogy to Clan Moffat UK tree

TNG Modules Impacted

The following TNG Modules are modified, and should be backed up prior to installing this mod:

• customconfig.php
• admin_backup.php
• admin_optimize.php
• admin_restore.php
• admin_utilities.php
• admin_genconfig.php
• tabledefs.php
• admin_modmanager.php
• getperson.php
• personlib.php
• tngdblib.php
• admin_editperson.php
• ajx_editperson.php
• eventlib_js.php
• js/selectutils.js
• css/genstyle.css
• your languages cust_text.php file(s)

The following modules are added by this mod:

• admin_addsameperson.php
• admin_samepersonlinks.php
• admin_deletesameperson.php
• admin_editsameperson.php
• admin_maketable_sameperson.php
• admin_removetable_sameperson.php
• admin_updatesameperson.php
• upgrade_sameperson.php
• languages/English/sameperson_help.php