Completed
Branch BUG-9583-fix-fetching-term-rel... (646110)
by
unknown
539:15 queued 523:53
created
data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_org_options.dmsstage.php 4 patches
Doc Comments   -1 removed lines patch added patch discarded remove patch
@@ -245,7 +245,6 @@
 block discarded – undo
245 245
 	/**
246 246
 	 * Creates a 4.1 member price discount
247 247
 	 * @global type $wpdb
248
-	 * @param type $old_price
249 248
 	 * @return int
250 249
 	 */
251 250
 	private function _insert_new_global_surcharge_price($org_options){
Please login to merge, or discard this patch.
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -191,7 +191,7 @@
 block discarded – undo
191 191
 			  $c->organization->logo_url = $value;break;
192 192
 		  case 'event_page_id':
193 193
 
194
-			    //also, find that post, and changes the shortcode in it from ESPRESSO_PAYMENTS
194
+				//also, find that post, and changes the shortcode in it from ESPRESSO_PAYMENTS
195 195
 			  //to ESPRESSO_THANK_YOU
196 196
 			  $reg_page_post = get_post($value);
197 197
 			  $reg_page_post->post_content = str_replace("[ESPRESSO_EVENTS]","[ESPRESSO_CHECKOUT]",$reg_page_post->post_content);
Please login to merge, or discard this patch.
Spacing   +69 added lines, -69 removed lines patch added patch discarded remove patch
@@ -100,30 +100,30 @@  discard block
 block discarded – undo
100 100
  *
101 101
  * @todo: inform clients that messages have COMPLETELY changed in 4.1; themeroller isn't in there; event list page is no more;
102 102
  */
103
-class EE_DMS_4_1_0_org_options extends EE_Data_Migration_Script_Stage{
103
+class EE_DMS_4_1_0_org_options extends EE_Data_Migration_Script_Stage {
104 104
 
105
-	function _migration_step($num_items=50){
105
+	function _migration_step($num_items = 50) {
106 106
 
107 107
 		$items_actually_migrated = 0;
108 108
 		$old_org_options = get_option('events_organization_settings');
109
-		foreach($this->_org_options_we_know_how_to_migrate as $option_name){
109
+		foreach ($this->_org_options_we_know_how_to_migrate as $option_name) {
110 110
 			//only bother migrating if there's a setting to migrate. Otherwise we'll just use the default
111
-			if(isset($old_org_options[$option_name])){
111
+			if (isset($old_org_options[$option_name])) {
112 112
 				$this->_handle_org_option($option_name, $old_org_options[$option_name]);
113 113
 			}
114
-			if($option_name=='surcharge'){
114
+			if ($option_name == 'surcharge') {
115 115
 				$this->_insert_new_global_surcharge_price($old_org_options);
116 116
 			}
117 117
 			$items_actually_migrated++;
118 118
 		}
119 119
 
120
-		$success = EE_Config::instance()->update_espresso_config(FALSE,TRUE);
121
-		if( ! $success ) {
122
-			$this->add_error( sprintf( __( 'Could not save EE Config during org options stage. Reason: %s', 'event_espresso' ),  EE_Error::get_notices( FALSE )) );
120
+		$success = EE_Config::instance()->update_espresso_config(FALSE, TRUE);
121
+		if ( ! $success) {
122
+			$this->add_error(sprintf(__('Could not save EE Config during org options stage. Reason: %s', 'event_espresso'), EE_Error::get_notices(FALSE)));
123 123
 			EE_Error::overwrite_errors();
124 124
 		}
125
-		EE_Network_Config::instance()->update_config(FALSE,FALSE);
126
-		if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){
125
+		EE_Network_Config::instance()->update_config(FALSE, FALSE);
126
+		if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
127 127
 			//we may have added new pages and this might be necessary
128 128
 			flush_rewrite_rules();
129 129
 			$this->set_completed();
@@ -136,65 +136,65 @@  discard block
 block discarded – undo
136 136
 	}
137 137
 	function __construct() {
138 138
 		$this->_pretty_name = __("Organization Options/Config", "event_espresso");
139
-		$this->_org_options_we_know_how_to_migrate = apply_filters( 'FHEE__EE_DMS_4_1_0_org_options__org_options_we_know_how_to_migrate',$this->_org_options_we_know_how_to_migrate );
139
+		$this->_org_options_we_know_how_to_migrate = apply_filters('FHEE__EE_DMS_4_1_0_org_options__org_options_we_know_how_to_migrate', $this->_org_options_we_know_how_to_migrate);
140 140
 		parent::__construct();
141 141
 	}
142 142
 
143
-	private function _handle_org_option($option_name,$value){
143
+	private function _handle_org_option($option_name, $value) {
144 144
 		$c = EE_Config::instance();
145 145
 		$cn = EE_Network_Config::instance();
146
-		switch($option_name){
146
+		switch ($option_name) {
147 147
 		  case 'organization':
148
-			  $c->organization->name = $value;break;
148
+			  $c->organization->name = $value; break;
149 149
 		  case 'organization_street1':
150
-			  $c->organization->address_1 = $value;break;
150
+			  $c->organization->address_1 = $value; break;
151 151
 		  case 'organization_street2':
152
-			  $c->organization->address_2 = $value;break;
152
+			  $c->organization->address_2 = $value; break;
153 153
 		  case 'organization_city':
154
-			  $c->organization->city = $value;break;
154
+			  $c->organization->city = $value; break;
155 155
 		  case 'organization_state':
156
-			  try{
156
+			  try {
157 157
 			  $state = $this->get_migration_script()->get_or_create_state($value);
158 158
 			  $state_id = $state['STA_ID'];
159 159
 			  $c->organization->STA_ID = $state_id;
160
-			  }catch(EE_Error $e){}break;
160
+			  } catch (EE_Error $e) {}break;
161 161
 		  case 'organization_zip':
162
-			  $c->organization->zip = $value;break;
162
+			  $c->organization->zip = $value; break;
163 163
 		  case 'contact_email':
164
-			  $c->organization->email = $value;break;
164
+			  $c->organization->email = $value; break;
165 165
 		  case 'default_payment_status':
166
-			  $c->registration->default_STS_ID =  $this->get_migration_script()->convert_3_1_payment_status_to_4_1_STS_ID($value);break;
166
+			  $c->registration->default_STS_ID = $this->get_migration_script()->convert_3_1_payment_status_to_4_1_STS_ID($value); break;
167 167
 		  case 'organization_country':
168
-			  $iso =$this->get_migration_script()->get_iso_from_3_1_country_id($value);
168
+			  $iso = $this->get_migration_script()->get_iso_from_3_1_country_id($value);
169 169
 			  $c->organization->CNT_ISO = $iso;
170 170
 			  $country_row = $this->get_migration_script()->get_or_create_country($iso);
171
-			  if( ! $country_row){
172
-				  $this->add_error(sprintf(__("Could not set country's currency config because no country exists for ISO %s", "event_espresso"),$iso));
171
+			  if ( ! $country_row) {
172
+				  $this->add_error(sprintf(__("Could not set country's currency config because no country exists for ISO %s", "event_espresso"), $iso));
173 173
 			  }
174 174
 			  //can't use EE_Currency_Config's handy constructor because the models are off-limits right now (and it uses them)
175
-			$c->currency->code = $country_row['CNT_cur_code']; 			// currency code: USD, CAD, EUR
176
-			$c->currency->name = $country_row['CNT_cur_single'];	// Dollar
177
-			$c->currency->plural = $country_row['CNT_cur_plural']; 	// Dollars
178
-			$c->currency->sign =  $country_row['CNT_cur_sign']; 			// currency sign: $
179
-			$c->currency->sign_b4 = intval($country_row['CNT_cur_sign_b4']); 		// currency sign before or after: $TRUE  or  FALSE$
180
-			$c->currency->dec_plc = intval($country_row['CNT_cur_dec_plc']);	// decimal places: 2 = 0.00  3 = 0.000
181
-			$c->currency->dec_mrk = $country_row['CNT_cur_dec_mrk'];	// decimal mark: (comma) ',' = 0,01   or (decimal) '.' = 0.01
182
-			$c->currency->thsnds = $country_row['CNT_cur_thsnds'];	// thousands separator: (comma) ',' = 1,000   or (decimal) '.' = 1.000
175
+			$c->currency->code = $country_row['CNT_cur_code']; // currency code: USD, CAD, EUR
176
+			$c->currency->name = $country_row['CNT_cur_single']; // Dollar
177
+			$c->currency->plural = $country_row['CNT_cur_plural']; // Dollars
178
+			$c->currency->sign = $country_row['CNT_cur_sign']; // currency sign: $
179
+			$c->currency->sign_b4 = intval($country_row['CNT_cur_sign_b4']); // currency sign before or after: $TRUE  or  FALSE$
180
+			$c->currency->dec_plc = intval($country_row['CNT_cur_dec_plc']); // decimal places: 2 = 0.00  3 = 0.000
181
+			$c->currency->dec_mrk = $country_row['CNT_cur_dec_mrk']; // decimal mark: (comma) ',' = 0,01   or (decimal) '.' = 0.01
182
+			$c->currency->thsnds = $country_row['CNT_cur_thsnds']; // thousands separator: (comma) ',' = 1,000   or (decimal) '.' = 1.000
183 183
 //			  $c->currency = new EE_Currency_Config($c->organization->CNT_ISO);break;
184 184
 //		  case 'currency_symbol': ignore the currency symbol. we'll just go by their country.
185 185
 //			  $c->currency->sign = $value;break;
186 186
 		  case 'show_pending_payment_options':
187
-			  $c->registration->show_pending_payment_options = ($value == 'Y');break;
187
+			  $c->registration->show_pending_payment_options = ($value == 'Y'); break;
188 188
 		  case 'display_address_in_regform':
189
-			  $c->template_settings->display_address_in_regform = ($value == 'Y');break;
189
+			  $c->template_settings->display_address_in_regform = ($value == 'Y'); break;
190 190
 		  case 'default_logo_url':
191
-			  $c->organization->logo_url = $value;break;
191
+			  $c->organization->logo_url = $value; break;
192 192
 		  case 'event_page_id':
193 193
 
194 194
 			    //also, find that post, and changes the shortcode in it from ESPRESSO_PAYMENTS
195 195
 			  //to ESPRESSO_THANK_YOU
196 196
 			  $reg_page_post = get_post($value);
197
-			  $reg_page_post->post_content = str_replace("[ESPRESSO_EVENTS]","[ESPRESSO_CHECKOUT]",$reg_page_post->post_content);
197
+			  $reg_page_post->post_content = str_replace("[ESPRESSO_EVENTS]", "[ESPRESSO_CHECKOUT]", $reg_page_post->post_content);
198 198
 			  wp_update_post($reg_page_post);
199 199
 			  $c->core->reg_page_id = $value;
200 200
 			  break;
@@ -202,7 +202,7 @@  discard block
 block discarded – undo
202 202
 			  //also, find that post, and changes the shortcode in it from ESPRESSO_PAYMENTS
203 203
 			  //to ESPRESSO_THANK_YOU
204 204
 			  $thank_you_page_post = get_post($value);
205
-			  $thank_you_page_post->post_content = str_replace("[ESPRESSO_PAYMENTS]","[ESPRESSO_THANK_YOU]",$thank_you_page_post->post_content);
205
+			  $thank_you_page_post->post_content = str_replace("[ESPRESSO_PAYMENTS]", "[ESPRESSO_THANK_YOU]", $thank_you_page_post->post_content);
206 206
 			  wp_update_post($thank_you_page_post);
207 207
 			  $c->core->thank_you_page_id = $value;
208 208
 			   break;
@@ -216,15 +216,15 @@  discard block
 block discarded – undo
216 216
 		  case 'use_captcha':
217 217
 			  $c->registration->use_captcha = ($value == 'Y'); break;
218 218
 		  case 'recaptcha_publickey':
219
-			  $c->registration->recaptcha_publickey = $value;break;
219
+			  $c->registration->recaptcha_publickey = $value; break;
220 220
 		  case 'recaptcha_privatekey':
221
-			  $c->registration->recaptcha_privatekey = $value;break;
221
+			  $c->registration->recaptcha_privatekey = $value; break;
222 222
 		  case 'recaptcha_theme':
223
-			  $c->registration->recaptcha_theme = $value;break;
223
+			  $c->registration->recaptcha_theme = $value; break;
224 224
 		  case 'recaptcha_width':
225
-			  $c->registration->recaptcha_width = $value;break;
225
+			  $c->registration->recaptcha_width = $value; break;
226 226
 		  case 'recaptcha_language':
227
-			  $c->registration->recaptcha_language = $value;break;
227
+			  $c->registration->recaptcha_language = $value; break;
228 228
 		  case 'espresso_dashboard_widget':
229 229
 			  $c->admin->use_dashboard_widget = ($value == 'Y'); break;
230 230
 		  case 'use_personnel_manager':
@@ -232,13 +232,13 @@  discard block
 block discarded – undo
232 232
 		  case 'use_event_timezones':
233 233
 			  $c->admin->use_event_timezones = ($value == 'Y'); break;
234 234
 		  case 'full_logging':
235
-			  $c->admin->use_full_logging = ($value == 'Y');break;
235
+			  $c->admin->use_full_logging = ($value == 'Y'); break;
236 236
 		  case 'affiliate_id':
237
-			  $c->admin->affiliate_id = $value;break;
237
+			  $c->admin->affiliate_id = $value; break;
238 238
 		  case 'site_license_key':
239
-			  $cn->core->site_license_key = $value;break;
239
+			  $cn->core->site_license_key = $value; break;
240 240
 		  default:
241
-			  do_action( 'AHEE__EE_DMS_4_1_0__handle_org_option',$option_name,$value );
241
+			  do_action('AHEE__EE_DMS_4_1_0__handle_org_option', $option_name, $value);
242 242
 		}
243 243
 	}
244 244
 
@@ -248,15 +248,15 @@  discard block
 block discarded – undo
248 248
 	 * @param type $old_price
249 249
 	 * @return int
250 250
 	 */
251
-	private function _insert_new_global_surcharge_price($org_options){
251
+	private function _insert_new_global_surcharge_price($org_options) {
252 252
 		$amount = floatval($org_options['surcharge']);
253 253
 		//dont createa a price if the surcharge is 0
254
-		if($amount <=.01){
254
+		if ($amount <= .01) {
255 255
 			return 0;
256 256
 		}
257
-		if($org_options['surcharge_type'] == 'flat_rate'){
257
+		if ($org_options['surcharge_type'] == 'flat_rate') {
258 258
 			$price_type = EE_DMS_4_1_0_prices::price_type_flat_surcharge;
259
-		}else{
259
+		} else {
260 260
 			$price_type = EE_DMS_4_1_0_prices::price_type_percent_surcharge;
261 261
 		}
262 262
 		global $wpdb;
@@ -272,18 +272,18 @@  discard block
 block discarded – undo
272 272
 
273 273
 		);
274 274
 		$datatypes = array(
275
-			'%d',//PRT_ID
276
-			'%f',//PRT_amount
277
-			'%s',//PRC_name
278
-			'%d',//PRC_is_default
279
-			'%d',//PRC_overrides
280
-			'%d',//PRC_order
281
-			'%d',//PRC_deleted
282
-			'%d',//PRC_parent
275
+			'%d', //PRT_ID
276
+			'%f', //PRT_amount
277
+			'%s', //PRC_name
278
+			'%d', //PRC_is_default
279
+			'%d', //PRC_overrides
280
+			'%d', //PRC_order
281
+			'%d', //PRC_deleted
282
+			'%d', //PRC_parent
283 283
 		);
284 284
 		$price_table = $wpdb->prefix."esp_price";
285
-		$success = $wpdb->insert($price_table,$cols_n_values,$datatypes);
286
-		if ( ! $success){
285
+		$success = $wpdb->insert($price_table, $cols_n_values, $datatypes);
286
+		if ( ! $success) {
287 287
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion('org_options',
288 288
 					array(
289 289
 						'surcharge'=>$org_options['surcharge'],
@@ -308,8 +308,8 @@  discard block
 block discarded – undo
308 308
 	  'payment_message',
309 309
 	  'message',
310 310
 	  'default_payment_status',
311
-	  'surcharge',//unused?
312
-	  'country_id',//unused?
311
+	  'surcharge', //unused?
312
+	  'country_id', //unused?
313 313
 	  'organization_country',
314 314
 //	  'currency_symbol',
315 315
 	  'expire_on_registration_end',
@@ -321,13 +321,13 @@  discard block
 block discarded – undo
321 321
 	  'show_pending_payment_options',
322 322
 	  'show_reg_footer',
323 323
 	  'skip_confirmation_page',
324
-	  'allow_mer_discounts',//no equiv
325
-	  'allow_mer_vouchers',//no equiv
324
+	  'allow_mer_discounts', //no equiv
325
+	  'allow_mer_vouchers', //no equiv
326 326
 	  'display_short_description_in_event_list',
327 327
 	  'display_description_on_multi_reg_page',
328 328
 	  'display_address_in_event_list',
329 329
 	  'display_address_in_regform',
330
-	  'use_custom_post_types',//no equiv
330
+	  'use_custom_post_types', //no equiv
331 331
 	  'display_ical_download',
332 332
 	  'display_featured_image',
333 333
 	  'themeroller',
@@ -346,11 +346,11 @@  discard block
 block discarded – undo
346 346
 	  'espresso_dashboard_widget',
347 347
 	  'time_reg_limit',
348 348
 //	  'use_attendee_pre_approval', removed in 4.1- instead this is factored into the default reg status
349
-	  'use_personnel_manager',//no equiv
349
+	  'use_personnel_manager', //no equiv
350 350
 	  'use_event_timezones',
351 351
 	  'full_logging',
352
-	  'surcharge_type',//unused
353
-	  'surcharge_text',//unused
352
+	  'surcharge_type', //unused
353
+	  'surcharge_text', //unused
354 354
 	  'affiliate_id',
355 355
 	  'site_license_key',
356 356
 	);
Please login to merge, or discard this patch.
Braces   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -157,7 +157,7 @@  discard block
 block discarded – undo
157 157
 			  $state = $this->get_migration_script()->get_or_create_state($value);
158 158
 			  $state_id = $state['STA_ID'];
159 159
 			  $c->organization->STA_ID = $state_id;
160
-			  }catch(EE_Error $e){}break;
160
+			  } catch(EE_Error $e){}break;
161 161
 		  case 'organization_zip':
162 162
 			  $c->organization->zip = $value;break;
163 163
 		  case 'contact_email':
@@ -256,7 +256,7 @@  discard block
 block discarded – undo
256 256
 		}
257 257
 		if($org_options['surcharge_type'] == 'flat_rate'){
258 258
 			$price_type = EE_DMS_4_1_0_prices::price_type_flat_surcharge;
259
-		}else{
259
+		} else{
260 260
 			$price_type = EE_DMS_4_1_0_prices::price_type_percent_surcharge;
261 261
 		}
262 262
 		global $wpdb;
Please login to merge, or discard this patch.
core/data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_prices.dmsstage.php 3 patches
Doc Comments   +3 added lines, -4 removed lines patch added patch discarded remove patch
@@ -345,8 +345,8 @@  discard block
 block discarded – undo
345 345
 	/**
346 346
 	 * Adds a join between a ticket and a price
347 347
 	 * @global type $wpdb
348
-	 * @param type $new_ticket_id
349
-	 * @param type $new_price_id
348
+	 * @param integer $new_ticket_id
349
+	 * @param integer $new_price_id
350 350
 	 * @return int
351 351
 	 */
352 352
 	private function _insert_ticket_price_relation($new_ticket_id,$new_price_id){
@@ -371,8 +371,7 @@  discard block
 block discarded – undo
371 371
 	/**
372 372
 	 * Adds a join between a ticket and a datetime
373 373
 	 * @global type $wpdb
374
-	 * @param type $new_ticket_id
375
-	 * @param type $new_price_id
374
+	 * @param integer $new_ticket_id
376 375
 	 * @return int
377 376
 	 */
378 377
 	private function _insert_datetime_ticket_relation($new_datetime_id,$new_ticket_id){
Please login to merge, or discard this patch.
Spacing   +74 added lines, -74 removed lines patch added patch discarded remove patch
@@ -86,7 +86,7 @@  discard block
 block discarded – undo
86 86
 			));
87 87
  */
88 88
 
89
-class EE_DMS_4_1_0_prices extends EE_Data_Migration_Script_Stage_Table{
89
+class EE_DMS_4_1_0_prices extends EE_Data_Migration_Script_Stage_Table {
90 90
 	private $_new_price_table;
91 91
 	private $_new_ticket_table;
92 92
 	private $_new_ticket_price_table;
@@ -122,10 +122,10 @@  discard block
 block discarded – undo
122 122
 //			$member_price_discount_id = 0;
123 123
 //		}
124 124
 		//create the surcharge if there is any
125
-		if(floatval($old_row['surcharge']) >= 0.01){
125
+		if (floatval($old_row['surcharge']) >= 0.01) {
126 126
 			$surcharge_price_id = $this->_insert_new_surcharge_price($old_row);
127
-			$this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_price_table, array($new_price_id,$surcharge_price_id));
128
-		}else{
127
+			$this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_price_table, array($new_price_id, $surcharge_price_id));
128
+		} else {
129 129
 			$surcharge_price_id = 0;
130 130
 			$this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_price_table, array($new_price_id));
131 131
 		}
@@ -145,7 +145,7 @@  discard block
 block discarded – undo
145 145
 //		}
146 146
 		//create a ticket for each old price -old datetime combo
147 147
 		$tickets_for_old_price = array();
148
-		foreach($this->_get_datetime_ids_for_old_event_id($old_row['event_id']) as $new_datetime_id){
148
+		foreach ($this->_get_datetime_ids_for_old_event_id($old_row['event_id']) as $new_datetime_id) {
149 149
 			$ticket_id = $this->_insert_new_ticket($old_row);
150 150
 			$tickets_for_old_price[] = $ticket_id;
151 151
 			//associate to old prices
@@ -162,7 +162,7 @@  discard block
 block discarded – undo
162 162
 	 * @param type $old_price
163 163
 	 * @return int
164 164
 	 */
165
-	private function _insert_new_price($old_price){
165
+	private function _insert_new_price($old_price) {
166 166
 		global $wpdb;
167 167
 		$cols_n_values = array(
168 168
 			'PRT_ID'=>self::price_type_base,
@@ -176,17 +176,17 @@  discard block
 block discarded – undo
176 176
 
177 177
 		);
178 178
 		$datatypes = array(
179
-			'%d',//PRT_ID
180
-			'%f',//PRT_amount
181
-			'%s',//PRC_name
182
-			'%d',//PRC_is_default
183
-			'%d',//PRC_overrides
184
-			'%d',//PRC_order
185
-			'%d',//PRC_deleted
186
-			'%d',//PRC_parent
179
+			'%d', //PRT_ID
180
+			'%f', //PRT_amount
181
+			'%s', //PRC_name
182
+			'%d', //PRC_is_default
183
+			'%d', //PRC_overrides
184
+			'%d', //PRC_order
185
+			'%d', //PRC_deleted
186
+			'%d', //PRC_parent
187 187
 		);
188
-		$success = $wpdb->insert($this->_new_price_table,$cols_n_values,$datatypes);
189
-		if ( ! $success){
188
+		$success = $wpdb->insert($this->_new_price_table, $cols_n_values, $datatypes);
189
+		if ( ! $success) {
190 190
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_price, $this->_new_price_table, $cols_n_values, $datatypes));
191 191
 			return 0;
192 192
 		}
@@ -237,11 +237,11 @@  discard block
 block discarded – undo
237 237
 	 * @param type $old_price
238 238
 	 * @return int
239 239
 	 */
240
-	private function _insert_new_surcharge_price($old_price){
240
+	private function _insert_new_surcharge_price($old_price) {
241 241
 
242
-		if($old_price['surcharge_type'] == 'flat_rate'){
242
+		if ($old_price['surcharge_type'] == 'flat_rate') {
243 243
 			$price_type = self::price_type_flat_surcharge;
244
-		}else{
244
+		} else {
245 245
 			$price_type = self::price_type_percent_surcharge;
246 246
 		}
247 247
 		global $wpdb;
@@ -257,17 +257,17 @@  discard block
 block discarded – undo
257 257
 
258 258
 		);
259 259
 		$datatypes = array(
260
-			'%d',//PRT_ID
261
-			'%f',//PRT_amount
262
-			'%s',//PRC_name
263
-			'%d',//PRC_is_default
264
-			'%d',//PRC_overrides
265
-			'%d',//PRC_order
266
-			'%d',//PRC_deleted
267
-			'%d',//PRC_parent
260
+			'%d', //PRT_ID
261
+			'%f', //PRT_amount
262
+			'%s', //PRC_name
263
+			'%d', //PRC_is_default
264
+			'%d', //PRC_overrides
265
+			'%d', //PRC_order
266
+			'%d', //PRC_deleted
267
+			'%d', //PRC_parent
268 268
 		);
269
-		$success = $wpdb->insert($this->_new_price_table,$cols_n_values,$datatypes);
270
-		if ( ! $success){
269
+		$success = $wpdb->insert($this->_new_price_table, $cols_n_values, $datatypes);
270
+		if ( ! $success) {
271 271
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_price, $this->_new_price_table, $cols_n_values, $datatypes));
272 272
 			return 0;
273 273
 		}
@@ -282,18 +282,18 @@  discard block
 block discarded – undo
282 282
 	 * @param $new_surcharge_id int
283 283
 	 * @return int new ticket id
284 284
 	 */
285
-	private function _insert_new_ticket($old_price_row){
285
+	private function _insert_new_ticket($old_price_row) {
286 286
 		global $wpdb;
287 287
 		$event_row = $this->_get_event_row($old_price_row['event_id']);
288
-		if($old_price_row['surcharge_type'] == 'flat_rate'){
288
+		if ($old_price_row['surcharge_type'] == 'flat_rate') {
289 289
 			$final_ticket_price = floatval($old_price_row['event_cost']) + floatval($old_price_row['surcharge']);
290
-		}else{//percent surcharge
291
-			$final_ticket_price = floatval($old_price_row['event_cost']) * (1 + floatval($old_price_row['surcharge'])/100);
290
+		} else {//percent surcharge
291
+			$final_ticket_price = floatval($old_price_row['event_cost']) * (1 + floatval($old_price_row['surcharge']) / 100);
292 292
 		}
293 293
 		$start_date = $event_row['registration_start']." ".$this->get_migration_script()->convertTimeFromAMPM($event_row['registration_startT']);
294
-		$start_date_utc = $this->get_migration_script()->convert_date_string_to_utc($this,$old_price_row,$start_date,$event_row['timezone_string']);
294
+		$start_date_utc = $this->get_migration_script()->convert_date_string_to_utc($this, $old_price_row, $start_date, $event_row['timezone_string']);
295 295
 		$end_date = $event_row['registration_end']." ".$this->get_migration_script()->convertTimeFromAMPM($event_row['registration_endT']);
296
-		$end_date_utc = $this->get_migration_script()->convert_date_string_to_utc($this,$old_price_row,$end_date,$event_row['timezone_string']);
296
+		$end_date_utc = $this->get_migration_script()->convert_date_string_to_utc($this, $old_price_row, $end_date, $event_row['timezone_string']);
297 297
 		$cols_n_values = array(
298 298
 			'TTM_ID'=>0,
299 299
 			'TKT_name'=>$old_price_row['price_type'],
@@ -303,38 +303,38 @@  discard block
 block discarded – undo
303 303
 			'TKT_min'=>0,
304 304
 			'TKT_max'=>-1,
305 305
 			'TKT_price'=>$final_ticket_price,
306
-			'TKT_sold'=> 0,//note: this will get calculated as we actually add registrations during the migration
306
+			'TKT_sold'=> 0, //note: this will get calculated as we actually add registrations during the migration
307 307
 			'TKT_qty'=> -1,
308 308
 			'TKT_uses'=> 1,
309
-			'TKT_taxable'=>false,//so by default, old prices are NOT taxable. This way they don't suddenly have a sudden spike in prices
309
+			'TKT_taxable'=>false, //so by default, old prices are NOT taxable. This way they don't suddenly have a sudden spike in prices
310 310
 			'TKT_is_default'=>false,
311 311
 			'TKT_order'=>$this->_get_ticket_count(),
312
-			'TKT_row'=>0,//doesn't matter because UI reset this on first save anyways
312
+			'TKT_row'=>0, //doesn't matter because UI reset this on first save anyways
313 313
 			'TKT_deleted'=>false,
314 314
 			'TKT_parent'=>0
315 315
 
316 316
 		);
317 317
 		$datatypes = array(
318
-			'%d',//TTM_ID
319
-			'%s',//TKT_name
320
-			'%s',//TKT_description
321
-			'%s',//TKT_start_date
322
-			'%s',//TKT_end_date
323
-			'%d',//TKT_min
324
-			'%d',//TKT_max
325
-			'%f',//TKT_price
326
-			'%d',//TKT_sold
327
-			'%d',//TKT_qty
328
-			'%d',//TKT_uses
329
-			'%d',//TKT_taxable
330
-			'%d',//TKT_is_default
331
-			'%d',//TKT_order
332
-			'%d',//TKT_row
333
-			'%d',//TKT_deleted
334
-			'%d',//TKT_parent
318
+			'%d', //TTM_ID
319
+			'%s', //TKT_name
320
+			'%s', //TKT_description
321
+			'%s', //TKT_start_date
322
+			'%s', //TKT_end_date
323
+			'%d', //TKT_min
324
+			'%d', //TKT_max
325
+			'%f', //TKT_price
326
+			'%d', //TKT_sold
327
+			'%d', //TKT_qty
328
+			'%d', //TKT_uses
329
+			'%d', //TKT_taxable
330
+			'%d', //TKT_is_default
331
+			'%d', //TKT_order
332
+			'%d', //TKT_row
333
+			'%d', //TKT_deleted
334
+			'%d', //TKT_parent
335 335
 		);
336
-		$success = $wpdb->insert($this->_new_ticket_table,$cols_n_values,$datatypes);
337
-		if ( ! $success){
336
+		$success = $wpdb->insert($this->_new_ticket_table, $cols_n_values, $datatypes);
337
+		if ( ! $success) {
338 338
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_price_row, $this->_new_ticket_table, $cols_n_values, $datatypes));
339 339
 			return 0;
340 340
 		}
@@ -349,19 +349,19 @@  discard block
 block discarded – undo
349 349
 	 * @param type $new_price_id
350 350
 	 * @return int
351 351
 	 */
352
-	private function _insert_ticket_price_relation($new_ticket_id,$new_price_id){
352
+	private function _insert_ticket_price_relation($new_ticket_id, $new_price_id) {
353 353
 		global $wpdb;
354 354
 		$cols_n_values = array(
355 355
 			'TKT_ID'=>$new_ticket_id,
356 356
 			'PRC_ID'=>$new_price_id,
357 357
 		);
358 358
 		$datatypes = array(
359
-			'%d',//TKT_ID
360
-			'%d',//PRC_ID
359
+			'%d', //TKT_ID
360
+			'%d', //PRC_ID
361 361
 		);
362
-		$success = $wpdb->insert($this->_new_ticket_price_table,$cols_n_values,$datatypes);
363
-		if ( ! $success){
364
-			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, array('ticket id'=>$new_ticket_id,'price id'=>$new_price_id), $this->_new_ticket_price_table, $cols_n_values, $datatypes));
362
+		$success = $wpdb->insert($this->_new_ticket_price_table, $cols_n_values, $datatypes);
363
+		if ( ! $success) {
364
+			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, array('ticket id'=>$new_ticket_id, 'price id'=>$new_price_id), $this->_new_ticket_price_table, $cols_n_values, $datatypes));
365 365
 			return 0;
366 366
 		}
367 367
 		$new_id = $wpdb->insert_id;
@@ -375,19 +375,19 @@  discard block
 block discarded – undo
375 375
 	 * @param type $new_price_id
376 376
 	 * @return int
377 377
 	 */
378
-	private function _insert_datetime_ticket_relation($new_datetime_id,$new_ticket_id){
378
+	private function _insert_datetime_ticket_relation($new_datetime_id, $new_ticket_id) {
379 379
 		global $wpdb;
380 380
 		$cols_n_values = array(
381 381
 			'TKT_ID'=>$new_ticket_id,
382 382
 			'DTT_ID'=>$new_datetime_id,
383 383
 		);
384 384
 		$datatypes = array(
385
-			'%d',//TKT_ID
386
-			'%d',//DTT_ID
385
+			'%d', //TKT_ID
386
+			'%d', //DTT_ID
387 387
 		);
388
-		$success = $wpdb->insert($this->_new_datetime_ticket_table,$cols_n_values,$datatypes);
389
-		if ( ! $success){
390
-			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, array('ticket id'=>$new_ticket_id,'datetime id'=>$new_datetime_id), $this->_new_datetime_ticket_table, $cols_n_values, $datatypes));
388
+		$success = $wpdb->insert($this->_new_datetime_ticket_table, $cols_n_values, $datatypes);
389
+		if ( ! $success) {
390
+			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, array('ticket id'=>$new_ticket_id, 'datetime id'=>$new_datetime_id), $this->_new_datetime_ticket_table, $cols_n_values, $datatypes));
391 391
 			return 0;
392 392
 		}
393 393
 		$new_id = $wpdb->insert_id;
@@ -400,17 +400,17 @@  discard block
 block discarded – undo
400 400
 	 * @param type $event_id
401 401
 	 * @return array
402 402
 	 */
403
-	private function _get_event_row($event_id){
403
+	private function _get_event_row($event_id) {
404 404
 		global $wpdb;
405 405
 		$old_event_table = $wpdb->prefix."events_detail";
406
-		return $wpdb->get_row($wpdb->prepare("SELECT * FROM $old_event_table WHERE id=%d",$event_id),ARRAY_A);
406
+		return $wpdb->get_row($wpdb->prepare("SELECT * FROM $old_event_table WHERE id=%d", $event_id), ARRAY_A);
407 407
 	}
408 408
 	/**
409 409
 	 * Gets a higher ticket count than last time it was called (and is persisted between HTTP requests).
410 410
 	 * Yes we COULD run a query joining events->datetimes->ticket_datetimes->tickets, but this should work fine too
411 411
 	 * @return int
412 412
 	 */
413
-	private function _get_ticket_count(){
413
+	private function _get_ticket_count() {
414 414
 		return $this->_ticket_count++;
415 415
 	}
416 416
 
@@ -419,10 +419,10 @@  discard block
 block discarded – undo
419 419
 	 * @param int $old_event_id
420 420
 	 * @return array where values are datetime ids
421 421
 	 */
422
-	private function _get_datetime_ids_for_old_event_id($old_event_id){
422
+	private function _get_datetime_ids_for_old_event_id($old_event_id) {
423 423
 		global $wpdb;
424 424
 		$new_cpt_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_detail", $old_event_id, $wpdb->posts);
425
-		$datetime_ids = $wpdb->get_col($wpdb->prepare("SELECT DTT_ID FROM {$wpdb->prefix}esp_datetime WHERE EVT_ID=%d",$new_cpt_id));
425
+		$datetime_ids = $wpdb->get_col($wpdb->prepare("SELECT DTT_ID FROM {$wpdb->prefix}esp_datetime WHERE EVT_ID=%d", $new_cpt_id));
426 426
 		return $datetime_ids;
427 427
 	}
428 428
 }
Please login to merge, or discard this patch.
Braces   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -125,7 +125,7 @@  discard block
 block discarded – undo
125 125
 		if(floatval($old_row['surcharge']) >= 0.01){
126 126
 			$surcharge_price_id = $this->_insert_new_surcharge_price($old_row);
127 127
 			$this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_price_table, array($new_price_id,$surcharge_price_id));
128
-		}else{
128
+		} else{
129 129
 			$surcharge_price_id = 0;
130 130
 			$this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_price_table, array($new_price_id));
131 131
 		}
@@ -241,7 +241,7 @@  discard block
 block discarded – undo
241 241
 
242 242
 		if($old_price['surcharge_type'] == 'flat_rate'){
243 243
 			$price_type = self::price_type_flat_surcharge;
244
-		}else{
244
+		} else{
245 245
 			$price_type = self::price_type_percent_surcharge;
246 246
 		}
247 247
 		global $wpdb;
@@ -287,7 +287,7 @@  discard block
 block discarded – undo
287 287
 		$event_row = $this->_get_event_row($old_price_row['event_id']);
288 288
 		if($old_price_row['surcharge_type'] == 'flat_rate'){
289 289
 			$final_ticket_price = floatval($old_price_row['event_cost']) + floatval($old_price_row['surcharge']);
290
-		}else{//percent surcharge
290
+		} else{//percent surcharge
291 291
 			$final_ticket_price = floatval($old_price_row['event_cost']) * (1 + floatval($old_price_row['surcharge'])/100);
292 292
 		}
293 293
 		$start_date = $event_row['registration_start']." ".$this->get_migration_script()->convertTimeFromAMPM($event_row['registration_startT']);
Please login to merge, or discard this patch.
4_1_0_stages/EE_DMS_4_1_0_question_group_question.dmsstage.php 4 patches
Doc Comments   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -126,7 +126,7 @@
 block discarded – undo
126 126
 	 * being address info, and 0 being neither)
127 127
 	 * @global type $wpdb
128 128
 	 * @param type $new_question_group_id
129
-	 * @return boolean
129
+	 * @return integer
130 130
 	 */
131 131
 	private function _is_system_question_group($new_question_group_id){
132 132
 		global $wpdb;
Please login to merge, or discard this patch.
Indentation   -2 removed lines patch added patch discarded remove patch
@@ -12,8 +12,6 @@
 block discarded – undo
12 12
   KEY `group_id` (`group_id`),
13 13
   KEY `question_id` (`question_id`)
14 14
 ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8$$
15
-
16
-
17 15
  * 4.1 question group question model's tables and fields:
18 16
  $this->_tables = array(
19 17
 			'Question_Group_Question'=>new EE_Primary_Table('esp_question_group_question','QGQ_ID')
Please login to merge, or discard this patch.
Spacing   +25 added lines, -25 removed lines patch added patch discarded remove patch
@@ -27,20 +27,20 @@  discard block
 block discarded – undo
27 27
 		);
28 28
  * 
29 29
  */
30
-class EE_DMS_4_1_0_question_group_question extends EE_Data_Migration_Script_Stage{
30
+class EE_DMS_4_1_0_question_group_question extends EE_Data_Migration_Script_Stage {
31 31
 	private $_old_table;
32 32
 	private $_new_table;
33
-	function _migration_step($num_items=50){
33
+	function _migration_step($num_items = 50) {
34 34
 		
35 35
 		global $wpdb;
36 36
 		$start_at_record = $this->count_records_migrated();
37
-		$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A);
37
+		$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A);
38 38
 		$items_actually_migrated = 0;
39
-		foreach($rows as $question_group_question){
39
+		foreach ($rows as $question_group_question) {
40 40
 			$this->_insert_new_question_group_question($question_group_question);
41 41
 			$items_actually_migrated++;
42 42
 		}
43
-		if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){
43
+		if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
44 44
 			$this->set_completed();
45 45
 		}
46 46
 		return $items_actually_migrated;
@@ -64,39 +64,39 @@  discard block
 block discarded – undo
64 64
 	 * @param array $old_question_group_question
65 65
 	 * @return int
66 66
 	 */
67
-	private function _insert_new_question_group_question($old_question_group_question){
67
+	private function _insert_new_question_group_question($old_question_group_question) {
68 68
 		global $wpdb;
69 69
 		$new_question_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_question", $old_question_group_question['question_id'], $wpdb->prefix."esp_question");
70 70
 		$new_question_group_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_qst_group", $old_question_group_question['group_id'], $wpdb->prefix."esp_question_group");
71
-		if( ! $new_question_id){
72
-			$this->add_error(sprintf(__("Could not find 4.1 question id for 3.1 question #%d.", "event_espresso"),$old_question_group_question['question_id']));
71
+		if ( ! $new_question_id) {
72
+			$this->add_error(sprintf(__("Could not find 4.1 question id for 3.1 question #%d.", "event_espresso"), $old_question_group_question['question_id']));
73 73
 			return 0;
74 74
 		}
75
-		if( ! $new_question_group_id){
76
-			$this->add_error(sprintf(__("Could not find 4.1 question group id for 3.1 question group #%d.", "event_espresso"),$old_question_group_question['group_id']));
75
+		if ( ! $new_question_group_id) {
76
+			$this->add_error(sprintf(__("Could not find 4.1 question group id for 3.1 question group #%d.", "event_espresso"), $old_question_group_question['group_id']));
77 77
 			return 0;
78 78
 		}
79 79
 		//if it's a system question, it needs to be in the right system group. otherwise no dice!
80
-		if(
81
-				($this->_is_system_question_group($new_question_group_id) == $this->_is_system_question_for_question_group($new_question_id) )
80
+		if (
81
+				($this->_is_system_question_group($new_question_group_id) == $this->_is_system_question_for_question_group($new_question_id))
82 82
 				||
83 83
 				! $this->_is_system_question_for_question_group($new_question_id)
84
-			){
84
+			) {
85 85
 			$cols_n_values = array(
86 86
 				'QSG_ID'=>$new_question_group_id,
87 87
 				'QST_ID'=>$new_question_id
88 88
 			);
89 89
 			$datatypes = array(
90
-				'%d',//QSG_ID
91
-				'%d',//QST_ID
90
+				'%d', //QSG_ID
91
+				'%d', //QST_ID
92 92
 			);
93
-			$success = $wpdb->insert($this->_new_table,$cols_n_values,$datatypes);
94
-			if ( ! $success){
93
+			$success = $wpdb->insert($this->_new_table, $cols_n_values, $datatypes);
94
+			if ( ! $success) {
95 95
 				$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_question_group_question, $this->_new_table, $cols_n_values, $datatypes));
96 96
 				return 0;
97 97
 			}
98 98
 			return $wpdb->insert_id;
99
-		}else{
99
+		} else {
100 100
 			return false;
101 101
 		}
102 102
 		
@@ -109,14 +109,14 @@  discard block
 block discarded – undo
109 109
 	 * @param type $new_question_id
110 110
 	 * @return int
111 111
 	 */
112
-	private function _is_system_question_for_question_group($new_question_id){
112
+	private function _is_system_question_for_question_group($new_question_id) {
113 113
 		global $wpdb;
114
-		$system_id = $wpdb->get_var($wpdb->prepare("SELECT QST_system FROM ".$wpdb->prefix."esp_question WHERE QST_ID=%d",$new_question_id));
115
-		if(in_array($system_id, array('fname','lname','email'))){
114
+		$system_id = $wpdb->get_var($wpdb->prepare("SELECT QST_system FROM ".$wpdb->prefix."esp_question WHERE QST_ID=%d", $new_question_id));
115
+		if (in_array($system_id, array('fname', 'lname', 'email'))) {
116 116
 			return 1;
117
-		}elseif($system_id!='' && $system_id){
117
+		}elseif ($system_id != '' && $system_id) {
118 118
 			return 2;
119
-		}else{
119
+		} else {
120 120
 			return 0;
121 121
 		}
122 122
 	}
@@ -128,9 +128,9 @@  discard block
 block discarded – undo
128 128
 	 * @param type $new_question_group_id
129 129
 	 * @return boolean
130 130
 	 */
131
-	private function _is_system_question_group($new_question_group_id){
131
+	private function _is_system_question_group($new_question_group_id) {
132 132
 		global $wpdb;
133
-		$system_id = $wpdb->get_var($wpdb->prepare("SELECT QSG_system FROM ".$wpdb->prefix."esp_question_group WHERE QSG_ID=%d",$new_question_group_id));
133
+		$system_id = $wpdb->get_var($wpdb->prepare("SELECT QSG_system FROM ".$wpdb->prefix."esp_question_group WHERE QSG_ID=%d", $new_question_group_id));
134 134
 		return intval($system_id);
135 135
 	}
136 136
 
Please login to merge, or discard this patch.
Braces   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -96,7 +96,7 @@  discard block
 block discarded – undo
96 96
 				return 0;
97 97
 			}
98 98
 			return $wpdb->insert_id;
99
-		}else{
99
+		} else{
100 100
 			return false;
101 101
 		}
102 102
 		
@@ -114,9 +114,9 @@  discard block
 block discarded – undo
114 114
 		$system_id = $wpdb->get_var($wpdb->prepare("SELECT QST_system FROM ".$wpdb->prefix."esp_question WHERE QST_ID=%d",$new_question_id));
115 115
 		if(in_array($system_id, array('fname','lname','email'))){
116 116
 			return 1;
117
-		}elseif($system_id!='' && $system_id){
117
+		} elseif($system_id!='' && $system_id){
118 118
 			return 2;
119
-		}else{
119
+		} else{
120 120
 			return 0;
121 121
 		}
122 122
 	}
Please login to merge, or discard this patch.
core/data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_venues.dmsstage.php 3 patches
Doc Comments   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -196,7 +196,7 @@
 block discarded – undo
196 196
 
197 197
 	/**
198 198
 	 * Inserts into the venue_meta table
199
-	 * @param type $cpt_id
199
+	 * @param integer $cpt_id
200 200
 	 * @param type $old_venue
201 201
 	 * @return int
202 202
 	 */
Please login to merge, or discard this patch.
Braces   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -206,7 +206,7 @@  discard block
 block discarded – undo
206 206
 		try{
207 207
 			$country = $this->get_migration_script()->get_or_create_country(stripslashes($old_venue['country']));
208 208
 			$country_iso = $country['CNT_ISO'];
209
-		}catch(EE_Error $e){
209
+		} catch(EE_Error $e){
210 210
 			$this->add_error(sprintf(__("%s for venue %s", "event_espresso"),$e->getMessage(),$this->_json_encode($old_venue)));
211 211
 			$country_iso = null;
212 212
 		}
@@ -214,7 +214,7 @@  discard block
 block discarded – undo
214 214
 		try{
215 215
 			$state = $this->get_migration_script()->get_or_create_state(stripslashes($old_venue['state']),isset($country['CNT_name']) ? $country['CNT_name'] : strip_tags($old_venue['country']));
216 216
 			$state_id = $state['STA_ID'];
217
-		}catch(EE_Error $e){
217
+		} catch(EE_Error $e){
218 218
 			$this->add_error(sprintf(__("%s for venue %s", "event_espresso"),$e->getMessage(),$this->_json_encode($old_venue)));
219 219
 			$state_id = 0;
220 220
 		}
Please login to merge, or discard this patch.
Spacing   +79 added lines, -79 removed lines patch added patch discarded remove patch
@@ -61,44 +61,44 @@  discard block
 block discarded – undo
61 61
 //			));
62 62
  *
63 63
  */
64
-class EE_DMS_4_1_0_venues extends EE_Data_Migration_Script_Stage{
64
+class EE_DMS_4_1_0_venues extends EE_Data_Migration_Script_Stage {
65 65
 	private $_old_table;
66 66
 	private $_new_table;
67 67
 	private $_new_meta_table;
68
-function _migration_step($num_items=50){
68
+function _migration_step($num_items = 50) {
69 69
 	global $wpdb;
70 70
 	$start_at_record = $this->count_records_migrated();
71
-	$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM ".$this->_old_table." LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A);
71
+	$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM ".$this->_old_table." LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A);
72 72
 	$items_actually_migrated = 0;
73
-	foreach($rows as $old_venue){
74
-		if ( ! $new_id = $this->_insert_into_posts($old_venue)){
73
+	foreach ($rows as $old_venue) {
74
+		if ( ! $new_id = $this->_insert_into_posts($old_venue)) {
75 75
 			$items_actually_migrated++;
76 76
 			continue;
77 77
 		}
78 78
 		$this->get_migration_script()->set_mapping($this->_old_table, $old_venue['id'], $this->_new_table, $new_id);
79
-		if( ! $new_meta_id = $this->_insert_into_meta_table($new_id,$old_venue)){
79
+		if ( ! $new_meta_id = $this->_insert_into_meta_table($new_id, $old_venue)) {
80 80
 			$items_actually_migrated++;
81 81
 			continue;
82 82
 		}
83 83
 		$this->get_migration_script()->set_mapping($this->_old_table, $old_venue['id'], $this->_new_meta_table, $new_meta_id);
84 84
 		//lastly, save the 'contact' as post meta, because it doesn't exist anywhere else but someone may still want it
85 85
 		$venue_meta = maybe_unserialize($old_venue['meta']);
86
-		if(isset($venue_meta['contact']) && $venue_meta['contact']){
87
-			add_post_meta($new_id,'contact',$venue_meta['contact']);
86
+		if (isset($venue_meta['contact']) && $venue_meta['contact']) {
87
+			add_post_meta($new_id, 'contact', $venue_meta['contact']);
88 88
 		}
89 89
 		//is there an image on this venue?
90 90
 		$guid = isset($venue_meta['image']) && $venue_meta['image'] ? $venue_meta['image'] : NULL;
91
-		if($guid){
92
-			$this->get_migration_script()->convert_image_url_to_attachment_and_attach_to_post($guid,$new_id,$this);
91
+		if ($guid) {
92
+			$this->get_migration_script()->convert_image_url_to_attachment_and_attach_to_post($guid, $new_id, $this);
93 93
 		}
94 94
 		$items_actually_migrated++;
95
-		if($guid){
95
+		if ($guid) {
96 96
 			//if there was an image, we may have had to download it etc and it may have taken
97 97
 			//longer, then let's not bother migrating anymore on this step
98 98
 			break;
99 99
 		}
100 100
 	}
101
-	if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){
101
+	if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
102 102
 		$this->set_completed();
103 103
 	}
104 104
 	return $items_actually_migrated;
@@ -122,42 +122,42 @@  discard block
 block discarded – undo
122 122
 	 * @param array $old_venue keys are cols, values are col values
123 123
 	 * @return int
124 124
 	 */
125
-	private function _insert_into_posts($old_venue){
125
+	private function _insert_into_posts($old_venue) {
126 126
 		global $wpdb;
127 127
 		$meta = maybe_unserialize($old_venue['meta']);
128
-		$slug = $this->_find_unique_slug( $old_venue[ 'name' ], $old_venue[ 'identifier' ] );
128
+		$slug = $this->_find_unique_slug($old_venue['name'], $old_venue['identifier']);
129 129
 		$insertion_array = array(
130
-					'post_title'=>stripslashes($old_venue['name']),//VNU_name
131
-					'post_content'=>isset($meta['description']) ? stripslashes(strip_tags($meta['description'])) : '',//VNU_desc
132
-					'post_name'=> $slug,//VNU_identifier
133
-					'post_date'=>current_time('mysql'),//VNU_created
134
-					'post_date_gmt'=>  current_time('mysql',true),
135
-					'post_excerpt'=>'',//wp_trim_words($meta['description'] ? $meta['description'] : '',50),//VNU_short_desc arbitraty only 50 characters
136
-					'post_modified'=>current_time('mysql'),//VNU_modified
137
-					'post_modified_gmt'=>current_time('mysql',true),
138
-					'post_author'=>$old_venue['wp_user'],//VNU_wp_user
139
-					'post_parent'=>0,//parent
140
-					'menu_order'=>0,//VNU_order
130
+					'post_title'=>stripslashes($old_venue['name']), //VNU_name
131
+					'post_content'=>isset($meta['description']) ? stripslashes(strip_tags($meta['description'])) : '', //VNU_desc
132
+					'post_name'=> $slug, //VNU_identifier
133
+					'post_date'=>current_time('mysql'), //VNU_created
134
+					'post_date_gmt'=>  current_time('mysql', true),
135
+					'post_excerpt'=>'', //wp_trim_words($meta['description'] ? $meta['description'] : '',50),//VNU_short_desc arbitraty only 50 characters
136
+					'post_modified'=>current_time('mysql'), //VNU_modified
137
+					'post_modified_gmt'=>current_time('mysql', true),
138
+					'post_author'=>$old_venue['wp_user'], //VNU_wp_user
139
+					'post_parent'=>0, //parent
140
+					'menu_order'=>0, //VNU_order
141 141
 					'post_type'=>'espresso_venues'//post_type
142 142
 				);
143 143
 		$datatypes_array = array(
144
-					'%s',//VNU_name
145
-					'%s',//VNU_desc
146
-					'%s',//VNU_identifier
147
-					'%s',//VNU_created
144
+					'%s', //VNU_name
145
+					'%s', //VNU_desc
146
+					'%s', //VNU_identifier
147
+					'%s', //VNU_created
148 148
 					'%s',
149
-					'%s',//VNU_short_desc
150
-					'%s',//VNU_modified
149
+					'%s', //VNU_short_desc
150
+					'%s', //VNU_modified
151 151
 					'%s',
152
-					'%d',//VNU_wp_user
153
-					'%d',//parent
154
-					'%d',//VNU_order
155
-					'%s',//post_type
152
+					'%d', //VNU_wp_user
153
+					'%d', //parent
154
+					'%d', //VNU_order
155
+					'%s', //post_type
156 156
 				);
157 157
 		$success = $wpdb->insert($this->_new_table,
158 158
 				$insertion_array,
159 159
 				$datatypes_array);
160
-		if( ! $success ){
160
+		if ( ! $success) {
161 161
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_venue, $this->_new_table, $insertion_array, $datatypes_array));
162 162
 			return 0;
163 163
 		}
@@ -171,11 +171,11 @@  discard block
 block discarded – undo
171 171
 	 * @param string $post_name
172 172
 	 * @return string
173 173
 	 */
174
-	private function _find_unique_slug($post_name, $old_identifier = '' ){
174
+	private function _find_unique_slug($post_name, $old_identifier = '') {
175 175
 		$count = 0;
176
-		$original_name = $post_name ? sanitize_title( $post_name ) : $old_identifier;
176
+		$original_name = $post_name ? sanitize_title($post_name) : $old_identifier;
177 177
 		$event_slug = $original_name;
178
-		while( $this->_other_post_exists_with_that_slug($event_slug) && $count<50){
178
+		while ($this->_other_post_exists_with_that_slug($event_slug) && $count < 50) {
179 179
 			$event_slug = sanitize_title($original_name."-".++$count);
180 180
 		}
181 181
 		return $event_slug;
@@ -187,11 +187,11 @@  discard block
 block discarded – undo
187 187
 	 * @param type $slug
188 188
 	 * @return boolean
189 189
 	 */
190
-	private function _other_post_exists_with_that_slug($slug){
190
+	private function _other_post_exists_with_that_slug($slug) {
191 191
 		global $wpdb;
192
-		$query = $wpdb->prepare("SELECT COUNT(ID) FROM ".$this->_new_table." WHERE post_name = %s",$slug);
192
+		$query = $wpdb->prepare("SELECT COUNT(ID) FROM ".$this->_new_table." WHERE post_name = %s", $slug);
193 193
 		$count = $wpdb->get_var($query);
194
-		return (boolean)intval($count);
194
+		return (boolean) intval($count);
195 195
 	}
196 196
 
197 197
 	/**
@@ -200,60 +200,60 @@  discard block
 block discarded – undo
200 200
 	 * @param type $old_venue
201 201
 	 * @return int
202 202
 	 */
203
-	private function _insert_into_meta_table($cpt_id,$old_venue){
203
+	private function _insert_into_meta_table($cpt_id, $old_venue) {
204 204
 		global $wpdb;
205 205
 		//get a country with the same name, or insert one
206
-		try{
206
+		try {
207 207
 			$country = $this->get_migration_script()->get_or_create_country(stripslashes($old_venue['country']));
208 208
 			$country_iso = $country['CNT_ISO'];
209
-		}catch(EE_Error $e){
210
-			$this->add_error(sprintf(__("%s for venue %s", "event_espresso"),$e->getMessage(),$this->_json_encode($old_venue)));
209
+		} catch (EE_Error $e) {
210
+			$this->add_error(sprintf(__("%s for venue %s", "event_espresso"), $e->getMessage(), $this->_json_encode($old_venue)));
211 211
 			$country_iso = null;
212 212
 		}
213 213
 		//get a state with the same name, if possible
214
-		try{
215
-			$state = $this->get_migration_script()->get_or_create_state(stripslashes($old_venue['state']),isset($country['CNT_name']) ? $country['CNT_name'] : strip_tags($old_venue['country']));
214
+		try {
215
+			$state = $this->get_migration_script()->get_or_create_state(stripslashes($old_venue['state']), isset($country['CNT_name']) ? $country['CNT_name'] : strip_tags($old_venue['country']));
216 216
 			$state_id = $state['STA_ID'];
217
-		}catch(EE_Error $e){
218
-			$this->add_error(sprintf(__("%s for venue %s", "event_espresso"),$e->getMessage(),$this->_json_encode($old_venue)));
217
+		} catch (EE_Error $e) {
218
+			$this->add_error(sprintf(__("%s for venue %s", "event_espresso"), $e->getMessage(), $this->_json_encode($old_venue)));
219 219
 			$state_id = 0;
220 220
 		}
221 221
 		$meta = maybe_unserialize($old_venue['meta']);
222 222
 		//now insert into meta table
223 223
 		$insertion_array = array(
224
-			'VNU_ID'=>$cpt_id,//VNU_ID_fk
225
-			'VNU_address'=>stripslashes($old_venue['address']),//VNU_address
226
-			'VNU_address2'=>stripslashes($old_venue['address2']),//VNU_address2
227
-			'VNU_city'=>stripslashes($old_venue['city']),//VNU_city
228
-			'STA_ID'=>$state_id,//STA_ID
229
-			'CNT_ISO'=>$country_iso,//CNT_ISO
230
-			'VNU_zip'=>stripslashes($old_venue['zip']),//VNU_zip
231
-			'VNU_phone'=>isset($meta['phone']) ? stripslashes($meta['phone']) : '',//VNU_phone
232
-			'VNU_capacity'=>-1,//VNU_capacity
233
-			'VNU_url'=>isset($meta['website']) ? stripslashes($meta['website']) : '',//VNU_url
234
-			'VNU_virtual_phone'=>'',//VNU_virtual_phone
235
-			'VNU_virtual_url'=>'',//VNU_virtual_url
236
-			'VNU_google_map_link'=>'',//VNU_google_map_link
224
+			'VNU_ID'=>$cpt_id, //VNU_ID_fk
225
+			'VNU_address'=>stripslashes($old_venue['address']), //VNU_address
226
+			'VNU_address2'=>stripslashes($old_venue['address2']), //VNU_address2
227
+			'VNU_city'=>stripslashes($old_venue['city']), //VNU_city
228
+			'STA_ID'=>$state_id, //STA_ID
229
+			'CNT_ISO'=>$country_iso, //CNT_ISO
230
+			'VNU_zip'=>stripslashes($old_venue['zip']), //VNU_zip
231
+			'VNU_phone'=>isset($meta['phone']) ? stripslashes($meta['phone']) : '', //VNU_phone
232
+			'VNU_capacity'=>-1, //VNU_capacity
233
+			'VNU_url'=>isset($meta['website']) ? stripslashes($meta['website']) : '', //VNU_url
234
+			'VNU_virtual_phone'=>'', //VNU_virtual_phone
235
+			'VNU_virtual_url'=>'', //VNU_virtual_url
236
+			'VNU_google_map_link'=>'', //VNU_google_map_link
237 237
 			'VNU_enable_for_gmap'=>true	//VNU_enable_for_gmap
238 238
 		);
239 239
 		$datatypes = array(
240
-			'%d',//VNU_ID_fk
241
-			'%s',//VNU_address
242
-			'%s',//VNU_address2
243
-			'%s',//VNU_city
244
-			'%d',//STA_ID
245
-			'%s',//CNT_ISO
246
-			'%s',//VNU_zip
247
-			'%s',//VNU_phone
248
-			'%d',//VNU_capacity
249
-			'%s',//VNU_url
250
-			'%s',//VNU_virtual_phone
251
-			'%s',//VNU_virtual_url
252
-			'%s',//VNU_google_map_link
253
-			'%d',//VNU_enable_for_gmap
240
+			'%d', //VNU_ID_fk
241
+			'%s', //VNU_address
242
+			'%s', //VNU_address2
243
+			'%s', //VNU_city
244
+			'%d', //STA_ID
245
+			'%s', //CNT_ISO
246
+			'%s', //VNU_zip
247
+			'%s', //VNU_phone
248
+			'%d', //VNU_capacity
249
+			'%s', //VNU_url
250
+			'%s', //VNU_virtual_phone
251
+			'%s', //VNU_virtual_url
252
+			'%s', //VNU_google_map_link
253
+			'%d', //VNU_enable_for_gmap
254 254
 		);
255
-		$success = $wpdb->insert($this->_new_meta_table,$insertion_array,$datatypes);
256
-		if( ! $success ){
255
+		$success = $wpdb->insert($this->_new_meta_table, $insertion_array, $datatypes);
256
+		if ( ! $success) {
257 257
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_venue, $this->_new_meta_table, $insertion_array, $datatypes));
258 258
 			return 0;
259 259
 		}
Please login to merge, or discard this patch.
4_6_0_stages/EE_DMS_4_6_0_payment_method_currencies.dmsstage.php 2 patches
Doc Comments   +3 added lines, -2 removed lines patch added patch discarded remove patch
@@ -128,6 +128,9 @@  discard block
 block discarded – undo
128 128
 		return $items_actually_migrated;
129 129
 	}
130 130
 
131
+	/**
132
+	 * @param integer $num_items_to_migrate
133
+	 */
131 134
 	private function _gather_relations_to_add($num_items_to_migrate) {
132 135
 		$relations_to_add_this_step = array();
133 136
 		$migrate_up_to_count = $this->count_records_migrated() + $num_items_to_migrate;
@@ -158,8 +161,6 @@  discard block
 block discarded – undo
158 161
 
159 162
 	/**
160 163
 	 * Adds teh relation between the payment method and the currencies it can be used for
161
-	 * @param int $id
162
-	 * @param string $gateway_slug
163 164
 	 */
164 165
 	private function _add_currency_relations($pm_id,$currency_code){
165 166
 		global $wpdb;
Please login to merge, or discard this patch.
Spacing   +24 added lines, -24 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@  discard block
 block discarded – undo
1 1
 <?php
2 2
 
3
-if (!defined('EVENT_ESPRESSO_VERSION')) {
3
+if ( ! defined('EVENT_ESPRESSO_VERSION')) {
4 4
 	exit('No direct script access allowed');
5 5
 }
6 6
 
@@ -13,7 +13,7 @@  discard block
 block discarded – undo
13 13
  * @author				Mike Nelson
14 14
  *
15 15
  */
16
-class EE_DMS_4_6_0_payment_method_currencies extends EE_Data_Migration_Script_Stage{
16
+class EE_DMS_4_6_0_payment_method_currencies extends EE_Data_Migration_Script_Stage {
17 17
 	protected $_currency_table_name;
18 18
 	protected $_currency_payment_method_table_name;
19 19
 	protected $_payment_method_table_name;
@@ -89,7 +89,7 @@  discard block
 block discarded – undo
89 89
 	);
90 90
 	public function __construct() {
91 91
 		global $wpdb;
92
-		$this->_pretty_name = __( 'Payment Method Currencies', 'event_espresso' );
92
+		$this->_pretty_name = __('Payment Method Currencies', 'event_espresso');
93 93
 		$this->_payment_method_table_name = $wpdb->prefix.'esp_payment_method';
94 94
 		$this->_currency_payment_method_table_name = $wpdb->prefix.'esp_currency_payment_method';
95 95
 		$this->_currency_table_name = $wpdb->prefix.'esp_currency';
@@ -98,8 +98,8 @@  discard block
 block discarded – undo
98 98
 
99 99
 	protected function _count_records_to_migrate() {
100 100
 		$count = 0;
101
-		foreach($this->_gateway_currencies as $currencies){
102
-			if( $currencies == 'all'){
101
+		foreach ($this->_gateway_currencies as $currencies) {
102
+			if ($currencies == 'all') {
103 103
 				$currencies = $this->_get_all_currencies();
104 104
 			}
105 105
 			$count += count($currencies);
@@ -109,20 +109,20 @@  discard block
 block discarded – undo
109 109
 
110 110
 
111 111
 
112
-	protected function _migration_step( $num_items_to_migrate = 50 ) {
112
+	protected function _migration_step($num_items_to_migrate = 50) {
113 113
 		$items_actually_migrated = 0;
114 114
 		$relations_to_add_this_step = $this->_gather_relations_to_add($num_items_to_migrate);
115
-		foreach($relations_to_add_this_step as $pm_slug => $currencies){
115
+		foreach ($relations_to_add_this_step as $pm_slug => $currencies) {
116 116
 
117
-			$id = $this->get_migration_script()->get_mapping_new_pk( 'EE_Gateway_Config', $pm_slug, $this->_payment_method_table_name );
118
-			foreach( $currencies as $currency ){
119
-				if( $id ){
120
-					$this->_add_currency_relations( $id, $currency );
117
+			$id = $this->get_migration_script()->get_mapping_new_pk('EE_Gateway_Config', $pm_slug, $this->_payment_method_table_name);
118
+			foreach ($currencies as $currency) {
119
+				if ($id) {
120
+					$this->_add_currency_relations($id, $currency);
121 121
 				}
122 122
 				$items_actually_migrated++;
123 123
 			}
124 124
 		}
125
-		if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){
125
+		if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
126 126
 			$this->set_completed();
127 127
 		}
128 128
 		return $items_actually_migrated;
@@ -132,14 +132,14 @@  discard block
 block discarded – undo
132 132
 		$relations_to_add_this_step = array();
133 133
 		$migrate_up_to_count = $this->count_records_migrated() + $num_items_to_migrate;
134 134
 		$iterator = 0;
135
-		foreach($this->_gateway_currencies as $pm_slug => $currencies){
136
-			if( $currencies == 'all' ){
135
+		foreach ($this->_gateway_currencies as $pm_slug => $currencies) {
136
+			if ($currencies == 'all') {
137 137
 				$currencies = $this->_get_all_currencies();
138 138
 			}
139
-			foreach($currencies as $currency_code){
140
-				if( $this->count_records_migrated() <= $iterator &&
141
-						$iterator < $migrate_up_to_count ){
142
-					$relations_to_add_this_step[ $pm_slug ] [] = $currency_code;
139
+			foreach ($currencies as $currency_code) {
140
+				if ($this->count_records_migrated() <= $iterator &&
141
+						$iterator < $migrate_up_to_count) {
142
+					$relations_to_add_this_step[$pm_slug] [] = $currency_code;
143 143
 				}
144 144
 				$iterator++;
145 145
 			}
@@ -150,7 +150,7 @@  discard block
 block discarded – undo
150 150
 	 * Gets all the currency codes in the database
151 151
 	 * @return array
152 152
 	 */
153
-	private function _get_all_currencies(){
153
+	private function _get_all_currencies() {
154 154
 		global $wpdb;
155 155
 		$currencies = $wpdb->get_col("SELECT CUR_code FROM {$this->_currency_table_name}");
156 156
 		return $currencies;
@@ -161,7 +161,7 @@  discard block
 block discarded – undo
161 161
 	 * @param int $id
162 162
 	 * @param string $gateway_slug
163 163
 	 */
164
-	private function _add_currency_relations($pm_id,$currency_code){
164
+	private function _add_currency_relations($pm_id, $currency_code) {
165 165
 		global $wpdb;
166 166
 		$cur_pm_relation = array(
167 167
 					'CUR_code'=>$currency_code,
@@ -170,11 +170,11 @@  discard block
 block discarded – undo
170 170
 		$success = $wpdb->insert($this->_currency_payment_method_table_name,
171 171
 				$cur_pm_relation,
172 172
 				array(
173
-					'%s',//CUR_code
174
-					'%d',//PMD_ID
173
+					'%s', //CUR_code
174
+					'%d', //PMD_ID
175 175
 				));
176
-		if( ! $success ){
177
-			$this->add_error( sprintf( __( 'Could not add currency relation %s because %s', "event_espresso" ), json_encode( $cur_pm_relation ), $wpdb->last_error ) );
176
+		if ( ! $success) {
177
+			$this->add_error(sprintf(__('Could not add currency relation %s because %s', "event_espresso"), json_encode($cur_pm_relation), $wpdb->last_error));
178 178
 		}
179 179
 	}
180 180
 }
Please login to merge, or discard this patch.
data_migration_scripts/4_6_0_stages/EE_DMS_4_6_0_transactions.dmsstage.php 2 patches
Doc Comments   -1 removed lines patch added patch discarded remove patch
@@ -49,7 +49,6 @@
 block discarded – undo
49 49
 	/**
50 50
 	 *
51 51
 	 * @global type $wpdb
52
-	 * @param int $id
53 52
 	 * @return string
54 53
 	 */
55 54
 	protected function _get_payment_method_id_by_gateway_name( $gateway_name ){
Please login to merge, or discard this patch.
Spacing   +20 added lines, -20 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,38 +12,38 @@  discard block
 block discarded – undo
12 12
  * @author				Mike Nelson
13 13
  *
14 14
  */
15
-class EE_DMS_4_6_0_transactions extends EE_Data_Migration_Script_Stage_Table{
15
+class EE_DMS_4_6_0_transactions extends EE_Data_Migration_Script_Stage_Table {
16 16
 	protected $_transaction_table;
17 17
 	protected $_payment_method_table;
18
-	function __construct(){
18
+	function __construct() {
19 19
 		global $wpdb;
20
-		$this->_old_table = $wpdb->prefix . 'esp_extra_meta';
21
-		$this->_transaction_table = $wpdb->prefix . 'esp_transaction';
22
-		$this->_payment_method_table = $wpdb->prefix . 'esp_payment_method';
20
+		$this->_old_table = $wpdb->prefix.'esp_extra_meta';
21
+		$this->_transaction_table = $wpdb->prefix.'esp_transaction';
22
+		$this->_payment_method_table = $wpdb->prefix.'esp_payment_method';
23 23
 		$this->_pretty_name = __('Transaction Payment Method Relations', 'event_espresso');
24 24
 		$this->_extra_where_sql = "WHERE EXM_key = 'gateway' AND EXM_type = 'Transaction'";
25 25
 		parent::__construct();
26 26
 	}
27
-	protected function _migrate_old_row( $extra_meta_row ) {
27
+	protected function _migrate_old_row($extra_meta_row) {
28 28
 		global $wpdb;
29 29
 		//get the payment method's ID
30
-		$PMD_ID = $this->_get_payment_method_id_by_gateway_name( $extra_meta_row[ 'EXM_value' ] );
31
-		if( ! $PMD_ID ){
32
-			$this->add_error( sprintf( __( 'Could not find payment method with PMD_type = \'%1$s\' when migrating extra meta row %2$s', 'event_espresso' ), $extra_meta_row[ 'EXM_value' ], $this->_json_encode( $extra_meta_row ) ) );
30
+		$PMD_ID = $this->_get_payment_method_id_by_gateway_name($extra_meta_row['EXM_value']);
31
+		if ( ! $PMD_ID) {
32
+			$this->add_error(sprintf(__('Could not find payment method with PMD_type = \'%1$s\' when migrating extra meta row %2$s', 'event_espresso'), $extra_meta_row['EXM_value'], $this->_json_encode($extra_meta_row)));
33 33
 			return;
34 34
 		}
35
-		$new_values = array( 'PMD_ID' => $PMD_ID );
36
-		$wheres = array( 'TXN_ID' => $extra_meta_row[ 'OBJ_ID' ] );
37
-		$new_value_datatypes = array( '%d' );
38
-		$where_datatypes = array( '%d' );
39
-		$success = $wpdb->update( $this->_transaction_table,
35
+		$new_values = array('PMD_ID' => $PMD_ID);
36
+		$wheres = array('TXN_ID' => $extra_meta_row['OBJ_ID']);
37
+		$new_value_datatypes = array('%d');
38
+		$where_datatypes = array('%d');
39
+		$success = $wpdb->update($this->_transaction_table,
40 40
 				$new_values,
41 41
 				$wheres,
42 42
 				$new_value_datatypes,
43 43
 				$where_datatypes
44 44
 				);
45
-		if( ! $success ){
46
-			$this->add_error( sprintf( __( 'Couldnt set %1$s row in table %2$s where %3$s', 'event_espresso' ), $this->_json_encode( $new_values ), $this->_transaction_table, $this->_json_encode( $wheres ) ) );
45
+		if ( ! $success) {
46
+			$this->add_error(sprintf(__('Couldnt set %1$s row in table %2$s where %3$s', 'event_espresso'), $this->_json_encode($new_values), $this->_transaction_table, $this->_json_encode($wheres)));
47 47
 		}
48 48
 	}
49 49
 	/**
@@ -52,9 +52,9 @@  discard block
 block discarded – undo
52 52
 	 * @param int $id
53 53
 	 * @return string
54 54
 	 */
55
-	protected function _get_payment_method_id_by_gateway_name( $gateway_name ){
55
+	protected function _get_payment_method_id_by_gateway_name($gateway_name) {
56 56
 		global $wpdb;
57
-		return $wpdb->get_var( $wpdb->prepare( "SELECT PMD_ID FROM " . $wpdb->prefix . "esp_payment_method WHERE PMD_type = %s", $gateway_name ) );
57
+		return $wpdb->get_var($wpdb->prepare("SELECT PMD_ID FROM ".$wpdb->prefix."esp_payment_method WHERE PMD_type = %s", $gateway_name));
58 58
 	}
59 59
 
60 60
 
Please login to merge, or discard this patch.
core/data_migration_scripts/EE_Data_Migration_Class_Base.core.php 4 patches
Doc Comments   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -234,7 +234,7 @@
 block discarded – undo
234 234
 	 * @param array $old_row_as_array
235 235
 	 * @param string $new_table
236 236
 	 * @param array $new_row_as_array columns=>values like used in wpdb->insert
237
-	 * @param array $data_types numerically indexed
237
+	 * @param string[] $data_types numerically indexed
238 238
 	 * @return string
239 239
 	 */
240 240
 	protected function _create_error_message_for_db_insertion($old_table, $old_row_as_array, $new_table, $new_row_as_array, $data_types){
Please login to merge, or discard this patch.
Indentation   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -264,9 +264,9 @@
 block discarded – undo
264 264
 	/**
265 265
 	 * Same as json_encode, just avoids putting
266 266
 	 * serialized arrays into the http build query, as that would
267
-	* @param array $array_of_data
268
-	* @return string
269
-	*/
267
+	 * @param array $array_of_data
268
+	 * @return string
269
+	 */
270 270
 	protected function _json_encode($array_of_data){
271 271
 		//we'd rather NOT serialize the transaction details
272 272
 		$fields_to_include = array();
Please login to merge, or discard this patch.
Spacing   +46 added lines, -46 removed lines patch added patch discarded remove patch
@@ -17,7 +17,7 @@  discard block
 block discarded – undo
17 17
 
18 18
 
19 19
 
20
-abstract class EE_Data_Migration_Class_Base{
20
+abstract class EE_Data_Migration_Class_Base {
21 21
 	/**
22 22
 	 * @var $records_to_migrate int count of all that have been migrated
23 23
 	 */
@@ -50,7 +50,7 @@  discard block
 block discarded – undo
50 50
 	 * Just initializes the status of the migration
51 51
 	 * @throws EE_Error
52 52
 	 */
53
-	public function __construct(){
53
+	public function __construct() {
54 54
 		$this->set_status(EE_Data_Migration_Manager::status_continue);
55 55
 	}
56 56
 
@@ -61,9 +61,9 @@  discard block
 block discarded – undo
61 61
 	 * @throws EE_Error
62 62
 	 * @return string
63 63
 	 */
64
-	public function pretty_name(){
65
-		if($this->_pretty_name === null){
66
-			throw new EE_Error(sprintf(__("Please give a pretty name to the migration script stage %s by assigning the property _pretty_name in the constructor", "event_espresso"),get_class($this)));
64
+	public function pretty_name() {
65
+		if ($this->_pretty_name === null) {
66
+			throw new EE_Error(sprintf(__("Please give a pretty name to the migration script stage %s by assigning the property _pretty_name in the constructor", "event_espresso"), get_class($this)));
67 67
 		}
68 68
 		return $this->_pretty_name;
69 69
 	}
@@ -71,8 +71,8 @@  discard block
 block discarded – undo
71 71
 	 *
72 72
 	 * @return int
73 73
 	 */
74
-	public function count_records_to_migrate(){
75
-		if( $this->_records_to_migrate == null){
74
+	public function count_records_to_migrate() {
75
+		if ($this->_records_to_migrate == null) {
76 76
 			$this->_records_to_migrate = $this->_count_records_to_migrate();
77 77
 		}
78 78
 		return $this->_records_to_migrate;
@@ -92,9 +92,9 @@  discard block
 block discarded – undo
92 92
 	 * @return string one of EE_Data_Migration_Manager::status_* constants
93 93
 	 * @throws EE_Error
94 94
 	 */
95
-	public function get_status(){
96
-		if($this->_status === null){
97
-			throw new EE_Error(sprintf(__("Trying to get status of Migration class %s, but it has not been initialized yet. It should be set in the constructor.", "event_espresso"),get_class($this)));
95
+	public function get_status() {
96
+		if ($this->_status === null) {
97
+			throw new EE_Error(sprintf(__("Trying to get status of Migration class %s, but it has not been initialized yet. It should be set in the constructor.", "event_espresso"), get_class($this)));
98 98
 		}
99 99
 		return $this->_status;
100 100
 	}
@@ -103,7 +103,7 @@  discard block
 block discarded – undo
103 103
 	 * @param string $status
104 104
 	 * @return void
105 105
 	 */
106
-	protected function set_status($status){
106
+	protected function set_status($status) {
107 107
 		$this->_status = $status;
108 108
 	}
109 109
 	/**
@@ -115,11 +115,11 @@  discard block
 block discarded – undo
115 115
 	 * Returns the last error that occurred. If none occurred, returns null
116 116
 	 * @return string
117 117
 	 */
118
-	public function get_last_error(){
118
+	public function get_last_error() {
119 119
 		$errors = $this->get_errors();
120
-		if($errors){
120
+		if ($errors) {
121 121
 			return end($errors);
122
-		}else{
122
+		} else {
123 123
 			return null;
124 124
 		}
125 125
 	}
@@ -128,26 +128,26 @@  discard block
 block discarded – undo
128 128
 	 * @param string $error a string describing the error that will be useful for debugging. Consider including all the data that led to the error, and a stack trace etc.
129 129
 	 * @param boolean $force force the error to be added (because otherwise we have a limit). If forcing and errors are already at their limit, we will purposefully forget the first half
130 130
 	 */
131
-	public function add_error($error, $force = FALSE ){
132
-		if( ! defined( 'EE_DMS_ERROR_LIMIT' ) ){
131
+	public function add_error($error, $force = FALSE) {
132
+		if ( ! defined('EE_DMS_ERROR_LIMIT')) {
133 133
 			$limit = 50;
134
-		}else{
134
+		} else {
135 135
 			$limit = EE_DMS_ERROR_LIMIT;
136 136
 		}
137 137
 		//make sure errors is an array, see ticket #8261
138
-		if( is_string( $this->_errors ) ){
139
-			$this->_errors = array( $this->_errors );
138
+		if (is_string($this->_errors)) {
139
+			$this->_errors = array($this->_errors);
140 140
 		}
141
-		if(count($this->_errors) >= $limit ){
142
-			if( $force ){
141
+		if (count($this->_errors) >= $limit) {
142
+			if ($force) {
143 143
 				//get rid of the first half of the errors and any above the limit
144
-				$this->_errors = array_slice( $this->_errors, $limit / 2, $limit / 2 );
144
+				$this->_errors = array_slice($this->_errors, $limit / 2, $limit / 2);
145 145
 				$this->_errors[] = "Limit reached; removed first half of errors to save space";
146 146
 				$this->_errors[] = $error;
147
-			}else{
148
-				$this->_errors[ $limit ] = 'More, but limit reached...';
147
+			} else {
148
+				$this->_errors[$limit] = 'More, but limit reached...';
149 149
 			}
150
-		}else{
150
+		} else {
151 151
 			$this->_errors[] = $error;
152 152
 		}
153 153
 	}
@@ -156,57 +156,57 @@  discard block
 block discarded – undo
156 156
 	 * Indicates there was a fatal error and the migration cannot possibly continue
157 157
 	 * @return boolean
158 158
 	 */
159
-	public function is_broken(){
159
+	public function is_broken() {
160 160
 		return $this->get_status() == EE_Data_Migration_Manager::status_fatal_error;
161 161
 	}
162 162
 	/**
163 163
 	 * @deprecated since 4.6.12
164 164
 	 */
165
-	public function is_borked(){
166
-		EE_Error::doing_it_wrong('is_borked', __( 'The cheeky "is_borked" method had been replaced with the more proper "is_broken"', 'event_espresso' ), '4.6.12');
165
+	public function is_borked() {
166
+		EE_Error::doing_it_wrong('is_borked', __('The cheeky "is_borked" method had been replaced with the more proper "is_broken"', 'event_espresso'), '4.6.12');
167 167
 		return $this->is_broken();
168 168
 	}
169 169
 	/**
170 170
 	 * Sets the status to as having a fatal error
171 171
 	 */
172
-	public function set_broken(){
172
+	public function set_broken() {
173 173
 		$this->_status = EE_Data_Migration_Manager::status_fatal_error;
174 174
 	}
175 175
 	/**
176 176
 	 *
177 177
 	 * @deprecated since 4.6.12
178 178
 	 */
179
-	public function set_borked(){
180
-		EE_Error::doing_it_wrong('is_borked', __( 'The cheeky "is_borked" method had been replaced with the more proper "is_broken"', 'event_espresso' ), '4.6.12');
179
+	public function set_borked() {
180
+		EE_Error::doing_it_wrong('is_borked', __('The cheeky "is_borked" method had been replaced with the more proper "is_broken"', 'event_espresso'), '4.6.12');
181 181
 		return $this->set_broken();
182 182
 	}
183 183
 	/**
184 184
 	 * Checks if this thing believes it is completed
185 185
 	 * @return boolean
186 186
 	 */
187
-	public function is_completed(){
187
+	public function is_completed() {
188 188
 		return $this->get_status() == EE_Data_Migration_Manager::status_completed;
189 189
 	}
190 190
 	/**
191 191
 	 * Checks if the current script has more to do or not (ie, if it's status is CONTINUE)
192 192
 	 * @return boolean
193 193
 	 */
194
-	public function has_more_to_do(){
194
+	public function has_more_to_do() {
195 195
 		return $this->get_status() == EE_Data_Migration_Manager::status_continue;
196 196
 	}
197 197
 	/**
198 198
 	 * Marks that we believe this migration thing is completed
199 199
 	 */
200
-	public function set_completed(){
200
+	public function set_completed() {
201 201
 		$this->_status = EE_Data_Migration_Manager::status_completed;
202 202
 	}
203 203
 
204 204
 	/**
205 205
 	 * Marks that we think this migration class can continue to migrate
206 206
 	 */
207
-	public function reattempt(){
207
+	public function reattempt() {
208 208
 		$this->_status = EE_Data_Migration_Manager::status_continue;
209
-		$this->add_error( __( 'Reattempt migration', 'event_espresso' ), TRUE );
209
+		$this->add_error(__('Reattempt migration', 'event_espresso'), TRUE);
210 210
 	}
211 211
 
212 212
 	/**
@@ -215,8 +215,8 @@  discard block
 block discarded – undo
215 215
 	 * possible that this class is defined when it goes to sleep, but NOT available when it
216 216
 	 * awakes (eg, this class is part of an addon that is deactivated at some point).
217 217
 	 */
218
-	public function properties_as_array(){
219
-		$properties =  get_object_vars($this);
218
+	public function properties_as_array() {
219
+		$properties = get_object_vars($this);
220 220
 		$properties['class'] = get_class($this);
221 221
 		unset($properties['_migration_script']);
222 222
 		return $properties;
@@ -237,22 +237,22 @@  discard block
 block discarded – undo
237 237
 	 * @param array $data_types numerically indexed
238 238
 	 * @return string
239 239
 	 */
240
-	protected function _create_error_message_for_db_insertion($old_table, $old_row_as_array, $new_table, $new_row_as_array, $data_types){
240
+	protected function _create_error_message_for_db_insertion($old_table, $old_row_as_array, $new_table, $new_row_as_array, $data_types) {
241 241
 		global $wpdb;
242 242
 		$old_columns_and_values_for_string = array();
243
-		foreach($old_row_as_array as $column => $value){
243
+		foreach ($old_row_as_array as $column => $value) {
244 244
 			$old_columns_and_values_for_string[] = "$column => $value";
245 245
 		}
246 246
 		$new_columns_and_values_for_string = array();
247 247
 		$count = 0;
248
-		foreach($new_row_as_array as $column => $value){
248
+		foreach ($new_row_as_array as $column => $value) {
249 249
 			$new_columns_and_values_for_string[] = " $column => $value (".$data_types[$count++].")";
250 250
 		}
251 251
 		return sprintf(
252 252
 			__('Received error "%6$s" inserting row %5$s %1$s %5$s into table %2$s.%5$s Data used was %5$s %3$s %5$s from table %4%s.', "event_espresso"),
253
-			implode(", ",$new_columns_and_values_for_string),
253
+			implode(", ", $new_columns_and_values_for_string),
254 254
 			$new_table,
255
-			implode(", ",$old_columns_and_values_for_string),
255
+			implode(", ", $old_columns_and_values_for_string),
256 256
 			$old_table,
257 257
 			'<br/>',
258 258
 			$wpdb->last_error
@@ -267,12 +267,12 @@  discard block
 block discarded – undo
267 267
 	* @param array $array_of_data
268 268
 	* @return string
269 269
 	*/
270
-	protected function _json_encode($array_of_data){
270
+	protected function _json_encode($array_of_data) {
271 271
 		//we'd rather NOT serialize the transaction details
272 272
 		$fields_to_include = array();
273
-		foreach($array_of_data as $name => $value){
273
+		foreach ($array_of_data as $name => $value) {
274 274
 			$unserialized_data = @unserialize($value);
275
-			if($unserialized_data === FALSE){
275
+			if ($unserialized_data === FALSE) {
276 276
 				$fields_to_include[$name] = $value;
277 277
 			}
278 278
 		}
Please login to merge, or discard this patch.
Braces   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -119,7 +119,7 @@  discard block
 block discarded – undo
119 119
 		$errors = $this->get_errors();
120 120
 		if($errors){
121 121
 			return end($errors);
122
-		}else{
122
+		} else{
123 123
 			return null;
124 124
 		}
125 125
 	}
@@ -131,7 +131,7 @@  discard block
 block discarded – undo
131 131
 	public function add_error($error, $force = FALSE ){
132 132
 		if( ! defined( 'EE_DMS_ERROR_LIMIT' ) ){
133 133
 			$limit = 50;
134
-		}else{
134
+		} else{
135 135
 			$limit = EE_DMS_ERROR_LIMIT;
136 136
 		}
137 137
 		//make sure errors is an array, see ticket #8261
@@ -144,10 +144,10 @@  discard block
 block discarded – undo
144 144
 				$this->_errors = array_slice( $this->_errors, $limit / 2, $limit / 2 );
145 145
 				$this->_errors[] = "Limit reached; removed first half of errors to save space";
146 146
 				$this->_errors[] = $error;
147
-			}else{
147
+			} else{
148 148
 				$this->_errors[ $limit ] = 'More, but limit reached...';
149 149
 			}
150
-		}else{
150
+		} else{
151 151
 			$this->_errors[] = $error;
152 152
 		}
153 153
 	}
Please login to merge, or discard this patch.
core/data_migration_scripts/EE_DMS_Core_4_1_0.dms.php 4 patches
Doc Comments   +2 added lines, -3 removed lines patch added patch discarded remove patch
@@ -1434,7 +1434,6 @@  discard block
 block discarded – undo
1434 1434
 	/**
1435 1435
 	 * Makes sure the 3.1's image url is converted to an image attachment post to the 4.1 CPT event
1436 1436
 	 * and sets it as the featured image on the CPT event
1437
-	 * @param type $old_event
1438 1437
 	 * @param type $new_cpt_id
1439 1438
 	 * @param  EE_Data_Migration_Script_Stage $migration_stage the stage which called this, where errors should be added
1440 1439
 	 * @return boolean whether or not we had to do the big job of creating an image attachment
@@ -1482,7 +1481,7 @@  discard block
 block discarded – undo
1482 1481
 	/**
1483 1482
 	 * Creates an image attachment post for the GUID. If the GUID points to a remote image,
1484 1483
 	 * we download it to our uploads directory so that it can be properly processed (eg, creates different sizes of thumbnails)
1485
-	 * @param type $guid
1484
+	 * @param string $guid
1486 1485
 	 * @param EE_Data_Migration_Script_Stage $migration_stage
1487 1486
 	 * @return int
1488 1487
 	 */
@@ -1558,7 +1557,7 @@  discard block
 block discarded – undo
1558 1557
 	/**
1559 1558
 	 * Returns a mysql-formatted DATETIME in UTC time, given a $DATETIME_string
1560 1559
 	 * (and optionally a timezone; if none is given, the wp DEFAULT is used)
1561
-	 * @param EE_Data_Migration_Script_base $stage
1560
+	 * @param EE_Data_Migration_Script_Stage $stage
1562 1561
 	 * @param array $row_of_data, the row from the DB (as an array) we're trying to find the UTC time for
1563 1562
 	 * @param string $DATETIME_string
1564 1563
 	 * @param string $timezone
Please login to merge, or discard this patch.
Indentation   +13 added lines, -13 removed lines patch added patch discarded remove patch
@@ -1607,19 +1607,19 @@
 block discarded – undo
1607 1607
 	private function timezone_convert_to_string_from_offset($offset){
1608 1608
 		//shamelessly taken from bottom comment at http://ca1.php.net/manual/en/function.timezone-name-from-abbr.php because timezone_name_from_abbr() did NOT work as expected - its not reliable
1609 1609
 		$offset *= 3600; // convert hour offset to seconds
1610
-        $abbrarray = timezone_abbreviations_list();
1611
-        foreach ($abbrarray as $abbr){
1612
-                foreach ($abbr as $city)
1613
-                {
1614
-                        if ($city['offset'] == $offset)
1615
-                        {
1616
-
1617
-                                return $city['timezone_id'];
1618
-                        }
1619
-                }
1620
-        }
1621
-
1622
-        return FALSE;
1610
+		$abbrarray = timezone_abbreviations_list();
1611
+		foreach ($abbrarray as $abbr){
1612
+				foreach ($abbr as $city)
1613
+				{
1614
+						if ($city['offset'] == $offset)
1615
+						{
1616
+
1617
+								return $city['timezone_id'];
1618
+						}
1619
+				}
1620
+		}
1621
+
1622
+		return FALSE;
1623 1623
 	}
1624 1624
 
1625 1625
 	public function migration_page_hooks(){
Please login to merge, or discard this patch.
Braces   +10 added lines, -10 removed lines patch added patch discarded remove patch
@@ -72,7 +72,7 @@  discard block
 block discarded – undo
72 72
 		$results = $wpdb->get_results("SHOW TABLES LIKE '".$wpdb->prefix."events_attendee_checkin"."'");
73 73
 		if($results){
74 74
 			return true;
75
-		}else{
75
+		} else{
76 76
 			return false;
77 77
 		}
78 78
 	}
@@ -81,12 +81,12 @@  discard block
 block discarded – undo
81 81
 		if($version_string < '4.0.0' && $version_string > '3.1.26' ){
82 82
 //			echo "$version_string can be migrated fro";
83 83
 			return true;
84
-		}elseif( ! $version_string ){
84
+		} elseif( ! $version_string ){
85 85
 //			echo "no version string provided: $version_string";
86 86
 			//no version string provided... this must be pre 4.1
87 87
 			//because since 4.1 we're
88 88
 			return false;//changed mind. dont want people thinking they should migrate yet because they cant
89
-		}else{
89
+		} else{
90 90
 //			echo "$version_string doesnt apply";
91 91
 			return false;
92 92
 		}
@@ -1088,7 +1088,7 @@  discard block
 block discarded – undo
1088 1088
 		try{
1089 1089
 			$country = $this->get_or_create_country($country_name);
1090 1090
 			$country_iso = $country['CNT_ISO'];
1091
-		}catch(EE_Error $e){
1091
+		} catch(EE_Error $e){
1092 1092
 			$country_iso = $this->get_default_country_iso();
1093 1093
 		}
1094 1094
 		global $wpdb;
@@ -1132,7 +1132,7 @@  discard block
 block discarded – undo
1132 1132
 		if( ! $matches || count($matches)<3){
1133 1133
 			$hour = '00';
1134 1134
 			$minutes = '00';
1135
-		}else{
1135
+		} else{
1136 1136
 			$hour = intval($matches[1]);
1137 1137
 			$minutes = $matches[2];
1138 1138
 		}
@@ -1408,7 +1408,7 @@  discard block
 block discarded – undo
1408 1408
 		//EE team can read the related discussion: https://app.asana.com/0/2400967562914/9418495544455
1409 1409
 		if($this_thing_required_pre_approval){
1410 1410
 				return 'RNA';
1411
-		}else{
1411
+		} else{
1412 1412
 				$mapping = $default_reg_stati_conversions=array(
1413 1413
 			'Completed'=>'RAP',
1414 1414
 			''=>'RPP',
@@ -1453,7 +1453,7 @@  discard block
 block discarded – undo
1453 1453
 			//double-check we actually have an attachment post
1454 1454
 			if( $attachment_post_id){
1455 1455
 				update_post_meta($new_cpt_id,'_thumbnail_id',$attachment_post_id);
1456
-			}else{
1456
+			} else{
1457 1457
 				$migration_stage->add_error(sprintf(__("Could not update event image %s for CPT with ID %d, but attachments post ID is %d", "event_espresso"),$guid,$new_cpt_id,$attachment_post_id));
1458 1458
 			}
1459 1459
 		}
@@ -1474,7 +1474,7 @@  discard block
 block discarded – undo
1474 1474
 		$head_response = wp_remote_head($original_guid);
1475 1475
 		if( ! $head_response instanceof WP_Error && $head_response['response']['message'] == 'OK'){
1476 1476
 			return $original_guid;
1477
-		}else{
1477
+		} else{
1478 1478
 			return $guid_in_old_event;
1479 1479
 		}
1480 1480
 	}
@@ -1510,7 +1510,7 @@  discard block
 block discarded – undo
1510 1510
 			fwrite($savefile, $contents);
1511 1511
 			fclose($savefile);
1512 1512
 			$guid = str_replace($wp_upload_dir['path'],$wp_upload_dir['url'],$local_filepath);
1513
-		}else{
1513
+		} else{
1514 1514
 			$local_filepath = str_replace($wp_upload_dir['url'],$wp_upload_dir['path'],$guid);
1515 1515
 		}
1516 1516
 
@@ -1576,7 +1576,7 @@  discard block
 block discarded – undo
1576 1576
 		try{
1577 1577
 			$date_obj = new DateTime( $DATETIME_string, new DateTimeZone( $timezone ) );
1578 1578
 			$date_obj->setTimezone(new DateTimeZone('UTC'));
1579
-		}catch(Exception $e){
1579
+		} catch(Exception $e){
1580 1580
 			$stage->add_error(sprintf(__("Could not convert time string '%s' using timezone '%s' into a proper DATETIME. Using current time instead.", "event_espresso"),$DATETIME_string,$timezone));
1581 1581
 			$date_obj = new DateTime();
1582 1582
 		}
Please login to merge, or discard this patch.
Spacing   +204 added lines, -204 removed lines patch added patch discarded remove patch
@@ -8,15 +8,15 @@  discard block
 block discarded – undo
8 8
 //(all other times it gets resurrected from a wordpress option)
9 9
 $stages = glob(EE_CORE.'data_migration_scripts/4_1_0_stages/*');
10 10
 $class_to_filepath = array();
11
-if ( ! empty( $stages ) ) {
12
-	foreach($stages as $filepath){
11
+if ( ! empty($stages)) {
12
+	foreach ($stages as $filepath) {
13 13
 		$matches = array();
14
-		preg_match('~4_1_0_stages/(.*).dmsstage.php~',$filepath,$matches);
14
+		preg_match('~4_1_0_stages/(.*).dmsstage.php~', $filepath, $matches);
15 15
 		$class_to_filepath[$matches[1]] = $filepath;
16 16
 	}
17 17
 }
18 18
 //give addons a chance to autoload their stages too
19
-$class_to_filepath = apply_filters('FHEE__EE_DMS_4_1_0__autoloaded_stages',$class_to_filepath);
19
+$class_to_filepath = apply_filters('FHEE__EE_DMS_4_1_0__autoloaded_stages', $class_to_filepath);
20 20
 EEH_Autoloader::register_autoloader($class_to_filepath);
21 21
 
22 22
 /**
@@ -34,7 +34,7 @@  discard block
 block discarded – undo
34 34
  * --a function named update_espresso_config() which saves the EE_Config object to the database
35 35
  * --...and all its subclasses... really, you're best off copying the whole thin gwhen 4.1 is released into this file and wrapping its declaration in if( ! class_exists()){...}
36 36
  */
37
-class EE_DMS_Core_4_1_0 extends EE_Data_Migration_Script_Base{
37
+class EE_DMS_Core_4_1_0 extends EE_Data_Migration_Script_Base {
38 38
 
39 39
 
40 40
 
@@ -67,26 +67,26 @@  discard block
 block discarded – undo
67 67
 	 * @global type $wpdb
68 68
 	 * @return boolean
69 69
 	 */
70
-	private function _checkin_table_exists(){
70
+	private function _checkin_table_exists() {
71 71
 		global $wpdb;
72 72
 		$results = $wpdb->get_results("SHOW TABLES LIKE '".$wpdb->prefix."events_attendee_checkin"."'");
73
-		if($results){
73
+		if ($results) {
74 74
 			return true;
75
-		}else{
75
+		} else {
76 76
 			return false;
77 77
 		}
78 78
 	}
79 79
 	public function can_migrate_from_version($version_array) {
80 80
 		$version_string = $version_array['Core'];
81
-		if($version_string < '4.0.0' && $version_string > '3.1.26' ){
81
+		if ($version_string < '4.0.0' && $version_string > '3.1.26') {
82 82
 //			echo "$version_string can be migrated fro";
83 83
 			return true;
84
-		}elseif( ! $version_string ){
84
+		}elseif ( ! $version_string) {
85 85
 //			echo "no version string provided: $version_string";
86 86
 			//no version string provided... this must be pre 4.1
87 87
 			//because since 4.1 we're
88
-			return false;//changed mind. dont want people thinking they should migrate yet because they cant
89
-		}else{
88
+			return false; //changed mind. dont want people thinking they should migrate yet because they cant
89
+		} else {
90 90
 //			echo "$version_string doesnt apply";
91 91
 			return false;
92 92
 		}
@@ -96,15 +96,15 @@  discard block
 block discarded – undo
96 96
 	}
97 97
 	public function schema_changes_before_migration() {
98 98
 		//relies on 4.1's EEH_Activation::create_table
99
-		require_once( EE_HELPERS . 'EEH_Activation.helper.php' );
99
+		require_once(EE_HELPERS.'EEH_Activation.helper.php');
100 100
 
101
-		$table_name='esp_answer';
102
-		$sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
101
+		$table_name = 'esp_answer';
102
+		$sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
103 103
 					REG_ID INT UNSIGNED NOT NULL,
104 104
 					QST_ID INT UNSIGNED NOT NULL,
105 105
 					ANS_value TEXT NOT NULL,
106 106
 					PRIMARY KEY  (ANS_ID)";
107
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
107
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
108 108
 
109 109
 		$table_name = 'esp_attendee_meta';
110 110
 		$sql = "ATTM_ID INT(10) UNSIGNED NOT	NULL AUTO_INCREMENT,
@@ -144,7 +144,7 @@  discard block
 block discarded – undo
144 144
 					  CNT_is_EU TINYINT(1) DEFAULT '0',
145 145
 					  CNT_active TINYINT(1) DEFAULT '0',
146 146
 					  PRIMARY KEY  (CNT_ISO)";
147
-		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB' );
147
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
148 148
 
149 149
 
150 150
 
@@ -165,7 +165,7 @@  discard block
 block discarded – undo
165 165
 
166 166
 
167 167
 
168
-		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB' );
168
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
169 169
 		$table_name = 'esp_event_meta';
170 170
 		$sql = "
171 171
 			EVTM_ID INT NOT NULL AUTO_INCREMENT,
@@ -182,41 +182,41 @@  discard block
 block discarded – undo
182 182
 			EVT_external_URL VARCHAR(200) NULL,
183 183
 			EVT_donations TINYINT(1) NULL,
184 184
 			PRIMARY KEY  (EVTM_ID)";
185
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
185
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
186 186
 
187 187
 
188 188
 
189
-		$table_name='esp_event_question_group';
190
-		$sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
189
+		$table_name = 'esp_event_question_group';
190
+		$sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
191 191
 					EVT_ID BIGINT(20) UNSIGNED NOT NULL,
192 192
 					QSG_ID INT UNSIGNED NOT NULL,
193 193
 					EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
194 194
 					PRIMARY KEY  (EQG_ID)";
195
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
195
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
196 196
 
197 197
 
198 198
 
199
-		$table_name='esp_event_venue';
200
-		$sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT,
199
+		$table_name = 'esp_event_venue';
200
+		$sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT,
201 201
 				EVT_ID BIGINT(20) UNSIGNED NOT NULL,
202 202
 				VNU_ID BIGINT(20) UNSIGNED NOT NULL,
203 203
 				EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
204 204
 				PRIMARY KEY  (EVV_ID)";
205
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
205
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
206 206
 
207 207
 
208 208
 
209
-		$table_name='esp_extra_meta';
210
-		$sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT,
209
+		$table_name = 'esp_extra_meta';
210
+		$sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT,
211 211
 				OBJ_ID INT(11) DEFAULT NULL,
212 212
 				EXM_type VARCHAR(45) DEFAULT NULL,
213 213
 				EXM_key VARCHAR(45) DEFAULT NULL,
214 214
 				EXM_value TEXT,
215 215
 				PRIMARY KEY  (EXM_ID)";
216
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
216
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
217 217
 
218
-		$table_name='esp_line_item';
219
-		$sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT,
218
+		$table_name = 'esp_line_item';
219
+		$sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT,
220 220
 				LIN_code VARCHAR(245) NOT NULL DEFAULT '',
221 221
 				TXN_ID INT(11) DEFAULT NULL,
222 222
 				LIN_name VARCHAR(245) NOT NULL DEFAULT '',
@@ -232,7 +232,7 @@  discard block
 block discarded – undo
232 232
 				OBJ_ID INT(11) DEFAULT NULL,
233 233
 				OBJ_type VARCHAR(45)DEFAULT NULL,
234 234
 				PRIMARY KEY  (LIN_ID)";
235
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB' );
235
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
236 236
 
237 237
 		$table_name = 'esp_message_template';
238 238
 		$sql = "MTP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
@@ -259,7 +259,7 @@  discard block
 block discarded – undo
259 259
 					PRIMARY KEY  (GRP_ID),
260 260
 					KEY EVT_ID (EVT_ID),
261 261
 					KEY MTP_user_id (MTP_user_id)";
262
-		$this->_table_is_new_in_this_version( $table_name, $sql, 'ENGINE=InnoDB');
262
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
263 263
 
264 264
 
265 265
 
@@ -367,8 +367,8 @@  discard block
 block discarded – undo
367 367
 
368 368
 
369 369
 
370
-		$table_name='esp_question';
371
-		$sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
370
+		$table_name = 'esp_question';
371
+		$sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
372 372
 					QST_display_text TEXT NOT NULL,
373 373
 					QST_admin_label VARCHAR(255) NOT NULL,
374 374
 					QST_system VARCHAR(25) DEFAULT NULL,
@@ -380,12 +380,12 @@  discard block
 block discarded – undo
380 380
 					QST_wp_user BIGINT UNSIGNED NULL,
381 381
 					QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0,
382 382
 					PRIMARY KEY  (QST_ID)';
383
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
383
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
384 384
 
385
-		EEH_Activation::drop_index( 'esp_question_group', 'QSG_identifier_UNIQUE' );
385
+		EEH_Activation::drop_index('esp_question_group', 'QSG_identifier_UNIQUE');
386 386
 
387 387
 		$table_name = 'esp_question_group';
388
-		$sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
388
+		$sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
389 389
 					QSG_name VARCHAR(255) NOT NULL,
390 390
 					QSG_identifier VARCHAR(100) NOT NULL,
391 391
 					QSG_desc TEXT NULL,
@@ -396,27 +396,27 @@  discard block
 block discarded – undo
396 396
 					QSG_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
397 397
 					PRIMARY KEY  (QSG_ID),
398 398
 					UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)';
399
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
399
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
400 400
 
401 401
 
402 402
 
403
-		$table_name='esp_question_group_question';
404
-		$sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
403
+		$table_name = 'esp_question_group_question';
404
+		$sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
405 405
 					QSG_ID INT UNSIGNED NOT NULL,
406 406
 					QST_ID INT UNSIGNED NOT NULL,
407 407
 					PRIMARY KEY  (QGQ_ID) ";
408
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
408
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
409 409
 
410 410
 
411 411
 
412
-		$table_name='esp_question_option';
413
-		$sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
412
+		$table_name = 'esp_question_option';
413
+		$sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT,
414 414
 					QSO_value VARCHAR(255) NOT NULL,
415 415
 					QSO_desc TEXT NOT NULL,
416 416
 					QST_ID INT UNSIGNED NOT NULL,
417 417
 					QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
418 418
 					PRIMARY KEY  (QSO_ID)";
419
-		$this->_table_is_new_in_this_version($table_name,$sql, 'ENGINE=InnoDB');
419
+		$this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB');
420 420
 
421 421
 
422 422
 
@@ -449,8 +449,8 @@  discard block
 block discarded – undo
449 449
 
450 450
 
451 451
 
452
-		$table_name='esp_checkin';
453
-		$sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
452
+		$table_name = 'esp_checkin';
453
+		$sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
454 454
 					REG_ID INT(10) UNSIGNED NOT NULL,
455 455
 					DTT_ID INT(10) UNSIGNED NOT NULL,
456 456
 					CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1,
@@ -557,12 +557,12 @@  discard block
 block discarded – undo
557 557
 
558 558
 		global $wpdb;
559 559
 		$state_table = $wpdb->prefix."esp_state";
560
-		if ( EEH_Activation::table_exists( $state_table ) ) {
560
+		if (EEH_Activation::table_exists($state_table)) {
561 561
 
562
-			$SQL = "SELECT COUNT('STA_ID') FROM " . $state_table;
562
+			$SQL = "SELECT COUNT('STA_ID') FROM ".$state_table;
563 563
 			$states = $wpdb->get_var($SQL);
564
-			if ( ! $states ) {
565
-				$SQL = "INSERT INTO " . $state_table . "
564
+			if ( ! $states) {
565
+				$SQL = "INSERT INTO ".$state_table."
566 566
 				(STA_ID, CNT_ISO, STA_abbrev, STA_name, STA_active) VALUES
567 567
 				(1, 'US', 'AK', 'Alaska', 1),
568 568
 				(2, 'US', 'AL', 'Alabama', 1),
@@ -649,12 +649,12 @@  discard block
 block discarded – undo
649 649
 
650 650
 		global $wpdb;
651 651
 		$country_table = $wpdb->prefix."esp_country";
652
-		if ( EEH_Activation::table_exists( $country_table ) ) {
652
+		if (EEH_Activation::table_exists($country_table)) {
653 653
 
654
-			$SQL = "SELECT COUNT('CNT_ISO') FROM " . $country_table;
654
+			$SQL = "SELECT COUNT('CNT_ISO') FROM ".$country_table;
655 655
 			$countries = $wpdb->get_var($SQL);
656
-			if ( ! $countries ) {
657
-				$SQL = "INSERT INTO " . $country_table . "
656
+			if ( ! $countries) {
657
+				$SQL = "INSERT INTO ".$country_table."
658 658
 				(CNT_ISO, CNT_ISO3, RGN_ID, CNT_name, CNT_cur_code, CNT_cur_single, CNT_cur_plural, CNT_cur_sign, CNT_cur_sign_b4, CNT_cur_dec_plc, CNT_tel_code, CNT_is_EU, CNT_active) VALUES
659 659
 				('AD', 'AND', 0, 'Andorra', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+376', 0, 0),
660 660
 				('AE', 'ARE', 0, 'United Arab Emirates', 'AED', 'Dirham', 'Dirhams', 'د.إ', 1, 2, '+971', 0, 0),
@@ -901,20 +901,20 @@  discard block
 block discarded – undo
901 901
 		global $wpdb;
902 902
 		$price_type_table = $wpdb->prefix."esp_price_type";
903 903
 
904
-		if ( EEH_Activation::table_exists( $price_type_table ) ) {
904
+		if (EEH_Activation::table_exists($price_type_table)) {
905 905
 
906
-			$SQL = 'SELECT COUNT(PRT_ID) FROM ' . $price_type_table;
907
-			$price_types_exist = $wpdb->get_var( $SQL );
906
+			$SQL = 'SELECT COUNT(PRT_ID) FROM '.$price_type_table;
907
+			$price_types_exist = $wpdb->get_var($SQL);
908 908
 
909
-			if ( ! $price_types_exist ) {
909
+			if ( ! $price_types_exist) {
910 910
 				$SQL = "INSERT INTO $price_type_table ( PRT_ID, PRT_name, PBT_ID, PRT_is_percent, PRT_order, PRT_deleted ) VALUES
911
-							(1, '" . __('Base Price', 'event_espresso') . "', 1,  0, 0, 0),
912
-							(2, '" . __('Percent Discount', 'event_espresso') . "', 2,  1, 20, 0),
913
-							(3, '" . __('Fixed Discount', 'event_espresso') . "', 2,  0, 30, 0),
914
-							(4, '" . __('Percent Surcharge', 'event_espresso') . "', 3,  1, 40, 0),
915
-							(5, '" . __('Fixed Surcharge', 'event_espresso') . "', 3,  0, 50, 0);";
916
-				$SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_price_types__SQL', $SQL );
917
-				$wpdb->query( $SQL );
911
+							(1, '".__('Base Price', 'event_espresso')."', 1,  0, 0, 0),
912
+							(2, '" . __('Percent Discount', 'event_espresso')."', 2,  1, 20, 0),
913
+							(3, '" . __('Fixed Discount', 'event_espresso')."', 2,  0, 30, 0),
914
+							(4, '" . __('Percent Surcharge', 'event_espresso')."', 3,  1, 40, 0),
915
+							(5, '" . __('Fixed Surcharge', 'event_espresso')."', 3,  0, 50, 0);";
916
+				$SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_price_types__SQL', $SQL);
917
+				$wpdb->query($SQL);
918 918
 			}
919 919
 		}
920 920
 	}
@@ -934,16 +934,16 @@  discard block
 block discarded – undo
934 934
 		global $wpdb;
935 935
 		$price_table = $wpdb->prefix."esp_price";
936 936
 
937
-		if ( EEH_Activation::table_exists(  $price_table ) ) {
937
+		if (EEH_Activation::table_exists($price_table)) {
938 938
 
939
-			$SQL = 'SELECT COUNT(PRC_ID) FROM ' .$price_table;
940
-			$prices_exist = $wpdb->get_var( $SQL );
939
+			$SQL = 'SELECT COUNT(PRC_ID) FROM '.$price_table;
940
+			$prices_exist = $wpdb->get_var($SQL);
941 941
 
942
-			if ( ! $prices_exist ) {
942
+			if ( ! $prices_exist) {
943 943
 				$SQL = "INSERT INTO $price_table
944 944
 							(PRC_ID, PRT_ID, PRC_amount, PRC_name, PRC_desc,  PRC_is_default, PRC_overrides, PRC_order, PRC_deleted, PRC_parent ) VALUES
945 945
 							(1, 1, '0.00', 'Free Admission', '', 1, NULL, 0, 0, 0);";
946
-				$SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_prices__SQL', $SQL );
946
+				$SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_prices__SQL', $SQL);
947 947
 				$wpdb->query($SQL);
948 948
 			}
949 949
 		}
@@ -960,34 +960,34 @@  discard block
 block discarded – undo
960 960
 
961 961
 		global $wpdb;
962 962
 		$ticket_table = $wpdb->prefix."esp_ticket";
963
-		if ( EEH_Activation::table_exists( $ticket_table ) ) {
963
+		if (EEH_Activation::table_exists($ticket_table)) {
964 964
 
965
-			$SQL = 'SELECT COUNT(TKT_ID) FROM ' . $ticket_table;
965
+			$SQL = 'SELECT COUNT(TKT_ID) FROM '.$ticket_table;
966 966
 			$tickets_exist = $wpdb->get_var($SQL);
967 967
 
968
-			if ( ! $tickets_exist ) {
968
+			if ( ! $tickets_exist) {
969 969
 				$SQL = "INSERT INTO $ticket_table
970 970
 					( TKT_ID, TTM_ID, TKT_name, TKT_description, TKT_qty, TKT_sold, TKT_uses, 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
971
-					( 1, 0, '" . __("Free Ticket", "event_espresso") . "', '', 100, 0, -1, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, 0);";
972
-				$SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL', $SQL );
971
+					( 1, 0, '".__("Free Ticket", "event_espresso")."', '', 100, 0, -1, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, 0);";
972
+				$SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL', $SQL);
973 973
 				$wpdb->query($SQL);
974 974
 			}
975 975
 		}
976 976
 		$ticket_price_table = $wpdb->prefix."esp_ticket_price";
977 977
 
978
-		if ( EEH_Activation::table_exists( $ticket_price_table ) ) {
978
+		if (EEH_Activation::table_exists($ticket_price_table)) {
979 979
 
980
-			$SQL = 'SELECT COUNT(TKP_ID) FROM ' . $ticket_price_table;
980
+			$SQL = 'SELECT COUNT(TKP_ID) FROM '.$ticket_price_table;
981 981
 			$ticket_prc_exist = $wpdb->get_var($SQL);
982 982
 
983
-			if ( ! $ticket_prc_exist ) {
983
+			if ( ! $ticket_prc_exist) {
984 984
 
985 985
 				$SQL = "INSERT INTO $ticket_price_table
986 986
 				( TKP_ID, TKT_ID, PRC_ID ) VALUES
987 987
 				( 1, 1, 1 )
988 988
 				";
989 989
 
990
-				$SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL__ticket_price', $SQL );
990
+				$SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL__ticket_price', $SQL);
991 991
 				$wpdb->query($SQL);
992 992
 			}
993 993
 		}
@@ -1000,20 +1000,20 @@  discard block
 block discarded – undo
1000 1000
 	 * @param string $country_name
1001 1001
 	 * @return array where keys are columns, values are column values
1002 1002
 	 */
1003
-	public function get_or_create_country($country_name){
1004
-		if( ! $country_name ){
1003
+	public function get_or_create_country($country_name) {
1004
+		if ( ! $country_name) {
1005 1005
 			throw new EE_Error(__("Could not get a country because country name is blank", "event_espresso"));
1006 1006
 		}
1007 1007
 		global $wpdb;
1008 1008
 		$country_table = $wpdb->prefix."esp_country";
1009
-		if(is_int($country_name)){
1009
+		if (is_int($country_name)) {
1010 1010
 			$country_name = $this->get_iso_from_3_1_country_id($country_name);
1011 1011
 		}
1012 1012
 		$country = $wpdb->get_row($wpdb->prepare("SELECT * FROM $country_table WHERE
1013 1013
 			CNT_ISO LIKE %s OR
1014 1014
 			CNT_ISO3 LIKE %s OR
1015
-			CNT_name LIKE %s LIMIT 1",$country_name,$country_name,$country_name),ARRAY_A);
1016
-		if( ! $country ){
1015
+			CNT_name LIKE %s LIMIT 1", $country_name, $country_name, $country_name), ARRAY_A);
1016
+		if ( ! $country) {
1017 1017
 			//insert a new one then
1018 1018
 			$cols_n_values = array(
1019 1019
 				'CNT_ISO'=> $this->_find_available_country_iso(2),
@@ -1033,26 +1033,26 @@  discard block
 block discarded – undo
1033 1033
 				'CNT_active'=>true
1034 1034
 			);
1035 1035
 			$data_types = array(
1036
-				'%s',//CNT_ISO
1037
-				'%s',//CNT_ISO3
1038
-				'%d',//RGN_ID
1039
-				'%s',//CNT_name
1040
-				'%s',//CNT_cur_code
1041
-				'%s',//CNT_cur_single
1042
-				'%s',//CNT_cur_plural
1043
-				'%s',//CNT_cur_sign
1044
-				'%d',//CNT_cur_sign_b4
1045
-				'%d',//CNT_cur_dec_plc
1046
-				'%s',//CNT_cur_dec_mrk
1047
-				'%s',//CNT_cur_thsnds
1048
-				'%s',//CNT_tel_code
1049
-				'%d',//CNT_is_EU
1050
-				'%d',//CNT_active
1036
+				'%s', //CNT_ISO
1037
+				'%s', //CNT_ISO3
1038
+				'%d', //RGN_ID
1039
+				'%s', //CNT_name
1040
+				'%s', //CNT_cur_code
1041
+				'%s', //CNT_cur_single
1042
+				'%s', //CNT_cur_plural
1043
+				'%s', //CNT_cur_sign
1044
+				'%d', //CNT_cur_sign_b4
1045
+				'%d', //CNT_cur_dec_plc
1046
+				'%s', //CNT_cur_dec_mrk
1047
+				'%s', //CNT_cur_thsnds
1048
+				'%s', //CNT_tel_code
1049
+				'%d', //CNT_is_EU
1050
+				'%d', //CNT_active
1051 1051
 			);
1052 1052
 			$success = $wpdb->insert($country_table,
1053 1053
 					$cols_n_values,
1054 1054
 					$data_types);
1055
-			if( ! $success){
1055
+			if ( ! $success) {
1056 1056
 				throw new EE_Error($this->_create_error_message_for_db_insertion('N/A', array('country_id'=>$country_name), $country_table, $cols_n_values, $data_types));
1057 1057
 			}
1058 1058
 			$country = $cols_n_values;
@@ -1064,13 +1064,13 @@  discard block
 block discarded – undo
1064 1064
 	 * @global type $wpdb
1065 1065
 	 * @return string
1066 1066
 	 */
1067
-	private function _find_available_country_iso($num_letters = 2){
1067
+	private function _find_available_country_iso($num_letters = 2) {
1068 1068
 		global $wpdb;
1069 1069
 		$country_table = $wpdb->prefix."esp_country";
1070
-		do{
1070
+		do {
1071 1071
 			$current_iso = strtoupper(wp_generate_password($num_letters, false));
1072
-			$country_with_that_iso = $wpdb->get_var($wpdb->prepare("SELECT count(CNT_ISO) FROM ".$country_table." WHERE CNT_ISO=%s",$current_iso));
1073
-		}while(intval($country_with_that_iso));
1072
+			$country_with_that_iso = $wpdb->get_var($wpdb->prepare("SELECT count(CNT_ISO) FROM ".$country_table." WHERE CNT_ISO=%s", $current_iso));
1073
+		}while (intval($country_with_that_iso));
1074 1074
 		return $current_iso;
1075 1075
 	}
1076 1076
 
@@ -1081,14 +1081,14 @@  discard block
 block discarded – undo
1081 1081
 	 * @param string $state_name
1082 1082
 	 * @return array where keys are columns, values are column values
1083 1083
 	 */
1084
-	public function get_or_create_state($state_name,$country_name = ''){
1085
-		if( ! $state_name ){
1084
+	public function get_or_create_state($state_name, $country_name = '') {
1085
+		if ( ! $state_name) {
1086 1086
 			throw new EE_Error(__("Could not get-or-create state because no state name was provided", "event_espresso"));
1087 1087
 		}
1088
-		try{
1088
+		try {
1089 1089
 			$country = $this->get_or_create_country($country_name);
1090 1090
 			$country_iso = $country['CNT_ISO'];
1091
-		}catch(EE_Error $e){
1091
+		} catch (EE_Error $e) {
1092 1092
 			$country_iso = $this->get_default_country_iso();
1093 1093
 		}
1094 1094
 		global $wpdb;
@@ -1096,24 +1096,24 @@  discard block
 block discarded – undo
1096 1096
 		$state = $wpdb->get_row($wpdb->prepare("SELECT * FROM $state_table WHERE
1097 1097
 			(STA_abbrev LIKE %s OR
1098 1098
 			STA_name LIKE %s) AND
1099
-			CNT_ISO LIKE %s LIMIT 1",$state_name,$state_name,$country_iso),ARRAY_A);
1100
-		if ( ! $state){
1099
+			CNT_ISO LIKE %s LIMIT 1", $state_name, $state_name, $country_iso), ARRAY_A);
1100
+		if ( ! $state) {
1101 1101
 			//insert a new one then
1102 1102
 			$cols_n_values = array(
1103 1103
 				'CNT_ISO'=>$country_iso,
1104
-				'STA_abbrev'=>substr($state_name,0,6),
1104
+				'STA_abbrev'=>substr($state_name, 0, 6),
1105 1105
 				'STA_name'=>$state_name,
1106 1106
 				'STA_active'=>true
1107 1107
 			);
1108 1108
 			$data_types = array(
1109
-				'%s',//CNT_ISO
1110
-				'%s',//STA_abbrev
1111
-				'%s',//STA_name
1112
-				'%d',//STA_active
1109
+				'%s', //CNT_ISO
1110
+				'%s', //STA_abbrev
1111
+				'%s', //STA_name
1112
+				'%d', //STA_active
1113 1113
 			);
1114
-			$success = $wpdb->insert($state_table,$cols_n_values,$data_types);
1115
-			if ( ! $success ){
1116
-				throw new EE_Error($this->_create_error_message_for_db_insertion('N/A', array('state'=>$state_name,'country_id'=>$country_name), $state_table, $cols_n_values, $data_types));
1114
+			$success = $wpdb->insert($state_table, $cols_n_values, $data_types);
1115
+			if ( ! $success) {
1116
+				throw new EE_Error($this->_create_error_message_for_db_insertion('N/A', array('state'=>$state_name, 'country_id'=>$country_name), $state_table, $cols_n_values, $data_types));
1117 1117
 			}
1118 1118
 			$state = $cols_n_values;
1119 1119
 			$state['STA_ID'] = $wpdb->insert_id;
@@ -1126,21 +1126,21 @@  discard block
 block discarded – undo
1126 1126
 	 * @param type $timeString
1127 1127
 	 * @return string in the php DATETIME format: "G:i" (24-hour format hour with leading zeros, a colon, and minutes with leading zeros)
1128 1128
 	 */
1129
-	public function convertTimeFromAMPM($timeString){
1129
+	public function convertTimeFromAMPM($timeString) {
1130 1130
 		$matches = array();
1131
-		preg_match("~(\\d*):(\\d*)~",$timeString,$matches);
1132
-		if( ! $matches || count($matches)<3){
1131
+		preg_match("~(\\d*):(\\d*)~", $timeString, $matches);
1132
+		if ( ! $matches || count($matches) < 3) {
1133 1133
 			$hour = '00';
1134 1134
 			$minutes = '00';
1135
-		}else{
1135
+		} else {
1136 1136
 			$hour = intval($matches[1]);
1137 1137
 			$minutes = $matches[2];
1138 1138
 		}
1139
-		if(strpos($timeString, 'PM') || strpos($timeString, 'pm')){
1139
+		if (strpos($timeString, 'PM') || strpos($timeString, 'pm')) {
1140 1140
 			$hour = intval($hour) + 12;
1141 1141
 		}
1142
-		$hour = str_pad( "$hour", 2, '0',STR_PAD_LEFT);
1143
-		$minutes = str_pad( "$minutes", 2, '0',STR_PAD_LEFT);
1142
+		$hour = str_pad("$hour", 2, '0', STR_PAD_LEFT);
1143
+		$minutes = str_pad("$minutes", 2, '0', STR_PAD_LEFT);
1144 1144
 		return "$hour:$minutes";
1145 1145
 	}
1146 1146
 
@@ -1149,7 +1149,7 @@  discard block
 block discarded – undo
1149 1149
 	 * @param int $country_id
1150 1150
 	 * @return string the country's ISO3 code
1151 1151
 	 */
1152
-	public function get_iso_from_3_1_country_id($country_id){
1152
+	public function get_iso_from_3_1_country_id($country_id) {
1153 1153
 		$old_countries = array(
1154 1154
 			array(64, 'United States', 'US', 'USA', 1),
1155 1155
 			array(15, 'Australia', 'AU', 'AUS', 1),
@@ -1375,9 +1375,9 @@  discard block
 block discarded – undo
1375 1375
 			array(226, 'Zimbabwe', 'ZW', 'ZWE', 1));
1376 1376
 
1377 1377
 		$country_iso = 'US';
1378
-		foreach($old_countries as $country_array){
1378
+		foreach ($old_countries as $country_array) {
1379 1379
 			//note: index 0 is the 3.1 country ID
1380
-			if($country_array[0] == $country_id){
1380
+			if ($country_array[0] == $country_id) {
1381 1381
 				//note: index 2 is the ISO
1382 1382
 				$country_iso = $country_array[2];
1383 1383
 				break;
@@ -1390,8 +1390,8 @@  discard block
 block discarded – undo
1390 1390
 	 * Gets the ISO3 for the
1391 1391
 	 * @return string
1392 1392
 	 */
1393
-	public function get_default_country_iso(){
1394
-		$old_org_options= get_option('events_organization_settings');
1393
+	public function get_default_country_iso() {
1394
+		$old_org_options = get_option('events_organization_settings');
1395 1395
 		$iso = $this->get_iso_from_3_1_country_id($old_org_options['organization_country']);
1396 1396
 		return $iso;
1397 1397
 	}
@@ -1403,13 +1403,13 @@  discard block
 block discarded – undo
1403 1403
 	 * the event's DEFAULT payment status, or the attendee's payment status) required pre-approval.
1404 1404
 	 * @return string STS_ID for use in 4.1
1405 1405
 	 */
1406
-	public function convert_3_1_payment_status_to_4_1_STS_ID($payment_status, $this_thing_required_pre_approval = false){
1406
+	public function convert_3_1_payment_status_to_4_1_STS_ID($payment_status, $this_thing_required_pre_approval = false) {
1407 1407
 
1408 1408
 		//EE team can read the related discussion: https://app.asana.com/0/2400967562914/9418495544455
1409
-		if($this_thing_required_pre_approval){
1409
+		if ($this_thing_required_pre_approval) {
1410 1410
 				return 'RNA';
1411
-		}else{
1412
-				$mapping = $default_reg_stati_conversions=array(
1411
+		} else {
1412
+				$mapping = $default_reg_stati_conversions = array(
1413 1413
 			'Completed'=>'RAP',
1414 1414
 			''=>'RPP',
1415 1415
 			'Incomplete'=>'RPP',
@@ -1439,22 +1439,22 @@  discard block
 block discarded – undo
1439 1439
 	 * @param  EE_Data_Migration_Script_Stage $migration_stage the stage which called this, where errors should be added
1440 1440
 	 * @return boolean whether or not we had to do the big job of creating an image attachment
1441 1441
 	 */
1442
-	public function convert_image_url_to_attachment_and_attach_to_post($guid,$new_cpt_id,  EE_Data_Migration_Script_Stage $migration_stage){
1442
+	public function convert_image_url_to_attachment_and_attach_to_post($guid, $new_cpt_id, EE_Data_Migration_Script_Stage $migration_stage) {
1443 1443
 		$created_attachment_post = false;
1444 1444
 		$guid = $this->_get_original_guid($guid);
1445
-		if($guid){
1445
+		if ($guid) {
1446 1446
 			//check for an existing attachment post with this guid
1447 1447
 			$attachment_post_id = $this->_get_image_attachment_id_by_GUID($guid);
1448
-			if( ! $attachment_post_id){
1448
+			if ( ! $attachment_post_id) {
1449 1449
 				//post thumbnail with that GUID doesn't exist, we should create one
1450 1450
 				$attachment_post_id = $this->_create_image_attachment_from_GUID($guid, $migration_stage);
1451 1451
 				$created_attachment_post = true;
1452 1452
 			}
1453 1453
 			//double-check we actually have an attachment post
1454
-			if( $attachment_post_id){
1455
-				update_post_meta($new_cpt_id,'_thumbnail_id',$attachment_post_id);
1456
-			}else{
1457
-				$migration_stage->add_error(sprintf(__("Could not update event image %s for CPT with ID %d, but attachments post ID is %d", "event_espresso"),$guid,$new_cpt_id,$attachment_post_id));
1454
+			if ($attachment_post_id) {
1455
+				update_post_meta($new_cpt_id, '_thumbnail_id', $attachment_post_id);
1456
+			} else {
1457
+				$migration_stage->add_error(sprintf(__("Could not update event image %s for CPT with ID %d, but attachments post ID is %d", "event_espresso"), $guid, $new_cpt_id, $attachment_post_id));
1458 1458
 			}
1459 1459
 		}
1460 1460
 		return $created_attachment_post;
@@ -1468,13 +1468,13 @@  discard block
 block discarded – undo
1468 1468
 	 * @param string $guid_in_old_event
1469 1469
 	 * @return string either the original guid, or $guid_in_old_event if we couldn't figure out what the original was
1470 1470
 	 */
1471
-	private function _get_original_guid($guid_in_old_event){
1472
-		$original_guid = preg_replace('~-\d*x\d*\.~','.',$guid_in_old_event,1);
1471
+	private function _get_original_guid($guid_in_old_event) {
1472
+		$original_guid = preg_replace('~-\d*x\d*\.~', '.', $guid_in_old_event, 1);
1473 1473
 		//do a head request to verify the file exists
1474 1474
 		$head_response = wp_remote_head($original_guid);
1475
-		if( ! $head_response instanceof WP_Error && $head_response['response']['message'] == 'OK'){
1475
+		if ( ! $head_response instanceof WP_Error && $head_response['response']['message'] == 'OK') {
1476 1476
 			return $original_guid;
1477
-		}else{
1477
+		} else {
1478 1478
 			return $guid_in_old_event;
1479 1479
 		}
1480 1480
 	}
@@ -1486,32 +1486,32 @@  discard block
 block discarded – undo
1486 1486
 	 * @param EE_Data_Migration_Script_Stage $migration_stage
1487 1487
 	 * @return int
1488 1488
 	 */
1489
-	private function _create_image_attachment_from_GUID($guid, EE_Data_Migration_Script_Stage $migration_stage){
1490
-		if ( ! $guid){
1489
+	private function _create_image_attachment_from_GUID($guid, EE_Data_Migration_Script_Stage $migration_stage) {
1490
+		if ( ! $guid) {
1491 1491
 			$migration_stage->add_error(sprintf(__("Cannot create image attachment for a blank GUID!", "event_espresso")));
1492 1492
 			return 0;
1493 1493
 		}
1494
-		$wp_filetype = wp_check_filetype(basename($guid), null );
1494
+		$wp_filetype = wp_check_filetype(basename($guid), null);
1495 1495
 		$wp_upload_dir = wp_upload_dir();
1496 1496
 		//if the file is located remotely, download it to our uploads DIR, because wp_genereate_attachmnet_metadata needs the file to be local
1497
-		if(strpos($guid,$wp_upload_dir['url']) === FALSE){
1497
+		if (strpos($guid, $wp_upload_dir['url']) === FALSE) {
1498 1498
 			//image is located remotely. download it and place it in the uploads directory
1499
-			if( ! is_readable($guid)){
1500
-				$migration_stage->add_error(sprintf(__("Could not create image attachment from non-existent file: %s", "event_espresso"),$guid));
1499
+			if ( ! is_readable($guid)) {
1500
+				$migration_stage->add_error(sprintf(__("Could not create image attachment from non-existent file: %s", "event_espresso"), $guid));
1501 1501
 				return 0;
1502 1502
 			}
1503
-			$contents= file_get_contents($guid);
1504
-			if($contents === FALSE){
1505
-				$migration_stage->add_error(sprintf(__("Could not read image at %s, and therefore couldnt create an attachment post for it.", "event_espresso"),$guid));
1503
+			$contents = file_get_contents($guid);
1504
+			if ($contents === FALSE) {
1505
+				$migration_stage->add_error(sprintf(__("Could not read image at %s, and therefore couldnt create an attachment post for it.", "event_espresso"), $guid));
1506 1506
 				return false;
1507 1507
 			}
1508
-			$local_filepath  = $wp_upload_dir['path'].DS.basename($guid);
1508
+			$local_filepath = $wp_upload_dir['path'].DS.basename($guid);
1509 1509
 			$savefile = fopen($local_filepath, 'w');
1510 1510
 			fwrite($savefile, $contents);
1511 1511
 			fclose($savefile);
1512
-			$guid = str_replace($wp_upload_dir['path'],$wp_upload_dir['url'],$local_filepath);
1513
-		}else{
1514
-			$local_filepath = str_replace($wp_upload_dir['url'],$wp_upload_dir['path'],$guid);
1512
+			$guid = str_replace($wp_upload_dir['path'], $wp_upload_dir['url'], $local_filepath);
1513
+		} else {
1514
+			$local_filepath = str_replace($wp_upload_dir['url'], $wp_upload_dir['path'], $guid);
1515 1515
 		}
1516 1516
 
1517 1517
 		$attachment = array(
@@ -1521,24 +1521,24 @@  discard block
 block discarded – undo
1521 1521
 		   'post_content' => '',
1522 1522
 		   'post_status' => 'inherit'
1523 1523
 		);
1524
-		$attach_id = wp_insert_attachment( $attachment, $guid );
1525
-		if( ! $attach_id ){
1526
-			$migration_stage->add_error(sprintf(__("Could not create image attachment post from image '%s'. Attachment data was %s.", "event_espresso"),$guid,$this->_json_encode($attachment)));
1524
+		$attach_id = wp_insert_attachment($attachment, $guid);
1525
+		if ( ! $attach_id) {
1526
+			$migration_stage->add_error(sprintf(__("Could not create image attachment post from image '%s'. Attachment data was %s.", "event_espresso"), $guid, $this->_json_encode($attachment)));
1527 1527
 			return $attach_id;
1528 1528
 		}
1529 1529
 
1530 1530
 		// you must first include the image.php file
1531 1531
 		// for the function wp_generate_attachment_metadata() to work
1532
-		require_once(ABSPATH . 'wp-admin/includes/image.php');
1532
+		require_once(ABSPATH.'wp-admin/includes/image.php');
1533 1533
 
1534
-		$attach_data = wp_generate_attachment_metadata( $attach_id, $local_filepath );
1535
-		if( ! $attach_data){
1536
-			$migration_stage->add_error(sprintf(__("Coudl not genereate attachment metadata for attachment post %d with filepath %s and GUID %s. Please check the file was downloaded properly.", "event_espresso"),$attach_id,$local_filepath,$guid));
1534
+		$attach_data = wp_generate_attachment_metadata($attach_id, $local_filepath);
1535
+		if ( ! $attach_data) {
1536
+			$migration_stage->add_error(sprintf(__("Coudl not genereate attachment metadata for attachment post %d with filepath %s and GUID %s. Please check the file was downloaded properly.", "event_espresso"), $attach_id, $local_filepath, $guid));
1537 1537
 			return $attach_id;
1538 1538
 		}
1539
-		$metadata_save_result = wp_update_attachment_metadata( $attach_id, $attach_data );
1540
-		if( ! $metadata_save_result ){
1541
-			$migration_stage->add_error(sprintf(__("Could not update attachment metadata for attachment %d with data %s", "event_espresso"),$attach_id,$this->_json_encode($attach_data)));
1539
+		$metadata_save_result = wp_update_attachment_metadata($attach_id, $attach_data);
1540
+		if ( ! $metadata_save_result) {
1541
+			$migration_stage->add_error(sprintf(__("Could not update attachment metadata for attachment %d with data %s", "event_espresso"), $attach_id, $this->_json_encode($attach_data)));
1542 1542
 		}
1543 1543
 		return $attach_id;
1544 1544
 	}
@@ -1550,9 +1550,9 @@  discard block
 block discarded – undo
1550 1550
 	 * @param string $guid
1551 1551
 	 * @return int
1552 1552
 	 */
1553
-	private function _get_image_attachment_id_by_GUID($guid){
1553
+	private function _get_image_attachment_id_by_GUID($guid) {
1554 1554
 		global $wpdb;
1555
-		$attachment_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM $wpdb->posts WHERE guid=%s LIMIT 1",$guid));
1555
+		$attachment_id = $wpdb->get_var($wpdb->prepare("SELECT ID FROM $wpdb->posts WHERE guid=%s LIMIT 1", $guid));
1556 1556
 		return $attachment_id;
1557 1557
 	}
1558 1558
 	/**
@@ -1564,20 +1564,20 @@  discard block
 block discarded – undo
1564 1564
 	 * @param string $timezone
1565 1565
 	 * @return string
1566 1566
 	 */
1567
-	public function convert_date_string_to_utc(EE_Data_Migration_Script_Stage $stage, $row_of_data, $DATETIME_string,$timezone = null){
1567
+	public function convert_date_string_to_utc(EE_Data_Migration_Script_Stage $stage, $row_of_data, $DATETIME_string, $timezone = null) {
1568 1568
 		$original_tz = $timezone;
1569
-		if( ! $timezone){
1569
+		if ( ! $timezone) {
1570 1570
 			$timezone = $this->_get_wp_timezone();
1571 1571
 		}
1572
-		if( ! $timezone){
1573
-			$stage->add_error(sprintf(__("Could not find timezone given %s for %s", "event_espresso"),$original_tz,$row_of_data));
1572
+		if ( ! $timezone) {
1573
+			$stage->add_error(sprintf(__("Could not find timezone given %s for %s", "event_espresso"), $original_tz, $row_of_data));
1574 1574
 			$timezone = 'UTC';
1575 1575
 		}
1576
-		try{
1577
-			$date_obj = new DateTime( $DATETIME_string, new DateTimeZone( $timezone ) );
1576
+		try {
1577
+			$date_obj = new DateTime($DATETIME_string, new DateTimeZone($timezone));
1578 1578
 			$date_obj->setTimezone(new DateTimeZone('UTC'));
1579
-		}catch(Exception $e){
1580
-			$stage->add_error(sprintf(__("Could not convert time string '%s' using timezone '%s' into a proper DATETIME. Using current time instead.", "event_espresso"),$DATETIME_string,$timezone));
1579
+		} catch (Exception $e) {
1580
+			$stage->add_error(sprintf(__("Could not convert time string '%s' using timezone '%s' into a proper DATETIME. Using current time instead.", "event_espresso"), $DATETIME_string, $timezone));
1581 1581
 			$date_obj = new DateTime();
1582 1582
 		}
1583 1583
 
@@ -1588,14 +1588,14 @@  discard block
 block discarded – undo
1588 1588
 	 * Gets the DEFAULT timezone string from wordpress (even if they set a gmt offset)
1589 1589
 	 * @return string
1590 1590
 	 */
1591
-	private function _get_wp_timezone(){
1592
-		$timezone = empty( $timezone ) ? get_option('timezone_string') : $timezone;
1591
+	private function _get_wp_timezone() {
1592
+		$timezone = empty($timezone) ? get_option('timezone_string') : $timezone;
1593 1593
 
1594 1594
 		//if timezone is STILL empty then let's get the GMT offset and then set the timezone_string using our converter
1595
-		if ( empty( $timezone ) ) {
1595
+		if (empty($timezone)) {
1596 1596
 			//let's get a the WordPress UTC offset
1597 1597
 			$offset = get_option('gmt_offset');
1598
-			$timezone = $this->timezone_convert_to_string_from_offset( $offset );
1598
+			$timezone = $this->timezone_convert_to_string_from_offset($offset);
1599 1599
 		}
1600 1600
 		return $timezone;
1601 1601
 	}
@@ -1604,11 +1604,11 @@  discard block
 block discarded – undo
1604 1604
 	 * @param int $offset
1605 1605
 	 * @return boolean
1606 1606
 	 */
1607
-	private function timezone_convert_to_string_from_offset($offset){
1607
+	private function timezone_convert_to_string_from_offset($offset) {
1608 1608
 		//shamelessly taken from bottom comment at http://ca1.php.net/manual/en/function.timezone-name-from-abbr.php because timezone_name_from_abbr() did NOT work as expected - its not reliable
1609 1609
 		$offset *= 3600; // convert hour offset to seconds
1610 1610
         $abbrarray = timezone_abbreviations_list();
1611
-        foreach ($abbrarray as $abbr){
1611
+        foreach ($abbrarray as $abbr) {
1612 1612
                 foreach ($abbr as $city)
1613 1613
                 {
1614 1614
                         if ($city['offset'] == $offset)
@@ -1622,32 +1622,32 @@  discard block
 block discarded – undo
1622 1622
         return FALSE;
1623 1623
 	}
1624 1624
 
1625
-	public function migration_page_hooks(){
1626
-		add_filter('FHEE__ee_migration_page__header',array($this,'_migrate_page_hook_simplify_version_strings'),10,3);
1627
-		add_filter('FHEE__ee_migration_page__p_after_header',array($this,'_migration_page_hook_simplify_next_db_state'),10,2);
1628
-		add_filter('FHEE__ee_migration_page__option_1_main',array($this,'_migrate_page_hook_simplify_version_strings'),10,3);
1629
-		add_filter('FHEE__ee_migration_page__option_1_button_text',array($this,'_migrate_page_hook_simplify_version_strings'),10,3);
1630
-		add_action('AHEE__ee_migration_page__option_1_extra_details',array($this,'_migration_page_hook_option_1_extra_details'),10,3);
1631
-		add_filter('FHEE__ee_migration_page__option_2_main',array($this,'_migrate_page_hook_simplify_version_strings'),10,4);
1632
-		add_filter('FHEE__ee_migration_page__option_2_button_text',array($this,'_migration_page_hook_simplify_next_db_state'),10,2);
1633
-		add_filter('FHEE__ee_migration_page__option_2_details',array($this,'_migration_page_hook_simplify_next_db_state'),10,2);
1634
-		add_action('AHEE__ee_migration_page__after_migration_options_table',array($this,'_migration_page_hook_after_migration_options_table'));
1635
-		add_filter('FHEE__ee_migration_page__done_migration_header',array($this,'_migration_page_hook_simplify_next_db_state'),10,2);
1636
-		add_filter('FHEE__ee_migration_page__p_after_done_migration_header',array($this,'_migration_page_hook_simplify_next_db_state'),10,2);
1625
+	public function migration_page_hooks() {
1626
+		add_filter('FHEE__ee_migration_page__header', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 3);
1627
+		add_filter('FHEE__ee_migration_page__p_after_header', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2);
1628
+		add_filter('FHEE__ee_migration_page__option_1_main', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 3);
1629
+		add_filter('FHEE__ee_migration_page__option_1_button_text', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 3);
1630
+		add_action('AHEE__ee_migration_page__option_1_extra_details', array($this, '_migration_page_hook_option_1_extra_details'), 10, 3);
1631
+		add_filter('FHEE__ee_migration_page__option_2_main', array($this, '_migrate_page_hook_simplify_version_strings'), 10, 4);
1632
+		add_filter('FHEE__ee_migration_page__option_2_button_text', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2);
1633
+		add_filter('FHEE__ee_migration_page__option_2_details', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2);
1634
+		add_action('AHEE__ee_migration_page__after_migration_options_table', array($this, '_migration_page_hook_after_migration_options_table'));
1635
+		add_filter('FHEE__ee_migration_page__done_migration_header', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2);
1636
+		add_filter('FHEE__ee_migration_page__p_after_done_migration_header', array($this, '_migration_page_hook_simplify_next_db_state'), 10, 2);
1637 1637
 	}
1638 1638
 
1639
-	public function _migrate_page_hook_simplify_version_strings($old_content,$current_db_state,$next_db_state,$ultimate_db_state = NULL){
1640
-		return str_replace(array($current_db_state,$next_db_state,$ultimate_db_state),array(__('EE3','event_espresso'),__('EE4','event_espresso'),  __("EE4", 'event_espresso')),$old_content);
1639
+	public function _migrate_page_hook_simplify_version_strings($old_content, $current_db_state, $next_db_state, $ultimate_db_state = NULL) {
1640
+		return str_replace(array($current_db_state, $next_db_state, $ultimate_db_state), array(__('EE3', 'event_espresso'), __('EE4', 'event_espresso'), __("EE4", 'event_espresso')), $old_content);
1641 1641
 	}
1642
-	public function _migration_page_hook_simplify_next_db_state($old_content,$next_db_state){
1643
-		return str_replace($next_db_state,  __("EE4", 'event_espresso'),$old_content);
1642
+	public function _migration_page_hook_simplify_next_db_state($old_content, $next_db_state) {
1643
+		return str_replace($next_db_state, __("EE4", 'event_espresso'), $old_content);
1644 1644
 	}
1645
-	public function _migration_page_hook_option_1_extra_details(){
1646
-		?><p><?php	printf(__("Note: many of your EE3 shortcodes will be changed to EE4 shortcodes during this migration (among many other things). Should you revert to EE3, then you should restore to your backup or manually change the EE4 shortcodes back to their EE3 equivalents", "event_espresso"));?></p><?php
1645
+	public function _migration_page_hook_option_1_extra_details() {
1646
+		?><p><?php	printf(__("Note: many of your EE3 shortcodes will be changed to EE4 shortcodes during this migration (among many other things). Should you revert to EE3, then you should restore to your backup or manually change the EE4 shortcodes back to their EE3 equivalents", "event_espresso")); ?></p><?php
1647 1647
 	}
1648
-	public function _migration_page_hook_after_migration_options_table(){
1648
+	public function _migration_page_hook_after_migration_options_table() {
1649 1649
 		?><p class="ee-attention">
1650
-				<strong><span class="reminder-spn"><?php _e("Important note to those using Event Espresso 3 addons: ", "event_espresso");?></span></strong><br/><?php _e("Unless an addon's description on our website explicitly states that it is compatible with EE4, you should consider it incompatible and know that it WILL NOT WORK correctly with this new version of Event Espresso 4 (EE4). As well, any data for incompatible addons will NOT BE MIGRATED until an updated EE4 compatible version of the addon is available. If you want, or need to keep using your EE3 addons, you should simply continue using EE3 until EE4 compatible versions of your addons become available. To continue using EE3 for now, just deactivate EE4 and reactivate EE3.", "event_espresso");	?>
1650
+				<strong><span class="reminder-spn"><?php _e("Important note to those using Event Espresso 3 addons: ", "event_espresso"); ?></span></strong><br/><?php _e("Unless an addon's description on our website explicitly states that it is compatible with EE4, you should consider it incompatible and know that it WILL NOT WORK correctly with this new version of Event Espresso 4 (EE4). As well, any data for incompatible addons will NOT BE MIGRATED until an updated EE4 compatible version of the addon is available. If you want, or need to keep using your EE3 addons, you should simply continue using EE3 until EE4 compatible versions of your addons become available. To continue using EE3 for now, just deactivate EE4 and reactivate EE3.", "event_espresso"); ?>
1651 1651
 			</p><?php
1652 1652
 	}
1653 1653
 }
Please login to merge, or discard this patch.
core/db_classes/EE_CSV.class.php 4 patches
Doc Comments   +6 added lines, -8 removed lines patch added patch discarded remove patch
@@ -287,7 +287,7 @@  discard block
 block discarded – undo
287 287
 	 * Sends HTTP headers to indicate that the browser should download a file,
288 288
 	 * and starts writing the file to PHP's output. Returns the file handle so other functions can
289 289
 	 * also write to it
290
-	 * @param string $new_filename the name of the file that the user will download
290
+	 * @param string|false $filename the name of the file that the user will download
291 291
 	 * @return resource, like the results of fopen(), which can be used for fwrite, fputcsv2, etc.
292 292
 	 */
293 293
 	public function begin_sending_csv($filename){
@@ -343,9 +343,7 @@  discard block
 block discarded – undo
343 343
 	/**
344 344
 	 * Writes $data to the csv file open in $filehandle. uses the array indices of $data for column headers
345 345
 	 * @param array $data 2D array, first numerically-indexed, and next-level-down preferably indexed by string
346
-	 * @param boolean $add_csv_column_names whether or not we should add the keys in the bottom-most array as a row for headers in the CSV.
347
-	 * Eg, if $data looked like array(0=>array('EVT_ID'=>1,'EVT_name'=>'monkey'...), 1=>array(...),...))
348
-	 * then the first row we'd write to the CSV would be "EVT_ID,EVT_name,..."
346
+	 * @param resource $filehandle
349 347
 	 * @return boolean if we successfully wrote to the CSV or not. If there's no $data, we consider that a success (because we wrote everything there was...nothing)
350 348
 	 */
351 349
 	public function write_data_array_to_csv($filehandle, $data){
@@ -427,7 +425,7 @@  discard block
 block discarded – undo
427 425
 	 * @param array $model_data_array is assumed to be a 3d array: 1st layer has keys of model names (eg 'Event'),
428 426
 	 * next layer is numerically indexed to represent each model object (eg, each individual event), and the last layer
429 427
 	 * has all the attributes o fthat model object (eg, the event's id, name, etc)
430
-	 * @return boolean success
428
+	 * @return boolean|null success
431 429
 	 */
432 430
 	public function write_model_data_to_csv($filehandle,$model_data_array){
433 431
 		$this->write_metadata_to_csv($filehandle);
@@ -456,8 +454,8 @@  discard block
 block discarded – undo
456 454
 	 * Writes the CSV file to the output buffer, with rows corresponding to $model_data_array,
457 455
 	 * and dies (in order to avoid other plugins from messing up the csv output)
458 456
 	 * @param string $filename the filename you want to give the file
459
-	 * @param array $model_data_array 3d array, as described in EE_CSV::write_model_data_to_csv()
460
-	 * @return bool | void writes CSV file to output and dies
457
+	 * @param boolean $model_data_array 3d array, as described in EE_CSV::write_model_data_to_csv()
458
+	 * @return boolean|null | void writes CSV file to output and dies
461 459
 	 */
462 460
 	public function export_multiple_model_data_to_csv($filename,$model_data_array){
463 461
 		$filehandle = $this->begin_sending_csv($filename);
@@ -469,7 +467,7 @@  discard block
 block discarded – undo
469 467
 	 *		  @access public
470 468
 	 *			@param array $data - the array of data to be converted to csv and exported
471 469
 	 *			@param string $filename - name for newly created csv file
472
-	 *			@return TRUE on success, FALSE on fail
470
+	 *			@return false|null on success, FALSE on fail
473 471
 	 */
474 472
 	public function export_array_to_csv( $data = FALSE, $filename = FALSE  ) {
475 473
 
Please login to merge, or discard this patch.
Braces   +12 added lines, -9 removed lines patch added patch discarded remove patch
@@ -1,4 +1,6 @@  discard block
 block discarded – undo
1
-<?php if (!defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed');
1
+<?php if (!defined('EVENT_ESPRESSO_VERSION')) {
2
+	exit('No direct script access allowed');
3
+}
2 4
 /**
3 5
  * CSV Import Export class
4 6
  *
@@ -105,8 +107,9 @@  discard block
 block discarded – undo
105 107
 			  $fc = $fc . $c;
106 108
 			}
107 109
 		}
108
-		if ((ord(substr($fc,0,1)) == 255) && (ord(substr($fc,1,1)) == 254))
109
-		$fc = substr($fc,2);
110
+		if ((ord(substr($fc,0,1)) == 255) && (ord(substr($fc,1,1)) == 254)) {
111
+				$fc = substr($fc,2);
112
+		}
110 113
 		return ($fc);
111 114
 }
112 115
 
@@ -144,7 +147,7 @@  discard block
 block discarded – undo
144 147
 				while(($data = fgetcsv($file_handle, 0, ',', '"' )) !== FALSE){
145 148
 					$csvarray[]= $data;
146 149
 				}
147
-			}else{
150
+			} else{
148 151
 				// loop through each row of the file
149 152
 				while (( $data = fgetcsv( $file_handle, 0, ',', '"', '\\' )) !== FALSE ) {
150 153
 					$csvarray[]=$data;
@@ -153,7 +156,7 @@  discard block
 block discarded – undo
153 156
 			# Close the File.
154 157
 			fclose($file_handle);
155 158
 			return $csvarray;
156
-		}else{
159
+		} else{
157 160
 			EE_Error::add_error( sprintf(__("An error occurred - the file: %s could not opened.", "event_espresso"),$path_to_file), __FILE__, __FUNCTION__, __LINE__ );
158 161
 			return false;
159 162
 		}
@@ -234,7 +237,7 @@  discard block
 block discarded – undo
234 237
 						$matches = array();
235 238
 						if($model_name == EE_CSV::metadata_header){
236 239
 							$headers[$i] = $column_name;
237
-						}else{
240
+						} else{
238 241
 							//now get the db table name from it (the part between square brackets)
239 242
 							$success = preg_match('~(.*)\[(.*)\]~', $column_name,$matches);
240 243
 							if (!$success){
@@ -244,7 +247,7 @@  discard block
 block discarded – undo
244 247
 							$headers[$i] = $matches[2];
245 248
 						}
246 249
 
247
-					}else{
250
+					} else{
248 251
 						// no column names means our final array will just use counters for keys
249 252
 						$model_entry[$headers[$i]] = $data[$i];
250 253
 						$headers[$i] = $i;
@@ -371,7 +374,7 @@  discard block
 block discarded – undo
371 374
 				echo $this->fputcsv2($filehandle, $data_row);
372 375
 			}
373 376
 			return true;
374
-		}else{
377
+		} else{
375 378
 			//no data TO write... so we can assume that's a success
376 379
 			return true;
377 380
 		}
@@ -438,7 +441,7 @@  discard block
 block discarded – undo
438 441
 
439 442
 			if( ! empty($model_instance_arrays) ){
440 443
 				$this->write_data_array_to_csv($filehandle, $model_instance_arrays);
441
-			}else{
444
+			} else{
442 445
 //				echo "no data to write... so just write the headers";
443 446
 				//so there's actually NO model objects for that model.
444 447
 				//probably still want to show the columns
Please login to merge, or discard this patch.
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -315,7 +315,7 @@
 block discarded – undo
315 315
 //		header("Content-Type: application/download");
316 316
 		header('Content-disposition: attachment; filename='.$filename);
317 317
 		header("Content-Type: text/csv; charset=utf-8");
318
-                do_action( 'AHEE__EE_CSV__begin_sending_csv__headers' );
318
+				do_action( 'AHEE__EE_CSV__begin_sending_csv__headers' );
319 319
 		echo apply_filters('FHEE__EE_CSV__begin_sending_csv__start_writing', "\xEF\xBB\xBF" ); // makes excel open it as UTF-8. UTF-8 BOM, see http://stackoverflow.com/a/4440143/2773835
320 320
 		$fh = fopen('php://output', 'w');
321 321
 		return $fh;
Please login to merge, or discard this patch.
Spacing   +114 added lines, -114 removed lines patch added patch discarded remove patch
@@ -1,4 +1,4 @@  discard block
 block discarded – undo
1
-<?php if (!defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed');
1
+<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed');
2 2
 /**
3 3
  * CSV Import Export class
4 4
  *
@@ -45,31 +45,31 @@  discard block
 block discarded – undo
45 45
 		global $wpdb;
46 46
 
47 47
 		$this->_primary_keys = array(
48
-				$wpdb->prefix . 'esp_answer' => array( 'ANS_ID' ),
49
-				$wpdb->prefix . 'esp_attendee' => array( 'ATT_ID' ),
50
-				$wpdb->prefix . 'esp_datetime'	=> array( 'DTT_ID' ),
51
-				$wpdb->prefix . 'esp_event_question_group'	=> array( 'EQG_ID' ),
52
-				$wpdb->prefix . 'esp_message_template'	=> array( 'MTP_ID' ),
53
-				$wpdb->prefix . 'esp_payment'	=> array( 'PAY_ID' ),
54
-				$wpdb->prefix . 'esp_price'	=> array( 'PRC_ID' ),
55
-				$wpdb->prefix . 'esp_price_type'	=> array( 'PRT_ID' ),
56
-				$wpdb->prefix . 'esp_question'	=> array( 'QST_ID' ),
57
-				$wpdb->prefix . 'esp_question_group'	=> array( 'QSG_ID' ),
58
-				$wpdb->prefix . 'esp_question_group_question'	=> array( 'QGQ_ID' ),
59
-				$wpdb->prefix . 'esp_question_option'	=> array( 'QSO_ID' ),
60
-				$wpdb->prefix . 'esp_registration'	=> array( 'REG_ID' ),
61
-				$wpdb->prefix . 'esp_status'	=> array( 'STS_ID' ),
62
-				$wpdb->prefix . 'esp_transaction'	=> array( 'TXN_ID' ),
63
-				$wpdb->prefix . 'esp_transaction'	=> array( 'TXN_ID' ),
64
-				$wpdb->prefix . 'events_detail'	=> array( 'id' ),
65
-				$wpdb->prefix . 'events_category_detail'	=> array( 'id' ),
66
-				$wpdb->prefix . 'events_category_rel'	=> array( 'id' ),
67
-				$wpdb->prefix . 'events_venue'	=> array( 'id' ),
68
-				$wpdb->prefix . 'events_venue_rel' =>  array( 'emeta_id' ),
69
-				$wpdb->prefix . 'events_locale'	=> array( 'id' ),
70
-				$wpdb->prefix . 'events_locale_rel'	=> array( 'id' ),
71
-				$wpdb->prefix . 'events_personnel' =>  array( 'id' ),
72
-				$wpdb->prefix . 'events_personnel_rel' =>  array( 'id' ),
48
+				$wpdb->prefix.'esp_answer' => array('ANS_ID'),
49
+				$wpdb->prefix.'esp_attendee' => array('ATT_ID'),
50
+				$wpdb->prefix.'esp_datetime'	=> array('DTT_ID'),
51
+				$wpdb->prefix.'esp_event_question_group'	=> array('EQG_ID'),
52
+				$wpdb->prefix.'esp_message_template'	=> array('MTP_ID'),
53
+				$wpdb->prefix.'esp_payment'	=> array('PAY_ID'),
54
+				$wpdb->prefix.'esp_price'	=> array('PRC_ID'),
55
+				$wpdb->prefix.'esp_price_type'	=> array('PRT_ID'),
56
+				$wpdb->prefix.'esp_question'	=> array('QST_ID'),
57
+				$wpdb->prefix.'esp_question_group'	=> array('QSG_ID'),
58
+				$wpdb->prefix.'esp_question_group_question'	=> array('QGQ_ID'),
59
+				$wpdb->prefix.'esp_question_option'	=> array('QSO_ID'),
60
+				$wpdb->prefix.'esp_registration'	=> array('REG_ID'),
61
+				$wpdb->prefix.'esp_status'	=> array('STS_ID'),
62
+				$wpdb->prefix.'esp_transaction'	=> array('TXN_ID'),
63
+				$wpdb->prefix.'esp_transaction'	=> array('TXN_ID'),
64
+				$wpdb->prefix.'events_detail'	=> array('id'),
65
+				$wpdb->prefix.'events_category_detail'	=> array('id'),
66
+				$wpdb->prefix.'events_category_rel'	=> array('id'),
67
+				$wpdb->prefix.'events_venue'	=> array('id'),
68
+				$wpdb->prefix.'events_venue_rel' =>  array('emeta_id'),
69
+				$wpdb->prefix.'events_locale'	=> array('id'),
70
+				$wpdb->prefix.'events_locale_rel'	=> array('id'),
71
+				$wpdb->prefix.'events_personnel' =>  array('id'),
72
+				$wpdb->prefix.'events_personnel_rel' =>  array('id'),
73 73
 			);
74 74
 
75 75
 	}
@@ -81,9 +81,9 @@  discard block
 block discarded – undo
81 81
 	 *		@ access public
82 82
 	 *		@return EE_CSV
83 83
 	 */
84
-	public static function instance ( ) {
84
+	public static function instance( ) {
85 85
 		// check if class object is instantiated
86
-		if ( self::$_instance === NULL  or ! is_object( self::$_instance ) or ! ( self::$_instance instanceof EE_CSV )) {
86
+		if (self::$_instance === NULL or ! is_object(self::$_instance) or ! (self::$_instance instanceof EE_CSV)) {
87 87
 			self::$_instance = new self();
88 88
 		}
89 89
 		return self::$_instance;
@@ -95,22 +95,22 @@  discard block
 block discarded – undo
95 95
 	 * @return string
96 96
 	 * @throws EE_Error
97 97
 	 */
98
-	private function read_unicode_file($file_path){
98
+	private function read_unicode_file($file_path) {
99 99
 		$fc = "";
100
-		$fh = fopen($file_path,"rb");
101
-		if( ! $fh ){
102
-			throw new EE_Error( sprintf( __("Cannot open file for read: %s<br>\n", 'event_espresso'), $file_path ) );
100
+		$fh = fopen($file_path, "rb");
101
+		if ( ! $fh) {
102
+			throw new EE_Error(sprintf(__("Cannot open file for read: %s<br>\n", 'event_espresso'), $file_path));
103 103
 		}
104 104
 		$flen = filesize($file_path);
105 105
 		$bc = fread($fh, $flen);
106
-		for ($i=0; $i<$flen; $i++){
107
-			$c = substr($bc,$i,1);
108
-			if ((ord($c) != 0) && (ord($c) != 13)){
109
-			  $fc = $fc . $c;
106
+		for ($i = 0; $i < $flen; $i++) {
107
+			$c = substr($bc, $i, 1);
108
+			if ((ord($c) != 0) && (ord($c) != 13)) {
109
+			  $fc = $fc.$c;
110 110
 			}
111 111
 		}
112
-		if ((ord(substr($fc,0,1)) == 255) && (ord(substr($fc,1,1)) == 254))
113
-		$fc = substr($fc,2);
112
+		if ((ord(substr($fc, 0, 1)) == 255) && (ord(substr($fc, 1, 1)) == 254))
113
+		$fc = substr($fc, 2);
114 114
 		return ($fc);
115 115
 }
116 116
 
@@ -122,15 +122,15 @@  discard block
 block discarded – undo
122 122
 	 * @param string $path_to_file
123 123
 	 * @return array of arrays. Top-level array has rows, second-level array has each item
124 124
 	 */
125
-	public function import_csv_to_multi_dimensional_array($path_to_file){
125
+	public function import_csv_to_multi_dimensional_array($path_to_file) {
126 126
 		// needed to deal with Mac line endings
127
-		ini_set('auto_detect_line_endings',TRUE);
127
+		ini_set('auto_detect_line_endings', TRUE);
128 128
 
129 129
 		// because fgetcsv does not correctly deal with backslashed quotes such as \"
130 130
 		// we'll read the file into a string
131
-		$file_contents = $this->read_unicode_file( $path_to_file );
131
+		$file_contents = $this->read_unicode_file($path_to_file);
132 132
 		// replace backslashed quotes with CSV enclosures
133
-		$file_contents = str_replace ( '\\"', '"""', $file_contents );
133
+		$file_contents = str_replace('\\"', '"""', $file_contents);
134 134
 		// HEY YOU! PUT THAT FILE BACK!!!
135 135
 		file_put_contents($path_to_file, $file_contents);
136 136
 
@@ -140,25 +140,25 @@  discard block
 block discarded – undo
140 140
 			$csvarray = array();
141 141
 
142 142
 			// in PHP 5.3 fgetcsv accepts a 5th parameter, but the pre 5.3 versions of fgetcsv choke if passed more than 4 - is that crazy or what?
143
-			if ( version_compare( PHP_VERSION, '5.3.0' ) < 0 ) {
143
+			if (version_compare(PHP_VERSION, '5.3.0') < 0) {
144 144
 
145 145
 				//  PHP 5.2- version
146 146
 
147 147
 				// loop through each row of the file
148
-				while(($data = fgetcsv($file_handle, 0, ',', '"' )) !== FALSE){
149
-					$csvarray[]= $data;
148
+				while (($data = fgetcsv($file_handle, 0, ',', '"')) !== FALSE) {
149
+					$csvarray[] = $data;
150 150
 				}
151
-			}else{
151
+			} else {
152 152
 				// loop through each row of the file
153
-				while (( $data = fgetcsv( $file_handle, 0, ',', '"', '\\' )) !== FALSE ) {
154
-					$csvarray[]=$data;
153
+				while (($data = fgetcsv($file_handle, 0, ',', '"', '\\')) !== FALSE) {
154
+					$csvarray[] = $data;
155 155
 				}
156 156
 			}
157 157
 			# Close the File.
158 158
 			fclose($file_handle);
159 159
 			return $csvarray;
160
-		}else{
161
-			EE_Error::add_error( sprintf(__("An error occurred - the file: %s could not opened.", "event_espresso"),$path_to_file), __FILE__, __FUNCTION__, __LINE__ );
160
+		} else {
161
+			EE_Error::add_error(sprintf(__("An error occurred - the file: %s could not opened.", "event_espresso"), $path_to_file), __FILE__, __FUNCTION__, __LINE__);
162 162
 			return false;
163 163
 		}
164 164
 	}
@@ -188,9 +188,9 @@  discard block
 block discarded – undo
188 188
 	 *						...
189 189
 	 *						)
190 190
 	 */
191
-	public function import_csv_to_model_data_array( $path_to_file, $model_name = FALSE, $first_row_is_headers = TRUE ) {
191
+	public function import_csv_to_model_data_array($path_to_file, $model_name = FALSE, $first_row_is_headers = TRUE) {
192 192
 		$multi_dimensional_array = $this->import_csv_to_multi_dimensional_array($path_to_file);
193
-		if( ! $multi_dimensional_array ){
193
+		if ( ! $multi_dimensional_array) {
194 194
 			return false;
195 195
 		}
196 196
 		// gotta start somewhere
@@ -199,9 +199,9 @@  discard block
 block discarded – undo
199 199
 		$ee_formatted_data = array();
200 200
 		// array to store headers (column names)
201 201
 		$headers = array();
202
-		foreach($multi_dimensional_array as $data){
202
+		foreach ($multi_dimensional_array as $data) {
203 203
 			// if first cell is MODEL, then second cell is the MODEL name
204
-			if ( $data[0]	== 'MODEL' ) {
204
+			if ($data[0] == 'MODEL') {
205 205
 				$model_name = $data[1];
206 206
 				//don't bother looking for model data in this row. The rest of this
207 207
 				//row should be blank
@@ -211,7 +211,7 @@  discard block
 block discarded – undo
211 211
 				$headers = array();
212 212
 				continue;
213 213
 			}
214
-			if( strpos( $data[0], EE_CSV::metadata_header ) !==FALSE ){
214
+			if (strpos($data[0], EE_CSV::metadata_header) !== FALSE) {
215 215
 				$model_name = EE_CSV::metadata_header;
216 216
 				//store like model data, we just won't try importing it etc.
217 217
 				$row = 1;
@@ -224,31 +224,31 @@  discard block
 block discarded – undo
224 224
 
225 225
 			$model_entry = array();
226 226
 			// loop through each column
227
-			for ( $i=0; $i < $columns; $i++ ) {
227
+			for ($i = 0; $i < $columns; $i++) {
228 228
 
229 229
 				//replace csv_enclosures with backslashed quotes
230
-				$data[$i] = str_replace ( '"""', '\\"', $data[$i] );
230
+				$data[$i] = str_replace('"""', '\\"', $data[$i]);
231 231
 				// do we need to grab the column names?
232
-				if ( $row === 1){
233
-					if( $first_row_is_headers ) {
232
+				if ($row === 1) {
233
+					if ($first_row_is_headers) {
234 234
 						// store the column names to use for keys
235 235
 						$column_name = $data[$i];
236 236
 						//check it's not blank... sometimes CSV editign programs adda bunch of empty columns onto the end...
237
-						if(!$column_name){continue;}
237
+						if ( ! $column_name) {continue; }
238 238
 						$matches = array();
239
-						if($model_name == EE_CSV::metadata_header){
239
+						if ($model_name == EE_CSV::metadata_header) {
240 240
 							$headers[$i] = $column_name;
241
-						}else{
241
+						} else {
242 242
 							//now get the db table name from it (the part between square brackets)
243
-							$success = preg_match('~(.*)\[(.*)\]~', $column_name,$matches);
244
-							if (!$success){
245
-								EE_Error::add_error( sprintf(__("The column titled %s is invalid for importing. It must be be in the format of 'Nice Name[model_field_name]' in row %s", "event_espresso"),$column_name,implode(",",$data)), __FILE__, __FUNCTION__, __LINE__ );
243
+							$success = preg_match('~(.*)\[(.*)\]~', $column_name, $matches);
244
+							if ( ! $success) {
245
+								EE_Error::add_error(sprintf(__("The column titled %s is invalid for importing. It must be be in the format of 'Nice Name[model_field_name]' in row %s", "event_espresso"), $column_name, implode(",", $data)), __FILE__, __FUNCTION__, __LINE__);
246 246
 								return false;
247 247
 							}
248 248
 							$headers[$i] = $matches[2];
249 249
 						}
250 250
 
251
-					}else{
251
+					} else {
252 252
 						// no column names means our final array will just use counters for keys
253 253
 						$model_entry[$headers[$i]] = $data[$i];
254 254
 						$headers[$i] = $i;
@@ -256,14 +256,14 @@  discard block
 block discarded – undo
256 256
 					// and we need to store csv data
257 257
 				} else {
258 258
 					// this column isn' ta header, store it if there is a header for it
259
-					if(isset($headers[$i])){
259
+					if (isset($headers[$i])) {
260 260
 						$model_entry[$headers[$i]] = $data[$i];
261 261
 					}
262 262
 				}
263 263
 
264 264
 			}
265 265
 			//save the row's data IF it's a non-header-row
266
-			if( ! $first_row_is_headers || ($first_row_is_headers && $row > 1)){
266
+			if ( ! $first_row_is_headers || ($first_row_is_headers && $row > 1)) {
267 267
 				$ee_formatted_data[$model_name][] = $model_entry;
268 268
 			}
269 269
 			// advance to next row
@@ -282,9 +282,9 @@  discard block
 block discarded – undo
282 282
 	}
283 283
 
284 284
 
285
-	public function save_csv_to_db( $csv_data_array, $model_name = FALSE ) {
286
-		EE_Error::doing_it_wrong('save_csv_to_db', __( 'Function moved to EE_Import and renamed to save_csv_data_array_to_db', 'event_espresso' ), '4.6.7' );
287
-		return EE_Import::instance()->save_csv_data_array_to_db( $csv_data_array, $model_name );
285
+	public function save_csv_to_db($csv_data_array, $model_name = FALSE) {
286
+		EE_Error::doing_it_wrong('save_csv_to_db', __('Function moved to EE_Import and renamed to save_csv_data_array_to_db', 'event_espresso'), '4.6.7');
287
+		return EE_Import::instance()->save_csv_data_array_to_db($csv_data_array, $model_name);
288 288
 	}
289 289
 
290 290
 	/**
@@ -294,11 +294,11 @@  discard block
 block discarded – undo
294 294
 	 * @param string $new_filename the name of the file that the user will download
295 295
 	 * @return resource, like the results of fopen(), which can be used for fwrite, fputcsv2, etc.
296 296
 	 */
297
-	public function begin_sending_csv($filename){
297
+	public function begin_sending_csv($filename) {
298 298
 		// grab file extension
299 299
 		$ext = substr(strrchr($filename, '.'), 1);
300
-		if ( $ext == '.csv' or  $ext == '.xls' ) {
301
-			str_replace( $ext, '', $filename );
300
+		if ($ext == '.csv' or $ext == '.xls') {
301
+			str_replace($ext, '', $filename);
302 302
 		}
303 303
 		$filename .= '.csv';
304 304
 
@@ -319,8 +319,8 @@  discard block
 block discarded – undo
319 319
 //		header("Content-Type: application/download");
320 320
 		header('Content-disposition: attachment; filename='.$filename);
321 321
 		header("Content-Type: text/csv; charset=utf-8");
322
-                do_action( 'AHEE__EE_CSV__begin_sending_csv__headers' );
323
-		echo apply_filters('FHEE__EE_CSV__begin_sending_csv__start_writing', "\xEF\xBB\xBF" ); // makes excel open it as UTF-8. UTF-8 BOM, see http://stackoverflow.com/a/4440143/2773835
322
+                do_action('AHEE__EE_CSV__begin_sending_csv__headers');
323
+		echo apply_filters('FHEE__EE_CSV__begin_sending_csv__start_writing', "\xEF\xBB\xBF"); // makes excel open it as UTF-8. UTF-8 BOM, see http://stackoverflow.com/a/4440143/2773835
324 324
 		$fh = fopen('php://output', 'w');
325 325
 		return $fh;
326 326
 	}
@@ -330,10 +330,10 @@  discard block
 block discarded – undo
330 330
 	 * mentioning the version and timezone
331 331
 	 * @param resource $filehandle
332 332
 	 */
333
-	public function write_metadata_to_csv($filehandle){
334
-		$data_row = array(EE_CSV::metadata_header);//do NOT translate because this exact string is used when importing
333
+	public function write_metadata_to_csv($filehandle) {
334
+		$data_row = array(EE_CSV::metadata_header); //do NOT translate because this exact string is used when importing
335 335
 		$this->fputcsv2($filehandle, $data_row);
336
-		$meta_data = array( 0=> array(
336
+		$meta_data = array(0=> array(
337 337
 			'version'=>espresso_version(),
338 338
 			'timezone'=>  EEH_DTT_Helper::get_timezone(),
339 339
 			'time_of_export'=>current_time('mysql'),
@@ -351,29 +351,29 @@  discard block
 block discarded – undo
351 351
 	 * then the first row we'd write to the CSV would be "EVT_ID,EVT_name,..."
352 352
 	 * @return boolean if we successfully wrote to the CSV or not. If there's no $data, we consider that a success (because we wrote everything there was...nothing)
353 353
 	 */
354
-	public function write_data_array_to_csv($filehandle, $data){
354
+	public function write_data_array_to_csv($filehandle, $data) {
355 355
 
356 356
 
357 357
 		//determine if $data is actually a 2d array
358
-		if ( $data && is_array($data) && is_array(EEH_Array::get_one_item_from_array($data))){
358
+		if ($data && is_array($data) && is_array(EEH_Array::get_one_item_from_array($data))) {
359 359
 			//make sure top level is numerically indexed,
360 360
 
361
-			if( EEH_Array::is_associative_array($data)){
362
-				throw new EE_Error(sprintf(__("top-level array must be numerically indexed. Does these look like numbers to you? %s","event_espresso"),implode(",",array_keys($data))));
361
+			if (EEH_Array::is_associative_array($data)) {
362
+				throw new EE_Error(sprintf(__("top-level array must be numerically indexed. Does these look like numbers to you? %s", "event_espresso"), implode(",", array_keys($data))));
363 363
 			}
364 364
 			$item_in_top_level_array = EEH_Array::get_one_item_from_array($data);
365 365
 			//now, is the last item in the top-level array of $data an associative or numeric array?
366
-			if(EEH_Array::is_associative_array($item_in_top_level_array)){
366
+			if (EEH_Array::is_associative_array($item_in_top_level_array)) {
367 367
 				//its associative, so we want to output its keys as column headers
368 368
 				$keys = array_keys($item_in_top_level_array);
369 369
 				echo $this->fputcsv2($filehandle, $keys);
370 370
 			}
371 371
 			//start writing data
372
-			foreach($data as $data_row){
372
+			foreach ($data as $data_row) {
373 373
 				echo $this->fputcsv2($filehandle, $data_row);
374 374
 			}
375 375
 			return true;
376
-		}else{
376
+		} else {
377 377
 			//no data TO write... so we can assume that's a success
378 378
 			return true;
379 379
 		}
@@ -418,7 +418,7 @@  discard block
 block discarded – undo
418 418
 	 * Calls exit to prevent polluting the CSV file with other junk
419 419
 	 * @param resource $fh filehandle where we're writing the CSV to
420 420
 	 */
421
-	public function end_sending_csv($fh){
421
+	public function end_sending_csv($fh) {
422 422
 		fclose($fh);
423 423
 		exit(0);
424 424
 	}
@@ -431,23 +431,23 @@  discard block
 block discarded – undo
431 431
 	 * has all the attributes o fthat model object (eg, the event's id, name, etc)
432 432
 	 * @return boolean success
433 433
 	 */
434
-	public function write_model_data_to_csv($filehandle,$model_data_array){
434
+	public function write_model_data_to_csv($filehandle, $model_data_array) {
435 435
 		$this->write_metadata_to_csv($filehandle);
436
-		foreach($model_data_array as $model_name => $model_instance_arrays){
436
+		foreach ($model_data_array as $model_name => $model_instance_arrays) {
437 437
 			//first: output a special row stating the model
438
-			echo $this->fputcsv2($filehandle,array('MODEL',$model_name));
438
+			echo $this->fputcsv2($filehandle, array('MODEL', $model_name));
439 439
 			//if we have items to put in the CSV, do it normally
440 440
 
441
-			if( ! empty($model_instance_arrays) ){
441
+			if ( ! empty($model_instance_arrays)) {
442 442
 				$this->write_data_array_to_csv($filehandle, $model_instance_arrays);
443
-			}else{
443
+			} else {
444 444
 //				echo "no data to write... so just write the headers";
445 445
 				//so there's actually NO model objects for that model.
446 446
 				//probably still want to show the columns
447 447
 				$model = EE_Registry::instance()->load_model($model_name);
448 448
 				$column_names = array();
449
-				foreach($model->field_settings() as $field){
450
-					$column_names[$field->get_nicename()."[".$field->get_name()."]"] = null ;
449
+				foreach ($model->field_settings() as $field) {
450
+					$column_names[$field->get_nicename()."[".$field->get_name()."]"] = null;
451 451
 				}
452 452
 				$this->write_data_array_to_csv($filehandle, array($column_names));
453 453
 			}
@@ -461,7 +461,7 @@  discard block
 block discarded – undo
461 461
 	 * @param array $model_data_array 3d array, as described in EE_CSV::write_model_data_to_csv()
462 462
 	 * @return bool | void writes CSV file to output and dies
463 463
 	 */
464
-	public function export_multiple_model_data_to_csv($filename,$model_data_array){
464
+	public function export_multiple_model_data_to_csv($filename, $model_data_array) {
465 465
 		$filehandle = $this->begin_sending_csv($filename);
466 466
 		$this->write_model_data_to_csv($filehandle, $model_data_array);
467 467
 		$this->end_sending_csv($filehandle);
@@ -473,15 +473,15 @@  discard block
 block discarded – undo
473 473
 	 *			@param string $filename - name for newly created csv file
474 474
 	 *			@return TRUE on success, FALSE on fail
475 475
 	 */
476
-	public function export_array_to_csv( $data = FALSE, $filename = FALSE  ) {
476
+	public function export_array_to_csv($data = FALSE, $filename = FALSE) {
477 477
 
478 478
 		// no data file?? get outta here
479
-		if ( ! $data or ! is_array( $data ) or empty( $data ) ) {
479
+		if ( ! $data or ! is_array($data) or empty($data)) {
480 480
 			return FALSE;
481 481
 		}
482 482
 
483 483
 		// no filename?? get outta here
484
-		if ( ! $filename ) {
484
+		if ( ! $filename) {
485 485
 			return FALSE;
486 486
 		}
487 487
 
@@ -507,11 +507,11 @@  discard block
 block discarded – undo
507 507
 	 *			@param int $percent_of_max - desired percentage of the max upload_mb
508 508
 	 *			@return int KB
509 509
 	 */
510
-	public function get_max_upload_size ( $percent_of_max = FALSE ) {
510
+	public function get_max_upload_size($percent_of_max = FALSE) {
511 511
 
512
-		$max_upload = (int)(ini_get('upload_max_filesize'));
513
-		$max_post = (int)(ini_get('post_max_size'));
514
-		$memory_limit = (int)(ini_get('memory_limit'));
512
+		$max_upload = (int) (ini_get('upload_max_filesize'));
513
+		$max_post = (int) (ini_get('post_max_size'));
514
+		$memory_limit = (int) (ini_get('memory_limit'));
515 515
 
516 516
 		// determine the smallest of the three values from above
517 517
 		$upload_mb = min($max_upload, $max_post, $memory_limit);
@@ -520,9 +520,9 @@  discard block
 block discarded – undo
520 520
 		$upload_mb = $upload_mb * 1024;
521 521
 
522 522
 		// don't want the full monty? then reduce the max uplaod size
523
-		if ( $percent_of_max ) {
523
+		if ($percent_of_max) {
524 524
 			// is percent_of_max like this -> 50 or like this -> 0.50 ?
525
-			if ( $percent_of_max > 1 ) {
525
+			if ($percent_of_max > 1) {
526 526
 				// chnages 50 to 0.50
527 527
 				$percent_of_max = $percent_of_max / 100;
528 528
 			}
@@ -544,17 +544,17 @@  discard block
 block discarded – undo
544 544
 	 *			@param string $mysql_null - allows php NULL to be overridden with MySQl's insertable NULL value
545 545
 	 *			@return void
546 546
 	 */
547
-	private function fputcsv2 ($fh, array $row, $delimiter = ',', $enclosure = '"', $mysql_null = FALSE) {
547
+	private function fputcsv2($fh, array $row, $delimiter = ',', $enclosure = '"', $mysql_null = FALSE) {
548 548
 		//Allow user to filter the csv delimiter and enclosure for other countries csv standards
549
-		$delimiter = apply_filters( 'FHEE__EE_CSV__fputcsv2__delimiter', $delimiter );
550
-		$enclosure = apply_filters( 'FHEE__EE_CSV__fputcsv2__enclosure', $enclosure );
549
+		$delimiter = apply_filters('FHEE__EE_CSV__fputcsv2__delimiter', $delimiter);
550
+		$enclosure = apply_filters('FHEE__EE_CSV__fputcsv2__enclosure', $enclosure);
551 551
 
552 552
 		$delimiter_esc = preg_quote($delimiter, '/');
553 553
 		$enclosure_esc = preg_quote($enclosure, '/');
554 554
 
555 555
 		$output = array();
556 556
 		foreach ($row as $field_value) {
557
-			if(is_object($field_value) || is_array($field_value)){
557
+			if (is_object($field_value) || is_array($field_value)) {
558 558
 				$field_value = serialize($field_value);
559 559
 			}
560 560
 			if ($field_value === null && $mysql_null) {
@@ -563,10 +563,10 @@  discard block
 block discarded – undo
563 563
 			}
564 564
 
565 565
 			$output[] = preg_match("/(?:${delimiter_esc}|${enclosure_esc}|\s)/", $field_value) ?
566
-				( $enclosure . str_replace($enclosure, $enclosure . $enclosure, $field_value) . $enclosure ) : $field_value;
566
+				($enclosure.str_replace($enclosure, $enclosure.$enclosure, $field_value).$enclosure) : $field_value;
567 567
 		}
568 568
 
569
-		fwrite($fh, join($delimiter, $output) . PHP_EOL);
569
+		fwrite($fh, join($delimiter, $output).PHP_EOL);
570 570
 	}
571 571
 
572 572
 
@@ -604,8 +604,8 @@  discard block
 block discarded – undo
604 604
 	 * @param string $current_format
605 605
 	 * @return string
606 606
 	 */
607
-	public function get_date_format_for_csv( $current_format = null ) {
608
-		return apply_filters( 'FHEE__EE_CSV__get_date_format_for_csv__format', 'Y-m-d', $current_format );
607
+	public function get_date_format_for_csv($current_format = null) {
608
+		return apply_filters('FHEE__EE_CSV__get_date_format_for_csv__format', 'Y-m-d', $current_format);
609 609
 	}
610 610
 
611 611
 	/**
@@ -613,8 +613,8 @@  discard block
 block discarded – undo
613 613
 	 * @param string $current_format
614 614
 	 * @return string
615 615
 	 */
616
-	public function get_time_format_for_csv( $current_format = null ) {
617
-		return apply_filters( 'FHEE__EE_CSV__get_time_format_for_csv__format', 'H:i:s', $current_format );
616
+	public function get_time_format_for_csv($current_format = null) {
617
+		return apply_filters('FHEE__EE_CSV__get_time_format_for_csv__format', 'H:i:s', $current_format);
618 618
 	}
619 619
 
620 620
 
Please login to merge, or discard this patch.