Linux 软件免费装

在这里免费安装WordPress以及其他软件

EZ SQL Reports Shortcode Widget and DB Backup

开发者 scheeeli
更新时间 2025年2月19日 01:11
捐献地址: 去捐款
PHP版本: 2.6 及以上
WordPress版本: 6.7.2

标签

backup widget plugin dashboard shortcode admin database sql query cron reports schedule mysql

下载

1.2.09.23 1.3.01.28 1.2.04.06 1.3.02.12 1.3.03.02 1.3.03.24 3.06.14 3.06.24 3.06.29 3.08.03 3.10.19 4.1.76 4.11.13 4.11.15 4.11.33 4.11.37 4.16.38 4.17.38 4.17.42 5.21.35 5.25.08 1.1.12.16

详情介绍:

Just place some SQL on in the box and save it as a report. You can save multiple reports and they will be listed on the Admin Menu so you can quickly run them again anytime with just one click. You can place your reports on the User's Dashboard based on Roles. You can also put a report on a Page or Post using a shortcode like [SQLREPORT name="My Report" style="padding: 6px;" /] There is also an shortcode for the wpdb::get_var function that you can use to display a single value from your database. For example, this will display the number of users on your site: [sqlgetvar]SELECT COUNT(*) FROM wp_users[/sqlgetvar] Note: because of a known exploit in the WordPress shortcode functionality it is required that an admin user create an SQL Report with the exact query that will be used in the sqlgetvar shotcode, otherwise any subscriber could white their own shortcode query. If you want to include an "Export to CSV" button on your page or post then use the additional shortcode [SQLEXPORTCSV] once on any page or post that contains a report you want visitors to be able to download. Thanks to @loristictok and @rob66bnu for posting the suggestion with the JavaScript that I used to make this new Shortcode. Note: Adding this shortcode to the just one time will insert the "Export to CSV" button at the top of every HTML Table on the page. Automatic Database Backups Your database can be automatically saved and archived every hour and/or every day, and backups can be emailed to the address you specify. You can also restore the data to your WP DB or an external DB, which makes copying your database to another server and easy task.

安装:

  1. Download and unzip the plugin into your WordPress plugins directory (usually /wp-content/plugins/).
  2. Activate the plugin through the 'Plugins' menu in your WordPress Admin.

升级注意事项:

5.25.08 Added a filter to the style property of the Report-DIV to remove the ability of content authors to insert scripts into the shortcode that generates the Report HTML. Now you'll have to put those scripts directly into your content after the shotcode if you want to add them. 5.21.35 Added a Shortcode for an "Export to CSV" button, and fixed the "create_function() is deprecated" error and an Undefined Index notice to make the plugin compatible with the newest versions of PHP and WordPress. 4.17.42 Fixed the deletion of old backup files when the commandline backup method is used. 4.17.38 Changed all mysql_ functions to mysqli_ to fix deprecation errors, fixed the usage of %s in queries containing PHP variables, and fixed a vulnerability in the shortcodes that could be exploited by subscriber level users. 4.16.38 Fixed the custom backup directory setting and two deprecated function errors. 4.11.37 Fixed two vulnerabilities that could be exploited by site admins, thanks to Felipe Molina for discovering these bugs. 4.11.33 Upgraded Widget Class for compatibility with WordPress 4.3 changes. 4.11.15 Fixed some minor styles in the admin and added a feature to hide all the reports from the main admin menu. 4.11.13 Fixed some minor bugs, improved the handling of multiple queries and added a call to do_shortcode to the query results. 4.1.76 Made minor layout changes to the Edit Reports page, fixed the Delete Report button to work on failed queries, and used wpdb for full compatibility with WP 3.9. 3.10.19 Fixed table header row, added an SQL Reports widget, and 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, restore function able to connect to an external DB, and fixed shortcode to work with sanitize_title. 3.06.14 Added scheduler for hourly and daily backups, upgraded the Backup process to ZIP and email all backups, and added a shortcode for get_var. 1.3.03.24 Fixed the Backup process to capture VIEW definitions properly. 1.3.03.02 Added database backup feature and fixed Report name issue when using apostrophes. 1.3.02.12 Added Menu Placement and sorting options and 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.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.

常见问题:

What do I do after I activate the Plugin?

Start Creating and Saving Reports.

How do I get one of my reports onto a Page or Post?

Just use the shortcode SQLREPORT like this [SQLREPORT name="My Report" style="border: 2px solid #CCCCCC; padding: 6px;" /] but be sure the name attribute matches the exact name of a report you have already created.

How do I use a global PHP variable in one of my SQL queries?

Note: This < does not display properly on web pages so I used the HTML code < in this example, > works... SELECT display_name FROM wp_users WHERE ID = '<?php $current_user->ID ?>' (There are other ways to get the display name in WordPress, this is just a simple example to illustrate the proper syntax.) SELECT * FROM wp_users WHERE user_registered > '<?php $_GET[thedate] ?>' (note: this example assumes you are going to pass 'thedate' as a GET variable in the query string and, as this example shows, don't use quotes inside the PHP brackets.)

更新日志:

5.25.08 5.21.35 4.17.42 4.17.38 4.16.38 4.11.37 4.11.33 4.11.15 4.11.13 4.1.76 3.10.19 3.08.03 3.06.29 3.06.24 3.06.14 1.3.03.24 1.3.03.02 1.3.02.12 1.3.01.28 1.2.09.23 1.2.04.16 1.2.04.06 1.1.12.16