Title: Display SQL Stats Author: Juergen Schulze Published: 16 Avril 2013 Last modified: 15 Masg 2017 --- Search plugins This plugin **hasn’t been tested with the latest 3 major releases of WordPress**. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress. ![](https://s.w.org/plugins/geopattern-icon/display-sql-stats.svg) # Display SQL Stats By [Juergen Schulze](https://profiles.wordpress.org/1manfactory/) [Download](https://downloads.wordpress.org/plugin/display-sql-stats.zip) * [Details](https://lmo.wordpress.org/plugins/display-sql-stats/#description) * [Reviews](https://lmo.wordpress.org/plugins/display-sql-stats/#reviews) * [Installation](https://lmo.wordpress.org/plugins/display-sql-stats/#installation) * [Development](https://lmo.wordpress.org/plugins/display-sql-stats/#developers) [Support](https://wordpress.org/support/plugin/display-sql-stats/) ## Description ! ! ! S T I L L B E T A ! ! ! Displaying SQL result data as graphical chart on your blog (shortcodes) or your dashboard with use of Google Chart Tools. ### Remove plugin 1. Deactivate plugin through the ‘Plugins’ menu in WordPress 2. Delete plugin through the ‘Plugins’ menu in WordPress It’s best to use the build in delete function of wordpress. That way all the stored data will be removed and no orphaned data will stay. ### To do More translations. Does someone wants to help? ## Screenshots * [[ * Showing chart in dashboard * [[ * Settings ## Installation 1. Upload plugin to the `/wp-content/plugins/` folder 2. Activate the plugin 3. Edit/Insert SQL Stament in Settings 4. Watch in dashboard ## FAQ Installation Instructions 1. Upload plugin to the `/wp-content/plugins/` folder 2. Activate the plugin 3. Edit/Insert SQL Stament in Settings 4. Watch in dashboard variable #user_login# Use SQL statements with #user_login# to be replaced by user login on the fly Eg. SELECT * FROM wp_users WHERE user_login=’#user_login#;’ Will only give one line whith the result of the current user login, where SELECT * FROM wp_users; will give you all lines What about the shortcode? [dsscode no=x title=”My Title” width=”100%” height=”400″ pagesize=”50″] x is the number of your SQL statement title is the title width, use percent values oder just figures which will be treated as picxel, leave empty for full width of 100% height =”400″, same as above pagesize=”50″: The number of rows in each page (only with charttype table) Can I access other databases than wordpress database? Yes, but you have the grant your user access (better only select rights) to the database. Than you can use “SELECT * FROM database.table;” as you are used to. Be careful this might cause security risks. Where can I find more information on Google Charts? [Google Charts](https://developers.google.com/chart/) How can I support you? Post a comment on [Display SQL Stats](http://1manfactory.com/dss) What is the plugin page? [Display SQL Stats](http://1manfactory.com/dss) Do you have other plugins? Check out my other [WordPress Plugins](https://profiles.wordpress.org/1manfactory) Where do I post my feedback? Post it at the plugin page: [Display SQL Stats](http://1manfactory.com/dss) ## Reviews ![](https://secure.gravatar.com/avatar/0f90d067a229711e82bf72e9185878da93dd6c08343205cf0b5a836f5c883991? s=60&d=retro&r=g) ### 󠀁[Intuitive, easy to use and does the job](https://wordpress.org/support/topic/intuitive-easy-to-use-and-does-the-job/)󠁿 [OliviaL](https://profiles.wordpress.org/olivial/) 03 Setember 2016 Interestingly, the plugin does not requires me to specify x and y axes, but somehow it figures out. I guess user would have to put the x axis values in the first column and y axis values in the following columns. I’ve tried several charts-making plugins. I would have to say this is exactly the one I needed. There are some other charts- making plugins are quite popular, but you can barely do anything with their free versions. [ Read all 2 reviews ](https://wordpress.org/support/plugin/display-sql-stats/reviews/) ## Contributors & Developers “Display SQL Stats” is open source software. The following people have contributed to this plugin. Contributors * [ Juergen Schulze ](https://profiles.wordpress.org/1manfactory/) [Translate “Display SQL Stats” into your language.](https://translate.wordpress.org/projects/wp-plugins/display-sql-stats) ### Interested in development? [Browse the code](https://plugins.trac.wordpress.org/browser/display-sql-stats/), check out the [SVN repository](https://plugins.svn.wordpress.org/display-sql-stats/), or subscribe to the [development log](https://plugins.trac.wordpress.org/log/display-sql-stats/) by [RSS](https://plugins.trac.wordpress.org/log/display-sql-stats/?limit=100&mode=stop_on_copy&format=rss). ## Changelog #### 0.9.5.1(2017/05/15) * tested with WP 4.7.4 * google source only included in front end if needed by short code #### 0.9.5(2016/04/13) * tested with WP 4.5 * replaced deprecated function get_currentuserinfo with wp_get_current_user #### 0.9.4.2(2015/09/13) * tested von WP 4.3 * remove more unnecessary warning messages #### 0.9.4.1(2014/12/22) * tested von WP 4.1 * remove unnecessary warning message #### 0.9.4 (2014/12/12) * default settings: width and height * new statements are always attached at the end to keep numbering straight. #### 0.9.3 (2014/12/10) * More settings for shortcode table (see faqs) * Added variable #user_login# to be replaced with user login name on the fly (see faqs) #### 0.9.2 (2014/12/10) * New chart type: Table (a pure, sortable, smart table) * added title to shortcode #### 0.9.1 (2014/07/06) * typo * handling of session error during activation #### 0.9.0 (2014/07/06) * Now with shortcodes to place your graphics everywhere (read FAQ section) #### 0.8.2 (2014/05/17) * fix of small bug on empty values #### 0.8.1 (2014/04/27) * deleting of unnecessary warning message #### 0.8 (2014/04/27) * allow user with different roles to see results on dashboard #### 0.7 (2014/02/05) * adding/removing SQL statements more stylish #### 0.6.5 (2013/12/27) * fix bug on automatic detection of column types * better formatting of debug information #### 0.6.4 (2013/11/08) * only enrich header when on dashboard #### 0.6.3.1 (2013/10/17) * fixing small bug on min/max values when using more than one barcharts #### 0.6.3 (2013/10/15) * placing automatic max/min values on barcharts for better visualisation #### 0.6.2 (2013/09/14) * bug fix on emtpy results * switch charts on/off #### 0.6.1 (2013/09/14) * bug fix on wrong date display #### 0.6 (2013/09/14) * Check on WordPress 3.6.1 * New chart types: Bar Chart * auto detecting of column types: date, number, string #### 0.5 (2013/09/10) * Use different chart types (Pie Chart, Scatter Chart, Bubble Chart) #### 0.4 (2013/08/21) * Use multiple SQL statments and charts #### 0.3 (2013/08/17) * Tested with WP 3.6 * New default demo SQL to demonstrate how to insert additional columns #### 0.2 (2013/04/25) * NEW: Notepad function to store different SQL statement, ideas or whatever #### 0.1 (2013/04/16) * first test version ## Meta * Version **0.9.5.1** * Last updated **9 years ago** * Active installations **10+** * WordPress version ** 2.7 or higher ** * Tested up to **4.7.33** * Language * [English (US)](https://wordpress.org/plugins/display-sql-stats/) * Tags * [chart](https://lmo.wordpress.org/plugins/tags/chart/)[charts](https://lmo.wordpress.org/plugins/tags/charts/) [google chart](https://lmo.wordpress.org/plugins/tags/google-chart/)[mysql](https://lmo.wordpress.org/plugins/tags/mysql/) * [Advanced View](https://lmo.wordpress.org/plugins/display-sql-stats/advanced/) ## Ratings 5 out of 5 stars. * [ 2 5-star reviews ](https://wordpress.org/support/plugin/display-sql-stats/reviews/?filter=5) * [ 0 4-star reviews ](https://wordpress.org/support/plugin/display-sql-stats/reviews/?filter=4) * [ 0 3-star reviews ](https://wordpress.org/support/plugin/display-sql-stats/reviews/?filter=3) * [ 0 2-star reviews ](https://wordpress.org/support/plugin/display-sql-stats/reviews/?filter=2) * [ 0 1-star reviews ](https://wordpress.org/support/plugin/display-sql-stats/reviews/?filter=1) [Add my review](https://wordpress.org/support/plugin/display-sql-stats/reviews/#new-post) [See all reviews](https://wordpress.org/support/plugin/display-sql-stats/reviews/) ## Contributors * [ Juergen Schulze ](https://profiles.wordpress.org/1manfactory/) ## Support Got something to say? Need help? [View support forum](https://wordpress.org/support/plugin/display-sql-stats/) ## Donate Would you like to support the advancement of this plugin? [ Donate to this plugin ](http://1manfactory.com/donate)