@@ -13,13 +13,13 @@ discard block |
||
13 | 13 | //(all other times it gets resurrected from a wordpress option) |
14 | 14 | $stages = glob(EE_CORE.'data_migration_scripts/4_8_0_stages/*'); |
15 | 15 | $class_to_filepath = array(); |
16 | -foreach($stages as $filepath){ |
|
16 | +foreach ($stages as $filepath) { |
|
17 | 17 | $matches = array(); |
18 | - preg_match('~4_8_0_stages/(.*).dmsstage.php~',$filepath,$matches); |
|
18 | + preg_match('~4_8_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
19 | 19 | $class_to_filepath[$matches[1]] = $filepath; |
20 | 20 | } |
21 | 21 | //give addons a chance to autoload their stages too |
22 | -$class_to_filepath = apply_filters('FHEE__EE_DMS_4_8_0__autoloaded_stages',$class_to_filepath); |
|
22 | +$class_to_filepath = apply_filters('FHEE__EE_DMS_4_8_0__autoloaded_stages', $class_to_filepath); |
|
23 | 23 | EEH_Autoloader::register_autoloader($class_to_filepath); |
24 | 24 | |
25 | 25 | |
@@ -35,7 +35,7 @@ discard block |
||
35 | 35 | * @since 4.6.0 |
36 | 36 | * |
37 | 37 | */ |
38 | -class EE_DMS_Core_4_8_0 extends EE_Data_Migration_Script_Base{ |
|
38 | +class EE_DMS_Core_4_8_0 extends EE_Data_Migration_Script_Base { |
|
39 | 39 | |
40 | 40 | /** |
41 | 41 | * return EE_DMS_Core_4_8_0 |
@@ -62,14 +62,14 @@ discard block |
||
62 | 62 | */ |
63 | 63 | public function can_migrate_from_version($version_array) { |
64 | 64 | $version_string = $version_array['Core']; |
65 | - if( $version_string <= '4.8.0' && $version_string >= '4.7.0' ){ |
|
65 | + if ($version_string <= '4.8.0' && $version_string >= '4.7.0') { |
|
66 | 66 | // echo "$version_string can be migrated from"; |
67 | 67 | return true; |
68 | - }elseif( ! $version_string ){ |
|
68 | + }elseif ( ! $version_string) { |
|
69 | 69 | // echo "no version string provided: $version_string"; |
70 | 70 | //no version string provided... this must be pre 4.3 |
71 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
72 | - }else{ |
|
71 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
72 | + } else { |
|
73 | 73 | // echo "$version_string doesnt apply"; |
74 | 74 | return false; |
75 | 75 | } |
@@ -90,19 +90,19 @@ discard block |
||
90 | 90 | * @return bool |
91 | 91 | */ |
92 | 92 | public function schema_changes_before_migration() { |
93 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
94 | - $now_in_mysql = current_time( 'mysql', true ); |
|
93 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
94 | + $now_in_mysql = current_time('mysql', true); |
|
95 | 95 | |
96 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
97 | - $table_name='esp_answer'; |
|
98 | - $sql=" ANS_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
96 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
97 | + $table_name = 'esp_answer'; |
|
98 | + $sql = " ANS_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
99 | 99 | REG_ID int(10) unsigned NOT NULL, |
100 | 100 | QST_ID int(10) unsigned NOT NULL, |
101 | 101 | ANS_value text NOT NULL, |
102 | 102 | PRIMARY KEY (ANS_ID), |
103 | 103 | KEY REG_ID (REG_ID), |
104 | 104 | KEY QST_ID (QST_ID)"; |
105 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
105 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
106 | 106 | |
107 | 107 | $table_name = 'esp_attendee_meta'; |
108 | 108 | $sql = "ATTM_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
@@ -142,7 +142,7 @@ discard block |
||
142 | 142 | CNT_is_EU tinyint(1) DEFAULT '0', |
143 | 143 | CNT_active tinyint(1) DEFAULT '0', |
144 | 144 | PRIMARY KEY (CNT_ISO)"; |
145 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB' ); |
|
145 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
146 | 146 | |
147 | 147 | $table_name = 'esp_currency'; |
148 | 148 | $sql = "CUR_code varchar(6) collate utf8_bin NOT NULL, |
@@ -152,7 +152,7 @@ discard block |
||
152 | 152 | CUR_dec_plc varchar(1) collate utf8_bin NOT NULL DEFAULT '2', |
153 | 153 | CUR_active tinyint(1) DEFAULT '0', |
154 | 154 | PRIMARY KEY (CUR_code)"; |
155 | - $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB' ); |
|
155 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
156 | 156 | |
157 | 157 | |
158 | 158 | $table_name = 'esp_currency_payment_method'; |
@@ -182,7 +182,7 @@ discard block |
||
182 | 182 | KEY EVT_ID (EVT_ID), |
183 | 183 | KEY DTT_is_primary (DTT_is_primary)"; |
184 | 184 | |
185 | - $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
185 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
186 | 186 | |
187 | 187 | $table_name = 'esp_event_meta'; |
188 | 188 | $sql = " |
@@ -201,41 +201,41 @@ discard block |
||
201 | 201 | EVT_donations tinyint(1) NULL, |
202 | 202 | PRIMARY KEY (EVTM_ID), |
203 | 203 | KEY EVT_ID (EVT_ID)"; |
204 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
204 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
205 | 205 | |
206 | 206 | |
207 | 207 | |
208 | - $table_name='esp_event_question_group'; |
|
209 | - $sql="EQG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
208 | + $table_name = 'esp_event_question_group'; |
|
209 | + $sql = "EQG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
210 | 210 | EVT_ID bigint(20) unsigned NOT NULL, |
211 | 211 | QSG_ID int(10) unsigned NOT NULL, |
212 | 212 | EQG_primary tinyint(1) unsigned NOT NULL DEFAULT 0, |
213 | 213 | PRIMARY KEY (EQG_ID), |
214 | 214 | KEY EVT_ID (EVT_ID), |
215 | 215 | KEY QSG_ID (QSG_ID)"; |
216 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
216 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
217 | 217 | |
218 | 218 | |
219 | 219 | |
220 | - $table_name='esp_event_venue'; |
|
221 | - $sql="EVV_ID int(11) NOT NULL AUTO_INCREMENT, |
|
220 | + $table_name = 'esp_event_venue'; |
|
221 | + $sql = "EVV_ID int(11) NOT NULL AUTO_INCREMENT, |
|
222 | 222 | EVT_ID bigint(20) unsigned NOT NULL, |
223 | 223 | VNU_ID bigint(20) unsigned NOT NULL, |
224 | 224 | EVV_primary tinyint(1) unsigned NOT NULL DEFAULT 0, |
225 | 225 | PRIMARY KEY (EVV_ID)"; |
226 | - $this->_table_has_not_changed_since_previous($table_name,$sql, 'ENGINE=InnoDB'); |
|
226 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
227 | 227 | |
228 | 228 | |
229 | 229 | |
230 | - $table_name='esp_extra_meta'; |
|
231 | - $sql="EXM_ID int(11) NOT NULL AUTO_INCREMENT, |
|
230 | + $table_name = 'esp_extra_meta'; |
|
231 | + $sql = "EXM_ID int(11) NOT NULL AUTO_INCREMENT, |
|
232 | 232 | OBJ_ID int(11) DEFAULT NULL, |
233 | 233 | EXM_type varchar(45) DEFAULT NULL, |
234 | 234 | EXM_key varchar(45) DEFAULT NULL, |
235 | 235 | EXM_value text, |
236 | 236 | PRIMARY KEY (EXM_ID), |
237 | 237 | KEY EXM_type (EXM_type,OBJ_ID,EXM_key)"; |
238 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
238 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
239 | 239 | |
240 | 240 | $table_name = 'esp_extra_join'; |
241 | 241 | $sql = "EXJ_ID int(11) NOT NULL AUTO_INCREMENT, |
@@ -248,8 +248,8 @@ discard block |
||
248 | 248 | KEY second_model (EXJ_second_model_name,EXJ_second_model_id)"; |
249 | 249 | $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB '); |
250 | 250 | |
251 | - $table_name='esp_line_item'; |
|
252 | - $sql="LIN_ID int(11) NOT NULL AUTO_INCREMENT, |
|
251 | + $table_name = 'esp_line_item'; |
|
252 | + $sql = "LIN_ID int(11) NOT NULL AUTO_INCREMENT, |
|
253 | 253 | LIN_code varchar(245) NOT NULL DEFAULT '', |
254 | 254 | TXN_ID int(11) DEFAULT NULL, |
255 | 255 | LIN_name varchar(245) NOT NULL DEFAULT '', |
@@ -268,7 +268,7 @@ discard block |
||
268 | 268 | PRIMARY KEY (LIN_ID), |
269 | 269 | KEY LIN_code (LIN_code(191)), |
270 | 270 | KEY TXN_ID (TXN_ID)"; |
271 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB' ); |
|
271 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
272 | 272 | |
273 | 273 | $table_name = 'esp_log'; |
274 | 274 | $sql = "LOG_ID int(11) NOT NULL AUTO_INCREMENT, |
@@ -307,7 +307,7 @@ discard block |
||
307 | 307 | MTP_is_active tinyint(1) NOT NULL DEFAULT '1', |
308 | 308 | PRIMARY KEY (GRP_ID), |
309 | 309 | KEY MTP_user_id (MTP_user_id)"; |
310 | - $this->_table_has_not_changed_since_previous( $table_name, $sql, 'ENGINE=InnoDB'); |
|
310 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
311 | 311 | |
312 | 312 | $table_name = 'esp_event_message_template'; |
313 | 313 | $sql = "EMT_ID bigint(20) unsigned NOT NULL AUTO_INCREMENT, |
@@ -316,7 +316,7 @@ discard block |
||
316 | 316 | PRIMARY KEY (EMT_ID), |
317 | 317 | KEY EVT_ID (EVT_ID), |
318 | 318 | KEY GRP_ID (GRP_ID)"; |
319 | - $this->_table_has_not_changed_since_previous( $table_name, $sql, 'ENGINE=InnoDB'); |
|
319 | + $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
|
320 | 320 | |
321 | 321 | |
322 | 322 | $table_name = 'esp_payment'; |
@@ -389,8 +389,8 @@ discard block |
||
389 | 389 | PRIMARY KEY (TTM_ID)"; |
390 | 390 | $this->_table_has_not_changed_since_previous($table_name, $sql, 'ENGINE=InnoDB'); |
391 | 391 | |
392 | - $table_name='esp_question'; |
|
393 | - $sql='QST_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
392 | + $table_name = 'esp_question'; |
|
393 | + $sql = 'QST_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
394 | 394 | QST_display_text text NOT NULL, |
395 | 395 | QST_admin_label varchar(255) NOT NULL, |
396 | 396 | QST_system varchar(25) NOT NULL DEFAULT "", |
@@ -404,22 +404,22 @@ discard block |
||
404 | 404 | QST_deleted tinyint(2) unsigned NOT NULL DEFAULT 0, |
405 | 405 | PRIMARY KEY (QST_ID), |
406 | 406 | KEY QST_order (QST_order)'; |
407 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
407 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
408 | 408 | |
409 | - $table_name='esp_question_group_question'; |
|
410 | - $sql="QGQ_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
409 | + $table_name = 'esp_question_group_question'; |
|
410 | + $sql = "QGQ_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
411 | 411 | QSG_ID int(10) unsigned NOT NULL, |
412 | 412 | QST_ID int(10) unsigned NOT NULL, |
413 | 413 | QGQ_order int(10) unsigned NOT NULL DEFAULT 0, |
414 | 414 | PRIMARY KEY (QGQ_ID), |
415 | 415 | KEY QST_ID (QST_ID), |
416 | 416 | KEY QSG_ID_order (QSG_ID,QGQ_order)"; |
417 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
417 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
418 | 418 | |
419 | 419 | |
420 | 420 | |
421 | - $table_name='esp_question_option'; |
|
422 | - $sql="QSO_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
421 | + $table_name = 'esp_question_option'; |
|
422 | + $sql = "QSO_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
423 | 423 | QSO_value varchar(255) NOT NULL, |
424 | 424 | QSO_desc text NOT NULL, |
425 | 425 | QST_ID int(10) unsigned NOT NULL, |
@@ -429,7 +429,7 @@ discard block |
||
429 | 429 | PRIMARY KEY (QSO_ID), |
430 | 430 | KEY QST_ID (QST_ID), |
431 | 431 | KEY QSO_order (QSO_order)"; |
432 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
432 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
433 | 433 | |
434 | 434 | |
435 | 435 | |
@@ -475,8 +475,8 @@ discard block |
||
475 | 475 | |
476 | 476 | |
477 | 477 | |
478 | - $table_name='esp_checkin'; |
|
479 | - $sql="CHK_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
478 | + $table_name = 'esp_checkin'; |
|
479 | + $sql = "CHK_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
480 | 480 | REG_ID int(10) unsigned NOT NULL, |
481 | 481 | DTT_ID int(10) unsigned NOT NULL, |
482 | 482 | CHK_in tinyint(1) unsigned NOT NULL DEFAULT 1, |
@@ -571,7 +571,7 @@ discard block |
||
571 | 571 | PRC_parent int(10) unsigned DEFAULT 0, |
572 | 572 | PRIMARY KEY (PRC_ID), |
573 | 573 | KEY PRT_ID (PRT_ID)"; |
574 | - $this->_table_is_changed_in_this_version($table_name,$sql, 'ENGINE=InnoDB'); |
|
574 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
575 | 575 | |
576 | 576 | $table_name = "esp_price_type"; |
577 | 577 | $sql = "PRT_ID tinyint(3) unsigned NOT NULL AUTO_INCREMENT, |
@@ -609,10 +609,10 @@ discard block |
||
609 | 609 | TKT_deleted tinyint(1) NOT NULL DEFAULT '0', |
610 | 610 | PRIMARY KEY (TKT_ID), |
611 | 611 | KEY TKT_start_date (TKT_start_date)"; |
612 | - $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
612 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
613 | 613 | |
614 | 614 | $table_name = 'esp_question_group'; |
615 | - $sql='QSG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
615 | + $sql = 'QSG_ID int(10) unsigned NOT NULL AUTO_INCREMENT, |
|
616 | 616 | QSG_name varchar(255) NOT NULL, |
617 | 617 | QSG_identifier varchar(100) NOT NULL, |
618 | 618 | QSG_desc text NULL, |
@@ -625,7 +625,7 @@ discard block |
||
625 | 625 | PRIMARY KEY (QSG_ID), |
626 | 626 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier), |
627 | 627 | KEY QSG_order (QSG_order)'; |
628 | - $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
628 | + $this->_table_is_changed_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
629 | 629 | |
630 | 630 | /** @var EE_DMS_Core_4_1_0 $script_4_1_defaults */ |
631 | 631 | $script_4_1_defaults = EE_Registry::instance()->load_dms('Core_4_1_0'); |
@@ -661,7 +661,7 @@ discard block |
||
661 | 661 | return $script_4_7_defaults->schema_changes_after_migration(); |
662 | 662 | } |
663 | 663 | |
664 | - public function migration_page_hooks(){ |
|
664 | + public function migration_page_hooks() { |
|
665 | 665 | |
666 | 666 | } |
667 | 667 | |
@@ -675,19 +675,19 @@ discard block |
||
675 | 675 | //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 |
676 | 676 | //('AD', 'AND', 0, 'Andorra', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+376', 0, 0), |
677 | 677 | $newer_countries = array( |
678 | - array( 'AX', 'ALA', 0, 'Alan Islands', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+358', 1, 0 ), |
|
679 | - array( 'BL', 'BLM', 0, 'Saint Barthelemy', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0 ), |
|
680 | - array( 'CW', 'CUW', 0, 'Curacao', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+599', 1, 0 ), |
|
681 | - array( 'GG', 'GGY', 0, 'Guernsey', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+44', 0, 0 ), |
|
682 | - array( 'IM', 'IMN', 0, 'Isle of Man', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0 ), |
|
683 | - array( 'JE', 'JEY', 0, 'Jersey', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0 ), |
|
684 | - array( 'MF', 'MAF', 0, 'Saint Martin', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0 ), |
|
685 | - array( 'MN', 'MNE', 0, 'Montenegro', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+382', 0, 0 ), |
|
686 | - array( 'RS', 'SRB', 0, 'Serbia', 'RSD', 'Dinar', 'Dinars', '', 0, 2, '+941', 1, 0 ), |
|
687 | - array( 'SS', 'SSD', 0, 'South Sudan', 'SSP', 'Pound', 'Pounds', '£', 1, 2, '+211', 0, 0 ), |
|
688 | - array( 'SX', 'SXM', 0, 'Sint Maarten', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+1', 1, 0 ), |
|
689 | - array( 'XK', 'XKX', 0, 'Kosovo', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+381', 0, 0 ), |
|
690 | - array( 'YT', 'MYT', 0, 'Mayotte', 'EUR', 'Euro', 'Euros', '€', 0, 2, '+262', 1, 0 ), |
|
678 | + array('AX', 'ALA', 0, 'Alan Islands', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+358', 1, 0), |
|
679 | + array('BL', 'BLM', 0, 'Saint Barthelemy', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0), |
|
680 | + array('CW', 'CUW', 0, 'Curacao', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+599', 1, 0), |
|
681 | + array('GG', 'GGY', 0, 'Guernsey', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+44', 0, 0), |
|
682 | + array('IM', 'IMN', 0, 'Isle of Man', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0), |
|
683 | + array('JE', 'JEY', 0, 'Jersey', 'GBP', 'Pound', 'Pounds', '£', 1, 2, '+44', 0, 0), |
|
684 | + array('MF', 'MAF', 0, 'Saint Martin', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+590', 1, 0), |
|
685 | + array('MN', 'MNE', 0, 'Montenegro', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+382', 0, 0), |
|
686 | + array('RS', 'SRB', 0, 'Serbia', 'RSD', 'Dinar', 'Dinars', '', 0, 2, '+941', 1, 0), |
|
687 | + array('SS', 'SSD', 0, 'South Sudan', 'SSP', 'Pound', 'Pounds', '£', 1, 2, '+211', 0, 0), |
|
688 | + array('SX', 'SXM', 0, 'Sint Maarten', 'ANG', 'Guilder', 'Guilders', 'ƒ', 1, 2, '+1', 1, 0), |
|
689 | + array('XK', 'XKX', 0, 'Kosovo', 'EUR', 'Euro', 'Euros', '€', 1, 2, '+381', 0, 0), |
|
690 | + array('YT', 'MYT', 0, 'Mayotte', 'EUR', 'Euro', 'Euros', '€', 0, 2, '+262', 1, 0), |
|
691 | 691 | ); |
692 | 692 | global $wpdb; |
693 | 693 | $country_table = $wpdb->prefix."esp_country"; |
@@ -706,14 +706,14 @@ discard block |
||
706 | 706 | "CNT_is_EU" => '%d', |
707 | 707 | "CNT_active" => '%d', |
708 | 708 | ); |
709 | - if ( EEH_Activation::table_exists( $country_table ) ) { |
|
710 | - foreach( $newer_countries as $country ) { |
|
711 | - $SQL = "SELECT COUNT('CNT_ISO') FROM {$country_table} WHERE CNT_ISO='{$country[0]}' LIMIT 1" ; |
|
709 | + if (EEH_Activation::table_exists($country_table)) { |
|
710 | + foreach ($newer_countries as $country) { |
|
711 | + $SQL = "SELECT COUNT('CNT_ISO') FROM {$country_table} WHERE CNT_ISO='{$country[0]}' LIMIT 1"; |
|
712 | 712 | $countries = $wpdb->get_var($SQL); |
713 | - if ( ! $countries ) { |
|
713 | + if ( ! $countries) { |
|
714 | 714 | |
715 | - $wpdb->insert( $country_table, |
|
716 | - array_combine( array_keys( $country_format), $country ), |
|
715 | + $wpdb->insert($country_table, |
|
716 | + array_combine(array_keys($country_format), $country), |
|
717 | 717 | $country_format |
718 | 718 | ); |
719 | 719 | } |
@@ -731,7 +731,7 @@ discard block |
||
731 | 731 | // CUR_code, CUR_single, CUR_plural, CUR_sign, CUR_dec_plc, CUR_active |
732 | 732 | //( 'EUR', 'Euro', 'Euros', '€', 2,1), |
733 | 733 | $newer_currencies = array( |
734 | - array( 'RSD', 'Dinar', 'Dinars', '', 3, 1 ), |
|
734 | + array('RSD', 'Dinar', 'Dinars', '', 3, 1), |
|
735 | 735 | ); |
736 | 736 | global $wpdb; |
737 | 737 | $currency_table = $wpdb->prefix."esp_currency"; |
@@ -743,14 +743,14 @@ discard block |
||
743 | 743 | "CUR_dec_plc" => '%d', |
744 | 744 | "CUR_active" => '%d', |
745 | 745 | ); |
746 | - if ( EEH_Activation::table_exists( $currency_table ) ) { |
|
747 | - foreach( $newer_currencies as $currency ) { |
|
748 | - $SQL = "SELECT COUNT('CUR_code') FROM {$currency_table} WHERE CUR_code='{$currency[0]}' LIMIT 1" ; |
|
746 | + if (EEH_Activation::table_exists($currency_table)) { |
|
747 | + foreach ($newer_currencies as $currency) { |
|
748 | + $SQL = "SELECT COUNT('CUR_code') FROM {$currency_table} WHERE CUR_code='{$currency[0]}' LIMIT 1"; |
|
749 | 749 | $countries = $wpdb->get_var($SQL); |
750 | - if ( ! $countries ) { |
|
750 | + if ( ! $countries) { |
|
751 | 751 | |
752 | - $wpdb->insert( $currency_table, |
|
753 | - array_combine( array_keys( $currency_format), $currency ), |
|
752 | + $wpdb->insert($currency_table, |
|
753 | + array_combine(array_keys($currency_format), $currency), |
|
754 | 754 | $currency_format |
755 | 755 | ); |
756 | 756 | } |
@@ -762,9 +762,9 @@ discard block |
||
762 | 762 | * which should just be a temporary issue for folks who installed 4.8.0-4.8.5; |
763 | 763 | * we should be able to stop doing this in 4.9 |
764 | 764 | */ |
765 | - public function fix_non_default_taxes(){ |
|
765 | + public function fix_non_default_taxes() { |
|
766 | 766 | global $wpdb; |
767 | - $query = $wpdb->prepare( "UPDATE |
|
767 | + $query = $wpdb->prepare("UPDATE |
|
768 | 768 | {$wpdb->prefix}esp_price p INNER JOIN |
769 | 769 | {$wpdb->prefix}esp_price_type pt ON p.PRT_ID = pt.PRT_ID |
770 | 770 | SET |
@@ -772,7 +772,7 @@ discard block |
||
772 | 772 | WHERE |
773 | 773 | p.PRC_is_default = 0 AND |
774 | 774 | pt.PBT_ID = %d |
775 | - ", EEM_Price_Type::base_type_tax ); |
|
776 | - $wpdb->query( $query ); |
|
775 | + ", EEM_Price_Type::base_type_tax); |
|
776 | + $wpdb->query($query); |
|
777 | 777 | } |
778 | 778 | } |
@@ -25,30 +25,30 @@ discard block |
||
25 | 25 | * ------------------------------------------------------------------------ |
26 | 26 | */ |
27 | 27 | // defined some new constants related to caffeinated folder |
28 | -define('EE_CAF_URL', EE_PLUGIN_DIR_URL . 'caffeinated/' ); |
|
29 | -define('EE_CAF_CORE', EE_CAFF_PATH . 'core' . DS); |
|
30 | -define('EE_CAF_LIBRARIES', EE_CAF_CORE . 'libraries' . DS); |
|
31 | -define('EE_CAF_PAYMENT_METHODS', EE_CAFF_PATH . 'payment_methods' . DS ); |
|
28 | +define('EE_CAF_URL', EE_PLUGIN_DIR_URL.'caffeinated/'); |
|
29 | +define('EE_CAF_CORE', EE_CAFF_PATH.'core'.DS); |
|
30 | +define('EE_CAF_LIBRARIES', EE_CAF_CORE.'libraries'.DS); |
|
31 | +define('EE_CAF_PAYMENT_METHODS', EE_CAFF_PATH.'payment_methods'.DS); |
|
32 | 32 | class EE_Brewing_Regular extends EE_Base { |
33 | 33 | |
34 | 34 | public function __construct() { |
35 | - if ( defined( 'EE_CAFF_PATH' )) { |
|
35 | + if (defined('EE_CAFF_PATH')) { |
|
36 | 36 | // activation |
37 | - add_action( 'AHEE__EEH_Activation__initialize_db_content', array( $this, 'initialize_caf_db_content' )); |
|
37 | + add_action('AHEE__EEH_Activation__initialize_db_content', array($this, 'initialize_caf_db_content')); |
|
38 | 38 | // load caff init |
39 | - add_action( 'AHEE__EE_System__set_hooks_for_core', array( $this, 'caffeinated_init' )); |
|
39 | + add_action('AHEE__EE_System__set_hooks_for_core', array($this, 'caffeinated_init')); |
|
40 | 40 | // make it so the PDF receipt doesn't show our shameless plug |
41 | - add_filter( 'FHEE_Invoice__send_invoice__shameless_plug', '__return_false' ); |
|
41 | + add_filter('FHEE_Invoice__send_invoice__shameless_plug', '__return_false'); |
|
42 | 42 | // add caffeinated modules |
43 | - add_filter( 'FHEE__EE_Config__register_modules__modules_to_register', array( $this, 'caffeinated_modules_to_register' )); |
|
43 | + add_filter('FHEE__EE_Config__register_modules__modules_to_register', array($this, 'caffeinated_modules_to_register')); |
|
44 | 44 | // load caff scripts |
45 | - add_action( 'wp_enqueue_scripts', array( $this, 'enqueue_caffeinated_scripts'), 10 ); |
|
45 | + add_action('wp_enqueue_scripts', array($this, 'enqueue_caffeinated_scripts'), 10); |
|
46 | 46 | |
47 | - add_filter( 'FHEE__EE_Registry__load_helper__helper_paths', array( $this, 'caf_helper_paths' ), 10 ); |
|
47 | + add_filter('FHEE__EE_Registry__load_helper__helper_paths', array($this, 'caf_helper_paths'), 10); |
|
48 | 48 | |
49 | - add_filter( 'FHEE__EE_Payment_Method_Manager__register_payment_methods__payment_methods_to_register', array( $this, 'caf_payment_methods' ) ); |
|
49 | + add_filter('FHEE__EE_Payment_Method_Manager__register_payment_methods__payment_methods_to_register', array($this, 'caf_payment_methods')); |
|
50 | 50 | // caffeinated constructed |
51 | - do_action( 'AHEE__EE_Brewing_Regular__construct__complete' ); |
|
51 | + do_action('AHEE__EE_Brewing_Regular__construct__complete'); |
|
52 | 52 | } |
53 | 53 | } |
54 | 54 | |
@@ -58,8 +58,8 @@ discard block |
||
58 | 58 | * @param array $paths original helper paths array |
59 | 59 | * @return array new array of paths |
60 | 60 | */ |
61 | - public function caf_helper_paths( $paths ) { |
|
62 | - $paths[] = EE_CAF_CORE . 'helpers' . DS; |
|
61 | + public function caf_helper_paths($paths) { |
|
62 | + $paths[] = EE_CAF_CORE.'helpers'.DS; |
|
63 | 63 | return $paths; |
64 | 64 | } |
65 | 65 | |
@@ -75,22 +75,22 @@ discard block |
||
75 | 75 | * Right now, we ASSUME the only price types in the system are default ones |
76 | 76 | * @global type $wpdb |
77 | 77 | */ |
78 | - function initialize_caf_db_content(){ |
|
78 | + function initialize_caf_db_content() { |
|
79 | 79 | // echo "initialize caf db content!"; |
80 | 80 | global $wpdb; |
81 | 81 | |
82 | 82 | //use same method of getting creator id as the version introducing the change |
83 | - $default_creator_id = apply_filters('FHEE__EE_DMS_Core_4_5_0__get_default_creator_id',get_current_user_id()); |
|
83 | + $default_creator_id = apply_filters('FHEE__EE_DMS_Core_4_5_0__get_default_creator_id', get_current_user_id()); |
|
84 | 84 | |
85 | 85 | $price_type_table = $wpdb->prefix."esp_price_type"; |
86 | 86 | $price_table = $wpdb->prefix."esp_price"; |
87 | 87 | |
88 | - if ( EEH_Activation::table_exists( $price_type_table ) ) { |
|
88 | + if (EEH_Activation::table_exists($price_type_table)) { |
|
89 | 89 | |
90 | - $SQL = 'SELECT COUNT(PRT_ID) FROM ' . $price_type_table . ' WHERE PBT_ID=4';//include trashed price types |
|
91 | - $tax_price_type_count = $wpdb->get_var( $SQL ); |
|
90 | + $SQL = 'SELECT COUNT(PRT_ID) FROM '.$price_type_table.' WHERE PBT_ID=4'; //include trashed price types |
|
91 | + $tax_price_type_count = $wpdb->get_var($SQL); |
|
92 | 92 | |
93 | - if ( $tax_price_type_count <= 1) { |
|
93 | + if ($tax_price_type_count <= 1) { |
|
94 | 94 | $result = $wpdb->insert($price_type_table, |
95 | 95 | array( |
96 | 96 | 'PRT_name'=> __("Regional Tax", "event_espresso"), |
@@ -101,11 +101,11 @@ discard block |
||
101 | 101 | 'PRT_wp_user' => $default_creator_id |
102 | 102 | ), |
103 | 103 | array( |
104 | - '%s',//PRT_name |
|
105 | - '%d',//PBT_id |
|
106 | - '%d',//PRT_is_percent |
|
107 | - '%d',//PRT_order |
|
108 | - '%d',//PRT_deleted |
|
104 | + '%s', //PRT_name |
|
105 | + '%d', //PBT_id |
|
106 | + '%d', //PRT_is_percent |
|
107 | + '%d', //PRT_order |
|
108 | + '%d', //PRT_deleted |
|
109 | 109 | '%d', //PRT_wp_user |
110 | 110 | )); |
111 | 111 | //federal tax |
@@ -119,14 +119,14 @@ discard block |
||
119 | 119 | 'PRT_wp_user' => $default_creator_id, |
120 | 120 | ), |
121 | 121 | array( |
122 | - '%s',//PRT_name |
|
123 | - '%d',//PBT_id |
|
124 | - '%d',//PRT_is_percent |
|
125 | - '%d',//PRT_order |
|
126 | - '%d',//PRT_deleted |
|
122 | + '%s', //PRT_name |
|
123 | + '%d', //PBT_id |
|
124 | + '%d', //PRT_is_percent |
|
125 | + '%d', //PRT_order |
|
126 | + '%d', //PRT_deleted |
|
127 | 127 | '%d' //PRT_wp_user |
128 | 128 | )); |
129 | - if( $result){ |
|
129 | + if ($result) { |
|
130 | 130 | $wpdb->insert($price_table, |
131 | 131 | array( |
132 | 132 | 'PRT_ID'=>$wpdb->insert_id, |
@@ -141,15 +141,15 @@ discard block |
||
141 | 141 | 'PRC_wp_user' => $default_creator_id |
142 | 142 | ), |
143 | 143 | array( |
144 | - '%d',//PRT_id |
|
145 | - '%f',//PRC_amount |
|
146 | - '%s',//PRC_name |
|
147 | - '%s',//PRC_desc |
|
148 | - '%d',//PRC_is_default |
|
149 | - '%d',//PRC_overrides |
|
150 | - '%d',//PRC_deleted |
|
151 | - '%d',//PRC_order |
|
152 | - '%d',//PRC_parent |
|
144 | + '%d', //PRT_id |
|
145 | + '%f', //PRC_amount |
|
146 | + '%s', //PRC_name |
|
147 | + '%s', //PRC_desc |
|
148 | + '%d', //PRC_is_default |
|
149 | + '%d', //PRC_overrides |
|
150 | + '%d', //PRC_deleted |
|
151 | + '%d', //PRC_order |
|
152 | + '%d', //PRC_parent |
|
153 | 153 | '%d' //PRC_wp_user |
154 | 154 | )); |
155 | 155 | } |
@@ -169,11 +169,11 @@ discard block |
||
169 | 169 | * @param array $modules_to_register |
170 | 170 | * @return array |
171 | 171 | */ |
172 | - public function caffeinated_modules_to_register( $modules_to_register = array() ){ |
|
173 | - if ( is_readable( EE_CAFF_PATH . 'modules' )) { |
|
174 | - $caffeinated_modules_to_register = glob( EE_CAFF_PATH . 'modules' . DS . '*', GLOB_ONLYDIR ); |
|
175 | - if ( is_array( $caffeinated_modules_to_register ) && ! empty( $caffeinated_modules_to_register )) { |
|
176 | - $modules_to_register = array_merge( $modules_to_register, $caffeinated_modules_to_register ); |
|
172 | + public function caffeinated_modules_to_register($modules_to_register = array()) { |
|
173 | + if (is_readable(EE_CAFF_PATH.'modules')) { |
|
174 | + $caffeinated_modules_to_register = glob(EE_CAFF_PATH.'modules'.DS.'*', GLOB_ONLYDIR); |
|
175 | + if (is_array($caffeinated_modules_to_register) && ! empty($caffeinated_modules_to_register)) { |
|
176 | + $modules_to_register = array_merge($modules_to_register, $caffeinated_modules_to_register); |
|
177 | 177 | } |
178 | 178 | } |
179 | 179 | return $modules_to_register; |
@@ -181,19 +181,19 @@ discard block |
||
181 | 181 | |
182 | 182 | |
183 | 183 | |
184 | - public function caffeinated_init(){ |
|
184 | + public function caffeinated_init() { |
|
185 | 185 | // EE_Register_CPTs hooks |
186 | - add_filter('FHEE__EE_Register_CPTs__get_taxonomies__taxonomies', array( $this, 'filter_taxonomies' ), 10 ); |
|
187 | - add_filter('FHEE__EE_Register_CPTs__get_CPTs__cpts', array( $this, 'filter_cpts' ), 10 ); |
|
188 | - add_filter('FHEE__EE_Admin__get_extra_nav_menu_pages_items', array( $this, 'nav_metabox_items' ), 10 ); |
|
189 | - EE_Registry::instance()->load_file( EE_CAFF_PATH, 'EE_Caf_Messages', 'class', array(), FALSE ); |
|
186 | + add_filter('FHEE__EE_Register_CPTs__get_taxonomies__taxonomies', array($this, 'filter_taxonomies'), 10); |
|
187 | + add_filter('FHEE__EE_Register_CPTs__get_CPTs__cpts', array($this, 'filter_cpts'), 10); |
|
188 | + add_filter('FHEE__EE_Admin__get_extra_nav_menu_pages_items', array($this, 'nav_metabox_items'), 10); |
|
189 | + EE_Registry::instance()->load_file(EE_CAFF_PATH, 'EE_Caf_Messages', 'class', array(), FALSE); |
|
190 | 190 | // caffeinated_init__complete hook |
191 | - do_action( 'AHEE__EE_Brewing_Regular__caffeinated_init__complete' ); |
|
191 | + do_action('AHEE__EE_Brewing_Regular__caffeinated_init__complete'); |
|
192 | 192 | } |
193 | 193 | |
194 | 194 | |
195 | 195 | |
196 | - public function enqueue_caffeinated_scripts(){ |
|
196 | + public function enqueue_caffeinated_scripts() { |
|
197 | 197 | // sound of crickets... |
198 | 198 | } |
199 | 199 | |
@@ -202,23 +202,23 @@ discard block |
||
202 | 202 | * callbacks below here |
203 | 203 | */ |
204 | 204 | |
205 | - public function filter_taxonomies( $taxonomy_array ) { |
|
205 | + public function filter_taxonomies($taxonomy_array) { |
|
206 | 206 | $taxonomy_array['espresso_venue_categories']['args']['show_in_nav_menus'] = TRUE; |
207 | 207 | return $taxonomy_array; |
208 | 208 | } |
209 | 209 | |
210 | 210 | |
211 | 211 | |
212 | - public function filter_cpts( $cpt_array ) { |
|
212 | + public function filter_cpts($cpt_array) { |
|
213 | 213 | $cpt_array['espresso_venues']['args']['show_in_nav_menus'] = TRUE; |
214 | 214 | return $cpt_array; |
215 | 215 | } |
216 | 216 | |
217 | 217 | |
218 | - public function nav_metabox_items( $menuitems ) { |
|
218 | + public function nav_metabox_items($menuitems) { |
|
219 | 219 | $menuitems[] = array( |
220 | 220 | 'title' => __('Venue List', 'event_espresso'), |
221 | - 'url' => get_post_type_archive_link( 'espresso_venues' ), |
|
221 | + 'url' => get_post_type_archive_link('espresso_venues'), |
|
222 | 222 | 'description' => __('Archive page for all venues.', 'event_espresso') |
223 | 223 | ); |
224 | 224 | return $menuitems; |
@@ -229,9 +229,9 @@ discard block |
||
229 | 229 | * @param array $payment_method_paths |
230 | 230 | * @return array values are folder paths to payment method folders |
231 | 231 | */ |
232 | - public function caf_payment_methods( $payment_method_paths ) { |
|
233 | - $caf_payment_methods_paths = glob( EE_CAF_PAYMENT_METHODS . '*', GLOB_ONLYDIR ); |
|
234 | - $payment_method_paths = array_merge( $payment_method_paths, $caf_payment_methods_paths ); |
|
232 | + public function caf_payment_methods($payment_method_paths) { |
|
233 | + $caf_payment_methods_paths = glob(EE_CAF_PAYMENT_METHODS.'*', GLOB_ONLYDIR); |
|
234 | + $payment_method_paths = array_merge($payment_method_paths, $caf_payment_methods_paths); |
|
235 | 235 | return $payment_method_paths; |
236 | 236 | } |
237 | 237 | } |
@@ -10,7 +10,7 @@ discard block |
||
10 | 10 | * @subpackage Expression package is undefined on line 19, column 19 in Templates/Scripting/PHPClass.php. |
11 | 11 | * @author Mike Nelson |
12 | 12 | */ |
13 | -class EE_Model_Matching_Query_Validation_Strategy extends EE_Validation_Strategy_Base{ |
|
13 | +class EE_Model_Matching_Query_Validation_Strategy extends EE_Validation_Strategy_Base { |
|
14 | 14 | |
15 | 15 | /** |
16 | 16 | * |
@@ -27,30 +27,30 @@ discard block |
||
27 | 27 | * @param array $query_params @see EEM_Base::get_all() |
28 | 28 | * @param string $input_field_name the input will be treated as this field's value |
29 | 29 | */ |
30 | - public function __construct( $validation_error_message = NULL, $model_name = '', $query_params = array(), $input_field_name = '' ) { |
|
31 | - if( ! EE_Registry::instance()->is_model_name( $model_name ) ) { |
|
32 | - throw new EE_Error( sprintf( __( 'You must provide a valid model object ', 'event_espresso'), $model_name ) ); |
|
30 | + public function __construct($validation_error_message = NULL, $model_name = '', $query_params = array(), $input_field_name = '') { |
|
31 | + if ( ! EE_Registry::instance()->is_model_name($model_name)) { |
|
32 | + throw new EE_Error(sprintf(__('You must provide a valid model object ', 'event_espresso'), $model_name)); |
|
33 | 33 | } |
34 | - $this->_model = EE_Registry::instance()->load_model( $model_name ); |
|
34 | + $this->_model = EE_Registry::instance()->load_model($model_name); |
|
35 | 35 | $this->_query_params = $query_params; |
36 | - if( empty( $input_field_name ) ) { |
|
36 | + if (empty($input_field_name)) { |
|
37 | 37 | $input_field_name = $this->_model->primary_key_name(); |
38 | 38 | } |
39 | 39 | $this->_input_field_name = $input_field_name; |
40 | - parent::__construct( $validation_error_message ); |
|
40 | + parent::__construct($validation_error_message); |
|
41 | 41 | } |
42 | 42 | |
43 | 43 | /** |
44 | 44 | * @param $normalized_value |
45 | 45 | */ |
46 | 46 | public function validate($normalized_value) { |
47 | - if( empty( $normalized_value ) ) { |
|
47 | + if (empty($normalized_value)) { |
|
48 | 48 | return true; |
49 | 49 | } |
50 | 50 | $combined_query_params = $this->get_query_params(); |
51 | - $combined_query_params[0][ $this->treat_input_as_field() ] = $normalized_value; |
|
52 | - if( ! $this->get_model()->exists( $combined_query_params ) ) { |
|
53 | - throw new EE_Validation_Error( $this->get_validation_error_message(), 'no_matching_model_object' ); |
|
51 | + $combined_query_params[0][$this->treat_input_as_field()] = $normalized_value; |
|
52 | + if ( ! $this->get_model()->exists($combined_query_params)) { |
|
53 | + throw new EE_Validation_Error($this->get_validation_error_message(), 'no_matching_model_object'); |
|
54 | 54 | } |
55 | 55 | } |
56 | 56 | |
@@ -67,7 +67,7 @@ discard block |
||
67 | 67 | * @return array |
68 | 68 | */ |
69 | 69 | public function get_query_params() { |
70 | - return (array)$this->_query_params; |
|
70 | + return (array) $this->_query_params; |
|
71 | 71 | } |
72 | 72 | |
73 | 73 | /** |
@@ -12,16 +12,16 @@ discard block |
||
12 | 12 | //(all other times it gets resurrected from a wordpress option) |
13 | 13 | $stages = glob(EE_CORE.'data_migration_scripts/4_5_0_stages/*'); |
14 | 14 | $class_to_filepath = array(); |
15 | -foreach($stages as $filepath){ |
|
15 | +foreach ($stages as $filepath) { |
|
16 | 16 | $matches = array(); |
17 | - preg_match('~4_5_0_stages/(.*).dmsstage.php~',$filepath,$matches); |
|
17 | + preg_match('~4_5_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
18 | 18 | $class_to_filepath[$matches[1]] = $filepath; |
19 | 19 | } |
20 | 20 | //give addons a chance to autoload their stages too |
21 | -$class_to_filepath = apply_filters('FHEE__EE_DMS_4_5_0__autoloaded_stages',$class_to_filepath); |
|
21 | +$class_to_filepath = apply_filters('FHEE__EE_DMS_4_5_0__autoloaded_stages', $class_to_filepath); |
|
22 | 22 | EEH_Autoloader::register_autoloader($class_to_filepath); |
23 | 23 | |
24 | -class EE_DMS_Core_4_5_0 extends EE_Data_Migration_Script_Base{ |
|
24 | +class EE_DMS_Core_4_5_0 extends EE_Data_Migration_Script_Base { |
|
25 | 25 | |
26 | 26 | |
27 | 27 | |
@@ -39,14 +39,14 @@ discard block |
||
39 | 39 | } |
40 | 40 | public function can_migrate_from_version($version_array) { |
41 | 41 | $version_string = $version_array['Core']; |
42 | - if($version_string <= '4.5.0' && $version_string >= '4.3.0' ){ |
|
42 | + if ($version_string <= '4.5.0' && $version_string >= '4.3.0') { |
|
43 | 43 | // echo "$version_string can be migrated from"; |
44 | 44 | return true; |
45 | - }elseif( ! $version_string ){ |
|
45 | + }elseif ( ! $version_string) { |
|
46 | 46 | // echo "no version string provided: $version_string"; |
47 | 47 | //no version string provided... this must be pre 4.3 |
48 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
49 | - }else{ |
|
48 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
49 | + } else { |
|
50 | 50 | // echo "$version_string doesnt apply"; |
51 | 51 | return false; |
52 | 52 | } |
@@ -56,14 +56,14 @@ discard block |
||
56 | 56 | } |
57 | 57 | public function schema_changes_before_migration() { |
58 | 58 | //relies on 4.1's EEH_Activation::create_table |
59 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
60 | - $table_name='esp_answer'; |
|
61 | - $sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
59 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
60 | + $table_name = 'esp_answer'; |
|
61 | + $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
62 | 62 | REG_ID INT UNSIGNED NOT NULL, |
63 | 63 | QST_ID INT UNSIGNED NOT NULL, |
64 | 64 | ANS_value TEXT NOT NULL, |
65 | 65 | PRIMARY KEY (ANS_ID)"; |
66 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
66 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
67 | 67 | |
68 | 68 | $table_name = 'esp_attendee_meta'; |
69 | 69 | $sql = "ATTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -102,7 +102,7 @@ discard block |
||
102 | 102 | CNT_is_EU TINYINT(1) DEFAULT '0', |
103 | 103 | CNT_active TINYINT(1) DEFAULT '0', |
104 | 104 | PRIMARY KEY (CNT_ISO)"; |
105 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
105 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
106 | 106 | |
107 | 107 | $table_name = 'esp_datetime'; |
108 | 108 | $sql = "DTT_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -123,7 +123,7 @@ discard block |
||
123 | 123 | |
124 | 124 | |
125 | 125 | |
126 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
126 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
127 | 127 | $table_name = 'esp_event_meta'; |
128 | 128 | $sql = " |
129 | 129 | EVTM_ID INT NOT NULL AUTO_INCREMENT, |
@@ -140,41 +140,41 @@ discard block |
||
140 | 140 | EVT_external_URL VARCHAR(200) NULL, |
141 | 141 | EVT_donations TINYINT(1) NULL, |
142 | 142 | PRIMARY KEY (EVTM_ID)"; |
143 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
143 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
144 | 144 | |
145 | 145 | |
146 | 146 | |
147 | - $table_name='esp_event_question_group'; |
|
148 | - $sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
147 | + $table_name = 'esp_event_question_group'; |
|
148 | + $sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
149 | 149 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
150 | 150 | QSG_ID INT UNSIGNED NOT NULL, |
151 | 151 | EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
152 | 152 | PRIMARY KEY (EQG_ID)"; |
153 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
153 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
154 | 154 | |
155 | 155 | |
156 | 156 | |
157 | - $table_name='esp_event_venue'; |
|
158 | - $sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
157 | + $table_name = 'esp_event_venue'; |
|
158 | + $sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
159 | 159 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
160 | 160 | VNU_ID BIGINT(20) UNSIGNED NOT NULL, |
161 | 161 | EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
162 | 162 | PRIMARY KEY (EVV_ID)"; |
163 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
163 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
164 | 164 | |
165 | 165 | |
166 | 166 | |
167 | - $table_name='esp_extra_meta'; |
|
168 | - $sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
167 | + $table_name = 'esp_extra_meta'; |
|
168 | + $sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
169 | 169 | OBJ_ID INT(11) DEFAULT NULL, |
170 | 170 | EXM_type VARCHAR(45) DEFAULT NULL, |
171 | 171 | EXM_key VARCHAR(45) DEFAULT NULL, |
172 | 172 | EXM_value TEXT, |
173 | 173 | PRIMARY KEY (EXM_ID)"; |
174 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
174 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
175 | 175 | |
176 | - $table_name='esp_line_item'; |
|
177 | - $sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
176 | + $table_name = 'esp_line_item'; |
|
177 | + $sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
178 | 178 | LIN_code VARCHAR(245) NOT NULL DEFAULT '', |
179 | 179 | TXN_ID INT(11) DEFAULT NULL, |
180 | 180 | LIN_name VARCHAR(245) NOT NULL DEFAULT '', |
@@ -190,7 +190,7 @@ discard block |
||
190 | 190 | OBJ_ID INT(11) DEFAULT NULL, |
191 | 191 | OBJ_type VARCHAR(45)DEFAULT NULL, |
192 | 192 | PRIMARY KEY (LIN_ID)"; |
193 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB' ); |
|
193 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
194 | 194 | |
195 | 195 | $table_name = 'esp_message_template'; |
196 | 196 | $sql = "MTP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -202,7 +202,7 @@ discard block |
||
202 | 202 | KEY GRP_ID (GRP_ID)"; |
203 | 203 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
204 | 204 | |
205 | - EEH_Activation::drop_index( 'esp_message_template_group', 'EVT_ID' ); |
|
205 | + EEH_Activation::drop_index('esp_message_template_group', 'EVT_ID'); |
|
206 | 206 | |
207 | 207 | $table_name = 'esp_message_template_group'; |
208 | 208 | $sql = "GRP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -217,7 +217,7 @@ discard block |
||
217 | 217 | MTP_is_active TINYINT(1) NOT NULL DEFAULT '1', |
218 | 218 | PRIMARY KEY (GRP_ID), |
219 | 219 | KEY MTP_user_id (MTP_user_id)"; |
220 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
220 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
221 | 221 | |
222 | 222 | $table_name = 'esp_event_message_template'; |
223 | 223 | $sql = "EMT_ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -226,7 +226,7 @@ discard block |
||
226 | 226 | PRIMARY KEY (EMT_ID), |
227 | 227 | KEY EVT_ID (EVT_ID), |
228 | 228 | KEY GRP_ID (GRP_ID)"; |
229 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
229 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
230 | 230 | |
231 | 231 | |
232 | 232 | $table_name = 'esp_payment'; |
@@ -276,8 +276,8 @@ discard block |
||
276 | 276 | PRIMARY KEY (TTM_ID)"; |
277 | 277 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
278 | 278 | |
279 | - $table_name='esp_question'; |
|
280 | - $sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
279 | + $table_name = 'esp_question'; |
|
280 | + $sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
281 | 281 | QST_display_text TEXT NOT NULL, |
282 | 282 | QST_admin_label VARCHAR(255) NOT NULL, |
283 | 283 | QST_system VARCHAR(25) DEFAULT NULL, |
@@ -289,27 +289,27 @@ discard block |
||
289 | 289 | QST_wp_user BIGINT UNSIGNED NULL, |
290 | 290 | QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0, |
291 | 291 | PRIMARY KEY (QST_ID)'; |
292 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
292 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
293 | 293 | |
294 | - $table_name='esp_question_group_question'; |
|
295 | - $sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
294 | + $table_name = 'esp_question_group_question'; |
|
295 | + $sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
296 | 296 | QSG_ID INT UNSIGNED NOT NULL, |
297 | 297 | QST_ID INT UNSIGNED NOT NULL, |
298 | 298 | QGQ_order INT UNSIGNED NOT NULL DEFAULT 0, |
299 | 299 | PRIMARY KEY (QGQ_ID) "; |
300 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
300 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
301 | 301 | |
302 | 302 | |
303 | 303 | |
304 | - $table_name='esp_question_option'; |
|
305 | - $sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
304 | + $table_name = 'esp_question_option'; |
|
305 | + $sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
306 | 306 | QSO_value VARCHAR(255) NOT NULL, |
307 | 307 | QSO_desc TEXT NOT NULL, |
308 | 308 | QST_ID INT UNSIGNED NOT NULL, |
309 | 309 | QSO_order INT UNSIGNED NOT NULL DEFAULT 0, |
310 | 310 | QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
311 | 311 | PRIMARY KEY (QSO_ID)"; |
312 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
312 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
313 | 313 | |
314 | 314 | |
315 | 315 | |
@@ -342,8 +342,8 @@ discard block |
||
342 | 342 | |
343 | 343 | |
344 | 344 | |
345 | - $table_name='esp_checkin'; |
|
346 | - $sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
345 | + $table_name = 'esp_checkin'; |
|
346 | + $sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
347 | 347 | REG_ID INT(10) UNSIGNED NOT NULL, |
348 | 348 | DTT_ID INT(10) UNSIGNED NOT NULL, |
349 | 349 | CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, |
@@ -431,7 +431,7 @@ discard block |
||
431 | 431 | PRC_wp_user BIGINT UNSIGNED NULL, |
432 | 432 | PRC_parent INT(10) UNSIGNED DEFAULT 0, |
433 | 433 | PRIMARY KEY (PRC_ID)"; |
434 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
434 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
435 | 435 | |
436 | 436 | $table_name = "esp_price_type"; |
437 | 437 | $sql = "PRT_ID TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -468,12 +468,12 @@ discard block |
||
468 | 468 | TKT_parent INT(10) UNSIGNED DEFAULT '0', |
469 | 469 | TKT_deleted TINYINT(1) NOT NULL DEFAULT '0', |
470 | 470 | PRIMARY KEY (TKT_ID)"; |
471 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
471 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
472 | 472 | |
473 | - EEH_Activation::drop_index( 'esp_question_group', 'QSG_identifier_UNIQUE' ); |
|
473 | + EEH_Activation::drop_index('esp_question_group', 'QSG_identifier_UNIQUE'); |
|
474 | 474 | |
475 | 475 | $table_name = 'esp_question_group'; |
476 | - $sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
476 | + $sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
477 | 477 | QSG_name VARCHAR(255) NOT NULL, |
478 | 478 | QSG_identifier VARCHAR(100) NOT NULL, |
479 | 479 | QSG_desc TEXT NULL, |
@@ -485,7 +485,7 @@ discard block |
||
485 | 485 | QSG_wp_user BIGINT UNSIGNED NULL, |
486 | 486 | PRIMARY KEY (QSG_ID), |
487 | 487 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)'; |
488 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
488 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
489 | 489 | |
490 | 490 | $script_4_1_defaults = EE_Registry::instance()->load_dms('Core_4_1_0'); |
491 | 491 | |
@@ -509,7 +509,7 @@ discard block |
||
509 | 509 | return true; |
510 | 510 | } |
511 | 511 | |
512 | - public function migration_page_hooks(){ |
|
512 | + public function migration_page_hooks() { |
|
513 | 513 | |
514 | 514 | } |
515 | 515 | |
@@ -523,21 +523,21 @@ discard block |
||
523 | 523 | global $wpdb; |
524 | 524 | $price_type_table = $wpdb->prefix."esp_price_type"; |
525 | 525 | |
526 | - if ( EEH_Activation::table_exists( $price_type_table ) ) { |
|
526 | + if (EEH_Activation::table_exists($price_type_table)) { |
|
527 | 527 | |
528 | - $SQL = 'SELECT COUNT(PRT_ID) FROM ' . $price_type_table; |
|
529 | - $price_types_exist = $wpdb->get_var( $SQL ); |
|
528 | + $SQL = 'SELECT COUNT(PRT_ID) FROM '.$price_type_table; |
|
529 | + $price_types_exist = $wpdb->get_var($SQL); |
|
530 | 530 | |
531 | - if ( ! $price_types_exist ) { |
|
531 | + if ( ! $price_types_exist) { |
|
532 | 532 | $user_id = EEH_Activation::get_default_creator_id(); |
533 | 533 | $SQL = "INSERT INTO $price_type_table ( PRT_ID, PRT_name, PBT_ID, PRT_is_percent, PRT_order, PRT_wp_user, PRT_deleted ) VALUES |
534 | - (1, '" . __('Base Price', 'event_espresso') . "', 1, 0, 0, $user_id, 0), |
|
535 | - (2, '" . __('Percent Discount', 'event_espresso') . "', 2, 1, 20, $user_id, 0), |
|
536 | - (3, '" . __('Dollar Discount', 'event_espresso') . "', 2, 0, 30, $user_id, 0), |
|
537 | - (4, '" . __('Percent Surcharge', 'event_espresso') . "', 3, 1, 40, $user_id, 0), |
|
538 | - (5, '" . __('Dollar Surcharge', 'event_espresso') . "', 3, 0, 50, $user_id, 0);"; |
|
539 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_price_types__SQL', $SQL ); |
|
540 | - $wpdb->query( $SQL ); |
|
534 | + (1, '".__('Base Price', 'event_espresso')."', 1, 0, 0, $user_id, 0), |
|
535 | + (2, '".__('Percent Discount', 'event_espresso')."', 2, 1, 20, $user_id, 0), |
|
536 | + (3, '".__('Dollar Discount', 'event_espresso')."', 2, 0, 30, $user_id, 0), |
|
537 | + (4, '".__('Percent Surcharge', 'event_espresso')."', 3, 1, 40, $user_id, 0), |
|
538 | + (5, '".__('Dollar Surcharge', 'event_espresso')."', 3, 0, 50, $user_id, 0);"; |
|
539 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_price_types__SQL', $SQL); |
|
540 | + $wpdb->query($SQL); |
|
541 | 541 | } |
542 | 542 | } |
543 | 543 | } |
@@ -557,17 +557,17 @@ discard block |
||
557 | 557 | global $wpdb; |
558 | 558 | $price_table = $wpdb->prefix."esp_price"; |
559 | 559 | |
560 | - if ( EEH_Activation::table_exists( $price_table ) ) { |
|
560 | + if (EEH_Activation::table_exists($price_table)) { |
|
561 | 561 | |
562 | - $SQL = 'SELECT COUNT(PRC_ID) FROM ' .$price_table; |
|
563 | - $prices_exist = $wpdb->get_var( $SQL ); |
|
562 | + $SQL = 'SELECT COUNT(PRC_ID) FROM '.$price_table; |
|
563 | + $prices_exist = $wpdb->get_var($SQL); |
|
564 | 564 | |
565 | - if ( ! $prices_exist ) { |
|
565 | + if ( ! $prices_exist) { |
|
566 | 566 | $user_id = EEH_Activation::get_default_creator_id(); |
567 | 567 | $SQL = "INSERT INTO $price_table |
568 | 568 | (PRC_ID, PRT_ID, PRC_amount, PRC_name, PRC_desc, PRC_is_default, PRC_overrides, PRC_wp_user, PRC_order, PRC_deleted, PRC_parent ) VALUES |
569 | 569 | (1, 1, '0.00', 'Free Admission', '', 1, NULL, $user_id, 0, 0, 0);"; |
570 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_prices__SQL', $SQL ); |
|
570 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_prices__SQL', $SQL); |
|
571 | 571 | $wpdb->query($SQL); |
572 | 572 | } |
573 | 573 | } |
@@ -585,35 +585,35 @@ discard block |
||
585 | 585 | |
586 | 586 | global $wpdb; |
587 | 587 | $ticket_table = $wpdb->prefix."esp_ticket"; |
588 | - if ( EEH_Activation::table_exists( $ticket_table ) ) { |
|
588 | + if (EEH_Activation::table_exists($ticket_table)) { |
|
589 | 589 | |
590 | - $SQL = 'SELECT COUNT(TKT_ID) FROM ' . $ticket_table; |
|
590 | + $SQL = 'SELECT COUNT(TKT_ID) FROM '.$ticket_table; |
|
591 | 591 | $tickets_exist = $wpdb->get_var($SQL); |
592 | 592 | |
593 | - if ( ! $tickets_exist ) { |
|
593 | + if ( ! $tickets_exist) { |
|
594 | 594 | $user_id = EEH_Activation::get_default_creator_id(); |
595 | 595 | $SQL = "INSERT INTO $ticket_table |
596 | 596 | ( TKT_ID, TTM_ID, TKT_name, TKT_description, TKT_qty, TKT_sold, TKT_uses, TKT_required, TKT_min, TKT_max, TKT_price, TKT_start_date, TKT_end_date, TKT_taxable, TKT_order, TKT_row, TKT_is_default, TKT_parent, TKT_wp_user, TKT_deleted ) VALUES |
597 | - ( 1, 0, '" . __("Free Ticket", "event_espresso") . "', '', 100, 0, -1, 0, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, $user_id, 0);"; |
|
598 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL', $SQL ); |
|
597 | + ( 1, 0, '".__("Free Ticket", "event_espresso")."', '', 100, 0, -1, 0, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, $user_id, 0);"; |
|
598 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL', $SQL); |
|
599 | 599 | $wpdb->query($SQL); |
600 | 600 | } |
601 | 601 | } |
602 | 602 | $ticket_price_table = $wpdb->prefix."esp_ticket_price"; |
603 | 603 | |
604 | - if ( EEH_Activation::table_exists( $ticket_price_table ) ) { |
|
604 | + if (EEH_Activation::table_exists($ticket_price_table)) { |
|
605 | 605 | |
606 | - $SQL = 'SELECT COUNT(TKP_ID) FROM ' . $ticket_price_table; |
|
606 | + $SQL = 'SELECT COUNT(TKP_ID) FROM '.$ticket_price_table; |
|
607 | 607 | $ticket_prc_exist = $wpdb->get_var($SQL); |
608 | 608 | |
609 | - if ( ! $ticket_prc_exist ) { |
|
609 | + if ( ! $ticket_prc_exist) { |
|
610 | 610 | |
611 | 611 | $SQL = "INSERT INTO $ticket_price_table |
612 | 612 | ( TKP_ID, TKT_ID, PRC_ID ) VALUES |
613 | 613 | ( 1, 1, 1 ) |
614 | 614 | "; |
615 | 615 | |
616 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL__ticket_price', $SQL ); |
|
616 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL__ticket_price', $SQL); |
|
617 | 617 | $wpdb->query($SQL); |
618 | 618 | } |
619 | 619 | } |
@@ -10,13 +10,13 @@ discard block |
||
10 | 10 | //(all other times it gets resurrected from a wordpress option) |
11 | 11 | $stages = glob(EE_CORE.'data_migration_scripts/4_6_0_stages/*'); |
12 | 12 | $class_to_filepath = array(); |
13 | -foreach($stages as $filepath){ |
|
13 | +foreach ($stages as $filepath) { |
|
14 | 14 | $matches = array(); |
15 | - preg_match('~4_6_0_stages/(.*).dmsstage.php~',$filepath,$matches); |
|
15 | + preg_match('~4_6_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
16 | 16 | $class_to_filepath[$matches[1]] = $filepath; |
17 | 17 | } |
18 | 18 | //give addons a chance to autoload their stages too |
19 | -$class_to_filepath = apply_filters('FHEE__EE_DMS_4_6_0__autoloaded_stages',$class_to_filepath); |
|
19 | +$class_to_filepath = apply_filters('FHEE__EE_DMS_4_6_0__autoloaded_stages', $class_to_filepath); |
|
20 | 20 | EEH_Autoloader::register_autoloader($class_to_filepath); |
21 | 21 | |
22 | 22 | |
@@ -32,7 +32,7 @@ discard block |
||
32 | 32 | * @since 4.6.0 |
33 | 33 | * |
34 | 34 | */ |
35 | -class EE_DMS_Core_4_6_0 extends EE_Data_Migration_Script_Base{ |
|
35 | +class EE_DMS_Core_4_6_0 extends EE_Data_Migration_Script_Base { |
|
36 | 36 | |
37 | 37 | /** |
38 | 38 | * return EE_DMS_Core_4_6_0 |
@@ -62,14 +62,14 @@ discard block |
||
62 | 62 | */ |
63 | 63 | public function can_migrate_from_version($version_array) { |
64 | 64 | $version_string = $version_array['Core']; |
65 | - if($version_string <= '4.6.0' && $version_string >= '4.5.0' ){ |
|
65 | + if ($version_string <= '4.6.0' && $version_string >= '4.5.0') { |
|
66 | 66 | // echo "$version_string can be migrated from"; |
67 | 67 | return true; |
68 | - }elseif( ! $version_string ){ |
|
68 | + }elseif ( ! $version_string) { |
|
69 | 69 | // echo "no version string provided: $version_string"; |
70 | 70 | //no version string provided... this must be pre 4.3 |
71 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
72 | - }else{ |
|
71 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
72 | + } else { |
|
73 | 73 | // echo "$version_string doesnt apply"; |
74 | 74 | return false; |
75 | 75 | } |
@@ -91,14 +91,14 @@ discard block |
||
91 | 91 | */ |
92 | 92 | public function schema_changes_before_migration() { |
93 | 93 | //relies on 4.1's EEH_Activation::create_table |
94 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
95 | - $table_name='esp_answer'; |
|
96 | - $sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
94 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
95 | + $table_name = 'esp_answer'; |
|
96 | + $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
97 | 97 | REG_ID INT UNSIGNED NOT NULL, |
98 | 98 | QST_ID INT UNSIGNED NOT NULL, |
99 | 99 | ANS_value TEXT NOT NULL, |
100 | 100 | PRIMARY KEY (ANS_ID)"; |
101 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
101 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
102 | 102 | |
103 | 103 | $table_name = 'esp_attendee_meta'; |
104 | 104 | $sql = "ATTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -137,7 +137,7 @@ discard block |
||
137 | 137 | CNT_is_EU TINYINT(1) DEFAULT '0', |
138 | 138 | CNT_active TINYINT(1) DEFAULT '0', |
139 | 139 | PRIMARY KEY (CNT_ISO)"; |
140 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
140 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
141 | 141 | |
142 | 142 | $table_name = 'esp_currency'; |
143 | 143 | $sql = "CUR_code VARCHAR(6) COLLATE utf8_bin NOT NULL, |
@@ -147,7 +147,7 @@ discard block |
||
147 | 147 | CUR_dec_plc VARCHAR(1) COLLATE utf8_bin NOT NULL DEFAULT '2', |
148 | 148 | CUR_active TINYINT(1) DEFAULT '0', |
149 | 149 | PRIMARY KEY (CUR_code)"; |
150 | - $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB' ); |
|
150 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
151 | 151 | |
152 | 152 | |
153 | 153 | $table_name = 'esp_currency_payment_method'; |
@@ -177,7 +177,7 @@ discard block |
||
177 | 177 | |
178 | 178 | |
179 | 179 | |
180 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
180 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
181 | 181 | $table_name = 'esp_event_meta'; |
182 | 182 | $sql = " |
183 | 183 | EVTM_ID INT NOT NULL AUTO_INCREMENT, |
@@ -194,41 +194,41 @@ discard block |
||
194 | 194 | EVT_external_URL VARCHAR(200) NULL, |
195 | 195 | EVT_donations TINYINT(1) NULL, |
196 | 196 | PRIMARY KEY (EVTM_ID)"; |
197 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
197 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
198 | 198 | |
199 | 199 | |
200 | 200 | |
201 | - $table_name='esp_event_question_group'; |
|
202 | - $sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
201 | + $table_name = 'esp_event_question_group'; |
|
202 | + $sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
203 | 203 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
204 | 204 | QSG_ID INT UNSIGNED NOT NULL, |
205 | 205 | EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
206 | 206 | PRIMARY KEY (EQG_ID)"; |
207 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
207 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
208 | 208 | |
209 | 209 | |
210 | 210 | |
211 | - $table_name='esp_event_venue'; |
|
212 | - $sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
211 | + $table_name = 'esp_event_venue'; |
|
212 | + $sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
213 | 213 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
214 | 214 | VNU_ID BIGINT(20) UNSIGNED NOT NULL, |
215 | 215 | EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
216 | 216 | PRIMARY KEY (EVV_ID)"; |
217 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
217 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
218 | 218 | |
219 | 219 | |
220 | 220 | |
221 | - $table_name='esp_extra_meta'; |
|
222 | - $sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
221 | + $table_name = 'esp_extra_meta'; |
|
222 | + $sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
223 | 223 | OBJ_ID INT(11) DEFAULT NULL, |
224 | 224 | EXM_type VARCHAR(45) DEFAULT NULL, |
225 | 225 | EXM_key VARCHAR(45) DEFAULT NULL, |
226 | 226 | EXM_value TEXT, |
227 | 227 | PRIMARY KEY (EXM_ID)"; |
228 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
228 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
229 | 229 | |
230 | - $table_name='esp_line_item'; |
|
231 | - $sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
230 | + $table_name = 'esp_line_item'; |
|
231 | + $sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
232 | 232 | LIN_code VARCHAR(245) NOT NULL DEFAULT '', |
233 | 233 | TXN_ID INT(11) DEFAULT NULL, |
234 | 234 | LIN_name VARCHAR(245) NOT NULL DEFAULT '', |
@@ -244,7 +244,7 @@ discard block |
||
244 | 244 | OBJ_ID INT(11) DEFAULT NULL, |
245 | 245 | OBJ_type VARCHAR(45)DEFAULT NULL, |
246 | 246 | PRIMARY KEY (LIN_ID)"; |
247 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB' ); |
|
247 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
248 | 248 | |
249 | 249 | $table_name = 'esp_log'; |
250 | 250 | $sql = "LOG_ID INT(11) NOT NULL AUTO_INCREMENT, |
@@ -267,7 +267,7 @@ discard block |
||
267 | 267 | KEY GRP_ID (GRP_ID)"; |
268 | 268 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
269 | 269 | |
270 | - EEH_Activation::drop_index( 'esp_message_template_group', 'EVT_ID' ); |
|
270 | + EEH_Activation::drop_index('esp_message_template_group', 'EVT_ID'); |
|
271 | 271 | |
272 | 272 | $table_name = 'esp_message_template_group'; |
273 | 273 | $sql = "GRP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -282,7 +282,7 @@ discard block |
||
282 | 282 | MTP_is_active TINYINT(1) NOT NULL DEFAULT '1', |
283 | 283 | PRIMARY KEY (GRP_ID), |
284 | 284 | KEY MTP_user_id (MTP_user_id)"; |
285 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
285 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
286 | 286 | |
287 | 287 | $table_name = 'esp_event_message_template'; |
288 | 288 | $sql = "EMT_ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -291,7 +291,7 @@ discard block |
||
291 | 291 | PRIMARY KEY (EMT_ID), |
292 | 292 | KEY EVT_ID (EVT_ID), |
293 | 293 | KEY GRP_ID (GRP_ID)"; |
294 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
294 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
295 | 295 | |
296 | 296 | |
297 | 297 | $table_name = 'esp_payment'; |
@@ -359,8 +359,8 @@ discard block |
||
359 | 359 | PRIMARY KEY (TTM_ID)"; |
360 | 360 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
361 | 361 | |
362 | - $table_name='esp_question'; |
|
363 | - $sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
362 | + $table_name = 'esp_question'; |
|
363 | + $sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
364 | 364 | QST_display_text TEXT NOT NULL, |
365 | 365 | QST_admin_label VARCHAR(255) NOT NULL, |
366 | 366 | QST_system VARCHAR(25) DEFAULT NULL, |
@@ -372,27 +372,27 @@ discard block |
||
372 | 372 | QST_wp_user BIGINT UNSIGNED NULL, |
373 | 373 | QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0, |
374 | 374 | PRIMARY KEY (QST_ID)'; |
375 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
375 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
376 | 376 | |
377 | - $table_name='esp_question_group_question'; |
|
378 | - $sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
377 | + $table_name = 'esp_question_group_question'; |
|
378 | + $sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
379 | 379 | QSG_ID INT UNSIGNED NOT NULL, |
380 | 380 | QST_ID INT UNSIGNED NOT NULL, |
381 | 381 | QGQ_order INT UNSIGNED NOT NULL DEFAULT 0, |
382 | 382 | PRIMARY KEY (QGQ_ID) "; |
383 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
383 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
384 | 384 | |
385 | 385 | |
386 | 386 | |
387 | - $table_name='esp_question_option'; |
|
388 | - $sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
387 | + $table_name = 'esp_question_option'; |
|
388 | + $sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
389 | 389 | QSO_value VARCHAR(255) NOT NULL, |
390 | 390 | QSO_desc TEXT NOT NULL, |
391 | 391 | QST_ID INT UNSIGNED NOT NULL, |
392 | 392 | QSO_order INT UNSIGNED NOT NULL DEFAULT 0, |
393 | 393 | QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
394 | 394 | PRIMARY KEY (QSO_ID)"; |
395 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
395 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
396 | 396 | |
397 | 397 | |
398 | 398 | |
@@ -425,8 +425,8 @@ discard block |
||
425 | 425 | |
426 | 426 | |
427 | 427 | |
428 | - $table_name='esp_checkin'; |
|
429 | - $sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
428 | + $table_name = 'esp_checkin'; |
|
429 | + $sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
430 | 430 | REG_ID INT(10) UNSIGNED NOT NULL, |
431 | 431 | DTT_ID INT(10) UNSIGNED NOT NULL, |
432 | 432 | CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, |
@@ -515,7 +515,7 @@ discard block |
||
515 | 515 | PRC_wp_user BIGINT UNSIGNED NULL, |
516 | 516 | PRC_parent INT(10) UNSIGNED DEFAULT 0, |
517 | 517 | PRIMARY KEY (PRC_ID)"; |
518 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
518 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
519 | 519 | |
520 | 520 | $table_name = "esp_price_type"; |
521 | 521 | $sql = "PRT_ID TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -552,12 +552,12 @@ discard block |
||
552 | 552 | TKT_parent INT(10) UNSIGNED DEFAULT '0', |
553 | 553 | TKT_deleted TINYINT(1) NOT NULL DEFAULT '0', |
554 | 554 | PRIMARY KEY (TKT_ID)"; |
555 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
555 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
556 | 556 | |
557 | - EEH_Activation::drop_index( 'esp_question_group', 'QSG_identifier_UNIQUE' ); |
|
557 | + EEH_Activation::drop_index('esp_question_group', 'QSG_identifier_UNIQUE'); |
|
558 | 558 | |
559 | 559 | $table_name = 'esp_question_group'; |
560 | - $sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
560 | + $sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
561 | 561 | QSG_name VARCHAR(255) NOT NULL, |
562 | 562 | QSG_identifier VARCHAR(100) NOT NULL, |
563 | 563 | QSG_desc TEXT NULL, |
@@ -569,7 +569,7 @@ discard block |
||
569 | 569 | QSG_wp_user BIGINT UNSIGNED NULL, |
570 | 570 | PRIMARY KEY (QSG_ID), |
571 | 571 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)'; |
572 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
572 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
573 | 573 | |
574 | 574 | /** @var EE_DMS_Core_4_1_0 $script_4_1_defaults */ |
575 | 575 | $script_4_1_defaults = EE_Registry::instance()->load_dms('Core_4_1_0'); |
@@ -597,15 +597,15 @@ discard block |
||
597 | 597 | return true; |
598 | 598 | } |
599 | 599 | |
600 | - public function migration_page_hooks(){ |
|
600 | + public function migration_page_hooks() { |
|
601 | 601 | |
602 | 602 | } |
603 | 603 | |
604 | - public function add_default_admin_only_payments(){ |
|
604 | + public function add_default_admin_only_payments() { |
|
605 | 605 | global $wpdb; |
606 | 606 | $table_name = $wpdb->prefix."esp_payment_method"; |
607 | 607 | $user_id = EEH_Activation::get_default_creator_id(); |
608 | - if ( EEH_Activation::table_exists( $table_name ) ) { |
|
608 | + if (EEH_Activation::table_exists($table_name)) { |
|
609 | 609 | |
610 | 610 | $SQL = "SELECT COUNT( * ) FROM $table_name"; |
611 | 611 | $existing_payment_methods = $wpdb->get_var($SQL); |
@@ -626,11 +626,11 @@ discard block |
||
626 | 626 | //so admins can record payments for them from the admin page |
627 | 627 | |
628 | 628 | |
629 | - foreach($default_admin_only_payment_methods as $nicename => $description){ |
|
629 | + foreach ($default_admin_only_payment_methods as $nicename => $description) { |
|
630 | 630 | $slug = sanitize_key($nicename); |
631 | 631 | //check that such a payment method exists |
632 | - $exists = $wpdb->get_var($wpdb->prepare("SELECT count(*) FROM $table_name WHERE PMD_slug = %s",$slug)); |
|
633 | - if( ! $exists){ |
|
632 | + $exists = $wpdb->get_var($wpdb->prepare("SELECT count(*) FROM $table_name WHERE PMD_slug = %s", $slug)); |
|
633 | + if ( ! $exists) { |
|
634 | 634 | $values = array( |
635 | 635 | 'PMD_type'=>'Admin_Only', |
636 | 636 | 'PMD_name'=>$nicename, |
@@ -644,17 +644,17 @@ discard block |
||
644 | 644 | $table_name, |
645 | 645 | $values, |
646 | 646 | array( |
647 | - '%s',//PMD_type |
|
648 | - '%s',//PMD_name |
|
649 | - '%s',//PMD_admin_name |
|
650 | - '%s',//PMD_admin_desc |
|
651 | - '%s',//PMD_slug |
|
652 | - '%d',//PMD_wp_user |
|
653 | - '%s',//PMD_scope |
|
647 | + '%s', //PMD_type |
|
648 | + '%s', //PMD_name |
|
649 | + '%s', //PMD_admin_name |
|
650 | + '%s', //PMD_admin_desc |
|
651 | + '%s', //PMD_slug |
|
652 | + '%d', //PMD_wp_user |
|
653 | + '%s', //PMD_scope |
|
654 | 654 | ) |
655 | 655 | ); |
656 | - if( ! $success ){ |
|
657 | - $this->add_error(sprintf(__("Could not insert new admin-only payment method with values %s during migration", "event_espresso"),$this->_json_encode($values))); |
|
656 | + if ( ! $success) { |
|
657 | + $this->add_error(sprintf(__("Could not insert new admin-only payment method with values %s during migration", "event_espresso"), $this->_json_encode($values))); |
|
658 | 658 | } |
659 | 659 | } |
660 | 660 | } |
@@ -672,11 +672,11 @@ discard block |
||
672 | 672 | |
673 | 673 | global $wpdb; |
674 | 674 | $currency_table = $wpdb->prefix."esp_currency"; |
675 | - if ( EEH_Activation::table_exists( $currency_table ) ) { |
|
675 | + if (EEH_Activation::table_exists($currency_table)) { |
|
676 | 676 | |
677 | 677 | $SQL = "SELECT COUNT('CUR_code') FROM $currency_table"; |
678 | 678 | $countries = $wpdb->get_var($SQL); |
679 | - if ( ! $countries ) { |
|
679 | + if ( ! $countries) { |
|
680 | 680 | $SQL = "INSERT INTO $currency_table |
681 | 681 | ( CUR_code, CUR_single, CUR_plural, CUR_sign, CUR_dec_plc, CUR_active) VALUES |
682 | 682 | ( 'EUR', 'Euro', 'Euros', '€', 2,1), |
@@ -8,15 +8,15 @@ discard block |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 | } |
@@ -10,18 +10,18 @@ discard block |
||
10 | 10 | //(all other times it gets resurrected from a wordpress option) |
11 | 11 | $stages = glob(EE_CORE.'data_migration_scripts/4_3_0_stages/*'); |
12 | 12 | $class_to_filepath = array(); |
13 | -if ( ! empty( $stages ) ) { |
|
14 | - foreach($stages as $filepath){ |
|
13 | +if ( ! empty($stages)) { |
|
14 | + foreach ($stages as $filepath) { |
|
15 | 15 | $matches = array(); |
16 | - preg_match('~4_3_0_stages/(.*).dmsstage.php~',$filepath,$matches); |
|
16 | + preg_match('~4_3_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
17 | 17 | $class_to_filepath[$matches[1]] = $filepath; |
18 | 18 | } |
19 | 19 | } |
20 | 20 | //give addons a chance to autoload their stages too |
21 | -$class_to_filepath = apply_filters('FHEE__EE_DMS_4_3_0__autoloaded_stages',$class_to_filepath); |
|
21 | +$class_to_filepath = apply_filters('FHEE__EE_DMS_4_3_0__autoloaded_stages', $class_to_filepath); |
|
22 | 22 | EEH_Autoloader::register_autoloader($class_to_filepath); |
23 | 23 | |
24 | -class EE_DMS_Core_4_3_0 extends EE_Data_Migration_Script_Base{ |
|
24 | +class EE_DMS_Core_4_3_0 extends EE_Data_Migration_Script_Base { |
|
25 | 25 | |
26 | 26 | |
27 | 27 | |
@@ -37,14 +37,14 @@ discard block |
||
37 | 37 | } |
38 | 38 | public function can_migrate_from_version($version_array) { |
39 | 39 | $version_string = $version_array['Core']; |
40 | - if($version_string <= '4.3.0' && $version_string >= '4.2.0' ){ |
|
40 | + if ($version_string <= '4.3.0' && $version_string >= '4.2.0') { |
|
41 | 41 | // echo "$version_string can be migrated fro"; |
42 | 42 | return true; |
43 | - }elseif( ! $version_string ){ |
|
43 | + }elseif ( ! $version_string) { |
|
44 | 44 | // echo "no version string provided: $version_string"; |
45 | 45 | //no version string provided... this must be pre 4.2 |
46 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
47 | - }else{ |
|
46 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
47 | + } else { |
|
48 | 48 | // echo "$version_string doesnt apply"; |
49 | 49 | return false; |
50 | 50 | } |
@@ -54,14 +54,14 @@ discard block |
||
54 | 54 | } |
55 | 55 | public function schema_changes_before_migration() { |
56 | 56 | //relies on 4.1's EEH_Activation::create_table |
57 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
58 | - $table_name='esp_answer'; |
|
59 | - $sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
57 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
58 | + $table_name = 'esp_answer'; |
|
59 | + $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
60 | 60 | REG_ID INT UNSIGNED NOT NULL, |
61 | 61 | QST_ID INT UNSIGNED NOT NULL, |
62 | 62 | ANS_value TEXT NOT NULL, |
63 | 63 | PRIMARY KEY (ANS_ID)"; |
64 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
64 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
65 | 65 | |
66 | 66 | $table_name = 'esp_attendee_meta'; |
67 | 67 | $sql = "ATTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -100,7 +100,7 @@ discard block |
||
100 | 100 | CNT_is_EU TINYINT(1) DEFAULT '0', |
101 | 101 | CNT_active TINYINT(1) DEFAULT '0', |
102 | 102 | PRIMARY KEY (CNT_ISO)"; |
103 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
103 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
104 | 104 | |
105 | 105 | |
106 | 106 | |
@@ -123,7 +123,7 @@ discard block |
||
123 | 123 | |
124 | 124 | |
125 | 125 | |
126 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
126 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
127 | 127 | $table_name = 'esp_event_meta'; |
128 | 128 | $sql = " |
129 | 129 | EVTM_ID INT NOT NULL AUTO_INCREMENT, |
@@ -140,41 +140,41 @@ discard block |
||
140 | 140 | EVT_external_URL VARCHAR(200) NULL, |
141 | 141 | EVT_donations TINYINT(1) NULL, |
142 | 142 | PRIMARY KEY (EVTM_ID)"; |
143 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
143 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
144 | 144 | |
145 | 145 | |
146 | 146 | |
147 | - $table_name='esp_event_question_group'; |
|
148 | - $sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
147 | + $table_name = 'esp_event_question_group'; |
|
148 | + $sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
149 | 149 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
150 | 150 | QSG_ID INT UNSIGNED NOT NULL, |
151 | 151 | EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
152 | 152 | PRIMARY KEY (EQG_ID)"; |
153 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
153 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
154 | 154 | |
155 | 155 | |
156 | 156 | |
157 | - $table_name='esp_event_venue'; |
|
158 | - $sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
157 | + $table_name = 'esp_event_venue'; |
|
158 | + $sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
159 | 159 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
160 | 160 | VNU_ID BIGINT(20) UNSIGNED NOT NULL, |
161 | 161 | EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
162 | 162 | PRIMARY KEY (EVV_ID)"; |
163 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
163 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
164 | 164 | |
165 | 165 | |
166 | 166 | |
167 | - $table_name='esp_extra_meta'; |
|
168 | - $sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
167 | + $table_name = 'esp_extra_meta'; |
|
168 | + $sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
169 | 169 | OBJ_ID INT(11) DEFAULT NULL, |
170 | 170 | EXM_type VARCHAR(45) DEFAULT NULL, |
171 | 171 | EXM_key VARCHAR(45) DEFAULT NULL, |
172 | 172 | EXM_value TEXT, |
173 | 173 | PRIMARY KEY (EXM_ID)"; |
174 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
174 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
175 | 175 | |
176 | - $table_name='esp_line_item'; |
|
177 | - $sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
176 | + $table_name = 'esp_line_item'; |
|
177 | + $sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
178 | 178 | LIN_code VARCHAR(245) NOT NULL DEFAULT '', |
179 | 179 | TXN_ID INT(11) DEFAULT NULL, |
180 | 180 | LIN_name VARCHAR(245) NOT NULL DEFAULT '', |
@@ -190,7 +190,7 @@ discard block |
||
190 | 190 | OBJ_ID INT(11) DEFAULT NULL, |
191 | 191 | OBJ_type VARCHAR(45)DEFAULT NULL, |
192 | 192 | PRIMARY KEY (LIN_ID)"; |
193 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB' ); |
|
193 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
194 | 194 | |
195 | 195 | $table_name = 'esp_message_template'; |
196 | 196 | $sql = "MTP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -202,7 +202,7 @@ discard block |
||
202 | 202 | KEY GRP_ID (GRP_ID)"; |
203 | 203 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
204 | 204 | |
205 | - EEH_Activation::drop_index( 'esp_message_template_group', 'EVT_ID' ); |
|
205 | + EEH_Activation::drop_index('esp_message_template_group', 'EVT_ID'); |
|
206 | 206 | |
207 | 207 | $table_name = 'esp_message_template_group'; |
208 | 208 | $sql = "GRP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -217,7 +217,7 @@ discard block |
||
217 | 217 | MTP_is_active TINYINT(1) NOT NULL DEFAULT '1', |
218 | 218 | PRIMARY KEY (GRP_ID), |
219 | 219 | KEY MTP_user_id (MTP_user_id)"; |
220 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
220 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
221 | 221 | |
222 | 222 | $table_name = 'esp_event_message_template'; |
223 | 223 | $sql = "EMT_ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -226,7 +226,7 @@ discard block |
||
226 | 226 | PRIMARY KEY (EMT_ID), |
227 | 227 | KEY EVT_ID (EVT_ID), |
228 | 228 | KEY GRP_ID (GRP_ID)"; |
229 | - $this->_table_is_new_in_this_version( $table_name, $sql, 'ENGINE=InnoDB'); |
|
229 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
230 | 230 | |
231 | 231 | |
232 | 232 | |
@@ -335,8 +335,8 @@ discard block |
||
335 | 335 | |
336 | 336 | |
337 | 337 | |
338 | - $table_name='esp_question'; |
|
339 | - $sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
338 | + $table_name = 'esp_question'; |
|
339 | + $sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
340 | 340 | QST_display_text TEXT NOT NULL, |
341 | 341 | QST_admin_label VARCHAR(255) NOT NULL, |
342 | 342 | QST_system VARCHAR(25) DEFAULT NULL, |
@@ -348,12 +348,12 @@ discard block |
||
348 | 348 | QST_wp_user BIGINT UNSIGNED NULL, |
349 | 349 | QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0, |
350 | 350 | PRIMARY KEY (QST_ID)'; |
351 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
351 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
352 | 352 | |
353 | - EEH_Activation::drop_index( 'esp_question_group', 'QSG_identifier_UNIQUE' ); |
|
353 | + EEH_Activation::drop_index('esp_question_group', 'QSG_identifier_UNIQUE'); |
|
354 | 354 | |
355 | 355 | $table_name = 'esp_question_group'; |
356 | - $sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
356 | + $sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
357 | 357 | QSG_name VARCHAR(255) NOT NULL, |
358 | 358 | QSG_identifier VARCHAR(100) NOT NULL, |
359 | 359 | QSG_desc TEXT NULL, |
@@ -364,29 +364,29 @@ discard block |
||
364 | 364 | QSG_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
365 | 365 | PRIMARY KEY (QSG_ID), |
366 | 366 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)'; |
367 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
367 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
368 | 368 | |
369 | 369 | |
370 | 370 | |
371 | - $table_name='esp_question_group_question'; |
|
372 | - $sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
371 | + $table_name = 'esp_question_group_question'; |
|
372 | + $sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
373 | 373 | QSG_ID INT UNSIGNED NOT NULL, |
374 | 374 | QST_ID INT UNSIGNED NOT NULL, |
375 | 375 | QGQ_order INT UNSIGNED NOT NULL DEFAULT 0, |
376 | 376 | PRIMARY KEY (QGQ_ID) "; |
377 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
377 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
378 | 378 | |
379 | 379 | |
380 | 380 | |
381 | - $table_name='esp_question_option'; |
|
382 | - $sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
381 | + $table_name = 'esp_question_option'; |
|
382 | + $sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
383 | 383 | QSO_value VARCHAR(255) NOT NULL, |
384 | 384 | QSO_desc TEXT NOT NULL, |
385 | 385 | QST_ID INT UNSIGNED NOT NULL, |
386 | 386 | QSO_order INT UNSIGNED NOT NULL DEFAULT 0, |
387 | 387 | QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
388 | 388 | PRIMARY KEY (QSO_ID)"; |
389 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
389 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
390 | 390 | |
391 | 391 | |
392 | 392 | |
@@ -419,8 +419,8 @@ discard block |
||
419 | 419 | |
420 | 420 | |
421 | 421 | |
422 | - $table_name='esp_checkin'; |
|
423 | - $sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
422 | + $table_name = 'esp_checkin'; |
|
423 | + $sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
424 | 424 | REG_ID INT(10) UNSIGNED NOT NULL, |
425 | 425 | DTT_ID INT(10) UNSIGNED NOT NULL, |
426 | 426 | CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, |
@@ -494,7 +494,7 @@ discard block |
||
494 | 494 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
495 | 495 | |
496 | 496 | |
497 | - $script_with_defaults = EE_Registry::instance()->load_dms( 'Core_4_1_0' ); |
|
497 | + $script_with_defaults = EE_Registry::instance()->load_dms('Core_4_1_0'); |
|
498 | 498 | //setting up the DEFAULT stats and countries is also essential for the data migrations to run |
499 | 499 | //(because many need to convert old string states to foreign keys into the states table) |
500 | 500 | $script_with_defaults->insert_default_states(); |
@@ -516,7 +516,7 @@ discard block |
||
516 | 516 | return true; |
517 | 517 | } |
518 | 518 | |
519 | - public function migration_page_hooks(){ |
|
519 | + public function migration_page_hooks() { |
|
520 | 520 | |
521 | 521 | } |
522 | 522 | |
@@ -532,34 +532,34 @@ discard block |
||
532 | 532 | |
533 | 533 | global $wpdb; |
534 | 534 | $ticket_table = $wpdb->prefix."esp_ticket"; |
535 | - if ( EEH_Activation::table_exists( $ticket_table ) ) { |
|
535 | + if (EEH_Activation::table_exists($ticket_table)) { |
|
536 | 536 | |
537 | - $SQL = 'SELECT COUNT(TKT_ID) FROM ' . $ticket_table; |
|
537 | + $SQL = 'SELECT COUNT(TKT_ID) FROM '.$ticket_table; |
|
538 | 538 | $tickets_exist = $wpdb->get_var($SQL); |
539 | 539 | |
540 | - if ( ! $tickets_exist ) { |
|
540 | + if ( ! $tickets_exist) { |
|
541 | 541 | $SQL = "INSERT INTO $ticket_table |
542 | 542 | ( TKT_ID, TTM_ID, TKT_name, TKT_description, TKT_qty, TKT_sold, TKT_uses, TKT_required, TKT_min, TKT_max, TKT_price, TKT_start_date, TKT_end_date, TKT_taxable, TKT_order, TKT_row, TKT_is_default, TKT_parent, TKT_deleted ) VALUES |
543 | - ( 1, 0, '" . __("Free Ticket", "event_espresso") . "', '', 100, 0, -1, 0, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, 0);"; |
|
544 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL', $SQL ); |
|
543 | + ( 1, 0, '".__("Free Ticket", "event_espresso")."', '', 100, 0, -1, 0, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, 0);"; |
|
544 | + $SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL', $SQL); |
|
545 | 545 | $wpdb->query($SQL); |
546 | 546 | } |
547 | 547 | } |
548 | 548 | $ticket_price_table = $wpdb->prefix."esp_ticket_price"; |
549 | 549 | |
550 | - if ( EEH_Activation::table_exists( $ticket_price_table ) ) { |
|
550 | + if (EEH_Activation::table_exists($ticket_price_table)) { |
|
551 | 551 | |
552 | - $SQL = 'SELECT COUNT(TKP_ID) FROM ' . $ticket_price_table; |
|
552 | + $SQL = 'SELECT COUNT(TKP_ID) FROM '.$ticket_price_table; |
|
553 | 553 | $ticket_prc_exist = $wpdb->get_var($SQL); |
554 | 554 | |
555 | - if ( ! $ticket_prc_exist ) { |
|
555 | + if ( ! $ticket_prc_exist) { |
|
556 | 556 | |
557 | 557 | $SQL = "INSERT INTO $ticket_price_table |
558 | 558 | ( TKP_ID, TKT_ID, PRC_ID ) VALUES |
559 | 559 | ( 1, 1, 1 ) |
560 | 560 | "; |
561 | 561 | |
562 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL__ticket_price', $SQL ); |
|
562 | + $SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL__ticket_price', $SQL); |
|
563 | 563 | $wpdb->query($SQL); |
564 | 564 | } |
565 | 565 | } |
@@ -1,5 +1,5 @@ discard block |
||
1 | 1 | <?php |
2 | -if (!defined('EVENT_ESPRESSO_VERSION')) |
|
2 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) |
|
3 | 3 | exit('No direct script access allowed'); |
4 | 4 | |
5 | 5 | |
@@ -32,13 +32,13 @@ discard block |
||
32 | 32 | * |
33 | 33 | * @return bool |
34 | 34 | */ |
35 | - public function add( $message, $info = null ) { |
|
36 | - $attached = parent::add( $message ); |
|
35 | + public function add($message, $info = null) { |
|
36 | + $attached = parent::add($message); |
|
37 | 37 | //ensure $info is an array if not already |
38 | 38 | $info = $info === null ? $info = array() : (array) $info; |
39 | - $data = $this->_init_data( $info, $attached, $message ); |
|
40 | - if ( $attached ) { |
|
41 | - $this->set_info( $message, $data ); |
|
39 | + $data = $this->_init_data($info, $attached, $message); |
|
40 | + if ($attached) { |
|
41 | + $this->set_info($message, $data); |
|
42 | 42 | } |
43 | 43 | return $attached; |
44 | 44 | } |
@@ -51,7 +51,7 @@ discard block |
||
51 | 51 | * @param EE_Message $message |
52 | 52 | * @return array |
53 | 53 | */ |
54 | - protected function _init_data( $info, $attached, $message ) { |
|
54 | + protected function _init_data($info, $attached, $message) { |
|
55 | 55 | $data = array( |
56 | 56 | 'test_send' => false, |
57 | 57 | 'preview' => false, |
@@ -60,20 +60,20 @@ discard block |
||
60 | 60 | 'MSG_generation_data' => array() |
61 | 61 | ) |
62 | 62 | ); |
63 | - if ( isset( $info['preview'] ) ) { |
|
63 | + if (isset($info['preview'])) { |
|
64 | 64 | $data['preview'] = $info['preview']; |
65 | - unset( $info['preview'] ); |
|
65 | + unset($info['preview']); |
|
66 | 66 | } |
67 | - if ( isset( $info['test_send'] ) ) { |
|
67 | + if (isset($info['test_send'])) { |
|
68 | 68 | $data['test_send'] = $info['test_send']; |
69 | - unset( $info['test_send'] ); |
|
69 | + unset($info['test_send']); |
|
70 | 70 | } |
71 | - if ( isset( $info['data_handler_class_name'] ) ) { |
|
71 | + if (isset($info['data_handler_class_name'])) { |
|
72 | 72 | $data['data_handler_class_name'] = $info['data_handler_class_name']; |
73 | - unset( $info['data_handler_class_name'] ); |
|
73 | + unset($info['data_handler_class_name']); |
|
74 | 74 | } |
75 | - if ( $attached && $message->STS_ID() === EEM_Message::status_incomplete ) { |
|
76 | - $generation_data = isset( $info['MSG_generation_data'] ) ? $info['MSG_generation_data'] : array(); |
|
75 | + if ($attached && $message->STS_ID() === EEM_Message::status_incomplete) { |
|
76 | + $generation_data = isset($info['MSG_generation_data']) ? $info['MSG_generation_data'] : array(); |
|
77 | 77 | //if data isn't in $info...let's see if its available via the message object |
78 | 78 | $generation_data = ! $generation_data ? $message->get_generation_data() : $generation_data; |
79 | 79 | //still empty then let's just use info |
@@ -96,19 +96,19 @@ discard block |
||
96 | 96 | */ |
97 | 97 | public function saveAll() { |
98 | 98 | $this->rewind(); |
99 | - $save_tracking = array( 'updated' => 0, 'notupdated' => 0, 'errors' => array() ); |
|
99 | + $save_tracking = array('updated' => 0, 'notupdated' => 0, 'errors' => array()); |
|
100 | 100 | |
101 | 101 | //exit early if there is nothing to save. |
102 | - if ( ! $this->count() > 0 ) { |
|
102 | + if ( ! $this->count() > 0) { |
|
103 | 103 | return $save_tracking; |
104 | 104 | } |
105 | 105 | |
106 | - while( $this->valid() ) { |
|
106 | + while ($this->valid()) { |
|
107 | 107 | |
108 | 108 | $saved = $this->current()->save(); |
109 | - if ( $saved === false ) { |
|
109 | + if ($saved === false) { |
|
110 | 110 | $save_tracking['errors'][] = $this->current()->MSG_token(); |
111 | - } elseif ( $saved ) { |
|
111 | + } elseif ($saved) { |
|
112 | 112 | $save_tracking['updated']++; |
113 | 113 | } else { |
114 | 114 | $save_tracking['notupdated']++; |
@@ -118,7 +118,7 @@ discard block |
||
118 | 118 | |
119 | 119 | $this->next(); |
120 | 120 | } |
121 | - do_action( 'AHEE__EE_Message_Repository__saveAll__after', $save_tracking, $this ); |
|
121 | + do_action('AHEE__EE_Message_Repository__saveAll__after', $save_tracking, $this); |
|
122 | 122 | return $save_tracking; |
123 | 123 | } |
124 | 124 | |
@@ -133,10 +133,10 @@ discard block |
||
133 | 133 | * @param string $token Token. |
134 | 134 | * @return EE_Message | null |
135 | 135 | */ |
136 | - public function getMessageByToken( $token ) { |
|
136 | + public function getMessageByToken($token) { |
|
137 | 137 | $this->rewind(); |
138 | - while( $this->valid() ) { |
|
139 | - if ( $this->current()->MSG_token() === $token ) { |
|
138 | + while ($this->valid()) { |
|
139 | + if ($this->current()->MSG_token() === $token) { |
|
140 | 140 | $message = $this->current(); |
141 | 141 | $this->rewind(); |
142 | 142 | return $message; |
@@ -157,11 +157,11 @@ discard block |
||
157 | 157 | */ |
158 | 158 | public function get_generation_data() { |
159 | 159 | //first verify we're at a valid iterator point. |
160 | - if ( ! $this->valid() ) { |
|
160 | + if ( ! $this->valid()) { |
|
161 | 161 | return array(); |
162 | 162 | } |
163 | 163 | $info = $this->getInfo(); |
164 | - return isset( $info['data'] ) && isset( $info['data']['MSG_generation_data'] ) ? $info['data']['MSG_generation_data'] : array(); |
|
164 | + return isset($info['data']) && isset($info['data']['MSG_generation_data']) ? $info['data']['MSG_generation_data'] : array(); |
|
165 | 165 | } |
166 | 166 | |
167 | 167 | |
@@ -172,11 +172,11 @@ discard block |
||
172 | 172 | * @return string |
173 | 173 | */ |
174 | 174 | public function get_data_handler() { |
175 | - if ( ! $this->valid() ) { |
|
175 | + if ( ! $this->valid()) { |
|
176 | 176 | return ''; |
177 | 177 | } |
178 | 178 | $info = $this->getInfo(); |
179 | - return isset( $info['data_handler_class_name'] ) ? $info['data_handler_class_name'] : ''; |
|
179 | + return isset($info['data_handler_class_name']) ? $info['data_handler_class_name'] : ''; |
|
180 | 180 | } |
181 | 181 | |
182 | 182 | |
@@ -186,7 +186,7 @@ discard block |
||
186 | 186 | * @return bool |
187 | 187 | */ |
188 | 188 | public function is_preview() { |
189 | - if ( ! $this->valid() ) { |
|
189 | + if ( ! $this->valid()) { |
|
190 | 190 | return false; |
191 | 191 | } |
192 | 192 | $info = $this->getInfo(); |
@@ -199,7 +199,7 @@ discard block |
||
199 | 199 | * @return bool |
200 | 200 | */ |
201 | 201 | public function is_test_send() { |
202 | - if ( ! $this->valid() ) { |
|
202 | + if ( ! $this->valid()) { |
|
203 | 203 | return false; |
204 | 204 | } |
205 | 205 | $info = $this->getInfo(); |
@@ -214,16 +214,16 @@ discard block |
||
214 | 214 | * data is attached for later retrieval (batch generation). |
215 | 215 | */ |
216 | 216 | protected function _maybe_persist_attached_data() { |
217 | - if ( ! $this->valid() ) { |
|
217 | + if ( ! $this->valid()) { |
|
218 | 218 | return; |
219 | 219 | } |
220 | 220 | |
221 | 221 | $info = $this->getInfo(); |
222 | - $data_handler_class_name = isset( $info['data_handler_class_name'] ) ? $info['data_handler_class_name'] : ''; |
|
223 | - $data = isset( $info['data'] ) && isset( $info['data']['MSG_generation_data'] ) ? $info['data']['MSG_generation_data'] : array(); |
|
224 | - if ( $data && $this->current()->STS_ID() === EEM_Message::status_incomplete ) { |
|
225 | - $this->current()->set_generation_data( $data ); |
|
226 | - $this->current()->set_field_or_extra_meta( 'data_handler_class_name', $data_handler_class_name ); |
|
222 | + $data_handler_class_name = isset($info['data_handler_class_name']) ? $info['data_handler_class_name'] : ''; |
|
223 | + $data = isset($info['data']) && isset($info['data']['MSG_generation_data']) ? $info['data']['MSG_generation_data'] : array(); |
|
224 | + if ($data && $this->current()->STS_ID() === EEM_Message::status_incomplete) { |
|
225 | + $this->current()->set_generation_data($data); |
|
226 | + $this->current()->set_field_or_extra_meta('data_handler_class_name', $data_handler_class_name); |
|
227 | 227 | } |
228 | 228 | } |
229 | 229 | |
@@ -236,15 +236,15 @@ discard block |
||
236 | 236 | * @param array $status the optional status(es) that will also be filtered by when priority matches. |
237 | 237 | * @return int count of messages in the queue matching the conditions. |
238 | 238 | */ |
239 | - public function count_by_priority_and_status( $priority, $status = array() ) { |
|
240 | - if ( ! empty( $status ) ) { |
|
241 | - $status = is_array( $status ) ? $status : array( $status ); |
|
239 | + public function count_by_priority_and_status($priority, $status = array()) { |
|
240 | + if ( ! empty($status)) { |
|
241 | + $status = is_array($status) ? $status : array($status); |
|
242 | 242 | } |
243 | 243 | |
244 | 244 | $count = 0; |
245 | 245 | $this->rewind(); |
246 | - while ( $this->valid() ) { |
|
247 | - if ( $this->current()->priority() === $priority && ( ( $status && in_array( $this->current()->STS_ID(), $status ) ) || ! $status ) ) { |
|
246 | + while ($this->valid()) { |
|
247 | + if ($this->current()->priority() === $priority && (($status && in_array($this->current()->STS_ID(), $status)) || ! $status)) { |
|
248 | 248 | $count++; |
249 | 249 | } |
250 | 250 | $this->next(); |
@@ -1,5 +1,5 @@ discard block |
||
1 | -<?php if ( ! defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
2 | - exit( 'No direct script access allowed' ); |
|
1 | +<?php if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
2 | + exit('No direct script access allowed'); |
|
3 | 3 | } |
4 | 4 | /** |
5 | 5 | * |
@@ -37,33 +37,33 @@ discard block |
||
37 | 37 | * @access protected |
38 | 38 | * @return EEM_Payment_Method |
39 | 39 | */ |
40 | - protected function __construct( $timezone = NULL ) { |
|
41 | - $this->singlular_item = __( 'Payment Method', 'event_espresso' ); |
|
42 | - $this->plural_item = __( 'Payment Methods', 'event_espresso' ); |
|
43 | - $this->_tables = array( 'Payment_Method' => new EE_Primary_Table( 'esp_payment_method', 'PMD_ID' ) ); |
|
40 | + protected function __construct($timezone = NULL) { |
|
41 | + $this->singlular_item = __('Payment Method', 'event_espresso'); |
|
42 | + $this->plural_item = __('Payment Methods', 'event_espresso'); |
|
43 | + $this->_tables = array('Payment_Method' => new EE_Primary_Table('esp_payment_method', 'PMD_ID')); |
|
44 | 44 | $this->_fields = array( |
45 | 45 | 'Payment_Method' => array( |
46 | - 'PMD_ID' => new EE_Primary_Key_Int_Field( 'PMD_ID', __( "ID", 'event_espresso' ) ), |
|
47 | - 'PMD_type' => new EE_Plain_Text_Field( 'PMD_type', __( "Payment Method Type", 'event_espresso' ), FALSE, 'Admin_Only' ), |
|
48 | - 'PMD_name' => new EE_Plain_Text_Field( 'PMD_name', __( "Name", 'event_espresso' ), FALSE ), |
|
49 | - 'PMD_desc' => new EE_Post_Content_Field( 'PMD_desc', __( "Description", 'event_espresso' ), FALSE, '' ), |
|
50 | - 'PMD_admin_name' => new EE_Plain_Text_Field( 'PMD_admin_name', __( "Admin-Only Name", 'event_espresso' ), TRUE ), |
|
51 | - 'PMD_admin_desc' => new EE_Post_Content_Field( 'PMD_admin_desc', __( "Admin-Only Description", 'event_espresso' ), TRUE ), |
|
52 | - 'PMD_slug' => new EE_Slug_Field( 'PMD_slug', __( "Slug", 'event_espresso' ), FALSE ), |
|
53 | - 'PMD_order' => new EE_Integer_Field( 'PMD_order', __( "Order", 'event_espresso' ), FALSE, 0 ), |
|
54 | - 'PMD_debug_mode' => new EE_Boolean_Field( 'PMD_debug_mode', __( "Debug Mode On?", 'event_espresso' ), FALSE, FALSE ), |
|
55 | - 'PMD_wp_user' => new EE_WP_User_Field( 'PMD_wp_user', __( "Payment Method Creator ID", 'event_espresso' ), FALSE ), |
|
56 | - 'PMD_open_by_default' => new EE_Boolean_Field( 'PMD_open_by_default', __( "Open by Default?", 'event_espresso' ), FALSE, FALSE ), 'PMD_button_url' => new EE_Plain_Text_Field( 'PMD_button_url', __( "Button URL", 'event_espresso' ), TRUE, '' ), |
|
57 | - 'PMD_scope' => new EE_Serialized_Text_Field( 'PMD_scope', __( "Usable From?", 'event_espresso' ), FALSE, array() ), //possible values currently are 'CART','ADMIN','API' |
|
46 | + 'PMD_ID' => new EE_Primary_Key_Int_Field('PMD_ID', __("ID", 'event_espresso')), |
|
47 | + 'PMD_type' => new EE_Plain_Text_Field('PMD_type', __("Payment Method Type", 'event_espresso'), FALSE, 'Admin_Only'), |
|
48 | + 'PMD_name' => new EE_Plain_Text_Field('PMD_name', __("Name", 'event_espresso'), FALSE), |
|
49 | + 'PMD_desc' => new EE_Post_Content_Field('PMD_desc', __("Description", 'event_espresso'), FALSE, ''), |
|
50 | + 'PMD_admin_name' => new EE_Plain_Text_Field('PMD_admin_name', __("Admin-Only Name", 'event_espresso'), TRUE), |
|
51 | + 'PMD_admin_desc' => new EE_Post_Content_Field('PMD_admin_desc', __("Admin-Only Description", 'event_espresso'), TRUE), |
|
52 | + 'PMD_slug' => new EE_Slug_Field('PMD_slug', __("Slug", 'event_espresso'), FALSE), |
|
53 | + 'PMD_order' => new EE_Integer_Field('PMD_order', __("Order", 'event_espresso'), FALSE, 0), |
|
54 | + 'PMD_debug_mode' => new EE_Boolean_Field('PMD_debug_mode', __("Debug Mode On?", 'event_espresso'), FALSE, FALSE), |
|
55 | + 'PMD_wp_user' => new EE_WP_User_Field('PMD_wp_user', __("Payment Method Creator ID", 'event_espresso'), FALSE), |
|
56 | + 'PMD_open_by_default' => new EE_Boolean_Field('PMD_open_by_default', __("Open by Default?", 'event_espresso'), FALSE, FALSE), 'PMD_button_url' => new EE_Plain_Text_Field('PMD_button_url', __("Button URL", 'event_espresso'), TRUE, ''), |
|
57 | + 'PMD_scope' => new EE_Serialized_Text_Field('PMD_scope', __("Usable From?", 'event_espresso'), FALSE, array()), //possible values currently are 'CART','ADMIN','API' |
|
58 | 58 | ) ); |
59 | 59 | $this->_model_relations = array( |
60 | 60 | // 'Event'=>new EE_HABTM_Relation('Event_Payment_Method'), |
61 | 61 | 'Payment' => new EE_Has_Many_Relation(), |
62 | - 'Currency' => new EE_HABTM_Relation( 'Currency_Payment_Method' ), |
|
62 | + 'Currency' => new EE_HABTM_Relation('Currency_Payment_Method'), |
|
63 | 63 | 'Transaction' => new EE_Has_Many_Relation(), |
64 | 64 | 'WP_User' => new EE_Belongs_To_Relation(), |
65 | 65 | ); |
66 | - parent::__construct( $timezone ); |
|
66 | + parent::__construct($timezone); |
|
67 | 67 | } |
68 | 68 | |
69 | 69 | |
@@ -73,8 +73,8 @@ discard block |
||
73 | 73 | * @param string $slug |
74 | 74 | * @return EE_Payment_Method |
75 | 75 | */ |
76 | - public function get_one_by_slug( $slug ) { |
|
77 | - return $this->get_one( array( array( 'PMD_slug' => $slug ) ) ); |
|
76 | + public function get_one_by_slug($slug) { |
|
77 | + return $this->get_one(array(array('PMD_slug' => $slug))); |
|
78 | 78 | } |
79 | 79 | |
80 | 80 | |
@@ -88,8 +88,8 @@ discard block |
||
88 | 88 | return apply_filters( |
89 | 89 | 'FHEE__EEM_Payment_Method__scopes', |
90 | 90 | array( |
91 | - self::scope_cart => __( "Front-end Registration Page", 'event_espresso' ), |
|
92 | - self::scope_admin => __( "Admin Registration Page (no online processing)", 'event_espresso' ) |
|
91 | + self::scope_cart => __("Front-end Registration Page", 'event_espresso'), |
|
92 | + self::scope_admin => __("Admin Registration Page (no online processing)", 'event_espresso') |
|
93 | 93 | ) |
94 | 94 | ); |
95 | 95 | } |
@@ -101,9 +101,9 @@ discard block |
||
101 | 101 | * @param string $scope like one of EEM_Payment_Method::instance()->scopes() |
102 | 102 | * @return boolean |
103 | 103 | */ |
104 | - public function is_valid_scope( $scope ) { |
|
104 | + public function is_valid_scope($scope) { |
|
105 | 105 | $scopes = $this->scopes(); |
106 | - if ( isset( $scopes[ $scope ] ) ) { |
|
106 | + if (isset($scopes[$scope])) { |
|
107 | 107 | return TRUE; |
108 | 108 | } else { |
109 | 109 | return FALSE; |
@@ -119,11 +119,11 @@ discard block |
||
119 | 119 | * @throws EE_Error |
120 | 120 | * @return EE_Payment_Method[] |
121 | 121 | */ |
122 | - public function get_all_active( $scope = NULL, $query_params = array() ) { |
|
123 | - if( ! isset( $query_params[ 'order_by' ] ) && ! isset( $query_params[ 'order' ] ) ) { |
|
124 | - $query_params = array( 'order_by' => array( 'PMD_order' => 'ASC', 'PMD_ID' => 'ASC' ) ); |
|
122 | + public function get_all_active($scope = NULL, $query_params = array()) { |
|
123 | + if ( ! isset($query_params['order_by']) && ! isset($query_params['order'])) { |
|
124 | + $query_params = array('order_by' => array('PMD_order' => 'ASC', 'PMD_ID' => 'ASC')); |
|
125 | 125 | } |
126 | - return $this->get_all( $this->_get_query_params_for_all_active( $scope, $query_params ) ); |
|
126 | + return $this->get_all($this->_get_query_params_for_all_active($scope, $query_params)); |
|
127 | 127 | } |
128 | 128 | |
129 | 129 | /** |
@@ -132,8 +132,8 @@ discard block |
||
132 | 132 | * @param array $query_params |
133 | 133 | * @return int |
134 | 134 | */ |
135 | - public function count_active( $scope = NULL, $query_params = array() ){ |
|
136 | - return $this->count( $this->_get_query_params_for_all_active( $scope, $query_params ) ); |
|
135 | + public function count_active($scope = NULL, $query_params = array()) { |
|
136 | + return $this->count($this->_get_query_params_for_all_active($scope, $query_params)); |
|
137 | 137 | } |
138 | 138 | |
139 | 139 | /** |
@@ -144,21 +144,21 @@ discard block |
||
144 | 144 | * @return array like param of EEM_Base::get_all() |
145 | 145 | * @throws EE_Error |
146 | 146 | */ |
147 | - protected function _get_query_params_for_all_active( $scope = NULL, $query_params = array() ){ |
|
148 | - if ( $scope ) { |
|
149 | - if ( $this->is_valid_scope( $scope ) ) { |
|
150 | - return array_replace_recursive( array( array( 'PMD_scope' => array( 'LIKE', "%$scope%" ) ) ), $query_params ); |
|
147 | + protected function _get_query_params_for_all_active($scope = NULL, $query_params = array()) { |
|
148 | + if ($scope) { |
|
149 | + if ($this->is_valid_scope($scope)) { |
|
150 | + return array_replace_recursive(array(array('PMD_scope' => array('LIKE', "%$scope%"))), $query_params); |
|
151 | 151 | } else { |
152 | - throw new EE_Error( sprintf( __( "'%s' is not a valid scope for a payment method", "event_espresso" ), $scope ) ); |
|
152 | + throw new EE_Error(sprintf(__("'%s' is not a valid scope for a payment method", "event_espresso"), $scope)); |
|
153 | 153 | } |
154 | 154 | } else { |
155 | 155 | $acceptable_scopes = array(); |
156 | 156 | $count = 0; |
157 | - foreach ( $this->scopes() as $scope_name => $desc ) { |
|
157 | + foreach ($this->scopes() as $scope_name => $desc) { |
|
158 | 158 | $count++; |
159 | - $acceptable_scopes[ 'PMD_scope*' . $count ] = array( 'LIKE', '%' . $scope_name . '%' ); |
|
159 | + $acceptable_scopes['PMD_scope*'.$count] = array('LIKE', '%'.$scope_name.'%'); |
|
160 | 160 | } |
161 | - return array_replace_recursive( array( array( 'OR*active_scope' => $acceptable_scopes ) ), $query_params ); |
|
161 | + return array_replace_recursive(array(array('OR*active_scope' => $acceptable_scopes)), $query_params); |
|
162 | 162 | } |
163 | 163 | } |
164 | 164 | |
@@ -170,8 +170,8 @@ discard block |
||
170 | 170 | * @return array like param of EEM_Base::get_all() |
171 | 171 | * @throws EE_Error |
172 | 172 | */ |
173 | - public function get_query_params_for_all_active( $scope = NULL, $query_params = array() ) { |
|
174 | - return $this->_get_query_params_for_all_active( $scope, $query_params ); |
|
173 | + public function get_query_params_for_all_active($scope = NULL, $query_params = array()) { |
|
174 | + return $this->_get_query_params_for_all_active($scope, $query_params); |
|
175 | 175 | } |
176 | 176 | |
177 | 177 | |
@@ -181,8 +181,8 @@ discard block |
||
181 | 181 | * @param array $query_params |
182 | 182 | * @return EE_Payment_Method |
183 | 183 | */ |
184 | - public function get_one_active( $scope = NULL, $query_params = array() ) { |
|
185 | - return $this->get_one( $this->_get_query_params_for_all_active( $scope, $query_params ) ); |
|
184 | + public function get_one_active($scope = NULL, $query_params = array()) { |
|
185 | + return $this->get_one($this->_get_query_params_for_all_active($scope, $query_params)); |
|
186 | 186 | } |
187 | 187 | |
188 | 188 | |
@@ -192,8 +192,8 @@ discard block |
||
192 | 192 | * @param string $type |
193 | 193 | * @return EE_Payment_Method |
194 | 194 | */ |
195 | - public function get_one_of_type( $type ) { |
|
196 | - return $this->get_one( array( array( 'PMD_type' => $type ) ) ); |
|
195 | + public function get_one_of_type($type) { |
|
196 | + return $this->get_one(array(array('PMD_type' => $type))); |
|
197 | 197 | } |
198 | 198 | |
199 | 199 | |
@@ -206,22 +206,22 @@ discard block |
||
206 | 206 | * @return EE_Payment_Method |
207 | 207 | * @throws EE_Error |
208 | 208 | */ |
209 | - public function ensure_is_obj( $base_class_obj_or_id, $ensure_is_in_db = FALSE ) { |
|
209 | + public function ensure_is_obj($base_class_obj_or_id, $ensure_is_in_db = FALSE) { |
|
210 | 210 | //first: check if it's a slug |
211 | - if( is_string( $base_class_obj_or_id ) ) { |
|
212 | - $obj = $this->get_one_by_slug( $base_class_obj_or_id ); |
|
213 | - if( $obj ) { |
|
211 | + if (is_string($base_class_obj_or_id)) { |
|
212 | + $obj = $this->get_one_by_slug($base_class_obj_or_id); |
|
213 | + if ($obj) { |
|
214 | 214 | return $obj; |
215 | 215 | } |
216 | 216 | } |
217 | 217 | //ok so it wasn't a slug we were passed. try the usual then (ie, it's an object or an ID) |
218 | 218 | try { |
219 | - return parent::ensure_is_obj( $base_class_obj_or_id, $ensure_is_in_db ); |
|
219 | + return parent::ensure_is_obj($base_class_obj_or_id, $ensure_is_in_db); |
|
220 | 220 | } |
221 | - catch ( EE_Error $e ) { |
|
221 | + catch (EE_Error $e) { |
|
222 | 222 | //handle it outside the catch |
223 | 223 | } |
224 | - throw new EE_Error( sprintf( __( "'%s' is neither a Payment Method ID, slug, nor object.", "event_espresso" ), $base_class_obj_or_id ) ); |
|
224 | + throw new EE_Error(sprintf(__("'%s' is neither a Payment Method ID, slug, nor object.", "event_espresso"), $base_class_obj_or_id)); |
|
225 | 225 | } |
226 | 226 | |
227 | 227 | |
@@ -232,12 +232,12 @@ discard block |
||
232 | 232 | * @param mixed $base_obj_or_id_or_slug |
233 | 233 | * @return int |
234 | 234 | */ |
235 | - function ensure_is_ID( $base_obj_or_id_or_slug ) { |
|
236 | - if ( is_string( $base_obj_or_id_or_slug ) ) { |
|
235 | + function ensure_is_ID($base_obj_or_id_or_slug) { |
|
236 | + if (is_string($base_obj_or_id_or_slug)) { |
|
237 | 237 | //assume it's a slug |
238 | - $base_obj_or_id_or_slug = $this->get_one_by_slug( $base_obj_or_id_or_slug ); |
|
238 | + $base_obj_or_id_or_slug = $this->get_one_by_slug($base_obj_or_id_or_slug); |
|
239 | 239 | } |
240 | - return parent::ensure_is_ID( $base_obj_or_id_or_slug ); |
|
240 | + return parent::ensure_is_ID($base_obj_or_id_or_slug); |
|
241 | 241 | } |
242 | 242 | |
243 | 243 | |
@@ -246,36 +246,36 @@ discard block |
||
246 | 246 | * Verifies the button urls on all the passed payment methods have a valid button url. If not, resets them to their default. |
247 | 247 | * @param EE_Payment_Method[] $payment_methods. If NULL is provided defaults to all payment methods active in the cart |
248 | 248 | */ |
249 | - function verify_button_urls( $payment_methods = NULL ) { |
|
250 | - $payment_methods = is_array( $payment_methods ) ? $payment_methods : $this->get_all_active(EEM_Payment_Method::scope_cart); |
|
251 | - foreach ( $payment_methods as $payment_method ) { |
|
249 | + function verify_button_urls($payment_methods = NULL) { |
|
250 | + $payment_methods = is_array($payment_methods) ? $payment_methods : $this->get_all_active(EEM_Payment_Method::scope_cart); |
|
251 | + foreach ($payment_methods as $payment_method) { |
|
252 | 252 | try { |
253 | 253 | $current_button_url = $payment_method->button_url(); |
254 | - $buttons_urls_to_try = apply_filters( 'FHEE__EEM_Payment_Method__verify_button_urls__button_urls_to_try', array( |
|
255 | - 'current_ssl' => str_replace( "http://", "https://", $current_button_url ), |
|
256 | - 'current' => str_replace( "https://", "http://", $current_button_url ), |
|
257 | - 'default_ssl' => str_replace( "http://", "https://", $payment_method->type_obj()->default_button_url() ), |
|
258 | - 'default' => str_replace( "https://", "http://", $payment_method->type_obj()->default_button_url() ), |
|
259 | - ) ); |
|
260 | - foreach( $buttons_urls_to_try as $button_url_to_try ) { |
|
261 | - if( |
|
254 | + $buttons_urls_to_try = apply_filters('FHEE__EEM_Payment_Method__verify_button_urls__button_urls_to_try', array( |
|
255 | + 'current_ssl' => str_replace("http://", "https://", $current_button_url), |
|
256 | + 'current' => str_replace("https://", "http://", $current_button_url), |
|
257 | + 'default_ssl' => str_replace("http://", "https://", $payment_method->type_obj()->default_button_url()), |
|
258 | + 'default' => str_replace("https://", "http://", $payment_method->type_obj()->default_button_url()), |
|
259 | + )); |
|
260 | + foreach ($buttons_urls_to_try as $button_url_to_try) { |
|
261 | + if ( |
|
262 | 262 | (//this is the current url and it exists, regardless of SSL issues |
263 | 263 | $button_url_to_try == $current_button_url && |
264 | 264 | EEH_URL::remote_file_exists( |
265 | 265 | $button_url_to_try, |
266 | 266 | array( |
267 | 267 | 'sslverify' => false, |
268 | - 'limit_response_size' => 4095,//we don't really care for a full response, but we do want headers at least. Lets just ask for a one block |
|
268 | + 'limit_response_size' => 4095, //we don't really care for a full response, but we do want headers at least. Lets just ask for a one block |
|
269 | 269 | ) ) |
270 | 270 | ) |
271 | 271 | || |
272 | 272 | (//this is NOT the current url and it exists with a working SSL cert |
273 | 273 | $button_url_to_try != $current_button_url && |
274 | - EEH_URL::remote_file_exists( $button_url_to_try ) |
|
274 | + EEH_URL::remote_file_exists($button_url_to_try) |
|
275 | 275 | ) ) { |
276 | - if( $current_button_url != $button_url_to_try ){ |
|
277 | - $payment_method->save( array( 'PMD_button_url' => $button_url_to_try ) ); |
|
278 | - EE_Error::add_attention( sprintf( __( "Payment Method %s's button url was set to %s, because the old image either didnt exist or SSL was recently enabled.", "event_espresso" ), $payment_method->name(), $button_url_to_try ) ); |
|
276 | + if ($current_button_url != $button_url_to_try) { |
|
277 | + $payment_method->save(array('PMD_button_url' => $button_url_to_try)); |
|
278 | + EE_Error::add_attention(sprintf(__("Payment Method %s's button url was set to %s, because the old image either didnt exist or SSL was recently enabled.", "event_espresso"), $payment_method->name(), $button_url_to_try)); |
|
279 | 279 | } |
280 | 280 | //this image exists. So if wasn't set before, now it is; |
281 | 281 | //or if it was already set, we have nothing to do |
@@ -283,8 +283,8 @@ discard block |
||
283 | 283 | } |
284 | 284 | } |
285 | 285 | } |
286 | - catch ( EE_Error $e ) { |
|
287 | - $payment_method->set_active( FALSE ); |
|
286 | + catch (EE_Error $e) { |
|
287 | + $payment_method->set_active(FALSE); |
|
288 | 288 | } |
289 | 289 | } |
290 | 290 | } |
@@ -298,29 +298,29 @@ discard block |
||
298 | 298 | * @param array $rows |
299 | 299 | * @return EE_Payment_Method[] |
300 | 300 | */ |
301 | - protected function _create_objects( $rows = array() ) { |
|
302 | - EE_Registry::instance()->load_lib( 'Payment_Method_Manager' ); |
|
303 | - $payment_methods = parent::_create_objects( $rows ); |
|
301 | + protected function _create_objects($rows = array()) { |
|
302 | + EE_Registry::instance()->load_lib('Payment_Method_Manager'); |
|
303 | + $payment_methods = parent::_create_objects($rows); |
|
304 | 304 | /* @var $payment_methods EE_Payment_Method[] */ |
305 | 305 | $usable_payment_methods = array(); |
306 | - foreach ( $payment_methods as $key => $payment_method ) { |
|
307 | - if ( EE_Payment_Method_Manager::instance()->payment_method_type_exists( $payment_method->type() ) ) { |
|
308 | - $usable_payment_methods[ $key ] = $payment_method; |
|
306 | + foreach ($payment_methods as $key => $payment_method) { |
|
307 | + if (EE_Payment_Method_Manager::instance()->payment_method_type_exists($payment_method->type())) { |
|
308 | + $usable_payment_methods[$key] = $payment_method; |
|
309 | 309 | //some payment methods enqueue their scripts in EE_PMT_*::__construct |
310 | 310 | //which is kinda a no-no (just because it's being constructed doesn't mean we need to enqueue |
311 | 311 | //its scripts). but for backwards-compat we should continue to do that |
312 | 312 | $payment_method->type_obj(); |
313 | - } elseif( $payment_method->active() ) { |
|
313 | + } elseif ($payment_method->active()) { |
|
314 | 314 | //only deactivate and notify the admin if the payment is active somewhere |
315 | 315 | $payment_method->deactivate(); |
316 | 316 | $payment_method->save(); |
317 | 317 | EE_Error::add_persistent_admin_notice( |
318 | - 'auto-deactivated-' . $payment_method->type(), |
|
318 | + 'auto-deactivated-'.$payment_method->type(), |
|
319 | 319 | sprintf( |
320 | - __( 'The payment method %1$s was automatically deactivated because it appears its associated Event Espresso Addon was recently deactivated.%2$sIt can be reactivated on the %3$sPlugins admin page%4$s, then you can reactivate the payment method.', 'event_espresso' ), |
|
320 | + __('The payment method %1$s was automatically deactivated because it appears its associated Event Espresso Addon was recently deactivated.%2$sIt can be reactivated on the %3$sPlugins admin page%4$s, then you can reactivate the payment method.', 'event_espresso'), |
|
321 | 321 | $payment_method->admin_name(), |
322 | 322 | '<br />', |
323 | - '<a href="' . admin_url('plugins.php') . '">', |
|
323 | + '<a href="'.admin_url('plugins.php').'">', |
|
324 | 324 | '</a>' |
325 | 325 | ), |
326 | 326 | true |
@@ -340,16 +340,16 @@ discard block |
||
340 | 340 | * @param string $scope @see EEM_Payment_Method::get_all_for_events |
341 | 341 | * @return EE_Payment_Method[] |
342 | 342 | */ |
343 | - public function get_all_for_transaction( $transaction, $scope ) { |
|
343 | + public function get_all_for_transaction($transaction, $scope) { |
|
344 | 344 | //@todo take relations between events and payment methods into account, once that relation exists |
345 | - if ( $transaction instanceof EE_Transaction ) { |
|
345 | + if ($transaction instanceof EE_Transaction) { |
|
346 | 346 | //@todo take the relation between transaction and currencies into account |
347 | 347 | } |
348 | - $currencies_for_events = array( EE_Config::instance()->currency->code ); |
|
348 | + $currencies_for_events = array(EE_Config::instance()->currency->code); |
|
349 | 349 | //give addons a chance to override what payment methods are chosen based on the transaction |
350 | 350 | return apply_filters( |
351 | 351 | 'FHEE__EEM_Payment_Method__get_all_for_transaction__payment_methods', |
352 | - $this->get_all_active( $scope, array( array( 'Currency.CUR_code' => array( 'IN', $currencies_for_events ) ) ) ), |
|
352 | + $this->get_all_active($scope, array(array('Currency.CUR_code' => array('IN', $currencies_for_events)))), |
|
353 | 353 | $transaction, |
354 | 354 | $scope |
355 | 355 | ); |
@@ -365,16 +365,16 @@ discard block |
||
365 | 365 | * @param EE_Registration|int $registration_or_reg_id Either the EE_Registration object or the id for the registration. |
366 | 366 | * @return EE_Payment|null |
367 | 367 | */ |
368 | - public function get_last_used_for_registration( $registration_or_reg_id ) { |
|
369 | - $registration_id = EEM_Registration::instance()->ensure_is_ID( $registration_or_reg_id ); |
|
368 | + public function get_last_used_for_registration($registration_or_reg_id) { |
|
369 | + $registration_id = EEM_Registration::instance()->ensure_is_ID($registration_or_reg_id); |
|
370 | 370 | |
371 | 371 | $query_params = array( |
372 | 372 | 0 => array( |
373 | 373 | 'Payment.Registration.REG_ID' => $registration_id, |
374 | 374 | ), |
375 | - 'order_by' => array( 'Payment.PAY_ID' => 'DESC' ) |
|
375 | + 'order_by' => array('Payment.PAY_ID' => 'DESC') |
|
376 | 376 | ); |
377 | - return $this->get_one( $query_params ); |
|
377 | + return $this->get_one($query_params); |
|
378 | 378 | } |
379 | 379 | |
380 | 380 | } |