PluginProbe
WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards / 5.5.84
WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards v5.5.84
5.5.84 5.5.83 5.5.82 5.5.81 5.5.80 5.5.79 5.5.77 5.5.76 5.5.75 5.5.73 5.5.72 5.5.22 5.5.23 5.5.29 5.5.3 5.5.31 5.5.32 5.5.34 5.5.35 5.5.36 5.5.37 5.5.4 5.5.40 5.5.41 5.5.42 All 160 releases
← All changes | WPDataProjects/Project/WPDP_Project_Table_List.php +11 -11 5.5.32 → 5.5.84 View file →
@@ -76,9 +76,9 @@
76 76 unset( $tables_named[ $wp_table ] );
77 77 }
78 78 $tables = array();
79 79 foreach ( $tables_named as $key => $value ) {
80 - array_push( $tables, $key );//phpcs:ignore - 8.1 proof
80 + array_push( $tables, $key ); // phpcs:ignore -- 8.1 proof
81 81 }
82 82 break;
83 83 default:
84 84 // Show only selected tables and views
@@ -123,12 +123,12 @@
123 123 </select>
124 124 <input type="hidden" name="wpnonce"
125 125 value="<?php echo esc_attr( $wpnonce ); ?>"/>
126 126 <input type="submit"
127 - value="<?php echo __( 'Add Template For Selected Table To Repository', 'wp-data-access' ); ?>"
127 + value="<?php esc_html_e( 'Add Template For Selected Table To Repository', 'wp-data-access' ); ?>"
128 128 class="button button-secondary">
129 129 <input type="button"
130 - value="<?php echo __( 'Cancel', 'wp-data-access' ); ?>"
130 + value="<?php esc_html_e( 'Cancel', 'wp-data-access' ); ?>"
131 131 class="button button-secondary"
132 132 onclick="jQuery('#no_repository_buttons').show(); jQuery('#add_table_to_repository').hide(); return false;">
133 133 </div>
134 134 </form>
@@ -174,9 +174,9 @@
174 174 protected function get_all_db_tables( $database ) {
175 175 $tables = array();
176 176 $db_tables = WPDA_Dictionary_Lists::get_tables( true, $database ); // select all db tables and views
177 177 foreach ( $db_tables as $db_table ) {
178 - //phpcs:ignore - 8.1 proof
178 + // phpcs:ignore -- 8.1 proof
179 179 array_push( $tables, $db_table['table_name'] ); // add table or view to array
180 180 }
181 181
182 182 return $tables;
@@ -193,9 +193,9 @@
193 193 if ( $this->bulk_actions_enabled ) {
194 194 $columns = array( 'cb' => '<input type="checkbox" />' );
195 195 }
196 196
197 - return array_merge( $columns, $this->column_headers );//phpcs:ignore - 8.1 proof
197 + return array_merge( $columns, $this->column_headers ); // phpcs:ignore -- 8.1 proof
198 198 }
199 199
200 200 /**
201 201 * Overwrites method column_default
@@ -245,9 +245,9 @@
245 245 WPDA::remove_backticks( $item['wpda_table_name'] ),
246 246 )
247 247 );
248 248 }
249 - $rows = $wpdb->get_var( $query ); // phpcs:ignore WordPress.DB.PreparedSQL
249 + $rows = $wpdb->get_var( $query ); // phpcs:ignore WordPress.DB.PreparedSQL, WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
250 250 $wpdb->suppress_errors( $suppress );
251 251 return null === $rows ? '-' : $rows;
252 252 case 'wpda_table_name':
253 253 // Validate schema, table and column names
@@ -331,9 +331,9 @@
331 331 if ( 'copy' === $this->current_action() ) {
332 332 $wp_nonce_action = "wpda-copy-{$this->table_name}";
333 333 $wp_nonce = isset( $_REQUEST['_wpnonce'] ) ? sanitize_text_field( wp_unslash( $_REQUEST['_wpnonce'] ) ) : ''; // input var okay.
334 334 if ( ! wp_verify_nonce( $wp_nonce, $wp_nonce_action ) ) {
335 - die( __( 'ERROR: Not authorized', 'wp-data-access' ) );
335 + die( esc_attr__( 'ERROR: Not authorized', 'wp-data-access' ) );
336 336 }
337 337
338 338 if ( isset( $_REQUEST['wpda_schema_name'] ) ) {
339 339 $wpda_schema_name = sanitize_text_field( wp_unslash( $_REQUEST['wpda_schema_name'] ) ); // input var okay.
@@ -347,9 +347,9 @@
347 347
348 348 $unique_wpda_table_setname = $this->get_unique_setname( $wpda_schema_name, $wpda_table_name, $wpda_table_setname );
349 349
350 350 global $wpdb;
351 - $wpda_table_design_raw = $wpdb->get_results(
351 + $wpda_table_design_raw = $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching
352 352 $wpdb->prepare(
353 353 'SELECT * FROM `%1s` WHERE wpda_schema_name = %s AND wpda_table_name = %s AND wpda_table_setname = %s', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders
354 354 array(
355 355 WPDA::remove_backticks( $this->table_name ),
@@ -361,9 +361,9 @@
361 361 'ARRAY_A'
362 362 );
363 363 if ( $wpdb->num_rows > 0 ) {
364 364 $wpda_table_design_raw[0]['wpda_table_setname'] = $unique_wpda_table_setname;
365 - $rows_inserted = $wpdb->insert(
365 + $rows_inserted = $wpdb->insert( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery
366 366 $this->table_name,
367 367 $wpda_table_design_raw[0]
368 368 );
369 369 switch ( $rows_inserted ) {
@@ -416,9 +416,9 @@
416 416 $i = 2;
417 417 $query = "select 'x' from `%1s` where wpda_schema_name = %s and wpda_table_name = %s and wpda_table_setname = %s";
418 418
419 419 $unique_wpda_table_setname = "{$wpda_table_setname}_$i";
420 - $wpdb->get_results(
420 + $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter
421 421 $wpdb->prepare(
422 422 $query, // phpcs:ignore WordPress.DB.PreparedSQL
423 423 array(
424 424 WPDA::remove_backticks( WPDP_Project_Design_Table_Model::get_base_table_name() ),
@@ -431,9 +431,9 @@
431 431 while ( $wpdb->num_rows > 0 ) {
432 432 // Search until a free options set is found
433 433 $i ++;
434 434 $unique_wpda_table_setname = "{$wpda_table_setname}_$i";
435 - $wpdb->get_results(
435 + $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter
436 436 $wpdb->prepare(
437 437 $query, // phpcs:ignore WordPress.DB.PreparedSQL
438 438 array(
439 439 WPDA::remove_backticks( WPDP_Project_Design_Table_Model::get_base_table_name() ),