Changeset 730389

Timestamp:

06/23/2013 03:06:00 PM (13 years ago)

Author:

rolice

Message:

1.3.1

• Fix with escaping strings in custom SQL clauses.

Location:

post-sorter

Files:

• tags/1.3.1 (added)
• trunk/page/general.php (modified) (2 diffs)
• trunk/post_sorter.php (modified) (3 diffs)
• trunk/readme.txt (modified) (2 diffs)

post-sorter/trunk/page/general.php

@@ -96 +96 @@
                     <th scope="row"><label for="post_sorter_join_clause"><?php _e( 'JOIN Clause', 'post_sorter' ) ?></label>:</th>
                     <td valign="top">
-                        <textarea name="post_sorter_join_clause" id="post_sorter_join_clause" rows="8" cols="80"><?php echo get_option('post_sorter_join_clause') ?></textarea>
+                        <textarea name="post_sorter_join_clause" id="post_sorter_join_clause" rows="8" cols="80"><?php echo str_replace( '\\', '', get_option( 'post_sorter_join_clause' ) ) ?></textarea>
                         <br />
                         <span class="hint"><?php _e( 'Your custom join clause that would be applied on the post list SQL query.', 'post_sorter' ) ?></span>
@@ -104 +104 @@
                     <th scope="row"><label for="post_sorter_order_by_clause"><?php _e( 'ORDER BY Clause', 'post_sorter' ) ?></label>:</th>
                     <td valign="top">
-                        <textarea name="post_sorter_order_by_clause" id="post_sorter_order_by_clause" rows="8" cols="80"><?php echo get_option('post_sorter_order_by_clause') ?></textarea>
+                        <textarea name="post_sorter_order_by_clause" id="post_sorter_order_by_clause" rows="8" cols="80"><?php echo str_replace( '\\', '', get_option( 'post_sorter_order_by_clause' ) ) ?></textarea>
                         <br />
                         <span class="hint"><?php _e( 'Your custom order by clause that would be applied on the post list SQL query.', 'post_sorter' ) ?></span>

post-sorter/trunk/post_sorter.php

@@ -4 +4 @@
   Plugin URI: http://intellisys.org/
   Description: Plugin for easy sorting of posts and pages by numeric value, both ascending and descending.
-  Version: 1.3
+  Version: 1.3.1
   Author: Lyubomir Gardev
   Author URI: http://rolice.intellisys.info/
@@ -474 +474 @@
      */
     public function internal_join( $sql ) {
-        if( !( $join = get_option( 'post_sorter_join_clause' ) ) )
+        if( !( $join = str_replace( '\\', '', get_option( 'post_sorter_join_clause' ) ) ) )
             return $sql;
         
@@ -486 +486 @@
      */
     public function internal_order( $sql ) {
-        if( !( $orderby = get_option( 'post_sorter_order_by_clause' ) ) )
+        if( !( $orderby = str_replace( '\\', '', get_option( 'post_sorter_order_by_clause' ) ) ) )
             return $sql;
         

post-sorter/trunk/readme.txt

@@ -5 +5 @@
 Requires at least: 3.2
 Tested up to: 3.5
-Stable tag: 1.3
+Stable tag: 1.3.1
 License: GPLv2 or later
 License URI: http://www.gnu.org/licenses/gpl-2.0.html
@@ -67 +67 @@
 == Changelog ==
 
+= 1.3.1 =
+* Escaping quotes with backslashes in SQL clauses fixed.
+
 = 1.3 =
 * Fixed a bug where custom post types disappear from the list. This problem was due to INNER join, but not OUTER.