Changeset 21178

Timestamp:

06/29/2012 03:08:17 PM (12 years ago)

Author:

nacin

Message:

Correctly identify queries where a line break follows a keyword, rather than a space. props GeertDD, fixes #19467.

File:

• trunk/wp-includes/wp-db.php (modified) (1 diff)

trunk/wp-includes/wp-db.php

@@ -1107 +1107 @@
         }
 
-        if ( preg_match( '/^\s*(create|alter|truncate|drop) /i', $query ) ) {
+        if ( preg_match( '/^\s*(create|alter|truncate|drop)\s/i', $query ) ) {
             $return_val = $this->result;
-        } elseif ( preg_match( '/^\s*(insert|delete|update|replace) /i', $query ) ) {
+        } elseif ( preg_match( '/^\s*(insert|delete|update|replace)\s/i', $query ) ) {
             $this->rows_affected = mysql_affected_rows( $this->dbh );
             // Take note of the insert_id
-            if ( preg_match( '/^\s*(insert|replace) /i', $query ) ) {
+            if ( preg_match( '/^\s*(insert|replace)\s/i', $query ) ) {
                 $this->insert_id = mysql_insert_id($this->dbh);
             }