Changeset 1180090

Timestamp:

06/13/2015 07:26:08 AM (11 years ago)

Author:

sharewebdesign

Message:

Plugin update to fix db prefix issue

Location:

simple-quick-tags/trunk

Files:

• readme.txt (modified) (3 diffs)
• simple-quick-tags.php (modified) (1 diff)

simple-quick-tags/trunk/readme.txt

@@ -5 +5 @@
 Tags: quicktags, text editor, html
 Requires at least: 3.3
-Tested up to: 4.0
-Stable tag: 1.0
+Tested up to: 4.2.2
+Stable tag: 1.1
 License: GPLv2 or later
 License URI: http://www.gnu.org/licenses/gpl-2.0.html
@@ -40 +40 @@
 == Changelog ==
 
+= 1.1 =
+Added $table_name = $wpdb->base_prefix . 'options'; and now using $table_name rather than just using wp_options.
+
 = 1.0 =
 Public Release
@@ -45 +48 @@
 == Upgrade Notice ==
 
-This is the 1st Public Release and the current stable version.
+This fixes the issue with the plugin not working on WordPress installations that use a custom database prefix (e.g. NOT wp_). 

simple-quick-tags/trunk/simple-quick-tags.php

@@ -104 +104 @@
     global $wpdb;
 
-$simple_quicktags_p_value = $wpdb->get_var("SELECT option_value FROM wp_options WHERE option_name = 'simple-quicktags-p'");
-$simple_quicktags_br_value = $wpdb->get_var("SELECT option_value FROM wp_options WHERE option_name = 'simple-quicktags-br'");
-$simple_quicktags_h1_value = $wpdb->get_var("SELECT option_value FROM wp_options WHERE option_name = 'simple-quicktags-h1'");
-$simple_quicktags_h2_value = $wpdb->get_var("SELECT option_value FROM wp_options WHERE option_name = 'simple-quicktags-h2'");
-$simple_quicktags_h3_value = $wpdb->get_var("SELECT option_value FROM wp_options WHERE option_name = 'simple-quicktags-h3'");
-$simple_quicktags_h4_value = $wpdb->get_var("SELECT option_value FROM wp_options WHERE option_name = 'simple-quicktags-h4'");
-$simple_quicktags_h5_value = $wpdb->get_var("SELECT option_value FROM wp_options WHERE option_name = 'simple-quicktags-h5'");
-$simple_quicktags_h6_value = $wpdb->get_var("SELECT option_value FROM wp_options WHERE option_name = 'simple-quicktags-h6'");
-$simple_quicktags_pb_value = $wpdb->get_var("SELECT option_value FROM wp_options WHERE option_name = 'simple-quicktags-pb'");
+$table_name = $wpdb->base_prefix . 'options';
+
+$simple_quicktags_p_value = $wpdb->get_var("SELECT option_value FROM $table_name WHERE option_name = 'simple-quicktags-p'");
+$simple_quicktags_br_value = $wpdb->get_var("SELECT option_value FROM $table_name WHERE option_name = 'simple-quicktags-br'");
+$simple_quicktags_h1_value = $wpdb->get_var("SELECT option_value FROM $table_name WHERE option_name = 'simple-quicktags-h1'");
+$simple_quicktags_h2_value = $wpdb->get_var("SELECT option_value FROM $table_name WHERE option_name = 'simple-quicktags-h2'");
+$simple_quicktags_h3_value = $wpdb->get_var("SELECT option_value FROM $table_name WHERE option_name = 'simple-quicktags-h3'");
+$simple_quicktags_h4_value = $wpdb->get_var("SELECT option_value FROM $table_name WHERE option_name = 'simple-quicktags-h4'");
+$simple_quicktags_h5_value = $wpdb->get_var("SELECT option_value FROM $table_name WHERE option_name = 'simple-quicktags-h5'");
+$simple_quicktags_h6_value = $wpdb->get_var("SELECT option_value FROM $table_name WHERE option_name = 'simple-quicktags-h6'");
+$simple_quicktags_pb_value = $wpdb->get_var("SELECT option_value FROM $table_name WHERE option_name = 'simple-quicktags-pb'");
 
     if (wp_script_is('quicktags')){