Completed
Branch FET-8365-add-indexes (4b9253)
by
unknown
527:08 queued 512:28
created
4_7_0_stages/EE_DMS_4_7_0_Add_Taxes_To_REG_Final_Price.dmsstage.php 1 patch
Spacing   +39 added lines, -39 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 				)
Please login to merge, or discard this patch.
4_7_0_stages/EE_DMS_4_7_0_Registration_Payments.dmsstage.php 2 patches
Spacing   +50 added lines, -50 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 				)
Please login to merge, or discard this patch.
Doc Comments   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -26,7 +26,7 @@
 block discarded – undo
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) {
Please login to merge, or discard this patch.
core/data_migration_scripts/EE_DMS_Core_4_2_0.dms.php 3 patches
Indentation   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -1,10 +1,10 @@
 block discarded – undo
1 1
 <?php
2 2
 /**
3
- * meant to convert DBs between 4.1.x to 4.2.0
4
- * mostly just
5
- * -adds QGQ_order to the question-group_question table;
6
- * -adds DTT_name and DTT_description to the datetime table;
7
- */
3
+	 * meant to convert DBs between 4.1.x to 4.2.0
4
+	 * mostly just
5
+	 * -adds QGQ_order to the question-group_question table;
6
+	 * -adds DTT_name and DTT_description to the datetime table;
7
+	 */
8 8
 //make sure we have all the stages loaded too
9 9
 //unfortunately, this needs to be done upon INCLUSION of this file,
10 10
 //instead of construction, because it only gets constructed on first page load
Please login to merge, or discard this patch.
Spacing   +45 added lines, -45 removed lines patch added patch discarded remove patch
@@ -11,18 +11,18 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 }
Please login to merge, or discard this patch.
Braces   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -65,11 +65,11 @@
 block discarded – undo
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
 		}
Please login to merge, or discard this patch.
core/data_migration_scripts/EE_DMS_Core_4_3_0.dms.php 2 patches
Spacing   +56 added lines, -56 removed lines patch added patch discarded remove patch
@@ -10,18 +10,18 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 		}
Please login to merge, or discard this patch.
Braces   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -65,11 +65,11 @@
 block discarded – undo
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
 		}
Please login to merge, or discard this patch.
core/data_migration_scripts/EE_DMS_Core_4_5_0.dms.php 2 patches
Spacing   +70 added lines, -70 removed lines patch added patch discarded remove patch
@@ -12,16 +12,16 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 		}
Please login to merge, or discard this patch.
Braces   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -65,11 +65,11 @@
 block discarded – undo
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
 		}
Please login to merge, or discard this patch.
core/data_migration_scripts/EE_DMS_Core_4_6_0.dms.php 2 patches
Spacing   +65 added lines, -65 removed lines patch added patch discarded remove patch
@@ -10,13 +10,13 @@  discard block
 block discarded – undo
10 10
 //(all other times it gets resurrected from a wordpress option)
11 11
 $stages = glob(EE_CORE.'data_migration_scripts/4_6_0_stages/*');
12 12
 $class_to_filepath = array();
13
-foreach($stages as $filepath){
13
+foreach ($stages as $filepath) {
14 14
 	$matches = array();
15
-	preg_match('~4_6_0_stages/(.*).dmsstage.php~',$filepath,$matches);
15
+	preg_match('~4_6_0_stages/(.*).dmsstage.php~', $filepath, $matches);
16 16
 	$class_to_filepath[$matches[1]] = $filepath;
17 17
 }
18 18
 //give addons a chance to autoload their stages too
19
-$class_to_filepath = apply_filters('FHEE__EE_DMS_4_6_0__autoloaded_stages',$class_to_filepath);
19
+$class_to_filepath = apply_filters('FHEE__EE_DMS_4_6_0__autoloaded_stages', $class_to_filepath);
20 20
 EEH_Autoloader::register_autoloader($class_to_filepath);
21 21
 
22 22
 
@@ -32,7 +32,7 @@  discard block
 block discarded – undo
32 32
  * @since                4.6.0
33 33
  *
34 34
  */
35
-class EE_DMS_Core_4_6_0 extends EE_Data_Migration_Script_Base{
35
+class EE_DMS_Core_4_6_0 extends EE_Data_Migration_Script_Base {
36 36
 
37 37
 	/**
38 38
 	 * return EE_DMS_Core_4_6_0
@@ -62,14 +62,14 @@  discard block
 block discarded – undo
62 62
 	 */
63 63
 	public function can_migrate_from_version($version_array) {
64 64
 		$version_string = $version_array['Core'];
65
-		if($version_string <= '4.6.0' && $version_string >= '4.5.0' ){
65
+		if ($version_string <= '4.6.0' && $version_string >= '4.5.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
 		}
@@ -91,14 +91,14 @@  discard block
 block discarded – undo
91 91
 	 */
92 92
 	public function schema_changes_before_migration() {
93 93
 		//relies on 4.1's EEH_Activation::create_table
94
-		require_once( EE_HELPERS . 'EEH_Activation.helper.php' );
95
-		$table_name='esp_answer';
96
-		$sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
94
+		require_once(EE_HELPERS.'EEH_Activation.helper.php');
95
+		$table_name = 'esp_answer';
96
+		$sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
97 97
 					REG_ID INT UNSIGNED NOT NULL,
98 98
 					QST_ID INT UNSIGNED NOT NULL,
99 99
 					ANS_value TEXT NOT NULL,
100 100
 					PRIMARY KEY  (ANS_ID)";
101
-		$this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB');
101
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
102 102
 
103 103
 		$table_name = 'esp_attendee_meta';
104 104
 		$sql = "ATTM_ID INT(10) UNSIGNED NOT	NULL AUTO_INCREMENT,
@@ -137,7 +137,7 @@  discard block
 block discarded – undo
137 137
 					  CNT_is_EU TINYINT(1) DEFAULT '0',
138 138
 					  CNT_active TINYINT(1) DEFAULT '0',
139 139
 					  PRIMARY KEY  (CNT_ISO)";
140
-		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' );
140
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
141 141
 
142 142
 		$table_name = 'esp_currency';
143 143
 		$sql = "CUR_code VARCHAR(6) COLLATE utf8_bin NOT NULL,
@@ -147,7 +147,7 @@  discard block
 block discarded – undo
147 147
 				CUR_dec_plc VARCHAR(1) COLLATE utf8_bin NOT NULL DEFAULT '2',
148 148
 				CUR_active TINYINT(1) DEFAULT '0',
149 149
 				PRIMARY KEY  (CUR_code)";
150
-		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB' );
150
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
151 151
 
152 152
 
153 153
 		$table_name = 'esp_currency_payment_method';
@@ -177,7 +177,7 @@  discard block
 block discarded – undo
177 177
 
178 178
 
179 179
 
180
-		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' );
180
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
181 181
 		$table_name = 'esp_event_meta';
182 182
 		$sql = "
183 183
 			EVTM_ID INT NOT NULL AUTO_INCREMENT,
@@ -194,41 +194,41 @@  discard block
 block discarded – undo
194 194
 			EVT_external_URL VARCHAR(200) NULL,
195 195
 			EVT_donations TINYINT(1) NULL,
196 196
 			PRIMARY KEY  (EVTM_ID)";
197
-		$this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB');
197
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
198 198
 
199 199
 
200 200
 
201
-		$table_name='esp_event_question_group';
202
-		$sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
201
+		$table_name = 'esp_event_question_group';
202
+		$sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
203 203
 					EVT_ID BIGINT(20) UNSIGNED NOT NULL,
204 204
 					QSG_ID INT UNSIGNED NOT NULL,
205 205
 					EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
206 206
 					PRIMARY KEY  (EQG_ID)";
207
-		$this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB');
207
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
208 208
 
209 209
 
210 210
 
211
-		$table_name='esp_event_venue';
212
-		$sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT,
211
+		$table_name = 'esp_event_venue';
212
+		$sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT,
213 213
 				EVT_ID BIGINT(20) UNSIGNED NOT NULL,
214 214
 				VNU_ID BIGINT(20) UNSIGNED NOT NULL,
215 215
 				EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
216 216
 				PRIMARY KEY  (EVV_ID)";
217
-		$this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB');
217
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
218 218
 
219 219
 
220 220
 
221
-		$table_name='esp_extra_meta';
222
-		$sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT,
221
+		$table_name = 'esp_extra_meta';
222
+		$sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT,
223 223
 				OBJ_ID INT(11) DEFAULT NULL,
224 224
 				EXM_type VARCHAR(45) DEFAULT NULL,
225 225
 				EXM_key VARCHAR(45) DEFAULT NULL,
226 226
 				EXM_value TEXT,
227 227
 				PRIMARY KEY  (EXM_ID)";
228
-		$this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB');
228
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
229 229
 
230
-		$table_name='esp_line_item';
231
-		$sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT,
230
+		$table_name = 'esp_line_item';
231
+		$sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT,
232 232
 				LIN_code VARCHAR(245) NOT NULL DEFAULT '',
233 233
 				TXN_ID INT(11) DEFAULT NULL,
234 234
 				LIN_name VARCHAR(245) NOT NULL DEFAULT '',
@@ -244,7 +244,7 @@  discard block
 block discarded – undo
244 244
 				OBJ_ID INT(11) DEFAULT NULL,
245 245
 				OBJ_type VARCHAR(45)DEFAULT NULL,
246 246
 				PRIMARY KEY  (LIN_ID)";
247
-		$this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB' );
247
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
248 248
 
249 249
 		$table_name = 'esp_log';
250 250
 		$sql = "LOG_ID INT(11) NOT NULL AUTO_INCREMENT,
@@ -267,7 +267,7 @@  discard block
 block discarded – undo
267 267
 					KEY GRP_ID (GRP_ID)";
268 268
 		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
269 269
 
270
-		EEH_Activation::drop_index( 'esp_message_template_group', 'EVT_ID' );
270
+		EEH_Activation::drop_index('esp_message_template_group', 'EVT_ID');
271 271
 
272 272
 		$table_name = 'esp_message_template_group';
273 273
 		$sql = "GRP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
@@ -282,7 +282,7 @@  discard block
 block discarded – undo
282 282
 					MTP_is_active TINYINT(1) NOT NULL DEFAULT '1',
283 283
 					PRIMARY KEY  (GRP_ID),
284 284
 					KEY MTP_user_id (MTP_user_id)";
285
-		$this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB');
285
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
286 286
 
287 287
 		$table_name = 'esp_event_message_template';
288 288
 		$sql = "EMT_ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
@@ -291,7 +291,7 @@  discard block
 block discarded – undo
291 291
 					PRIMARY KEY  (EMT_ID),
292 292
 					KEY EVT_ID (EVT_ID),
293 293
 					KEY GRP_ID (GRP_ID)";
294
-		$this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB');
294
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
295 295
 
296 296
 
297 297
 		$table_name = 'esp_payment';
@@ -359,8 +359,8 @@  discard block
 block discarded – undo
359 359
 					  PRIMARY KEY  (TTM_ID)";
360 360
 		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
361 361
 
362
-		$table_name='esp_question';
363
-		$sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
362
+		$table_name = 'esp_question';
363
+		$sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
364 364
 					QST_display_text TEXT NOT NULL,
365 365
 					QST_admin_label VARCHAR(255) NOT NULL,
366 366
 					QST_system VARCHAR(25) DEFAULT NULL,
@@ -372,27 +372,27 @@  discard block
 block discarded – undo
372 372
 					QST_wp_user BIGINT UNSIGNED NULL,
373 373
 					QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0,
374 374
 					PRIMARY KEY  (QST_ID)';
375
-		$this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB');
375
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
376 376
 
377
-		$table_name='esp_question_group_question';
378
-		$sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
377
+		$table_name = 'esp_question_group_question';
378
+		$sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
379 379
 					QSG_ID INT UNSIGNED NOT NULL,
380 380
 					QST_ID INT UNSIGNED NOT NULL,
381 381
 					QGQ_order INT UNSIGNED NOT NULL DEFAULT 0,
382 382
 					PRIMARY KEY  (QGQ_ID) ";
383
-		$this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB');
383
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
384 384
 
385 385
 
386 386
 
387
-		$table_name='esp_question_option';
388
-		$sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
387
+		$table_name = 'esp_question_option';
388
+		$sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
389 389
 					QSO_value VARCHAR(255) NOT NULL,
390 390
 					QSO_desc TEXT NOT NULL,
391 391
 					QST_ID INT UNSIGNED NOT NULL,
392 392
 					QSO_order INT UNSIGNED NOT NULL DEFAULT 0,
393 393
 					QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
394 394
 					PRIMARY KEY  (QSO_ID)";
395
-		$this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB');
395
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
396 396
 
397 397
 
398 398
 
@@ -425,8 +425,8 @@  discard block
 block discarded – undo
425 425
 
426 426
 
427 427
 
428
-		$table_name='esp_checkin';
429
-		$sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
428
+		$table_name = 'esp_checkin';
429
+		$sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
430 430
 					REG_ID INT(10) UNSIGNED NOT NULL,
431 431
 					DTT_ID INT(10) UNSIGNED NOT NULL,
432 432
 					CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
@@ -515,7 +515,7 @@  discard block
 block discarded – undo
515 515
 					  PRC_wp_user BIGINT UNSIGNED NULL,
516 516
 					  PRC_parent INT(10) UNSIGNED DEFAULT 0,
517 517
 					  PRIMARY KEY  (PRC_ID)";
518
-		$this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB');
518
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
519 519
 
520 520
 		$table_name = "esp_price_type";
521 521
 		$sql = "PRT_ID TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
@@ -552,12 +552,12 @@  discard block
 block discarded – undo
552 552
 					  TKT_parent INT(10) UNSIGNED DEFAULT '0',
553 553
 					  TKT_deleted TINYINT(1) NOT NULL DEFAULT '0',
554 554
 					  PRIMARY KEY  (TKT_ID)";
555
-		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' );
555
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
556 556
 
557
-		EEH_Activation::drop_index( 'esp_question_group', 'QSG_identifier_UNIQUE' );
557
+		EEH_Activation::drop_index('esp_question_group', 'QSG_identifier_UNIQUE');
558 558
 
559 559
 		$table_name = 'esp_question_group';
560
-		$sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
560
+		$sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
561 561
 					QSG_name VARCHAR(255) NOT NULL,
562 562
 					QSG_identifier VARCHAR(100) NOT NULL,
563 563
 					QSG_desc TEXT NULL,
@@ -569,7 +569,7 @@  discard block
 block discarded – undo
569 569
 					QSG_wp_user BIGINT UNSIGNED NULL,
570 570
 					PRIMARY KEY  (QSG_ID),
571 571
 					UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)';
572
-		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' );
572
+		$this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB');
573 573
 
574 574
 		/** @var EE_DMS_Core_4_1_0 $script_4_1_defaults */
575 575
 		$script_4_1_defaults = EE_Registry::instance()->load_dms('Core_4_1_0');
@@ -597,19 +597,19 @@  discard block
 block discarded – undo
597 597
 		return true;
598 598
 	}
599 599
 
600
-	public function migration_page_hooks(){
600
+	public function migration_page_hooks() {
601 601
 
602 602
 	}
603 603
 
604
-	public function add_default_admin_only_payments(){
604
+	public function add_default_admin_only_payments() {
605 605
 		global $wpdb;
606 606
 		$table_name = $wpdb->prefix."esp_payment_method";
607 607
 		$user_id = EEH_Activation::get_default_creator_id();
608
-		if ( $wpdb->get_var( "SHOW TABLES LIKE '" . $table_name . "'") == $table_name ) {
608
+		if ($wpdb->get_var("SHOW TABLES LIKE '".$table_name."'") == $table_name) {
609 609
 
610 610
 			$SQL = "SELECT COUNT( * ) FROM $table_name";
611 611
 			$existing_payment_methods = $wpdb->get_var($SQL);
612
-			if ( ! $existing_payment_methods ) {
612
+			if ( ! $existing_payment_methods) {
613 613
 				//make sure we hae payment method records for the following
614 614
 				//so admins can record payments for them from the admin page
615 615
 				$default_admin_only_payment_methods = array(
@@ -623,11 +623,11 @@  discard block
 block discarded – undo
623 623
 					__("Paypal", 'event_espresso')=>  __("Paypal eCheck, Invoice, etc", 'event_espresso'),
624 624
 				);
625 625
 
626
-				foreach($default_admin_only_payment_methods as $nicename => $description){
626
+				foreach ($default_admin_only_payment_methods as $nicename => $description) {
627 627
 					$slug = sanitize_key($nicename);
628 628
 				//check that such a payment method exists
629
-					$exists = $wpdb->get_var($wpdb->prepare("SELECT count(*) FROM $table_name WHERE PMD_slug = %s",$slug));
630
-					if( ! $exists){
629
+					$exists = $wpdb->get_var($wpdb->prepare("SELECT count(*) FROM $table_name WHERE PMD_slug = %s", $slug));
630
+					if ( ! $exists) {
631 631
 						$values = array(
632 632
 									'PMD_type'=>'Admin_Only',
633 633
 									'PMD_name'=>$nicename,
@@ -641,17 +641,17 @@  discard block
 block discarded – undo
641 641
 								$table_name,
642 642
 								$values,
643 643
 								array(
644
-									'%s',//PMD_type
645
-									'%s',//PMD_name
646
-									'%s',//PMD_admin_name
647
-									'%s',//PMD_admin_desc
648
-									'%s',//PMD_slug
649
-									'%d',//PMD_wp_user
650
-									'%s',//PMD_scope
644
+									'%s', //PMD_type
645
+									'%s', //PMD_name
646
+									'%s', //PMD_admin_name
647
+									'%s', //PMD_admin_desc
648
+									'%s', //PMD_slug
649
+									'%d', //PMD_wp_user
650
+									'%s', //PMD_scope
651 651
 								)
652 652
 								);
653
-						if( ! $success ){
654
-							$this->add_error(sprintf(__("Could not insert new admin-only payment method with values %s during migration", "event_espresso"),$this->_json_encode($values)));
653
+						if ( ! $success) {
654
+							$this->add_error(sprintf(__("Could not insert new admin-only payment method with values %s during migration", "event_espresso"), $this->_json_encode($values)));
655 655
 						}
656 656
 					}
657 657
 				}
@@ -670,11 +670,11 @@  discard block
 block discarded – undo
670 670
 
671 671
 		global $wpdb;
672 672
 		$currency_table = $wpdb->prefix."esp_currency";
673
-		if ( $wpdb->get_var( "SHOW TABLES LIKE '" . $currency_table . "'") == $currency_table ) {
673
+		if ($wpdb->get_var("SHOW TABLES LIKE '".$currency_table."'") == $currency_table) {
674 674
 
675 675
 			$SQL = "SELECT COUNT('CUR_code') FROM $currency_table";
676 676
 			$countries = $wpdb->get_var($SQL);
677
-			if ( ! $countries ) {
677
+			if ( ! $countries) {
678 678
 				$SQL = "INSERT INTO $currency_table
679 679
 				( CUR_code, CUR_single, CUR_plural, CUR_sign, CUR_dec_plc, CUR_active) VALUES
680 680
 				( 'EUR',  'Euro',  'Euros',  '€',  2,1),
Please login to merge, or discard this patch.
Braces   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -65,11 +65,11 @@
 block discarded – undo
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
 		}
Please login to merge, or discard this patch.
core/data_migration_scripts/EE_DMS_Unknown_1_0_0.core.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -17,7 +17,7 @@
 block discarded – undo
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.
Please login to merge, or discard this patch.
core/data_migration_scripts/EE_Data_Migration_Script_Base.core.php 2 patches
Braces   +11 added lines, -11 removed lines patch added patch discarded remove patch
@@ -306,7 +306,7 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 		}
Please login to merge, or discard this patch.
Spacing   +110 added lines, -110 removed lines patch added patch discarded remove patch
@@ -117,9 +117,9 @@  discard block
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 block discarded – undo
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
 
@@ -432,9 +432,9 @@  discard block
 block discarded – undo
432 432
 	 * @param string $table_definition_sql
433 433
 	 * @param string $engine_string
434 434
 	 */
435
-	protected function _table_is_changed_in_this_version($table_name,$table_definition_sql,$engine_string = 'ENGINE=MyISAM'){
435
+	protected function _table_is_changed_in_this_version($table_name, $table_definition_sql, $engine_string = 'ENGINE=MyISAM') {
436 436
 //		EEH_Debug_Tools::instance()->start_timer( '_table_is_changed_in_this_version' . $table_name );
437
-		$this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped(  false ) );
437
+		$this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped(false));
438 438
 //		EEH_Debug_Tools::instance()->stop_timer( '_table_is_changed_in_this_version' . $table_name  );
439 439
 	}
440 440
 
@@ -452,9 +452,9 @@  discard block
 block discarded – undo
452 452
 	 * @param string $table_definition_sql
453 453
 	 * @param string $engine_string
454 454
 	 */
455
-	protected function _table_should_exist_previously($table_name,$table_definition_sql,$engine_string = 'ENGINE=MyISAM'){
455
+	protected function _table_should_exist_previously($table_name, $table_definition_sql, $engine_string = 'ENGINE=MyISAM') {
456 456
 //		EEH_Debug_Tools::instance()->start_timer( '_table_should_exist_previously' . $table_name );
457
-		$this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped(  false ) );
457
+		$this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped(false));
458 458
 //		EEH_Debug_Tools::instance()->stop_timer( '_table_should_exist_previously' . $table_name );
459 459
 	}
460 460
 
@@ -468,13 +468,13 @@  discard block
 block discarded – undo
468 468
 	 * @param string $table_definition_sql
469 469
 	 * @param string $engine_string
470 470
 	 */
471
-	protected function _table_has_not_changed_since_previous( $table_name,$table_definition_sql,$engine_string = 'ENGINE=MyISAM'){
472
-		if( $this->_currently_migrating() ) {
471
+	protected function _table_has_not_changed_since_previous($table_name, $table_definition_sql, $engine_string = 'ENGINE=MyISAM') {
472
+		if ($this->_currently_migrating()) {
473 473
 			//if we're doing a migration, and this table apparently already exists, then we don't need do anything right?
474 474
 //			EEH_Debug_Tools::instance()->stop_timer( '_table_should_exist_previously' . $table_name );
475 475
 			return;
476 476
 		}
477
-		$this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped(  false ) );
477
+		$this->_create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string, $this->_pre_existing_table_should_be_dropped(false));
478 478
 	}
479 479
 
480 480
 	/**
@@ -484,7 +484,7 @@  discard block
 block discarded – undo
484 484
 	protected function _currently_migrating() {
485 485
 		//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)
486 486
 		return $this->_migrating &&
487
-					$this->can_migrate_from_version( EE_Data_Migration_Manager::instance()->ensure_current_database_state_is_set() ) &&
487
+					$this->can_migrate_from_version(EE_Data_Migration_Manager::instance()->ensure_current_database_state_is_set()) &&
488 488
 					EE_Maintenance_Mode::instance()->real_level() == EE_Maintenance_Mode::level_2_complete_maintenance;
489 489
 	}
490 490
 
@@ -494,17 +494,17 @@  discard block
 block discarded – undo
494 494
 	 * @param boolean $table_is_new
495 495
 	 * @return boolean
496 496
 	 */
497
-	protected function _pre_existing_table_should_be_dropped( $table_is_new ) {
498
-		if( $table_is_new ) {
499
-			if( $this->_get_req_type_for_plugin_corresponding_to_this_dms() == EE_System::req_type_new_activation  || $this->_currently_migrating() ){
497
+	protected function _pre_existing_table_should_be_dropped($table_is_new) {
498
+		if ($table_is_new) {
499
+			if ($this->_get_req_type_for_plugin_corresponding_to_this_dms() == EE_System::req_type_new_activation || $this->_currently_migrating()) {
500 500
 				return true;
501
-			}else{
501
+			} else {
502 502
 				return false;
503 503
 			}
504
-		}else{
505
-			if(in_array($this->_get_req_type_for_plugin_corresponding_to_this_dms(),array(EE_System::req_type_new_activation))){
504
+		} else {
505
+			if (in_array($this->_get_req_type_for_plugin_corresponding_to_this_dms(), array(EE_System::req_type_new_activation))) {
506 506
 				return true;
507
-			}else{
507
+			} else {
508 508
 				return false;
509 509
 			}
510 510
 		}
@@ -517,13 +517,13 @@  discard block
 block discarded – undo
517 517
 	 * @param string $engine_string
518 518
 	 * @param boolean $drop_pre_existing_tables
519 519
 	 */
520
-	private function _create_table_and_catch_errors( $table_name, $table_definition_sql, $engine_string = 'ENGINE=MyISAM', $drop_pre_existing_tables = FALSE ){
520
+	private function _create_table_and_catch_errors($table_name, $table_definition_sql, $engine_string = 'ENGINE=MyISAM', $drop_pre_existing_tables = FALSE) {
521 521
 		EE_Registry::instance()->load_helper('Activation');
522
-		try{
523
-			EEH_Activation::create_table($table_name,$table_definition_sql, $engine_string, $drop_pre_existing_tables);
524
-		}catch( EE_Error $e ) {
525
-			$message = $e->getMessage() . '<br>Stack Trace:' . $e->getTraceAsString();
526
-			$this->add_error( $message  );
522
+		try {
523
+			EEH_Activation::create_table($table_name, $table_definition_sql, $engine_string, $drop_pre_existing_tables);
524
+		} catch (EE_Error $e) {
525
+			$message = $e->getMessage().'<br>Stack Trace:'.$e->getTraceAsString();
526
+			$this->add_error($message);
527 527
 			$this->_feedback_message .= $message;
528 528
 		}
529 529
 	}
@@ -535,15 +535,15 @@  discard block
 block discarded – undo
535 535
 	 * @return int one of EE_System::_req_type_* constants
536 536
 	 * @throws EE_Error
537 537
 	 */
538
-	private function _get_req_type_for_plugin_corresponding_to_this_dms(){
539
-		if($this->slug() == 'Core'){
538
+	private function _get_req_type_for_plugin_corresponding_to_this_dms() {
539
+		if ($this->slug() == 'Core') {
540 540
 			return EE_System::instance()->detect_req_type();
541
-		}else{//it must be for an addon
541
+		} else {//it must be for an addon
542 542
 			$addon_name = $this->slug();
543
-			if( EE_Registry::instance()->get_addon_by_name($addon_name)){
543
+			if (EE_Registry::instance()->get_addon_by_name($addon_name)) {
544 544
 				return EE_Registry::instance()->get_addon_by_name($addon_name)->detect_req_type();
545
-			}else{
546
-				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() ) ) ) ) ;
545
+			} else {
546
+				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()))));
547 547
 			}
548 548
 		}
549 549
 	}
@@ -554,13 +554,13 @@  discard block
 block discarded – undo
554 554
 	 * returns an array of strings describing errors by all the script's stages
555 555
 	 * @return array
556 556
 	 */
557
-	public function get_errors(){
557
+	public function get_errors() {
558 558
 		$all_errors = $this->_errors;
559
-		if( ! is_array($all_errors)){
559
+		if ( ! is_array($all_errors)) {
560 560
 			$all_errors = array();
561 561
 		}
562
-		foreach($this->stages() as $stage){
563
-			$all_errors = array_merge($stage->get_errors(),$all_errors);
562
+		foreach ($this->stages() as $stage) {
563
+			$all_errors = array_merge($stage->get_errors(), $all_errors);
564 564
 		}
565 565
 		return $all_errors;
566 566
 	}
@@ -571,8 +571,8 @@  discard block
 block discarded – undo
571 571
 	 * Indicates whether or not this migration script should continue
572 572
 	 * @return boolean
573 573
 	 */
574
-	public function can_continue(){
575
-		return in_array($this->get_status(),  EE_Data_Migration_Manager::instance()->stati_that_indicate_to_continue_single_migration_script);
574
+	public function can_continue() {
575
+		return in_array($this->get_status(), EE_Data_Migration_Manager::instance()->stati_that_indicate_to_continue_single_migration_script);
576 576
 	}
577 577
 
578 578
 
@@ -584,8 +584,8 @@  discard block
 block discarded – undo
584 584
 	 * get ordered by the indexes
585 585
 	 * @return EE_Data_Migration_Script_Stage[]
586 586
 	 */
587
-	protected function stages(){
588
-		$stages = apply_filters( 'FHEE__'.get_class($this).'__stages',$this->_migration_stages );
587
+	protected function stages() {
588
+		$stages = apply_filters('FHEE__'.get_class($this).'__stages', $this->_migration_stages);
589 589
 		ksort($stages);
590 590
 		return $stages;
591 591
 	}
@@ -597,7 +597,7 @@  discard block
 block discarded – undo
597 597
 	 * can be displayed to the user
598 598
 	 * @return string
599 599
 	 */
600
-	public function get_feedback_message(){
600
+	public function get_feedback_message() {
601 601
 		return $this->_feedback_message;
602 602
 	}
603 603
 
@@ -609,16 +609,16 @@  discard block
 block discarded – undo
609 609
 	 * possible that this class is defined when it goes to sleep, but NOT available when it
610 610
 	 * awakes (eg, this class is part of an addon that is deactivated at some point).
611 611
 	 */
612
-	public function properties_as_array(){
612
+	public function properties_as_array() {
613 613
 		$properties = parent::properties_as_array();
614 614
 		$properties['_migration_stages'] = array();
615
-		foreach($this->_migration_stages as $migration_stage_priority => $migration_stage_class){
615
+		foreach ($this->_migration_stages as $migration_stage_priority => $migration_stage_class) {
616 616
 			$properties['_migration_stages'][$migration_stage_priority] = $migration_stage_class->properties_as_array();
617 617
 		}
618 618
 		unset($properties['_mappings']);
619 619
 
620
-		foreach($this->_mappings as $old_table_name => $mapping_to_new_table){
621
-			foreach($mapping_to_new_table as $new_table_name => $mapping){
620
+		foreach ($this->_mappings as $old_table_name => $mapping_to_new_table) {
621
+			foreach ($mapping_to_new_table as $new_table_name => $mapping) {
622 622
 				$this->_set_mapping_option($old_table_name, $new_table_name, $mapping);
623 623
 			}
624 624
 		}
@@ -633,19 +633,19 @@  discard block
 block discarded – undo
633 633
 	 * @param array $array_of_properties like what's produced from properties_as_array() method
634 634
 	 * @return void
635 635
 	 */
636
-	public function instantiate_from_array_of_properties($array_of_properties){
636
+	public function instantiate_from_array_of_properties($array_of_properties) {
637 637
 		$stages_properties_arrays = $array_of_properties['_migration_stages'];
638 638
 		unset($array_of_properties['_migration_stages']);
639 639
 		unset($array_of_properties['class']);
640
-		foreach($array_of_properties as $property_name => $property_value){
640
+		foreach ($array_of_properties as $property_name => $property_value) {
641 641
 			$this->$property_name = $property_value;
642 642
 		}
643 643
 		//_migration_stages are already instantiated, but have only default data
644
-		foreach($this->_migration_stages as $stage){
645
-			$stage_data = $this->_find_migration_stage_data_with_classname(get_class($stage),$stages_properties_arrays);
644
+		foreach ($this->_migration_stages as $stage) {
645
+			$stage_data = $this->_find_migration_stage_data_with_classname(get_class($stage), $stages_properties_arrays);
646 646
 			//SO, if we found the stage data that was saved, use it. Otherwise, I guess the stage is new? (maybe added by
647 647
 			//an addon? Unlikely... not sure why it wouldn't exist, but if it doesn't just treat it like it was never started yet)
648
-			if($stage_data){
648
+			if ($stage_data) {
649 649
 				$stage->instantiate_from_array_of_properties($stage_data);
650 650
 			}
651 651
 		}
@@ -661,9 +661,9 @@  discard block
 block discarded – undo
661 661
 	 * @param array $migration_stage_data_arrays
662 662
 	 * @return null
663 663
 	 */
664
-	private function _find_migration_stage_data_with_classname($classname,$migration_stage_data_arrays){
665
-		foreach($migration_stage_data_arrays as $migration_stage_data_array){
666
-			if(isset($migration_stage_data_array['class']) && $migration_stage_data_array['class'] == $classname){
664
+	private function _find_migration_stage_data_with_classname($classname, $migration_stage_data_arrays) {
665
+		foreach ($migration_stage_data_arrays as $migration_stage_data_array) {
666
+			if (isset($migration_stage_data_array['class']) && $migration_stage_data_array['class'] == $classname) {
667 667
 				return $migration_stage_data_array;
668 668
 			}
669 669
 		}
@@ -679,8 +679,8 @@  discard block
 block discarded – undo
679 679
 	 * @return array where the first key is the plugin's slug, the 2nd is the version of that plugin
680 680
 	 * that will be updated to. Eg array('Core','4.1.0')
681 681
 	 */
682
-	public final function migrates_to_version(){
683
-		return EE_Data_Migration_Manager::instance()->script_migrates_to_version( get_class( $this ) );
682
+	public final function migrates_to_version() {
683
+		return EE_Data_Migration_Manager::instance()->script_migrates_to_version(get_class($this));
684 684
 	}
685 685
 
686 686
 
@@ -692,10 +692,10 @@  discard block
 block discarded – undo
692 692
 	 * Or 'Core' for core (non-addon).
693 693
 	 * @return string
694 694
 	 */
695
-	public function slug(){
695
+	public function slug() {
696 696
 		$migrates_to_version_info = $this->migrates_to_version();
697 697
 		//the slug is the first part of the array
698
-		return $migrates_to_version_info[ 'slug' ];
698
+		return $migrates_to_version_info['slug'];
699 699
 	}
700 700
 
701 701
 
@@ -709,7 +709,7 @@  discard block
 block discarded – undo
709 709
 	 * the database up so it can run), then you can set "A" to priority 3 or something.
710 710
 	 * @return int
711 711
 	 */
712
-	public function priority(){
712
+	public function priority() {
713 713
 		return $this->_priority;
714 714
 	}
715 715
 
@@ -722,18 +722,18 @@  discard block
 block discarded – undo
722 722
 	 * @param boolean $migrating
723 723
 	 * @return void
724 724
 	 */
725
-	public function set_migrating( $migrating = TRUE ){
725
+	public function set_migrating($migrating = TRUE) {
726 726
 		$this->_migrating = $migrating;
727 727
 	}
728 728
 
729 729
 	/**
730 730
 	 * Marks that we think this migration class can continue to migrate
731 731
 	 */
732
-	public function reattempt(){
732
+	public function reattempt() {
733 733
 		parent::reattempt();
734 734
 		//also, we want to reattempt any stages that were marked as borked
735
-		foreach( $this->stages() as $stage ) {
736
-			if( $stage->is_broken() ) {
735
+		foreach ($this->stages() as $stage) {
736
+			if ($stage->is_broken()) {
737 737
 				$stage->reattempt();
738 738
 			}
739 739
 		}
Please login to merge, or discard this patch.
core/data_migration_scripts/EE_Data_Migration_Script_Stage.core.php 1 patch
Spacing   +9 added lines, -9 removed lines patch added patch discarded remove patch
@@ -34,7 +34,7 @@  discard block
 block discarded – undo
34 34
  * _migration_step() (ie, it its a count of rows in the old attendees table in _count_records_to_migrate(), it should also be OLD attendee rows migrated
35 35
  * on each call to _migration_step().
36 36
  */
37
-abstract class EE_Data_Migration_Script_Stage extends EE_Data_Migration_Class_Base{
37
+abstract class EE_Data_Migration_Script_Stage extends EE_Data_Migration_Class_Base {
38 38
 	/**
39 39
 	 * The migration script this is a stage of
40 40
 	 * @var EE_Data_Migration_Script_Base
@@ -47,7 +47,7 @@  discard block
 block discarded – undo
47 47
 	 * called by EE_Data_Migration_Script_Base's __construct() method so children don't have to
48 48
 	 * @param EE_Data_Migration_Script_Base $migration_script
49 49
 	 */
50
-	public function _construct_finalize($migration_script){
50
+	public function _construct_finalize($migration_script) {
51 51
 		$this->_migration_script = $migration_script;
52 52
 	}
53 53
 
@@ -58,13 +58,13 @@  discard block
 block discarded – undo
58 58
 	 * @param int $num_items_to_migrate
59 59
 	 * @return int
60 60
 	 */
61
-	public function migration_step($num_items_to_migrate=50){
61
+	public function migration_step($num_items_to_migrate = 50) {
62 62
 		//before we run the migration step, we want ot take note of warnings that get outputted
63 63
 		ob_start();
64 64
 		$items_migrated = $this->_migration_step($num_items_to_migrate);
65 65
 		$output = ob_get_contents();
66 66
 		ob_end_clean();
67
-		if( $output ){
67
+		if ($output) {
68 68
 			$this->add_error($output);
69 69
 		}
70 70
 		$this->_records_migrated += $items_migrated;
@@ -82,7 +82,7 @@  discard block
 block discarded – undo
82 82
 	 * @param int $num_items_to_migrate
83 83
 	 * @return int number of items ACTUALLY migrated
84 84
 	 */
85
-	abstract protected function _migration_step($num_items_to_migrate=50);
85
+	abstract protected function _migration_step($num_items_to_migrate = 50);
86 86
 
87 87
 	/**
88 88
 	 * Counts the records that have been migrated so far
@@ -96,7 +96,7 @@  discard block
 block discarded – undo
96 96
 	 * returns an array of strings describing errors
97 97
 	 * @return array
98 98
 	 */
99
-	public function get_errors(){
99
+	public function get_errors() {
100 100
 		return $this->_errors;
101 101
 	}
102 102
 
@@ -106,9 +106,9 @@  discard block
 block discarded – undo
106 106
 	 * to have been made from the properties_as_array() function.
107 107
 	 * @param array $array_of_properties like what's produced from properties_as_array() method
108 108
 	 */
109
-	public function instantiate_from_array_of_properties($array_of_properties){
109
+	public function instantiate_from_array_of_properties($array_of_properties) {
110 110
 		unset($array_of_properties['class']);
111
-		foreach($array_of_properties as $property_name => $property_value){
111
+		foreach ($array_of_properties as $property_name => $property_value) {
112 112
 			$this->$property_name = $property_value;
113 113
 		}
114 114
 	}
@@ -117,7 +117,7 @@  discard block
 block discarded – undo
117 117
 	 * Gets the script this is a stage of
118 118
 	 * @return EE_Data_Migration_Script_Base
119 119
 	 */
120
-	protected function get_migration_script(){
120
+	protected function get_migration_script() {
121 121
 		return $this->_migration_script;
122 122
 	}
123 123
 }
Please login to merge, or discard this patch.