이 플러그인은 최근 3개의 주요 워드프레스 출시와 시험 되지 않았습니다. 워드프레스의 좀 더 최근 버전으로 이용할 때 더 이상 관리되지 않고 지원되지 않고 호환성 문제가 있을 수 있습니다.

Display SQL Stats

설명

! ! ! 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?

스크린샷

  • Showing chart in dashboard
  • 설정을

설치

  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

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

후기

2016년 9월 3일
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.
모든 2 평가 읽기

기여자 & 개발자

“Display SQL Stats”(은)는 오픈 소스 소프트웨어입니다. 다음의 사람들이 이 플러그인에 기여하였습니다.

기여자

자국어로 “Display SQL Stats”(을)를 번역하세요.

개발에 관심이 있으십니까?

코드 탐색하기는, SVN 저장소를 확인하시거나, 개발 기록RSS로 구독하세요.

변경이력

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