Private Flag Backup / Restore

From TNG_Wiki
Jump to navigation Jump to search
Restricted Downloads of Private Flag Backup / Restore 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 have trouble downloading with Google Chrome, Vivaldi, Brave or other Chromium based browser, try using a right-click and select Open in new Window, then F5, or use another browser such as Firefox


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 14.0
TNG 13.0
TNG 12.0

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
TNG 13.0
MySQL 8 or sites requiring a port
TNG 13.0
TNG 12.0
TNG 11.0
[Show 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 for TNG V14+ for TNG V13+ for TNG V12+ for TNG V11 for TNG V10.1 for TNG V10 for TNG V9
8.1.1 for TNG V8
Min TNG V 8.0.0
Max TNG V 14+
Files modified
Related Mods


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.


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


  • 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 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 28 Dec 2022 Published the v14.0.0.10_rc version to support backups Stored in Config Path 14.0 21 Dec 2022 Updated to support backups Stored in Config Path 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 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 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 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 26 Oct 2021 Return Admin Login screen on direct URL calls if not logged in with appropriate rights 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 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 13 Jul 2020 updated for TNG V13 new Admin Layout 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 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 15 Mar 2016 updated for TNG 11 Admin screen changes 10.1 09 Jan 2015 updated for TNG 10.1 for MySQLi calls and for new Mod Manager syntax rules. 10.0 02 Jan 2014 updated for TNG 10 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 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.


  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

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.


  • 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.


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";


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.


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.

Private Flag Backup

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

Other mods related to Private

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.
TNG 14.0.4
R G Strong Family Genealogy Russell G. Strong Public 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.1.2 DE,EN,NO,FR
Wortelboer Genealogy Bernard Wortelboer Public Site 11.0.0 NL,EN
OurLife Family History - McMullen Clan Sean Thompson Not a public site. 11.1.0 EN
Balbeag Family History David Hill Not a public site 11.0.2 EN
Koufos Family History Stephen Koufos 11.0.2 EN
SiEiNo's slekt på Internett Eilif A Nordseth Not a public site 11.1.1 EN
Martius family Hendrik Martius Half public 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 EN
Les Lapierre d'Amérique Normand Lapierre Public/Private site 14.0 FR,EN