{"id":22990,"date":"2013-04-16T21:50:44","date_gmt":"2013-04-16T21:50:44","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/display-sql-stats\/"},"modified":"2017-05-15T14:22:01","modified_gmt":"2017-05-15T14:22:01","slug":"display-sql-stats","status":"publish","type":"plugin","link":"https:\/\/lmo.wordpress.org\/plugins\/display-sql-stats\/","author":2354754,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"0.9.5.1","stable_tag":"trunk","tested":"4.7.33","requires":"2.7","requires_php":"","requires_plugins":"","header_name":"Display SQL Stats","header_author":"J\u00fcrgen Schulze","header_description":"","assets_banners_color":"","last_updated":"2017-05-15 14:22:01","external_support_url":"","external_repository_url":"","donate_link":"http:\/\/1manfactory.com\/donate","header_plugin_uri":"http:\/\/wordpress.org\/plugins\/display-sql-stats\/","header_author_uri":"http:\/\/1manfactory.com","rating":5,"author_block_rating":0,"active_installs":10,"downloads":5353,"num_ratings":2,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":{"":"<p>Just do a normal upgrade.<\/p>"},"ratings":{"1":0,"2":0,"3":0,"4":0,"5":"2"},"assets_icons":[],"assets_banners":[],"assets_blueprints":{},"all_blocks":[],"tagged_versions":["0.1","0.2","0.3","0.4","0.5","0.6","0.6.1","0.6.2","0.6.3","0.6.3.1","0.6.4","0.6.5","0.7","0.8","0.8.1","0.8.2","0.9","0.9.1","0.9.2","0.9.3","0.9.4","0.9.4.1"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":"769584","resolution":"1","location":"assets"},"screenshot-2.png":{"filename":"screenshot-2.png","revision":"769584","resolution":"2","location":"assets"}},"screenshots":{"1":"Showing chart in dashboard","2":"Settings"},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[2510,4108,16398,24095,1627],"plugin_category":[36,59],"plugin_contributors":[78197],"plugin_business_model":[],"class_list":["post-22990","plugin","type-plugin","status-publish","hentry","plugin_tags-chart","plugin_tags-charts","plugin_tags-google-chart","plugin_tags-google-chart-tools","plugin_tags-mysql","plugin_category-analytics","plugin_category-utilities-and-tools","plugin_contributors-1manfactory","plugin_committers-1manfactory"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/display-sql-stats.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/display-sql-stats\/assets\/screenshot-1.png?rev=769584","caption":"Showing chart in dashboard"},{"src":"https:\/\/ps.w.org\/display-sql-stats\/assets\/screenshot-2.png?rev=769584","caption":"Settings"}],"raw_content":"<!--section=description-->\n<p>! ! !  S T I L L   B E T A  ! ! !<\/p>\n\n<p>Displaying SQL result data as graphical chart on your blog (shortcodes) or your dashboard with use of Google Chart Tools.<\/p>\n\n<h3>Remove plugin<\/h3>\n\n<ol>\n<li>Deactivate plugin through the 'Plugins' menu in WordPress<\/li>\n<li>Delete plugin through the 'Plugins' menu in WordPress<\/li>\n<\/ol>\n\n<p>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.<\/p>\n\n<h3>To do<\/h3>\n\n<p>More translations. Does someone wants to help?<\/p>\n\n<!--section=installation-->\n<ol>\n<li>Upload plugin to the <code>\/wp-content\/plugins\/<\/code> folder<\/li>\n<li>Activate the plugin<\/li>\n<li>Edit\/Insert SQL Stament in Settings<\/li>\n<li>Watch in dashboard<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt>Installation Instructions<\/dt>\n<dd><ol>\n<li>Upload plugin to the <code>\/wp-content\/plugins\/<\/code> folder<\/li>\n<li>Activate the plugin<\/li>\n<li>Edit\/Insert SQL Stament in Settings<\/li>\n<li>Watch in dashboard<\/li>\n<\/ol><\/dd>\n<dt>variable #user_login#<\/dt>\n<dd><p>Use SQL statements with #user_login# to be replaced by user login on the fly\nEg. SELECT * FROM wp_users WHERE user_login='#user_login#;'\nWill only give one line whith the result of the current user login, where\nSELECT * FROM wp_users;\nwill give you all lines<\/p><\/dd>\n<dt>What about the shortcode?<\/dt>\n<dd><p>[dsscode no=x title=\"My Title\" width=\"100%\" height=\"400\" pagesize=\"50\"]\nx is the number of your SQL statement\ntitle is the title\nwidth, use percent values oder just figures which will be treated as picxel, leave empty for full width of 100%\nheight=\"400\", same as above\npagesize=\"50\": The number of rows in each page (only with charttype table)<\/p><\/dd>\n<dt>Can I access other databases than wordpress database?<\/dt>\n<dd><p>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.<\/p><\/dd>\n<dt>Where can I find more information on Google Charts?<\/dt>\n<dd><p><a href=\"https:\/\/developers.google.com\/chart\/\">Google Charts<\/a><\/p><\/dd>\n<dt>How can I support you?<\/dt>\n<dd><p>Post a comment on <a href=\"http:\/\/1manfactory.com\/dss\">Display SQL Stats<\/a><\/p><\/dd>\n<dt>What is the plugin page?<\/dt>\n<dd><p><a href=\"http:\/\/1manfactory.com\/dss\">Display SQL Stats<\/a><\/p><\/dd>\n<dt>Do you have other plugins?<\/dt>\n<dd><p>Check out my other <a href=\"http:\/\/profiles.wordpress.org\/1manfactory\">Wordpress Plugins<\/a><\/p><\/dd>\n<dt>Where do I post my feedback?<\/dt>\n<dd><p>Post it at the plugin page: <a href=\"http:\/\/1manfactory.com\/dss\">Display SQL Stats<\/a><\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>0.9.5.1(2017\/05\/15)<\/h4>\n\n<ul>\n<li>tested with WP 4.7.4<\/li>\n<li>google source only included in front end if needed by short code<\/li>\n<\/ul>\n\n<h4>0.9.5(2016\/04\/13)<\/h4>\n\n<ul>\n<li>tested with WP 4.5<\/li>\n<li>replaced deprecated function get_currentuserinfo with wp_get_current_user<\/li>\n<\/ul>\n\n<h4>0.9.4.2(2015\/09\/13)<\/h4>\n\n<ul>\n<li>tested von WP 4.3<\/li>\n<li>remove more unnecessary warning messages<\/li>\n<\/ul>\n\n<h4>0.9.4.1(2014\/12\/22)<\/h4>\n\n<ul>\n<li>tested von WP 4.1<\/li>\n<li>remove unnecessary warning message<\/li>\n<\/ul>\n\n<h4>0.9.4 (2014\/12\/12)<\/h4>\n\n<ul>\n<li>default settings: width and height<\/li>\n<li>new statements are always attached at the end to keep numbering straight.<\/li>\n<\/ul>\n\n<h4>0.9.3 (2014\/12\/10)<\/h4>\n\n<ul>\n<li>More settings for shortcode table (see faqs)<\/li>\n<li>Added variable #user_login# to be replaced with user login name on the fly (see faqs)<\/li>\n<\/ul>\n\n<h4>0.9.2 (2014\/12\/10)<\/h4>\n\n<ul>\n<li>New chart type: Table (a pure, sortable, smart table)<\/li>\n<li>added title to shortcode<\/li>\n<\/ul>\n\n<h4>0.9.1 (2014\/07\/06)<\/h4>\n\n<ul>\n<li>typo<\/li>\n<li>handling of session error during activation<\/li>\n<\/ul>\n\n<h4>0.9.0 (2014\/07\/06)<\/h4>\n\n<ul>\n<li>Now with shortcodes to place your graphics everywhere (read FAQ section)<\/li>\n<\/ul>\n\n<h4>0.8.2 (2014\/05\/17)<\/h4>\n\n<ul>\n<li>fix of small bug on empty values<\/li>\n<\/ul>\n\n<h4>0.8.1 (2014\/04\/27)<\/h4>\n\n<ul>\n<li>deleting of unnecessary warning message<\/li>\n<\/ul>\n\n<h4>0.8 (2014\/04\/27)<\/h4>\n\n<ul>\n<li>allow user with different roles to see results on dashboard<\/li>\n<\/ul>\n\n<h4>0.7 (2014\/02\/05)<\/h4>\n\n<ul>\n<li>adding\/removing SQL statements more stylish<\/li>\n<\/ul>\n\n<h4>0.6.5 (2013\/12\/27)<\/h4>\n\n<ul>\n<li>fix bug on automatic detection of column types<\/li>\n<li>better formatting of debug information<\/li>\n<\/ul>\n\n<h4>0.6.4 (2013\/11\/08)<\/h4>\n\n<ul>\n<li>only enrich header when on dashboard<\/li>\n<\/ul>\n\n<h4>0.6.3.1 (2013\/10\/17)<\/h4>\n\n<ul>\n<li>fixing small bug on min\/max values when using more than one barcharts<\/li>\n<\/ul>\n\n<h4>0.6.3 (2013\/10\/15)<\/h4>\n\n<ul>\n<li>placing automatic max\/min values on barcharts for better visualisation<\/li>\n<\/ul>\n\n<h4>0.6.2 (2013\/09\/14)<\/h4>\n\n<ul>\n<li>bug fix on emtpy results<\/li>\n<li>switch charts on\/off<\/li>\n<\/ul>\n\n<h4>0.6.1 (2013\/09\/14)<\/h4>\n\n<ul>\n<li>bug fix on wrong date display<\/li>\n<\/ul>\n\n<h4>0.6 (2013\/09\/14)<\/h4>\n\n<ul>\n<li>Check on Wordpress 3.6.1<\/li>\n<li>New chart types: Bar Chart<\/li>\n<li>auto detecting of column types: date, number, string<\/li>\n<\/ul>\n\n<h4>0.5 (2013\/09\/10)<\/h4>\n\n<ul>\n<li>Use different chart types (Pie Chart, Scatter Chart, Bubble Chart)<\/li>\n<\/ul>\n\n<h4>0.4 (2013\/08\/21)<\/h4>\n\n<ul>\n<li>Use multiple SQL statments and charts<\/li>\n<\/ul>\n\n<h4>0.3 (2013\/08\/17)<\/h4>\n\n<ul>\n<li>Tested with WP 3.6<\/li>\n<li>New default demo SQL to demonstrate how to insert additional columns<\/li>\n<\/ul>\n\n<h4>0.2 (2013\/04\/25)<\/h4>\n\n<ul>\n<li>NEW: Notepad function to store different SQL statement, ideas or whatever<\/li>\n<\/ul>\n\n<h4>0.1 (2013\/04\/16)<\/h4>\n\n<ul>\n<li>first test version<\/li>\n<\/ul>","raw_excerpt":"! ! !  S T I L L   B E T A  ! ! !","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/lmo.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/22990","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lmo.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/lmo.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/lmo.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=22990"}],"author":[{"embeddable":true,"href":"https:\/\/lmo.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/1manfactory"}],"wp:attachment":[{"href":"https:\/\/lmo.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=22990"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/lmo.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=22990"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/lmo.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=22990"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/lmo.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=22990"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/lmo.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=22990"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/lmo.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=22990"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}