Difference between revisions of "Personal Table Maintenance"
Rob van Rij (talk | contribs) |
|||
(31 intermediate revisions by 10 users not shown) | |||
Line 1: | Line 1: | ||
− | {{TNGmod | + | {{restricted}}{{TNGmod |
| mod_name = Personal Table Maintenance | | mod_name = Personal Table Maintenance | ||
| 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]] | ||
− | | download_link = <span class="nowrap">{{Tv100}}{{Tv912}}</span>[http://ccount.degryse-moeys.net/click.php?id=80 personal_table_maintenance_v9.1.2.3.zip]<hr/> {{Tv911}}{{Tv90}}[http://ccount.degryse-moeys.net/click.php?id=77 personal_table_maintenance_v9.0.0.2.zip]<hr/> {{Tv813}}[http://ccount.degryse-moeys.net/click.php?id=76 personal_table_maintenance_v8.1.3.2.zip] | + | | mod_last_update = 12 Jan 2015 |
+ | | 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/> | ||
+ | <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;'>[Show Previous Versions]</span></div> | ||
+ | <div class='mw-collapsible mw-collapsible-content mw-collapsed' id='mw-customcollapsible-sbdiv'> | ||
+ | <span class="nowrap">{{Tv100}}{{Tv912}}</span>[http://ccount.degryse-moeys.net/click.php?id=80 personal_table_maintenance_v9.1.2.3.zip]<hr/> {{Tv911}}{{Tv90}}[http://ccount.degryse-moeys.net/click.php?id=77 personal_table_maintenance_v9.0.0.2.zip]<hr/> {{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;'>[Hide Previous Versions]</div></div> | ||
| download_stats = [http://ccount.degryse-moeys.net/index.php?action=stats&groupid=16 See download statistics] | | download_stats = [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]] | ||
| mod_url = [[Personal Table Maintenance]] | | mod_url = [[Personal Table Maintenance]] | ||
− | | mod_support = [http:// | + | | mod_support = [http://tng.community/ TNG Community Forums] |
| mod_contact = | | mod_contact = | ||
− | | mod_version = 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 = 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 |
| min_TNG_ver = 8.1.3 | | min_TNG_ver = 8.1.3 | ||
− | | max_TNG_ver = | + | | max_TNG_ver = 12+ |
| 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/>cust_text.php | ||
| related_mods = | | related_mods = | ||
| notes = | | notes = | ||
}} | }} | ||
− | + | {| style="margin-right:0.5 em;" align="right" | |
− | {|align=right | + | | __TOC__ |
− | |__TOC__ | ||
|} | |} | ||
Line 30: | Line 33: | ||
This mod was developed by [[User:Roebie|Bart 'Roebie' Degryse]] | This mod was developed by [[User:Roebie|Bart 'Roebie' Degryse]] | ||
+ | Updated for TNG 10.1 by [[User:Ken Roy|Ken Roy]] | ||
== Requirements == | == Requirements == | ||
Line 91: | Line 95: | ||
== Uninstalling the mod == | == Uninstalling the mod == | ||
− | Uninstalling is done through the mod's ''' | + | 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 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''. | 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''. | ||
Line 99: | Line 103: | ||
* Try using the [[Mod_Manager_-_Installing_Config_Files#Remove_Mod_Steps|Mod Manager Remove]] capability | * 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 == | == Revision History == | ||
Line 111: | Line 112: | ||
! Release Date | ! Release Date | ||
! Contents | ! 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" | |- valign="top" | ||
| v9.1.2.3 | | v9.1.2.3 | ||
Line 151: | Line 156: | ||
| NL/EN/ES/FR | | NL/EN/ES/FR | ||
|- | |- | ||
− | | [ | + | | [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 |
− | | | + | | 12.0.0 |
| EN, FR | | EN, FR | ||
|- | |- | ||
Line 161: | Line 166: | ||
| [[User:Hiraeth|Graham Chamberlain]] | | [[User:Hiraeth|Graham Chamberlain]] | ||
| | | | ||
− | | | + | | 10.1.0.4 |
− | | | + | | 12.0.1 |
| EN,DE,FR,NL,ES | | EN,DE,FR,NL,ES | ||
|- | |- | ||
Line 175: | Line 180: | ||
| [[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 |
− | | | + | | 10.1.1 |
| EN | | EN | ||
|- | |- | ||
| [http://genealogy.oceanwharf.com Hooley Family Links] | | [http://genealogy.oceanwharf.com Hooley Family Links] | ||
| [[User:lastejas|Rick Hooley]] | | [[User:lastejas|Rick Hooley]] | ||
− | | | + | | Public/Private |
− | | | + | | [[User: lastejas|See Here]] |
− | | | + | | [[User: lastejas|See Here]] |
| EN | | EN | ||
|- | |- | ||
Line 195: | Line 200: | ||
| [[User:Clausm|Claus Martinussen]] | | [[User:Clausm|Claus Martinussen]] | ||
| Public site | | Public site | ||
− | | | + | | 10.1.0.4 |
− | | | + | | 12.0 |
| EN, DA | | EN, DA | ||
|- | |- | ||
Line 202: | Line 207: | ||
| [[User:Bernard57|Bernard Wortelboer]] | | [[User:Bernard57|Bernard Wortelboer]] | ||
| Public site | | Public site | ||
− | | | + | | 10.1.0.4 |
− | | 10.0. | + | | 11.0.0 |
− | | EN | + | | NL, EN |
− | |} | + | |- |
+ | | [https://www.bradyfamilytree.org/ Brady Family Tree in Western Australia] | ||
+ | | [[User:bradyfamilytree|Darryl Brady]] | ||
+ | | Public site | ||
+ | | 10.1.0.4 | ||
+ | | 10.1.1 | ||
+ | | EN, DE | ||
+ | |- | ||
+ | | [http://tor-lund.net/ Our Family History] | ||
+ | | [[User:torlund|Tor Lund]] | ||
+ | | Public site | ||
+ | | 10.1.0.4 | ||
+ | | 12.2 | ||
+ | | NO, EN, DE | ||
+ | |- | ||
+ | | [https://www.brabantse-genealogie.nl Brabantse Genealogie] | ||
+ | | [[User:Rob van Rij|Rob van Rij]] | ||
+ | | Public Site | ||
+ | | 10.1.0.4 | ||
+ | | 12.2 | ||
+ | | EN,NL | ||
+ | |- | ||
+ | | [https://www.rgstrong-genes.com/ R G Strong Family Genealogy] | ||
+ | | [[User:Rgstrong|Russell G. Strong]] | ||
+ | | Public Site | ||
+ | | 10.1.0.4 | ||
+ | | 11.0.1 | ||
+ | | EN, FR, DE, NL | ||
+ | |- | ||
+ | | [https://www.ourlife.us OurLife Family History - McMullen Clan] | ||
+ | | [[User:Seanst|Sean Thompson]] | ||
+ | | Not a public site. | ||
+ | | 10.1.0.4 | ||
+ | | 11.1.0 | ||
+ | | English | ||
+ | |- | ||
+ | | [http://sklgenealogy.net/ Wilton, Brimson, Munro and Forward Families] | ||
+ | | [[User:Malleefowl|Sharon Lewis]] | ||
+ | | | ||
+ | | 10.1.0.4 | ||
+ | | 11.1.0 | ||
+ | | English | ||
+ | |-} | ||
+ | |||
+ | [[Category:Mods for TNG v12]] | ||
+ | [[Category:Mods for TNG v11]] | ||
[[Category:Mods for TNG v10]] | [[Category:Mods for TNG v10]] | ||
[[Category:Mods for TNG v9]] | [[Category:Mods for TNG v9]] |
Revision as of 16:39, 23 December 2019
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 | ||
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
|
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 | 12 Jan 2015 | ||||||||
Download link | For
[Show Previous Versions]
[Hide Previous Versions] | ||||||||
Download stats | See download statistics | ||||||||
Author(s) | Bart 'Roebie' Degryse | ||||||||
Homepage | Personal Table Maintenance | ||||||||
Mod Support | TNG Community Forums | ||||||||
Contact Developer | |||||||||
Latest Mod | 10.1.0.4 for TNG v10.1 and up 9.1.2.3 for TNG v9.1.2 and up 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 | 12+ | ||||||||
Files modified | admin_backup.php admin_optimize.php admin_restore.php admin_utilities.php 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
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 (is already included in TNG v9)
Installation
- 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.
- Extract the config file from the downloaded zip file into the 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 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.
Visualization of this mod
The following images show the visual effects of installing the 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.
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 Remove capability
- Open an issue in the TNG Community Forums
Revision History
Version | Release Date | Contents |
---|---|---|
v10.1.0.4 | 12 January 2015 | Updated for TNG 10.1 for MySQLi and Mod Manager syntax rule changes |
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. |
v9.0.0.2 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. |
v9.0.0.1 v8.1.3.1 |
28 January 2013 | Bug fix (php error *Warning*: array_keys(): The first argument should be an array on line *24*) |
v9.0.0.0 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:
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! | 10.1.0.4 | 12.0.0 | 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! | 10.1.0.4 | 10.1.1 | EN |
Hooley Family Links | Rick Hooley | Public/Private | See Here | See Here | EN |
My family | (no public site) | see here | D,(NL),(GB) | ||
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 | 10.1.0.4 | 11.0.1 | EN, FR, DE, NL |
OurLife Family History - McMullen Clan | Sean Thompson | Not a public site. | 10.1.0.4 | 11.1.0 | English |
Wilton, Brimson, Munro and Forward Families | Sharon Lewis | 10.1.0.4 | 11.1.0 | English |