Sosa

Sosa
Summary	Marks graphically the ancestors of the root of a tree.
Validation
Mod Updated	05 Nov 2023
Download link	For TNG 13.0.1 TNG 14.0 v13.0.1.11c For TNG 13.0 TNG 12.0 v12.0.2.7e
Download stats	Show statistics
Author(s)	Michel Kirsch
Homepage	Racines luxo-hennuyeres
Mod Support	[TNG Community Forums]
Contact Developer
Latest Mod	12.0.2.7e for TNG v12 & 13.0 - v13.0.1.11c for TNG v13.0.1+
Min TNG V	13+
Max TNG V	n.c.
Files modified	admin_backup.php admin_families.php admin_optimize.php admin_people.php admin_restore.php admin_utilities.php ahnentafel.php connections.php connections-form.php customconfig.php descend.php descendtables.php descendtext.php descendvert.php desctracker.php extrastree.php familychart.php familygroup.php fan.php genlib.php getperson.php pedigree.php pedigreetext.php register.php relateform.php relationship.php search.php showreport.php verticalchart.php template10/index.php Languages: Dutch/cust_text.php Dutch-UTF8/cust_text.php English/cust_text.php English-UTF8/cust_text.php French/cust_text.php French-UTF8/cust_text.php German/cust_text.php German-UTF8/cust_text.php Spanish/cust_text.php Spanish-UTF8/cust_text.php Norwegian-UTF8/cust_text.php
Related Mods	mk parameters links
Notes

Note for all TNG version

Before installing a version 9 and above of the Mod for the first time, you have to delete/rename your extensions/sosa_vars.php file
After installing a version 10 and above of the Mod, for the first time don't forget to Adapt your environment by using the dedicated button in Mod Manager.
Be sure to be connected with YOUR userID, because all existing sosa at this time will be assigned to the current user !
Implicitly, if you upgrade from 8 to 10+ for the first time, you should apply the two recommendations above

New in Sosa 11

From version 11 onwards, Sosa offers a new feature: Missing Sosas.
This is a list that displays sosas for which there are no parents in your database (lineage heads): See screenshots.
The "Missing Sosa" feature can be compared with the Treetops List Mod, but applied to your Sosa1.
Don't forget : if you add or delete a person in your Sosa list, goto your Sosa 1 and RE designate him (her) as Sosa 1, in order to keep your sosa list up to date.

New in Sosa 11a

Now you can rule out any missing sosas that you're sure you won't find. By clicking on them, they will be rejected at the end of the list as "verified".

Foreword

FAQ : If you add or delete a person belonging to your Sosa list, you have to reconstruct your list of Sosas.
Goto your Sosa 1 and re-designate him/her as Sosa 1

Users of TNG 11 can try to use Sosa v12.0.2.6e for TNG 11 (There is no more support for this version!)

Purpose of the Mod

This Mod allows the administrator (and other users from version 10) to designate the root of his tree (SOSA No. 1).
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

Many thanks to

Ron, Ken, Scott, Jean-Louis, Rob S, Jean-Luc, Katryne for the testing, the ideas and the comments about this version !
Bart(+) for the code to delete the table before uninstall !
DeepL for some translations...

Development

Written by : MichelK from Charleroi - Hainaut - Belgium

Requirements

To avoid conflicts :
Installing this mod require the updating of the Balanced Media mod to the version 12.0.0.2
Installing this mod require the updating of the Living Color Mod mod to the version 13.0.0.23

TNG version:

≥ 12.0.2

A TNG 12.0.2+ installation (or v13+) 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:

admin_backup.php
admin_families.php
admin_optimize.php
admin_people.php
admin_restore.php
admin_utilities.php
ahnentafel.php
connections.php
connections-form.php
customconfig.php
descend.php
descendtables.php
descendtext.php
descendvert.php
desctracker.php
extrastree.php
familychart.php
familygroup.php
fan.php
genlib.php
getperson.php
pedigree.php
pedigreetext.php
register.php
relateform.php
relationship.php
search.php
showreport.php
verticalchart.php
languages/Dutch/cust_text.php
languages/Dutch-UTF8/cust_text.php
languages/English/cust_text.php
languages/English-UTF8/cust_text.php
languages/French/cust_text.php
languages/French-UTF8/cust_text.php
languages/German/cust_text.php
languages/German-UTF8/cust_text.php
languages/Spanish/cust_text.php
languages/Spanish-UTF8/cust_text.php
templates/template10/index.php
Norwegian-UTF8/cust_text.php

Mod Compatibility

• If you are using the Living Color Mod mod, you will need to upgrade to V13.0.0.23 in order to install Sosa v10+
• 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. Once Sosa is installed, you can reinstall Regroup Person Profile

Installation

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.

Parameters

The sosa mod has a special parameter update screen.
Click on the "Easy Edit - Edition facile" button in the Mod Manager to access it.
This button is also available in the Administration >> Setup section if you install the mk parameters links Mod.

UNinstallation

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.

Upgrade

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

This is very important information!

• When upgrading to version 9+ for the first time, you have to rename/delete your extensions/soa_vars.php file.
• When upgrading to version 10+ for the first time, you have to adapt your environment by using the dedicated button in the Mod Manager.

  Note that the version 9+ upgrade instructions apply to version 10+ when upgrading from version 8 or lower

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
13.0.1.11c	05 Nov 2023	- Fixed fugitive warnings about $row['living'] and $row['private'] in tng_sosa.php - Fixed warning with template 10 (index.php) - Added condition in verticalchart.php to work with the Living Color Mod - Fixed a bug that prevent the sosa to be displayed as a field in getperson.php.
13.0.1.11b	29 Sep 2023	- Fixed a warning with $row['sex'] for mono-parental families. - in missing sosa, fixed an empty generation when this generation has only implexes already displayed. (RonK) - Add a condition before declaring the insert_new_variables() function of sosa_fix_vars.php. In some cases PHP raise a Fatal Error (KenR) - if the personID on a page is not a person (first letter is different than $tngconfig['personprefix']) the menu "Designate as Sosa1" is not available.
13.0.1.11a	30 Jun 2023	- Fixed an installation bug with TNG 14.0.0. - Display instantly 20 generations (new code). - Added a functionnality that allows users to stop listing missing sosas that have already been checked. - Deleted the "sosa" and "Spouse" columns, unuseful. - Fixed a bug that prevent the last generation to be displayed in Missing Sosas (code reviewed). - Added a title for Sosa 1 - Added a notice if there are no results - Added a results line at the end of the list. - Added Czech translation (Thx to RonK)
13.0.1.11	05 Jun 2023	- Add the new feature 'Missing Sosas'
13.0.1.10b	20 May 2023	- Modify the upgrade instructions in cfg - add an global $cms for descendvert.php (Thx to Ken) - Modify the $callinpage in tng_sosa_admin.php - Fix an error when using multiple sosa with templates 19 and 21 (no way to display the tng_header for these templates) - Deleted old parameters 1 and 27 ($systembits and $sosa_negative_sosa). These are now set to default (64 and 0) in tng_sosa.php. Deleted relative stings. Updated the help file.
13.0.1.10a	29 Apr 2023	- Cosmetic changes for readability (KenR) in Mod Manager - Add an include in some forms to avoid Errors. - Review the code in genlib.php : when option 9 (NO_sosa_menu) was set to 1, tng_sosa.php was never included!(Jan-Thore). - Add a bullet into lists in descendtables.php - Review some code for coherence in including tng_sosa.php - Norsk translation by Jan-Thore Solem (Thx to JTS)
13.0.1.10	15 Apr 2023	The great change for this version is that each of your registered user can now designate its own sosa1 (Option 28 - set to No as default) For the administrator. -After the installation of the Mod, you MUST click the button "Adapt Environment". Your Sosa table will be modified (and therefore incompatible with Sosa 9B) - Additional parameter (28) to allow "users without rights" to designate their sosa1 (Default: NO), and to change the color of the sosa bullet (29) for the Sosa1 (Default : Red) - If you allow your users to designate their own sosa1 and you remove this permission after some time, users who have already designated a sosa1 will still be able to see it but will not be able to change it. - The Go to Sosa 1 menu supports sites with multiple trees. So users are offered a choice among the sosa1 of the trees they have access to. The administrator can choose between all the sosa1 defined on his site and can delete defined sosa that are no longer useful. - the sosa existing at the time of the "Adapt Environment" time are assigned to the administrator (= currentuser!!) So be sure to install the mod and adapt the environment with YOUR userID ! Visually : - a lot of pages have now their green balls, including new pages in TNG 14. (Thx to RonK) - The reports will now display the Sosa bullet if the complete name is displayed in the report. - The sosa 1 has now its own bullet color, modifiable with option 29. (Red bullet) - (see above Go to Sosa 1) - If the sosa menu cannot be used, the text is crossed out (except in the reduced menu) for example, designate as sosa 1 if you are not on a getperson.php page or list the sosas if no sosa1 has been designated for this user. - In principle, no more popup messages should appear (message "this action is not allowed in this context...") If you see one, please report it to me - Move the mouse over the green ball to see for which other user this sosa is also a sosa example : Degree 1 - Generation 2 - Sosa 2 (Sosa 4 for Céline METENS) Inside : - The sosa table is adapted: an additional field (user) is added and an index on (sosa + user) is added - If you want to go back to a lower version, you have to delete the sosa table before install a lower version of the mod.
13.0.1.9b	02 Jan 2023	Fix problem with uppercase in the folder name (9A) - Fix problem when comparing TNG version to "14".
13.0.1.9a	14 Dec 2022	Cosmetic changes for the sosa table creation. Don't use if your sosa table exists yet.
13.0.1.9	13 Nov 2022	Multiple internal modifications. Compatible TNG 13 & 14. ATTENTION :before installing this version, you must delete or rename the file sosa_vars.php in the extensions folder of your TNG installation
13.0.1.8a	02 Oct 2022	Add a condition before starting a session, so the progress-bar for import gedcom works normally in TNG 14.
13.0.1.8	30 May 2022	Reorganize parameters (ALL in sosa_vars) - Reorganize tng_sosa_admin.php (more interactive & handels ALL parameters) - Restitute the normal edit options of Mod Manager & add a button for the sosa edit options - Add a new module (sosa_fix_vars) to fix the sosa variables in $extspath/sosa_vars.php, so this must no more be done by the cfg.
13.0.1.7r	11 Apr 2022	Add a parameter to scroll directly to the current person in sosa list.
13.0.1.7q		Not promoted
13.0.1.7p	06 Apr 2022	PHP8.1+ ready.
13.0.1.7n	13 Jan 2022	Internal modifications. Better integration into CMS. Edit button leads now to the sosa's parameters sheet. Some users may have experienced problems with the uppercase in the directory name.
13.0.1.7M	04 Jan 2022	Fix two PHP8 warnings.
13.0.1.7L	19 Nov 2021	Fix a bad behaviour : The reduced menu replicated the bookmark and print menus when TNG menu = 2 (= hidden).
13.0.1.7k	06 Nov 2021	Reduced menus works now with user's file as histories.
13.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.
13.0.1.7h	02 Jul 2021	PHP8 ready
13.0.1.7g	07 Jun 2021	Modify get_degree_of() function in tng_sosa.php to avoid Fatal Type Error with PHP8
13.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)
13.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.
13.0.1.7c	28 Nov 2020	Now uses prefix (de, le, van, van der, ...)as part of the lastname.
13.0.1.7b	13 Nov 2020	Fix the fan chart problem in mobile mode.
13.0.1.7a1	29 Oct 2020	Fix a print problem when reduced menu is set to yes.
13.0.1.7a	25 Oct 2020	Compatibilty with TNG 13.0.1
12.0.2.7a	24 Oct 2020	Add some pictures in help file. LAST VERSION for TNG v12+ and 13.0
12.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.
12.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.
12.0.2.6e	19 Nov 2019	Modify code to avoid conflict with ALL others mods using own tables
12.0.2.6d	06 Nov 2019	Modify code of cfg file to avoid conflict with "Special List" Mod
12.0.2.6c	05 Nov 2019	Modify code of genlib.php to hide the sosa reduced menu from home page
12.0.2.6b	04 Nov 2019	Modify cfg file to avoid conflict with "Optional Person Row" Mod
12.0.2.6a	01 Nov 2019	Fix "call to undifened function" error in mobile mode
12.0.2.6	10 Oct 2019	Many minor code changes. Visual: 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 IMPORTANT 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.
12.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.
12.0.2.4a	23 Aug 2019	Introducing of a parallel between generation and degree of relationship.
12.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.
12.0.2.2-3	29 jun 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
12.0.2.2-2	20 Jun 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
12.0.2.2-1	16 Jun 2019	Sosa list before the TNG Menu. Big sosa list (must be open in a new tab)
12.0.2.2	14 Jun 2019	Some changes of behaviour / layout. Version number visible on sosa menu
12.0.2.1	23 May 2019	Original version.

Screenshots Sosa 11a

Sosa 11 introduce the new feature 'Missing Sosas'

Missing Sosa list is accessed via the menu. The list always opens in a new tab.

The list can search instantly over 20 generations. The number of generations to display is easily modifiable.
the verified missing sosas are diplayed at the end of the list. They can be restored with clicking on the green zone.

Snapshots

Here are some snapshots of the modified screens (there are 25 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

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
Racines luxo-hennuyeres	Michel Kirsch	Developper of the Mod	13.0.1.11b	14.0.3	FR,EN,NL,DE,SP
Treichel-Familie.de	Andreas Treichel	Public & Private	13.0.1.11c	TNG 14.0.6	DE,EN,FR,ES,PL
Ahnenforschung Joachim Drexel	Joachim Drexel	Public	13.0.1.7e	13.0.2	DE,EN
Family tree of Marcin & Emilia Senderski	Marcin Senderski	Only home page is public	13.0.1.7h	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.0.2.6c	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​.1​.11a	14.0.3	EN,FR
Surfing the Genetic Pool	Andrew DuPree	Using parts of the mod	12.0.2.4a	12.x	EN
van Heerden	Emilevh		12.0.2.6e	12.2	EN
Families Schaapkens-Salden en Kruize-Rombouts	Majohejoan		12.0.2.6e	12.1	EN,NL
Généalogie des familles Meresse et Facon	Philippe Meresse		12.0.2.6e	12.2	EN,FR,NL
GénéaKat	Katryne	Public/Private	13​.0​.1​.11b	14.0.3	FR,EN
Hooley Family Links	Lastejas		See Here	See Here	EN
memoire-familiale	Lisa		12.0.2.6e	12.2	EN,FR
Les Lapierre d'Amérique	Normand Lapierre	Public/Private	13.0.1.10a	14.0.2	FR,EN
Startseite	Tlandrock		12.0.2.6	12.0.2	EN
Site	Camfam		12.0.2.4a
Généalogie Dubuc-Landry	Roche		12.0.2.6e	12.2	DE,EN,ES,FR,IT
Herrmann genealogy pages	Unknown		12.0.2.5	12.0.2	DE,EN
A Quest For Our Ancestors	J13lthayer		12.0.2.6e	12.2	EN
WashingtonFamilyReunion	Mrlee		12.0.2.6d	12.2	EN,SP
Onze familiegeschiedenis	Petermaasnl		12.0.2.6e	12.2	EN,FR,NL
The St. John Genealogy	Suzstjohn		12.0.2.4a	12.1	EN
Local site only - Research Abell from mid-Devon	Ned Abell		12.0.2.6c		EN
Hooley Family Links	Rick Hooley	Public/Private	See Here	See Here	EN
Barta-Joggele Online aus Mauren, Liechtenstein	Gerald Meier	Private	13.0.1.9b	14.0	DE,EN,FR,ES,PT,CZ
Schuster-Pippersteiner	Ingrid Schuster	Public	13.0.1.9b	14.0	DE,EN,CS
Our Roots&Relatives	Kåre Kjøllesdal	Private site	13.0.1.11c	14.0.5	NO,EN
Scealta	Ton van Lil	Public/Private	13​.0​.1​.9b	14.0	NL,EN
La saga BIGEY	François BIGEY	Public	13.0.1.10	14.0.1	FR
Joseph Oran Holtz Genealogy Pages	Jim Holt	Private	See Here	See Here	EN
Pittsburgh O'Neils	Sean O'Neil		13.0.1.8	13.1.2	EN
The Severijns / Timmer Familytree	Rob Severijns	Public / Private - Great Mod :-)	See here	See here	NL,EN
Solem Genealogy	Jan-Thore Solem	Private	13​.0​.1​.10b	14.0.2	EN,NO
Ô mes aieux! O mijn voorouders! Ó, meus ancestrais!	Jean-Luc Halleux	Public	13​.0​.1​.11	14.0.2	FR,NL,PT,EN,ES
Auf den Spuren meiner Ahnen	Michael Klein	Public/Private site	13​.0​.1​.9b	TNG 14.0.3	EN,DE
Stammbaum der Familie Datschetzky	Christian Datschetzky	Public	13.0.1.11c	14.0.3	DE,EN