V3007.php
63 lines
| 1 | <?php |
| 2 | |
| 3 | namespace AC\Plugin\Update; |
| 4 | |
| 5 | use AC\Plugin\Update; |
| 6 | |
| 7 | class V3007 extends Update { |
| 8 | |
| 9 | public function apply_update() { |
| 10 | $this->update_roles_column(); |
| 11 | } |
| 12 | |
| 13 | protected function set_version() { |
| 14 | $this->version = '3.0.7'; |
| 15 | } |
| 16 | |
| 17 | /** |
| 18 | * Change the roles columns to the author column |
| 19 | */ |
| 20 | private function update_roles_column() { |
| 21 | global $wpdb; |
| 22 | |
| 23 | $sql = " |
| 24 | SELECT * |
| 25 | FROM {$wpdb->options} |
| 26 | WHERE option_name LIKE 'cpac_options_%' |
| 27 | "; |
| 28 | |
| 29 | $results = $wpdb->get_results( $sql ); |
| 30 | |
| 31 | if ( ! is_array( $results ) ) { |
| 32 | return; |
| 33 | } |
| 34 | |
| 35 | foreach ( $results as $row ) { |
| 36 | $options = maybe_unserialize( $row->option_value ); |
| 37 | $update = false; |
| 38 | |
| 39 | if ( ! is_array( $options ) ) { |
| 40 | continue; |
| 41 | } |
| 42 | |
| 43 | foreach ( $options as $k => $v ) { |
| 44 | if ( ! is_array( $v ) || empty( $v['type'] ) || $v['type'] !== 'column-roles' ) { |
| 45 | continue; |
| 46 | } |
| 47 | |
| 48 | $v['type'] = 'column-author_name'; |
| 49 | $v['display_author_as'] = 'roles'; |
| 50 | $v['edit'] = 'off'; |
| 51 | |
| 52 | $options[ $k ] = $v; |
| 53 | |
| 54 | $update = true; |
| 55 | } |
| 56 | |
| 57 | if ( $update ) { |
| 58 | update_option( $row->option_name, $options, false ); |
| 59 | } |
| 60 | } |
| 61 | } |
| 62 | |
| 63 | } |