Display SQL Stats

1. 

   Showing chart in dashboard

2. 

   Settings

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

How can I support you?

Post a comment on Display SQL Stats

What is the plugin page?

Display SQL Stats

Do you have other plugins?

Check out my other WordPress Plugins

Where do I post my feedback?

Post it at the plugin page: Display SQL Stats

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