- []](#bugfix) Extra security measure added - credit @hughbris
-
- propagate id in shortcode to table,
- credit to Matt Marsh @marshmn
-
- log function at line 16 SqlTableShortcode requires two parameters, not one.
- credit to @dlannan
-
- A more elaborate example is added to show how to obtain data from a database, change data by creating a form, then update the row in the database.
-
- Extra security option. Allows for more paranoia
- When enabled, each page with an [sql-table] shortcode must have explicit header permission
- This is to prevent shortcode being added in the front end by an editor
-
- fix file permission from 0666 to 0664
-
- More logging options, allowing for the SELECT, INSERT and UPDATE stanzas (in addition to Errors) to be trapped.
- Append the logged data to the directory
user/data/sqlite
as a 'log.txt' file- This allows an Administrator to view the data from within the Admin panel using the DataManager plugin.
- [](#change of configuration)
- The default configuration for the placement of the sqlite3 database is now
user/data/sqlite
- The default configuration for the placement of the sqlite3 database is now
-
- Add
ignore
field insql-insert
andsql-update
- Add
error_logging
configuration option, so that SQL errors are written to hard drive
- Add
- [*](#bug and enhancement)
- Process
sqlite-insert
corrected tosql-insert
- Removed fields provided by
Form
plugin, viz._xxx
&form-nonce
- Process
- * * error in translate call
#v1.2.0
- *
- Allow for Twig variables to be used in SELECT stanza in shortcode, and in 'where' field of UPDATE Form process.