Living Flag Backup / Restore

Living Flag Backup / Restore
Summary	Provides a backup and restore of the Living flags that are set in the tng_peoples table.
Validation	Admin application not validated.
Mod Updated	27 Dec 2022
Download link	for TNG 14.0 living_flag_backup_v14.0.0.10.zip for sites that require a port TNG 13.0 living_flag_backup_v13.0.0.9.zip for TNG 13.0 living_flag_backup_v13.0.0.8.zip for TNG 12.0 living_flag_backup_v12.0.0.3.zip for TNG 11.0 living_flag_backup_v11.0.0.0.zip French Language Files [Show older versions] for TNG 10.1.0 living_flag_backup_v10.1.0.1.zip for TNG 10.0 living_flag_backup_v10.0.0.0.zip for TNG 9.0 living_flag_backup_v9.0.0.1.zip French Language Files for TNG 8.0 living_flag_backup_v8.1.1.zip for TNG 7.0 living_flag_backup_v2.1.zip Download backupLiving.php V2.0 [Hide old versions]
Download stats	View download statistics for Living Flag Backup/Restore for Living Flag mods group
Author(s)	Ben Wagner Ken Roy developed config file and supports the mod
Homepage	Living Flag Backup / Restore
Mod Support	TNG Community Forums
Contact Developer	TNG Community Forums
Latest Mod	14.0.0.10 for TNG V14+ 13.0.0.9 for TNG V13+ 12.0.0.3 for TNG V12+ 11.0.0.0 for TNG V11 10.1.0.1 for TNG V10.1 and up 10.0.0.0 for TNG V10 and up 9.0.0.1 for TNG V9 8.1.0 for TNG V8 2.0 (2.1 config file) for TNG V7
Min TNG V	7.0.0
Max TNG V	14+
Files modified	See TNG Modules Involved
Related Mods	Living Flag Mod
Notes	Only available to System Administrators.

Introduction

This mod provides a backup and restore of the Living flags that are set in the tng_peoples table. It is designed to be used as a backup before doing an import gedcom and then used to restore the manually set living flags that were dropped during the import process.

Developer

This mod was developed by Ben Wagner

Ben Wagner developed the Backup and Restore Living Flag Add-ons. For a description check the Backup / Restore Living flag script created by Ben Wagner that will backup and restore living flags Backup Living Script in the TNG Community Forums.

Config files were created by Ken Roy, who also updated the mod for TNG V8, V9, v10.1, v11, v12, v13, and v14

Requirements

• A working TNG installation. The automated installation release was initially tested at TNG Version 7.1.0. Manual installation previously anchored in the Admin Header Mod on TNG 6 and 7.
• A backup of the TNG files
• A TNG database that contains Living flags (do not attempt to use if you do not have any Living flags set in your database)

Revision History

Version	Date	Contents
V14.0.0.10	27 December 2022	Published the v10.0.0.10_rc version to support the new Store in Config Path option for backups
V14.0.0.10_rc	20 December 2022	Updated to support the new Store in Config Path option for backups
V14.0.0.10_b112	7 December 2022	Updated for new Admin screen design. Our thanks to Michel Kirsch for his help in updating the admin page look and feel.
V14.0.0.10_b101	10 September 2022	Updated for new Admin home page to also show living counts from database and backup file. Our thanks to Brent Hemphill and Michel Kirsch for their help with displaying the counts.
V13.0.0.9	15 May 2022	Updated to pass the database port and socket on the tngconnect to the database. Problem encountered when testing MySQL 8 on ICDSoft host which requires a port and socket information to access MySQL 8 when their primary MySQL server is still MySQL 5.7.36. Tested on PHP 8.1.3 and MySQL 8.0.26
V13.0.0.8	15 Mar 2022	Our thanks to Michel Kirsch for providing the code changes to eliminate PHP 8.1.1 errors: Trying to access array offset on value of type null Deprecated: trim(): Passing null to parameter #1 ($string) of type string Tested on PHP 8.0.8 and PHP 8.1.1
V13.0.0.7	26 Oct 2021	Return Admin Login screen on direct URL calls if not logged in with appropriate rights
V13.0.0.6	25 Jun 2021	to prevent direct URL call by users who do not have TNG Admin rights code changed provided by Brent Hemphill
V13.0.0.5	16 Mar 2021	updated for TNG 13 to fix additional PHP 7.4 and PHP 8 notices with help from Brent Hemphill to fix Return to Main Menu link in TNG 13 to change page heading to match other admin pages
V13.0.0.4	13 Jul 2020	updated for TNG V13 for Admin Layout change
V12.0.0.3	2 Nov 2019	updated for TNG V12 to fix PHP 7.2 undefined constant errors Our thanks to Brent Hemphill for providing the code changes.
V12.0.0.2	1 May 2019	updated for TNG V12 to fix PHP 7.2 warnings and to use the new cust_text.php anchor string Our thanks to Rick Hooley for reporting the problems with the v12.0.0.1 version of the mod that was removed and for beta testing this new version
V11.0.0.0	15 March 2016	updated for TNG V11 Admin Menu changes
V10.1.0.1	8 January 2015	updated for TNG V10.1 Mod Manager changes
V10.0.0.0	2 January 2014	updated for TNG V10 admin changes
V9.0.0.1	6 January 2013	updated to remove the include("config.php") since it was causing a blank page if a function was defined in customconfig.php.
V9.0.0.0	2 February 2012	updated config file name and number to TNG V9 Mod Guidelines standard. Fixed issue with Config Path due to change in begin.php and updated to use template formatting for the created output html page. Also created a separate French language .cfg file.
V8.1.1	3 June 2010	updated config file to use the admin_main for the Return links in TNG V8
V8.1.0	24 May 2010	updated config file to include the changes required to admin_backupLiving.php for TNG V8 and enhanced to support $text variables to make the mod multi-lingual.
V2.1	30 October 2009	updated config file so the Backup Living button is on the right side of the Admin menu and only available to System Administrators and no longer available to Registered Users with add / edit / delete authority
V2.0	15 May 2009	original config file for installing Backup / Restore Living Flag mod
V2.0	16 January 2009	Version 2.0 of the Backup / Restore Living Flag mod
V1.0	21 December 2007	Version 1 of the Backup / Restore
V0.9R1	21 April 2006	original Backup / Restore Living Flag mod

Automated Installation

For TNG V8 and above

TNG version:

≥ 8.0

1. Download the appropriate zip file from the Mod Summary in the upper right hand corner
2. After downloading the zip file, unzip it into your mods folder
3. Follow the normal automated installation for Mod Manager, as shown in the example Mod Manager - Installing Config Files to install the living_flag_backup.cfg.

For TNG V7

TNG version:

7.0

1. Download backupLiving.php for version 2.0.
2. Put the downloaded backupLiving.php in your admin/mod_folder directory.
3. Download the Media:living_flag_backup_v2.1.zip
4. After downloading the zip file, unzip it into your admin/mod_folder
5. Follow the normal automated installation for Mod Manager, as shown in the example Mod Manager - Installing Config Files to install the living_flag_backup_v2.1.cfg.

Note: that the automated config file is specific for version 2 of Ben Wagner's mod and that V2.0 of the Admin Header Mod no longer includes a link for the Living Flag Backup and Restore, since the Living_Flag_Backup_V2.1.cfg creates a link in the left nav area with a button in the Admin frame. Note that the Living_Flag_Backup_V2.1.cfg creates the Backup Living button in the right side of the Admin menu so it is not available to registered users with add / edit / delete authority.

Upgrade to new version

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

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.

English

The following custom text will be added to your English/cust_text.php and English-UTF8/cust_text.php files 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.

// Backup / Restore Living Flags Mod
$admtext['backupliving'] = "Backup Living";
$admtext['backuplivingitems'] = "Backup/Restore Living Flags";
$admtext['bkuprestoraction'] = "To back up or restore the living table, click on the appropriate action icon.";
$admtext['livinginbackup'] = "Living in Backup File";
$admtext['livingindatabase'] = "Living in DataBase";
$admtext['livingconfirm'] = "Are you sure you wish to WRITE the current list of living to disk?";
$admtext['livingreturn'] = "Return to Main Menu";
$admtext['livingrestore'] = "Restore checked to living";
$admtext['livingbackupinfo'] = "Information in Backup File";
$admtext['livingdatabaseinfo'] = "Information in Database";
$admtext['livingchanged'] = "Changed";
$admtext['livingnochange'] = "Most Likely No Change of Information";
$admtext['livingnochangeneeded'] = "Already Marked Living, No Need to Change";
$admtext['livingcomparing'] = "Examining and comparing backup to current database. Please double check before updating.";
$admtext['livingcorrupt'] = "or file is corrupt.";
$admtext['livingnotfound'] = "Not found in database";

French

For example, you would add to the French/cust_text.php

// Backup / Restore Living Flags Mod
$admtext['backupliving'] = "Sauvegarder en vie";
$admtext['backuplivingitems'] = "Sauvegarder/restaurer les étiquettes des vivants";
$admtext['bkuprestoraction'] = "Pour sauvegarder ou restaurer les étiquettes des vivants, cliquez sur l'icône d'action appropriée.";
$admtext['livinginbackup'] = "En vie dans le dossier";
$admtext['livingindatabase'] = "En vie dans la base de données";
$admtext['livingconfirm'] = "Êtes-vous sûr de vouloir écrire la liste courante des vivants au disque ?";
$admtext['livingreturn'] = "Revenez au menu principal";
$admtext['livingrestore'] = "Restaurer les étiquettes des vivants";
$admtext['livingbackupinfo'] = "L'information dans le dossier de sauvegarde";
$admtext['livingdatabaseinfo'] = "L'information dans la base de données";
$admtext['livingchanged'] = "Changé";
$admtext['livingnochange'] = "Il y a probable aucun changement d'information";
$admtext['livingnochangeneeded'] = "Déjà marquée en vie, aucun besoin de changer";
$admtext['livingcomparing'] = "Examinant et comparant le dossier de sauvegarde courant à la base de donnée . Vérifiez une deuxième fois svp avant la mise à jour.";
$admtext['livingcorrupt'] = "ou le dossier est corrompu.";
$admtext['livingnotfound'] = "Non trouvé dans la base de données";

Note that for TNG V8 and above, the $text variables are within single-quotes, and the English/cust_text.php changes were provided for both the languages/English/cust_text.php and languages/English-UTF8/cust_text.php files.

New Death Column on Restore

Version 2 of the Backup / Restore Living Flag Add-on script now contains a Death Column on the Restore screen that makes it easier to uncheck the box to not restore the Living flag for persons who are now deceased.

Restore Changed Detected section

The following image shows an example where the living flag is set for a person where the Backup / Restore script has detected a change. In this case, the change was the addition of a death date, so you should uncheck the Living Flag box before doing the restore.

Manually Checked Living Flags section

The following image shows an example of unchecking the living flag for two people whose records contain a living flag, but who have a death date.

Visual of mod

The above image shows the Backup / Restore Living Flag mod installed with a left nav link and button in the TNG Admin screen that is only available to the System Administrator.

In the event of a problem with your TNG site

1. Try using the Mod Manager Remove capability
2. Or copy your backup admin/rightbanner.php files to your TNG admin directory
   • all should be well now

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
A family history of Ben Wagner and Jo Watlington	...	Ben is the developer of the Backup / Restore Living Flag Add-ons	...	...	...
Our Roy and Boucher Family	Ken Roy	I use this TNG mod to maintain over 1600 manually set Living Flags.	14.0.0.10	14.0	EN, FR
Kuit's Family Pages	...	I am using this TNG add-on, as my feed program does not cater for this, and I do not have all birth-/deceased dates. I can easily check the correct settings now.	...	...
AppeltHaus Genealogy	Lawrence Appelt	Not a Public Site.	10.0.0.0	10.0.0	EN
R G Strong Family Genealogy	Russell G. Strong	Public	V12.0.0.3	V12.3.0	EN, DE, NL, FR
Our Family Genealogy Pages	Roger Navarre	Nice addition to my site	V9.0.0.1	V9.2.0	EN
Hooley Family Links	Rick Hooley	Public/Private	See Here	See Here	EN
The Williams Family Tree	Phil Williams	Public Site	10.0.0.0	10.0.3	English
Brady Family Tree in Western Australia	Darryl Brady	Public site	10.1.0.1	10.1.1	EN, DE
Kemp(e) Family History	Andrew Kemp	Public site	see User:Kempons	see User:Kempons	EN
Wortelboer Genealogy	Bernard Wortelboer	Public site	11.0.0.0	11.0.0	NL,EN
Roebuck and Families Ancestry Website	Donald Roebuck	Public site except for Living	11.0.0.0	11.0.2	EN
Zalewski Family Genealogy	Brian Zalewski		11.0.0.0	11.1.0	EN
Avery Genealogy	Jim Kratoville		11.0.0.0	11.0.2	EN
OurLife Family History - McMullen Clan	Sean Thompson	Not a public site.	11.0.0.0	11.1.0	English
Balbeag Family History	David Hill	Not a public site	11.0.0.0	11.0.2	EN
Familiegeschiedenis en Voorvaderen	Wim Jansen	Not a public site. Very practical addition	V11.0.0.2a	12.0.1	EN, DE, NL
Our Family Histories	Bryan S. Larson	Public - T8 customized	see here	see here	EN
van Heerden Family	Emile van Heerden	Public site	13.0.0.9	13.1.2	EN, AFR
Les Lapierre d'Amérique	Normand Lapierre	Public/Private site	14.0.0.10	14.0	FR, EN
Les Lapierre d'Amérique	Normand Lapierre	Public/Private site	14.0.0.10	14.0	FR, EN

Related Links

• To help track descendants who might be living but do not show birth information, you can also modify the descendtext.php script to show the Living flag when you are logged in as Administrator Display Living Flag mod on the TNG Community Forum
• See also Living Flag Mod
• See also Admin Header Mod (TNG V7 only)

TNG Modules Involved

TNG version:

≥ 13.0.0

In TNG V13 and later, this mod modifies the following files:

• admin_leftmenu.php
• admin.php
• languages/English/cust_text.php
• languages/English-UTF8/cust_text.php

and adds

• admin_backupLiving.php

TNG version:

≤ 12.3.0

TNG version:

≥ 8.0

In TNG V8 and later, this mod modifies the following files:

• admin_leftbanner.php
• admin_main.php
• languages/English/cust_text.php
• languages/English-UTF8/cust_text.php

and adds

• admin_backupLiving.php

TNG version:

≤ 7.1.3

TNG version:

≥ 7.0

In TNG V7, this mod modifies the following files:

• admin/leftbanner.php
• admin/main.php

and copies

• admin/backupLiving.php which must be downloaded from the TNG Forum