Changeset 927089

Timestamp:

06/05/2014 12:14:20 PM (12 years ago)

Author:

michaeltyson

Message:

WP 3.9 compatibility fix, thanks to Sowmedia

Location:

custom-permalinks

Files:

• tags/0.7.19 (added)
• tags/0.7.19/custom-permalinks.php (added)
• tags/0.7.19/index.html (added)
• tags/0.7.19/readme.txt (added)
• trunk/custom-permalinks.php (modified) (3 diffs)
• trunk/readme.txt (modified) (2 diffs)

custom-permalinks/trunk/custom-permalinks.php

@@ -5 +5 @@
 Donate link: http://atastypixel.com/blog/wordpress/plugins/custom-permalinks/
 Description: Set custom permalinks on a per-post basis
-Version: 0.7.18
+Version: 0.7.19
 Author: Michael Tyson
 Author URI: http://atastypixel.com/blog
@@ -161 +161 @@
     if ( !$request ) return $query;
     
-    $sql = "SELECT $wpdb->posts.ID, $wpdb->postmeta.meta_value, $wpdb->posts.post_type FROM $wpdb->posts  ".
+    // Queries are now WP3.9 compatible (by Steve from Sowmedia.nl)
+    $sql = $wpdb->prepare("SELECT $wpdb->posts.ID, $wpdb->postmeta.meta_value, $wpdb->posts.post_type FROM $wpdb->posts  ".
                 "LEFT JOIN $wpdb->postmeta ON ($wpdb->posts.ID = $wpdb->postmeta.post_id) WHERE ".
                 "  meta_key = 'custom_permalink' AND ".
                 "  meta_value != '' AND ".
-                "  ( LOWER(meta_value) = LEFT(LOWER('".mysql_real_escape_string($request_noslash)."'), LENGTH(meta_value)) OR ".
-                "    LOWER(meta_value) = LEFT(LOWER('".mysql_real_escape_string($request_noslash."/")."'), LENGTH(meta_value)) ) ".
+                "  ( LOWER(meta_value) = LEFT(LOWER('%s'), LENGTH(meta_value)) OR ".
+                "    LOWER(meta_value) = LEFT(LOWER('%s'), LENGTH(meta_value)) ) ".
                 "  AND post_status != 'trash' AND post_type != 'nav_menu_item'".
                 " ORDER BY LENGTH(meta_value) DESC, ".
                 " FIELD(post_status,'publish','private','draft','auto-draft','inherit'),".
                 " FIELD(post_type,'post','page'),".
-                "$wpdb->posts.ID ASC  LIMIT 1";
+                "$wpdb->posts.ID ASC  LIMIT 1",
+            $request_noslash,
+            $request_noslash."/"
+            );
 
     $posts = $wpdb->get_results($sql);
@@ -512 +516 @@
 function custom_permalinks_delete_permalink( $id ){
     global $wpdb;
-    $wpdb->query("DELETE FROM $wpdb->postmeta WHERE `meta_key` = 'custom_permalink' AND `post_id` = '".mysql_real_escape_string($id)."'");
+    // Queries are now WP3.9 compatible (by Steve from Sowmedia.nl)
+    $wpdb->query($wpdb->prepare("DELETE FROM $wpdb->postmeta WHERE `meta_key` = 'custom_permalink' AND `post_id` = %d",$id));
 }
 

custom-permalinks/trunk/readme.txt

@@ -4 +4 @@
 Tags: permalink, url, link, address, custom, redirect
 Requires at least: 2.6
-Tested up to: 3.3.1
-Stable tag: 0.7.18
+Tested up to: 3.9
+Stable tag: 0.7.19
 
 Set custom permalinks on a per-post, per-tag or per-category basis.
@@ -29 +29 @@
 
 == Changelog ==
+
+= 0.7.19 =
+
+  * WP 3.9 compatibility fix, thanks to Sowmedia
 
 = 0.7.18 =