Difference between revisions of "Personal Table Maintenance"

From TNG_Wiki
Jump to navigation Jump to search
 
(29 intermediate revisions by 6 users not shown)
Line 1: Line 1:
−
{{restricted}}{{TNGmod
+
{{restricted}}{{V12_cust_text}}{{TNGmod
−
| mod_name        = Personal Table Maintenance
+
| mod_name        = {{PAGENAME}}
 
| mod_summary    = Adds any of your personal tables to the TNG's database maintenance cycle.
 
| mod_summary    = Adds any of your personal tables to the TNG's database maintenance cycle.
 
| mod_validation  = The mod is XHTML compliant.[[Image:Valid-xhtml10.png|44px]]  
 
| mod_validation  = The mod is XHTML compliant.[[Image:Valid-xhtml10.png|44px]]  
−
| mod_last_update = 12 Jan 2015
+
| mod_last_update = 16 Jan 2023
−
|  download_link  = For <span  class="nowrap">{{Tv120}}{{Tv110}}{{Tv1010}}</span>[https://www.royandboucher.com/ccount/click.php?id=220&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} personal_table_maintenance_v10.1.0.4.zip]<hr/>
+
|  download_link  = For{{Tv140}}[https://www.royandboucher.com/ccount/click.php?id=695&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} personal_table_maintenance_v14.0.0.6a.zip]<hr style="clear: both;"/>For{{Tv130}}<br />Updated for PHP 8.1<br />[https://www.royandboucher.com/ccount/click.php?id=649&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} personal_table_maintenance_v13.0.0.5.zip]<hr style="clear: both;"/>For{{Tv130}}{{Tv120}}{{Tv110}}{{Tv1010}}<br />[https://www.royandboucher.com/ccount/click.php?id=220&user={{#replace:{{CURRENTLOGGEDUSER}}}}&page={{PAGENAMEE}} personal_table_maintenance_v10.1.0.4.zip]<hr style="clear: both;"/>
 
<div class='mw-collapsible mw-collapsible-content' id='mw-customcollapsible-sb1'><span class='mw-customtoggle-sb1 mw-customtoggle-sbdiv' style='text-decoration:underline;float:right;'>&#91;Show Previous Versions&#93;</span></div>
 
<div class='mw-collapsible mw-collapsible-content' id='mw-customcollapsible-sb1'><span class='mw-customtoggle-sb1 mw-customtoggle-sbdiv' style='text-decoration:underline;float:right;'>&#91;Show Previous Versions&#93;</span></div>
−
<div class='mw-collapsible mw-collapsible-content mw-collapsed' id='mw-customcollapsible-sbdiv'>
+
<div class='mw-collapsible mw-collapsible-content mw-collapsed' id='mw-customcollapsible-sbdiv'>For{{Tv100}}{{Tv912}}<br />[http://ccount.degryse-moeys.net/click.php?id=80 personal_table_maintenance_v9.1.2.3.zip]<hr/>&nbsp;{{Tv911}}{{Tv90}}[http://ccount.degryse-moeys.net/click.php?id=77 personal_table_maintenance_v9.0.0.2.zip]<hr style="clear: both;"/>For{{Tv813}}<br />[http://ccount.degryse-moeys.net/click.php?id=76 personal_table_maintenance_v8.1.3.2.zip]<div class='mw-customtoggle-sb1 mw-customtoggle-sbdiv' style='text-decoration:underline;float:right;'>&#91;Hide Previous Versions&#93;</div></div>
−
&nbsp;<span class="nowrap">{{Tv100}}{{Tv912}}</span>[http://ccount.degryse-moeys.net/click.php?id=80 personal_table_maintenance_v9.1.2.3.zip]<hr/>&nbsp;{{Tv911}}{{Tv90}}[http://ccount.degryse-moeys.net/click.php?id=77 personal_table_maintenance_v9.0.0.2.zip]<hr/>&nbsp;{{Tv813}}[http://ccount.degryse-moeys.net/click.php?id=76 personal_table_maintenance_v8.1.3.2.zip]<div class='mw-customtoggle-sb1 mw-customtoggle-sbdiv' style='text-decoration:underline;float:right;'>&#91;Hide Previous Versions&#93;</div></div>
+
| download_stats  = [https://www.royandboucher.com/ccount/index.php?action=stats&id=220-649-680-695 Download statisics (v 10,13,14)]
−
| download_stats  = [http://ccount.degryse-moeys.net/index.php?action=stats&groupid=16 See download statistics]
+
<!-- [http://ccount.degryse-moeys.net/index.php?action=stats&groupid=16 See download statistics] -->
−
| mod_author      = [[User:Roebie|Bart 'Roebie' Degryse]]
+
| mod_author      = [[User:Roebie|Bart 'Roebie' Degryse]]<br />Supported by [[User:KenRoy|Ken Roy]]
−
| mod_url        = [[Personal Table Maintenance]]
+
| mod_url        = '''{{PAGENAME}}''' (This page)
−
| mod_support    = [http://tng.community/ TNG Community Forums]
+
| mod_support    = [https://tng.community/index.php?/forums/forum/21-addons/ TNG Community Forums]
−
| mod_contact    =  
+
| mod_contact    = [https://tng.community/index.php?/forums/forum/21-addons/ TNG Community Forums]
−
| mod_version    = 10.1.0.4 for TNG v10.1 and up<br />9.1.2.3 for TNG v9.1.2 and up<br />9.0.0.2 for TNG v9.0.0 - v9.1.1<br/>8.1.3.2 for TNG v8
+
| mod_version    = 14.0.0.6a for TNG v14+<br />13.0.0.5 for TNG v13+<br />10.1.0.4 for TNG v10.1+<br />9.1.2.3 for TNG v9.1.2+<br />9.0.0.2 for TNG v9.0.0 - v9.1.1<br/>8.1.3.2 for TNG v8
 
| min_TNG_ver    = 8.1.3
 
| min_TNG_ver    = 8.1.3
−
| max_TNG_ver    = 12+
+
| max_TNG_ver    = 14+
−
|  TNG_file_list  = admin_backup.php<br/>admin_optimize.php<br/>admin_restore.php<br/>admin_utilities.php<br/>cust_text.php
+
|  TNG_file_list  = admin_backup.php<br/>admin_optimize.php<br/>admin_restore.php<br/>admin_utilities.php<br/>languages/English/cust_text.php
 
| related_mods    =  
 
| related_mods    =  
 
| notes          =  
 
| notes          =  
−
}}
+
}}{| style="margin-right:0.5 em;" align="right"  
−
{| style="margin-right:0.5 em;" align="right"  
 
 
| __TOC__
 
| __TOC__
 
|}
 
|}
 +
== 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 [[User:Roebie|Bart 'Roebie' Degryse]].<br />
 +
Updated for TNG 10.1 by [[User:KenRoy|Ken Roy]] who now supports the mod.<br />
 +
Updated for TNG 13 using PHP 8.1 by [[User:Ken Roy|Ken Roy]] and [[User:Bhemph|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]].
  
−
== Purpose of the mod ==
+
==Revision History==
 +
{| border="0" cellspacing="1" cellpadding="2" class="wikitable"
 +
|-
 +
! Mod Version
 +
! TNG Version
 +
! Date
 +
! Contents
 +
 
 +
|- style="vertical-align:top;"
 +
| 14.0.0.6a
 +
| 14.0
 +
| style="white-space: nowrap;"|16 Jan 2023
 +
| Updated to fix issue with French text variable reported by Chris made by [[User:MichelKirsch|Michel Kirsch]] and published by [[User:KenRoy|Ken Roy]]
 +
 
 +
|- style="vertical-align:top;"
 +
| 14.0.0.6
 +
| 14.0
 +
| style="white-space: nowrap;"|12 Dec 2022
 +
| Updated for TNG v14 by [[User:MichelKirsch|Michel Kirsch]] and published by [[User:KenRoy|Ken Roy]]
  
−
This mod will add any of your personal tables to the TNG's database maintenance cycle.
+
|- style="vertical-align:top;"
 +
| 13.0.0.5
 +
| 13.0
 +
| style="white-space: nowrap;"|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 [[User:Bhemph|Brent Hemphill]]<br />Updated by [[User:KenRoy|Ken Roy]] to use TNG v12 cust_text.php anchor
  
 +
|- style="vertical-align:top;"
 +
| 10.1.0.4
 +
| 10.1
 +
| style="white-space: nowrap;"|12 Jan 2015
 +
| Updated for TNG 10.1 for MySQLi and Mod Manager syntax rule changes
  
−
== Developer ==
+
|- style="vertical-align:top;"
 +
| 9.1.2.3
 +
| 9.1
 +
| style="white-space: nowrap;"|19 Feb 2013
 +
| Darrin fixed some bugs in TNG v9.1.2 per my request, so the mod must adapt too.
  
−
This mod was developed by [[User:Roebie|Bart 'Roebie' Degryse]]
+
|- style="vertical-align:top;"
 +
| 8.1.3.2
 +
| 8.1
 +
| style="white-space: nowrap;"|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.
  
−
Updated for TNG 10.1 by [[User:Ken Roy|Ken Roy]]
+
|- style="vertical-align:top;"
 +
| 9.0.0.2
 +
| 9.0
 +
| style="white-space: nowrap;"|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.
  
−
== Requirements ==
+
|- style="vertical-align:top;
 +
| 8.1.3.1
 +
| 8.1
 +
| style="white-space: nowrap;"|28 Jan 2013
 +
| Bug fix (php error *Warning*: array_keys(): The first argument should be an array on line *24*)
  
−
* A working TNG installation.
+
|- style="vertical-align:top;
−
* A backup of all affected files (see the list in the summary in the upper right corner of the page)
+
| 9.0.0.1
−
* An installed current version of the [[Mod Manager]] (is already included in TNG v9)
+
| 9.0
 +
| style="white-space: nowrap;"|28 Jan 2013
 +
| Bug fix (php error *Warning*: array_keys(): The first argument should be an array on line *24*)  
  
 +
|- style="vertical-align:top;"
 +
| 8.1.3.0
 +
| 8.1
 +
| style="white-space: nowrap;"|27 Jan 2013
 +
| Initial release
  
−
== Installation ==
+
|- style="vertical-align:top;"
 +
| 9.0.0.0
 +
| 9.0
 +
| style="white-space: nowrap;"|27 Jan 2013
 +
| Initial release
 +
|}
  
−
#  Download the appropriate zip file as shown in the summary in the upper  right corner of the page. NOTE that I host these zip files on my own  server. That way I can count the number of downloads for each mod I made  and estimate the relevance of such mod.
+
== Conflicts and Issues==
−
# Extract the config file from the downloaded zip file into the '''mods''' folder.
+
* Works only for tables in the same database as your TNG tables.
−
#  Follow the normal automated installation for Mod Manager, as shown in  the example [[Mod Manager - Installing Config Files]] to install the  mod.
+
* (<= 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.
−
# Press the '''Edit''' button and add any table to the text box. The rules to follow are listed in the next paragraph.
 
  
 +
==Installation==
 +
# Uninstall and delete previous version of this mod (if installed)
 +
# Download the appropriate zip file as shown in the mod summary in the upper right corner of the page.
 +
# Extract the file from the downloaded zip file into the '''mods''' folder or FTP the extracted file to your mods folder.
 +
# Follow the normal automated installation for Mod Manager, as shown in  the example [[Mod Manager - Installing Config Files]] to install the mod.
 +
# Press the '''Edit'''button in Mod Manager and add any table to the text box. The rules to follow are listed in the next paragraph.
  
 
== Rules ==
 
== Rules ==
−
 
 
* Only 1 table per line
 
* Only 1 table per line
 
* Each line looks like xxx:yyy
 
* Each line looks like xxx:yyy
 
* xxx is the name of the table in the database
 
* xxx is the name of the table in the database
 
* yyy is the tables's descriptive name
 
* yyy is the tables's descriptive name
−
 
  
 
== Feature List ==
 
== 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.
 
* 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.
 
* You will be able to back up, restore, optimize and delete each table just like any of the default TNG tables.
Line 65: Line 135:
 
* Non-existing tables will be marked as such and the backup, optimize and restore buttons will be hidden.
 
* 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_-_Installing_Config_Files#Remove_Mod_Steps|Mod Manager Remove]] capability
 +
* Copy the backup of the affected files back to your TNG  directory
 +
* Contact us through the [https://tng.community/index.php?/forums/forum/21-addons/ TNG Community Forums].
 +
 +
== Uninstalling the mod ==
 +
If  you want to completely '''Remove''' (uninstall) this mod and all its tables, you should
 +
# click the '''Uninstall''' button to uninstall the mod
 +
# 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 ==
 
== Visualization of this mod ==
−
 
 
The following images show the visual effects of installing the mod.
 
The following images show the visual effects of installing the mod.
  
Line 87: Line 169:
 
|}
 
|}
  
−
 
+
==Sites using this mod==
−
== Limitations ==
 
−
 
 
−
* 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.
 
−
 
 
−
== Uninstalling the mod ==
 
−
 
 
−
Uninstalling is done through the mod's '''Uninstall''' button on the [[Mod Manager]] page.
 
−
This will however not remove the table from your database. That is something you have to do yourself.<br/>
 
−
This mod also creates a file in the extensions folder. Since this file isn't and can't be created during the installation of the mod it will also not be removed when uninstalling it. You can however safely delete it yourself. It's called ''ptm_settings.inc''.
 
−
 
 
−
 
 
−
== In the event of a problem ==
 
−
 
 
−
* Try using the [[Mod_Manager_-_Installing_Config_Files#Remove_Mod_Steps|Mod Manager Remove]] capability
 
−
* Open an issue in the [http://tng.community TNG Community Forums]
 
−
 
 
−
== Revision History ==
 
−
 
 
−
{| border="1" cellspacing="5" cellpadding="2" width="100%" class="wikitable"
 
−
|-
 
−
! Version
 
−
! Release&nbsp;Date
 
−
! Contents
 
−
|- valign="top"
 
−
| v10.1.0.4
 
−
| 12 January 2015
 
−
| Updated for TNG 10.1 for MySQLi and Mod Manager syntax rule changes
 
−
|- valign="top"
 
−
| v9.1.2.3
 
−
| 19 February 2013
 
−
| Darrin fixed some bugs in TNG v9.1.2 per my request, so the mod must adapt too.
 
−
|- valign="top"
 
−
| v9.0.0.2<br/>v8.1.3.2
 
−
| 1 February 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.
 
−
|- valign="top"
 
−
| v9.0.0.1<br/>v8.1.3.1
 
−
| 28 January 2013
 
−
| Bug fix (php error *Warning*: array_keys(): The first argument should be an array on line *24*)
 
−
|- valign="top"
 
−
| v9.0.0.0<br/>v8.1.3.0
 
−
| 27 January 2013
 
−
| Initial release
 
−
|}
 
−
 
 
−
 
 
−
== Sites using this mod ==
 
−
 
 
 
If you download and install this mod, please add your TNG site to the table below:
 
If you download and install this mod, please add your TNG site to the table below:
  
−
{| border="0" cellspacing="1" cellpadding="2" class="wikitable"
+
{| class="wikitable" width="100%" cellspacing="1" cellpadding="2" border="0"
 
|-
 
|-
 
! URL
 
! URL
Line 148: Line 180:
 
! TNG-Version
 
! TNG-Version
 
! User-language
 
! User-language
−
|-
+
 
 +
|- style="vertical-align:top;"
 
| no public site
 
| no public site
 
| [[User:Roebie|Bart 'Roebie' Degryse]]
 
| [[User:Roebie|Bart 'Roebie' Degryse]]
Line 154: Line 187:
 
| 9.1.2.3
 
| 9.1.2.3
 
| 9.1.2
 
| 9.1.2
−
| NL/EN/ES/FR
+
| NL,EN,ES,FR
−
|-
+
 
 +
|- style="vertical-align:top;"
 
| [https://www.royandboucher.com Our Roy and Boucher Family]
 
| [https://www.royandboucher.com Our Roy and Boucher Family]
 
| [[User:Ken Roy|Ken Roy]]
 
| [[User:Ken Roy|Ken Roy]]
 
| Thanks for this mod.  Works great!
 
| Thanks for this mod.  Works great!
−
| 10.1.0.4
+
| 14.0.0.6a
−
| 12.0.0
+
| {{Tv1404}}
−
| EN, FR
+
| EN,FR
−
|-
+
 
 +
|- style="vertical-align:top;"
 
| [http://www.katiandgraham.com/genealogy Chamberlain and Eidenbenz Genealogy]
 
| [http://www.katiandgraham.com/genealogy Chamberlain and Eidenbenz Genealogy]
 
| [[User:Hiraeth|Graham Chamberlain]]
 
| [[User:Hiraeth|Graham Chamberlain]]
Line 169: Line 204:
 
| 12.0.1
 
| 12.0.1
 
| EN,DE,FR,NL,ES
 
| EN,DE,FR,NL,ES
−
|-
+
 
 +
|- style="vertical-align:top;"
 
| [http://mfo.me.uk Mitchell Families Online]
 
| [http://mfo.me.uk Mitchell Families Online]
 
| [[User:HiTowerUK|Roger Mitchell]]
 
| [[User:HiTowerUK|Roger Mitchell]]
Line 176: Line 212:
 
| 9.1.2
 
| 9.1.2
 
| EN
 
| EN
−
|-
+
 
 +
|- style="vertical-align:top;"
 
| [http://www.1820Settlers.com British 1820 Settlers to South Africa]
 
| [http://www.1820Settlers.com British 1820 Settlers to South Africa]
 
| [[User:PaulTT|Paul Tanner-Tremaine]]
 
| [[User:PaulTT|Paul Tanner-Tremaine]]
 
| Certainly saved me a lot of coding, thanks Bart!
 
| Certainly saved me a lot of coding, thanks Bart!
−
| 10.1.0.4
+
| 14.0.0.6a| 14.0.0.6a
−
| 10.1.1
+
|14.0.2
−
| EN
+
|EN
−
|-
+
|- style="vertical-align:top;"
 
| [http://genealogy.oceanwharf.com Hooley Family Links]
 
| [http://genealogy.oceanwharf.com Hooley Family Links]
 
| [[User:lastejas|Rick Hooley]]
 
| [[User:lastejas|Rick Hooley]]
Line 190: Line 227:
 
| [[User: lastejas|See Here]]
 
| [[User: lastejas|See Here]]
 
| EN
 
| EN
−
|-
+
 
 +
|- style="vertical-align:top;"
 
| [http://www.teige.eu My family]
 
| [http://www.teige.eu My family]
 
| [[image:Oname.gif‎|top]]
 
| [[image:Oname.gif‎|top]]
 
| (no public site)
 
| (no public site)
 
| colspan="2" align="center" | see [[User:ojay|here]]
 
| colspan="2" align="center" | see [[User:ojay|here]]
−
| D,(NL),(GB)
+
| DE,NL,EN
−
|-
+
 
 +
|- style="vertical-align:top;"
 
| [http://djcm.dk DJCM.DK]
 
| [http://djcm.dk DJCM.DK]
 
| [[User:Clausm|Claus Martinussen]]
 
| [[User:Clausm|Claus Martinussen]]
Line 202: Line 241:
 
| 10.1.0.4
 
| 10.1.0.4
 
| 12.0
 
| 12.0
−
| EN, DA
+
| EN,DA
−
|-
+
 
 +
|- style="vertical-align:top;"
 
| [http://www.wortelboer.tk Wortelboer Genealogy]  
 
| [http://www.wortelboer.tk Wortelboer Genealogy]  
 
| [[User:Bernard57|Bernard Wortelboer]]
 
| [[User:Bernard57|Bernard Wortelboer]]
Line 209: Line 249:
 
| 10.1.0.4
 
| 10.1.0.4
 
| 11.0.0
 
| 11.0.0
−
| NL, EN
+
| NL,EN
−
|-
+
 
 +
|- style="vertical-align:top;"
 
| [https://www.bradyfamilytree.org/ Brady Family Tree in Western Australia]
 
| [https://www.bradyfamilytree.org/ Brady Family Tree in Western Australia]
 
| [[User:bradyfamilytree|Darryl Brady]]
 
| [[User:bradyfamilytree|Darryl Brady]]
Line 216: Line 257:
 
| 10.1.0.4
 
| 10.1.0.4
 
| 10.1.1
 
| 10.1.1
−
| EN, DE
+
| EN,DE
−
|-
+
 
 +
|- style="vertical-align:top;"
 
| [http://tor-lund.net/ Our Family History]
 
| [http://tor-lund.net/ Our Family History]
 
| [[User:torlund|Tor Lund]]
 
| [[User:torlund|Tor Lund]]
Line 223: Line 265:
 
| 10.1.0.4
 
| 10.1.0.4
 
| 12.2
 
| 12.2
−
| NO, EN, DE
+
| NO,EN,DE
−
|-
+
 
 +
|- style="vertical-align:top;"
 
| [https://www.brabantse-genealogie.nl Brabantse Genealogie]
 
| [https://www.brabantse-genealogie.nl Brabantse Genealogie]
 
| [[User:Rob van Rij|Rob van Rij]]
 
| [[User:Rob van Rij|Rob van Rij]]
Line 231: Line 274:
 
| 12.2
 
| 12.2
 
| EN,NL  
 
| EN,NL  
−
|-
+
 
 +
|- style="vertical-align:top;"
 
| [https://www.rgstrong-genes.com/ R G Strong Family Genealogy]
 
| [https://www.rgstrong-genes.com/ R G Strong Family Genealogy]
 
| [[User:Rgstrong|Russell G. Strong]]
 
| [[User:Rgstrong|Russell G. Strong]]
 
| Public Site
 
| Public Site
−
| 10.1.0.4
+
| 14.0.0.6a
−
| 11.0.1
+
| 14.0.4
−
| EN, FR, DE, NL
+
| EN,FR,DE,NL
−
|-
+
 
 +
|- style="vertical-align:top;"
 
| [https://www.ourlife.us OurLife Family History - McMullen Clan]
 
| [https://www.ourlife.us OurLife Family History - McMullen Clan]
 
| [[User:Seanst|Sean Thompson]]
 
| [[User:Seanst|Sean Thompson]]
Line 244: Line 289:
 
| 10.1.0.4
 
| 10.1.0.4
 
| 11.1.0
 
| 11.1.0
−
| English
+
| EN
−
|-
+
 
 +
|- style="vertical-align:top;"
 
| [http://sklgenealogy.net/ Wilton, Brimson, Munro and Forward Families]
 
| [http://sklgenealogy.net/ Wilton, Brimson, Munro and Forward Families]
 
| [[User:Malleefowl|Sharon Lewis]]
 
| [[User:Malleefowl|Sharon Lewis]]
Line 251: Line 297:
 
| 10.1.0.4
 
| 10.1.0.4
 
| 11.1.0
 
| 11.1.0
−
| English
+
| EN
 +
 
 +
|- style="vertical-align:top;"
 +
| [https://www.severijns.family/Severijns The Severijns / Timmer Familytree]
 +
| Rob Severijns
 +
| Public / Private
 +
| 14.0.0.6a
 +
| 14.0.4
 +
| NL, EN
 +
 
 +
|- style="vertical-align:top;"
 +
| [https://www.craswell.ca/ Your Roots are Showing]
 +
| [[User:crashar|Harold Craswell]]
 +
| Public/Private
 +
| [https://www.craswell.ca/rrmodcompare_report.php?power=basic&cachemethod=3&sb=filename&aformat=full&statushilite=1&b1=0 See Here]
 +
| [https://www.craswell.ca/rrmodcompare_report.php?power=basic&cachemethod=3&sb=filename&aformat=full&statushilite=1&b1=0 See Here]
 +
| EN
 
|-}
 
|-}
  
 +
[[Category:Mods for TNG v14]]
 +
[[Category:Mods for TNG v13]]
 
[[Category:Mods for TNG v12]]
 
[[Category:Mods for TNG v12]]
 
[[Category:Mods for TNG v11]]
 
[[Category:Mods for TNG v11]]
Line 259: Line 323:
 
[[Category:Mods for TNG v9]]
 
[[Category:Mods for TNG v9]]
 
[[Category:Mods for TNG v8]]
 
[[Category:Mods for TNG v8]]
 +
 
[[Category:admin_backup.php mods]]
 
[[Category:admin_backup.php mods]]
 
[[Category:admin_optimize.php mods]]
 
[[Category:admin_optimize.php mods]]
 
[[Category:admin_restore.php mods]]
 
[[Category:admin_restore.php mods]]
 
[[Category:admin_utilities.php mods]]
 
[[Category:admin_utilities.php mods]]
 +
 
[[Category:cust_text.php English mods]]
 
[[Category:cust_text.php English mods]]
 +
|}

Latest revision as of 22:46, 4 March 2024

Restricted Downloads of Personal Table Maintenance 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


Caution


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


Personal Table Maintenance
Summary Adds any of your personal tables to the TNG's database maintenance cycle.
Validation The mod is XHTML compliant.Valid-xhtml10.png
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

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.

Use parameters to set the table names
Utilities >> Back up, Restore & Optimize Table Data

The mod adds the tables to the list of tables you can optimize, backup or restore.

With the mod installed
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.
 Table existance check

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 Oname.gif (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
Retrieved from "https://tng.lythgoes.net/wiki/index.php?title=Personal_Table_Maintenance&oldid=84737"