| @@ -96,8 +96,9 @@ | ||
| 96 | 96 | users VARCHAR( 200 ) NULL DEFAULT '0', |
| 97 | 97 | date_created datetime, |
| 98 | 98 | task_auth_code LONGTEXT NULL DEFAULT NULL, |
| 99 | 99 | active int(11) DEFAULT 1, |
| 100 | + parent_task_id integer NOT NULL DEFAULT 0, | |
| 100 | 101 | PRIMARY KEY (id) |
| 101 | 102 | );"; |
| 102 | 103 | dbDelta( $sql ); |
| 103 | 104 | |
| @@ -321,8 +322,11 @@ | ||
| 321 | 322 | } |
| 322 | 323 | update_option( |
| 323 | 324 | 'wppm-ap-project-list', |
| 324 | 325 | array( |
| 326 | + 'list-header-button-background-color' => '#0052CC', | |
| 327 | + 'list-header-button-hover-color' => '#0065ff', | |
| 328 | + 'list-header-button-text-color' => '#fff', | |
| 325 | 329 | 'list-header-background-color' => '#304FFE', |
| 326 | 330 | 'list-header-text-color' => '#fff', |
| 327 | 331 | 'list-item-odd-background-color' => '#fff', |
| 328 | 332 | 'list-item-odd-text-color' => '#2C3E50', |
| @@ -597,8 +601,33 @@ | ||
| 597 | 601 | $cl_type |
| 598 | 602 | ); |
| 599 | 603 | // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared -- Safe: identifiers are hardcoded. |
| 600 | 604 | $wpdb->query( $sql ); |
| 605 | + } | |
| 606 | + } | |
| 607 | + if($installed_version < '6.0.6'){ | |
| 608 | + update_option('wppm_default_global_mention_comment_notification', 1); | |
| 609 | + $project_list_settings = get_option( 'wppm-ap-project-list', array() ); | |
| 610 | + $project_list_settings['list-header-button-background-color'] = '#0052CC'; | |
| 611 | + $project_list_settings['list-header-button-hover-color'] = '#0065ff'; | |
| 612 | + $project_list_settings['list-header-button-text-color'] = '#fff'; | |
| 613 | + update_option( 'wppm-ap-project-list', $project_list_settings ); | |
| 614 | + $table_name = $wpdb->prefix . 'wppm_task'; | |
| 615 | + $column_name = 'parent_task_id'; | |
| 616 | + $column_type = 'INT(11) NOT NULL DEFAULT 0'; | |
| 617 | + $column_exists = $wpdb->get_var( | |
| 618 | + $wpdb->prepare( | |
| 619 | + "SHOW COLUMNS FROM `$table_name` LIKE %s", | |
| 620 | + $column_name | |
| 621 | + ) | |
| 622 | + ); | |
| 623 | + if ( empty( $column_exists ) ) { | |
| 624 | + // Column name and type are hardcoded, not user input. | |
| 625 | + // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 626 | + $wpdb->query( | |
| 627 | + "ALTER TABLE `$table_name` | |
| 628 | + ADD `$column_name` $column_type" | |
| 629 | + ); | |
| 601 | 630 | } |
| 602 | 631 | } |
| 603 | 632 | // update wppm_version option to plugin version |
| 604 | 633 | update_option( 'wppm_version', WPPM_VERSION ); |
