@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | -if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
3 | - exit( 'No direct script access allowed' ); |
|
2 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
3 | + exit('No direct script access allowed'); |
|
4 | 4 | } |
5 | 5 | |
6 | 6 | /** |
@@ -12,20 +12,20 @@ discard block |
||
12 | 12 | * @author Brent Christensen |
13 | 13 | * |
14 | 14 | */ |
15 | -class EE_DMS_4_7_0_Add_Taxes_To_REG_Final_Price extends EE_Data_Migration_Script_Stage_Table{ |
|
15 | +class EE_DMS_4_7_0_Add_Taxes_To_REG_Final_Price extends EE_Data_Migration_Script_Stage_Table { |
|
16 | 16 | |
17 | 17 | protected $_ticket_table; |
18 | 18 | |
19 | 19 | protected $_line_item_table; |
20 | 20 | |
21 | - function __construct(){ |
|
21 | + function __construct() { |
|
22 | 22 | /** @type WPDB $wpdb */ |
23 | 23 | global $wpdb; |
24 | - $this->_pretty_name = __( 'Registration Final Price Tax Calculations', 'event_espresso' ); |
|
24 | + $this->_pretty_name = __('Registration Final Price Tax Calculations', 'event_espresso'); |
|
25 | 25 | // define tables |
26 | - $this->_old_table = $wpdb->prefix . 'esp_registration'; |
|
27 | - $this->_ticket_table = $wpdb->prefix . 'esp_ticket'; |
|
28 | - $this->_line_item_table = $wpdb->prefix . 'esp_line_item'; |
|
26 | + $this->_old_table = $wpdb->prefix.'esp_registration'; |
|
27 | + $this->_ticket_table = $wpdb->prefix.'esp_ticket'; |
|
28 | + $this->_line_item_table = $wpdb->prefix.'esp_line_item'; |
|
29 | 29 | parent::__construct(); |
30 | 30 | } |
31 | 31 | |
@@ -55,7 +55,7 @@ discard block |
||
55 | 55 | global $wpdb; |
56 | 56 | $SQL = "SELECT count( reg.REG_ID ) "; |
57 | 57 | $SQL .= $this->_get_rest_of_sql_for_query(); |
58 | - $count = $wpdb->get_var( $SQL ); |
|
58 | + $count = $wpdb->get_var($SQL); |
|
59 | 59 | return $count; |
60 | 60 | } |
61 | 61 | |
@@ -67,13 +67,13 @@ discard block |
||
67 | 67 | * @param int $limit |
68 | 68 | * @return array of arrays like $wpdb->get_results($sql, ARRAY_A) |
69 | 69 | */ |
70 | - protected function _get_rows( $limit ) { |
|
70 | + protected function _get_rows($limit) { |
|
71 | 71 | /** @type WPDB $wpdb */ |
72 | 72 | global $wpdb; |
73 | 73 | $start_at_record = $this->count_records_migrated(); |
74 | 74 | $SQL = "SELECT reg.REG_ID, reg.REG_final_price, line.LIN_ID "; |
75 | 75 | $SQL .= $this->_get_rest_of_sql_for_query(); |
76 | - $SQL .= $wpdb->prepare( "LIMIT %d, %d", $start_at_record, $limit ); |
|
76 | + $SQL .= $wpdb->prepare("LIMIT %d, %d", $start_at_record, $limit); |
|
77 | 77 | |
78 | 78 | // produces something like: |
79 | 79 | /* |
@@ -93,7 +93,7 @@ discard block |
||
93 | 93 | LIMIT 1, 50 |
94 | 94 | */ |
95 | 95 | |
96 | - return $wpdb->get_results( $SQL, ARRAY_A ); |
|
96 | + return $wpdb->get_results($SQL, ARRAY_A); |
|
97 | 97 | } |
98 | 98 | |
99 | 99 | |
@@ -102,38 +102,38 @@ discard block |
||
102 | 102 | * @param array $row |
103 | 103 | * @return void |
104 | 104 | */ |
105 | - protected function _migrate_old_row( $row ) { |
|
105 | + protected function _migrate_old_row($row) { |
|
106 | 106 | /** @type WPDB $wpdb */ |
107 | 107 | global $wpdb; |
108 | 108 | // ensure all required values are present |
109 | - if ( ! isset( $row[ 'REG_ID' ], $row[ 'REG_final_price' ], $row[ 'LIN_ID' ] )) { |
|
109 | + if ( ! isset($row['REG_ID'], $row['REG_final_price'], $row['LIN_ID'])) { |
|
110 | 110 | $this->add_error( |
111 | 111 | sprintf( |
112 | - __( 'Invalid query results returned with the following data:%1$s REG_ID=%2$d, REG_final_price=%3$d, LIN_ID=%4$f. Error: "%5$s"', 'event_espresso' ), |
|
112 | + __('Invalid query results returned with the following data:%1$s REG_ID=%2$d, REG_final_price=%3$d, LIN_ID=%4$f. Error: "%5$s"', 'event_espresso'), |
|
113 | 113 | '<br />', |
114 | - isset( $row[ 'REG_ID' ] ) ? $row[ 'REG_ID' ] : '', |
|
115 | - isset( $row[ 'REG_final_price' ] ) ? $row[ 'REG_final_price' ] : '', |
|
116 | - isset( $row[ 'LIN_ID' ] ) ? $row[ 'LIN_ID' ] : '', |
|
114 | + isset($row['REG_ID']) ? $row['REG_ID'] : '', |
|
115 | + isset($row['REG_final_price']) ? $row['REG_final_price'] : '', |
|
116 | + isset($row['LIN_ID']) ? $row['LIN_ID'] : '', |
|
117 | 117 | $wpdb->last_error |
118 | 118 | ) |
119 | 119 | ); |
120 | 120 | return; |
121 | 121 | } |
122 | 122 | // get tax subtotal |
123 | - $tax_subtotal_line_item_ID = $this->_get_line_item_ID_for_tax_subtotal( $row['LIN_ID'] ); |
|
124 | - if ( ! $tax_subtotal_line_item_ID ) { |
|
123 | + $tax_subtotal_line_item_ID = $this->_get_line_item_ID_for_tax_subtotal($row['LIN_ID']); |
|
124 | + if ( ! $tax_subtotal_line_item_ID) { |
|
125 | 125 | $this->add_error( |
126 | 126 | sprintf( |
127 | - __( 'Invalid line item ID returned. Error: "%1$s"', 'event_espresso' ), |
|
127 | + __('Invalid line item ID returned. Error: "%1$s"', 'event_espresso'), |
|
128 | 128 | $wpdb->last_error |
129 | 129 | ) |
130 | 130 | ); |
131 | 131 | return; |
132 | 132 | } |
133 | 133 | // now get taxes |
134 | - $taxes = $this->_get_tax_amounts( $tax_subtotal_line_item_ID ); |
|
134 | + $taxes = $this->_get_tax_amounts($tax_subtotal_line_item_ID); |
|
135 | 135 | // apply taxes to registration final price |
136 | - $this->_apply_taxes( $row[ 'REG_ID' ], $row[ 'REG_final_price' ], $taxes ); |
|
136 | + $this->_apply_taxes($row['REG_ID'], $row['REG_final_price'], $taxes); |
|
137 | 137 | |
138 | 138 | } |
139 | 139 | |
@@ -145,14 +145,14 @@ discard block |
||
145 | 145 | * @param int $LIN_ID |
146 | 146 | * @return int |
147 | 147 | */ |
148 | - protected function _get_line_item_ID_for_tax_subtotal( $LIN_ID ) { |
|
148 | + protected function _get_line_item_ID_for_tax_subtotal($LIN_ID) { |
|
149 | 149 | /** @type WPDB $wpdb */ |
150 | 150 | global $wpdb; |
151 | 151 | $SQL = "SELECT LIN_ID "; |
152 | 152 | $SQL .= "FROM {$this->_line_item_table} "; |
153 | 153 | $SQL .= "WHERE LIN_parent = %d "; |
154 | 154 | $SQL .= "AND LIN_code = 'taxes'"; |
155 | - return $wpdb->get_var( $wpdb->prepare( $SQL, $LIN_ID ) ); |
|
155 | + return $wpdb->get_var($wpdb->prepare($SQL, $LIN_ID)); |
|
156 | 156 | } |
157 | 157 | |
158 | 158 | |
@@ -163,13 +163,13 @@ discard block |
||
163 | 163 | * @param int $LIN_ID |
164 | 164 | * @return array |
165 | 165 | */ |
166 | - protected function _get_tax_amounts( $LIN_ID ) { |
|
166 | + protected function _get_tax_amounts($LIN_ID) { |
|
167 | 167 | /** @type WPDB $wpdb */ |
168 | 168 | global $wpdb; |
169 | 169 | $SQL = "SELECT LIN_percent "; |
170 | 170 | $SQL .= "FROM {$this->_line_item_table} "; |
171 | 171 | $SQL .= "WHERE LIN_parent = %d"; |
172 | - return $wpdb->get_results( $wpdb->prepare( $SQL, $LIN_ID ), OBJECT_K ); |
|
172 | + return $wpdb->get_results($wpdb->prepare($SQL, $LIN_ID), OBJECT_K); |
|
173 | 173 | } |
174 | 174 | |
175 | 175 | |
@@ -182,14 +182,14 @@ discard block |
||
182 | 182 | * @param array $taxes |
183 | 183 | * @return void |
184 | 184 | */ |
185 | - protected function _apply_taxes( $REG_ID = 0, $final_price = 0.00, $taxes = array() ) { |
|
186 | - if ( is_array( $taxes ) && ! empty( $taxes ) ) { |
|
185 | + protected function _apply_taxes($REG_ID = 0, $final_price = 0.00, $taxes = array()) { |
|
186 | + if (is_array($taxes) && ! empty($taxes)) { |
|
187 | 187 | $total_taxes = 0; |
188 | - foreach ( $taxes as $tax ) { |
|
189 | - $total_taxes += $final_price * ( $tax->LIN_percent / 100 ); |
|
188 | + foreach ($taxes as $tax) { |
|
189 | + $total_taxes += $final_price * ($tax->LIN_percent / 100); |
|
190 | 190 | } |
191 | 191 | $final_price += $total_taxes; |
192 | - $this->_update_registration_final_price( $REG_ID, $final_price ); |
|
192 | + $this->_update_registration_final_price($REG_ID, $final_price); |
|
193 | 193 | } |
194 | 194 | } |
195 | 195 | |
@@ -202,20 +202,20 @@ discard block |
||
202 | 202 | * @param float $REG_final_price |
203 | 203 | * @return void |
204 | 204 | */ |
205 | - protected function _update_registration_final_price( $REG_ID = 0, $REG_final_price = 0.00 ) { |
|
205 | + protected function _update_registration_final_price($REG_ID = 0, $REG_final_price = 0.00) { |
|
206 | 206 | /** @type WPDB $wpdb */ |
207 | 207 | global $wpdb; |
208 | 208 | $success = $wpdb->update( |
209 | 209 | $this->_old_table, |
210 | - array( 'REG_final_price' => $REG_final_price ), // data |
|
211 | - array( 'REG_ID' => $REG_ID ), // where |
|
212 | - array( '%f' ), // data format |
|
213 | - array( '%d' ) // where format |
|
210 | + array('REG_final_price' => $REG_final_price), // data |
|
211 | + array('REG_ID' => $REG_ID), // where |
|
212 | + array('%f'), // data format |
|
213 | + array('%d') // where format |
|
214 | 214 | ); |
215 | - if ( $success === false ) { |
|
215 | + if ($success === false) { |
|
216 | 216 | $this->add_error( |
217 | 217 | sprintf( |
218 | - __( 'Could not update registration final price value for registration ID=%1$d because "%2$s"', 'event_espresso' ), |
|
218 | + __('Could not update registration final price value for registration ID=%1$d because "%2$s"', 'event_espresso'), |
|
219 | 219 | $REG_ID, |
220 | 220 | $wpdb->last_error |
221 | 221 | ) |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | -if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
3 | - exit( 'No direct script access allowed' ); |
|
2 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
3 | + exit('No direct script access allowed'); |
|
4 | 4 | } |
5 | 5 | |
6 | 6 | /** |
@@ -12,7 +12,7 @@ discard block |
||
12 | 12 | * @author Brent Christensen |
13 | 13 | * |
14 | 14 | */ |
15 | -class EE_DMS_4_7_0_Registration_Payments extends EE_Data_Migration_Script_Stage_Table{ |
|
15 | +class EE_DMS_4_7_0_Registration_Payments extends EE_Data_Migration_Script_Stage_Table { |
|
16 | 16 | |
17 | 17 | protected $_payment_table; |
18 | 18 | |
@@ -20,15 +20,15 @@ discard block |
||
20 | 20 | |
21 | 21 | protected $_registration_payment_table; |
22 | 22 | |
23 | - function __construct(){ |
|
23 | + function __construct() { |
|
24 | 24 | /** @type WPDB $wpdb */ |
25 | 25 | global $wpdb; |
26 | - $this->_pretty_name = __( 'Registration Payment Record Generation', 'event_espresso' ); |
|
26 | + $this->_pretty_name = __('Registration Payment Record Generation', 'event_espresso'); |
|
27 | 27 | // define tables |
28 | - $this->_old_table = $wpdb->prefix . 'esp_transaction'; |
|
29 | - $this->_payment_table = $wpdb->prefix . 'esp_payment'; |
|
30 | - $this->_registration_table = $wpdb->prefix . 'esp_registration'; |
|
31 | - $this->_registration_payment_table = $wpdb->prefix . 'esp_registration_payment'; |
|
28 | + $this->_old_table = $wpdb->prefix.'esp_transaction'; |
|
29 | + $this->_payment_table = $wpdb->prefix.'esp_payment'; |
|
30 | + $this->_registration_table = $wpdb->prefix.'esp_registration'; |
|
31 | + $this->_registration_payment_table = $wpdb->prefix.'esp_registration_payment'; |
|
32 | 32 | // build SQL WHERE clauses |
33 | 33 | $this->_extra_where_sql = "WHERE STS_ID IN ( 'TIN', 'TCM' ) AND TXN_Total != '0.000'"; |
34 | 34 | parent::__construct(); |
@@ -40,14 +40,14 @@ discard block |
||
40 | 40 | * @param array $transaction |
41 | 41 | * @return void |
42 | 42 | */ |
43 | - protected function _migrate_old_row( $transaction ) { |
|
43 | + protected function _migrate_old_row($transaction) { |
|
44 | 44 | /** @type WPDB $wpdb */ |
45 | 45 | global $wpdb; |
46 | - $TXN_ID = absint( $transaction[ 'TXN_ID' ] ); |
|
47 | - if ( ! $TXN_ID ) { |
|
46 | + $TXN_ID = absint($transaction['TXN_ID']); |
|
47 | + if ( ! $TXN_ID) { |
|
48 | 48 | $this->add_error( |
49 | 49 | sprintf( |
50 | - __( 'Invalid transaction with ID=%1$d. Error: "%2$s"', 'event_espresso' ), |
|
50 | + __('Invalid transaction with ID=%1$d. Error: "%2$s"', 'event_espresso'), |
|
51 | 51 | $TXN_ID, |
52 | 52 | $wpdb->last_error |
53 | 53 | ) |
@@ -55,19 +55,19 @@ discard block |
||
55 | 55 | return; |
56 | 56 | } |
57 | 57 | // get all payments for the TXN |
58 | - $payments = $this->_get_payments( $TXN_ID ); |
|
59 | - if ( empty( $payments ) ) { |
|
58 | + $payments = $this->_get_payments($TXN_ID); |
|
59 | + if (empty($payments)) { |
|
60 | 60 | return; |
61 | 61 | } |
62 | 62 | // then the registrants |
63 | - $registrations = $this->_get_registrations( $TXN_ID ); |
|
64 | - if ( empty( $registrations ) ) { |
|
63 | + $registrations = $this->_get_registrations($TXN_ID); |
|
64 | + if (empty($registrations)) { |
|
65 | 65 | return; |
66 | 66 | } |
67 | 67 | // now loop thru each payment and apply it to each of the registrations |
68 | - foreach ( $payments as $PAY_ID => $payment ) { |
|
69 | - if ( $payment->STS_ID === 'PAP' && $payment->PAY_amount > 0 ) { |
|
70 | - $this->_process_registration_payments( $payment, $registrations ); |
|
68 | + foreach ($payments as $PAY_ID => $payment) { |
|
69 | + if ($payment->STS_ID === 'PAP' && $payment->PAY_amount > 0) { |
|
70 | + $this->_process_registration_payments($payment, $registrations); |
|
71 | 71 | } |
72 | 72 | } |
73 | 73 | } |
@@ -80,11 +80,11 @@ discard block |
||
80 | 80 | * @param int $TXN_ID |
81 | 81 | * @return array |
82 | 82 | */ |
83 | - protected function _get_registrations( $TXN_ID ) { |
|
83 | + protected function _get_registrations($TXN_ID) { |
|
84 | 84 | /** @type WPDB $wpdb */ |
85 | 85 | global $wpdb; |
86 | 86 | $SQL = "SELECT * FROM {$this->_registration_table} WHERE TXN_ID = %d AND STS_ID IN ( 'RPP', 'RAP' )"; |
87 | - return $wpdb->get_results( $wpdb->prepare( $SQL, $TXN_ID ), OBJECT_K ); |
|
87 | + return $wpdb->get_results($wpdb->prepare($SQL, $TXN_ID), OBJECT_K); |
|
88 | 88 | } |
89 | 89 | |
90 | 90 | |
@@ -95,10 +95,10 @@ discard block |
||
95 | 95 | * @param int $TXN_ID |
96 | 96 | * @return array |
97 | 97 | */ |
98 | - protected function _get_payments( $TXN_ID ) { |
|
98 | + protected function _get_payments($TXN_ID) { |
|
99 | 99 | /** @type WPDB $wpdb */ |
100 | 100 | global $wpdb; |
101 | - return $wpdb->get_results( $wpdb->prepare( "SELECT * FROM {$this->_payment_table} WHERE TXN_ID = %d", $TXN_ID ), OBJECT_K ); |
|
101 | + return $wpdb->get_results($wpdb->prepare("SELECT * FROM {$this->_payment_table} WHERE TXN_ID = %d", $TXN_ID), OBJECT_K); |
|
102 | 102 | } |
103 | 103 | |
104 | 104 | |
@@ -109,10 +109,10 @@ discard block |
||
109 | 109 | * @param int $REG_ID |
110 | 110 | * @return array |
111 | 111 | */ |
112 | - protected function _get_possibly_updated_REG_paid( $REG_ID ) { |
|
112 | + protected function _get_possibly_updated_REG_paid($REG_ID) { |
|
113 | 113 | /** @type WPDB $wpdb */ |
114 | 114 | global $wpdb; |
115 | - return $wpdb->get_var( $wpdb->prepare( "SELECT REG_paid FROM {$this->_registration_table} WHERE REG_ID = %d", $REG_ID ) ); |
|
115 | + return $wpdb->get_var($wpdb->prepare("SELECT REG_paid FROM {$this->_registration_table} WHERE REG_ID = %d", $REG_ID)); |
|
116 | 116 | } |
117 | 117 | |
118 | 118 | |
@@ -127,40 +127,40 @@ discard block |
||
127 | 127 | * @param array $registrations |
128 | 128 | * @return bool |
129 | 129 | */ |
130 | - protected function _process_registration_payments( $payment, $registrations = array() ){ |
|
130 | + protected function _process_registration_payments($payment, $registrations = array()) { |
|
131 | 131 | // how much is available to apply to registrations? |
132 | 132 | $available_payment_amount = $payment->PAY_amount; |
133 | - foreach ( $registrations as $REG_ID => $registration ) { |
|
133 | + foreach ($registrations as $REG_ID => $registration) { |
|
134 | 134 | // nothing left, then we are done here? |
135 | - if ( ! $available_payment_amount > 0 ) { |
|
135 | + if ( ! $available_payment_amount > 0) { |
|
136 | 136 | break; |
137 | 137 | } |
138 | 138 | // ensure REG_final_price has a valid value, and skip if it turns out to be zero |
139 | - $registration->REG_final_price = ! empty( $registration->REG_final_price ) ? (float)$registration->REG_final_price : 0.00; |
|
140 | - if ( ! $registration->REG_final_price > 0 ) { |
|
139 | + $registration->REG_final_price = ! empty($registration->REG_final_price) ? (float) $registration->REG_final_price : 0.00; |
|
140 | + if ( ! $registration->REG_final_price > 0) { |
|
141 | 141 | continue; |
142 | 142 | } |
143 | 143 | // because REG_paid may have been updated by a previous payment, we need to retrieve the value from the db |
144 | - $possibly_updated_REG_paid = $this->_get_possibly_updated_REG_paid( $REG_ID ); |
|
145 | - if ( is_float( $possibly_updated_REG_paid ) ) { |
|
144 | + $possibly_updated_REG_paid = $this->_get_possibly_updated_REG_paid($REG_ID); |
|
145 | + if (is_float($possibly_updated_REG_paid)) { |
|
146 | 146 | $registration->REG_paid = $possibly_updated_REG_paid; |
147 | 147 | } |
148 | 148 | // and ensure REG_paid has a valid value |
149 | - $registration->REG_paid = ! empty( $registration->REG_paid ) ? (float)$registration->REG_paid : 0.00; |
|
149 | + $registration->REG_paid = ! empty($registration->REG_paid) ? (float) $registration->REG_paid : 0.00; |
|
150 | 150 | // calculate amount owing, and skip if it turns out to be zero |
151 | 151 | $owing = $registration->REG_final_price - $registration->REG_paid; |
152 | - if ( ! $owing > 0 ) { |
|
152 | + if ( ! $owing > 0) { |
|
153 | 153 | continue; |
154 | 154 | } |
155 | 155 | // don't allow payment amount to exceed the available payment amount, OR the amount owing |
156 | - $payment_amount = min( $available_payment_amount, $owing ); |
|
156 | + $payment_amount = min($available_payment_amount, $owing); |
|
157 | 157 | // update $available_payment_amount |
158 | 158 | $available_payment_amount = $available_payment_amount - $payment_amount; |
159 | 159 | // add relation between registration and payment and set amount |
160 | - if ( $this->_insert_registration_payment( $registration->REG_ID, $payment->PAY_ID, $payment_amount )) { |
|
160 | + if ($this->_insert_registration_payment($registration->REG_ID, $payment->PAY_ID, $payment_amount)) { |
|
161 | 161 | //calculate and set new REG_paid |
162 | 162 | $registration->REG_paid = $registration->REG_paid + $payment_amount; |
163 | - $this->_update_registration_paid( $registration->REG_ID, $registration->REG_paid ); |
|
163 | + $this->_update_registration_paid($registration->REG_ID, $registration->REG_paid); |
|
164 | 164 | } |
165 | 165 | } |
166 | 166 | } |
@@ -175,18 +175,18 @@ discard block |
||
175 | 175 | * @param float $PAY_amount |
176 | 176 | * @return bool |
177 | 177 | */ |
178 | - protected function _insert_registration_payment( $REG_ID = 0, $PAY_ID = 0, $PAY_amount = 0.00 ){ |
|
178 | + protected function _insert_registration_payment($REG_ID = 0, $PAY_ID = 0, $PAY_amount = 0.00) { |
|
179 | 179 | /** @type WPDB $wpdb */ |
180 | 180 | global $wpdb; |
181 | 181 | $success = $wpdb->insert( |
182 | 182 | $this->_registration_payment_table, |
183 | - array( 'REG_ID' => $REG_ID, 'PAY_ID' => $PAY_ID, 'RPY_amount' => $PAY_amount, ), // data |
|
184 | - array( '%f' ) // data format |
|
183 | + array('REG_ID' => $REG_ID, 'PAY_ID' => $PAY_ID, 'RPY_amount' => $PAY_amount,), // data |
|
184 | + array('%f') // data format |
|
185 | 185 | ); |
186 | - if ( $success === false ) { |
|
186 | + if ($success === false) { |
|
187 | 187 | $this->add_error( |
188 | 188 | sprintf( |
189 | - __( 'Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso' ), |
|
189 | + __('Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso'), |
|
190 | 190 | $REG_ID, |
191 | 191 | $wpdb->last_error |
192 | 192 | ) |
@@ -205,20 +205,20 @@ discard block |
||
205 | 205 | * @param float $REG_paid |
206 | 206 | * @return bool |
207 | 207 | */ |
208 | - protected function _update_registration_paid( $REG_ID = 0, $REG_paid = 0.00 ) { |
|
208 | + protected function _update_registration_paid($REG_ID = 0, $REG_paid = 0.00) { |
|
209 | 209 | /** @type WPDB $wpdb */ |
210 | 210 | global $wpdb; |
211 | 211 | $success = $wpdb->update( |
212 | 212 | $this->_registration_table, |
213 | - array( 'REG_paid' => $REG_paid ), // data |
|
214 | - array( 'REG_ID' => $REG_ID ), // where |
|
215 | - array( '%f' ), // data format |
|
216 | - array( '%d' ) // where format |
|
213 | + array('REG_paid' => $REG_paid), // data |
|
214 | + array('REG_ID' => $REG_ID), // where |
|
215 | + array('%f'), // data format |
|
216 | + array('%d') // where format |
|
217 | 217 | ); |
218 | - if ( $success === false ) { |
|
218 | + if ($success === false) { |
|
219 | 219 | $this->add_error( |
220 | 220 | sprintf( |
221 | - __( 'Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso' ), |
|
221 | + __('Could not update registration paid value for registration ID=%1$d because "%2$s"', 'event_espresso'), |
|
222 | 222 | $REG_ID, |
223 | 223 | $wpdb->last_error |
224 | 224 | ) |
@@ -26,7 +26,7 @@ |
||
26 | 26 | * just checks the field isn't blank |
27 | 27 | * |
28 | 28 | * @param $normalized_value |
29 | - * @return bool |
|
29 | + * @return boolean|null |
|
30 | 30 | * @throws \EE_Validation_Error |
31 | 31 | */ |
32 | 32 | function validate($normalized_value) { |
@@ -1,5 +1,5 @@ discard block |
||
1 | 1 | <?php |
2 | -if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
3 | 3 | exit('No direct script access allowed'); |
4 | 4 | } |
5 | 5 | |
@@ -13,7 +13,7 @@ discard block |
||
13 | 13 | * |
14 | 14 | * Migrates line items that used to have LIN_code="tickets" to "pre-tax-total" |
15 | 15 | */ |
16 | -class EE_DMS_4_8_0_pretax_totals extends EE_Data_Migration_Script_Stage{ |
|
16 | +class EE_DMS_4_8_0_pretax_totals extends EE_Data_Migration_Script_Stage { |
|
17 | 17 | |
18 | 18 | protected $_line_item_table_name; |
19 | 19 | |
@@ -53,10 +53,10 @@ discard block |
||
53 | 53 | global $wpdb; |
54 | 54 | $rows_updated = $wpdb->update( |
55 | 55 | $this->_line_item_table_name, |
56 | - array( 'LIN_code' => 'pre-tax-subtotal' ), |
|
57 | - array( 'LIN_code' => 'tickets' ), |
|
58 | - array( '%s' ), |
|
59 | - array( '%s' ) ); |
|
56 | + array('LIN_code' => 'pre-tax-subtotal'), |
|
57 | + array('LIN_code' => 'tickets'), |
|
58 | + array('%s'), |
|
59 | + array('%s') ); |
|
60 | 60 | $this->set_completed(); |
61 | 61 | return 1; |
62 | 62 | } |
@@ -11,18 +11,18 @@ discard block |
||
11 | 11 | //(all other times it gets resurrected from a wordpress option) |
12 | 12 | $stages = glob(EE_CORE.'data_migration_scripts/4_2_0_stages/*'); |
13 | 13 | $class_to_filepath = array(); |
14 | -if ( ! empty( $stages ) ) { |
|
15 | - foreach($stages as $filepath){ |
|
14 | +if ( ! empty($stages)) { |
|
15 | + foreach ($stages as $filepath) { |
|
16 | 16 | $matches = array(); |
17 | - preg_match('~4_2_0_stages/(.*).dmsstage.php~',$filepath,$matches); |
|
17 | + preg_match('~4_2_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
18 | 18 | $class_to_filepath[$matches[1]] = $filepath; |
19 | 19 | } |
20 | 20 | } |
21 | 21 | //give addons a chance to autoload their stages too |
22 | -$class_to_filepath = apply_filters('FHEE__EE_DMS_4_2_0__autoloaded_stages',$class_to_filepath); |
|
22 | +$class_to_filepath = apply_filters('FHEE__EE_DMS_4_2_0__autoloaded_stages', $class_to_filepath); |
|
23 | 23 | EEH_Autoloader::register_autoloader($class_to_filepath); |
24 | 24 | |
25 | -class EE_DMS_Core_4_2_0 extends EE_Data_Migration_Script_Base{ |
|
25 | +class EE_DMS_Core_4_2_0 extends EE_Data_Migration_Script_Base { |
|
26 | 26 | |
27 | 27 | |
28 | 28 | |
@@ -37,15 +37,15 @@ discard block |
||
37 | 37 | } |
38 | 38 | public function can_migrate_from_version($version_array) { |
39 | 39 | $version_string = $version_array['Core']; |
40 | - if($version_string <= '4.2.0' && $version_string >= '4.1.0' ){ |
|
40 | + if ($version_string <= '4.2.0' && $version_string >= '4.1.0') { |
|
41 | 41 | // echo "$version_string can be migrated fro"; |
42 | 42 | return true; |
43 | - }elseif( ! $version_string ){ |
|
43 | + }elseif ( ! $version_string) { |
|
44 | 44 | // echo "no version string provided: $version_string"; |
45 | 45 | //no version string provided... this must be pre 4.1 |
46 | 46 | //because since 4.1 we're |
47 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
48 | - }else{ |
|
47 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
48 | + } else { |
|
49 | 49 | // echo "$version_string doesnt apply"; |
50 | 50 | return false; |
51 | 51 | } |
@@ -55,14 +55,14 @@ discard block |
||
55 | 55 | } |
56 | 56 | public function schema_changes_before_migration() { |
57 | 57 | //relies on 4.1's EEH_Activation::create_table |
58 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
59 | - $table_name='esp_answer'; |
|
60 | - $sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
58 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
59 | + $table_name = 'esp_answer'; |
|
60 | + $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
61 | 61 | REG_ID INT UNSIGNED NOT NULL, |
62 | 62 | QST_ID INT UNSIGNED NOT NULL, |
63 | 63 | ANS_value TEXT NOT NULL, |
64 | 64 | PRIMARY KEY (ANS_ID)"; |
65 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
65 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
66 | 66 | |
67 | 67 | $table_name = 'esp_attendee_meta'; |
68 | 68 | $sql = "ATTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -102,7 +102,7 @@ discard block |
||
102 | 102 | CNT_is_EU TINYINT(1) DEFAULT '0', |
103 | 103 | CNT_active TINYINT(1) DEFAULT '0', |
104 | 104 | PRIMARY KEY (CNT_ISO)"; |
105 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
105 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
106 | 106 | |
107 | 107 | |
108 | 108 | |
@@ -125,7 +125,7 @@ discard block |
||
125 | 125 | |
126 | 126 | |
127 | 127 | |
128 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
128 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
129 | 129 | $table_name = 'esp_event_meta'; |
130 | 130 | $sql = " |
131 | 131 | EVTM_ID INT NOT NULL AUTO_INCREMENT, |
@@ -142,41 +142,41 @@ discard block |
||
142 | 142 | EVT_external_URL VARCHAR(200) NULL, |
143 | 143 | EVT_donations TINYINT(1) NULL, |
144 | 144 | PRIMARY KEY (EVTM_ID)"; |
145 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
145 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
146 | 146 | |
147 | 147 | |
148 | 148 | |
149 | - $table_name='esp_event_question_group'; |
|
150 | - $sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
149 | + $table_name = 'esp_event_question_group'; |
|
150 | + $sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
151 | 151 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
152 | 152 | QSG_ID INT UNSIGNED NOT NULL, |
153 | 153 | EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
154 | 154 | PRIMARY KEY (EQG_ID)"; |
155 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
155 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
156 | 156 | |
157 | 157 | |
158 | 158 | |
159 | - $table_name='esp_event_venue'; |
|
160 | - $sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
159 | + $table_name = 'esp_event_venue'; |
|
160 | + $sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
161 | 161 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
162 | 162 | VNU_ID BIGINT(20) UNSIGNED NOT NULL, |
163 | 163 | EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
164 | 164 | PRIMARY KEY (EVV_ID)"; |
165 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
165 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
166 | 166 | |
167 | 167 | |
168 | 168 | |
169 | - $table_name='esp_extra_meta'; |
|
170 | - $sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
169 | + $table_name = 'esp_extra_meta'; |
|
170 | + $sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
171 | 171 | OBJ_ID INT(11) DEFAULT NULL, |
172 | 172 | EXM_type VARCHAR(45) DEFAULT NULL, |
173 | 173 | EXM_key VARCHAR(45) DEFAULT NULL, |
174 | 174 | EXM_value TEXT, |
175 | 175 | PRIMARY KEY (EXM_ID)"; |
176 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
176 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
177 | 177 | |
178 | - $table_name='esp_line_item'; |
|
179 | - $sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
178 | + $table_name = 'esp_line_item'; |
|
179 | + $sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
180 | 180 | LIN_code VARCHAR(245) NOT NULL DEFAULT '', |
181 | 181 | TXN_ID INT(11) DEFAULT NULL, |
182 | 182 | LIN_name VARCHAR(245) NOT NULL DEFAULT '', |
@@ -192,7 +192,7 @@ discard block |
||
192 | 192 | OBJ_ID INT(11) DEFAULT NULL, |
193 | 193 | OBJ_type VARCHAR(45)DEFAULT NULL, |
194 | 194 | PRIMARY KEY (LIN_ID)"; |
195 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB' ); |
|
195 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
196 | 196 | |
197 | 197 | $table_name = 'esp_message_template'; |
198 | 198 | $sql = "MTP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -219,7 +219,7 @@ discard block |
||
219 | 219 | PRIMARY KEY (GRP_ID), |
220 | 220 | KEY EVT_ID (EVT_ID), |
221 | 221 | KEY MTP_user_id (MTP_user_id)"; |
222 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
222 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
223 | 223 | |
224 | 224 | |
225 | 225 | |
@@ -327,8 +327,8 @@ discard block |
||
327 | 327 | |
328 | 328 | |
329 | 329 | |
330 | - $table_name='esp_question'; |
|
331 | - $sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
330 | + $table_name = 'esp_question'; |
|
331 | + $sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
332 | 332 | QST_display_text TEXT NOT NULL, |
333 | 333 | QST_admin_label VARCHAR(255) NOT NULL, |
334 | 334 | QST_system VARCHAR(25) DEFAULT NULL, |
@@ -340,12 +340,12 @@ discard block |
||
340 | 340 | QST_wp_user BIGINT UNSIGNED NULL, |
341 | 341 | QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0, |
342 | 342 | PRIMARY KEY (QST_ID)'; |
343 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
343 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
344 | 344 | |
345 | - EEH_Activation::drop_index( 'esp_question_group', 'QSG_identifier_UNIQUE' ); |
|
345 | + EEH_Activation::drop_index('esp_question_group', 'QSG_identifier_UNIQUE'); |
|
346 | 346 | |
347 | 347 | $table_name = 'esp_question_group'; |
348 | - $sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
348 | + $sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
349 | 349 | QSG_name VARCHAR(255) NOT NULL, |
350 | 350 | QSG_identifier VARCHAR(100) NOT NULL, |
351 | 351 | QSG_desc TEXT NULL, |
@@ -356,28 +356,28 @@ discard block |
||
356 | 356 | QSG_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
357 | 357 | PRIMARY KEY (QSG_ID), |
358 | 358 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)'; |
359 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
359 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
360 | 360 | |
361 | 361 | |
362 | 362 | |
363 | - $table_name='esp_question_group_question'; |
|
364 | - $sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
363 | + $table_name = 'esp_question_group_question'; |
|
364 | + $sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
365 | 365 | QSG_ID INT UNSIGNED NOT NULL, |
366 | 366 | QST_ID INT UNSIGNED NOT NULL, |
367 | 367 | QGQ_order INT UNSIGNED NOT NULL DEFAULT 0, |
368 | 368 | PRIMARY KEY (QGQ_ID) "; |
369 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
369 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
370 | 370 | |
371 | 371 | |
372 | 372 | |
373 | - $table_name='esp_question_option'; |
|
374 | - $sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
373 | + $table_name = 'esp_question_option'; |
|
374 | + $sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
375 | 375 | QSO_value VARCHAR(255) NOT NULL, |
376 | 376 | QSO_desc TEXT NOT NULL, |
377 | 377 | QST_ID INT UNSIGNED NOT NULL, |
378 | 378 | QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
379 | 379 | PRIMARY KEY (QSO_ID)"; |
380 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
380 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
381 | 381 | |
382 | 382 | |
383 | 383 | |
@@ -410,8 +410,8 @@ discard block |
||
410 | 410 | |
411 | 411 | |
412 | 412 | |
413 | - $table_name='esp_checkin'; |
|
414 | - $sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
413 | + $table_name = 'esp_checkin'; |
|
414 | + $sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
415 | 415 | REG_ID INT(10) UNSIGNED NOT NULL, |
416 | 416 | DTT_ID INT(10) UNSIGNED NOT NULL, |
417 | 417 | CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, |
@@ -485,7 +485,7 @@ discard block |
||
485 | 485 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
486 | 486 | |
487 | 487 | |
488 | - $script_with_defaults = EE_Registry::instance()->load_dms( 'Core_4_1_0' ); |
|
488 | + $script_with_defaults = EE_Registry::instance()->load_dms('Core_4_1_0'); |
|
489 | 489 | //setting up the DEFAULT stats and countries is also essential for the data migrations to run |
490 | 490 | //(because many need to convert old string states to foreign keys into the states table) |
491 | 491 | $script_with_defaults->insert_default_states(); |
@@ -507,7 +507,7 @@ discard block |
||
507 | 507 | return true; |
508 | 508 | } |
509 | 509 | |
510 | - public function migration_page_hooks(){ |
|
510 | + public function migration_page_hooks() { |
|
511 | 511 | |
512 | 512 | } |
513 | 513 | } |
@@ -65,11 +65,11 @@ |
||
65 | 65 | if( $version_string <= '4.8.0' && $version_string >= '4.7.0' ){ |
66 | 66 | // echo "$version_string can be migrated from"; |
67 | 67 | return true; |
68 | - }elseif( ! $version_string ){ |
|
68 | + } elseif( ! $version_string ){ |
|
69 | 69 | // echo "no version string provided: $version_string"; |
70 | 70 | //no version string provided... this must be pre 4.3 |
71 | 71 | return false;//changed mind. dont want people thinking they should migrate yet because they cant |
72 | - }else{ |
|
72 | + } else{ |
|
73 | 73 | // echo "$version_string doesnt apply"; |
74 | 74 | return false; |
75 | 75 | } |
@@ -10,18 +10,18 @@ discard block |
||
10 | 10 | //(all other times it gets resurrected from a wordpress option) |
11 | 11 | $stages = glob(EE_CORE.'data_migration_scripts/4_3_0_stages/*'); |
12 | 12 | $class_to_filepath = array(); |
13 | -if ( ! empty( $stages ) ) { |
|
14 | - foreach($stages as $filepath){ |
|
13 | +if ( ! empty($stages)) { |
|
14 | + foreach ($stages as $filepath) { |
|
15 | 15 | $matches = array(); |
16 | - preg_match('~4_3_0_stages/(.*).dmsstage.php~',$filepath,$matches); |
|
16 | + preg_match('~4_3_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
17 | 17 | $class_to_filepath[$matches[1]] = $filepath; |
18 | 18 | } |
19 | 19 | } |
20 | 20 | //give addons a chance to autoload their stages too |
21 | -$class_to_filepath = apply_filters('FHEE__EE_DMS_4_3_0__autoloaded_stages',$class_to_filepath); |
|
21 | +$class_to_filepath = apply_filters('FHEE__EE_DMS_4_3_0__autoloaded_stages', $class_to_filepath); |
|
22 | 22 | EEH_Autoloader::register_autoloader($class_to_filepath); |
23 | 23 | |
24 | -class EE_DMS_Core_4_3_0 extends EE_Data_Migration_Script_Base{ |
|
24 | +class EE_DMS_Core_4_3_0 extends EE_Data_Migration_Script_Base { |
|
25 | 25 | |
26 | 26 | |
27 | 27 | |
@@ -37,14 +37,14 @@ discard block |
||
37 | 37 | } |
38 | 38 | public function can_migrate_from_version($version_array) { |
39 | 39 | $version_string = $version_array['Core']; |
40 | - if($version_string <= '4.3.0' && $version_string >= '4.2.0' ){ |
|
40 | + if ($version_string <= '4.3.0' && $version_string >= '4.2.0') { |
|
41 | 41 | // echo "$version_string can be migrated fro"; |
42 | 42 | return true; |
43 | - }elseif( ! $version_string ){ |
|
43 | + }elseif ( ! $version_string) { |
|
44 | 44 | // echo "no version string provided: $version_string"; |
45 | 45 | //no version string provided... this must be pre 4.2 |
46 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
47 | - }else{ |
|
46 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
47 | + } else { |
|
48 | 48 | // echo "$version_string doesnt apply"; |
49 | 49 | return false; |
50 | 50 | } |
@@ -54,14 +54,14 @@ discard block |
||
54 | 54 | } |
55 | 55 | public function schema_changes_before_migration() { |
56 | 56 | //relies on 4.1's EEH_Activation::create_table |
57 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
58 | - $table_name='esp_answer'; |
|
59 | - $sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
57 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
58 | + $table_name = 'esp_answer'; |
|
59 | + $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
60 | 60 | REG_ID INT UNSIGNED NOT NULL, |
61 | 61 | QST_ID INT UNSIGNED NOT NULL, |
62 | 62 | ANS_value TEXT NOT NULL, |
63 | 63 | PRIMARY KEY (ANS_ID)"; |
64 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
64 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
65 | 65 | |
66 | 66 | $table_name = 'esp_attendee_meta'; |
67 | 67 | $sql = "ATTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -100,7 +100,7 @@ discard block |
||
100 | 100 | CNT_is_EU TINYINT(1) DEFAULT '0', |
101 | 101 | CNT_active TINYINT(1) DEFAULT '0', |
102 | 102 | PRIMARY KEY (CNT_ISO)"; |
103 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
103 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
104 | 104 | |
105 | 105 | |
106 | 106 | |
@@ -123,7 +123,7 @@ discard block |
||
123 | 123 | |
124 | 124 | |
125 | 125 | |
126 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
126 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
127 | 127 | $table_name = 'esp_event_meta'; |
128 | 128 | $sql = " |
129 | 129 | EVTM_ID INT NOT NULL AUTO_INCREMENT, |
@@ -140,41 +140,41 @@ discard block |
||
140 | 140 | EVT_external_URL VARCHAR(200) NULL, |
141 | 141 | EVT_donations TINYINT(1) NULL, |
142 | 142 | PRIMARY KEY (EVTM_ID)"; |
143 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
143 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
144 | 144 | |
145 | 145 | |
146 | 146 | |
147 | - $table_name='esp_event_question_group'; |
|
148 | - $sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
147 | + $table_name = 'esp_event_question_group'; |
|
148 | + $sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
149 | 149 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
150 | 150 | QSG_ID INT UNSIGNED NOT NULL, |
151 | 151 | EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
152 | 152 | PRIMARY KEY (EQG_ID)"; |
153 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
153 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
154 | 154 | |
155 | 155 | |
156 | 156 | |
157 | - $table_name='esp_event_venue'; |
|
158 | - $sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
157 | + $table_name = 'esp_event_venue'; |
|
158 | + $sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
159 | 159 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
160 | 160 | VNU_ID BIGINT(20) UNSIGNED NOT NULL, |
161 | 161 | EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
162 | 162 | PRIMARY KEY (EVV_ID)"; |
163 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
163 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
164 | 164 | |
165 | 165 | |
166 | 166 | |
167 | - $table_name='esp_extra_meta'; |
|
168 | - $sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
167 | + $table_name = 'esp_extra_meta'; |
|
168 | + $sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
169 | 169 | OBJ_ID INT(11) DEFAULT NULL, |
170 | 170 | EXM_type VARCHAR(45) DEFAULT NULL, |
171 | 171 | EXM_key VARCHAR(45) DEFAULT NULL, |
172 | 172 | EXM_value TEXT, |
173 | 173 | PRIMARY KEY (EXM_ID)"; |
174 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
174 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
175 | 175 | |
176 | - $table_name='esp_line_item'; |
|
177 | - $sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
176 | + $table_name = 'esp_line_item'; |
|
177 | + $sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
178 | 178 | LIN_code VARCHAR(245) NOT NULL DEFAULT '', |
179 | 179 | TXN_ID INT(11) DEFAULT NULL, |
180 | 180 | LIN_name VARCHAR(245) NOT NULL DEFAULT '', |
@@ -190,7 +190,7 @@ discard block |
||
190 | 190 | OBJ_ID INT(11) DEFAULT NULL, |
191 | 191 | OBJ_type VARCHAR(45)DEFAULT NULL, |
192 | 192 | PRIMARY KEY (LIN_ID)"; |
193 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB' ); |
|
193 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
194 | 194 | |
195 | 195 | $table_name = 'esp_message_template'; |
196 | 196 | $sql = "MTP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -202,7 +202,7 @@ discard block |
||
202 | 202 | KEY GRP_ID (GRP_ID)"; |
203 | 203 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
204 | 204 | |
205 | - EEH_Activation::drop_index( 'esp_message_template_group', 'EVT_ID' ); |
|
205 | + EEH_Activation::drop_index('esp_message_template_group', 'EVT_ID'); |
|
206 | 206 | |
207 | 207 | $table_name = 'esp_message_template_group'; |
208 | 208 | $sql = "GRP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -217,7 +217,7 @@ discard block |
||
217 | 217 | MTP_is_active TINYINT(1) NOT NULL DEFAULT '1', |
218 | 218 | PRIMARY KEY (GRP_ID), |
219 | 219 | KEY MTP_user_id (MTP_user_id)"; |
220 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
220 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
221 | 221 | |
222 | 222 | $table_name = 'esp_event_message_template'; |
223 | 223 | $sql = "EMT_ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -226,7 +226,7 @@ discard block |
||
226 | 226 | PRIMARY KEY (EMT_ID), |
227 | 227 | KEY EVT_ID (EVT_ID), |
228 | 228 | KEY GRP_ID (GRP_ID)"; |
229 | - $this->_table_is_new_in_this_version( $table_name, $sql, 'ENGINE=InnoDB'); |
|
229 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
230 | 230 | |
231 | 231 | |
232 | 232 | |
@@ -335,8 +335,8 @@ discard block |
||
335 | 335 | |
336 | 336 | |
337 | 337 | |
338 | - $table_name='esp_question'; |
|
339 | - $sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
338 | + $table_name = 'esp_question'; |
|
339 | + $sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
340 | 340 | QST_display_text TEXT NOT NULL, |
341 | 341 | QST_admin_label VARCHAR(255) NOT NULL, |
342 | 342 | QST_system VARCHAR(25) DEFAULT NULL, |
@@ -348,12 +348,12 @@ discard block |
||
348 | 348 | QST_wp_user BIGINT UNSIGNED NULL, |
349 | 349 | QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0, |
350 | 350 | PRIMARY KEY (QST_ID)'; |
351 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
351 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
352 | 352 | |
353 | - EEH_Activation::drop_index( 'esp_question_group', 'QSG_identifier_UNIQUE' ); |
|
353 | + EEH_Activation::drop_index('esp_question_group', 'QSG_identifier_UNIQUE'); |
|
354 | 354 | |
355 | 355 | $table_name = 'esp_question_group'; |
356 | - $sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
356 | + $sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
357 | 357 | QSG_name VARCHAR(255) NOT NULL, |
358 | 358 | QSG_identifier VARCHAR(100) NOT NULL, |
359 | 359 | QSG_desc TEXT NULL, |
@@ -364,29 +364,29 @@ discard block |
||
364 | 364 | QSG_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
365 | 365 | PRIMARY KEY (QSG_ID), |
366 | 366 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)'; |
367 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
367 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
368 | 368 | |
369 | 369 | |
370 | 370 | |
371 | - $table_name='esp_question_group_question'; |
|
372 | - $sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
371 | + $table_name = 'esp_question_group_question'; |
|
372 | + $sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
373 | 373 | QSG_ID INT UNSIGNED NOT NULL, |
374 | 374 | QST_ID INT UNSIGNED NOT NULL, |
375 | 375 | QGQ_order INT UNSIGNED NOT NULL DEFAULT 0, |
376 | 376 | PRIMARY KEY (QGQ_ID) "; |
377 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
377 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
378 | 378 | |
379 | 379 | |
380 | 380 | |
381 | - $table_name='esp_question_option'; |
|
382 | - $sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
381 | + $table_name = 'esp_question_option'; |
|
382 | + $sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
383 | 383 | QSO_value VARCHAR(255) NOT NULL, |
384 | 384 | QSO_desc TEXT NOT NULL, |
385 | 385 | QST_ID INT UNSIGNED NOT NULL, |
386 | 386 | QSO_order INT UNSIGNED NOT NULL DEFAULT 0, |
387 | 387 | QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
388 | 388 | PRIMARY KEY (QSO_ID)"; |
389 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
389 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
390 | 390 | |
391 | 391 | |
392 | 392 | |
@@ -419,8 +419,8 @@ discard block |
||
419 | 419 | |
420 | 420 | |
421 | 421 | |
422 | - $table_name='esp_checkin'; |
|
423 | - $sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
422 | + $table_name = 'esp_checkin'; |
|
423 | + $sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
424 | 424 | REG_ID INT(10) UNSIGNED NOT NULL, |
425 | 425 | DTT_ID INT(10) UNSIGNED NOT NULL, |
426 | 426 | CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, |
@@ -494,7 +494,7 @@ discard block |
||
494 | 494 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
495 | 495 | |
496 | 496 | |
497 | - $script_with_defaults = EE_Registry::instance()->load_dms( 'Core_4_1_0' ); |
|
497 | + $script_with_defaults = EE_Registry::instance()->load_dms('Core_4_1_0'); |
|
498 | 498 | //setting up the DEFAULT stats and countries is also essential for the data migrations to run |
499 | 499 | //(because many need to convert old string states to foreign keys into the states table) |
500 | 500 | $script_with_defaults->insert_default_states(); |
@@ -516,7 +516,7 @@ discard block |
||
516 | 516 | return true; |
517 | 517 | } |
518 | 518 | |
519 | - public function migration_page_hooks(){ |
|
519 | + public function migration_page_hooks() { |
|
520 | 520 | |
521 | 521 | } |
522 | 522 | |
@@ -532,34 +532,34 @@ discard block |
||
532 | 532 | |
533 | 533 | global $wpdb; |
534 | 534 | $ticket_table = $wpdb->prefix."esp_ticket"; |
535 | - if ( $wpdb->get_var("SHOW TABLES LIKE'$ticket_table'") == $ticket_table ) { |
|
535 | + if ($wpdb->get_var("SHOW TABLES LIKE'$ticket_table'") == $ticket_table) { |
|
536 | 536 | |
537 | - $SQL = 'SELECT COUNT(TKT_ID) FROM ' . $ticket_table; |
|
537 | + $SQL = 'SELECT COUNT(TKT_ID) FROM '.$ticket_table; |
|
538 | 538 | $tickets_exist = $wpdb->get_var($SQL); |
539 | 539 | |
540 | - if ( ! $tickets_exist ) { |
|
540 | + if ( ! $tickets_exist) { |
|
541 | 541 | $SQL = "INSERT INTO $ticket_table |
542 | 542 | ( TKT_ID, TTM_ID, TKT_name, TKT_description, TKT_qty, TKT_sold, TKT_uses, TKT_required, TKT_min, TKT_max, TKT_price, TKT_start_date, TKT_end_date, TKT_taxable, TKT_order, TKT_row, TKT_is_default, TKT_parent, TKT_deleted ) VALUES |
543 | - ( 1, 0, '" . __("Free Ticket", "event_espresso") . "', '', 100, 0, -1, 0, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, 0);"; |
|
544 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL', $SQL ); |
|
543 | + ( 1, 0, '".__("Free Ticket", "event_espresso")."', '', 100, 0, -1, 0, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, 0);"; |
|
544 | + $SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL', $SQL); |
|
545 | 545 | $wpdb->query($SQL); |
546 | 546 | } |
547 | 547 | } |
548 | 548 | $ticket_price_table = $wpdb->prefix."esp_ticket_price"; |
549 | 549 | |
550 | - if ( $wpdb->get_var("SHOW TABLES LIKE'$ticket_price_table'") == $ticket_price_table ) { |
|
550 | + if ($wpdb->get_var("SHOW TABLES LIKE'$ticket_price_table'") == $ticket_price_table) { |
|
551 | 551 | |
552 | - $SQL = 'SELECT COUNT(TKP_ID) FROM ' . $ticket_price_table; |
|
552 | + $SQL = 'SELECT COUNT(TKP_ID) FROM '.$ticket_price_table; |
|
553 | 553 | $ticket_prc_exist = $wpdb->get_var($SQL); |
554 | 554 | |
555 | - if ( ! $ticket_prc_exist ) { |
|
555 | + if ( ! $ticket_prc_exist) { |
|
556 | 556 | |
557 | 557 | $SQL = "INSERT INTO $ticket_price_table |
558 | 558 | ( TKP_ID, TKT_ID, PRC_ID ) VALUES |
559 | 559 | ( 1, 1, 1 ) |
560 | 560 | "; |
561 | 561 | |
562 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL__ticket_price', $SQL ); |
|
562 | + $SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL__ticket_price', $SQL); |
|
563 | 563 | $wpdb->query($SQL); |
564 | 564 | } |
565 | 565 | } |
@@ -65,11 +65,11 @@ |
||
65 | 65 | if( $version_string <= '4.8.0' && $version_string >= '4.7.0' ){ |
66 | 66 | // echo "$version_string can be migrated from"; |
67 | 67 | return true; |
68 | - }elseif( ! $version_string ){ |
|
68 | + } elseif( ! $version_string ){ |
|
69 | 69 | // echo "no version string provided: $version_string"; |
70 | 70 | //no version string provided... this must be pre 4.3 |
71 | 71 | return false;//changed mind. dont want people thinking they should migrate yet because they cant |
72 | - }else{ |
|
72 | + } else{ |
|
73 | 73 | // echo "$version_string doesnt apply"; |
74 | 74 | return false; |
75 | 75 | } |
@@ -12,16 +12,16 @@ discard block |
||
12 | 12 | //(all other times it gets resurrected from a wordpress option) |
13 | 13 | $stages = glob(EE_CORE.'data_migration_scripts/4_5_0_stages/*'); |
14 | 14 | $class_to_filepath = array(); |
15 | -foreach($stages as $filepath){ |
|
15 | +foreach ($stages as $filepath) { |
|
16 | 16 | $matches = array(); |
17 | - preg_match('~4_5_0_stages/(.*).dmsstage.php~',$filepath,$matches); |
|
17 | + preg_match('~4_5_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
18 | 18 | $class_to_filepath[$matches[1]] = $filepath; |
19 | 19 | } |
20 | 20 | //give addons a chance to autoload their stages too |
21 | -$class_to_filepath = apply_filters('FHEE__EE_DMS_4_5_0__autoloaded_stages',$class_to_filepath); |
|
21 | +$class_to_filepath = apply_filters('FHEE__EE_DMS_4_5_0__autoloaded_stages', $class_to_filepath); |
|
22 | 22 | EEH_Autoloader::register_autoloader($class_to_filepath); |
23 | 23 | |
24 | -class EE_DMS_Core_4_5_0 extends EE_Data_Migration_Script_Base{ |
|
24 | +class EE_DMS_Core_4_5_0 extends EE_Data_Migration_Script_Base { |
|
25 | 25 | |
26 | 26 | |
27 | 27 | |
@@ -39,14 +39,14 @@ discard block |
||
39 | 39 | } |
40 | 40 | public function can_migrate_from_version($version_array) { |
41 | 41 | $version_string = $version_array['Core']; |
42 | - if($version_string <= '4.5.0' && $version_string >= '4.3.0' ){ |
|
42 | + if ($version_string <= '4.5.0' && $version_string >= '4.3.0') { |
|
43 | 43 | // echo "$version_string can be migrated from"; |
44 | 44 | return true; |
45 | - }elseif( ! $version_string ){ |
|
45 | + }elseif ( ! $version_string) { |
|
46 | 46 | // echo "no version string provided: $version_string"; |
47 | 47 | //no version string provided... this must be pre 4.3 |
48 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
49 | - }else{ |
|
48 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
49 | + } else { |
|
50 | 50 | // echo "$version_string doesnt apply"; |
51 | 51 | return false; |
52 | 52 | } |
@@ -56,14 +56,14 @@ discard block |
||
56 | 56 | } |
57 | 57 | public function schema_changes_before_migration() { |
58 | 58 | //relies on 4.1's EEH_Activation::create_table |
59 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
60 | - $table_name='esp_answer'; |
|
61 | - $sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
59 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
60 | + $table_name = 'esp_answer'; |
|
61 | + $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
62 | 62 | REG_ID INT UNSIGNED NOT NULL, |
63 | 63 | QST_ID INT UNSIGNED NOT NULL, |
64 | 64 | ANS_value TEXT NOT NULL, |
65 | 65 | PRIMARY KEY (ANS_ID)"; |
66 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
66 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
67 | 67 | |
68 | 68 | $table_name = 'esp_attendee_meta'; |
69 | 69 | $sql = "ATTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -102,7 +102,7 @@ discard block |
||
102 | 102 | CNT_is_EU TINYINT(1) DEFAULT '0', |
103 | 103 | CNT_active TINYINT(1) DEFAULT '0', |
104 | 104 | PRIMARY KEY (CNT_ISO)"; |
105 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
105 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
106 | 106 | |
107 | 107 | $table_name = 'esp_datetime'; |
108 | 108 | $sql = "DTT_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -123,7 +123,7 @@ discard block |
||
123 | 123 | |
124 | 124 | |
125 | 125 | |
126 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
126 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
127 | 127 | $table_name = 'esp_event_meta'; |
128 | 128 | $sql = " |
129 | 129 | EVTM_ID INT NOT NULL AUTO_INCREMENT, |
@@ -140,41 +140,41 @@ discard block |
||
140 | 140 | EVT_external_URL VARCHAR(200) NULL, |
141 | 141 | EVT_donations TINYINT(1) NULL, |
142 | 142 | PRIMARY KEY (EVTM_ID)"; |
143 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
143 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
144 | 144 | |
145 | 145 | |
146 | 146 | |
147 | - $table_name='esp_event_question_group'; |
|
148 | - $sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
147 | + $table_name = 'esp_event_question_group'; |
|
148 | + $sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
149 | 149 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
150 | 150 | QSG_ID INT UNSIGNED NOT NULL, |
151 | 151 | EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
152 | 152 | PRIMARY KEY (EQG_ID)"; |
153 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
153 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
154 | 154 | |
155 | 155 | |
156 | 156 | |
157 | - $table_name='esp_event_venue'; |
|
158 | - $sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
157 | + $table_name = 'esp_event_venue'; |
|
158 | + $sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
159 | 159 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
160 | 160 | VNU_ID BIGINT(20) UNSIGNED NOT NULL, |
161 | 161 | EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
162 | 162 | PRIMARY KEY (EVV_ID)"; |
163 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
163 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
164 | 164 | |
165 | 165 | |
166 | 166 | |
167 | - $table_name='esp_extra_meta'; |
|
168 | - $sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
167 | + $table_name = 'esp_extra_meta'; |
|
168 | + $sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
169 | 169 | OBJ_ID INT(11) DEFAULT NULL, |
170 | 170 | EXM_type VARCHAR(45) DEFAULT NULL, |
171 | 171 | EXM_key VARCHAR(45) DEFAULT NULL, |
172 | 172 | EXM_value TEXT, |
173 | 173 | PRIMARY KEY (EXM_ID)"; |
174 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
174 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
175 | 175 | |
176 | - $table_name='esp_line_item'; |
|
177 | - $sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
176 | + $table_name = 'esp_line_item'; |
|
177 | + $sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
178 | 178 | LIN_code VARCHAR(245) NOT NULL DEFAULT '', |
179 | 179 | TXN_ID INT(11) DEFAULT NULL, |
180 | 180 | LIN_name VARCHAR(245) NOT NULL DEFAULT '', |
@@ -190,7 +190,7 @@ discard block |
||
190 | 190 | OBJ_ID INT(11) DEFAULT NULL, |
191 | 191 | OBJ_type VARCHAR(45)DEFAULT NULL, |
192 | 192 | PRIMARY KEY (LIN_ID)"; |
193 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB' ); |
|
193 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
194 | 194 | |
195 | 195 | $table_name = 'esp_message_template'; |
196 | 196 | $sql = "MTP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -202,7 +202,7 @@ discard block |
||
202 | 202 | KEY GRP_ID (GRP_ID)"; |
203 | 203 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
204 | 204 | |
205 | - EEH_Activation::drop_index( 'esp_message_template_group', 'EVT_ID' ); |
|
205 | + EEH_Activation::drop_index('esp_message_template_group', 'EVT_ID'); |
|
206 | 206 | |
207 | 207 | $table_name = 'esp_message_template_group'; |
208 | 208 | $sql = "GRP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -217,7 +217,7 @@ discard block |
||
217 | 217 | MTP_is_active TINYINT(1) NOT NULL DEFAULT '1', |
218 | 218 | PRIMARY KEY (GRP_ID), |
219 | 219 | KEY MTP_user_id (MTP_user_id)"; |
220 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
220 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
221 | 221 | |
222 | 222 | $table_name = 'esp_event_message_template'; |
223 | 223 | $sql = "EMT_ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -226,7 +226,7 @@ discard block |
||
226 | 226 | PRIMARY KEY (EMT_ID), |
227 | 227 | KEY EVT_ID (EVT_ID), |
228 | 228 | KEY GRP_ID (GRP_ID)"; |
229 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
229 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
230 | 230 | |
231 | 231 | |
232 | 232 | $table_name = 'esp_payment'; |
@@ -276,8 +276,8 @@ discard block |
||
276 | 276 | PRIMARY KEY (TTM_ID)"; |
277 | 277 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
278 | 278 | |
279 | - $table_name='esp_question'; |
|
280 | - $sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
279 | + $table_name = 'esp_question'; |
|
280 | + $sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
281 | 281 | QST_display_text TEXT NOT NULL, |
282 | 282 | QST_admin_label VARCHAR(255) NOT NULL, |
283 | 283 | QST_system VARCHAR(25) DEFAULT NULL, |
@@ -289,27 +289,27 @@ discard block |
||
289 | 289 | QST_wp_user BIGINT UNSIGNED NULL, |
290 | 290 | QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0, |
291 | 291 | PRIMARY KEY (QST_ID)'; |
292 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
292 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
293 | 293 | |
294 | - $table_name='esp_question_group_question'; |
|
295 | - $sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
294 | + $table_name = 'esp_question_group_question'; |
|
295 | + $sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
296 | 296 | QSG_ID INT UNSIGNED NOT NULL, |
297 | 297 | QST_ID INT UNSIGNED NOT NULL, |
298 | 298 | QGQ_order INT UNSIGNED NOT NULL DEFAULT 0, |
299 | 299 | PRIMARY KEY (QGQ_ID) "; |
300 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
300 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
301 | 301 | |
302 | 302 | |
303 | 303 | |
304 | - $table_name='esp_question_option'; |
|
305 | - $sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
304 | + $table_name = 'esp_question_option'; |
|
305 | + $sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
306 | 306 | QSO_value VARCHAR(255) NOT NULL, |
307 | 307 | QSO_desc TEXT NOT NULL, |
308 | 308 | QST_ID INT UNSIGNED NOT NULL, |
309 | 309 | QSO_order INT UNSIGNED NOT NULL DEFAULT 0, |
310 | 310 | QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
311 | 311 | PRIMARY KEY (QSO_ID)"; |
312 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
312 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
313 | 313 | |
314 | 314 | |
315 | 315 | |
@@ -342,8 +342,8 @@ discard block |
||
342 | 342 | |
343 | 343 | |
344 | 344 | |
345 | - $table_name='esp_checkin'; |
|
346 | - $sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
345 | + $table_name = 'esp_checkin'; |
|
346 | + $sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
347 | 347 | REG_ID INT(10) UNSIGNED NOT NULL, |
348 | 348 | DTT_ID INT(10) UNSIGNED NOT NULL, |
349 | 349 | CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, |
@@ -431,7 +431,7 @@ discard block |
||
431 | 431 | PRC_wp_user BIGINT UNSIGNED NULL, |
432 | 432 | PRC_parent INT(10) UNSIGNED DEFAULT 0, |
433 | 433 | PRIMARY KEY (PRC_ID)"; |
434 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
434 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
435 | 435 | |
436 | 436 | $table_name = "esp_price_type"; |
437 | 437 | $sql = "PRT_ID TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -468,12 +468,12 @@ discard block |
||
468 | 468 | TKT_parent INT(10) UNSIGNED DEFAULT '0', |
469 | 469 | TKT_deleted TINYINT(1) NOT NULL DEFAULT '0', |
470 | 470 | PRIMARY KEY (TKT_ID)"; |
471 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
471 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
472 | 472 | |
473 | - EEH_Activation::drop_index( 'esp_question_group', 'QSG_identifier_UNIQUE' ); |
|
473 | + EEH_Activation::drop_index('esp_question_group', 'QSG_identifier_UNIQUE'); |
|
474 | 474 | |
475 | 475 | $table_name = 'esp_question_group'; |
476 | - $sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
476 | + $sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
477 | 477 | QSG_name VARCHAR(255) NOT NULL, |
478 | 478 | QSG_identifier VARCHAR(100) NOT NULL, |
479 | 479 | QSG_desc TEXT NULL, |
@@ -485,7 +485,7 @@ discard block |
||
485 | 485 | QSG_wp_user BIGINT UNSIGNED NULL, |
486 | 486 | PRIMARY KEY (QSG_ID), |
487 | 487 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)'; |
488 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
488 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
489 | 489 | |
490 | 490 | $script_4_1_defaults = EE_Registry::instance()->load_dms('Core_4_1_0'); |
491 | 491 | |
@@ -509,7 +509,7 @@ discard block |
||
509 | 509 | return true; |
510 | 510 | } |
511 | 511 | |
512 | - public function migration_page_hooks(){ |
|
512 | + public function migration_page_hooks() { |
|
513 | 513 | |
514 | 514 | } |
515 | 515 | |
@@ -525,19 +525,19 @@ discard block |
||
525 | 525 | |
526 | 526 | if ($wpdb->get_var("SHOW TABLES LIKE '$price_type_table'") == $price_type_table) { |
527 | 527 | |
528 | - $SQL = 'SELECT COUNT(PRT_ID) FROM ' . $price_type_table; |
|
529 | - $price_types_exist = $wpdb->get_var( $SQL ); |
|
528 | + $SQL = 'SELECT COUNT(PRT_ID) FROM '.$price_type_table; |
|
529 | + $price_types_exist = $wpdb->get_var($SQL); |
|
530 | 530 | |
531 | - if ( ! $price_types_exist ) { |
|
531 | + if ( ! $price_types_exist) { |
|
532 | 532 | $user_id = EEH_Activation::get_default_creator_id(); |
533 | 533 | $SQL = "INSERT INTO $price_type_table ( PRT_ID, PRT_name, PBT_ID, PRT_is_percent, PRT_order, PRT_wp_user, PRT_deleted ) VALUES |
534 | - (1, '" . __('Base Price', 'event_espresso') . "', 1, 0, 0, $user_id, 0), |
|
535 | - (2, '" . __('Percent Discount', 'event_espresso') . "', 2, 1, 20, $user_id, 0), |
|
536 | - (3, '" . __('Dollar Discount', 'event_espresso') . "', 2, 0, 30, $user_id, 0), |
|
537 | - (4, '" . __('Percent Surcharge', 'event_espresso') . "', 3, 1, 40, $user_id, 0), |
|
538 | - (5, '" . __('Dollar Surcharge', 'event_espresso') . "', 3, 0, 50, $user_id, 0);"; |
|
539 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_price_types__SQL', $SQL ); |
|
540 | - $wpdb->query( $SQL ); |
|
534 | + (1, '".__('Base Price', 'event_espresso')."', 1, 0, 0, $user_id, 0), |
|
535 | + (2, '".__('Percent Discount', 'event_espresso')."', 2, 1, 20, $user_id, 0), |
|
536 | + (3, '".__('Dollar Discount', 'event_espresso')."', 2, 0, 30, $user_id, 0), |
|
537 | + (4, '".__('Percent Surcharge', 'event_espresso')."', 3, 1, 40, $user_id, 0), |
|
538 | + (5, '".__('Dollar Surcharge', 'event_espresso')."', 3, 0, 50, $user_id, 0);"; |
|
539 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_price_types__SQL', $SQL); |
|
540 | + $wpdb->query($SQL); |
|
541 | 541 | } |
542 | 542 | } |
543 | 543 | } |
@@ -559,15 +559,15 @@ discard block |
||
559 | 559 | |
560 | 560 | if ($wpdb->get_var("SHOW TABLES LIKE '$price_table'") == $price_table) { |
561 | 561 | |
562 | - $SQL = 'SELECT COUNT(PRC_ID) FROM ' .$price_table; |
|
563 | - $prices_exist = $wpdb->get_var( $SQL ); |
|
562 | + $SQL = 'SELECT COUNT(PRC_ID) FROM '.$price_table; |
|
563 | + $prices_exist = $wpdb->get_var($SQL); |
|
564 | 564 | |
565 | - if ( ! $prices_exist ) { |
|
565 | + if ( ! $prices_exist) { |
|
566 | 566 | $user_id = EEH_Activation::get_default_creator_id(); |
567 | 567 | $SQL = "INSERT INTO $price_table |
568 | 568 | (PRC_ID, PRT_ID, PRC_amount, PRC_name, PRC_desc, PRC_is_default, PRC_overrides, PRC_wp_user, PRC_order, PRC_deleted, PRC_parent ) VALUES |
569 | 569 | (1, 1, '0.00', 'Free Admission', '', 1, NULL, $user_id, 0, 0, 0);"; |
570 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_prices__SQL', $SQL ); |
|
570 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_prices__SQL', $SQL); |
|
571 | 571 | $wpdb->query($SQL); |
572 | 572 | } |
573 | 573 | } |
@@ -585,35 +585,35 @@ discard block |
||
585 | 585 | |
586 | 586 | global $wpdb; |
587 | 587 | $ticket_table = $wpdb->prefix."esp_ticket"; |
588 | - if ( $wpdb->get_var("SHOW TABLES LIKE'$ticket_table'") == $ticket_table ) { |
|
588 | + if ($wpdb->get_var("SHOW TABLES LIKE'$ticket_table'") == $ticket_table) { |
|
589 | 589 | |
590 | - $SQL = 'SELECT COUNT(TKT_ID) FROM ' . $ticket_table; |
|
590 | + $SQL = 'SELECT COUNT(TKT_ID) FROM '.$ticket_table; |
|
591 | 591 | $tickets_exist = $wpdb->get_var($SQL); |
592 | 592 | |
593 | - if ( ! $tickets_exist ) { |
|
593 | + if ( ! $tickets_exist) { |
|
594 | 594 | $user_id = EEH_Activation::get_default_creator_id(); |
595 | 595 | $SQL = "INSERT INTO $ticket_table |
596 | 596 | ( TKT_ID, TTM_ID, TKT_name, TKT_description, TKT_qty, TKT_sold, TKT_uses, TKT_required, TKT_min, TKT_max, TKT_price, TKT_start_date, TKT_end_date, TKT_taxable, TKT_order, TKT_row, TKT_is_default, TKT_parent, TKT_wp_user, TKT_deleted ) VALUES |
597 | - ( 1, 0, '" . __("Free Ticket", "event_espresso") . "', '', 100, 0, -1, 0, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, $user_id, 0);"; |
|
598 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL', $SQL ); |
|
597 | + ( 1, 0, '".__("Free Ticket", "event_espresso")."', '', 100, 0, -1, 0, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, $user_id, 0);"; |
|
598 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL', $SQL); |
|
599 | 599 | $wpdb->query($SQL); |
600 | 600 | } |
601 | 601 | } |
602 | 602 | $ticket_price_table = $wpdb->prefix."esp_ticket_price"; |
603 | 603 | |
604 | - if ( $wpdb->get_var("SHOW TABLES LIKE'$ticket_price_table'") == $ticket_price_table ) { |
|
604 | + if ($wpdb->get_var("SHOW TABLES LIKE'$ticket_price_table'") == $ticket_price_table) { |
|
605 | 605 | |
606 | - $SQL = 'SELECT COUNT(TKP_ID) FROM ' . $ticket_price_table; |
|
606 | + $SQL = 'SELECT COUNT(TKP_ID) FROM '.$ticket_price_table; |
|
607 | 607 | $ticket_prc_exist = $wpdb->get_var($SQL); |
608 | 608 | |
609 | - if ( ! $ticket_prc_exist ) { |
|
609 | + if ( ! $ticket_prc_exist) { |
|
610 | 610 | |
611 | 611 | $SQL = "INSERT INTO $ticket_price_table |
612 | 612 | ( TKP_ID, TKT_ID, PRC_ID ) VALUES |
613 | 613 | ( 1, 1, 1 ) |
614 | 614 | "; |
615 | 615 | |
616 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL__ticket_price', $SQL ); |
|
616 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL__ticket_price', $SQL); |
|
617 | 617 | $wpdb->query($SQL); |
618 | 618 | } |
619 | 619 | } |
@@ -65,11 +65,11 @@ |
||
65 | 65 | if( $version_string <= '4.8.0' && $version_string >= '4.7.0' ){ |
66 | 66 | // echo "$version_string can be migrated from"; |
67 | 67 | return true; |
68 | - }elseif( ! $version_string ){ |
|
68 | + } elseif( ! $version_string ){ |
|
69 | 69 | // echo "no version string provided: $version_string"; |
70 | 70 | //no version string provided... this must be pre 4.3 |
71 | 71 | return false;//changed mind. dont want people thinking they should migrate yet because they cant |
72 | - }else{ |
|
72 | + } else{ |
|
73 | 73 | // echo "$version_string doesnt apply"; |
74 | 74 | return false; |
75 | 75 | } |
@@ -65,11 +65,11 @@ |
||
65 | 65 | if( $version_string <= '4.8.0' && $version_string >= '4.7.0' ){ |
66 | 66 | // echo "$version_string can be migrated from"; |
67 | 67 | return true; |
68 | - }elseif( ! $version_string ){ |
|
68 | + } elseif( ! $version_string ){ |
|
69 | 69 | // echo "no version string provided: $version_string"; |
70 | 70 | //no version string provided... this must be pre 4.3 |
71 | 71 | return false;//changed mind. dont want people thinking they should migrate yet because they cant |
72 | - }else{ |
|
72 | + } else{ |
|
73 | 73 | // echo "$version_string doesnt apply"; |
74 | 74 | return false; |
75 | 75 | } |
@@ -715,7 +715,7 @@ |
||
715 | 715 | } |
716 | 716 | } |
717 | 717 | } |
718 | - } |
|
718 | + } |
|
719 | 719 | /** |
720 | 720 | * addresses https://events.codebasehq.com/projects/event-espresso/tickets/8731 |
721 | 721 | * which should just be a temporary issue for folks who installed 4.8.0-4.8.5; |
@@ -13,13 +13,13 @@ discard block |
||
13 | 13 | //(all other times it gets resurrected from a wordpress option) |
14 | 14 | $stages = glob(EE_CORE.'data_migration_scripts/4_8_0_stages/*'); |
15 | 15 | $class_to_filepath = array(); |
16 | -foreach($stages as $filepath){ |
|
16 | +foreach ($stages as $filepath) { |
|
17 | 17 | $matches = array(); |
18 | - preg_match('~4_8_0_stages/(.*).dmsstage.php~',$filepath,$matches); |
|
18 | + preg_match('~4_8_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
19 | 19 | $class_to_filepath[$matches[1]] = $filepath; |
20 | 20 | } |
21 | 21 | //give addons a chance to autoload their stages too |
22 | -$class_to_filepath = apply_filters('FHEE__EE_DMS_4_8_0__autoloaded_stages',$class_to_filepath); |
|
22 | +$class_to_filepath = apply_filters('FHEE__EE_DMS_4_8_0__autoloaded_stages', $class_to_filepath); |
|
23 | 23 | EEH_Autoloader::register_autoloader($class_to_filepath); |
24 | 24 | |
25 | 25 | |
@@ -35,7 +35,7 @@ discard block |
||
35 | 35 | * @since 4.6.0 |
36 | 36 | * |
37 | 37 | */ |
38 | -class EE_DMS_Core_4_8_0 extends EE_Data_Migration_Script_Base{ |
|
38 | +class EE_DMS_Core_4_8_0 extends EE_Data_Migration_Script_Base { |
|
39 | 39 | |
40 | 40 | /** |
41 | 41 | * return EE_DMS_Core_4_8_0 |
@@ -62,14 +62,14 @@ discard block |
||
62 | 62 | */ |
63 | 63 | public function can_migrate_from_version($version_array) { |
64 | 64 | $version_string = $version_array['Core']; |
65 | - if( $version_string <= '4.8.0' && $version_string >= '4.7.0' ){ |
|
65 | + if ($version_string <= '4.8.0' && $version_string >= '4.7.0') { |
|
66 | 66 | // echo "$version_string can be migrated from"; |
67 | 67 | return true; |
68 | - }elseif( ! $version_string ){ |
|
68 | + }elseif ( ! $version_string) { |
|
69 | 69 | // echo "no version string provided: $version_string"; |
70 | 70 | //no version string provided... this must be pre 4.3 |
71 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
72 | - }else{ |
|
71 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
72 | + } else { |
|
73 | 73 | // echo "$version_string doesnt apply"; |
74 | 74 | return false; |
75 | 75 | } |
@@ -90,18 +90,18 @@ discard block |
||
90 | 90 | * @return bool |
91 | 91 | */ |
92 | 92 | public function schema_changes_before_migration() { |
93 | - $now_in_mysql = current_time( 'mysql', true ); |
|
93 | + $now_in_mysql = current_time('mysql', true); |
|
94 | 94 | |
95 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
96 | - $table_name='esp_answer'; |
|
97 | - $sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
95 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
96 | + $table_name = 'esp_answer'; |
|
97 | + $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
98 | 98 | REG_ID INT UNSIGNED NOT NULL, |
99 | 99 | QST_ID INT UNSIGNED NOT NULL, |
100 | 100 | ANS_value TEXT NOT NULL, |
101 | 101 | PRIMARY KEY (ANS_ID), |
102 | 102 | KEY REG_ID (REG_ID), |
103 | 103 | KEY QST_ID (QST_ID)"; |
104 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
104 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
105 | 105 | |
106 | 106 | $table_name = 'esp_attendee_meta'; |
107 | 107 | $sql = "ATTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -141,7 +141,7 @@ discard block |
||
141 | 141 | CNT_is_EU TINYINT(1) DEFAULT '0', |
142 | 142 | CNT_active TINYINT(1) DEFAULT '0', |
143 | 143 | PRIMARY KEY (CNT_ISO)"; |
144 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB' ); |
|
144 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
145 | 145 | |
146 | 146 | $table_name = 'esp_currency'; |
147 | 147 | $sql = "CUR_code VARCHAR(6) COLLATE utf8_bin NOT NULL, |
@@ -151,7 +151,7 @@ discard block |
||
151 | 151 | CUR_dec_plc VARCHAR(1) COLLATE utf8_bin NOT NULL DEFAULT '2', |
152 | 152 | CUR_active TINYINT(1) DEFAULT '0', |
153 | 153 | PRIMARY KEY (CUR_code)"; |
154 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB' ); |
|
154 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
155 | 155 | |
156 | 156 | |
157 | 157 | $table_name = 'esp_currency_payment_method'; |
@@ -181,7 +181,7 @@ discard block |
||
181 | 181 | KEY EVT_ID (EVT_ID), |
182 | 182 | KEY DTT_is_primary (DTT_is_primary)"; |
183 | 183 | |
184 | - $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
184 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
185 | 185 | |
186 | 186 | $table_name = 'esp_event_meta'; |
187 | 187 | $sql = " |
@@ -200,44 +200,44 @@ discard block |
||
200 | 200 | EVT_donations TINYINT(1) NULL, |
201 | 201 | PRIMARY KEY (EVTM_ID), |
202 | 202 | KEY EVT_ID (EVT_ID)"; |
203 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
203 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
204 | 204 | |
205 | 205 | |
206 | 206 | |
207 | - $table_name='esp_event_question_group'; |
|
208 | - $sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
207 | + $table_name = 'esp_event_question_group'; |
|
208 | + $sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
209 | 209 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
210 | 210 | QSG_ID INT UNSIGNED NOT NULL, |
211 | 211 | EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
212 | 212 | PRIMARY KEY (EQG_ID), |
213 | 213 | KEY EVT_ID (EVT_ID), |
214 | 214 | KEY QSG_ID (QSG_ID)"; |
215 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
215 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
216 | 216 | |
217 | 217 | |
218 | 218 | |
219 | - $table_name='esp_event_venue'; |
|
220 | - $sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
219 | + $table_name = 'esp_event_venue'; |
|
220 | + $sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
221 | 221 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
222 | 222 | VNU_ID BIGINT(20) UNSIGNED NOT NULL, |
223 | 223 | EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
224 | 224 | PRIMARY KEY (EVV_ID)"; |
225 | - $this->_table_has_not_changed_since_previous($table_name,$sql, 'ENGINE=InnoDB'); |
|
225 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
226 | 226 | |
227 | 227 | |
228 | 228 | |
229 | - $table_name='esp_extra_meta'; |
|
230 | - $sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
229 | + $table_name = 'esp_extra_meta'; |
|
230 | + $sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
231 | 231 | OBJ_ID INT(11) DEFAULT NULL, |
232 | 232 | EXM_type VARCHAR(45) DEFAULT NULL, |
233 | 233 | EXM_key VARCHAR(45) DEFAULT NULL, |
234 | 234 | EXM_value TEXT, |
235 | 235 | PRIMARY KEY (EXM_ID), |
236 | 236 | KEY EXM_type (EXM_type, OBJ_ID, EXM_key(45))"; |
237 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
237 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
238 | 238 | |
239 | - $table_name='esp_line_item'; |
|
240 | - $sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
239 | + $table_name = 'esp_line_item'; |
|
240 | + $sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
241 | 241 | LIN_code VARCHAR(245) NOT NULL DEFAULT '', |
242 | 242 | TXN_ID INT(11) DEFAULT NULL, |
243 | 243 | LIN_name VARCHAR(245) NOT NULL DEFAULT '', |
@@ -256,7 +256,7 @@ discard block |
||
256 | 256 | PRIMARY KEY (LIN_ID), |
257 | 257 | KEY LIN_code (LIN_code(191)), |
258 | 258 | KEY TXN_ID (TXN_ID)"; |
259 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB' ); |
|
259 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
260 | 260 | |
261 | 261 | $table_name = 'esp_log'; |
262 | 262 | $sql = "LOG_ID INT(11) NOT NULL AUTO_INCREMENT, |
@@ -295,7 +295,7 @@ discard block |
||
295 | 295 | MTP_is_active TINYINT(1) NOT NULL DEFAULT '1', |
296 | 296 | PRIMARY KEY (GRP_ID), |
297 | 297 | KEY MTP_user_id (MTP_user_id)"; |
298 | - $this->_table_has_not_changed_since_previous( $table_name, $sql, 'ENGINE=InnoDB'); |
|
298 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
299 | 299 | |
300 | 300 | $table_name = 'esp_event_message_template'; |
301 | 301 | $sql = "EMT_ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -304,7 +304,7 @@ discard block |
||
304 | 304 | PRIMARY KEY (EMT_ID), |
305 | 305 | KEY EVT_ID (EVT_ID), |
306 | 306 | KEY GRP_ID (GRP_ID)"; |
307 | - $this->_table_has_not_changed_since_previous( $table_name, $sql, 'ENGINE=InnoDB'); |
|
307 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
308 | 308 | |
309 | 309 | |
310 | 310 | $table_name = 'esp_payment'; |
@@ -377,8 +377,8 @@ discard block |
||
377 | 377 | PRIMARY KEY (TTM_ID)"; |
378 | 378 | $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
379 | 379 | |
380 | - $table_name='esp_question'; |
|
381 | - $sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
380 | + $table_name = 'esp_question'; |
|
381 | + $sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
382 | 382 | QST_display_text TEXT NOT NULL, |
383 | 383 | QST_admin_label VARCHAR(255) NOT NULL, |
384 | 384 | QST_system VARCHAR(25) DEFAULT NULL, |
@@ -391,22 +391,22 @@ discard block |
||
391 | 391 | QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0, |
392 | 392 | PRIMARY KEY (QST_ID), |
393 | 393 | KEY QST_order (QST_order)'; |
394 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
394 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
395 | 395 | |
396 | - $table_name='esp_question_group_question'; |
|
397 | - $sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
396 | + $table_name = 'esp_question_group_question'; |
|
397 | + $sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
398 | 398 | QSG_ID INT UNSIGNED NOT NULL, |
399 | 399 | QST_ID INT UNSIGNED NOT NULL, |
400 | 400 | QGQ_order INT UNSIGNED NOT NULL DEFAULT 0, |
401 | 401 | PRIMARY KEY (QGQ_ID), |
402 | 402 | KEY QST_ID (QST_ID), |
403 | 403 | KEY QSG_ID_order (QSG_ID, QGQ_order)"; |
404 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
404 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
405 | 405 | |
406 | 406 | |
407 | 407 | |
408 | - $table_name='esp_question_option'; |
|
409 | - $sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
408 | + $table_name = 'esp_question_option'; |
|
409 | + $sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
410 | 410 | QSO_value VARCHAR(255) NOT NULL, |
411 | 411 | QSO_desc TEXT NOT NULL, |
412 | 412 | QST_ID INT UNSIGNED NOT NULL, |
@@ -416,7 +416,7 @@ discard block |
||
416 | 416 | PRIMARY KEY (QSO_ID), |
417 | 417 | KEY QST_ID (QST_ID), |
418 | 418 | KEY QSO_order (QSO_order)"; |
419 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
419 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
420 | 420 | |
421 | 421 | |
422 | 422 | |
@@ -462,8 +462,8 @@ discard block |
||
462 | 462 | |
463 | 463 | |
464 | 464 | |
465 | - $table_name='esp_checkin'; |
|
466 | - $sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
465 | + $table_name = 'esp_checkin'; |
|
466 | + $sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
467 | 467 | REG_ID INT(10) UNSIGNED NOT NULL, |
468 | 468 | DTT_ID INT(10) UNSIGNED NOT NULL, |
469 | 469 | CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, |
@@ -558,7 +558,7 @@ discard block |
||
558 | 558 | PRC_parent INT(10) UNSIGNED DEFAULT 0, |
559 | 559 | PRIMARY KEY (PRC_ID), |
560 | 560 | KEY PRT_ID (PRT_ID)"; |
561 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
561 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
562 | 562 | |
563 | 563 | $table_name = "esp_price_type"; |
564 | 564 | $sql = "PRT_ID TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -596,10 +596,10 @@ discard block |
||
596 | 596 | TKT_deleted TINYINT(1) NOT NULL DEFAULT '0', |
597 | 597 | PRIMARY KEY (TKT_ID), |
598 | 598 | KEY TKT_start_date (TKT_start_date)"; |
599 | - $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
599 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
600 | 600 | |
601 | 601 | $table_name = 'esp_question_group'; |
602 | - $sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
602 | + $sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
603 | 603 | QSG_name VARCHAR(255) NOT NULL, |
604 | 604 | QSG_identifier VARCHAR(100) NOT NULL, |
605 | 605 | QSG_desc TEXT NULL, |
@@ -612,7 +612,7 @@ discard block |
||
612 | 612 | PRIMARY KEY (QSG_ID), |
613 | 613 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC), |
614 | 614 | KEY QSG_order (QSG_order)'; |
615 | - $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
615 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
616 | 616 | |
617 | 617 | /** @var EE_DMS_Core_4_1_0 $script_4_1_defaults */ |
618 | 618 | $script_4_1_defaults = EE_Registry::instance()->load_dms('Core_4_1_0'); |
@@ -648,7 +648,7 @@ discard block |
||
648 | 648 | return $script_4_7_defaults->schema_changes_after_migration(); |
649 | 649 | } |
650 | 650 | |
651 | - public function migration_page_hooks(){ |
|
651 | + public function migration_page_hooks() { |
|
652 | 652 | |
653 | 653 | } |
654 | 654 | |
@@ -662,19 +662,19 @@ discard block |
||
662 | 662 | //CNT_ISO, CNT_ISO3, RGN_ID, CNT_name, CNT_cur_code, CNT_cur_single, CNT_cur_plural, CNT_cur_sign, CNT_cur_sign_b4, CNT_cur_dec_plc, CNT_tel_code, CNT_is_EU, CNT_active |
663 | 663 | //('AD', 'AND', 0, 'Andorra', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+376', 0, 0), |
664 | 664 | $newer_countries = array( |
665 | - array( 'AX', 'ALA', 0, 'Alan Islands', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+358', 1, 0 ), |
|
666 | - array( 'BL', 'BLM', 0, 'Saint Barthelemy', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0 ), |
|
667 | - array( 'CW', 'CUW', 0, 'Curacao', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+599', 1, 0 ), |
|
668 | - array( 'GG', 'GGY', 0, 'Guernsey', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+44', 0, 0 ), |
|
669 | - array( 'IM', 'IMN', 0, 'Isle of Man', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0 ), |
|
670 | - array( 'JE', 'JEY', 0, 'Jersey', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0 ), |
|
671 | - array( 'MF', 'MAF', 0, 'Saint Martin', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0 ), |
|
672 | - array( 'MN', 'MNE', 0, 'Montenegro', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+382', 0, 0 ), |
|
673 | - array( 'RS', 'SRB', 0, 'Serbia', 'RSD', 'Dinar', 'Dinars', '', 0, 2, '+941', 1, 0 ), |
|
674 | - array( 'SS', 'SSD', 0, 'South Sudan', 'SSP', 'Pound', 'Pounds', '£', 1, 2, '+211', 0, 0 ), |
|
675 | - array( 'SX', 'SXM', 0, 'Sint Maarten', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+1', 1, 0 ), |
|
676 | - array( 'XK', 'XKX', 0, 'Kosovo', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+381', 0, 0 ), |
|
677 | - array( 'YT', 'MYT', 0, 'Mayotte', 'EUR', 'Euro', 'Euros', '€', 0, 2, '+262', 1, 0 ), |
|
665 | + array('AX', 'ALA', 0, 'Alan Islands', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+358', 1, 0), |
|
666 | + array('BL', 'BLM', 0, 'Saint Barthelemy', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0), |
|
667 | + array('CW', 'CUW', 0, 'Curacao', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+599', 1, 0), |
|
668 | + array('GG', 'GGY', 0, 'Guernsey', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+44', 0, 0), |
|
669 | + array('IM', 'IMN', 0, 'Isle of Man', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0), |
|
670 | + array('JE', 'JEY', 0, 'Jersey', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0), |
|
671 | + array('MF', 'MAF', 0, 'Saint Martin', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0), |
|
672 | + array('MN', 'MNE', 0, 'Montenegro', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+382', 0, 0), |
|
673 | + array('RS', 'SRB', 0, 'Serbia', 'RSD', 'Dinar', 'Dinars', '', 0, 2, '+941', 1, 0), |
|
674 | + array('SS', 'SSD', 0, 'South Sudan', 'SSP', 'Pound', 'Pounds', '£', 1, 2, '+211', 0, 0), |
|
675 | + array('SX', 'SXM', 0, 'Sint Maarten', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+1', 1, 0), |
|
676 | + array('XK', 'XKX', 0, 'Kosovo', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+381', 0, 0), |
|
677 | + array('YT', 'MYT', 0, 'Mayotte', 'EUR', 'Euro', 'Euros', '€', 0, 2, '+262', 1, 0), |
|
678 | 678 | ); |
679 | 679 | global $wpdb; |
680 | 680 | $country_table = $wpdb->prefix."esp_country"; |
@@ -693,14 +693,14 @@ discard block |
||
693 | 693 | "CNT_is_EU" => '%d', |
694 | 694 | "CNT_active" => '%d', |
695 | 695 | ); |
696 | - if ( $wpdb->get_var( "SHOW TABLES LIKE '" . $country_table . "'") == $country_table ) { |
|
697 | - foreach( $newer_countries as $country ) { |
|
698 | - $SQL = "SELECT COUNT('CNT_ISO') FROM {$country_table} WHERE CNT_ISO='{$country[0]}' LIMIT 1" ; |
|
696 | + if ($wpdb->get_var("SHOW TABLES LIKE '".$country_table."'") == $country_table) { |
|
697 | + foreach ($newer_countries as $country) { |
|
698 | + $SQL = "SELECT COUNT('CNT_ISO') FROM {$country_table} WHERE CNT_ISO='{$country[0]}' LIMIT 1"; |
|
699 | 699 | $countries = $wpdb->get_var($SQL); |
700 | - if ( ! $countries ) { |
|
700 | + if ( ! $countries) { |
|
701 | 701 | |
702 | - $wpdb->insert( $country_table, |
|
703 | - array_combine( array_keys( $country_format), $country ), |
|
702 | + $wpdb->insert($country_table, |
|
703 | + array_combine(array_keys($country_format), $country), |
|
704 | 704 | $country_format |
705 | 705 | ); |
706 | 706 | } |
@@ -718,7 +718,7 @@ discard block |
||
718 | 718 | // CUR_code, CUR_single, CUR_plural, CUR_sign, CUR_dec_plc, CUR_active |
719 | 719 | //( 'EUR', 'Euro', 'Euros', '€', 2,1), |
720 | 720 | $newer_currencies = array( |
721 | - array( 'RSD', 'Dinar', 'Dinars', '', 3, 1 ), |
|
721 | + array('RSD', 'Dinar', 'Dinars', '', 3, 1), |
|
722 | 722 | ); |
723 | 723 | global $wpdb; |
724 | 724 | $currency_table = $wpdb->prefix."esp_currency"; |
@@ -730,14 +730,14 @@ discard block |
||
730 | 730 | "CUR_dec_plc" => '%d', |
731 | 731 | "CUR_active" => '%d', |
732 | 732 | ); |
733 | - if ( $wpdb->get_var( "SHOW TABLES LIKE '" . $currency_table . "'") == $currency_table ) { |
|
734 | - foreach( $newer_currencies as $currency ) { |
|
735 | - $SQL = "SELECT COUNT('CUR_code') FROM {$currency_table} WHERE CUR_code='{$currency[0]}' LIMIT 1" ; |
|
733 | + if ($wpdb->get_var("SHOW TABLES LIKE '".$currency_table."'") == $currency_table) { |
|
734 | + foreach ($newer_currencies as $currency) { |
|
735 | + $SQL = "SELECT COUNT('CUR_code') FROM {$currency_table} WHERE CUR_code='{$currency[0]}' LIMIT 1"; |
|
736 | 736 | $countries = $wpdb->get_var($SQL); |
737 | - if ( ! $countries ) { |
|
737 | + if ( ! $countries) { |
|
738 | 738 | |
739 | - $wpdb->insert( $currency_table, |
|
740 | - array_combine( array_keys( $currency_format), $currency ), |
|
739 | + $wpdb->insert($currency_table, |
|
740 | + array_combine(array_keys($currency_format), $currency), |
|
741 | 741 | $currency_format |
742 | 742 | ); |
743 | 743 | } |
@@ -749,9 +749,9 @@ discard block |
||
749 | 749 | * which should just be a temporary issue for folks who installed 4.8.0-4.8.5; |
750 | 750 | * we should be able to stop doing this in 4.9 |
751 | 751 | */ |
752 | - public function fix_non_default_taxes(){ |
|
752 | + public function fix_non_default_taxes() { |
|
753 | 753 | global $wpdb; |
754 | - $query = $wpdb->prepare( "UPDATE |
|
754 | + $query = $wpdb->prepare("UPDATE |
|
755 | 755 | {$wpdb->prefix}esp_price p INNER JOIN |
756 | 756 | {$wpdb->prefix}esp_price_type pt ON p.PRT_ID = pt.PRT_ID |
757 | 757 | SET |
@@ -759,8 +759,8 @@ discard block |
||
759 | 759 | WHERE |
760 | 760 | p.PRC_is_default = 0 AND |
761 | 761 | pt.PBT_ID = %d |
762 | - ", EEM_Price_Type::base_type_tax ); |
|
763 | - $wpdb->query( $query ); |
|
762 | + ", EEM_Price_Type::base_type_tax); |
|
763 | + $wpdb->query($query); |
|
764 | 764 | } |
765 | 765 | } |
766 | 766 |
@@ -17,7 +17,7 @@ |
||
17 | 17 | */ |
18 | 18 | /** |
19 | 19 | */ |
20 | -class EE_DMS_Unknown_1_0_0 extends EE_Data_Migration_Script_Base{ |
|
20 | +class EE_DMS_Unknown_1_0_0 extends EE_Data_Migration_Script_Base { |
|
21 | 21 | |
22 | 22 | /** |
23 | 23 | * Returns whether or not this data migration script can operate on the given version of the database. |
@@ -306,7 +306,7 @@ discard block |
||
306 | 306 | $records_migrated_during_stage = $stage->migration_step($num_records_to_migrate_limit - $num_records_actually_migrated); |
307 | 307 | $num_records_actually_migrated += $records_migrated_during_stage; |
308 | 308 | $records_migrated_per_stage[$stage->pretty_name()] = $records_migrated_during_stage; |
309 | - }catch(Exception $e){ |
|
309 | + } catch(Exception $e){ |
|
310 | 310 | //yes if we catch an exception here, we consider that migration stage borked. |
311 | 311 | $stage->set_status(EE_Data_Migration_Manager::status_fatal_error); |
312 | 312 | $this->set_status(EE_Data_Migration_Manager::status_fatal_error); |
@@ -332,14 +332,14 @@ discard block |
||
332 | 332 | //this migration script apparently has NO stages... which is super weird, but whatever |
333 | 333 | $this->set_completed(); |
334 | 334 | $this->_maybe_do_schema_changes(false); |
335 | - }else if( $num_records_actually_migrated < $num_records_to_migrate_limit && ! $stage->has_more_to_do()){ |
|
335 | + } else if( $num_records_actually_migrated < $num_records_to_migrate_limit && ! $stage->has_more_to_do()){ |
|
336 | 336 | //apparently we're done, because we couldn't migrate the number we intended to |
337 | 337 | $this->set_completed(); |
338 | 338 | $this->_update_feedback_message(array_reverse($records_migrated_per_stage)); |
339 | 339 | //do schema changes for after the migration now |
340 | 340 | //first double-check we haven't already done this |
341 | 341 | $this->_maybe_do_schema_changes(false); |
342 | - }else{ |
|
342 | + } else{ |
|
343 | 343 | //update feedback message, keeping in mind that we show them with the most recent at the top |
344 | 344 | $this->_update_feedback_message(array_reverse($records_migrated_per_stage)); |
345 | 345 | } |
@@ -378,12 +378,12 @@ discard block |
||
378 | 378 | ob_start(); |
379 | 379 | if($before){ |
380 | 380 | $this->schema_changes_before_migration(); |
381 | - }else{ |
|
381 | + } else{ |
|
382 | 382 | $this->schema_changes_after_migration(); |
383 | 383 | } |
384 | 384 | $output = ob_get_contents(); |
385 | 385 | ob_end_clean(); |
386 | - }catch(Exception $e){ |
|
386 | + } catch(Exception $e){ |
|
387 | 387 | $this->set_status(EE_Data_Migration_Manager::status_fatal_error); |
388 | 388 | throw $e; |
389 | 389 | } |
@@ -511,13 +511,13 @@ discard block |
||
511 | 511 | if( $table_is_new ) { |
512 | 512 | if( $this->_get_req_type_for_plugin_corresponding_to_this_dms() == EE_System::req_type_new_activation || $this->_currently_migrating() ){ |
513 | 513 | return true; |
514 | - }else{ |
|
514 | + } else{ |
|
515 | 515 | return false; |
516 | 516 | } |
517 | - }else{ |
|
517 | + } else{ |
|
518 | 518 | if(in_array($this->_get_req_type_for_plugin_corresponding_to_this_dms(),array(EE_System::req_type_new_activation))){ |
519 | 519 | return true; |
520 | - }else{ |
|
520 | + } else{ |
|
521 | 521 | return false; |
522 | 522 | } |
523 | 523 | } |
@@ -534,7 +534,7 @@ discard block |
||
534 | 534 | EE_Registry::instance()->load_helper('Activation'); |
535 | 535 | try{ |
536 | 536 | EEH_Activation::create_table($table_name,$table_definition_sql, $engine_string, $drop_pre_existing_tables); |
537 | - }catch( EE_Error $e ) { |
|
537 | + } catch( EE_Error $e ) { |
|
538 | 538 | $message = $e->getMessage() . '<br>Stack Trace:' . $e->getTraceAsString(); |
539 | 539 | $this->add_error( $message ); |
540 | 540 | $this->_feedback_message .= $message; |
@@ -551,11 +551,11 @@ discard block |
||
551 | 551 | private function _get_req_type_for_plugin_corresponding_to_this_dms(){ |
552 | 552 | if($this->slug() == 'Core'){ |
553 | 553 | return EE_System::instance()->detect_req_type(); |
554 | - }else{//it must be for an addon |
|
554 | + } else{//it must be for an addon |
|
555 | 555 | $addon_name = $this->slug(); |
556 | 556 | if( EE_Registry::instance()->get_addon_by_name($addon_name)){ |
557 | 557 | return EE_Registry::instance()->get_addon_by_name($addon_name)->detect_req_type(); |
558 | - }else{ |
|
558 | + } else{ |
|
559 | 559 | throw new EE_Error(sprintf(__("The DMS slug '%s' should correspond to the addon's name, which should also be '%s', but no such addon was registered. These are the registered addons' names: %s", "event_espresso"),$this->slug(),$addon_name,implode(",",array_keys( EE_Registry::instance()->get_addons_by_name() ) ) ) ) ; |
560 | 560 | } |
561 | 561 | } |
@@ -117,9 +117,9 @@ discard block |
||
117 | 117 | * All children of this must call parent::__construct() at the end of their constructor or suffer the consequences! |
118 | 118 | */ |
119 | 119 | public function __construct() { |
120 | - $this->_migration_stages = apply_filters('FHEE__'.get_class($this).'__construct__migration_stages',$this->_migration_stages); |
|
121 | - foreach($this->_migration_stages as $migration_stage){ |
|
122 | - if ( $migration_stage instanceof EE_Data_Migration_Script_Stage ) { |
|
120 | + $this->_migration_stages = apply_filters('FHEE__'.get_class($this).'__construct__migration_stages', $this->_migration_stages); |
|
121 | + foreach ($this->_migration_stages as $migration_stage) { |
|
122 | + if ($migration_stage instanceof EE_Data_Migration_Script_Stage) { |
|
123 | 123 | $migration_stage->_construct_finalize($this); |
124 | 124 | } |
125 | 125 | } |
@@ -132,7 +132,7 @@ discard block |
||
132 | 132 | * Place to add hooks and filters for tweaking the migrations page, in order |
133 | 133 | * to customize it |
134 | 134 | */ |
135 | - public function migration_page_hooks(){ |
|
135 | + public function migration_page_hooks() { |
|
136 | 136 | //by default none are added because we normally like the default look of the migration page |
137 | 137 | } |
138 | 138 | |
@@ -147,9 +147,9 @@ discard block |
||
147 | 147 | * @param int|string $new_pk eg posts.ID |
148 | 148 | * @return void |
149 | 149 | */ |
150 | - public function set_mapping($old_table,$old_pk,$new_table,$new_pk){ |
|
150 | + public function set_mapping($old_table, $old_pk, $new_table, $new_pk) { |
|
151 | 151 | //make sure it has the needed keys |
152 | - if( ! isset($this->_mappings[$old_table]) || ! isset($this->_mappings[$old_table][$new_table])){ |
|
152 | + if ( ! isset($this->_mappings[$old_table]) || ! isset($this->_mappings[$old_table][$new_table])) { |
|
153 | 153 | $this->_mappings[$old_table][$new_table] = $this->_get_mapping_option($old_table, $new_table); |
154 | 154 | } |
155 | 155 | $this->_mappings[$old_table][$new_table][$old_pk] = $new_pk; |
@@ -165,9 +165,9 @@ discard block |
||
165 | 165 | * @param string $new_table with wpdb prefix (wp_). Eg: wp_posts |
166 | 166 | * @return mixed the primary key on the new table |
167 | 167 | */ |
168 | - public function get_mapping_new_pk($old_table,$old_pk,$new_table){ |
|
169 | - if( ! isset($this->_mappings[$old_table]) || |
|
170 | - ! isset($this->_mappings[$old_table][$new_table])){ |
|
168 | + public function get_mapping_new_pk($old_table, $old_pk, $new_table) { |
|
169 | + if ( ! isset($this->_mappings[$old_table]) || |
|
170 | + ! isset($this->_mappings[$old_table][$new_table])) { |
|
171 | 171 | //try fetching the option |
172 | 172 | $this->_mappings[$old_table][$new_table] = $this->_get_mapping_option($old_table, $new_table); |
173 | 173 | } |
@@ -184,15 +184,15 @@ discard block |
||
184 | 184 | * @param mixed $new_pk |
185 | 185 | * @return mixed |
186 | 186 | */ |
187 | - public function get_mapping_old_pk($old_table,$new_table,$new_pk){ |
|
188 | - if( ! isset($this->_mappings[$old_table]) || |
|
189 | - ! isset($this->_mappings[$old_table][$new_table])){ |
|
187 | + public function get_mapping_old_pk($old_table, $new_table, $new_pk) { |
|
188 | + if ( ! isset($this->_mappings[$old_table]) || |
|
189 | + ! isset($this->_mappings[$old_table][$new_table])) { |
|
190 | 190 | //try fetching the option |
191 | 191 | $this->_mappings[$old_table][$new_table] = $this->_get_mapping_option($old_table, $new_table); |
192 | 192 | } |
193 | - if(isset($this->_mappings[$old_table][$new_table])){ |
|
193 | + if (isset($this->_mappings[$old_table][$new_table])) { |
|
194 | 194 | $new_pk_to_old_pk = array_flip($this->_mappings[$old_table][$new_table]); |
195 | - if(isset($new_pk_to_old_pk[$new_pk])){ |
|
195 | + if (isset($new_pk_to_old_pk[$new_pk])) { |
|
196 | 196 | return $new_pk_to_old_pk[$new_pk]; |
197 | 197 | } |
198 | 198 | } |
@@ -207,8 +207,8 @@ discard block |
||
207 | 207 | * @param string $new_table_name |
208 | 208 | * @return array |
209 | 209 | */ |
210 | - protected function _get_mapping_option($old_table_name,$new_table_name){ |
|
211 | - $option = get_option($this->_get_mapping_option_name($old_table_name, $new_table_name),array()); |
|
210 | + protected function _get_mapping_option($old_table_name, $new_table_name) { |
|
211 | + $option = get_option($this->_get_mapping_option_name($old_table_name, $new_table_name), array()); |
|
212 | 212 | return $option; |
213 | 213 | } |
214 | 214 | |
@@ -221,9 +221,9 @@ discard block |
||
221 | 221 | * @param array $mapping_array |
222 | 222 | * @return boolean success of updating option |
223 | 223 | */ |
224 | - protected function _set_mapping_option($old_table_name,$new_table_name,$mapping_array){ |
|
224 | + protected function _set_mapping_option($old_table_name, $new_table_name, $mapping_array) { |
|
225 | 225 | // echo "set mapping for $old_table_name $new_table_name".count($mapping_array)."<br>"; |
226 | - $success = update_option($this->_get_mapping_option_name($old_table_name, $new_table_name),$mapping_array); |
|
226 | + $success = update_option($this->_get_mapping_option_name($old_table_name, $new_table_name), $mapping_array); |
|
227 | 227 | return $success; |
228 | 228 | } |
229 | 229 | |
@@ -235,12 +235,12 @@ discard block |
||
235 | 235 | * @param string $new_table_name |
236 | 236 | * @return string |
237 | 237 | */ |
238 | - protected function _get_mapping_option_name($old_table_name,$new_table_name){ |
|
238 | + protected function _get_mapping_option_name($old_table_name, $new_table_name) { |
|
239 | 239 | global $wpdb; |
240 | - $old_table_name_sans_wp = str_replace($wpdb->prefix,"",$old_table_name); |
|
241 | - $new_table_name_sans_wp = str_replace($wpdb->prefix,"",$new_table_name); |
|
240 | + $old_table_name_sans_wp = str_replace($wpdb->prefix, "", $old_table_name); |
|
241 | + $new_table_name_sans_wp = str_replace($wpdb->prefix, "", $new_table_name); |
|
242 | 242 | $migrates_to = EE_Data_Migration_Manager::instance()->script_migrates_to_version(get_class($this)); |
243 | - return substr( EE_Data_Migration_Manager::data_migration_script_mapping_option_prefix . $migrates_to [ 'slug' ] . '_' . $migrates_to[ 'version' ] . '_' . $old_table_name_sans_wp . '_' . $new_table_name_sans_wp, 0, 64 ); |
|
243 | + return substr(EE_Data_Migration_Manager::data_migration_script_mapping_option_prefix.$migrates_to ['slug'].'_'.$migrates_to['version'].'_'.$old_table_name_sans_wp.'_'.$new_table_name_sans_wp, 0, 64); |
|
244 | 244 | } |
245 | 245 | |
246 | 246 | |
@@ -257,10 +257,10 @@ discard block |
||
257 | 257 | * 99% until the function "migration_step" returns EE_Data_Migration_Script_Base::status_complete. |
258 | 258 | * @return int |
259 | 259 | */ |
260 | - protected function _count_records_to_migrate(){ |
|
260 | + protected function _count_records_to_migrate() { |
|
261 | 261 | $count = 0; |
262 | - foreach($this->stages() as $stage){ |
|
263 | - $count+= $stage->count_records_to_migrate(); |
|
262 | + foreach ($this->stages() as $stage) { |
|
263 | + $count += $stage->count_records_to_migrate(); |
|
264 | 264 | } |
265 | 265 | return $count; |
266 | 266 | } |
@@ -272,10 +272,10 @@ discard block |
||
272 | 272 | * by just setting a transient and updating it after each migration_step |
273 | 273 | * @return int |
274 | 274 | */ |
275 | - public function count_records_migrated(){ |
|
275 | + public function count_records_migrated() { |
|
276 | 276 | $count = 0; |
277 | - foreach($this->stages() as $stage){ |
|
278 | - $count+= $stage->count_records_migrated(); |
|
277 | + foreach ($this->stages() as $stage) { |
|
278 | + $count += $stage->count_records_migrated(); |
|
279 | 279 | } |
280 | 280 | $this->_records_migrated = $count; |
281 | 281 | return $count; |
@@ -289,24 +289,24 @@ discard block |
||
289 | 289 | * @throws EE_Error |
290 | 290 | * @throws Exception |
291 | 291 | */ |
292 | - public function migration_step($num_records_to_migrate_limit){ |
|
292 | + public function migration_step($num_records_to_migrate_limit) { |
|
293 | 293 | //reset the feedback message |
294 | 294 | $this->_feedback_message = ''; |
295 | 295 | //if we haven't yet done the 1st schema changes, do them now. buffer any output |
296 | 296 | $this->_maybe_do_schema_changes(true); |
297 | 297 | |
298 | - $num_records_actually_migrated =0; |
|
298 | + $num_records_actually_migrated = 0; |
|
299 | 299 | $records_migrated_per_stage = array(); |
300 | 300 | //setup the 'stage' variable, which should hold the last run stage of the migration (or none at all if nothing runs) |
301 | 301 | $stage = null; |
302 | 302 | //get the next stage that isn't complete |
303 | - foreach($this->stages() as $stage){ |
|
304 | - if( $stage->get_status() == EE_Data_Migration_Manager::status_continue){ |
|
305 | - try{ |
|
303 | + foreach ($this->stages() as $stage) { |
|
304 | + if ($stage->get_status() == EE_Data_Migration_Manager::status_continue) { |
|
305 | + try { |
|
306 | 306 | $records_migrated_during_stage = $stage->migration_step($num_records_to_migrate_limit - $num_records_actually_migrated); |
307 | 307 | $num_records_actually_migrated += $records_migrated_during_stage; |
308 | 308 | $records_migrated_per_stage[$stage->pretty_name()] = $records_migrated_during_stage; |
309 | - }catch(Exception $e){ |
|
309 | + } catch (Exception $e) { |
|
310 | 310 | //yes if we catch an exception here, we consider that migration stage borked. |
311 | 311 | $stage->set_status(EE_Data_Migration_Manager::status_fatal_error); |
312 | 312 | $this->set_status(EE_Data_Migration_Manager::status_fatal_error); |
@@ -314,7 +314,7 @@ discard block |
||
314 | 314 | throw $e; |
315 | 315 | } |
316 | 316 | //check that the migration stage didn't mark itself as having a fatal error |
317 | - if($stage->is_broken()){ |
|
317 | + if ($stage->is_broken()) { |
|
318 | 318 | $this->set_broken(); |
319 | 319 | throw new EE_Error($stage->get_last_error()); |
320 | 320 | } |
@@ -322,24 +322,24 @@ discard block |
||
322 | 322 | //once we've migrated all the number we intended to (possibly from different stages), stop migrating |
323 | 323 | //or if we had a fatal error |
324 | 324 | //or if the current script stopped early- its not done, but it's done all it thinks we should do on this step |
325 | - if ($num_records_actually_migrated >= $num_records_to_migrate_limit || $stage->is_broken() || $stage->has_more_to_do()){ |
|
325 | + if ($num_records_actually_migrated >= $num_records_to_migrate_limit || $stage->is_broken() || $stage->has_more_to_do()) { |
|
326 | 326 | break; |
327 | 327 | } |
328 | 328 | } |
329 | 329 | //check if we're all done this data migration... |
330 | 330 | //which is indicated by being done early AND the last stage claims to be done |
331 | - if($stage == NULL){ |
|
331 | + if ($stage == NULL) { |
|
332 | 332 | //this migration script apparently has NO stages... which is super weird, but whatever |
333 | 333 | $this->set_completed(); |
334 | 334 | $this->_maybe_do_schema_changes(false); |
335 | - }else if( $num_records_actually_migrated < $num_records_to_migrate_limit && ! $stage->has_more_to_do()){ |
|
335 | + } else if ($num_records_actually_migrated < $num_records_to_migrate_limit && ! $stage->has_more_to_do()) { |
|
336 | 336 | //apparently we're done, because we couldn't migrate the number we intended to |
337 | 337 | $this->set_completed(); |
338 | 338 | $this->_update_feedback_message(array_reverse($records_migrated_per_stage)); |
339 | 339 | //do schema changes for after the migration now |
340 | 340 | //first double-check we haven't already done this |
341 | 341 | $this->_maybe_do_schema_changes(false); |
342 | - }else{ |
|
342 | + } else { |
|
343 | 343 | //update feedback message, keeping in mind that we show them with the most recent at the top |
344 | 344 | $this->_update_feedback_message(array_reverse($records_migrated_per_stage)); |
345 | 345 | } |
@@ -353,12 +353,12 @@ discard block |
||
353 | 353 | * @param array $records_migrated_per_stage KEYS are pretty names for each stage; values are the count of records migrated from that stage |
354 | 354 | * @return void |
355 | 355 | */ |
356 | - private function _update_feedback_message($records_migrated_per_stage){ |
|
356 | + private function _update_feedback_message($records_migrated_per_stage) { |
|
357 | 357 | $feedback_message_array = array(); |
358 | - foreach($records_migrated_per_stage as $migration_stage_name => $num_records_migrated){ |
|
359 | - $feedback_message_array[] = sprintf(__("Migrated %d records successfully during %s", "event_espresso"),$num_records_migrated,$migration_stage_name) ; |
|
358 | + foreach ($records_migrated_per_stage as $migration_stage_name => $num_records_migrated) { |
|
359 | + $feedback_message_array[] = sprintf(__("Migrated %d records successfully during %s", "event_espresso"), $num_records_migrated, $migration_stage_name); |
|
360 | 360 | } |
361 | - $this->_feedback_message .= implode("<br>",$feedback_message_array); |
|
361 | + $this->_feedback_message .= implode("<br>", $feedback_message_array); |
|
362 | 362 | } |
363 | 363 | |
364 | 364 | |
@@ -370,27 +370,27 @@ discard block |
||
370 | 370 | * @throws Exception |
371 | 371 | * @return void |
372 | 372 | */ |
373 | - private function _maybe_do_schema_changes($before = true){ |
|
373 | + private function _maybe_do_schema_changes($before = true) { |
|
374 | 374 | //so this property will be either _schema_changes_after_migration_ran or _schema_changes_before_migration_ran |
375 | - $property_name = '_schema_changes_'. ($before ? 'before' : 'after').'_migration_ran'; |
|
376 | - if ( ! $this->{$property_name} ){ |
|
377 | - try{ |
|
375 | + $property_name = '_schema_changes_'.($before ? 'before' : 'after').'_migration_ran'; |
|
376 | + if ( ! $this->{$property_name} ) { |
|
377 | + try { |
|
378 | 378 | ob_start(); |
379 | - if($before){ |
|
379 | + if ($before) { |
|
380 | 380 | $this->schema_changes_before_migration(); |
381 | - }else{ |
|
381 | + } else { |
|
382 | 382 | $this->schema_changes_after_migration(); |
383 | 383 | } |
384 | 384 | $output = ob_get_contents(); |
385 | 385 | ob_end_clean(); |
386 | - }catch(Exception $e){ |
|
386 | + } catch (Exception $e) { |
|
387 | 387 | $this->set_status(EE_Data_Migration_Manager::status_fatal_error); |
388 | 388 | throw $e; |
389 | 389 | } |
390 | 390 | //record that we've done these schema changes |
391 | 391 | $this->{$property_name} = true; |
392 | 392 | //if there were any warnings etc, record them as non-fatal errors |
393 | - if( $output ){ |
|
393 | + if ($output) { |
|
394 | 394 | //there were some warnings |
395 | 395 | $this->_errors[] = $output; |
396 | 396 | } |
@@ -417,9 +417,9 @@ discard block |
||
417 | 417 | * @param string $table_definition_sql |
418 | 418 | * @param string $engine_string |
419 | 419 | */ |
420 | - protected function _table_is_new_in_this_version($table_name,$table_definition_sql,$engine_string='ENGINE=InnoDB '){ |
|
420 | + protected function _table_is_new_in_this_version($table_name, $table_definition_sql, $engine_string = 'ENGINE=InnoDB ') { |
|
421 | 421 | // EEH_Debug_Tools::instance()->start_timer( '_table_is_new_in_this_version_' . $table_name ); |
422 | - $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped( true ) ); |
|
422 | + $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped(true)); |
|
423 | 423 | // EEH_Debug_Tools::instance()->stop_timer( '_table_is_new_in_this_version_' . $table_name ); |
424 | 424 | } |
425 | 425 | |
@@ -433,9 +433,9 @@ discard block |
||
433 | 433 | * @param string $table_definition_sql |
434 | 434 | * @param string $engine_string |
435 | 435 | */ |
436 | - protected function _table_is_changed_in_this_version($table_name,$table_definition_sql,$engine_string = 'ENGINE=MyISAM'){ |
|
436 | + protected function _table_is_changed_in_this_version($table_name, $table_definition_sql, $engine_string = 'ENGINE=MyISAM') { |
|
437 | 437 | // EEH_Debug_Tools::instance()->start_timer( '_table_is_changed_in_this_version' . $table_name ); |
438 | - $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped( false ) ); |
|
438 | + $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped(false)); |
|
439 | 439 | // EEH_Debug_Tools::instance()->stop_timer( '_table_is_changed_in_this_version' . $table_name ); |
440 | 440 | } |
441 | 441 | |
@@ -446,9 +446,9 @@ discard block |
||
446 | 446 | * @param string $table_name |
447 | 447 | * @return boolean |
448 | 448 | */ |
449 | - protected function _old_table_exists( $table_name ) { |
|
450 | - EE_Registry::instance()->load_helper( 'Activation' ); |
|
451 | - return EEH_Activation::table_exists( $table_name ); |
|
449 | + protected function _old_table_exists($table_name) { |
|
450 | + EE_Registry::instance()->load_helper('Activation'); |
|
451 | + return EEH_Activation::table_exists($table_name); |
|
452 | 452 | } |
453 | 453 | |
454 | 454 | |
@@ -458,9 +458,9 @@ discard block |
||
458 | 458 | * @param string $table_name |
459 | 459 | * @return boolean |
460 | 460 | */ |
461 | - protected function _delete_table_if_empty( $table_name ) { |
|
462 | - EE_Registry::instance()->load_helper( 'Activation' ); |
|
463 | - return EEH_Activation::delete_db_table_if_empty( $table_name ); |
|
461 | + protected function _delete_table_if_empty($table_name) { |
|
462 | + EE_Registry::instance()->load_helper('Activation'); |
|
463 | + return EEH_Activation::delete_db_table_if_empty($table_name); |
|
464 | 464 | } |
465 | 465 | |
466 | 466 | |
@@ -479,9 +479,9 @@ discard block |
||
479 | 479 | * @param string $table_definition_sql |
480 | 480 | * @param string $engine_string |
481 | 481 | */ |
482 | - protected function _table_should_exist_previously($table_name,$table_definition_sql,$engine_string = 'ENGINE=MyISAM'){ |
|
482 | + protected function _table_should_exist_previously($table_name, $table_definition_sql, $engine_string = 'ENGINE=MyISAM') { |
|
483 | 483 | // EEH_Debug_Tools::instance()->start_timer( '_table_should_exist_previously' . $table_name ); |
484 | - $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped( false ) ); |
|
484 | + $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped(false)); |
|
485 | 485 | // EEH_Debug_Tools::instance()->stop_timer( '_table_should_exist_previously' . $table_name ); |
486 | 486 | } |
487 | 487 | |
@@ -496,13 +496,13 @@ discard block |
||
496 | 496 | * @param string $table_definition_sql |
497 | 497 | * @param string $engine_string |
498 | 498 | */ |
499 | - protected function _table_has_not_changed_since_previous( $table_name,$table_definition_sql,$engine_string = 'ENGINE=MyISAM'){ |
|
500 | - if( $this->_currently_migrating() ) { |
|
499 | + protected function _table_has_not_changed_since_previous($table_name, $table_definition_sql, $engine_string = 'ENGINE=MyISAM') { |
|
500 | + if ($this->_currently_migrating()) { |
|
501 | 501 | //if we're doing a migration, and this table apparently already exists, then we don't need do anything right? |
502 | 502 | // EEH_Debug_Tools::instance()->stop_timer( '_table_should_exist_previously' . $table_name ); |
503 | 503 | return; |
504 | 504 | } |
505 | - $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped( false ) ); |
|
505 | + $this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped(false)); |
|
506 | 506 | } |
507 | 507 | |
508 | 508 | /** |
@@ -512,7 +512,7 @@ discard block |
||
512 | 512 | protected function _currently_migrating() { |
513 | 513 | //we want to know if we are currently performing a migration. We could just believe what was set on the _migrating property, but let's double-check (ie the script should apply and we should be in MM) |
514 | 514 | return $this->_migrating && |
515 | - $this->can_migrate_from_version( EE_Data_Migration_Manager::instance()->ensure_current_database_state_is_set() ) && |
|
515 | + $this->can_migrate_from_version(EE_Data_Migration_Manager::instance()->ensure_current_database_state_is_set()) && |
|
516 | 516 | EE_Maintenance_Mode::instance()->real_level() == EE_Maintenance_Mode::level_2_complete_maintenance; |
517 | 517 | } |
518 | 518 | |
@@ -523,17 +523,17 @@ discard block |
||
523 | 523 | * @param boolean $table_is_new |
524 | 524 | * @return boolean |
525 | 525 | */ |
526 | - protected function _pre_existing_table_should_be_dropped( $table_is_new ) { |
|
527 | - if( $table_is_new ) { |
|
528 | - if( $this->_get_req_type_for_plugin_corresponding_to_this_dms() == EE_System::req_type_new_activation || $this->_currently_migrating() ){ |
|
526 | + protected function _pre_existing_table_should_be_dropped($table_is_new) { |
|
527 | + if ($table_is_new) { |
|
528 | + if ($this->_get_req_type_for_plugin_corresponding_to_this_dms() == EE_System::req_type_new_activation || $this->_currently_migrating()) { |
|
529 | 529 | return true; |
530 | - }else{ |
|
530 | + } else { |
|
531 | 531 | return false; |
532 | 532 | } |
533 | - }else{ |
|
534 | - if(in_array($this->_get_req_type_for_plugin_corresponding_to_this_dms(),array(EE_System::req_type_new_activation))){ |
|
533 | + } else { |
|
534 | + if (in_array($this->_get_req_type_for_plugin_corresponding_to_this_dms(), array(EE_System::req_type_new_activation))) { |
|
535 | 535 | return true; |
536 | - }else{ |
|
536 | + } else { |
|
537 | 537 | return false; |
538 | 538 | } |
539 | 539 | } |
@@ -546,13 +546,13 @@ discard block |
||
546 | 546 | * @param string $engine_string |
547 | 547 | * @param boolean $drop_pre_existing_tables |
548 | 548 | */ |
549 | - private function _create_table_and_catch_errors( $table_name, $table_definition_sql, $engine_string = 'ENGINE=MyISAM', $drop_pre_existing_tables = FALSE ){ |
|
549 | + private function _create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string = 'ENGINE=MyISAM', $drop_pre_existing_tables = FALSE) { |
|
550 | 550 | EE_Registry::instance()->load_helper('Activation'); |
551 | - try{ |
|
552 | - EEH_Activation::create_table($table_name,$table_definition_sql, $engine_string, $drop_pre_existing_tables); |
|
553 | - }catch( EE_Error $e ) { |
|
554 | - $message = $e->getMessage() . '<br>Stack Trace:' . $e->getTraceAsString(); |
|
555 | - $this->add_error( $message ); |
|
551 | + try { |
|
552 | + EEH_Activation::create_table($table_name, $table_definition_sql, $engine_string, $drop_pre_existing_tables); |
|
553 | + } catch (EE_Error $e) { |
|
554 | + $message = $e->getMessage().'<br>Stack Trace:'.$e->getTraceAsString(); |
|
555 | + $this->add_error($message); |
|
556 | 556 | $this->_feedback_message .= $message; |
557 | 557 | } |
558 | 558 | } |
@@ -564,15 +564,15 @@ discard block |
||
564 | 564 | * @return int one of EE_System::_req_type_* constants |
565 | 565 | * @throws EE_Error |
566 | 566 | */ |
567 | - private function _get_req_type_for_plugin_corresponding_to_this_dms(){ |
|
568 | - if($this->slug() == 'Core'){ |
|
567 | + private function _get_req_type_for_plugin_corresponding_to_this_dms() { |
|
568 | + if ($this->slug() == 'Core') { |
|
569 | 569 | return EE_System::instance()->detect_req_type(); |
570 | - }else{//it must be for an addon |
|
570 | + } else {//it must be for an addon |
|
571 | 571 | $addon_name = $this->slug(); |
572 | - if( EE_Registry::instance()->get_addon_by_name($addon_name)){ |
|
572 | + if (EE_Registry::instance()->get_addon_by_name($addon_name)) { |
|
573 | 573 | return EE_Registry::instance()->get_addon_by_name($addon_name)->detect_req_type(); |
574 | - }else{ |
|
575 | - throw new EE_Error(sprintf(__("The DMS slug '%s' should correspond to the addon's name, which should also be '%s', but no such addon was registered. These are the registered addons' names: %s", "event_espresso"),$this->slug(),$addon_name,implode(",",array_keys( EE_Registry::instance()->get_addons_by_name() ) ) ) ) ; |
|
574 | + } else { |
|
575 | + throw new EE_Error(sprintf(__("The DMS slug '%s' should correspond to the addon's name, which should also be '%s', but no such addon was registered. These are the registered addons' names: %s", "event_espresso"), $this->slug(), $addon_name, implode(",", array_keys(EE_Registry::instance()->get_addons_by_name())))); |
|
576 | 576 | } |
577 | 577 | } |
578 | 578 | } |
@@ -583,13 +583,13 @@ discard block |
||
583 | 583 | * returns an array of strings describing errors by all the script's stages |
584 | 584 | * @return array |
585 | 585 | */ |
586 | - public function get_errors(){ |
|
586 | + public function get_errors() { |
|
587 | 587 | $all_errors = $this->_errors; |
588 | - if( ! is_array($all_errors)){ |
|
588 | + if ( ! is_array($all_errors)) { |
|
589 | 589 | $all_errors = array(); |
590 | 590 | } |
591 | - foreach($this->stages() as $stage){ |
|
592 | - $all_errors = array_merge($stage->get_errors(),$all_errors); |
|
591 | + foreach ($this->stages() as $stage) { |
|
592 | + $all_errors = array_merge($stage->get_errors(), $all_errors); |
|
593 | 593 | } |
594 | 594 | return $all_errors; |
595 | 595 | } |
@@ -600,8 +600,8 @@ discard block |
||
600 | 600 | * Indicates whether or not this migration script should continue |
601 | 601 | * @return boolean |
602 | 602 | */ |
603 | - public function can_continue(){ |
|
604 | - return in_array($this->get_status(), EE_Data_Migration_Manager::instance()->stati_that_indicate_to_continue_single_migration_script); |
|
603 | + public function can_continue() { |
|
604 | + return in_array($this->get_status(), EE_Data_Migration_Manager::instance()->stati_that_indicate_to_continue_single_migration_script); |
|
605 | 605 | } |
606 | 606 | |
607 | 607 | |
@@ -613,8 +613,8 @@ discard block |
||
613 | 613 | * get ordered by the indexes |
614 | 614 | * @return EE_Data_Migration_Script_Stage[] |
615 | 615 | */ |
616 | - protected function stages(){ |
|
617 | - $stages = apply_filters( 'FHEE__'.get_class($this).'__stages',$this->_migration_stages ); |
|
616 | + protected function stages() { |
|
617 | + $stages = apply_filters('FHEE__'.get_class($this).'__stages', $this->_migration_stages); |
|
618 | 618 | ksort($stages); |
619 | 619 | return $stages; |
620 | 620 | } |
@@ -626,7 +626,7 @@ discard block |
||
626 | 626 | * can be displayed to the user |
627 | 627 | * @return string |
628 | 628 | */ |
629 | - public function get_feedback_message(){ |
|
629 | + public function get_feedback_message() { |
|
630 | 630 | return $this->_feedback_message; |
631 | 631 | } |
632 | 632 | |
@@ -638,16 +638,16 @@ discard block |
||
638 | 638 | * possible that this class is defined when it goes to sleep, but NOT available when it |
639 | 639 | * awakes (eg, this class is part of an addon that is deactivated at some point). |
640 | 640 | */ |
641 | - public function properties_as_array(){ |
|
641 | + public function properties_as_array() { |
|
642 | 642 | $properties = parent::properties_as_array(); |
643 | 643 | $properties['_migration_stages'] = array(); |
644 | - foreach($this->_migration_stages as $migration_stage_priority => $migration_stage_class){ |
|
644 | + foreach ($this->_migration_stages as $migration_stage_priority => $migration_stage_class) { |
|
645 | 645 | $properties['_migration_stages'][$migration_stage_priority] = $migration_stage_class->properties_as_array(); |
646 | 646 | } |
647 | 647 | unset($properties['_mappings']); |
648 | 648 | |
649 | - foreach($this->_mappings as $old_table_name => $mapping_to_new_table){ |
|
650 | - foreach($mapping_to_new_table as $new_table_name => $mapping){ |
|
649 | + foreach ($this->_mappings as $old_table_name => $mapping_to_new_table) { |
|
650 | + foreach ($mapping_to_new_table as $new_table_name => $mapping) { |
|
651 | 651 | $this->_set_mapping_option($old_table_name, $new_table_name, $mapping); |
652 | 652 | } |
653 | 653 | } |
@@ -662,19 +662,19 @@ discard block |
||
662 | 662 | * @param array $array_of_properties like what's produced from properties_as_array() method |
663 | 663 | * @return void |
664 | 664 | */ |
665 | - public function instantiate_from_array_of_properties($array_of_properties){ |
|
665 | + public function instantiate_from_array_of_properties($array_of_properties) { |
|
666 | 666 | $stages_properties_arrays = $array_of_properties['_migration_stages']; |
667 | 667 | unset($array_of_properties['_migration_stages']); |
668 | 668 | unset($array_of_properties['class']); |
669 | - foreach($array_of_properties as $property_name => $property_value){ |
|
669 | + foreach ($array_of_properties as $property_name => $property_value) { |
|
670 | 670 | $this->{$property_name} = $property_value; |
671 | 671 | } |
672 | 672 | //_migration_stages are already instantiated, but have only default data |
673 | - foreach($this->_migration_stages as $stage){ |
|
674 | - $stage_data = $this->_find_migration_stage_data_with_classname(get_class($stage),$stages_properties_arrays); |
|
673 | + foreach ($this->_migration_stages as $stage) { |
|
674 | + $stage_data = $this->_find_migration_stage_data_with_classname(get_class($stage), $stages_properties_arrays); |
|
675 | 675 | //SO, if we found the stage data that was saved, use it. Otherwise, I guess the stage is new? (maybe added by |
676 | 676 | //an addon? Unlikely... not sure why it wouldn't exist, but if it doesn't just treat it like it was never started yet) |
677 | - if($stage_data){ |
|
677 | + if ($stage_data) { |
|
678 | 678 | $stage->instantiate_from_array_of_properties($stage_data); |
679 | 679 | } |
680 | 680 | } |
@@ -690,9 +690,9 @@ discard block |
||
690 | 690 | * @param array $migration_stage_data_arrays |
691 | 691 | * @return null |
692 | 692 | */ |
693 | - private function _find_migration_stage_data_with_classname($classname,$migration_stage_data_arrays){ |
|
694 | - foreach($migration_stage_data_arrays as $migration_stage_data_array){ |
|
695 | - if(isset($migration_stage_data_array['class']) && $migration_stage_data_array['class'] == $classname){ |
|
693 | + private function _find_migration_stage_data_with_classname($classname, $migration_stage_data_arrays) { |
|
694 | + foreach ($migration_stage_data_arrays as $migration_stage_data_array) { |
|
695 | + if (isset($migration_stage_data_array['class']) && $migration_stage_data_array['class'] == $classname) { |
|
696 | 696 | return $migration_stage_data_array; |
697 | 697 | } |
698 | 698 | } |
@@ -708,8 +708,8 @@ discard block |
||
708 | 708 | * @return array where the first key is the plugin's slug, the 2nd is the version of that plugin |
709 | 709 | * that will be updated to. Eg array('Core','4.1.0') |
710 | 710 | */ |
711 | - public final function migrates_to_version(){ |
|
712 | - return EE_Data_Migration_Manager::instance()->script_migrates_to_version( get_class( $this ) ); |
|
711 | + public final function migrates_to_version() { |
|
712 | + return EE_Data_Migration_Manager::instance()->script_migrates_to_version(get_class($this)); |
|
713 | 713 | } |
714 | 714 | |
715 | 715 | |
@@ -721,10 +721,10 @@ discard block |
||
721 | 721 | * Or 'Core' for core (non-addon). |
722 | 722 | * @return string |
723 | 723 | */ |
724 | - public function slug(){ |
|
724 | + public function slug() { |
|
725 | 725 | $migrates_to_version_info = $this->migrates_to_version(); |
726 | 726 | //the slug is the first part of the array |
727 | - return $migrates_to_version_info[ 'slug' ]; |
|
727 | + return $migrates_to_version_info['slug']; |
|
728 | 728 | } |
729 | 729 | |
730 | 730 | |
@@ -738,7 +738,7 @@ discard block |
||
738 | 738 | * the database up so it can run), then you can set "A" to priority 3 or something. |
739 | 739 | * @return int |
740 | 740 | */ |
741 | - public function priority(){ |
|
741 | + public function priority() { |
|
742 | 742 | return $this->_priority; |
743 | 743 | } |
744 | 744 | |
@@ -751,18 +751,18 @@ discard block |
||
751 | 751 | * @param boolean $migrating |
752 | 752 | * @return void |
753 | 753 | */ |
754 | - public function set_migrating( $migrating = TRUE ){ |
|
754 | + public function set_migrating($migrating = TRUE) { |
|
755 | 755 | $this->_migrating = $migrating; |
756 | 756 | } |
757 | 757 | |
758 | 758 | /** |
759 | 759 | * Marks that we think this migration class can continue to migrate |
760 | 760 | */ |
761 | - public function reattempt(){ |
|
761 | + public function reattempt() { |
|
762 | 762 | parent::reattempt(); |
763 | 763 | //also, we want to reattempt any stages that were marked as borked |
764 | - foreach( $this->stages() as $stage ) { |
|
765 | - if( $stage->is_broken() ) { |
|
764 | + foreach ($this->stages() as $stage) { |
|
765 | + if ($stage->is_broken()) { |
|
766 | 766 | $stage->reattempt(); |
767 | 767 | } |
768 | 768 | } |