Changeset 7645 for trunk/wp-admin/update-links.php

Timestamp:

04/14/2008 04:13:25 PM (17 years ago)

Author:

ryan

Message:

Prepare DB queries in more places. Props filosofo. see #6644

File:

• trunk/wp-admin/update-links.php (modified) (1 diff)

trunk/wp-admin/update-links.php

@@ -37 +37 @@
 
     foreach ($returns as $return) :
-        $time = $wpdb->escape( substr($return, 0, 19) );
-        $uri = $wpdb->escape( preg_replace('/(.*?) | (.*?)/', '$2', $return) );
-        $wpdb->query("UPDATE $wpdb->links SET link_updated = '$time' WHERE link_url = '$uri'");
+        $time = substr($return, 0, 19);
+        $uri = preg_replace('/(.*?) | (.*?)/', '$2', $return);
+        $wpdb->query( $wpdb->prepare("UPDATE $wpdb->links SET link_updated = %s WHERE link_url = %s", $time, $uri) );
     endforeach;
 }