Changeset 32414 for branches/3.9/src/wp-includes/wp-db.php

Timestamp:

05/06/2015 09:04:46 PM (11 years ago)

Author:

johnbillion

Message:

WPDB: Allow queries to reference tables in the dbname.tablename format, and allow table names to contain any valid character, rather than just ASCII.

Merge of [32368] to the 3.9 branch.

Props pento, willstedt for the initial patch.

See #32090.

File:

• branches/3.9/src/wp-includes/wp-db.php (modified) (4 diffs)

branches/3.9/src/wp-includes/wp-db.php

@@ -2210 +2210 @@
 
                 $charsets = $columns = array();
-                $results = $this->get_results( "SHOW FULL COLUMNS FROM `$table`" );
+
+                $table_parts = explode( '.', $table );
+                $table = '`' . implode( '`.`', $table_parts ) . '`';
+                $results = $this->get_results( "SHOW FULL COLUMNS FROM $table" );
                 if ( ! $results ) {
                         return new WP_Error( 'wpdb_get_table_charset_failure' );
@@ -2783 +2786 @@
                                 . '|UPDATE(?:\s+LOW_PRIORITY)?(?:\s+IGNORE)?'
                                 . '|DELETE(?:\s+LOW_PRIORITY|\s+QUICK|\s+IGNORE)*(?:\s+FROM)?'
-                                . ')\s+`?([\w-]+)`?/is', $query, $maybe ) ) {
-                        return $maybe[1];
+                                . ')\s+((?:[0-9a-zA-Z$_.`]|[\xC2-\xDF][\x80-\xBF])+)/is', $query, $maybe ) ) {
+                        return str_replace( '`', '', $maybe[1] );
                 }
 
@@ -2791 +2794 @@
                                 . 'SHOW\s+TABLE\s+STATUS.+(?:LIKE\s+|WHERE\s+Name\s*=\s*)'
                                 . '|SHOW\s+(?:FULL\s+)?TABLES.+(?:LIKE\s+|WHERE\s+Name\s*=\s*)'
-                                . ')\W([\w-]+)\W/is', $query, $maybe ) ) {
-                        return $maybe[1];
+                                . ')\W((?:[0-9a-zA-Z$_.`]|[\xC2-\xDF][\x80-\xBF])+)\W/is', $query, $maybe ) ) {
+                        return str_replace( '`', '', $maybe[1] );
                 }
 
@@ -2810 +2813 @@
                                 . '|(?:GRANT|REVOKE).*ON\s+TABLE'
                                 . '|SHOW\s+(?:.*FROM|.*TABLE)'
-                                . ')\s+\(*\s*`?([\w-]+)`?\s*\)*/is', $query, $maybe ) ) {
-                        return $maybe[1];
+                                . ')\s+\(*\s*((?:[0-9a-zA-Z$_.`]|[\xC2-\xDF][\x80-\xBF])+)\s*\)*/is', $query, $maybe ) ) {
+                        return str_replace( '`', '', $maybe[1] );
                 }