← All changes
|
WPDataAccess/Plugin_Table_Models/WPDA_App_Model.php
+15
-15
5.5.76
→
5.5.84
View file →
| @@ -10,9 +10,9 @@ | ||
| 10 | 10 | |
| 11 | 11 | public static function get_by_id( $app_id ) { |
| 12 | 12 | |
| 13 | 13 | global $wpdb; |
| 14 | - $dataset = $wpdb->get_results( | |
| 14 | + $dataset = $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table | |
| 15 | 15 | $wpdb->prepare( |
| 16 | 16 | 'SELECT * FROM `%1s` WHERE app_id = %d', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders |
| 17 | 17 | array( |
| 18 | 18 | WPDA::remove_backticks( self::get_base_table_name() ), |
| @@ -19,9 +19,9 @@ | ||
| 19 | 19 | $app_id, |
| 20 | 20 | ) |
| 21 | 21 | ), // db call ok; no-cache ok. |
| 22 | 22 | 'ARRAY_A' |
| 23 | - ); // phpcs:ignore Standard.Category.SniffName.ErrorCode | |
| 23 | + ); | |
| 24 | 24 | |
| 25 | 25 | return 1 === $wpdb->num_rows ? $dataset : false; |
| 26 | 26 | |
| 27 | 27 | } |
| @@ -28,9 +28,9 @@ | ||
| 28 | 28 | |
| 29 | 29 | public static function get_by_name( $app_name ) { |
| 30 | 30 | |
| 31 | 31 | global $wpdb; |
| 32 | - $dataset = $wpdb->get_results( | |
| 32 | + $dataset = $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table | |
| 33 | 33 | $wpdb->prepare( |
| 34 | 34 | 'SELECT * FROM `%1s` WHERE app_name = %s', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders |
| 35 | 35 | array( |
| 36 | 36 | WPDA::remove_backticks( self::get_base_table_name() ), |
| @@ -37,9 +37,9 @@ | ||
| 37 | 37 | $app_name, |
| 38 | 38 | ) |
| 39 | 39 | ), // db call ok; no-cache ok. |
| 40 | 40 | 'ARRAY_A' |
| 41 | - ); // phpcs:ignore Standard.Category.SniffName.ErrorCode | |
| 41 | + ); | |
| 42 | 42 | |
| 43 | 43 | return 1 === $wpdb->num_rows ? $dataset : false; |
| 44 | 44 | |
| 45 | 45 | } |
| @@ -46,9 +46,9 @@ | ||
| 46 | 46 | |
| 47 | 47 | public static function list() { |
| 48 | 48 | |
| 49 | 49 | global $wpdb; |
| 50 | - return $wpdb->get_results( | |
| 50 | + return $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table | |
| 51 | 51 | $wpdb->prepare( |
| 52 | 52 | 'SELECT * FROM `%1s` ORDER BY app_name', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders |
| 53 | 53 | array( |
| 54 | 54 | WPDA::remove_backticks( self::get_base_table_name() ), |
| @@ -54,9 +54,9 @@ | ||
| 54 | 54 | WPDA::remove_backticks( self::get_base_table_name() ), |
| 55 | 55 | ) |
| 56 | 56 | ), // db call ok; no-cache ok. |
| 57 | 57 | 'ARRAY_A' |
| 58 | - ); // phpcs:ignore Standard.Category.SniffName.ErrorCode | |
| 58 | + ); | |
| 59 | 59 | |
| 60 | 60 | } |
| 61 | 61 | |
| 62 | 62 | public static function has_any() { |
| @@ -61,9 +61,9 @@ | ||
| 61 | 61 | |
| 62 | 62 | public static function has_any() { |
| 63 | 63 | |
| 64 | 64 | global $wpdb; |
| 65 | - $wpdb->get_results( | |
| 65 | + $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table | |
| 66 | 66 | $wpdb->prepare( |
| 67 | 67 | 'SELECT 1 FROM `%1s` LIMIT 1', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders |
| 68 | 68 | array( |
| 69 | 69 | WPDA::remove_backticks( self::get_base_table_name() ), |
| @@ -69,9 +69,9 @@ | ||
| 69 | 69 | WPDA::remove_backticks( self::get_base_table_name() ), |
| 70 | 70 | ) |
| 71 | 71 | ), // db call ok; no-cache ok. |
| 72 | 72 | 'ARRAY_A' |
| 73 | - ); // phpcs:ignore Standard.Category.SniffName.ErrorCode | |
| 73 | + ); | |
| 74 | 74 | |
| 75 | 75 | return 1 === $wpdb->num_rows; |
| 76 | 76 | |
| 77 | 77 | } |
| @@ -78,9 +78,9 @@ | ||
| 78 | 78 | |
| 79 | 79 | public static function add_to_dashboard_menu() { |
| 80 | 80 | |
| 81 | 81 | global $wpdb; |
| 82 | - return $wpdb->get_results( | |
| 82 | + return $wpdb->get_results( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table | |
| 83 | 83 | $wpdb->prepare( |
| 84 | 84 | 'SELECT * FROM `%1s` WHERE `app_add_to_menu` = 1 ORDER BY app_name', // phpcs:ignore WordPress.DB.PreparedSQLPlaceholders |
| 85 | 85 | array( |
| 86 | 86 | WPDA::remove_backticks( self::get_base_table_name() ), |
| @@ -86,9 +86,9 @@ | ||
| 86 | 86 | WPDA::remove_backticks( self::get_base_table_name() ), |
| 87 | 87 | ) |
| 88 | 88 | ), // db call ok; no-cache ok. |
| 89 | 89 | 'ARRAY_A' |
| 90 | - ); // phpcs:ignore Standard.Category.SniffName.ErrorCode | |
| 90 | + ); | |
| 91 | 91 | |
| 92 | 92 | } |
| 93 | 93 | |
| 94 | 94 | public static function create( |
| @@ -98,9 +98,9 @@ | ||
| 98 | 98 | $app_settings |
| 99 | 99 | ) { |
| 100 | 100 | |
| 101 | 101 | global $wpdb; |
| 102 | - if ( 1 === $wpdb->insert( | |
| 102 | + if ( 1 === $wpdb->insert( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery -- plugin table | |
| 103 | 103 | static::get_base_table_name(), |
| 104 | 104 | array( |
| 105 | 105 | 'app_name' => $app_name, |
| 106 | 106 | 'app_title' => $app_title, |
| @@ -123,9 +123,9 @@ | ||
| 123 | 123 | |
| 124 | 124 | public static function delete( $app_id ) { |
| 125 | 125 | |
| 126 | 126 | global $wpdb; |
| 127 | - return $wpdb->delete( | |
| 127 | + return $wpdb->delete( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table | |
| 128 | 128 | static::get_base_table_name(), |
| 129 | 129 | array( |
| 130 | 130 | 'app_id' => $app_id, |
| 131 | 131 | ) |
| @@ -142,9 +142,9 @@ | ||
| 142 | 142 | $app_add_to_menu |
| 143 | 143 | ) { |
| 144 | 144 | |
| 145 | 145 | global $wpdb; |
| 146 | - $wpdb->update( | |
| 146 | + $wpdb->update( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table | |
| 147 | 147 | static::get_base_table_name(), |
| 148 | 148 | array( |
| 149 | 149 | 'app_name' => $app_name, |
| 150 | 150 | 'app_title' => $app_title, |
| @@ -179,9 +179,9 @@ | ||
| 179 | 179 | } |
| 180 | 180 | |
| 181 | 181 | // Copy app |
| 182 | 182 | global $wpdb; |
| 183 | - if ( 1 === $wpdb->insert( | |
| 183 | + if ( 1 === $wpdb->insert( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery -- plugin table | |
| 184 | 184 | static::get_base_table_name(), |
| 185 | 185 | array( |
| 186 | 186 | 'app_name' => $new_app_name, |
| 187 | 187 | 'app_title' => $app[0]['app_title'], |
| @@ -241,9 +241,9 @@ | ||
| 241 | 241 | $app_theme |
| 242 | 242 | ) { |
| 243 | 243 | |
| 244 | 244 | global $wpdb; |
| 245 | - $wpdb->update( | |
| 245 | + $wpdb->update( // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching -- plugin table | |
| 246 | 246 | static::get_base_table_name(), |
| 247 | 247 | array( |
| 248 | 248 | 'app_theme' => $app_theme, |
| 249 | 249 | ), |