WordPress.org

Ready to get started?Download WordPress

Plugin Directory

ELI's SQL Admin Reports Shortcode and DB Backup

Create and save SQL Reports in your WP Admin and place them on pages and posts with a shortcode. Keep your database safe with automatic backups.

3.10.19

  • Fixed table header row that contains column names.
  • Added an SQL Reports widget for the sidebar and footer area.
  • Added support for multiple queries on one report.

3.08.03

  • Improved the compatibility and reliability of the restore process.

3.06.29

  • Add ability to place reports on the dashboard for a given Role.

3.06.24

  • Created a second method for backups that uses the command line mysql.
  • Made compression optional and backup location changable.
  • Made restore function able to connect to external an DB.
  • Fixed shortcode to work with sanitize_title.

3.06.14

  • Added a WP cron scheduler for hourly and daily backups.
  • Upgraded the Backup process to ZIP and email all backups.
  • Added a shortcode for wpdb::get_var

1.3.03.24

  • Fixed the Backup process to capture VIEW definitions properly.

1.3.03.02

  • Added database backup feature.
  • Fixed Report name issue when using apostrophes.

1.3.02.12

  • Added Menu Placement and sorting options.
  • Expanded eval function to take multiple global variables.

1.3.01.28

  • Added eval function to take PHP code in the SQL Statement.

1.2.09.23

  • Added css classes to the Table and TRs for better style control.

1.2.09.02

  • Fixed auto sort links and removed them from showing on finished reports.

1.2.04.16

  • Added error message to the Edit Report Page if SQL statement fails.

1.2.04.06

  • Added shortcode support so you can put your reports onto Pages and Posts.

1.2.03.16

  • Added basic sort capability by linking column names.

1.1.12.16

  • Added styled DIV around Reports with ID tag so that you can customize the style.

1.1.12.15

  • Fixed aditional plugin links.
  • Made the Save button label dynamic depending on the state of the report fields.

1.1.12.14

  • First version uploaded to WordPress.

Requires: 2.6 or higher
Compatible up to: 3.6.1
Last Updated: 2013-10-19
Downloads: 4,653

Ratings

5 stars
5 out of 5 stars

Support

1 of 2 support threads in the last two months have been resolved.

Got something to say? Need help?

Compatibility

+
=
Not enough data

1 person says it works.
0 people say it's broken.

100,1,1 100,1,1 100,1,1
100,1,1 100,1,1 100,1,1
100,1,1 100,3,3
100,2,2 100,2,2 100,1,1
100,1,1 100,2,2 100,2,2 100,1,1 100,1,1
100,1,1 100,2,2 100,3,3 100,1,1 100,1,1
100,1,1 100,3,3 100,1,1 100,1,1
100,1,1 100,1,1 100,1,1
100,1,1 100,1,1 100,1,1 100,1,1 100,1,1 100,1,1
100,1,1
100,1,1 100,1,1
100,1,1 100,1,1 100,1,1
100,1,1
100,1,1
100,1,1
100,1,1