Associate names

Associate Names
Summary	Associating surnames with each other to facilitate searches
Validation
Mod Updated	06 Apr 2022
Download link	v12.3.0.2k TNG 12.0 TNG 13.0
Download stats	Show Michel's statistics
Author(s)	Michel Kirsch
Homepage	Racines luxo-hennuyeres
Mod Support	TNG Community Forums
Contact Developer
Latest Mod	v12.3.0.2k for TNG v12 & 13
Min TNG V	v12+
Max TNG V	n.c
Files modified	admin_setup.php famsearchform.php genlib.php languages/English-UTF8/cust_text.php languages/English/cust_text.php languages/French-UTF8/cust_text.php languages/French/cust_text.php search.php searchform.php searchlib.php
Related Mods	mk parameters links
Notes

Purpose of the Mod

This mod allows family names to be associated with a reference family name, so that a search on the reference name or on one of the associated names will give a result for all the associated family names.
For example, if you associate the names 'le Roy', Roy and King with the reference name "DuRoy", a search on the surname Roy will return all the 'le Roy', Roy, King and DuRoy from your database.
When viewing a person who belongs to a list of associated names, the associated names can be displayed (parameter). Each associated name is clickable separately and gives you the list concerning this name.
Support EN/FR/NL languages.

Development

Author : Michel Kirsch from Charleroi-Hainaut-Belgium

With thanks

to Katryne and Jean-Louis for their testing and patience.
to [DeepL] and Rob for some translations.

Requirements

A TNG v12.3.0 installation in working order.

IMPORTANT : Before installing

Before installing, it is judicious to make a backup copy of the files that will be modified by this mod.

TNG Modules Impacted

You can click on the [Expand] link on the right to display the list of TNG Modules change and the [Collapse] link to hide this section again.

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

admin_setup.php
famsearchform.php
genlib.php
languages/English-UTF8/cust_text.php
languages/English/cust_text.php
languages/French-UTF8/cust_text.php
languages/French/cust_text.php
search.php
searchform.php
searchlib.php

Files created/copied by this Mod

Source	Destination
associate_names/admin_assocnames.php	TNG root/admin_assocnames.php
associate_names/assoc_names.gif	TNG root/img/assoc_names.gif

INSTALLATION

• Unzip the received file directly in the "mods" sub directory of your TNG installation.
  
• Via Mod Manager, install the Mod.
  

UNINSTALLATION

The COMPLETE uninstallation requires the destruction of the 'assocname' field of the tng_people table.
A button is provided in the Mod Manager. It must be used BEFORE uninstalling the Mod.

Upgrade

• Uninstall and eventually Delete the current Mod.
• Proceed as for an installation with the new Mod.
• Your existing names associations will not be affected.

Known Problems

None at this day...

In the event of a problem

• Try using the Mod Manager Remove capability
• Copy the backup of the affected files back to your TNG directory
• Retry. If the problem persists, open an issue in the TNG Community Forums or on the page of Michel Kirsch. At worst, send a mail to

Historic of modifications

Version	Release Date	Contents
v12.3.0.2k	06 Apr 2022	Update the assocname field for a new person if needed - Danish translations by Hanne.
v12.3.0.2j	08 Jan 2022	Fix 2 PHP8 Warnings - Ready to work with a future version of the Optional Person Rows Mod
v12.3.0.2h	08 aug 2021	The link in Admin >> Setup is no more activated by this Mod. Use the new mk parameters links Mod
v12.3.0.2g	24 may 2021	Improve menu in admin_menu if Sosa and/or Menu_manager Mods are installed.
v12.3.0.2f	04 apr 2021	Modify code to avoid conflict with Simple SEO Mod.
v12.3.0.2e	03 apr 2021	The list at the beginning of the getperson.php page showed an "\" before the name. (D'\ETAIN in place of D'ETAIN).
v12.3.0.2d	09 mar 2021	With German translations (Jürgen).
v12.3.0.2c	13 feb 2021	The second name of the associated names list has a bad link (Jürgen).
v12.3.0.2b	03 feb 2021	Fixed another problem with apostrophe - The name of the current person is now in front of the associated names list - Modification at the option's text.
v12.3.0.2	08 dec 2020	The names associated with the current name can be displayed on getperson.php, in or above the form.
v12.3.0.1b	12 Aug 2020	The lists are now multi select. You can add/remove more than one name at a time.
v12.3.0.1a	10 Aug 2020	Fix problem with mysqli_fetch_all command (ISP have not installed mysqlnd module) - Fix problems with names containing apostrophes.
v12.3.0.1	07 Aug 2020	First online version.

Sites using this mod

If you download and install this mod, please add your TNG site to the table below:
If you have any problem to do it, send me a mail...

URL	User	Note	Mod-Version	TNG-Version	User-language
Stegemüller Family History	Hanne B. Stegemüller	Public site	12.3.0.2k	13.1.2	EN, DE, DA
Racines luxo-hennuyeres	Michel Kirsch	Mod's Developper	12.3.0.2k	13.1.1	FR/EN/NL/D/SP
Lignées revestoises	Katryne	Village site - Public	v12.3.0.1b	v13.0	FR/EN/D/IT
Genealogy of a Dutch East-Indies Family	Rob Severijns	Private	12.3.0.2k	13.1.1	NL, EN
GeneaKat	Katryne	Family site - private	v12.3.0.1b	v13.0	FR/EN/D/IT
Baza danych Rodziny Jarocińskich	Michał Jarociński	Non-public site	v12.3.0.2a	13.0.1	PL, EN
Genealogische Datenbank	JPB	Public site	see here	see here	DE, EN, FR
Racine d'Alsace	J-Louis Valory	Public (registration)	12.3.0.2g	13.0.3	FR
Les Lapierre d'Amérique	Normand Lapierre	Public/Private	v12.3.0.2h	v13.0.4	FR/EN

Visualization and functionning

Access the Name Association menu.
The name association interface is accessed through Admin >> Mod Manager >> Associate Names button

The name association screen.
To associate names with each other, first choose a 'Reference Name' from the list of your names.
Then, associate to this 'Reference Name' the names you choose from the list on the left.
Double-click on the chosen name or select it and move it to the list on the right using the 'right' arrow. To remove a name from the list on the right, double-click on it or select it
and move it back to the list on the left using the 'left' arrow.

A checkbox (checked by default) is added.
You can leave the box checked, even for a search on surnames that are not associated.
The only search for which you have to uncheck the box will be a search on a surname associated with others and
for which you want results ONLY on this surname, and not on the surnames associated with it.

A new option "Associated Names" is present in the dropdown menu search options for Last Names (Advanced Search for People).
Choose this option to search on all surnames associated with the one you are searching for.

A new option "Associated Names" is present in the dropdown menu search option for Last Names (Search Families).
Choose this option to search on all surnames associated with the one you are searching for.

by parameter, you can choose to display the names associated with the current name. Above the form...

... or in the form, as field. Each associated name is clickable and lead to the result of a search on this name alone.