Difference between revisions of "Admin Places Date"

From TNG_Wiki
Jump to navigation Jump to search
(mod v1b)
Line 3: Line 3:
 
|  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.php, the Admin>>Places>>Search program
 
| mod_validation  =  
 
| mod_validation  =  
| mod_last_update = 10 Jan 2018
+
| mod_last_update = 11 Jan 2018
| download_link  = [[Media:admin_places_date_v11.0.0.1a.zip|11.0.0.1a]]{{Tv110}}
+
| download_link  = [[Media:admin_places_date_v11.0.0.1b.zip|11.0.0.1b]]{{Tv110}}
 
| download_stats  =
 
| download_stats  =
 
| mod_author      = [[User:Robinrichm|Robin Richmond]]
 
| mod_author      = [[User:Robinrichm|Robin Richmond]]
Line 10: Line 10:
 
| 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    = 11.0.0.1b
 
| 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    = at least 11.1.2
Line 67: Line 67:
 
! Note
 
! Note
 
|-  
 
|-  
| 11.0.0.1
+
| 11.0.0.1b
 +
| 11.0 - 11.1.2+
 +
| 11 Jan 2018
 +
| Had to update the SQL command created the database field. The old one worked on MySQL5, but didn't work in MySQL7.
 +
Also added a dummy parameter to provide another way to create the database field.
 +
|-
 +
| 11.0.0.1a
 
| 11.0 - 11.1.2+
 
| 11.0 - 11.1.2+
 
| 10 Jan 2018
 
| 10 Jan 2018

Revision as of 21:45, 12 January 2018

Admin Places Date
Summary Adds a Creation Date to the Places table, and search features that use it in admin_places.php, the Admin>>Places>>Search program
Validation
Mod Updated 11 Jan 2018
Download link 11.0.0.1b
TNG 11.0
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 11.0.0.1b
Min TNG V 11.0 (probably earlier)
Max TNG V at least 11.1.2
Files modified
admin_places.php, installs admin_placesdate_dbsetup.php
Related Mods
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 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. }}

Compatibility with other Mods

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

Installation

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, and 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.

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 Versions Date Note
11.0.0.1b 11.0 - 11.1.2+ 11 Jan 2018 Had to update the SQL command created the database field. The old one worked on MySQL5, but didn't work in MySQL7.

Also added a dummy parameter to provide another way to create the database field.

11.0.0.1a 11.0 - 11.1.2+ 10 Jan 2018 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.
New Mod 11.0.0.1 11.0 - 11.1.2+ 7 Jan 2018 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 11.0.0.1 11.12 English