Completed
Branch BUG-7527-answer-question-group (0815fc)
by
unknown
25:10 queued 12:57
created
data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_org_options.dmsstage.php 3 patches
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 2 patches
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 3 patches
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.
4_1_0_stages/EE_DMS_4_1_0_question_groups.dmsstage.php 2 patches
Spacing   +25 added lines, -25 removed lines patch added patch discarded remove patch
@@ -38,7 +38,7 @@  discard block
 block discarded – undo
38 38
 		);
39 39
  * 
40 40
  */
41
-class EE_DMS_4_1_0_question_groups extends EE_Data_Migration_Script_Stage{
41
+class EE_DMS_4_1_0_question_groups extends EE_Data_Migration_Script_Stage {
42 42
 	private $_old_table;
43 43
 	private $_new_table;
44 44
 	/**
@@ -49,19 +49,19 @@  discard block
 block discarded – undo
49 49
 	 * @var boolean
50 50
 	 */
51 51
 	private $_already_got_system_question_group_1 = false;
52
-	function _migration_step($num_items=50){
52
+	function _migration_step($num_items = 50) {
53 53
 		
54 54
 		global $wpdb;
55 55
 		$start_at_record = $this->count_records_migrated();
56
-		$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A);
56
+		$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A);
57 57
 		$items_actually_migrated = 0;
58
-		foreach($rows as $question_group){
58
+		foreach ($rows as $question_group) {
59 59
 			$new_id = $this->_insert_new_question_group($question_group);
60 60
 
61 61
 			$this->get_migration_script()->set_mapping($this->_old_table, $question_group['id'], $this->_new_table, $new_id);
62 62
 			$items_actually_migrated++;
63 63
 		}
64
-		if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){
64
+		if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
65 65
 			$this->set_completed();
66 66
 		}
67 67
 		return $items_actually_migrated;
@@ -85,24 +85,24 @@  discard block
 block discarded – undo
85 85
 	 * @param array $old_question_group
86 86
 	 * @return int
87 87
 	 */
88
-	private function _insert_new_question_group($old_question_group){
88
+	private function _insert_new_question_group($old_question_group) {
89 89
 		global $wpdb;
90 90
 		//try to guess what the QST_system int should be... finding the Personal info system
91 91
 		//question group is quite easy. But in 3.1 address info WASN'T a system group, it just exitsed by default but
92 92
 		//could be easily removed.
93
-		if($old_question_group['system_group'] && ! $this->_already_got_system_question_group_1()){
93
+		if ($old_question_group['system_group'] && ! $this->_already_got_system_question_group_1()) {
94 94
 			$guess_at_system_number = 1;
95
-		}elseif($old_question_group['id'] == '2' && strpos($old_question_group['group_name'],'Address')!==FALSE){
95
+		}elseif ($old_question_group['id'] == '2' && strpos($old_question_group['group_name'], 'Address') !== FALSE) {
96 96
 			$guess_at_system_number = 2;
97
-		}else{
97
+		} else {
98 98
 			$guess_at_system_number = 0;
99 99
 		}
100 100
 		//if the question group wasn't made by the normal admin, 
101 101
 		//we'd like to keep track of who made it
102
-		if(intval($old_question_group['wp_user'])!=1){
103
-			$username = $wpdb->get_var($wpdb->prepare("SELECT user_nicename FROM ".$wpdb->users." WHERE ID = %d",$old_question_group['wp_user']));
102
+		if (intval($old_question_group['wp_user']) != 1) {
103
+			$username = $wpdb->get_var($wpdb->prepare("SELECT user_nicename FROM ".$wpdb->users." WHERE ID = %d", $old_question_group['wp_user']));
104 104
 			$identifier = $old_question_group['group_identifier']."-by-".$username;
105
-		}else{
105
+		} else {
106 106
 			$identifier = $old_question_group['group_identifier'];
107 107
 		}
108 108
 		$cols_n_values = array(
@@ -116,17 +116,17 @@  discard block
 block discarded – undo
116 116
 			'QSG_deleted'=>false
117 117
 		);
118 118
 		$datatypes = array(
119
-			'%s',//QSG_name
120
-			'%s',//QSG_identifier
121
-			'%s',//QSG_desc
122
-			'%d',//QSG_order
123
-			'%d',//QSG_show_group_name
124
-			'%d',//QSG_show_group_desc
125
-			'%d',//QSG_system
126
-			'%d',//QSG_deleted
119
+			'%s', //QSG_name
120
+			'%s', //QSG_identifier
121
+			'%s', //QSG_desc
122
+			'%d', //QSG_order
123
+			'%d', //QSG_show_group_name
124
+			'%d', //QSG_show_group_desc
125
+			'%d', //QSG_system
126
+			'%d', //QSG_deleted
127 127
 		);
128
-		$success = $wpdb->insert($this->_new_table,$cols_n_values,$datatypes);
129
-		if ( ! $success){
128
+		$success = $wpdb->insert($this->_new_table, $cols_n_values, $datatypes);
129
+		if ( ! $success) {
130 130
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_question_group, $this->_new_table, $cols_n_values, $datatypes));
131 131
 			return 0;
132 132
 		}
@@ -138,12 +138,12 @@  discard block
 block discarded – undo
138 138
 	 * @global type $wpdb
139 139
 	 * @return boolean
140 140
 	 */
141
-	private function _already_got_system_question_group_1(){
142
-		if( ! $this->_already_got_system_question_group_1 ){
141
+	private function _already_got_system_question_group_1() {
142
+		if ( ! $this->_already_got_system_question_group_1) {
143 143
 			//check the db
144 144
 			global $wpdb;
145 145
 			$exists = $wpdb->get_var("SELECT COUNT(*) FROM {$this->_new_table} WHERE QSG_system=1");
146
-			if(intval($exists)>0){
146
+			if (intval($exists) > 0) {
147 147
 				$this->_already_got_system_question_group_1 = true;
148 148
 			}
149 149
 		}		
Please login to merge, or discard this patch.
Braces   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -92,9 +92,9 @@  discard block
 block discarded – undo
92 92
 		//could be easily removed.
93 93
 		if($old_question_group['system_group'] && ! $this->_already_got_system_question_group_1()){
94 94
 			$guess_at_system_number = 1;
95
-		}elseif($old_question_group['id'] == '2' && strpos($old_question_group['group_name'],'Address')!==FALSE){
95
+		} elseif($old_question_group['id'] == '2' && strpos($old_question_group['group_name'],'Address')!==FALSE){
96 96
 			$guess_at_system_number = 2;
97
-		}else{
97
+		} else{
98 98
 			$guess_at_system_number = 0;
99 99
 		}
100 100
 		//if the question group wasn't made by the normal admin, 
@@ -102,7 +102,7 @@  discard block
 block discarded – undo
102 102
 		if(intval($old_question_group['wp_user'])!=1){
103 103
 			$username = $wpdb->get_var($wpdb->prepare("SELECT user_nicename FROM ".$wpdb->users." WHERE ID = %d",$old_question_group['wp_user']));
104 104
 			$identifier = $old_question_group['group_identifier']."-by-".$username;
105
-		}else{
105
+		} else{
106 106
 			$identifier = $old_question_group['group_identifier'];
107 107
 		}
108 108
 		$cols_n_values = array(
Please login to merge, or discard this patch.
data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_shortcodes.dmsstage.php 2 patches
Indentation   +1 added lines, -2 removed lines patch added patch discarded remove patch
@@ -2,8 +2,7 @@
 block discarded – undo
2 2
 
3 3
 /**
4 4
  * Goes through all the posts and pages, and converts old shortcodes to new ones
5
-	
6
-*/
5
+ */
7 6
 
8 7
 class EE_DMS_4_1_0_shortcodes extends EE_Data_Migration_Script_Stage{	
9 8
 	function __construct() {
Please login to merge, or discard this patch.
Spacing   +12 added lines, -12 removed lines patch added patch discarded remove patch
@@ -5,7 +5,7 @@  discard block
 block discarded – undo
5 5
 	
6 6
 */
7 7
 
8
-class EE_DMS_4_1_0_shortcodes extends EE_Data_Migration_Script_Stage{	
8
+class EE_DMS_4_1_0_shortcodes extends EE_Data_Migration_Script_Stage {	
9 9
 	function __construct() {
10 10
 		global $wpdb;
11 11
 		$this->_pretty_name = __("Shortcodes", "event_espresso");
@@ -15,13 +15,13 @@  discard block
 block discarded – undo
15 15
 	protected function _migrate_old_row($old_row) {
16 16
 		$new_post_content = $this->_change_event_list_shortcode($old_row['post_content']);
17 17
 		global $wpdb;
18
-		$wpdb->query($wpdb->prepare("UPDATE ".$this->_old_table." SET post_content=%s WHERE ID=%d",$new_post_content,$old_row['ID']));
18
+		$wpdb->query($wpdb->prepare("UPDATE ".$this->_old_table." SET post_content=%s WHERE ID=%d", $new_post_content, $old_row['ID']));
19 19
 		$slug = $old_row['post_name'];
20 20
 		$matches = array();
21
-		$success = preg_match_all('(ESPRESSO_[^ \]]*)',$new_post_content,$matches);;
22
-		if($success){
21
+		$success = preg_match_all('(ESPRESSO_[^ \]]*)', $new_post_content, $matches); ;
22
+		if ($success) {
23 23
 			$shortcodes = $matches[0];
24
-			foreach($shortcodes as $shortcode){
24
+			foreach ($shortcodes as $shortcode) {
25 25
 				EE_Config::instance()->core->post_shortcodes[$slug][$shortcode] = $old_row['ID'];
26 26
 				EE_Config::instance()->core->post_shortcodes['posts'][$shortcode] = $old_row['ID'];
27 27
 			}
@@ -41,20 +41,20 @@  discard block
 block discarded – undo
41 41
 	 * replaces [EVENT_LIST... with [ESPRESSO_EVENTS...]
42 42
 	 * @param string $old_content
43 43
 	 */
44
-	private function _change_event_list_shortcode($old_content){
45
-		return str_replace("[EVENT_LIST","[ESPRESSO_EVENTS",$old_content);
44
+	private function _change_event_list_shortcode($old_content) {
45
+		return str_replace("[EVENT_LIST", "[ESPRESSO_EVENTS", $old_content);
46 46
 	}
47 47
 	
48
-	function _migration_step($num_items=50){
48
+	function _migration_step($num_items = 50) {
49 49
 		global $wpdb;
50 50
 		$start_at_record = $this->count_records_migrated();
51
-		$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table {$this->_sql_to_only_select_non_drafts()} LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A);
51
+		$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table {$this->_sql_to_only_select_non_drafts()} LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A);
52 52
 		$items_actually_migrated = 0;
53
-		foreach($rows as $old_row){
53
+		foreach ($rows as $old_row) {
54 54
 			$this->_migrate_old_row($old_row);
55 55
 			$items_actually_migrated++;
56 56
 		}
57
-		if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){
57
+		if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
58 58
 			$this->set_completed();
59 59
 		}
60 60
 		return $items_actually_migrated;
@@ -65,7 +65,7 @@  discard block
 block discarded – undo
65 65
 		return $count;
66 66
 	}
67 67
 	
68
-	private function _sql_to_only_select_non_drafts(){
68
+	private function _sql_to_only_select_non_drafts() {
69 69
 		return " WHERE post_type NOT IN ('revision','auto-draft') ";
70 70
 	}
71 71
 	
Please login to merge, or discard this patch.
core/data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_venues.dmsstage.php 2 patches
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_2_0_stages/EE_DMS_4_2_0_datetime_fields.dmsstage.php 1 patch
Spacing   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -5,7 +5,7 @@  discard block
 block discarded – undo
5 5
  * The name is set to just be a string representation of the start date (in UTC time for now), and the description is just left blank
6 6
 */
7 7
 
8
-class EE_DMS_4_2_0_datetime_fields extends EE_Data_Migration_Script_Stage_Table{
8
+class EE_DMS_4_2_0_datetime_fields extends EE_Data_Migration_Script_Stage_Table {
9 9
 	function __construct() {
10 10
 		global $wpdb;
11 11
 		$this->_pretty_name = __("Datetime Fields", "event_espresso");
@@ -25,14 +25,14 @@  discard block
 block discarded – undo
25 25
 				array(
26 26
 					'DTT_ID'=>$old_row['DTT_ID']),
27 27
 				array(
28
-					'%s',//DTT_name,
29
-					'%s',//DTT_description
28
+					'%s', //DTT_name,
29
+					'%s', //DTT_description
30 30
 					),
31 31
 				array(
32
-					'%d',//DTT_ID
32
+					'%d', //DTT_ID
33 33
 					));
34
-		if( FALSE === $updated ){
35
-			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting DTT_name = '' and DTT_description = '' where DTT_ID = %d", 'event_espresso'),$old_row['QST_ID']));
34
+		if (FALSE === $updated) {
35
+			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting DTT_name = '' and DTT_description = '' where DTT_ID = %d", 'event_espresso'), $old_row['QST_ID']));
36 36
 		}
37 37
 		//nothing to map really
38 38
 	}	
Please login to merge, or discard this patch.
4_2_0_stages/EE_DMS_4_2_0_question_group_questions.dmsstage.php 1 patch
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -4,7 +4,7 @@  discard block
 block discarded – undo
4 4
  * Populates the QGQ_order (introduced in this version, 4.2.0) from the QST_order
5 5
 */
6 6
 
7
-class EE_DMS_4_2_0_question_group_questions extends EE_Data_Migration_Script_Stage_Table{
7
+class EE_DMS_4_2_0_question_group_questions extends EE_Data_Migration_Script_Stage_Table {
8 8
 	private $_qgq_table;
9 9
 	function __construct() {
10 10
 		global $wpdb;
@@ -20,12 +20,12 @@  discard block
 block discarded – undo
20 20
 		$updated = $wpdb->update($this->_qgq_table,
21 21
 				array('QGQ_order'=>$old_row['QST_order']),
22 22
 				array('QST_ID'=>$old_row['QST_ID']),
23
-				array('%d',//QGQ_order
23
+				array('%d', //QGQ_order
24 24
 					),
25
-				array('%d',//QST_ID
25
+				array('%d', //QST_ID
26 26
 					));
27
-		if( FALSE === $updated ){
28
-			$this->add_error(sprintf(__("Error in updating table {$this->_qgq_table} setting QGQ_order = %d where QST_ID = %d", 'event_espresso'),$old_row['QST_order'],$old_row['QST_ID']));
27
+		if (FALSE === $updated) {
28
+			$this->add_error(sprintf(__("Error in updating table {$this->_qgq_table} setting QGQ_order = %d where QST_ID = %d", 'event_espresso'), $old_row['QST_order'], $old_row['QST_ID']));
29 29
 		}
30 30
 		//nothing to map really
31 31
 	}	
Please login to merge, or discard this patch.
4_3_0_stages/EE_DMS_4_3_0_critical_page_shortcode_tracking.dmsstage.php 2 patches
Spacing   +29 added lines, -29 removed lines patch added patch discarded remove patch
@@ -32,7 +32,7 @@  discard block
 block discarded – undo
32 32
 	 * Just initializes the status of the migration
33 33
 	 */
34 34
 	public function __construct() {
35
-		$this->_pretty_name = __( 'Update Critical Page Shortcode Tracking', 'event_espresso' );
35
+		$this->_pretty_name = __('Update Critical Page Shortcode Tracking', 'event_espresso');
36 36
 		parent::__construct();
37 37
 	}
38 38
 
@@ -59,24 +59,24 @@  discard block
 block discarded – undo
59 59
 	 * @throws EE_Error
60 60
 	 * @return int number of items ACTUALLY migrated
61 61
 	 */
62
-	protected function _migration_step( $num_items = 1 ){
62
+	protected function _migration_step($num_items = 1) {
63 63
 		// if this isn't set then something is really wrong
64
-		if ( ! EE_Config::instance()->core instanceof EE_Core_Config ) {
65
-			throw new EE_Error( __( 'It appears the Event Espresso Core Configuration is not setup correctly.', 'event_espresso' ));
64
+		if ( ! EE_Config::instance()->core instanceof EE_Core_Config) {
65
+			throw new EE_Error(__('It appears the Event Espresso Core Configuration is not setup correctly.', 'event_espresso'));
66 66
 		}
67 67
 		// name of the WP Posts Page
68 68
 		$posts_page = $this->_get_page_for_posts();
69 69
 		// make sure critical pages get removed
70
-        $this->_update_post_shortcodes( $posts_page );
70
+        $this->_update_post_shortcodes($posts_page);
71 71
         // save updated config, but don't add errors
72
-		if ( ! EE_Config::instance()->update_espresso_config( FALSE, FALSE )) {
73
-			EE_Error::add_error( __( 'The Event Espresso Configuration Settings were not updated when attempting to save the "critical page post shortcodes".', 'event_espresso' ), __FILE__, __FUNCTION__, __LINE__ );
72
+		if ( ! EE_Config::instance()->update_espresso_config(FALSE, FALSE)) {
73
+			EE_Error::add_error(__('The Event Espresso Configuration Settings were not updated when attempting to save the "critical page post shortcodes".', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__);
74 74
 		}
75 75
 		// check for errors
76
-		$notices = EE_Error::get_notices( FALSE );
76
+		$notices = EE_Error::get_notices(FALSE);
77 77
 		// any errors to report?
78
-		if( isset( $notices['errors'] )) {
79
-          foreach($notices as $value){
78
+		if (isset($notices['errors'])) {
79
+          foreach ($notices as $value) {
80 80
 			  $this->add_error($value);
81 81
 		  }
82 82
         }
@@ -97,13 +97,13 @@  discard block
 block discarded – undo
97 97
      *  @return 	string
98 98
      */
99 99
     private function _get_page_for_posts() {
100
-        $page_for_posts = get_option( 'page_for_posts' );
101
-        if ( ! $page_for_posts ) {
100
+        $page_for_posts = get_option('page_for_posts');
101
+        if ( ! $page_for_posts) {
102 102
             return 'posts';
103 103
         }
104 104
         global $wpdb;
105
-        $SQL = 'SELECT post_name from ' . $wpdb->posts . ' WHERE post_type="posts" OR post_type="page" AND post_status="publish" AND ID=%s';
106
-        return $wpdb->get_var( $wpdb->prepare( $SQL, $page_for_posts ));
105
+        $SQL = 'SELECT post_name from '.$wpdb->posts.' WHERE post_type="posts" OR post_type="page" AND post_status="publish" AND ID=%s';
106
+        return $wpdb->get_var($wpdb->prepare($SQL, $page_for_posts));
107 107
     }
108 108
 
109 109
 
@@ -115,45 +115,45 @@  discard block
 block discarded – undo
115 115
      * @param $page_for_posts
116 116
      * @return    void
117 117
      */
118
-    private function _update_post_shortcodes( $page_for_posts = '' ) {
118
+    private function _update_post_shortcodes($page_for_posts = '') {
119 119
         // critical page shortcodes that we do NOT want added to the Posts page (blog)
120 120
         $critical_shortcodes = EE_Config::instance()->core->get_critical_pages_shortcodes_array();
121 121
         // verify that post_shortcodes is set
122
-        EE_Config::instance()->core->post_shortcodes = isset( EE_Config::instance()->core->post_shortcodes ) && is_array( EE_Config::instance()->core->post_shortcodes ) ? EE_Config::instance()->core->post_shortcodes : array();
122
+        EE_Config::instance()->core->post_shortcodes = isset(EE_Config::instance()->core->post_shortcodes) && is_array(EE_Config::instance()->core->post_shortcodes) ? EE_Config::instance()->core->post_shortcodes : array();
123 123
         //  just in case the site has ever had posts on frontpage at some time, then we should check for a "Posts Page" named "posts"
124
-        $post_pages_to_check = $page_for_posts == 'posts' ? array( $page_for_posts ) : array( 'posts', $page_for_posts );
124
+        $post_pages_to_check = $page_for_posts == 'posts' ? array($page_for_posts) : array('posts', $page_for_posts);
125 125
         // cycle thru post_shortcodes
126
-        foreach( $post_pages_to_check as $post_page ){
126
+        foreach ($post_pages_to_check as $post_page) {
127 127
             // cycle thru post_shortcodes
128
-            foreach( EE_Config::instance()->core->post_shortcodes as $post_name => $shortcodes ){
128
+            foreach (EE_Config::instance()->core->post_shortcodes as $post_name => $shortcodes) {
129 129
                 // are there any shortcodes to track ?
130
-                if ( ! empty( $shortcodes )) {
130
+                if ( ! empty($shortcodes)) {
131 131
                     // loop thru list of tracked shortcodes
132
-                    foreach( $shortcodes as $shortcode => $post_id ) {
132
+                    foreach ($shortcodes as $shortcode => $post_id) {
133 133
                         // if shortcode is for a critical page, BUT this is NOT the corresponding critical page for that shortcode
134
-                        if ( isset( $critical_shortcodes[ $post_id ] ) && $post_name == $post_page ) {
134
+                        if (isset($critical_shortcodes[$post_id]) && $post_name == $post_page) {
135 135
                             // then remove this shortcode, because we don't want critical page shortcodes like ESPRESSO_TXN_PAGE running on the "Posts Page" (blog)
136
-                            unset( EE_Config::instance()->core->post_shortcodes[ $post_name ][ $shortcode ] );
136
+                            unset(EE_Config::instance()->core->post_shortcodes[$post_name][$shortcode]);
137 137
                         }
138 138
                         // skip the posts page, because we want all shortcodes registered for it
139
-                        if ( $post_name == $post_page ) {
139
+                        if ($post_name == $post_page) {
140 140
                             continue;
141 141
                         }
142 142
                         // make sure post still exists
143
-                        $post = get_post( $post_id );
144
-                        if ( $post ) {
143
+                        $post = get_post($post_id);
144
+                        if ($post) {
145 145
                             // check that the post name matches what we have saved
146
-                            if ( $post->post_name == $post_name ) {
146
+                            if ($post->post_name == $post_name) {
147 147
                                 // if so, then break before hitting the unset below
148 148
                                 continue;
149 149
                             }
150 150
                         }
151 151
                         // we don't like missing posts around here >:(
152
-                        unset( EE_Config::instance()->core->post_shortcodes[ $post_name ] );
152
+                        unset(EE_Config::instance()->core->post_shortcodes[$post_name]);
153 153
                     }
154 154
                 } else {
155 155
                     // you got no shortcodes to keep track of !
156
-                    unset( EE_Config::instance()->core->post_shortcodes[ $post_name ] );
156
+                    unset(EE_Config::instance()->core->post_shortcodes[$post_name]);
157 157
                 }
158 158
             }
159 159
         }
Please login to merge, or discard this patch.
Indentation   +75 added lines, -75 removed lines patch added patch discarded remove patch
@@ -67,8 +67,8 @@  discard block
 block discarded – undo
67 67
 		// name of the WP Posts Page
68 68
 		$posts_page = $this->_get_page_for_posts();
69 69
 		// make sure critical pages get removed
70
-        $this->_update_post_shortcodes( $posts_page );
71
-        // save updated config, but don't add errors
70
+		$this->_update_post_shortcodes( $posts_page );
71
+		// save updated config, but don't add errors
72 72
 		if ( ! EE_Config::instance()->update_espresso_config( FALSE, FALSE )) {
73 73
 			EE_Error::add_error( __( 'The Event Espresso Configuration Settings were not updated when attempting to save the "critical page post shortcodes".', 'event_espresso' ), __FILE__, __FUNCTION__, __LINE__ );
74 74
 		}
@@ -76,87 +76,87 @@  discard block
 block discarded – undo
76 76
 		$notices = EE_Error::get_notices( FALSE );
77 77
 		// any errors to report?
78 78
 		if( isset( $notices['errors'] )) {
79
-          foreach($notices as $value){
79
+		  foreach($notices as $value){
80 80
 			  $this->add_error($value);
81 81
 		  }
82
-        }
82
+		}
83 83
 		//regardless of whether it worked or not, we ought to continue the migration
84 84
 		$this->set_completed();
85
-            return 1;
85
+			return 1;
86 86
 	}
87 87
 
88 88
 
89 89
 
90
-    /**
91
-     * 	_get_page_for_posts
92
-     *
93
-     * 	if the wp-option "show_on_front" is set to "page", then this is the post_name for the post set in the wp-option "page_for_posts", or "posts" if no page is selected
94
-     *
95
-     *
96
-     *  @access 	private
97
-     *  @return 	string
98
-     */
99
-    private function _get_page_for_posts() {
100
-        $page_for_posts = get_option( 'page_for_posts' );
101
-        if ( ! $page_for_posts ) {
102
-            return 'posts';
103
-        }
104
-        global $wpdb;
105
-        $SQL = 'SELECT post_name from ' . $wpdb->posts . ' WHERE post_type="posts" OR post_type="page" AND post_status="publish" AND ID=%s';
106
-        return $wpdb->get_var( $wpdb->prepare( $SQL, $page_for_posts ));
107
-    }
108
-
109
-
110
-
111
-    /**
112
-     *    _update_post_shortcodes
113
-     *
114
-     * @access    private
115
-     * @param $page_for_posts
116
-     * @return    void
117
-     */
118
-    private function _update_post_shortcodes( $page_for_posts = '' ) {
119
-        // critical page shortcodes that we do NOT want added to the Posts page (blog)
120
-        $critical_shortcodes = EE_Config::instance()->core->get_critical_pages_shortcodes_array();
121
-        // verify that post_shortcodes is set
122
-        EE_Config::instance()->core->post_shortcodes = isset( EE_Config::instance()->core->post_shortcodes ) && is_array( EE_Config::instance()->core->post_shortcodes ) ? EE_Config::instance()->core->post_shortcodes : array();
123
-        //  just in case the site has ever had posts on frontpage at some time, then we should check for a "Posts Page" named "posts"
124
-        $post_pages_to_check = $page_for_posts == 'posts' ? array( $page_for_posts ) : array( 'posts', $page_for_posts );
125
-        // cycle thru post_shortcodes
126
-        foreach( $post_pages_to_check as $post_page ){
127
-            // cycle thru post_shortcodes
128
-            foreach( EE_Config::instance()->core->post_shortcodes as $post_name => $shortcodes ){
129
-                // are there any shortcodes to track ?
130
-                if ( ! empty( $shortcodes )) {
131
-                    // loop thru list of tracked shortcodes
132
-                    foreach( $shortcodes as $shortcode => $post_id ) {
133
-                        // if shortcode is for a critical page, BUT this is NOT the corresponding critical page for that shortcode
134
-                        if ( isset( $critical_shortcodes[ $post_id ] ) && $post_name == $post_page ) {
135
-                            // then remove this shortcode, because we don't want critical page shortcodes like ESPRESSO_TXN_PAGE running on the "Posts Page" (blog)
136
-                            unset( EE_Config::instance()->core->post_shortcodes[ $post_name ][ $shortcode ] );
137
-                        }
138
-                        // skip the posts page, because we want all shortcodes registered for it
139
-                        if ( $post_name == $post_page ) {
140
-                            continue;
141
-                        }
142
-                        // make sure post still exists
143
-                        $post = get_post( $post_id );
144
-                        if ( $post ) {
145
-                            // check that the post name matches what we have saved
146
-                            if ( $post->post_name == $post_name ) {
147
-                                // if so, then break before hitting the unset below
148
-                                continue;
149
-                            }
150
-                        }
151
-                        // we don't like missing posts around here >:(
152
-                        unset( EE_Config::instance()->core->post_shortcodes[ $post_name ] );
153
-                    }
154
-                } else {
155
-                    // you got no shortcodes to keep track of !
156
-                    unset( EE_Config::instance()->core->post_shortcodes[ $post_name ] );
157
-                }
158
-            }
159
-        }
90
+	/**
91
+	 * 	_get_page_for_posts
92
+	 *
93
+	 * 	if the wp-option "show_on_front" is set to "page", then this is the post_name for the post set in the wp-option "page_for_posts", or "posts" if no page is selected
94
+	 *
95
+	 *
96
+	 *  @access 	private
97
+	 *  @return 	string
98
+	 */
99
+	private function _get_page_for_posts() {
100
+		$page_for_posts = get_option( 'page_for_posts' );
101
+		if ( ! $page_for_posts ) {
102
+			return 'posts';
103
+		}
104
+		global $wpdb;
105
+		$SQL = 'SELECT post_name from ' . $wpdb->posts . ' WHERE post_type="posts" OR post_type="page" AND post_status="publish" AND ID=%s';
106
+		return $wpdb->get_var( $wpdb->prepare( $SQL, $page_for_posts ));
107
+	}
108
+
109
+
110
+
111
+	/**
112
+	 *    _update_post_shortcodes
113
+	 *
114
+	 * @access    private
115
+	 * @param $page_for_posts
116
+	 * @return    void
117
+	 */
118
+	private function _update_post_shortcodes( $page_for_posts = '' ) {
119
+		// critical page shortcodes that we do NOT want added to the Posts page (blog)
120
+		$critical_shortcodes = EE_Config::instance()->core->get_critical_pages_shortcodes_array();
121
+		// verify that post_shortcodes is set
122
+		EE_Config::instance()->core->post_shortcodes = isset( EE_Config::instance()->core->post_shortcodes ) && is_array( EE_Config::instance()->core->post_shortcodes ) ? EE_Config::instance()->core->post_shortcodes : array();
123
+		//  just in case the site has ever had posts on frontpage at some time, then we should check for a "Posts Page" named "posts"
124
+		$post_pages_to_check = $page_for_posts == 'posts' ? array( $page_for_posts ) : array( 'posts', $page_for_posts );
125
+		// cycle thru post_shortcodes
126
+		foreach( $post_pages_to_check as $post_page ){
127
+			// cycle thru post_shortcodes
128
+			foreach( EE_Config::instance()->core->post_shortcodes as $post_name => $shortcodes ){
129
+				// are there any shortcodes to track ?
130
+				if ( ! empty( $shortcodes )) {
131
+					// loop thru list of tracked shortcodes
132
+					foreach( $shortcodes as $shortcode => $post_id ) {
133
+						// if shortcode is for a critical page, BUT this is NOT the corresponding critical page for that shortcode
134
+						if ( isset( $critical_shortcodes[ $post_id ] ) && $post_name == $post_page ) {
135
+							// then remove this shortcode, because we don't want critical page shortcodes like ESPRESSO_TXN_PAGE running on the "Posts Page" (blog)
136
+							unset( EE_Config::instance()->core->post_shortcodes[ $post_name ][ $shortcode ] );
137
+						}
138
+						// skip the posts page, because we want all shortcodes registered for it
139
+						if ( $post_name == $post_page ) {
140
+							continue;
141
+						}
142
+						// make sure post still exists
143
+						$post = get_post( $post_id );
144
+						if ( $post ) {
145
+							// check that the post name matches what we have saved
146
+							if ( $post->post_name == $post_name ) {
147
+								// if so, then break before hitting the unset below
148
+								continue;
149
+							}
150
+						}
151
+						// we don't like missing posts around here >:(
152
+						unset( EE_Config::instance()->core->post_shortcodes[ $post_name ] );
153
+					}
154
+				} else {
155
+					// you got no shortcodes to keep track of !
156
+					unset( EE_Config::instance()->core->post_shortcodes[ $post_name ] );
157
+				}
158
+			}
159
+		}
160 160
    }
161 161
 
162 162
 
Please login to merge, or discard this patch.