Reports Action Queries

From TNG_Wiki
Revision as of 09:32, 27 October 2018 by KenRoy (talk | contribs) (Text replacement - "{{RobinV12_cust_text_update}}" to "{{V12_cust_text}}")
Jump to navigation Jump to search


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


Added my TNGv22 cust_text.php upgrade template
reports_action_queries
Summary Allows SQL action queries in TNG reports in the TNG report-writer
Validation
Mod Updated 07 Nov 2017
Download link v11.0.0.1p
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.1p
Min TNG V 11.0.0.1p
Max TNG V at least 11.1.2
Files modified
admin_reports.php, showreport.php, English cust_text.php
Related Mods
Show Mod Names (optional)
Notes


Purpose of the Mod

Supports SQL action queries in TNG reports by

  1. Flagging them in the Admin >> Reports screen, and
  2. Modifying adminreport.php to recognize them and report the number of records changed.

Compatibility with other Mods

No known incompatibilities, but please let me know if you encounter any.

Mod Dependencies

This mod saves data that can be used by the Show Mod Names utility mod, but is not dependent on Show Mod Names. There are no other strict dependencies on other mods.

Requirements

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

Installation

  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.

In the event of a problem

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

Visualizations

none yet

Revision History

Mod Version TNG Versions Date Note
11.0.0.1p 10.1.0-11.1.2+ 07 Nov 2017 Removed the second line from the cust_text.php target location search string
11.0.0.1 11.0+ 17-May-2017 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.0.1 11.1.1 English