@@ -9,39 +9,39 @@ |
||
9 | 9 | */ |
10 | 10 | class EE_DMS_4_5_0_update_wp_user_for_question_groups extends EE_Data_Migration_Script_Stage_Table |
11 | 11 | { |
12 | - public function __construct() |
|
13 | - { |
|
14 | - global $wpdb; |
|
15 | - $this->_pretty_name = __("Question Groups", "event_espresso"); |
|
16 | - $this->_old_table = $wpdb->prefix."esp_question_group"; |
|
17 | - parent::__construct(); |
|
18 | - } |
|
19 | - protected function _migrate_old_row($old_row) |
|
20 | - { |
|
21 | - // foreach ticket row we add the id for the current logged in user. |
|
22 | - global $wpdb; |
|
23 | - $user_id = EEH_Activation::get_default_creator_id(); |
|
24 | - $updated = $wpdb->update( |
|
25 | - $this->_old_table, |
|
26 | - array('QSG_wp_user'=>$user_id), |
|
27 | - array('QSG_ID'=>$old_row['QSG_ID']), |
|
28 | - array('%d',// QSG_wp_user |
|
29 | - ), |
|
30 | - array('%d',// QSG_ID |
|
31 | - ) |
|
32 | - ); |
|
33 | - if (false === $updated) { |
|
34 | - $this->add_error( |
|
35 | - sprintf( |
|
36 | - __( |
|
37 | - "Error in updating table %s setting QSG_wp_user = %d where QSG_ID = %d", |
|
38 | - 'event_espresso' |
|
39 | - ), |
|
40 | - $this->_old_table, |
|
41 | - $user_id, |
|
42 | - $old_row['QSG_ID'] |
|
43 | - ) |
|
44 | - ); |
|
45 | - } |
|
46 | - } |
|
12 | + public function __construct() |
|
13 | + { |
|
14 | + global $wpdb; |
|
15 | + $this->_pretty_name = __("Question Groups", "event_espresso"); |
|
16 | + $this->_old_table = $wpdb->prefix."esp_question_group"; |
|
17 | + parent::__construct(); |
|
18 | + } |
|
19 | + protected function _migrate_old_row($old_row) |
|
20 | + { |
|
21 | + // foreach ticket row we add the id for the current logged in user. |
|
22 | + global $wpdb; |
|
23 | + $user_id = EEH_Activation::get_default_creator_id(); |
|
24 | + $updated = $wpdb->update( |
|
25 | + $this->_old_table, |
|
26 | + array('QSG_wp_user'=>$user_id), |
|
27 | + array('QSG_ID'=>$old_row['QSG_ID']), |
|
28 | + array('%d',// QSG_wp_user |
|
29 | + ), |
|
30 | + array('%d',// QSG_ID |
|
31 | + ) |
|
32 | + ); |
|
33 | + if (false === $updated) { |
|
34 | + $this->add_error( |
|
35 | + sprintf( |
|
36 | + __( |
|
37 | + "Error in updating table %s setting QSG_wp_user = %d where QSG_ID = %d", |
|
38 | + 'event_espresso' |
|
39 | + ), |
|
40 | + $this->_old_table, |
|
41 | + $user_id, |
|
42 | + $old_row['QSG_ID'] |
|
43 | + ) |
|
44 | + ); |
|
45 | + } |
|
46 | + } |
|
47 | 47 | } |
@@ -25,9 +25,9 @@ |
||
25 | 25 | $this->_old_table, |
26 | 26 | array('QSG_wp_user'=>$user_id), |
27 | 27 | array('QSG_ID'=>$old_row['QSG_ID']), |
28 | - array('%d',// QSG_wp_user |
|
28 | + array('%d', // QSG_wp_user |
|
29 | 29 | ), |
30 | - array('%d',// QSG_ID |
|
30 | + array('%d', // QSG_ID |
|
31 | 31 | ) |
32 | 32 | ); |
33 | 33 | if (false === $updated) { |
@@ -9,39 +9,39 @@ |
||
9 | 9 | */ |
10 | 10 | class EE_DMS_4_5_0_update_wp_user_for_prices extends EE_Data_Migration_Script_Stage_Table |
11 | 11 | { |
12 | - public function __construct() |
|
13 | - { |
|
14 | - global $wpdb; |
|
15 | - $this->_pretty_name = __("Prices", "event_espresso"); |
|
16 | - $this->_old_table = $wpdb->prefix."esp_price"; |
|
17 | - parent::__construct(); |
|
18 | - } |
|
19 | - protected function _migrate_old_row($old_row) |
|
20 | - { |
|
21 | - // foreach ticket row we add the id for the current logged in user. |
|
22 | - global $wpdb; |
|
23 | - $user_id = EEH_Activation::get_default_creator_id(); |
|
24 | - $updated = $wpdb->update( |
|
25 | - $this->_old_table, |
|
26 | - array('PRC_wp_user'=>$user_id), |
|
27 | - array('PRC_ID'=>$old_row['PRC_ID']), |
|
28 | - array('%d',// PRC_wp_user |
|
29 | - ), |
|
30 | - array('%d',// PRC_ID |
|
31 | - ) |
|
32 | - ); |
|
33 | - if (false === $updated) { |
|
34 | - $this->add_error( |
|
35 | - sprintf( |
|
36 | - __( |
|
37 | - "Error in updating table %s setting PRC_wp_user = %d where PRC_ID = %d", |
|
38 | - 'event_espresso' |
|
39 | - ), |
|
40 | - $this->_old_table, |
|
41 | - $user_id, |
|
42 | - $old_row['PRC_ID'] |
|
43 | - ) |
|
44 | - ); |
|
45 | - } |
|
46 | - } |
|
12 | + public function __construct() |
|
13 | + { |
|
14 | + global $wpdb; |
|
15 | + $this->_pretty_name = __("Prices", "event_espresso"); |
|
16 | + $this->_old_table = $wpdb->prefix."esp_price"; |
|
17 | + parent::__construct(); |
|
18 | + } |
|
19 | + protected function _migrate_old_row($old_row) |
|
20 | + { |
|
21 | + // foreach ticket row we add the id for the current logged in user. |
|
22 | + global $wpdb; |
|
23 | + $user_id = EEH_Activation::get_default_creator_id(); |
|
24 | + $updated = $wpdb->update( |
|
25 | + $this->_old_table, |
|
26 | + array('PRC_wp_user'=>$user_id), |
|
27 | + array('PRC_ID'=>$old_row['PRC_ID']), |
|
28 | + array('%d',// PRC_wp_user |
|
29 | + ), |
|
30 | + array('%d',// PRC_ID |
|
31 | + ) |
|
32 | + ); |
|
33 | + if (false === $updated) { |
|
34 | + $this->add_error( |
|
35 | + sprintf( |
|
36 | + __( |
|
37 | + "Error in updating table %s setting PRC_wp_user = %d where PRC_ID = %d", |
|
38 | + 'event_espresso' |
|
39 | + ), |
|
40 | + $this->_old_table, |
|
41 | + $user_id, |
|
42 | + $old_row['PRC_ID'] |
|
43 | + ) |
|
44 | + ); |
|
45 | + } |
|
46 | + } |
|
47 | 47 | } |
@@ -25,9 +25,9 @@ |
||
25 | 25 | $this->_old_table, |
26 | 26 | array('PRC_wp_user'=>$user_id), |
27 | 27 | array('PRC_ID'=>$old_row['PRC_ID']), |
28 | - array('%d',// PRC_wp_user |
|
28 | + array('%d', // PRC_wp_user |
|
29 | 29 | ), |
30 | - array('%d',// PRC_ID |
|
30 | + array('%d', // PRC_ID |
|
31 | 31 | ) |
32 | 32 | ); |
33 | 33 | if (false === $updated) { |
@@ -9,39 +9,39 @@ |
||
9 | 9 | */ |
10 | 10 | class EE_DMS_4_5_0_update_wp_user_for_tickets extends EE_Data_Migration_Script_Stage_Table |
11 | 11 | { |
12 | - public function __construct() |
|
13 | - { |
|
14 | - global $wpdb; |
|
15 | - $this->_pretty_name = __("Tickets", "event_espresso"); |
|
16 | - $this->_old_table = $wpdb->prefix."esp_ticket"; |
|
17 | - parent::__construct(); |
|
18 | - } |
|
19 | - protected function _migrate_old_row($old_row) |
|
20 | - { |
|
21 | - // foreach ticket row we add the id for the current logged in user. |
|
22 | - global $wpdb; |
|
23 | - $user_id = EEH_Activation::get_default_creator_id(); |
|
24 | - $updated = $wpdb->update( |
|
25 | - $this->_old_table, |
|
26 | - array('TKT_wp_user'=>$user_id), |
|
27 | - array('TKT_ID'=>$old_row['TKT_ID']), |
|
28 | - array('%d',// TKT_wp_user |
|
29 | - ), |
|
30 | - array('%d',// TKT_ID |
|
31 | - ) |
|
32 | - ); |
|
33 | - if (false === $updated) { |
|
34 | - $this->add_error( |
|
35 | - sprintf( |
|
36 | - __( |
|
37 | - "Error in updating table %s setting TKT_wp_user = %d where TKT_ID = %d", |
|
38 | - 'event_espresso' |
|
39 | - ), |
|
40 | - $this->_old_table, |
|
41 | - $user_id, |
|
42 | - $old_row['TKT_ID'] |
|
43 | - ) |
|
44 | - ); |
|
45 | - } |
|
46 | - } |
|
12 | + public function __construct() |
|
13 | + { |
|
14 | + global $wpdb; |
|
15 | + $this->_pretty_name = __("Tickets", "event_espresso"); |
|
16 | + $this->_old_table = $wpdb->prefix."esp_ticket"; |
|
17 | + parent::__construct(); |
|
18 | + } |
|
19 | + protected function _migrate_old_row($old_row) |
|
20 | + { |
|
21 | + // foreach ticket row we add the id for the current logged in user. |
|
22 | + global $wpdb; |
|
23 | + $user_id = EEH_Activation::get_default_creator_id(); |
|
24 | + $updated = $wpdb->update( |
|
25 | + $this->_old_table, |
|
26 | + array('TKT_wp_user'=>$user_id), |
|
27 | + array('TKT_ID'=>$old_row['TKT_ID']), |
|
28 | + array('%d',// TKT_wp_user |
|
29 | + ), |
|
30 | + array('%d',// TKT_ID |
|
31 | + ) |
|
32 | + ); |
|
33 | + if (false === $updated) { |
|
34 | + $this->add_error( |
|
35 | + sprintf( |
|
36 | + __( |
|
37 | + "Error in updating table %s setting TKT_wp_user = %d where TKT_ID = %d", |
|
38 | + 'event_espresso' |
|
39 | + ), |
|
40 | + $this->_old_table, |
|
41 | + $user_id, |
|
42 | + $old_row['TKT_ID'] |
|
43 | + ) |
|
44 | + ); |
|
45 | + } |
|
46 | + } |
|
47 | 47 | } |
@@ -25,9 +25,9 @@ |
||
25 | 25 | $this->_old_table, |
26 | 26 | array('TKT_wp_user'=>$user_id), |
27 | 27 | array('TKT_ID'=>$old_row['TKT_ID']), |
28 | - array('%d',// TKT_wp_user |
|
28 | + array('%d', // TKT_wp_user |
|
29 | 29 | ), |
30 | - array('%d',// TKT_ID |
|
30 | + array('%d', // TKT_ID |
|
31 | 31 | ) |
32 | 32 | ); |
33 | 33 | if (false === $updated) { |
@@ -9,36 +9,36 @@ |
||
9 | 9 | */ |
10 | 10 | class EE_DMS_4_5_0_update_wp_user_for_price_types extends EE_Data_Migration_Script_Stage_Table |
11 | 11 | { |
12 | - public function __construct() |
|
13 | - { |
|
14 | - global $wpdb; |
|
15 | - $this->_pretty_name = __("Price Types", "event_espresso"); |
|
16 | - $this->_old_table = $wpdb->prefix."esp_price_type"; |
|
17 | - parent::__construct(); |
|
18 | - } |
|
19 | - protected function _migrate_old_row($old_row) |
|
20 | - { |
|
21 | - // foreach ticket row we add the id for the current logged in user. |
|
22 | - global $wpdb; |
|
23 | - $user_id = EEH_Activation::get_default_creator_id(); |
|
24 | - $updated = $wpdb->update( |
|
25 | - $this->_old_table, |
|
26 | - array('PRT_wp_user'=>$user_id), |
|
27 | - array('PRT_ID'=>$old_row['PRT_ID']), |
|
28 | - array('%d',// PRT_wp_user |
|
29 | - ), |
|
30 | - array('%d',// PRT_ID |
|
31 | - ) |
|
32 | - ); |
|
33 | - if (false === $updated) { |
|
34 | - $this->add_error( |
|
35 | - sprintf( |
|
36 | - __("Error in updating table %s setting PRT_wp_user = %d where PRT_ID = %d", 'event_espresso'), |
|
37 | - $this->_old_table, |
|
38 | - $user_id, |
|
39 | - $old_row['PRT_ID'] |
|
40 | - ) |
|
41 | - ); |
|
42 | - } |
|
43 | - } |
|
12 | + public function __construct() |
|
13 | + { |
|
14 | + global $wpdb; |
|
15 | + $this->_pretty_name = __("Price Types", "event_espresso"); |
|
16 | + $this->_old_table = $wpdb->prefix."esp_price_type"; |
|
17 | + parent::__construct(); |
|
18 | + } |
|
19 | + protected function _migrate_old_row($old_row) |
|
20 | + { |
|
21 | + // foreach ticket row we add the id for the current logged in user. |
|
22 | + global $wpdb; |
|
23 | + $user_id = EEH_Activation::get_default_creator_id(); |
|
24 | + $updated = $wpdb->update( |
|
25 | + $this->_old_table, |
|
26 | + array('PRT_wp_user'=>$user_id), |
|
27 | + array('PRT_ID'=>$old_row['PRT_ID']), |
|
28 | + array('%d',// PRT_wp_user |
|
29 | + ), |
|
30 | + array('%d',// PRT_ID |
|
31 | + ) |
|
32 | + ); |
|
33 | + if (false === $updated) { |
|
34 | + $this->add_error( |
|
35 | + sprintf( |
|
36 | + __("Error in updating table %s setting PRT_wp_user = %d where PRT_ID = %d", 'event_espresso'), |
|
37 | + $this->_old_table, |
|
38 | + $user_id, |
|
39 | + $old_row['PRT_ID'] |
|
40 | + ) |
|
41 | + ); |
|
42 | + } |
|
43 | + } |
|
44 | 44 | } |
@@ -25,9 +25,9 @@ |
||
25 | 25 | $this->_old_table, |
26 | 26 | array('PRT_wp_user'=>$user_id), |
27 | 27 | array('PRT_ID'=>$old_row['PRT_ID']), |
28 | - array('%d',// PRT_wp_user |
|
28 | + array('%d', // PRT_wp_user |
|
29 | 29 | ), |
30 | - array('%d',// PRT_ID |
|
30 | + array('%d', // PRT_ID |
|
31 | 31 | ) |
32 | 32 | ); |
33 | 33 | if (false === $updated) { |
@@ -14,48 +14,48 @@ |
||
14 | 14 | |
15 | 15 | |
16 | 16 | |
17 | - /** |
|
18 | - * Just initializes the status of the migration |
|
19 | - * |
|
20 | - * @return EE_DMS_4_6_0_country_system_question |
|
21 | - */ |
|
22 | - public function __construct() |
|
23 | - { |
|
24 | - global $wpdb; |
|
25 | - $this->_pretty_name = __('Country - System Question', 'event_espresso'); |
|
26 | - $this->_old_table = $wpdb->prefix.'esp_question'; |
|
27 | - $this->_extra_where_sql = "WHERE QST_system = 'country'"; |
|
28 | - parent::__construct(); |
|
29 | - } |
|
17 | + /** |
|
18 | + * Just initializes the status of the migration |
|
19 | + * |
|
20 | + * @return EE_DMS_4_6_0_country_system_question |
|
21 | + */ |
|
22 | + public function __construct() |
|
23 | + { |
|
24 | + global $wpdb; |
|
25 | + $this->_pretty_name = __('Country - System Question', 'event_espresso'); |
|
26 | + $this->_old_table = $wpdb->prefix.'esp_question'; |
|
27 | + $this->_extra_where_sql = "WHERE QST_system = 'country'"; |
|
28 | + parent::__construct(); |
|
29 | + } |
|
30 | 30 | |
31 | 31 | |
32 | 32 | |
33 | - /** |
|
34 | - * updates the question with the new question type |
|
35 | - * @param array $question an associative array where keys are column names and values are their values. |
|
36 | - * @return null |
|
37 | - */ |
|
38 | - protected function _migrate_old_row($question) |
|
39 | - { |
|
40 | - if ($question['QST_ID'] && $question['QST_system'] == 'country') { |
|
41 | - global $wpdb; |
|
42 | - $success = $wpdb->update( |
|
43 | - $this->_old_table, |
|
44 | - array( 'QST_type' => 'COUNTRY' ), // data |
|
45 | - array( 'QST_ID' => $question['QST_ID'] ), // where |
|
46 | - array( '%s' ), // data format |
|
47 | - array( '%d' ) // where format |
|
48 | - ); |
|
49 | - if (! $success) { |
|
50 | - $this->add_error( |
|
51 | - sprintf( |
|
52 | - __('Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso'), |
|
53 | - wp_json_encode($question['QST_system']), |
|
54 | - $question['QST_ID'], |
|
55 | - $wpdb->last_error |
|
56 | - ) |
|
57 | - ); |
|
58 | - } |
|
59 | - } |
|
60 | - } |
|
33 | + /** |
|
34 | + * updates the question with the new question type |
|
35 | + * @param array $question an associative array where keys are column names and values are their values. |
|
36 | + * @return null |
|
37 | + */ |
|
38 | + protected function _migrate_old_row($question) |
|
39 | + { |
|
40 | + if ($question['QST_ID'] && $question['QST_system'] == 'country') { |
|
41 | + global $wpdb; |
|
42 | + $success = $wpdb->update( |
|
43 | + $this->_old_table, |
|
44 | + array( 'QST_type' => 'COUNTRY' ), // data |
|
45 | + array( 'QST_ID' => $question['QST_ID'] ), // where |
|
46 | + array( '%s' ), // data format |
|
47 | + array( '%d' ) // where format |
|
48 | + ); |
|
49 | + if (! $success) { |
|
50 | + $this->add_error( |
|
51 | + sprintf( |
|
52 | + __('Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso'), |
|
53 | + wp_json_encode($question['QST_system']), |
|
54 | + $question['QST_ID'], |
|
55 | + $wpdb->last_error |
|
56 | + ) |
|
57 | + ); |
|
58 | + } |
|
59 | + } |
|
60 | + } |
|
61 | 61 | } |
@@ -41,12 +41,12 @@ |
||
41 | 41 | global $wpdb; |
42 | 42 | $success = $wpdb->update( |
43 | 43 | $this->_old_table, |
44 | - array( 'QST_type' => 'COUNTRY' ), // data |
|
45 | - array( 'QST_ID' => $question['QST_ID'] ), // where |
|
46 | - array( '%s' ), // data format |
|
47 | - array( '%d' ) // where format |
|
44 | + array('QST_type' => 'COUNTRY'), // data |
|
45 | + array('QST_ID' => $question['QST_ID']), // where |
|
46 | + array('%s'), // data format |
|
47 | + array('%d') // where format |
|
48 | 48 | ); |
49 | - if (! $success) { |
|
49 | + if ( ! $success) { |
|
50 | 50 | $this->add_error( |
51 | 51 | sprintf( |
52 | 52 | __('Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso'), |
@@ -14,48 +14,48 @@ |
||
14 | 14 | |
15 | 15 | |
16 | 16 | |
17 | - /** |
|
18 | - * Just initializes the status of the migration |
|
19 | - * |
|
20 | - * @return EE_DMS_4_6_0_state_system_question |
|
21 | - */ |
|
22 | - public function __construct() |
|
23 | - { |
|
24 | - global $wpdb; |
|
25 | - $this->_pretty_name = __('State - System Question', 'event_espresso'); |
|
26 | - $this->_old_table = $wpdb->prefix.'esp_question'; |
|
27 | - $this->_extra_where_sql = "WHERE QST_system = 'state'"; |
|
28 | - parent::__construct(); |
|
29 | - } |
|
17 | + /** |
|
18 | + * Just initializes the status of the migration |
|
19 | + * |
|
20 | + * @return EE_DMS_4_6_0_state_system_question |
|
21 | + */ |
|
22 | + public function __construct() |
|
23 | + { |
|
24 | + global $wpdb; |
|
25 | + $this->_pretty_name = __('State - System Question', 'event_espresso'); |
|
26 | + $this->_old_table = $wpdb->prefix.'esp_question'; |
|
27 | + $this->_extra_where_sql = "WHERE QST_system = 'state'"; |
|
28 | + parent::__construct(); |
|
29 | + } |
|
30 | 30 | |
31 | 31 | |
32 | 32 | |
33 | - /** |
|
34 | - * updates the question with the new question type |
|
35 | - * @param array $question an associative array where keys are column names and values are their values. |
|
36 | - * @return null |
|
37 | - */ |
|
38 | - protected function _migrate_old_row($question) |
|
39 | - { |
|
40 | - if ($question['QST_ID'] && $question['QST_system'] == 'state') { |
|
41 | - global $wpdb; |
|
42 | - $success = $wpdb->update( |
|
43 | - $this->_old_table, |
|
44 | - array( 'QST_type' => 'STATE' ), // data |
|
45 | - array( 'QST_ID' => $question['QST_ID'] ), // where |
|
46 | - array( '%s' ), // data format |
|
47 | - array( '%d' ) // where format |
|
48 | - ); |
|
49 | - if (! $success) { |
|
50 | - $this->add_error( |
|
51 | - sprintf( |
|
52 | - __('Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso'), |
|
53 | - wp_json_encode($question['QST_system']), |
|
54 | - $question['QST_ID'], |
|
55 | - $wpdb->last_error |
|
56 | - ) |
|
57 | - ); |
|
58 | - } |
|
59 | - } |
|
60 | - } |
|
33 | + /** |
|
34 | + * updates the question with the new question type |
|
35 | + * @param array $question an associative array where keys are column names and values are their values. |
|
36 | + * @return null |
|
37 | + */ |
|
38 | + protected function _migrate_old_row($question) |
|
39 | + { |
|
40 | + if ($question['QST_ID'] && $question['QST_system'] == 'state') { |
|
41 | + global $wpdb; |
|
42 | + $success = $wpdb->update( |
|
43 | + $this->_old_table, |
|
44 | + array( 'QST_type' => 'STATE' ), // data |
|
45 | + array( 'QST_ID' => $question['QST_ID'] ), // where |
|
46 | + array( '%s' ), // data format |
|
47 | + array( '%d' ) // where format |
|
48 | + ); |
|
49 | + if (! $success) { |
|
50 | + $this->add_error( |
|
51 | + sprintf( |
|
52 | + __('Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso'), |
|
53 | + wp_json_encode($question['QST_system']), |
|
54 | + $question['QST_ID'], |
|
55 | + $wpdb->last_error |
|
56 | + ) |
|
57 | + ); |
|
58 | + } |
|
59 | + } |
|
60 | + } |
|
61 | 61 | } |
@@ -41,12 +41,12 @@ |
||
41 | 41 | global $wpdb; |
42 | 42 | $success = $wpdb->update( |
43 | 43 | $this->_old_table, |
44 | - array( 'QST_type' => 'STATE' ), // data |
|
45 | - array( 'QST_ID' => $question['QST_ID'] ), // where |
|
46 | - array( '%s' ), // data format |
|
47 | - array( '%d' ) // where format |
|
44 | + array('QST_type' => 'STATE'), // data |
|
45 | + array('QST_ID' => $question['QST_ID']), // where |
|
46 | + array('%s'), // data format |
|
47 | + array('%d') // where format |
|
48 | 48 | ); |
49 | - if (! $success) { |
|
49 | + if ( ! $success) { |
|
50 | 50 | $this->add_error( |
51 | 51 | sprintf( |
52 | 52 | __('Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso'), |
@@ -28,59 +28,59 @@ |
||
28 | 28 | class EE_DMS_4_6_0_invoice_settings extends EE_Data_Migration_Script_Stage |
29 | 29 | { |
30 | 30 | |
31 | - /** |
|
32 | - * Just initializes the status of the migration |
|
33 | - */ |
|
34 | - public function __construct() |
|
35 | - { |
|
36 | - $this->_pretty_name = __('Update Invoice Settings', 'event_espresso'); |
|
37 | - parent::__construct(); |
|
38 | - } |
|
31 | + /** |
|
32 | + * Just initializes the status of the migration |
|
33 | + */ |
|
34 | + public function __construct() |
|
35 | + { |
|
36 | + $this->_pretty_name = __('Update Invoice Settings', 'event_espresso'); |
|
37 | + parent::__construct(); |
|
38 | + } |
|
39 | 39 | |
40 | 40 | |
41 | 41 | |
42 | - /** |
|
43 | - * _count_records_to_migrate |
|
44 | - * Counts the records to migrate; the public version may cache it |
|
45 | - * |
|
46 | - * @access protected |
|
47 | - * @return int |
|
48 | - */ |
|
49 | - protected function _count_records_to_migrate() |
|
50 | - { |
|
51 | - return 1; |
|
52 | - } |
|
42 | + /** |
|
43 | + * _count_records_to_migrate |
|
44 | + * Counts the records to migrate; the public version may cache it |
|
45 | + * |
|
46 | + * @access protected |
|
47 | + * @return int |
|
48 | + */ |
|
49 | + protected function _count_records_to_migrate() |
|
50 | + { |
|
51 | + return 1; |
|
52 | + } |
|
53 | 53 | |
54 | 54 | |
55 | 55 | |
56 | - /** |
|
57 | - * _migration_step |
|
58 | - * |
|
59 | - * @access protected |
|
60 | - * @param int $num_items |
|
61 | - * @throws EE_Error |
|
62 | - * @return int number of items ACTUALLY migrated |
|
63 | - * @throws InvalidDataTypeException |
|
64 | - */ |
|
65 | - protected function _migration_step($num_items = 1) |
|
66 | - { |
|
56 | + /** |
|
57 | + * _migration_step |
|
58 | + * |
|
59 | + * @access protected |
|
60 | + * @param int $num_items |
|
61 | + * @throws EE_Error |
|
62 | + * @return int number of items ACTUALLY migrated |
|
63 | + * @throws InvalidDataTypeException |
|
64 | + */ |
|
65 | + protected function _migration_step($num_items = 1) |
|
66 | + { |
|
67 | 67 | |
68 | - $templates_relative_path = 'modules/gateways/Invoice/lib/templates/'; |
|
69 | - $overridden_invoice_body = EEH_Template::locate_template($templates_relative_path . 'invoice_body.template.php', null, false, false, true); |
|
70 | - $overridden_receipt_body= EEH_Template::locate_template($templates_relative_path . 'receipt_body.template.php', null, false, false, true); |
|
71 | - if ($overridden_invoice_body || $overridden_receipt_body) { |
|
72 | - new PersistentAdminNotice( |
|
73 | - 'invoice_overriding_templates', |
|
74 | - esc_html__( |
|
75 | - 'Note: in this version of Event Espresso, PDF and HTML Invoices and Receipts are now Messages and can be changed just like any other messages; however we noticed you had previously overridden the old default Invoice/Receipt templates. Because of this, your old Invoice/Receipt templates will continue to be used INSTEAD of the new Invoice/Receipt message equivalents (but this will be removed in an upcoming version). We recommend deleting your old Invoice/Receipt templates and using the new messages system. Then modify the new Invoice and Receipt messages\'s content in Messages -> Invoice and Messages -> Receipt.', |
|
76 | - 'event_espresso' |
|
77 | - ), |
|
78 | - true |
|
79 | - ); |
|
80 | - } |
|
68 | + $templates_relative_path = 'modules/gateways/Invoice/lib/templates/'; |
|
69 | + $overridden_invoice_body = EEH_Template::locate_template($templates_relative_path . 'invoice_body.template.php', null, false, false, true); |
|
70 | + $overridden_receipt_body= EEH_Template::locate_template($templates_relative_path . 'receipt_body.template.php', null, false, false, true); |
|
71 | + if ($overridden_invoice_body || $overridden_receipt_body) { |
|
72 | + new PersistentAdminNotice( |
|
73 | + 'invoice_overriding_templates', |
|
74 | + esc_html__( |
|
75 | + 'Note: in this version of Event Espresso, PDF and HTML Invoices and Receipts are now Messages and can be changed just like any other messages; however we noticed you had previously overridden the old default Invoice/Receipt templates. Because of this, your old Invoice/Receipt templates will continue to be used INSTEAD of the new Invoice/Receipt message equivalents (but this will be removed in an upcoming version). We recommend deleting your old Invoice/Receipt templates and using the new messages system. Then modify the new Invoice and Receipt messages\'s content in Messages -> Invoice and Messages -> Receipt.', |
|
76 | + 'event_espresso' |
|
77 | + ), |
|
78 | + true |
|
79 | + ); |
|
80 | + } |
|
81 | 81 | |
82 | - // regardless of whether it worked or not, we ought to continue the migration |
|
83 | - $this->set_completed(); |
|
84 | - return 1; |
|
85 | - } |
|
82 | + // regardless of whether it worked or not, we ought to continue the migration |
|
83 | + $this->set_completed(); |
|
84 | + return 1; |
|
85 | + } |
|
86 | 86 | } |
@@ -66,8 +66,8 @@ |
||
66 | 66 | { |
67 | 67 | |
68 | 68 | $templates_relative_path = 'modules/gateways/Invoice/lib/templates/'; |
69 | - $overridden_invoice_body = EEH_Template::locate_template($templates_relative_path . 'invoice_body.template.php', null, false, false, true); |
|
70 | - $overridden_receipt_body= EEH_Template::locate_template($templates_relative_path . 'receipt_body.template.php', null, false, false, true); |
|
69 | + $overridden_invoice_body = EEH_Template::locate_template($templates_relative_path.'invoice_body.template.php', null, false, false, true); |
|
70 | + $overridden_receipt_body = EEH_Template::locate_template($templates_relative_path.'receipt_body.template.php', null, false, false, true); |
|
71 | 71 | if ($overridden_invoice_body || $overridden_receipt_body) { |
72 | 72 | new PersistentAdminNotice( |
73 | 73 | 'invoice_overriding_templates', |
@@ -11,69 +11,69 @@ |
||
11 | 11 | */ |
12 | 12 | class EE_DMS_4_6_0_billing_info extends EE_Data_Migration_Script_Stage_Table |
13 | 13 | { |
14 | - public function __construct() |
|
15 | - { |
|
16 | - global $wpdb; |
|
17 | - $this->_old_table = $wpdb->postmeta; |
|
18 | - $this->_pretty_name = __('Billing Info', 'event_espresso'); |
|
19 | - $this->_extra_where_sql = "WHERE meta_key LIKE 'billing_info_%'"; |
|
20 | - parent::__construct(); |
|
21 | - } |
|
22 | - protected function _migrate_old_row($old_row) |
|
23 | - { |
|
24 | - $new_billing_info = array(); |
|
25 | - $old_billing_info = maybe_unserialize($old_row['meta_value']); |
|
26 | - $gateway_name = str_replace("billing_info_", '', $old_row['meta_key']); |
|
27 | - $repetitive_prefix = '_reg-page-billing-'; |
|
28 | - $repetitive_suffix = "-" . $gateway_name; |
|
29 | - foreach ($old_billing_info as $old_input_name => $input_value) { |
|
30 | - $old_input_name_important_part = str_replace(array( $repetitive_prefix, $repetitive_suffix ), array( '', ''), $old_input_name); |
|
14 | + public function __construct() |
|
15 | + { |
|
16 | + global $wpdb; |
|
17 | + $this->_old_table = $wpdb->postmeta; |
|
18 | + $this->_pretty_name = __('Billing Info', 'event_espresso'); |
|
19 | + $this->_extra_where_sql = "WHERE meta_key LIKE 'billing_info_%'"; |
|
20 | + parent::__construct(); |
|
21 | + } |
|
22 | + protected function _migrate_old_row($old_row) |
|
23 | + { |
|
24 | + $new_billing_info = array(); |
|
25 | + $old_billing_info = maybe_unserialize($old_row['meta_value']); |
|
26 | + $gateway_name = str_replace("billing_info_", '', $old_row['meta_key']); |
|
27 | + $repetitive_prefix = '_reg-page-billing-'; |
|
28 | + $repetitive_suffix = "-" . $gateway_name; |
|
29 | + foreach ($old_billing_info as $old_input_name => $input_value) { |
|
30 | + $old_input_name_important_part = str_replace(array( $repetitive_prefix, $repetitive_suffix ), array( '', ''), $old_input_name); |
|
31 | 31 | |
32 | - switch ($old_input_name_important_part) { |
|
33 | - case 'fname': |
|
34 | - $new_input_name = 'first_name'; |
|
35 | - break; |
|
36 | - case 'lname': |
|
37 | - $new_input_name = 'last_name'; |
|
38 | - break; |
|
39 | - case 'state': |
|
40 | - // we used to store the state's id ,but now we just store the name |
|
41 | - $new_input_name = $old_input_name_important_part; |
|
42 | - $input_value = $this->_get_state_name_by_ID($input_value); |
|
43 | - break; |
|
44 | - case 'card-nmbr': |
|
45 | - $new_input_name = 'credit_card'; |
|
46 | - break; |
|
47 | - case 'card-type':// paypal pro only |
|
48 | - $new_input_name = 'credit_card_type'; |
|
49 | - break; |
|
50 | - case 'card-exp-date-mnth': |
|
51 | - $new_input_name = 'exp_month'; |
|
52 | - $input_value = ''; |
|
53 | - break; |
|
54 | - case 'card-exp-date-year': |
|
55 | - $new_input_name = 'exp_year'; |
|
56 | - $input_value = 0; |
|
57 | - break; |
|
58 | - case 'ccv-code': |
|
59 | - $new_input_name = 'cvv'; |
|
60 | - break; |
|
61 | - default: |
|
62 | - $new_input_name = $old_input_name_important_part; |
|
63 | - } |
|
64 | - $new_billing_info[ $new_input_name ] = $input_value; |
|
65 | - } |
|
66 | - update_post_meta($old_row['post_id'], $old_row['meta_key'], $new_billing_info); |
|
67 | - } |
|
68 | - /** |
|
69 | - * |
|
70 | - * @global type $wpdb |
|
71 | - * @param int $id |
|
72 | - * @return string |
|
73 | - */ |
|
74 | - protected function _get_state_name_by_ID($id) |
|
75 | - { |
|
76 | - global $wpdb; |
|
77 | - return $wpdb->get_var($wpdb->prepare("SELECT STA_name FROM " . $wpdb->prefix . "esp_state WHERE STA_ID = %d", $id)); |
|
78 | - } |
|
32 | + switch ($old_input_name_important_part) { |
|
33 | + case 'fname': |
|
34 | + $new_input_name = 'first_name'; |
|
35 | + break; |
|
36 | + case 'lname': |
|
37 | + $new_input_name = 'last_name'; |
|
38 | + break; |
|
39 | + case 'state': |
|
40 | + // we used to store the state's id ,but now we just store the name |
|
41 | + $new_input_name = $old_input_name_important_part; |
|
42 | + $input_value = $this->_get_state_name_by_ID($input_value); |
|
43 | + break; |
|
44 | + case 'card-nmbr': |
|
45 | + $new_input_name = 'credit_card'; |
|
46 | + break; |
|
47 | + case 'card-type':// paypal pro only |
|
48 | + $new_input_name = 'credit_card_type'; |
|
49 | + break; |
|
50 | + case 'card-exp-date-mnth': |
|
51 | + $new_input_name = 'exp_month'; |
|
52 | + $input_value = ''; |
|
53 | + break; |
|
54 | + case 'card-exp-date-year': |
|
55 | + $new_input_name = 'exp_year'; |
|
56 | + $input_value = 0; |
|
57 | + break; |
|
58 | + case 'ccv-code': |
|
59 | + $new_input_name = 'cvv'; |
|
60 | + break; |
|
61 | + default: |
|
62 | + $new_input_name = $old_input_name_important_part; |
|
63 | + } |
|
64 | + $new_billing_info[ $new_input_name ] = $input_value; |
|
65 | + } |
|
66 | + update_post_meta($old_row['post_id'], $old_row['meta_key'], $new_billing_info); |
|
67 | + } |
|
68 | + /** |
|
69 | + * |
|
70 | + * @global type $wpdb |
|
71 | + * @param int $id |
|
72 | + * @return string |
|
73 | + */ |
|
74 | + protected function _get_state_name_by_ID($id) |
|
75 | + { |
|
76 | + global $wpdb; |
|
77 | + return $wpdb->get_var($wpdb->prepare("SELECT STA_name FROM " . $wpdb->prefix . "esp_state WHERE STA_ID = %d", $id)); |
|
78 | + } |
|
79 | 79 | } |
@@ -25,9 +25,9 @@ discard block |
||
25 | 25 | $old_billing_info = maybe_unserialize($old_row['meta_value']); |
26 | 26 | $gateway_name = str_replace("billing_info_", '', $old_row['meta_key']); |
27 | 27 | $repetitive_prefix = '_reg-page-billing-'; |
28 | - $repetitive_suffix = "-" . $gateway_name; |
|
28 | + $repetitive_suffix = "-".$gateway_name; |
|
29 | 29 | foreach ($old_billing_info as $old_input_name => $input_value) { |
30 | - $old_input_name_important_part = str_replace(array( $repetitive_prefix, $repetitive_suffix ), array( '', ''), $old_input_name); |
|
30 | + $old_input_name_important_part = str_replace(array($repetitive_prefix, $repetitive_suffix), array('', ''), $old_input_name); |
|
31 | 31 | |
32 | 32 | switch ($old_input_name_important_part) { |
33 | 33 | case 'fname': |
@@ -61,7 +61,7 @@ discard block |
||
61 | 61 | default: |
62 | 62 | $new_input_name = $old_input_name_important_part; |
63 | 63 | } |
64 | - $new_billing_info[ $new_input_name ] = $input_value; |
|
64 | + $new_billing_info[$new_input_name] = $input_value; |
|
65 | 65 | } |
66 | 66 | update_post_meta($old_row['post_id'], $old_row['meta_key'], $new_billing_info); |
67 | 67 | } |
@@ -74,6 +74,6 @@ discard block |
||
74 | 74 | protected function _get_state_name_by_ID($id) |
75 | 75 | { |
76 | 76 | global $wpdb; |
77 | - return $wpdb->get_var($wpdb->prepare("SELECT STA_name FROM " . $wpdb->prefix . "esp_state WHERE STA_ID = %d", $id)); |
|
77 | + return $wpdb->get_var($wpdb->prepare("SELECT STA_name FROM ".$wpdb->prefix."esp_state WHERE STA_ID = %d", $id)); |
|
78 | 78 | } |
79 | 79 | } |
@@ -12,57 +12,57 @@ |
||
12 | 12 | class EE_DMS_4_6_0_question_types extends EE_Data_Migration_Script_Stage_Table |
13 | 13 | { |
14 | 14 | |
15 | - protected $_question_type_conversions = array(); |
|
15 | + protected $_question_type_conversions = array(); |
|
16 | 16 | |
17 | 17 | |
18 | 18 | |
19 | - /** |
|
20 | - * Just initializes the status of the migration |
|
21 | - * |
|
22 | - * @return EE_DMS_4_6_0_question_types |
|
23 | - */ |
|
24 | - public function __construct() |
|
25 | - { |
|
26 | - global $wpdb; |
|
27 | - $this->_pretty_name = __('Question Types', 'event_espresso'); |
|
28 | - $this->_old_table = $wpdb->prefix.'esp_question'; |
|
29 | - $this->_question_type_conversions = array( |
|
30 | - 'MULTIPLE' => 'CHECKBOX', |
|
31 | - 'SINGLE' => 'RADIO_BTN' |
|
32 | - ); |
|
33 | - // when fetching rows, because we automatically use a limit and offset |
|
34 | - // rows counted before migrating any rows, need to ALSO be counted after a bunch of rows were counted |
|
35 | - // so we need to include both the migrated rows as well as the non-migrated rows |
|
36 | - $QST_types_to_count = array_merge(array_keys($this->_question_type_conversions), $this->_question_type_conversions); |
|
37 | - $this->_extra_where_sql = "WHERE QST_type IN ('" . implode("', '", $QST_types_to_count) . "')" ; |
|
38 | - parent::__construct(); |
|
39 | - } |
|
19 | + /** |
|
20 | + * Just initializes the status of the migration |
|
21 | + * |
|
22 | + * @return EE_DMS_4_6_0_question_types |
|
23 | + */ |
|
24 | + public function __construct() |
|
25 | + { |
|
26 | + global $wpdb; |
|
27 | + $this->_pretty_name = __('Question Types', 'event_espresso'); |
|
28 | + $this->_old_table = $wpdb->prefix.'esp_question'; |
|
29 | + $this->_question_type_conversions = array( |
|
30 | + 'MULTIPLE' => 'CHECKBOX', |
|
31 | + 'SINGLE' => 'RADIO_BTN' |
|
32 | + ); |
|
33 | + // when fetching rows, because we automatically use a limit and offset |
|
34 | + // rows counted before migrating any rows, need to ALSO be counted after a bunch of rows were counted |
|
35 | + // so we need to include both the migrated rows as well as the non-migrated rows |
|
36 | + $QST_types_to_count = array_merge(array_keys($this->_question_type_conversions), $this->_question_type_conversions); |
|
37 | + $this->_extra_where_sql = "WHERE QST_type IN ('" . implode("', '", $QST_types_to_count) . "')" ; |
|
38 | + parent::__construct(); |
|
39 | + } |
|
40 | 40 | |
41 | - /** |
|
42 | - * @param array $question an associative array where keys are column names and values are their values. |
|
43 | - * @return null |
|
44 | - */ |
|
45 | - protected function _migrate_old_row($question) |
|
46 | - { |
|
47 | - global $wpdb; |
|
48 | - if ($question['QST_ID'] && isset($this->_question_type_conversions[ $question['QST_type'] ])) { |
|
49 | - $success = $wpdb->update( |
|
50 | - $this->_old_table, |
|
51 | - array( 'QST_type' => $this->_question_type_conversions[ $question['QST_type'] ] ), // data |
|
52 | - array( 'QST_ID' => $question['QST_ID'] ), // where |
|
53 | - array( '%s' ), // data format |
|
54 | - array( '%d' ) // where format |
|
55 | - ); |
|
56 | - if (! $success) { |
|
57 | - $this->add_error( |
|
58 | - sprintf( |
|
59 | - __('Could not update question type %1$s for question ID=%2$d because "%3$s"', 'event_espresso'), |
|
60 | - wp_json_encode($question['QST_type']), |
|
61 | - $question['QST_ID'], |
|
62 | - $wpdb->last_error |
|
63 | - ) |
|
64 | - ); |
|
65 | - } |
|
66 | - } |
|
67 | - } |
|
41 | + /** |
|
42 | + * @param array $question an associative array where keys are column names and values are their values. |
|
43 | + * @return null |
|
44 | + */ |
|
45 | + protected function _migrate_old_row($question) |
|
46 | + { |
|
47 | + global $wpdb; |
|
48 | + if ($question['QST_ID'] && isset($this->_question_type_conversions[ $question['QST_type'] ])) { |
|
49 | + $success = $wpdb->update( |
|
50 | + $this->_old_table, |
|
51 | + array( 'QST_type' => $this->_question_type_conversions[ $question['QST_type'] ] ), // data |
|
52 | + array( 'QST_ID' => $question['QST_ID'] ), // where |
|
53 | + array( '%s' ), // data format |
|
54 | + array( '%d' ) // where format |
|
55 | + ); |
|
56 | + if (! $success) { |
|
57 | + $this->add_error( |
|
58 | + sprintf( |
|
59 | + __('Could not update question type %1$s for question ID=%2$d because "%3$s"', 'event_espresso'), |
|
60 | + wp_json_encode($question['QST_type']), |
|
61 | + $question['QST_ID'], |
|
62 | + $wpdb->last_error |
|
63 | + ) |
|
64 | + ); |
|
65 | + } |
|
66 | + } |
|
67 | + } |
|
68 | 68 | } |
@@ -34,7 +34,7 @@ discard block |
||
34 | 34 | // rows counted before migrating any rows, need to ALSO be counted after a bunch of rows were counted |
35 | 35 | // so we need to include both the migrated rows as well as the non-migrated rows |
36 | 36 | $QST_types_to_count = array_merge(array_keys($this->_question_type_conversions), $this->_question_type_conversions); |
37 | - $this->_extra_where_sql = "WHERE QST_type IN ('" . implode("', '", $QST_types_to_count) . "')" ; |
|
37 | + $this->_extra_where_sql = "WHERE QST_type IN ('".implode("', '", $QST_types_to_count)."')"; |
|
38 | 38 | parent::__construct(); |
39 | 39 | } |
40 | 40 | |
@@ -45,15 +45,15 @@ discard block |
||
45 | 45 | protected function _migrate_old_row($question) |
46 | 46 | { |
47 | 47 | global $wpdb; |
48 | - if ($question['QST_ID'] && isset($this->_question_type_conversions[ $question['QST_type'] ])) { |
|
48 | + if ($question['QST_ID'] && isset($this->_question_type_conversions[$question['QST_type']])) { |
|
49 | 49 | $success = $wpdb->update( |
50 | 50 | $this->_old_table, |
51 | - array( 'QST_type' => $this->_question_type_conversions[ $question['QST_type'] ] ), // data |
|
52 | - array( 'QST_ID' => $question['QST_ID'] ), // where |
|
53 | - array( '%s' ), // data format |
|
54 | - array( '%d' ) // where format |
|
51 | + array('QST_type' => $this->_question_type_conversions[$question['QST_type']]), // data |
|
52 | + array('QST_ID' => $question['QST_ID']), // where |
|
53 | + array('%s'), // data format |
|
54 | + array('%d') // where format |
|
55 | 55 | ); |
56 | - if (! $success) { |
|
56 | + if ( ! $success) { |
|
57 | 57 | $this->add_error( |
58 | 58 | sprintf( |
59 | 59 | __('Could not update question type %1$s for question ID=%2$d because "%3$s"', 'event_espresso'), |