Difference between revisions of "Admin Places Date"

From TNG_Wiki
Jump to navigation Jump to search
(mod v12.0.0.3b)
(14 intermediate revisions by 4 users not shown)
Line 1: Line 1:
 
{{TNGmod
 
{{TNGmod
 
| mod_name        =  Admin Places Date
 
| mod_name        =  Admin Places Date
−
|  mod_summary    = Adds a Creation Date to the Places table, and search features that use it in admin_places.php, the Admin>>Places>>Search program
+
|  mod_summary    = Adds a Creation Date to the Places table, and search features that use it in Admin>>Places>>Search
 
| mod_validation  =  
 
| mod_validation  =  
−
| mod_last_update = 10 Jan 2018
+
| mod_last_update = 28 Sep 2019
−
| download_link  = [[Media:admin_places_date_v11.0.0.1a.zip|11.0.0.1a]]{{Tv110}}
+
| download_link  = [[Media:admin_places_date_v12.0.0.3b.zip|v12.0.0.3b.zip]]{{Tv120}}
 +
<div style='font-size:90%'>See older versions in the [[#Revision_History|Revision History]]</div>
 
| download_stats  =
 
| download_stats  =
 
| mod_author      = [[User:Robinrichm|Robin Richmond]]
 
| mod_author      = [[User:Robinrichm|Robin Richmond]]
Line 10: Line 11:
 
| mod_contact    = [http://www.robinrichmond.com/family/mod_support.php My Mod Support form]
 
| mod_contact    = [http://www.robinrichmond.com/family/mod_support.php My Mod Support form]
 
| mod_support    = [http://www.robinrichmond.com/family/mod_support.php My Mod Support form] or [http://tng.community/ TNG Community Forums]
 
| mod_support    = [http://www.robinrichmond.com/family/mod_support.php My Mod Support form] or [http://tng.community/ TNG Community Forums]
−
| mod_version    = 11.0.0.1a
+
| mod_version    = 12.0.0.3b
 
| min_TNG_ver    = 11.0 (probably earlier)
 
| min_TNG_ver    = 11.0 (probably earlier)
−
| max_TNG_ver    = at least 11.1.2
+
| max_TNG_ver    = 12.3
−
|  TNG_file_list  = admin_places.php, installs admin_placesdate_dbsetup.php  
+
|  TNG_file_list  = admin_places.php, installs admin_placesdate_dbsetup.php in TNGv11, and rrplacesdate_dbsetup.php in TNGv12
−
| related_mods  =  
+
| related_mods  = [[Admin Places Search]], [[Admin Places Geocode]]
 
| notes    =   
 
| notes    =   
 
}}
 
}}
 +
 
== Purpose of the Mod ==
 
== Purpose of the Mod ==
 
To allow administrators to review the most recently-created Places, this mod installs a setup program that adds a Creation Date field (called 'datecreated') field to the Places table, and modifies admin_places.php (the Admin >> Places >> Search program) to search for places created after a given date, and to display the creation date.
 
To allow administrators to review the most recently-created Places, this mod installs a setup program that adds a Creation Date field (called 'datecreated') field to the Places table, and modifies admin_places.php (the Admin >> Places >> Search program) to search for places created after a given date, and to display the creation date.
−
 
−
Before you can use the new 'datecreated' field, you must run the setup program, which is accessible only through the expanded status cell in the Mod Manager mod list.  The setup program creates the new database field, and populates all Places records with a date of "2000-01-01" so that they do not accidentally pick up a current date when they are edited.
 
−
}}
 
 
{| style="margin-right:0.5 em;" align="right"  
 
{| style="margin-right:0.5 em;" align="right"  
 
| __TOC__
 
| __TOC__
 
|}
 
|}
−
== Compatibility with other Mods ==
+
Before you can use the new 'datecreated' field, you must run the setup program, which is accessible through the expanded status cell in the Mod Manager mod list.  The setup program creates the new database field, and populates all Places records with a date of "1 Jan 2000" so that they do not accidentally pick up a current date when they are edited.
 +
 
 +
== Mod Conflicts ==
 
This mod is compatible with [[Admin Places Search]], [[Admin Places Geocode]], [[Places Subject to Deletion]], [[TreeID-One Column]], [[Google Maps - More Place Levels Mod]] and [[Google maps 15]]. It is '''not compatible with''' [[Tree ID Mod]], but [[TreeID-One Column]] accomplishes the same purpose as [[Tree ID Mod]].  [[TreeID-One Column]] just uses one column instead of two to display the Tree ID and Tree Name, and avoids a couple of mod conflicts.
 
This mod is compatible with [[Admin Places Search]], [[Admin Places Geocode]], [[Places Subject to Deletion]], [[TreeID-One Column]], [[Google Maps - More Place Levels Mod]] and [[Google maps 15]]. It is '''not compatible with''' [[Tree ID Mod]], but [[TreeID-One Column]] accomplishes the same purpose as [[Tree ID Mod]].  [[TreeID-One Column]] just uses one column instead of two to display the Tree ID and Tree Name, and avoids a couple of mod conflicts.
  
 
== Related Mods ==
 
== Related Mods ==
 
* My [[Admin Places Search]] mod coordinates with this mod in that the field buttons defined for the new creation date search field are activated only after [[Admin Places Search]] is installed - along with [[Field Buttons]].
 
* My [[Admin Places Search]] mod coordinates with this mod in that the field buttons defined for the new creation date search field are activated only after [[Admin Places Search]] is installed - along with [[Field Buttons]].
 +
* This mod uses the '''[[Field Buttons]]''' mod to attach small 'field buttons' to several text fields, ''but it is not dependent on [[Field Buttons]]''. Field buttons are configurable (and generally one-character) buttons that are attached to HTML form fields, and that reduce the typing or mouse movements needed to perform several common editing tasks. This mod is not compatible with Field Buttons mod versions earlier than version 3.
  
−
==Installation==
+
== Installation ==
−
===Requirements===
+
=== Files Installed ===
−
* A working TNG installation.
+
This mod has two mod subfolders:
−
* An installed current version of the [[Mod Manager]].
+
# '''admin_places_date_v12.0.0.3b''' - The subfolder that you expect to exist for any mod that installs files. It contains
−
* You should backup files listed in the panel on the right.
+
## '''rrplacesdate_dbsetup.php''' - A one-time setup program that creates the database field in which a place's creation date is stored.
 +
# The shared folder '''RR-shared_mod_includes_v12.0.0.4''', which contains files that support mod option management in many of my mods. The files installed from that shared folder are:
 +
## '''rrshared_innermodmenu4.php''' - [https://tng.lythgoes.net/wiki/index.php?title=Inner_Mod_Menus Inner&nbsp;Mod&nbsp;Menus]
 +
## '''img/rrshared_wikilogo.gif''' - An icon that links to a mod's TNG Wiki page from an Inner Mod Menu or Mod Settings Block
  
−
===Procedure===
+
The shared folder is packaged with several mods, each of which may install some or all of its files. Once a file from this folder has been installed (by any mod), that file will not be overwritten or removed by the subsequent installation or un-installation of any mod (including this one), nor will its presence generate any Mod Manager errors.  
−
# Remove and delete previous version of this mod.
 
−
# Backup the files updated by this mod.  They are listed in the panel at the upper right.
 
−
# Download the .zip file, and extract its .cfg file to the mods folder.
 
−
# Follow the normal automated installation for Mod Manager, as shown in the example [[Mod Manager - Installing Config Files]].
 
  
−
===Problems?===
+
If you unzip mod distribution files directly into your mods folder, then the presence of this second subfolder and the installation of its files should be invisible to you.  But if you generally ''copy'' mod subfolders to your mods folder, you need to make sure to copy the folder '''RR-shared_mod_includes_v12.0.0.4''' (well, unless you are confident that it is already in your mods folder because it was part of another mod).
−
# Try using the [[Mod_Manager_-_Installing_Config_Files#Remove_Mod_Steps|Mod Manager Remove]] capability
+
{{RobinInstallationBoilerplate}}
−
# Contact me through [http://www.robinrichmond.com/family/mod_support.php My Mod Support form].
 
  
 
== Visualizations ==
 
== Visualizations ==
Line 61: Line 61:
 
== Revision History ==
 
== Revision History ==
 
{| border="0" cellspacing="1" cellpadding="2" class="wikitable"
 
{| border="0" cellspacing="1" cellpadding="2" class="wikitable"
−
|-
+
! Mod Version!! TNG Version !! Date !! Note
−
! Mod Version
+
|- style="vertical-align:top;"  <!-- ############################################################## -->
−
! TNG Versions
+
| [[Media:admin_places_date_v12.0.0.3b.zip|12.0.0.3b]]
−
! Date
+
| 12.0-12.3
−
! Note
+
| 26Feb2020
−
|-  
+
|
−
| 11.0.0.1
+
* Added a missing %end:% tag as required by TNGv12.3
−
| 11.0 - 11.1.2+
+
* Upgraded to version 4 of the shared mod includes
−
| 10 Jan 2018
+
* In admin_places.php (the Places search form)
−
| Fixed a syntax error, and program headings that still referred to the program I copied the setup program from.  Also removed the Creation Date tab, since the setup program is only meant to be run once.  The setpp program is now accessible only through the mod description in the Mod Manager mod list.
+
** When trying to apply the "created since" search condition, check for the presence of the database field (as before), but don't display the warning message, which was awkardly presented before the page headings.
−
|-
+
** Instead, use the search form row created for the "created since" search condition to display the warning and link to the database setup utility.
−
| New Mod
+
*** Also display a link to the Mod Manager, for uninstalling the mod.
 +
* In the database setup utility
 +
** Removed the default value from the db field definition. It doesn't work in newer versions of MySql, and isn't needed, anyway.
 +
** Changed the default date value from 1 Jan 2000 to 31 Dec 1999
 +
** When deleting the field 'creationdate' silently remove old field 'datecreated' if it exists.
 +
 
 +
|- style="vertical-align:top;"  <!-- ############################################################## -->
 +
| [[Media:admin_places_date_v12.0.0.3.zip|12.0.0.3]]
 +
| 12.0-12.2+
 +
| 28Sep2019
 +
|  
 +
*Added an InnerModMenu to admin_places.php
 +
*Now modifies gedimport_misc.php to save the same date/time for all places created by a Gedcom Import.
 +
*Removed the dummy mod parameter that did nothing more than provide a link to the database setup utility.
 +
*Changed the database setup program to have tabs for the Mod Manager and the Admin Places Search to make it cleaner for it to be linked from and linked to both programs.
 +
*Added a link to the database setup utility in a .cfg file note tag.
 +
|- style="vertical-align:top;" <!-- ############################################################## -->
 +
| [[Media:admin_places_date_v12.0.0.2.zip|12.0.0.2]]
 +
| 12.0+
 +
| 4May2018
 +
| No functional changes; made compatible with TNGv12, and changed the filename of the database setup program.
 +
|- style="vertical-align:top;"  <!-- ############################################################## -->
 +
| [[Media:admin_places_date_v11.0.0.1b.zip|11.0.0.1b]]
 +
| 11.0-11.1.2
 +
| 10Jan2018
 +
| No real functional changes. Removed an Admin>>Places tab for running the database setup program, since the it is only meant to be run once.  The database setup program is now accessible through the mod description and the mod options in Mod Manager.
 +
|- style="vertical-align:top;"  <!-- ############################################################## -->
 
| 11.0.0.1
 
| 11.0.0.1
−
| 11.0 - 11.1.2+
+
| 11.0-11.1.2+
−
| 7 Jan 2018
+
| 07Jan2018
 
| New Mod
 
| New Mod
 
|}
 
|}
Line 84: Line 110:
 
{| border="0" cellspacing="1" cellpadding="2" class="wikitable"
 
{| border="0" cellspacing="1" cellpadding="2" class="wikitable"
 
|-
 
|-
−
! URL
+
! URL !! User !! Note !! Mod-Version !! TNG-Version !! User-language
−
! User
 
−
! Note
 
−
! Mod-Version
 
−
! TNG-Version
 
−
! User-language
 
 
|-
 
|-
 
| [http://www.robinrichmond.com/family/ Robin Richmond's Genealogy Database]
 
| [http://www.robinrichmond.com/family/ Robin Richmond's Genealogy Database]
 
| [[User:Robinrichm|Robin Richmond]]
 
| [[User:Robinrichm|Robin Richmond]]
 
| Mod developer
 
| Mod developer
−
| 11.0.0.1
+
| 12.0.0.3b
−
| 11.12
+
| 12.3
 
| English
 
| English
 +
|-
 +
| [https://ourfamilyhistory.club/ Our Family History]
 +
| [[User:Paul Barrett|Paul Barrett]]
 +
| Public/Private site
 +
| 11.0.0.3a
 +
| 11.1.2
 +
| EN
 +
|-
 
|}
 
|}
  
 
[[Category:Mods for TNG v11]]
 
[[Category:Mods for TNG v11]]
 +
[[Category:Mods for TNG v12]]
 
[[Category:admin_places.php mods]]
 
[[Category:admin_places.php mods]]

Revision as of 22:22, 26 February 2020

Admin Places Date
Summary Adds a Creation Date to the Places table, and search features that use it in Admin>>Places>>Search
Validation
Mod Updated 28 Sep 2019
Download link v12.0.0.3b.zip
TNG 12.0
See older versions in the Revision History
Download stats
Author(s) Robin Richmond
Homepage Robin Richmond's Genealogy Database
Mod Support My Mod Support form or TNG Community Forums
Contact Developer My Mod Support form
Latest Mod 12.0.0.3b
Min TNG V 11.0 (probably earlier)
Max TNG V 12.3
Files modified
admin_places.php, installs admin_placesdate_dbsetup.php in TNGv11, and rrplacesdate_dbsetup.php in TNGv12
Related Mods
Admin Places Search, Admin Places Geocode
Notes


Purpose of the Mod

To allow administrators to review the most recently-created Places, this mod installs a setup program that adds a Creation Date field (called 'datecreated') field to the Places table, and modifies admin_places.php (the Admin >> Places >> Search program) to search for places created after a given date, and to display the creation date.

Before you can use the new 'datecreated' field, you must run the setup program, which is accessible through the expanded status cell in the Mod Manager mod list. The setup program creates the new database field, and populates all Places records with a date of "1 Jan 2000" so that they do not accidentally pick up a current date when they are edited.

Mod Conflicts

This mod is compatible with Admin Places Search, Admin Places Geocode, Places Subject to Deletion, TreeID-One Column, Google Maps - More Place Levels Mod and Google maps 15. It is not compatible with Tree ID Mod, but TreeID-One Column accomplishes the same purpose as Tree ID Mod. TreeID-One Column just uses one column instead of two to display the Tree ID and Tree Name, and avoids a couple of mod conflicts.

Related Mods

  • My Admin Places Search mod coordinates with this mod in that the field buttons defined for the new creation date search field are activated only after Admin Places Search is installed - along with Field Buttons.
  • This mod uses the Field Buttons mod to attach small 'field buttons' to several text fields, but it is not dependent on Field Buttons. Field buttons are configurable (and generally one-character) buttons that are attached to HTML form fields, and that reduce the typing or mouse movements needed to perform several common editing tasks. This mod is not compatible with Field Buttons mod versions earlier than version 3.

Installation

Files Installed

This mod has two mod subfolders:

  1. admin_places_date_v12.0.0.3b - The subfolder that you expect to exist for any mod that installs files. It contains
    1. rrplacesdate_dbsetup.php - A one-time setup program that creates the database field in which a place's creation date is stored.
  2. The shared folder RR-shared_mod_includes_v12.0.0.4, which contains files that support mod option management in many of my mods. The files installed from that shared folder are:
    1. rrshared_innermodmenu4.php - Inner Mod Menus
    2. img/rrshared_wikilogo.gif - An icon that links to a mod's TNG Wiki page from an Inner Mod Menu or Mod Settings Block

The shared folder is packaged with several mods, each of which may install some or all of its files. Once a file from this folder has been installed (by any mod), that file will not be overwritten or removed by the subsequent installation or un-installation of any mod (including this one), nor will its presence generate any Mod Manager errors.

If you unzip mod distribution files directly into your mods folder, then the presence of this second subfolder and the installation of its files should be invisible to you. But if you generally copy mod subfolders to your mods folder, you need to make sure to copy the folder RR-shared_mod_includes_v12.0.0.4 (well, unless you are confident that it is already in your mods folder because it was part of another mod).

[Show Installation Details]

Requirements

  • A working TNG installation.
  • An installed current version of the Mod Manager.
  • You should backup files listed in the panel on the right.

Procedure

  1. Remove and delete previous version of this mod.
  2. Backup the files updated by this mod. They are listed in the panel at the upper right.
  3. Download the .zip file, Extract its .cfg file to the mods folder.
  4. Follow the normal automated installation for Mod Manager, as shown in the example Mod Manager - Installing Config Files.

Problems?

  1. Try using the Mod Manager Remove capability
  2. Contact me through My Mod Support form.
[Hide Details]

Visualizations

The Admin>>Places>>Search screen After Installation

The highlighted items are:

  • The new menu tab that runs the setup program,
  • The new "Places Created Since:" date field, and
  • The Creation Date column that is placed in the report only when there is a "Places Created Since" date.

Admin places date-after.jpg

Revision History

Mod Version TNG Version Date Note
12.0.0.3b 12.0-12.3 26Feb2020
  • Added a missing %end:% tag as required by TNGv12.3
  • Upgraded to version 4 of the shared mod includes
  • In admin_places.php (the Places search form)
    • When trying to apply the "created since" search condition, check for the presence of the database field (as before), but don't display the warning message, which was awkardly presented before the page headings.
    • Instead, use the search form row created for the "created since" search condition to display the warning and link to the database setup utility.
      • Also display a link to the Mod Manager, for uninstalling the mod.
  • In the database setup utility
    • Removed the default value from the db field definition. It doesn't work in newer versions of MySql, and isn't needed, anyway.
    • Changed the default date value from 1 Jan 2000 to 31 Dec 1999
    • When deleting the field 'creationdate' silently remove old field 'datecreated' if it exists.
12.0.0.3 12.0-12.2+ 28Sep2019
  • Added an InnerModMenu to admin_places.php
  • Now modifies gedimport_misc.php to save the same date/time for all places created by a Gedcom Import.
  • Removed the dummy mod parameter that did nothing more than provide a link to the database setup utility.
  • Changed the database setup program to have tabs for the Mod Manager and the Admin Places Search to make it cleaner for it to be linked from and linked to both programs.
  • Added a link to the database setup utility in a .cfg file note tag.
12.0.0.2 12.0+ 4May2018 No functional changes; made compatible with TNGv12, and changed the filename of the database setup program.
11.0.0.1b 11.0-11.1.2 10Jan2018 No real functional changes. Removed an Admin>>Places tab for running the database setup program, since the it is only meant to be run once. The database setup program is now accessible through the mod description and the mod options in Mod Manager.
11.0.0.1 11.0-11.1.2+ 07Jan2018 New Mod

Sites using this mod

If you download and install this mod, please add your site to the table below.

URL User Note Mod-Version TNG-Version User-language
Robin Richmond's Genealogy Database Robin Richmond Mod developer 12.0.0.3b 12.3 English
Our Family History Paul Barrett Public/Private site 11.0.0.3a 11.1.2 EN
Retrieved from "https://tng.lythgoes.net/wiki/index.php?title=Admin_Places_Date&oldid=58503"