Personal Table Maintenance

Personal Table Maintenance
Summary	Adds any of your personal tables to the TNG's database maintenance cycle.
Validation	The mod is XHTML compliant.
Mod Updated	16 Jan 2023
Download link	For TNG 14.0 personal_table_maintenance_v14.0.0.6a.zip For TNG 13.0 Updated for PHP 8.1 personal_table_maintenance_v13.0.0.5.zip For TNG 13.0 TNG 12.0 TNG 11.0 TNG 10.1.0 personal_table_maintenance_v10.1.0.4.zip [Show Previous Versions] For TNG 10.0 TNG 9.1.2 personal_table_maintenance_v9.1.2.3.zip   TNG 9.1.1 TNG 9.0 personal_table_maintenance_v9.0.0.2.zip For TNG 8.1.3 personal_table_maintenance_v8.1.3.2.zip [Hide Previous Versions]
Download stats	Download statisics (v 10,13,14)
Author(s)	Bart 'Roebie' Degryse Supported by Ken Roy
Homepage	Personal Table Maintenance (This page)
Mod Support	TNG Community Forums
Contact Developer	TNG Community Forums
Latest Mod	14.0.0.6a for TNG v14+ 13.0.0.5 for TNG v13+ 10.1.0.4 for TNG v10.1+ 9.1.2.3 for TNG v9.1.2+ 9.0.0.2 for TNG v9.0.0 - v9.1.1 8.1.3.2 for TNG v8
Min TNG V	8.1.3
Max TNG V	14+
Files modified	admin_backup.php admin_optimize.php admin_restore.php admin_utilities.php languages/English/cust_text.php
Related Mods
Notes

Purpose of the mod

This mod will add any of your personal tables to the TNG's database maintenance cycle.

Developer

This mod was developed by Bart 'Roebie' Degryse.
Updated for TNG 10.1 by Ken Roy who now supports the mod.
Updated for TNG 13 using PHP 8.1 by Ken Roy and Brent Hemphill

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.

Revision History

Mod Version	TNG Version	Date	Contents
14.0.0.6a	14.0	16 Jan 2023	Updated to fix issue with French text variable reported by Chris made by Michel Kirsch and published by Ken Roy
14.0.0.6	14.0	12 Dec 2022	Updated for TNG v14 by Michel Kirsch and published by Ken Roy
13.0.0.5	13.0	21 Mar 2022	Updated for PHP 8.1 to fix PHP Deprecated: preg_split(): Passing null to parameter #3 ($limit) of type int is deprecated in admin_utilities.php on line 68 code change provided by Brent Hemphill Updated by Ken Roy to use TNG v12 cust_text.php anchor
10.1.0.4	10.1	12 Jan 2015	Updated for TNG 10.1 for MySQLi and Mod Manager syntax rule changes
9.1.2.3	9.1	19 Feb 2013	Darrin fixed some bugs in TNG v9.1.2 per my request, so the mod must adapt too.
8.1.3.2	8.1	1 Feb 2013	New feature: non-existing tables will be marked as such. The three action buttons and the check box will be hidden. TNG bug fix: After a first-time backup of a table the restore button now becomes visible without having to refresh the page. Darrin has promised to include this fix in the next TNG version.
9.0.0.2	9.0	1 Feb 2013	New feature: non-existing tables will be marked as such. The three action buttons and the check box will be hidden. TNG bug fix: After a first-time backup of a table the restore button now becomes visible without having to refresh the page. Darrin has promised to include this fix in the next TNG version.
8.1.3.1	8.1	28 Jan 2013	Bug fix (php error *Warning*: array_keys(): The first argument should be an array on line *24*)
9.0.0.1	9.0	28 Jan 2013	Bug fix (php error *Warning*: array_keys(): The first argument should be an array on line *24*)
8.1.3.0	8.1	27 Jan 2013	Initial release
9.0.0.0	9.0	27 Jan 2013	Initial release

Conflicts and Issues

• Works only for tables in the same database as your TNG tables.
• (<= 9.0.0.1, <= 8.1.3.1) Tables must exist. If they don't you'll get errors when you attempt to back up, optimize, restore or delete them.

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.
5. Press the Editbutton in Mod Manager and add any table to the text box. The rules to follow are listed in the next paragraph.

Rules

• Only 1 table per line
• Each line looks like xxx:yyy
• xxx is the name of the table in the database
• yyy is the tables's descriptive name

Feature List

• Each table you add on the Edit page will appear next to the default TNG tables on the Admin >> Utilities >> Tables page of your TNG website with its descriptive name.
• You will be able to back up, restore, optimize and delete each table just like any of the default TNG tables.
• Your personal tables' structure will be backed up or restored along with the default tables on the Admin >> Utilities >> Table structure page.
• Non-existing tables will be marked as such and the backup, optimize and restore buttons will be hidden.

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.

Visualization of this mod

The following images show the visual effects of installing the mod.

Admin >> Mod Manager >> Edit Use the mod's parameters to set the tables' database and descriptive name.
Utilities >> Back up, Restore & Optimize Table Data The mod adds the tables to the list of tables you can optimize, backup or restore.
Utilities >> Back up, Restore & Optimize Table Data table Users: this is a table that has already been backed up. All buttons and the check box are visible. table v5: this table does not exist. All buttons and the check box are invisible + there is a message telling about the problem table v7: this table does exist but it has not yet been backed up. Therefor the restore button is invisible. As soon as the backup is finished the restore button will be visible without having to refresh the page.

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
no public site	Bart 'Roebie' Degryse	Mod developer	9.1.2.3	9.1.2	NL,EN,ES,FR
Our Roy and Boucher Family	Ken Roy	Thanks for this mod. Works great!	14.0.0.6a	TNG 14.0.4	EN,FR
Chamberlain and Eidenbenz Genealogy	Graham Chamberlain		10.1.0.4	12.0.1	EN,DE,FR,NL,ES
Mitchell Families Online	Roger Mitchell	Very useful (as always from Bart!)	9.1.2.3	9.1.2	EN
British 1820 Settlers to South Africa	Paul Tanner-Tremaine	Certainly saved me a lot of coding, thanks Bart!	14.0.0.6a	14.0.2	EN
Hooley Family Links	Rick Hooley	Public/Private	See Here	See Here	EN
My family		(no public site)	see here		DE,NL,EN
DJCM.DK	Claus Martinussen	Public site	10.1.0.4	12.0	EN,DA
Wortelboer Genealogy	Bernard Wortelboer	Public site	10.1.0.4	11.0.0	NL,EN
Brady Family Tree in Western Australia	Darryl Brady	Public site	10.1.0.4	10.1.1	EN,DE
Our Family History	Tor Lund	Public site	10.1.0.4	12.2	NO,EN,DE
Brabantse Genealogie	Rob van Rij	Public Site	10.1.0.4	12.2	EN,NL
R G Strong Family Genealogy	Russell G. Strong	Public Site	14.0.0.6a	14.0.4	EN,FR,DE,NL
OurLife Family History - McMullen Clan	Sean Thompson	Not a public site.	10.1.0.4	11.1.0	EN
Wilton, Brimson, Munro and Forward Families	Sharon Lewis		10.1.0.4	11.1.0	EN
The Severijns / Timmer Familytree	Rob Severijns	Public / Private	14.0.0.6a	14.0.4	NL, EN
Your Roots are Showing	Harold Craswell	Public/Private	See Here	See Here	EN