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.

4.1.76

  • Made minor layout changes and enhancements to the Edit Reports page.
  • Fixed the Delete Report button to work even when the queries fails.
  • moved to the global wpdb object for full compatibility with WP 3.9 on MySQL 5.5.

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.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.1.12.16

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

Requires: 2.6 or higher
Compatible up to: 3.9.2
Last Updated: 2014-5-6
Downloads: 5,637

Ratings

5 stars
5 out of 5 stars

Support

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

Got something to say? Need help?

Compatibility

+
=
Not enough data

0 people say 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
100,1,1
100,1,1 100,1,1
100,2,2