From TNG_Wiki
Jump to navigation Jump to search
Restricted Downloads of Sosa are restricted to logged in users. If you do not have a user account on the TNG Wiki use the Request Account link to request a user account Restricted
Caution If you are having trouble downloading with the Google Chrome browser, try another browser Caution

Ambox notice.png The latest version of this mod uses the guidelines for TNG v12+ cust_text.php files. If you are using TNGv12+, and any cust_text.php file in this mod is marked with a Bad Target error, you need to update your cust_text.php files before you can install this mod. [Show instructions]

If you upgraded to TNGv12+, and did not update your cust_text.php files as instructed in the upgrade readme script, then you must use the TNG Mod Manager to update them. To do so:

  1. Go to Mod Manager, and select its "Recommended Updates" tab.
    (If the "Recommended Updates" tab is not visible, then go to the Mod Manager Options tab, select "Display Settings", and turn on the "Recommended Updates" tab.)
  2. Click the "Update" button in the "Recommended Updates" tab.
    Installed mods do not interfere with the update, and if you already have (or think you may have) run this update, it will not hurt for you to run it again.

[See details in the TNGv12 Change Impacts Article][Hide the instructions]

TNG 13.0
TNG 12.0

Summary Marks graphically the ancestors of the root of a tree.
Mod Updated 08 aug 2021
Download link v13.0.1.7j
TNG 13.0.1

TNG 13.0
TNG 12.0
Download stats Show statistics
Author(s) Michel Kirsch
Homepage Racines luxo-hennuyeres
Mod Support [TNG Community Forums]
Contact Developer MyMail
Latest Mod for TNG v12 & 13.0 - v13.0.1.7j for TNG v13.0.1 and above
Min TNG V n.c
Max TNG V 13+
Files modified


Related Mods

Purpose of the Mod

Important notice : This version doesn't work any more with TNG 11.x !
You can try to use Sosa v12.0.2.6e for TNG 11 (There is no more support for these version!)

This Mod allows the administrator to designate the root of his tree (SOSA No. 1).
Then the users can trace the lineage of your SOSA 1 through all forms of TNG.
The ancestors of the SOSA 1 are then identified by a green ball. When hover the mouse on it, show the generation/degree and sosa number(s).
The Mod also gives you a list of all SOSA

It is based on Sosa-Stradonitz's numbering, also called Eizinger's method or Ahnentafel numbering
Update 6f : If a child belongs to two families (biological and adoptive) the biological family is followed IF the parents are marked as birth parents.

Many thanks to

Ron, Ken, Scott, Jean-Louis for the testing, the ideas and the comments about this version !
Bart for the code to delete the table before uninstall !
Google for some translations...


Written by : [MichelKirsch] from Charleroi - Hainaut - Belgium


To avoid conflicts :
Installing this mod require the updating of the Balanced Media mod to the [Balanced Media]] version]

TNG version: 12.0.2

A TNG 12.0.2+ installation (or v13.0.1) in working order.
This version doesn't work any more with TNG 11.x !

IMPORTANT : Before installing

If you use the Regroup Person Profile Mod, you MUST first uninstall it BEFORE installing Sosa. After installation of Sosa, you can reinstall Regroup Person Profile.
Before installing, it is important 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:



Mod Compatibility

  • There is currently a known Sosa v12.0.2.2 rev3 compatibility issue with the Census Plus International mod version v12.0.0.10.
    Census Plus International v12.0.0.10a fixes the PHP 7.1 issues caused by the Sosa v12.0.2.2 rev3 mod
  • If you are using the Balanced Media mod, you will need to upgrade to V12.0.0.2 in order to install Sosa v12.0.3.3
  • If you are using the Regroup Person Profile Mod, you MUST first uninstall it BEFORE installing Sosa.


Unzip the received file directly in the "mods" sub directory of your TNG installation.
You do not have to create the table manually. It is created automatically at the first execution.
On the other hand for the uninstall, it is necessary to follow the instructions in order to erase
the sosa table and the sosa_vars file become useless.

drop table button


When upgrading to a higher version.

  • Uninstall and Delete the current Mod. It is not necessary to delete your table sosa_tng, EXCEPT if it is expressly explained in the release notes!
  • Proceed as for an installation with the new Mod
  • When upgrade from version lower than 6 to version 6 or higher. If you have many multiples sosas, the display of the sosa list is not complete (limited to 256 characters for multiple sosa). To show completely all your multiple sosa, YOU MUST delete or rename your sosa table (tng_sosa). To rename it, you can use the easy edit button after the install. After rename or delete of the table, you must redesignate your sosa 1 !

Known problems

  • Large databases with many multiple sosa (many marriages between cousins) can result in a MySQL timeout when designating sosa 1. increase the limits on the server. Contact me.
  • User may take attention to run minimum PHP version = 5.6

In the event of a problem

  • Try using the Mod Manager Remove capability
  • Open an issue in the [TNG Community Forums]
  • Copy the backup of the affected files back to your TNG directory

Revision History

Version Release Date Contents
v13.0.1.7j 08 aug 2021 The link in Admin >> Setup is no more installed by this Mod. Use the new mk parameters links Mod.
v13.0.1.7h 02 jul 2021 PHP8 ready
v13.0.1.7g 07 june 2021 Modify get_degree_of() function in tng_sosa.php to avoid Fatal Type Error with PHP8
v13.0.1.7f 24 may 2021 Minimal menu improvement if Menu_manager and/or Associate_names mods are installed - Setting to no longer display any Sosa menus if the user has their own menu system. (only available via the Mod Manager's "Edit" button)
v13.0.1.7e 18 mar 2021 Some installations are displaying the SOSA after the birth info - Add code to avoid that a user without rights can edit the sosa parameters.
v13.0.1.7c 28 nov 2020 Now uses prefix (de, le, van, van der, ...)as part of the lastname.
V13.0.1.7b 13 nov 2020 Fix the fan chart problem in mobile mode.
V13.0.1.7a1 29 oct 2020 Fix a print problem when reduced menu is set to yes.
V13.0.1.7a 25 oct 2020 Compatibilty with TNG 13.0.1
V12.0.2.7a 24 oct 2020 Add some pictures in help file. LAST VERSION for TNG v12+ and 13.0
V12.0.2.7 15 sep 2020 Installs on both tng12 & 13. Add a parameter to distribute the sosa sub-menus between Infos, Search and personnal menu.- Modify code to avoid conflict with "Simple SEO" Mod. - Sosa menu is now only visible for a connected user.
V12.0.2.6f 15 sep 2020 Sosa takes into account the biological family if the child has been adopted. - Modify code to avoid conflict with "Regroup Person Profile" Mod.
V12.0.2.6e 19 nov 2019 Modify code to avoid conflict with ALL others mods using own tables
V12.0.2.6d 06 nov 2019 Modify code of cfg file to avoid conflict with "Special List" Mod
V12.0.2.6c 05 nov 2019 Modify code of genlib.php to hide the sosa reduced menu from home page
V12.0.2.6b 04 nov 2019 Modify cfg file to avoid conflict with "Optional Person Row" Mod
V12.0.2.6a 01 nov 2019 Fix "call to undifened function" error in mobile mode
V12.0.2.6 10 oct 2019 Many minor code changes.


  • Add a special sosa marker for implexes (multiple sosas). This marker is present even if you choose not to mark ALL ancestors.
  • Added sosa marker in descend.php, ahnentafel.php, extrastree.php and register.php. The sosa info is available in fan.php (ascending wheel).
  • Adding the sosa marker to the search result.
  • You can choose another menu form than the TNG button. Set the "Display full sosa menu" parameter on "No".

Comfort :

  • Easier parameter editing thanks to a dedicated page. In the Mod Manager, use the "Easy edit - Edition facile" button instead of the "Edit" button of the Mod Manager. This function is also accessible from the "Configurations" menu in the Administration section. A complete help file is available from the parameter editing page.
  • Automatic update of the preserved variables file


  • If you have many multiple sosa, the display of the sosa list is truncated after 256 characters. YOU MUST delete or rename your sosa table (tng_sosa). To rename it, you can use the parameters editor after installation. After deletion or renaming, you must redefine your sosa 1!
  • If you are using a 32-bit system, go to the settings page and change "Number of bits..." from 64 to 32.
V12.0.2.5 10 sept 2019 TNG compliance of the sosa list (display of names, colors, fixed titles, stripes every x lines).
Ability to choose the display of Degree of relationship or Generation (or both, or none) in the sosa list and in the sosa marker.

WARNING!! if you make an upgrade of a version below v12.0.2.4d, before installing this version, you must delete or rename the file sosa_vars.php in the extensions folder of your TNG installation, in order to benefit from the new features.

V12.0.2.4a 23 aug 2019 Introducing of a parallel between generation and degree of relationship.
V12.0.2.4 20 aug 2019 Code and philosophy of the program are changed to permits a better integration into TNG and another existing. Details of new functionnality are to be found into the sosa vxxx.cfg file.
V12.0.2.2-3 29 june 2019 Optimize for 64 bits systems - The old table sosa must be deleted at uninstall of earlier version - Variables to change colours of sosa list - Marks parents in getperson.php - Marks child having a sosa in the siblings of current person (Show Siblings installed)- Choice between fake sosa(= -1) or negative sosa when trespassing PHP_INT_MAX limit
V12.0.2.2-2 20 june 2019 Upgrade for 64 bits systems - The old table sosa must be deleted at uninstall of earlier version - New algorithm to compute sosa - Sosa Icon
V12.0.2.2-1 16 june 2019 Sosa list before the TNG Menu. Big sosa list (must be open in a new tab)
V12.0.2.2 14 june 2019 Some changes of behaviour / layout. Version number visible on sosa menu
V12.0.2.1 23 may 2019 Original version.

Sites using this mod

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

URL User Note Mod-Version TNG-Version User-language
Ahnenforschung Joachim Drexel Joachim Drexel Public 13.0.2 DE, EN
Racines luxo-hennuyeres Michel Kirsch Developper of the Mod 13.0.1 FR/EN/NL/D/SP
Family tree of Marcin & Emilia Senderski Marcin Senderski Only home page is public 13.0.4 EN, PL
Roots & Relatives Remembered Ron Krzmarzick Public & Private See Here See Here EN,DE,CS
Racine d'Alsace J-Louis Valory Public- private - T17 customized 12.1 FR
Our Roy and Boucher Family Ken Roy New multi-sosa bullet was a nice addition in v12.0.2.6 13.0.4 EN, FR
Surfing the Genetic Pool Andrew DuPree Using parts of the mod 12.x EN
van Heerden Emilevh v12.0.2.6e 12.2 EN
Families Schaapkens-Salden en Kruize-Rombouts Majohejoan v12.0.2.6e 12.1 EN/NL
Généalogie des familles Meresse et Facon Philippe Meresse v12.0.2.6e 12.2 AN/FR/NL
Ma Tribu Katryne v12.0.2.6 FR
Hooley Family Links (v1230) Lastejas v13.0.1.7f 13.0.3 EN
memoire-familiale Lisa v12.0.2.6e 12.2 EN/FR
Les Lapierre d'Amérique NLapierre v12.0.2.6e 12.3 EN/FR
Startseite Tlandrock v12.0.2.6 12.0.2 EN
Site Camfam v12.0.2.4a
Généalogie Dubuc-Landry Roche v12.0.2.6e 12.2 AL/AN/ES/FR/IT
Herrmann genealogy pages Unknown v12.0.2.5 12.0.2 DE/EN
A Quest For Our Ancestors J13lthayer v12.0.2.6e 12.2 EN Mrlee v12.0.2.6d 12.2 EN/SP
Onze familiegeschiedenis Petermaasnl v12.0.2.6e 12.2 EN/FR/NL
The St. John Genealogy Suzstjohn v12.0.2.4a 12.1 EN
Local site only - Research Abell from mid-Devon Ned Abell --- EN
Hooley Family Links Rick Hooley Public/Private See Here See Here EN
Barta-Joggele Online aus Mauren, Liechtenstein Gerald Meier Private 13.0.4 DE, EN, FR, ES, PT
Schuster-Pippersteiner Ingrid Schuster Public 13.0.2 DE, EN, CS
Our Roots&Relatives Kåre Kjøllesdal Private site 13.0.4 NO / EN
Scealta Ton van Lil Public/Private 13.0.2 NL, EN


Here are some snapshots of the modified screens (there are 16 screens modified by Sosa) :

EN - Explanations Image
Main page (getperson.php)

A green ball indicates that this person is in the lineage. His sosa number is revealed by passing the mouse over the green ball.
The spouse and descendant in the lineage are marked with a green ball as well.
A new menu appears in the menu bar. If you use already a custom menu, sosa menu is placed beyond.
The menu can be dispalyed in 3 different ways, depending of your working environment. It offers the following options:
For all: Go directly to sosa N° 1 [Go to Sosa 1], list of sosas [Sosas List], the same to be open in a new tab, and access to a web site about sosa numbering
For the administrator of the site: possibility of designating the current person as sosa N ° 1 [Designate as sosa 1]
If you have several trees, you can designate one sosas N¨1 per tree.

Sosa Menu
Sample list of sosa:

The list starts at sosa 1 (generation 0) until the end of your lineage
The list includes: the generation, sosa number, full name, ID of the person with him (her) possible multiple sosas
The current person and people with multiple sosa numbers are highlighted (colour choice in parameters).

Sosa List
The same list with some multiple sosas. All colours can be modified in mod's parameters.
Sosa List with Implex
All the reports of descent are provided with their sosa marker (the green bullet)next to people of the lineage, possibly with their multiple sosa

Here's an example with implex (multiple sosas) to A-A-grandparents.

Descend Compact
Here's the descend tree in text mode (descend.php)
Descend Text
The sosa marker is also present in the search results...
Search Result
... and in every others graphical representations of your tree (here in desctracker.php)
arbre sosa