← All changes
|
WPDataAccess/Data_Dictionary/WPDA_Dictionary_Exist.php
+9
-9
5.5.32
→
5.5.85
View file →
| @@ -89,9 +89,9 @@ | ||
| 89 | 89 | } else { |
| 90 | 90 | // Local check... |
| 91 | 91 | // Since a table name (and therefor schema name as well) can be provided on the url we need to check for |
| 92 | 92 | // sql injection. We'll do this by checking of the schema name exists in our database. |
| 93 | - $wpdb->get_results( | |
| 93 | + $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching | |
| 94 | 94 | $wpdb->prepare( |
| 95 | 95 | ' |
| 96 | 96 | SELECT TRUE |
| 97 | 97 | FROM information_schema.schemata |
| @@ -103,9 +103,9 @@ | ||
| 103 | 103 | ) |
| 104 | 104 | ); // db call ok; no-cache ok. |
| 105 | 105 | if ( 1 !== $wpdb->num_rows ) { |
| 106 | 106 | // Schema name doesn't exist! It makes no sense to continue. |
| 107 | - wp_die( __( 'ERROR: Wrong arguments [schema name not found]', 'wp-data-access' ) ); | |
| 107 | + wp_die( esc_attr__( 'ERROR: Wrong arguments [schema name not found]', 'wp-data-access' ) ); | |
| 108 | 108 | } else { |
| 109 | 109 | self::$schema_name_cache[ $schema_name ] = true; |
| 110 | 110 | } |
| 111 | 111 | } |
| @@ -188,9 +188,9 @@ | ||
| 188 | 188 | $routine_type, |
| 189 | 189 | ) |
| 190 | 190 | ) |
| 191 | 191 | ); // db call ok; no-cache ok. |
| 192 | - $wpdadb->get_results(); // phpcs:ignore Standard.Category.SniffName.ErrorCode | |
| 192 | + $wpdadb->get_results(); | |
| 193 | 193 | |
| 194 | 194 | return ( 1 === $wpdadb->num_rows ); |
| 195 | 195 | } |
| 196 | 196 | |
| @@ -235,9 +235,9 @@ | ||
| 235 | 235 | $trigger_name, |
| 236 | 236 | ) |
| 237 | 237 | ) |
| 238 | 238 | ); // db call ok; no-cache ok. |
| 239 | - $wpdadb->get_results(); // phpcs:ignore Standard.Category.SniffName.ErrorCode | |
| 239 | + $wpdadb->get_results(); | |
| 240 | 240 | |
| 241 | 241 | return ( 1 === $wpdadb->num_rows ); |
| 242 | 242 | } |
| 243 | 243 | |
| @@ -317,9 +317,9 @@ | ||
| 317 | 317 | ) |
| 318 | 318 | ) |
| 319 | 319 | ); // db call ok; no-cache ok. |
| 320 | 320 | |
| 321 | - $wpdadb->get_results(); // phpcs:ignore Standard.Category.SniffName.ErrorCode | |
| 321 | + $wpdadb->get_results(); | |
| 322 | 322 | |
| 323 | 323 | if ( 1 === $wpdadb->num_rows ) { |
| 324 | 324 | self::$table_name_cache[ "$this->schema_name.$this->table_name" ] = true; |
| 325 | 325 | |
| @@ -356,9 +356,9 @@ | ||
| 356 | 356 | $this->table_name, |
| 357 | 357 | ) |
| 358 | 358 | ) |
| 359 | 359 | ); // db call ok; no-cache ok. |
| 360 | - $wpdadb->get_results(); // phpcs:ignore Standard.Category.SniffName.ErrorCode | |
| 360 | + $wpdadb->get_results(); | |
| 361 | 361 | |
| 362 | 362 | return ( 1 === $wpdadb->num_rows ); |
| 363 | 363 | } |
| 364 | 364 | |
| @@ -396,9 +396,9 @@ | ||
| 396 | 396 | $column_name, |
| 397 | 397 | ) |
| 398 | 398 | ) |
| 399 | 399 | ); // db call ok; no-cache ok. |
| 400 | - $wpdadb->get_results(); // phpcs:ignore Standard.Category.SniffName.ErrorCode | |
| 400 | + $wpdadb->get_results(); | |
| 401 | 401 | |
| 402 | 402 | return ( 1 === $wpdadb->num_rows ); |
| 403 | 403 | } |
| 404 | 404 | |
| @@ -427,9 +427,9 @@ | ||
| 427 | 427 | $this->table_name, |
| 428 | 428 | ) |
| 429 | 429 | ) |
| 430 | 430 | ); // db call ok; no-cache ok. |
| 431 | - $wpdadb->get_results(); // phpcs:ignore Standard.Category.SniffName.ErrorCode | |
| 431 | + $wpdadb->get_results(); | |
| 432 | 432 | |
| 433 | 433 | return ( 1 === $wpdadb->num_rows ); |
| 434 | 434 | } |
| 435 | 435 | |
| @@ -434,9 +434,9 @@ | ||
| 434 | 434 | } |
| 435 | 435 | |
| 436 | 436 | public static function schema_exists( $schema_name ) { |
| 437 | 437 | global $wpdb; |
| 438 | - $wpdb->get_results( | |
| 438 | + $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching | |
| 439 | 439 | $wpdb->prepare( |
| 440 | 440 | ' |
| 441 | 441 | SELECT TRUE |
| 442 | 442 | FROM information_schema.schemata |