Private Flag Backup / Restore

Private Flag Backup / Restore
Summary	Provides a backup and restore of the Private flags that are set in the tng_peoples table.
Validation	Admin application not validated.
Mod Updated	10 Feb 2023
Download link	For TNG 14.0 private_flag_backup_v14.0.0.10a.zip For TNG 13.0 Private_flag_backup_v13.0.0.9.zip MySQL 8 or sites requiring a port For TNG 13.0 Private_flag_backup_v13.0.0.8.zip For TNG 12.0 private_flag_backup_v12.0.0.3.zip For TNG 11.0 private_flag_backup_v11.0.0.0.zip [Show Previous Versions] For TNG 10.1.0 private_flag_backup_v10.1.0.2.zip For TNG 10.0 private_flag_backup_v10.0.0.0.zip For TNG 9.0 private_flag_backup_v9.0.0.1.zip French language files For TNG 8.0 private_flag_backup_v8.1.1a.zip [Hide Previous Versions]
Download stats	View V9 download statistics For Private Flag Backup/Restore for Private Flag mods group
Author(s)	Ken Roy based on Ben Wagner's Living Flag Backup / Restore
Homepage	Private Flag Backup / Restore (This page)
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.2 for TNG V10.1 10.0.0.0 for TNG V10 9.0.0.1 for TNG V9 8.1.1 for TNG V8
Min TNG V	8.0.0
Max TNG V	14+
Files modified	admin_leftbanner.php admin_main.php languages/English/cust_text.php languages/English-UTF8/cust_text.php languages/French/cust_text.php languages/French-UTF8/cust_text.php admin_backupPrivate.php
Related Mods	Private Flag Display
Notes

Introduction

TNG version:

≥ 8.0

This mod provides a backup and restore of the Private flags that can be set in the tng_peoples table starting with TNG V8.

It is designed to be used as a backup before doing an import gedcom and then used to restore the manually set private flags that were dropped during the import process.

In TNG V9, the French custom text files can now be downloaded as separate add-ons.

Developer

This mod was developed by Ken Roy using a scan and replace on Ben Wagner's Backup / Restore Living Flag

Requirements

• A working TNG installation.
• A backup of all affected files (see the list in the summary in the upper right corner of the page)
• An installed current version of the Mod Manager.
• A TNG database that contains Private flags (do not attempt to use this mod if you do not have any Private flags set in your database)

Revision History

Mod Version	TNG Version	Date	Contents
14.0.0.10a	14.0	10 Feb 2023	updated to fix the backups Store in Config Path sync changes with Living Flag Backup / Restore to make it easier to maintain both mods added table ID attribute to counter-act border="0" that eliminated cell borders added tr class = "databack" to use template background instead of white background for tables
14.0.0.10	14.0	28 Dec 2022	Published the v14.0.0.10_rc version to support backups Stored in Config Path
14.0.0.10_rc	14.0	21 Dec 2022	Updated to support backups Stored in Config Path
14.0.0.10_b113	14.0	18 Dec 2022	Updated for new Admin screen design based on changes provided by Michel Kirsch for the Living Flag Backup / Restore mod
14.0.0.10_b102	14.0	16 Sep 2022	Updated for new TNG v14 Admin layout. With help from Brent Hemphill and Michel Kirsch add the counts on the Home screen button
13.0.0.9	13.0	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
13.0.0.8	13.0	15 Mar 2022	Our thanks to Michel Kirsch for providing the code changes to eliminate PHP 8.1.1 errors in the Living Flag Backup / Restore mod that I used to update this mod: Trying to access array offset on value of type null Deprecated: trim(): Passing null to parameter #1 ($string) of type string updates not previously made when I updated the Living Flag Backup / Restore mod in v13.0.0.5 that now throw errors in PHP 8.1.1 Tested on PHP 8.0.8 and PHP 8.1.1
13.0.0.7	13.0	26 Oct 2021	Return Admin Login screen on direct URL calls if not logged in with appropriate rights
13.0.0.6	13.0	25 Jun 2021	to prevent direct URL call by users who do not have TNG Admin rights code changed provided by Brent Hemphill
13.0.0.5	13.0	16 Mar 2021	updated for TNG V13 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
13.0.0.4	13.0	13 Jul 2020	updated for TNG V13 new Admin Layout
12.0.0.3	12.0	02 Nov 2019	updated for TNG V12 to fix PHP 7.2 undefined constant errors Our thanks to Brent Hemphill for providing the code changes.
12.0.0.2	12.0	01 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
11.0.0.0	11.0	15 Mar 2016	updated for TNG 11 Admin screen changes
10.1.0.2	10.1	09 Jan 2015	updated for TNG 10.1 for MySQLi calls and for new Mod Manager syntax rules.
10.0.0.0	10.0	02 Jan 2014	updated for TNG 10
9.0.0.1	9.0	06 Jan 2013	updated to remove the include("config.php") since it was causing a blank page if a function was defined in customconfig.php.
9.0.0.0	9.0	02 Feb 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.
8.1.1	8.1	03 Jun 2010	updated config file to use the admin_main for the Return links in TNG V8
8.1.0	8.1	24 May 2010	initial release of the admin_backupPrivate.php for TNG V8

Conflicts and Issues

No known conflicts.

Installation

1. Uninstall and delete previous version of this mod (if installed)
2. Download the appropriate zip file as shown in the mod summary in the upper right corner of the page.
3. Extract the file from the downloaded zip file into the mods folder or FTP the extracted file to your mods folder.
4. Follow the normal automated installation for Mod Manager, as shown in the example Mod Manager - Installing Config Files to install the mod.

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
• Contact us through the TNG Community Forums.

Uninstalling the mod

If you want to completely Remove (uninstall) this mod and all its tables, you should

1. click the Uninstall button to uninstall the mod
2. click the Delete button to delete the config file from the mods folder.

Upgrade

• Uninstall and eventually Delete the current Mod.
• Proceed as for an installation with the new Mod.

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 Private Flags Mod
$admtext['backupprivate'] = "Backup Private";
$admtext['backupprivateitems'] = "Backup/Restore Private Flags";
$admtext['privatebkuprestoraction'] = "To back up or restore the Private table, click on the appropriate action icon.";
$admtext['privateinbackup'] = "Private in Backup File";
$admtext['privateindatabase'] = "Private in DataBase";
$admtext['privateconfirm'] = "Are you sure you wish to WRITE the current list of Private to disk?";
$admtext['privatereturn'] = "Return to Main Menu";
$admtext['privaterestore'] = "Restore checked to Private";
$admtext['privatebackupinfo'] = "Information in Backup File";
$admtext['privatedatabaseinfo'] = "Information in Database";
$admtext['privatechanged'] = "Changed";
$admtext['privatenochange'] = "Most Likely No Change of Information";
$admtext['privatenochangeneeded'] = "Already Marked Private, No Need to Change";
$admtext['privatecomparing'] = "Examining and comparing backup to current database. Please double check before updating.";
$admtext['privatecorrupt'] = "or file is corrupt.";
$admtext['privatenotfound'] = "Not found in database";

French

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

// Backup / Restore Private Flags Mod
$admtext['backupprivate'] = "Sauvegarder privé";
$admtext['backupprivateitems'] = "Sauvegarder/restaurer les étiquettes privées";
$admtext['privatebkuprestoraction'] = "Pour sauvegarder ou restaurer les étiquettes privées, cliquez sur l'icône d'action appropriée.";
$admtext['privateinbackup'] = "Privé dans le dossier";
$admtext['privateindatabase'] = "Privé dans la base de données";
$admtext['privateconfirm'] = "Êtes-vous sûr de vouloir écrire la liste courante des privées au disque ?";
$admtext['privatereturn'] = "Revenez au menu principal";
$admtext['privaterestore'] = "Restaurer les étiquettes privées";
$admtext['privatebackupinfo'] = "L'information dans le dossier de sauvegarde";
$admtext['privatedatabaseinfo'] = "L'information dans la base de données";
$admtext['privatechanged'] = "Changé";
$admtext['privatenochange'] = "Il y a probable aucun changement d'information";
$admtext['privatenochangeneeded'] = "Déjà marquée privé, aucun besoin de changer";
$admtext['privatecomparing'] = "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['privatecorrupt'] = "ou le dossier est corrompu.";
$admtext['privatenotfound'] = "Pas trouvé dans la base de données";

Note that for TNG V8 and above and after, 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.

Visualization

The image on the right shows the Backup / Restore Private Flag mod installed with a left nav link and button in the TNG V8 Admin screen. The Backup / Restore Private Flag capability will only be available to the Administrator.

Related Links

To help keep track of descendants who might be flagged as Private, you can also modify the descendtext.php script to show the Private flag when you are logged in as Administrator

• See Private Flag Mod

Other mods related to Private

• Private Checkboxes Mod
• Private Is Private
• Private Note Mod

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 Roy and Boucher Family	Ken Roy	I developed this mod based on Ben Wagner's Backup / Restore Living Flag to serve the same purpose for manually set Private flags.	14.0.0.10a	TNG 14.0.4	EN,FR
R G Strong Family Genealogy	Russell G. Strong	Public	14.0.0.10a	14.0.4	EN,DE,FR,NL
Hooley Family Links	Rick Hooley	Public/Private	See Here	See Here	EN
Luithlenfamilie	Ingo Wagner	Not a Public site	11.0.0.0	11.1.2	DE,EN,NO,FR
Wortelboer Genealogy	Bernard Wortelboer	Public Site	11.0.0.0	11.0.0	NL,EN
OurLife Family History - McMullen Clan	Sean Thompson	Not a public site.	11.0.0.0	11.1.0	EN
Balbeag Family History	David Hill	Not a public site	11.0.0.0	11.0.2	EN
Koufos Family History	Stephen Koufos		11.0.0.0	11.0.2	EN
SiEiNo's slekt på Internett	Eilif A Nordseth	Not a public site	11.0.0.0	11.1.1	EN
Martius family	Hendrik Martius	Half public	11.0.0.0	12.0.1	DE,EN,FR,NL
Simon and Anita Passey's Family Tree	Simon Passey	Public/private tree. I use this mod to keep a backup of people that I have made private because they died in the last 85 years.	13.0.0.4	13.0.0	EN
Les Lapierre d'Amérique	Normand Lapierre	Public/Private site	14.0.0.10	14.0	FR,EN