@@ -27,7 +27,7 @@ discard block |
||
27 | 27 | * Just initializes the status of the migration |
28 | 28 | */ |
29 | 29 | public function __construct() { |
30 | - $this->_pretty_name = __( 'Update Invoice Settings', 'event_espresso' ); |
|
30 | + $this->_pretty_name = __('Update Invoice Settings', 'event_espresso'); |
|
31 | 31 | parent::__construct(); |
32 | 32 | } |
33 | 33 | |
@@ -54,14 +54,14 @@ discard block |
||
54 | 54 | * @throws EE_Error |
55 | 55 | * @return int number of items ACTUALLY migrated |
56 | 56 | */ |
57 | - protected function _migration_step( $num_items = 1 ){ |
|
57 | + protected function _migration_step($num_items = 1) { |
|
58 | 58 | |
59 | - EE_Registry::instance()->load_helper( 'Template' ); |
|
59 | + EE_Registry::instance()->load_helper('Template'); |
|
60 | 60 | $templates_relative_path = 'modules/gateways/Invoice/lib/templates/'; |
61 | - $overridden_invoice_body = EEH_Template::locate_template( $templates_relative_path . 'invoice_body.template.php', NULL, FALSE, FALSE, TRUE ); |
|
62 | - $overridden_receipt_body= EEH_Template::locate_template( $templates_relative_path . 'receipt_body.template.php', NULL, FALSE, FALSE, TRUE ); |
|
63 | - if( $overridden_invoice_body || $overridden_receipt_body ) { |
|
64 | - EE_Error::add_persistent_admin_notice( 'invoice_overriding_templates', sprintf( __( 'Note: in this version of Event Espresso, PDF and HTML Invoices and Receipts are now Messages and can be changed just like any other messages; however we noticed you had previously overriden the old default Invoice/Receipt templates. Because of this, your old Invoice/Receipt templates will continue to be used INSTEAD of the new Invoice/Receipt message equivalents (but this will be removed in an upcoming version). We recommend deleting your old Invoice/Receipt templates and using the new messages system. Then modify the new Invoice and Receipt messages\'s content in Messages -> Invoice and Messages -> Receipt.')), TRUE ); |
|
61 | + $overridden_invoice_body = EEH_Template::locate_template($templates_relative_path.'invoice_body.template.php', NULL, FALSE, FALSE, TRUE); |
|
62 | + $overridden_receipt_body = EEH_Template::locate_template($templates_relative_path.'receipt_body.template.php', NULL, FALSE, FALSE, TRUE); |
|
63 | + if ($overridden_invoice_body || $overridden_receipt_body) { |
|
64 | + EE_Error::add_persistent_admin_notice('invoice_overriding_templates', sprintf(__('Note: in this version of Event Espresso, PDF and HTML Invoices and Receipts are now Messages and can be changed just like any other messages; however we noticed you had previously overriden the old default Invoice/Receipt templates. Because of this, your old Invoice/Receipt templates will continue to be used INSTEAD of the new Invoice/Receipt message equivalents (but this will be removed in an upcoming version). We recommend deleting your old Invoice/Receipt templates and using the new messages system. Then modify the new Invoice and Receipt messages\'s content in Messages -> Invoice and Messages -> Receipt.')), TRUE); |
|
65 | 65 | } |
66 | 66 | |
67 | 67 | //regardless of whether it worked or not, we ought to continue the migration |
@@ -26,7 +26,7 @@ discard block |
||
26 | 26 | */ |
27 | 27 | public function __construct() { |
28 | 28 | global $wpdb; |
29 | - $this->_pretty_name = __( 'Question Types', 'event_espresso' ); |
|
29 | + $this->_pretty_name = __('Question Types', 'event_espresso'); |
|
30 | 30 | $this->_old_table = $wpdb->prefix.'esp_question'; |
31 | 31 | $this->_question_type_conversions = array( |
32 | 32 | 'MULTIPLE' => 'CHECKBOX', |
@@ -35,8 +35,8 @@ discard block |
||
35 | 35 | //when fetching rows, because we automatically use a limit and offset |
36 | 36 | //rows counted before migrating any rows, need to ALSO be counted after a bunch of rows were counted |
37 | 37 | //so we need to include both the migrated rows as well as the non-migrated rows |
38 | - $QST_types_to_count = array_merge( array_keys( $this->_question_type_conversions ), $this->_question_type_conversions ); |
|
39 | - $this->_extra_where_sql = "WHERE QST_type IN ('" . implode( "', '", $QST_types_to_count ) . "')" ; |
|
38 | + $QST_types_to_count = array_merge(array_keys($this->_question_type_conversions), $this->_question_type_conversions); |
|
39 | + $this->_extra_where_sql = "WHERE QST_type IN ('".implode("', '", $QST_types_to_count)."')"; |
|
40 | 40 | parent::__construct(); |
41 | 41 | } |
42 | 42 | |
@@ -44,21 +44,21 @@ discard block |
||
44 | 44 | * @param array $question an associative array where keys are column names and values are their values. |
45 | 45 | * @return null |
46 | 46 | */ |
47 | - protected function _migrate_old_row( $question ) { |
|
47 | + protected function _migrate_old_row($question) { |
|
48 | 48 | global $wpdb; |
49 | - if ( $question['QST_ID'] && isset( $this->_question_type_conversions[ $question['QST_type'] ] )) { |
|
49 | + if ($question['QST_ID'] && isset($this->_question_type_conversions[$question['QST_type']])) { |
|
50 | 50 | $success = $wpdb->update( |
51 | 51 | $this->_old_table, |
52 | - array( 'QST_type' => $this->_question_type_conversions[ $question['QST_type'] ] ), // data |
|
53 | - array( 'QST_ID' => $question['QST_ID'] ), // where |
|
54 | - array( '%s' ), // data format |
|
55 | - array( '%d' ) // where format |
|
52 | + array('QST_type' => $this->_question_type_conversions[$question['QST_type']]), // data |
|
53 | + array('QST_ID' => $question['QST_ID']), // where |
|
54 | + array('%s'), // data format |
|
55 | + array('%d') // where format |
|
56 | 56 | ); |
57 | - if ( ! $success ) { |
|
57 | + if ( ! $success) { |
|
58 | 58 | $this->add_error( |
59 | 59 | sprintf( |
60 | - __( 'Could not update question type %1$s for question ID=%2$d because "%3$s"', 'event_espresso' ), |
|
61 | - json_encode( $question['QST_type'] ), |
|
60 | + __('Could not update question type %1$s for question ID=%2$d because "%3$s"', 'event_espresso'), |
|
61 | + json_encode($question['QST_type']), |
|
62 | 62 | $question['QST_ID'], |
63 | 63 | $wpdb->last_error |
64 | 64 | ) |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | |
3 | -if (!defined('EVENT_ESPRESSO_VERSION')) { |
|
3 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
4 | 4 | exit('No direct script access allowed'); |
5 | 5 | } |
6 | 6 | |
@@ -13,7 +13,7 @@ discard block |
||
13 | 13 | * @author Brent Christensen |
14 | 14 | * |
15 | 15 | */ |
16 | -class EE_DMS_4_6_0_state_system_question extends EE_Data_Migration_Script_Stage_Table{ |
|
16 | +class EE_DMS_4_6_0_state_system_question extends EE_Data_Migration_Script_Stage_Table { |
|
17 | 17 | |
18 | 18 | |
19 | 19 | |
@@ -24,7 +24,7 @@ discard block |
||
24 | 24 | */ |
25 | 25 | public function __construct() { |
26 | 26 | global $wpdb; |
27 | - $this->_pretty_name = __( 'State - System Question', 'event_espresso' ); |
|
27 | + $this->_pretty_name = __('State - System Question', 'event_espresso'); |
|
28 | 28 | $this->_old_table = $wpdb->prefix.'esp_question'; |
29 | 29 | $this->_extra_where_sql = "WHERE QST_system = 'state'"; |
30 | 30 | parent::__construct(); |
@@ -37,21 +37,21 @@ discard block |
||
37 | 37 | * @param array $question an associative array where keys are column names and values are their values. |
38 | 38 | * @return null |
39 | 39 | */ |
40 | - protected function _migrate_old_row( $question ) { |
|
41 | - if ( $question['QST_ID'] && $question['QST_system'] == 'state' ) { |
|
40 | + protected function _migrate_old_row($question) { |
|
41 | + if ($question['QST_ID'] && $question['QST_system'] == 'state') { |
|
42 | 42 | global $wpdb; |
43 | 43 | $success = $wpdb->update( |
44 | 44 | $this->_old_table, |
45 | - array( 'QST_type' => 'STATE' ), // data |
|
46 | - array( 'QST_ID' => $question['QST_ID'] ), // where |
|
47 | - array( '%s' ), // data format |
|
48 | - array( '%d' ) // where format |
|
45 | + array('QST_type' => 'STATE'), // data |
|
46 | + array('QST_ID' => $question['QST_ID']), // where |
|
47 | + array('%s'), // data format |
|
48 | + array('%d') // where format |
|
49 | 49 | ); |
50 | - if ( ! $success ) { |
|
50 | + if ( ! $success) { |
|
51 | 51 | $this->add_error( |
52 | 52 | sprintf( |
53 | - __( 'Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso' ), |
|
54 | - json_encode( $question['QST_system'] ), |
|
53 | + __('Could not update question system name "%1$s" for question ID=%2$d because "%3$s"', 'event_espresso'), |
|
54 | + json_encode($question['QST_system']), |
|
55 | 55 | $question['QST_ID'], |
56 | 56 | $wpdb->last_error |
57 | 57 | ) |
@@ -11,18 +11,18 @@ discard block |
||
11 | 11 | //(all other times it gets resurrected from a wordpress option) |
12 | 12 | $stages = glob(EE_CORE.'data_migration_scripts/4_2_0_stages/*'); |
13 | 13 | $class_to_filepath = array(); |
14 | -if ( ! empty( $stages ) ) { |
|
15 | - foreach($stages as $filepath){ |
|
14 | +if ( ! empty($stages)) { |
|
15 | + foreach ($stages as $filepath) { |
|
16 | 16 | $matches = array(); |
17 | - preg_match('~4_2_0_stages/(.*).dmsstage.php~',$filepath,$matches); |
|
17 | + preg_match('~4_2_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
18 | 18 | $class_to_filepath[$matches[1]] = $filepath; |
19 | 19 | } |
20 | 20 | } |
21 | 21 | //give addons a chance to autoload their stages too |
22 | -$class_to_filepath = apply_filters('FHEE__EE_DMS_4_2_0__autoloaded_stages',$class_to_filepath); |
|
22 | +$class_to_filepath = apply_filters('FHEE__EE_DMS_4_2_0__autoloaded_stages', $class_to_filepath); |
|
23 | 23 | EEH_Autoloader::register_autoloader($class_to_filepath); |
24 | 24 | |
25 | -class EE_DMS_Core_4_2_0 extends EE_Data_Migration_Script_Base{ |
|
25 | +class EE_DMS_Core_4_2_0 extends EE_Data_Migration_Script_Base { |
|
26 | 26 | |
27 | 27 | |
28 | 28 | |
@@ -37,15 +37,15 @@ discard block |
||
37 | 37 | } |
38 | 38 | public function can_migrate_from_version($version_array) { |
39 | 39 | $version_string = $version_array['Core']; |
40 | - if($version_string <= '4.2.0' && $version_string >= '4.1.0' ){ |
|
40 | + if ($version_string <= '4.2.0' && $version_string >= '4.1.0') { |
|
41 | 41 | // echo "$version_string can be migrated fro"; |
42 | 42 | return true; |
43 | - }elseif( ! $version_string ){ |
|
43 | + }elseif ( ! $version_string) { |
|
44 | 44 | // echo "no version string provided: $version_string"; |
45 | 45 | //no version string provided... this must be pre 4.1 |
46 | 46 | //because since 4.1 we're |
47 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
48 | - }else{ |
|
47 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
48 | + } else { |
|
49 | 49 | // echo "$version_string doesnt apply"; |
50 | 50 | return false; |
51 | 51 | } |
@@ -55,14 +55,14 @@ discard block |
||
55 | 55 | } |
56 | 56 | public function schema_changes_before_migration() { |
57 | 57 | //relies on 4.1's EEH_Activation::create_table |
58 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
59 | - $table_name='esp_answer'; |
|
60 | - $sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
58 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
59 | + $table_name = 'esp_answer'; |
|
60 | + $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
61 | 61 | REG_ID INT UNSIGNED NOT NULL, |
62 | 62 | QST_ID INT UNSIGNED NOT NULL, |
63 | 63 | ANS_value TEXT NOT NULL, |
64 | 64 | PRIMARY KEY (ANS_ID)"; |
65 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
65 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
66 | 66 | |
67 | 67 | $table_name = 'esp_attendee_meta'; |
68 | 68 | $sql = "ATTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -102,7 +102,7 @@ discard block |
||
102 | 102 | CNT_is_EU TINYINT(1) DEFAULT '0', |
103 | 103 | CNT_active TINYINT(1) DEFAULT '0', |
104 | 104 | PRIMARY KEY (CNT_ISO)"; |
105 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
105 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
106 | 106 | |
107 | 107 | |
108 | 108 | |
@@ -125,7 +125,7 @@ discard block |
||
125 | 125 | |
126 | 126 | |
127 | 127 | |
128 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
128 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
129 | 129 | $table_name = 'esp_event_meta'; |
130 | 130 | $sql = " |
131 | 131 | EVTM_ID INT NOT NULL AUTO_INCREMENT, |
@@ -142,41 +142,41 @@ discard block |
||
142 | 142 | EVT_external_URL VARCHAR(200) NULL, |
143 | 143 | EVT_donations TINYINT(1) NULL, |
144 | 144 | PRIMARY KEY (EVTM_ID)"; |
145 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
145 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
146 | 146 | |
147 | 147 | |
148 | 148 | |
149 | - $table_name='esp_event_question_group'; |
|
150 | - $sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
149 | + $table_name = 'esp_event_question_group'; |
|
150 | + $sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
151 | 151 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
152 | 152 | QSG_ID INT UNSIGNED NOT NULL, |
153 | 153 | EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
154 | 154 | PRIMARY KEY (EQG_ID)"; |
155 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
155 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
156 | 156 | |
157 | 157 | |
158 | 158 | |
159 | - $table_name='esp_event_venue'; |
|
160 | - $sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
159 | + $table_name = 'esp_event_venue'; |
|
160 | + $sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
161 | 161 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
162 | 162 | VNU_ID BIGINT(20) UNSIGNED NOT NULL, |
163 | 163 | EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
164 | 164 | PRIMARY KEY (EVV_ID)"; |
165 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
165 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
166 | 166 | |
167 | 167 | |
168 | 168 | |
169 | - $table_name='esp_extra_meta'; |
|
170 | - $sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
169 | + $table_name = 'esp_extra_meta'; |
|
170 | + $sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
171 | 171 | OBJ_ID INT(11) DEFAULT NULL, |
172 | 172 | EXM_type VARCHAR(45) DEFAULT NULL, |
173 | 173 | EXM_key VARCHAR(45) DEFAULT NULL, |
174 | 174 | EXM_value TEXT, |
175 | 175 | PRIMARY KEY (EXM_ID)"; |
176 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
176 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
177 | 177 | |
178 | - $table_name='esp_line_item'; |
|
179 | - $sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
178 | + $table_name = 'esp_line_item'; |
|
179 | + $sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
180 | 180 | LIN_code VARCHAR(245) NOT NULL DEFAULT '', |
181 | 181 | TXN_ID INT(11) DEFAULT NULL, |
182 | 182 | LIN_name VARCHAR(245) NOT NULL DEFAULT '', |
@@ -192,7 +192,7 @@ discard block |
||
192 | 192 | OBJ_ID INT(11) DEFAULT NULL, |
193 | 193 | OBJ_type VARCHAR(45)DEFAULT NULL, |
194 | 194 | PRIMARY KEY (LIN_ID)"; |
195 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB' ); |
|
195 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
196 | 196 | |
197 | 197 | $table_name = 'esp_message_template'; |
198 | 198 | $sql = "MTP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -219,7 +219,7 @@ discard block |
||
219 | 219 | PRIMARY KEY (GRP_ID), |
220 | 220 | KEY EVT_ID (EVT_ID), |
221 | 221 | KEY MTP_user_id (MTP_user_id)"; |
222 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
222 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
223 | 223 | |
224 | 224 | |
225 | 225 | |
@@ -327,8 +327,8 @@ discard block |
||
327 | 327 | |
328 | 328 | |
329 | 329 | |
330 | - $table_name='esp_question'; |
|
331 | - $sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
330 | + $table_name = 'esp_question'; |
|
331 | + $sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
332 | 332 | QST_display_text TEXT NOT NULL, |
333 | 333 | QST_admin_label VARCHAR(255) NOT NULL, |
334 | 334 | QST_system VARCHAR(25) DEFAULT NULL, |
@@ -340,12 +340,12 @@ discard block |
||
340 | 340 | QST_wp_user BIGINT UNSIGNED NULL, |
341 | 341 | QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0, |
342 | 342 | PRIMARY KEY (QST_ID)'; |
343 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
343 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
344 | 344 | |
345 | - EEH_Activation::drop_index( 'esp_question_group', 'QSG_identifier_UNIQUE' ); |
|
345 | + EEH_Activation::drop_index('esp_question_group', 'QSG_identifier_UNIQUE'); |
|
346 | 346 | |
347 | 347 | $table_name = 'esp_question_group'; |
348 | - $sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
348 | + $sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
349 | 349 | QSG_name VARCHAR(255) NOT NULL, |
350 | 350 | QSG_identifier VARCHAR(100) NOT NULL, |
351 | 351 | QSG_desc TEXT NULL, |
@@ -356,28 +356,28 @@ discard block |
||
356 | 356 | QSG_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
357 | 357 | PRIMARY KEY (QSG_ID), |
358 | 358 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)'; |
359 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
359 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
360 | 360 | |
361 | 361 | |
362 | 362 | |
363 | - $table_name='esp_question_group_question'; |
|
364 | - $sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
363 | + $table_name = 'esp_question_group_question'; |
|
364 | + $sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
365 | 365 | QSG_ID INT UNSIGNED NOT NULL, |
366 | 366 | QST_ID INT UNSIGNED NOT NULL, |
367 | 367 | QGQ_order INT UNSIGNED NOT NULL DEFAULT 0, |
368 | 368 | PRIMARY KEY (QGQ_ID) "; |
369 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
369 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
370 | 370 | |
371 | 371 | |
372 | 372 | |
373 | - $table_name='esp_question_option'; |
|
374 | - $sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
373 | + $table_name = 'esp_question_option'; |
|
374 | + $sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
375 | 375 | QSO_value VARCHAR(255) NOT NULL, |
376 | 376 | QSO_desc TEXT NOT NULL, |
377 | 377 | QST_ID INT UNSIGNED NOT NULL, |
378 | 378 | QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
379 | 379 | PRIMARY KEY (QSO_ID)"; |
380 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
380 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
381 | 381 | |
382 | 382 | |
383 | 383 | |
@@ -410,8 +410,8 @@ discard block |
||
410 | 410 | |
411 | 411 | |
412 | 412 | |
413 | - $table_name='esp_checkin'; |
|
414 | - $sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
413 | + $table_name = 'esp_checkin'; |
|
414 | + $sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
415 | 415 | REG_ID INT(10) UNSIGNED NOT NULL, |
416 | 416 | DTT_ID INT(10) UNSIGNED NOT NULL, |
417 | 417 | CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, |
@@ -485,7 +485,7 @@ discard block |
||
485 | 485 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
486 | 486 | |
487 | 487 | |
488 | - $script_with_defaults = EE_Registry::instance()->load_dms( 'Core_4_1_0' ); |
|
488 | + $script_with_defaults = EE_Registry::instance()->load_dms('Core_4_1_0'); |
|
489 | 489 | //setting up the DEFAULT stats and countries is also essential for the data migrations to run |
490 | 490 | //(because many need to convert old string states to foreign keys into the states table) |
491 | 491 | $script_with_defaults->insert_default_states(); |
@@ -507,7 +507,7 @@ discard block |
||
507 | 507 | return true; |
508 | 508 | } |
509 | 509 | |
510 | - public function migration_page_hooks(){ |
|
510 | + public function migration_page_hooks() { |
|
511 | 511 | |
512 | 512 | } |
513 | 513 | } |
@@ -40,12 +40,12 @@ |
||
40 | 40 | if($version_string <= '4.2.0' && $version_string >= '4.1.0' ){ |
41 | 41 | // echo "$version_string can be migrated fro"; |
42 | 42 | return true; |
43 | - }elseif( ! $version_string ){ |
|
43 | + } elseif( ! $version_string ){ |
|
44 | 44 | // echo "no version string provided: $version_string"; |
45 | 45 | //no version string provided... this must be pre 4.1 |
46 | 46 | //because since 4.1 we're |
47 | 47 | return false;//changed mind. dont want people thinking they should migrate yet because they cant |
48 | - }else{ |
|
48 | + } else{ |
|
49 | 49 | // echo "$version_string doesnt apply"; |
50 | 50 | return false; |
51 | 51 | } |
@@ -10,18 +10,18 @@ discard block |
||
10 | 10 | //(all other times it gets resurrected from a wordpress option) |
11 | 11 | $stages = glob(EE_CORE.'data_migration_scripts/4_3_0_stages/*'); |
12 | 12 | $class_to_filepath = array(); |
13 | -if ( ! empty( $stages ) ) { |
|
14 | - foreach($stages as $filepath){ |
|
13 | +if ( ! empty($stages)) { |
|
14 | + foreach ($stages as $filepath) { |
|
15 | 15 | $matches = array(); |
16 | - preg_match('~4_3_0_stages/(.*).dmsstage.php~',$filepath,$matches); |
|
16 | + preg_match('~4_3_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
17 | 17 | $class_to_filepath[$matches[1]] = $filepath; |
18 | 18 | } |
19 | 19 | } |
20 | 20 | //give addons a chance to autoload their stages too |
21 | -$class_to_filepath = apply_filters('FHEE__EE_DMS_4_3_0__autoloaded_stages',$class_to_filepath); |
|
21 | +$class_to_filepath = apply_filters('FHEE__EE_DMS_4_3_0__autoloaded_stages', $class_to_filepath); |
|
22 | 22 | EEH_Autoloader::register_autoloader($class_to_filepath); |
23 | 23 | |
24 | -class EE_DMS_Core_4_3_0 extends EE_Data_Migration_Script_Base{ |
|
24 | +class EE_DMS_Core_4_3_0 extends EE_Data_Migration_Script_Base { |
|
25 | 25 | |
26 | 26 | |
27 | 27 | |
@@ -37,14 +37,14 @@ discard block |
||
37 | 37 | } |
38 | 38 | public function can_migrate_from_version($version_array) { |
39 | 39 | $version_string = $version_array['Core']; |
40 | - if($version_string <= '4.3.0' && $version_string >= '4.2.0' ){ |
|
40 | + if ($version_string <= '4.3.0' && $version_string >= '4.2.0') { |
|
41 | 41 | // echo "$version_string can be migrated fro"; |
42 | 42 | return true; |
43 | - }elseif( ! $version_string ){ |
|
43 | + }elseif ( ! $version_string) { |
|
44 | 44 | // echo "no version string provided: $version_string"; |
45 | 45 | //no version string provided... this must be pre 4.2 |
46 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
47 | - }else{ |
|
46 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
47 | + } else { |
|
48 | 48 | // echo "$version_string doesnt apply"; |
49 | 49 | return false; |
50 | 50 | } |
@@ -54,14 +54,14 @@ discard block |
||
54 | 54 | } |
55 | 55 | public function schema_changes_before_migration() { |
56 | 56 | //relies on 4.1's EEH_Activation::create_table |
57 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
58 | - $table_name='esp_answer'; |
|
59 | - $sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
57 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
58 | + $table_name = 'esp_answer'; |
|
59 | + $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
60 | 60 | REG_ID INT UNSIGNED NOT NULL, |
61 | 61 | QST_ID INT UNSIGNED NOT NULL, |
62 | 62 | ANS_value TEXT NOT NULL, |
63 | 63 | PRIMARY KEY (ANS_ID)"; |
64 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
64 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
65 | 65 | |
66 | 66 | $table_name = 'esp_attendee_meta'; |
67 | 67 | $sql = "ATTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -100,7 +100,7 @@ discard block |
||
100 | 100 | CNT_is_EU TINYINT(1) DEFAULT '0', |
101 | 101 | CNT_active TINYINT(1) DEFAULT '0', |
102 | 102 | PRIMARY KEY (CNT_ISO)"; |
103 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
103 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
104 | 104 | |
105 | 105 | |
106 | 106 | |
@@ -123,7 +123,7 @@ discard block |
||
123 | 123 | |
124 | 124 | |
125 | 125 | |
126 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
126 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
127 | 127 | $table_name = 'esp_event_meta'; |
128 | 128 | $sql = " |
129 | 129 | EVTM_ID INT NOT NULL AUTO_INCREMENT, |
@@ -140,41 +140,41 @@ discard block |
||
140 | 140 | EVT_external_URL VARCHAR(200) NULL, |
141 | 141 | EVT_donations TINYINT(1) NULL, |
142 | 142 | PRIMARY KEY (EVTM_ID)"; |
143 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
143 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
144 | 144 | |
145 | 145 | |
146 | 146 | |
147 | - $table_name='esp_event_question_group'; |
|
148 | - $sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
147 | + $table_name = 'esp_event_question_group'; |
|
148 | + $sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
149 | 149 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
150 | 150 | QSG_ID INT UNSIGNED NOT NULL, |
151 | 151 | EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
152 | 152 | PRIMARY KEY (EQG_ID)"; |
153 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
153 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
154 | 154 | |
155 | 155 | |
156 | 156 | |
157 | - $table_name='esp_event_venue'; |
|
158 | - $sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
157 | + $table_name = 'esp_event_venue'; |
|
158 | + $sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
159 | 159 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
160 | 160 | VNU_ID BIGINT(20) UNSIGNED NOT NULL, |
161 | 161 | EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
162 | 162 | PRIMARY KEY (EVV_ID)"; |
163 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
163 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
164 | 164 | |
165 | 165 | |
166 | 166 | |
167 | - $table_name='esp_extra_meta'; |
|
168 | - $sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
167 | + $table_name = 'esp_extra_meta'; |
|
168 | + $sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
169 | 169 | OBJ_ID INT(11) DEFAULT NULL, |
170 | 170 | EXM_type VARCHAR(45) DEFAULT NULL, |
171 | 171 | EXM_key VARCHAR(45) DEFAULT NULL, |
172 | 172 | EXM_value TEXT, |
173 | 173 | PRIMARY KEY (EXM_ID)"; |
174 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
174 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
175 | 175 | |
176 | - $table_name='esp_line_item'; |
|
177 | - $sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
176 | + $table_name = 'esp_line_item'; |
|
177 | + $sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
178 | 178 | LIN_code VARCHAR(245) NOT NULL DEFAULT '', |
179 | 179 | TXN_ID INT(11) DEFAULT NULL, |
180 | 180 | LIN_name VARCHAR(245) NOT NULL DEFAULT '', |
@@ -190,7 +190,7 @@ discard block |
||
190 | 190 | OBJ_ID INT(11) DEFAULT NULL, |
191 | 191 | OBJ_type VARCHAR(45)DEFAULT NULL, |
192 | 192 | PRIMARY KEY (LIN_ID)"; |
193 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB' ); |
|
193 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
194 | 194 | |
195 | 195 | $table_name = 'esp_message_template'; |
196 | 196 | $sql = "MTP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -202,7 +202,7 @@ discard block |
||
202 | 202 | KEY GRP_ID (GRP_ID)"; |
203 | 203 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
204 | 204 | |
205 | - EEH_Activation::drop_index( 'esp_message_template_group', 'EVT_ID' ); |
|
205 | + EEH_Activation::drop_index('esp_message_template_group', 'EVT_ID'); |
|
206 | 206 | |
207 | 207 | $table_name = 'esp_message_template_group'; |
208 | 208 | $sql = "GRP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -217,7 +217,7 @@ discard block |
||
217 | 217 | MTP_is_active TINYINT(1) NOT NULL DEFAULT '1', |
218 | 218 | PRIMARY KEY (GRP_ID), |
219 | 219 | KEY MTP_user_id (MTP_user_id)"; |
220 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
220 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
221 | 221 | |
222 | 222 | $table_name = 'esp_event_message_template'; |
223 | 223 | $sql = "EMT_ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -226,7 +226,7 @@ discard block |
||
226 | 226 | PRIMARY KEY (EMT_ID), |
227 | 227 | KEY EVT_ID (EVT_ID), |
228 | 228 | KEY GRP_ID (GRP_ID)"; |
229 | - $this->_table_is_new_in_this_version( $table_name, $sql, 'ENGINE=InnoDB'); |
|
229 | + $this->_table_is_new_in_this_version($table_name, $sql, 'ENGINE=InnoDB'); |
|
230 | 230 | |
231 | 231 | |
232 | 232 | |
@@ -335,8 +335,8 @@ discard block |
||
335 | 335 | |
336 | 336 | |
337 | 337 | |
338 | - $table_name='esp_question'; |
|
339 | - $sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
338 | + $table_name = 'esp_question'; |
|
339 | + $sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
340 | 340 | QST_display_text TEXT NOT NULL, |
341 | 341 | QST_admin_label VARCHAR(255) NOT NULL, |
342 | 342 | QST_system VARCHAR(25) DEFAULT NULL, |
@@ -348,12 +348,12 @@ discard block |
||
348 | 348 | QST_wp_user BIGINT UNSIGNED NULL, |
349 | 349 | QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0, |
350 | 350 | PRIMARY KEY (QST_ID)'; |
351 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
351 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
352 | 352 | |
353 | - EEH_Activation::drop_index( 'esp_question_group', 'QSG_identifier_UNIQUE' ); |
|
353 | + EEH_Activation::drop_index('esp_question_group', 'QSG_identifier_UNIQUE'); |
|
354 | 354 | |
355 | 355 | $table_name = 'esp_question_group'; |
356 | - $sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
356 | + $sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
357 | 357 | QSG_name VARCHAR(255) NOT NULL, |
358 | 358 | QSG_identifier VARCHAR(100) NOT NULL, |
359 | 359 | QSG_desc TEXT NULL, |
@@ -364,29 +364,29 @@ discard block |
||
364 | 364 | QSG_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
365 | 365 | PRIMARY KEY (QSG_ID), |
366 | 366 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)'; |
367 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
367 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
368 | 368 | |
369 | 369 | |
370 | 370 | |
371 | - $table_name='esp_question_group_question'; |
|
372 | - $sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
371 | + $table_name = 'esp_question_group_question'; |
|
372 | + $sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
373 | 373 | QSG_ID INT UNSIGNED NOT NULL, |
374 | 374 | QST_ID INT UNSIGNED NOT NULL, |
375 | 375 | QGQ_order INT UNSIGNED NOT NULL DEFAULT 0, |
376 | 376 | PRIMARY KEY (QGQ_ID) "; |
377 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
377 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
378 | 378 | |
379 | 379 | |
380 | 380 | |
381 | - $table_name='esp_question_option'; |
|
382 | - $sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
381 | + $table_name = 'esp_question_option'; |
|
382 | + $sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
383 | 383 | QSO_value VARCHAR(255) NOT NULL, |
384 | 384 | QSO_desc TEXT NOT NULL, |
385 | 385 | QST_ID INT UNSIGNED NOT NULL, |
386 | 386 | QSO_order INT UNSIGNED NOT NULL DEFAULT 0, |
387 | 387 | QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
388 | 388 | PRIMARY KEY (QSO_ID)"; |
389 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
389 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
390 | 390 | |
391 | 391 | |
392 | 392 | |
@@ -419,8 +419,8 @@ discard block |
||
419 | 419 | |
420 | 420 | |
421 | 421 | |
422 | - $table_name='esp_checkin'; |
|
423 | - $sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
422 | + $table_name = 'esp_checkin'; |
|
423 | + $sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
424 | 424 | REG_ID INT(10) UNSIGNED NOT NULL, |
425 | 425 | DTT_ID INT(10) UNSIGNED NOT NULL, |
426 | 426 | CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, |
@@ -494,7 +494,7 @@ discard block |
||
494 | 494 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
495 | 495 | |
496 | 496 | |
497 | - $script_with_defaults = EE_Registry::instance()->load_dms( 'Core_4_1_0' ); |
|
497 | + $script_with_defaults = EE_Registry::instance()->load_dms('Core_4_1_0'); |
|
498 | 498 | //setting up the DEFAULT stats and countries is also essential for the data migrations to run |
499 | 499 | //(because many need to convert old string states to foreign keys into the states table) |
500 | 500 | $script_with_defaults->insert_default_states(); |
@@ -516,7 +516,7 @@ discard block |
||
516 | 516 | return true; |
517 | 517 | } |
518 | 518 | |
519 | - public function migration_page_hooks(){ |
|
519 | + public function migration_page_hooks() { |
|
520 | 520 | |
521 | 521 | } |
522 | 522 | |
@@ -532,34 +532,34 @@ discard block |
||
532 | 532 | |
533 | 533 | global $wpdb; |
534 | 534 | $ticket_table = $wpdb->prefix."esp_ticket"; |
535 | - if ( $wpdb->get_var("SHOW TABLES LIKE'$ticket_table'") == $ticket_table ) { |
|
535 | + if ($wpdb->get_var("SHOW TABLES LIKE'$ticket_table'") == $ticket_table) { |
|
536 | 536 | |
537 | - $SQL = 'SELECT COUNT(TKT_ID) FROM ' . $ticket_table; |
|
537 | + $SQL = 'SELECT COUNT(TKT_ID) FROM '.$ticket_table; |
|
538 | 538 | $tickets_exist = $wpdb->get_var($SQL); |
539 | 539 | |
540 | - if ( ! $tickets_exist ) { |
|
540 | + if ( ! $tickets_exist) { |
|
541 | 541 | $SQL = "INSERT INTO $ticket_table |
542 | 542 | ( TKT_ID, TTM_ID, TKT_name, TKT_description, TKT_qty, TKT_sold, TKT_uses, TKT_required, TKT_min, TKT_max, TKT_price, TKT_start_date, TKT_end_date, TKT_taxable, TKT_order, TKT_row, TKT_is_default, TKT_parent, TKT_deleted ) VALUES |
543 | - ( 1, 0, '" . __("Free Ticket", "event_espresso") . "', '', 100, 0, -1, 0, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, 0);"; |
|
544 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL', $SQL ); |
|
543 | + ( 1, 0, '".__("Free Ticket", "event_espresso")."', '', 100, 0, -1, 0, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, 0);"; |
|
544 | + $SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL', $SQL); |
|
545 | 545 | $wpdb->query($SQL); |
546 | 546 | } |
547 | 547 | } |
548 | 548 | $ticket_price_table = $wpdb->prefix."esp_ticket_price"; |
549 | 549 | |
550 | - if ( $wpdb->get_var("SHOW TABLES LIKE'$ticket_price_table'") == $ticket_price_table ) { |
|
550 | + if ($wpdb->get_var("SHOW TABLES LIKE'$ticket_price_table'") == $ticket_price_table) { |
|
551 | 551 | |
552 | - $SQL = 'SELECT COUNT(TKP_ID) FROM ' . $ticket_price_table; |
|
552 | + $SQL = 'SELECT COUNT(TKP_ID) FROM '.$ticket_price_table; |
|
553 | 553 | $ticket_prc_exist = $wpdb->get_var($SQL); |
554 | 554 | |
555 | - if ( ! $ticket_prc_exist ) { |
|
555 | + if ( ! $ticket_prc_exist) { |
|
556 | 556 | |
557 | 557 | $SQL = "INSERT INTO $ticket_price_table |
558 | 558 | ( TKP_ID, TKT_ID, PRC_ID ) VALUES |
559 | 559 | ( 1, 1, 1 ) |
560 | 560 | "; |
561 | 561 | |
562 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL__ticket_price', $SQL ); |
|
562 | + $SQL = apply_filters('FHEE__EE_DMS_4_1_0__insert_default_tickets__SQL__ticket_price', $SQL); |
|
563 | 563 | $wpdb->query($SQL); |
564 | 564 | } |
565 | 565 | } |
@@ -40,11 +40,11 @@ |
||
40 | 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 | 46 | return false;//changed mind. dont want people thinking they should migrate yet because they cant |
47 | - }else{ |
|
47 | + } else{ |
|
48 | 48 | // echo "$version_string doesnt apply"; |
49 | 49 | return false; |
50 | 50 | } |
@@ -12,16 +12,16 @@ discard block |
||
12 | 12 | //(all other times it gets resurrected from a wordpress option) |
13 | 13 | $stages = glob(EE_CORE.'data_migration_scripts/4_5_0_stages/*'); |
14 | 14 | $class_to_filepath = array(); |
15 | -foreach($stages as $filepath){ |
|
15 | +foreach ($stages as $filepath) { |
|
16 | 16 | $matches = array(); |
17 | - preg_match('~4_5_0_stages/(.*).dmsstage.php~',$filepath,$matches); |
|
17 | + preg_match('~4_5_0_stages/(.*).dmsstage.php~', $filepath, $matches); |
|
18 | 18 | $class_to_filepath[$matches[1]] = $filepath; |
19 | 19 | } |
20 | 20 | //give addons a chance to autoload their stages too |
21 | -$class_to_filepath = apply_filters('FHEE__EE_DMS_4_5_0__autoloaded_stages',$class_to_filepath); |
|
21 | +$class_to_filepath = apply_filters('FHEE__EE_DMS_4_5_0__autoloaded_stages', $class_to_filepath); |
|
22 | 22 | EEH_Autoloader::register_autoloader($class_to_filepath); |
23 | 23 | |
24 | -class EE_DMS_Core_4_5_0 extends EE_Data_Migration_Script_Base{ |
|
24 | +class EE_DMS_Core_4_5_0 extends EE_Data_Migration_Script_Base { |
|
25 | 25 | |
26 | 26 | |
27 | 27 | |
@@ -39,14 +39,14 @@ discard block |
||
39 | 39 | } |
40 | 40 | public function can_migrate_from_version($version_array) { |
41 | 41 | $version_string = $version_array['Core']; |
42 | - if($version_string <= '4.5.0' && $version_string >= '4.3.0' ){ |
|
42 | + if ($version_string <= '4.5.0' && $version_string >= '4.3.0') { |
|
43 | 43 | // echo "$version_string can be migrated from"; |
44 | 44 | return true; |
45 | - }elseif( ! $version_string ){ |
|
45 | + }elseif ( ! $version_string) { |
|
46 | 46 | // echo "no version string provided: $version_string"; |
47 | 47 | //no version string provided... this must be pre 4.3 |
48 | - return false;//changed mind. dont want people thinking they should migrate yet because they cant |
|
49 | - }else{ |
|
48 | + return false; //changed mind. dont want people thinking they should migrate yet because they cant |
|
49 | + } else { |
|
50 | 50 | // echo "$version_string doesnt apply"; |
51 | 51 | return false; |
52 | 52 | } |
@@ -56,14 +56,14 @@ discard block |
||
56 | 56 | } |
57 | 57 | public function schema_changes_before_migration() { |
58 | 58 | //relies on 4.1's EEH_Activation::create_table |
59 | - require_once( EE_HELPERS . 'EEH_Activation.helper.php' ); |
|
60 | - $table_name='esp_answer'; |
|
61 | - $sql=" ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
59 | + require_once(EE_HELPERS.'EEH_Activation.helper.php'); |
|
60 | + $table_name = 'esp_answer'; |
|
61 | + $sql = " ANS_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
62 | 62 | REG_ID INT UNSIGNED NOT NULL, |
63 | 63 | QST_ID INT UNSIGNED NOT NULL, |
64 | 64 | ANS_value TEXT NOT NULL, |
65 | 65 | PRIMARY KEY (ANS_ID)"; |
66 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
66 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
67 | 67 | |
68 | 68 | $table_name = 'esp_attendee_meta'; |
69 | 69 | $sql = "ATTM_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -102,7 +102,7 @@ discard block |
||
102 | 102 | CNT_is_EU TINYINT(1) DEFAULT '0', |
103 | 103 | CNT_active TINYINT(1) DEFAULT '0', |
104 | 104 | PRIMARY KEY (CNT_ISO)"; |
105 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
105 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
106 | 106 | |
107 | 107 | $table_name = 'esp_datetime'; |
108 | 108 | $sql = "DTT_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -123,7 +123,7 @@ discard block |
||
123 | 123 | |
124 | 124 | |
125 | 125 | |
126 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
126 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
127 | 127 | $table_name = 'esp_event_meta'; |
128 | 128 | $sql = " |
129 | 129 | EVTM_ID INT NOT NULL AUTO_INCREMENT, |
@@ -140,41 +140,41 @@ discard block |
||
140 | 140 | EVT_external_URL VARCHAR(200) NULL, |
141 | 141 | EVT_donations TINYINT(1) NULL, |
142 | 142 | PRIMARY KEY (EVTM_ID)"; |
143 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
143 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
144 | 144 | |
145 | 145 | |
146 | 146 | |
147 | - $table_name='esp_event_question_group'; |
|
148 | - $sql="EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
147 | + $table_name = 'esp_event_question_group'; |
|
148 | + $sql = "EQG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
149 | 149 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
150 | 150 | QSG_ID INT UNSIGNED NOT NULL, |
151 | 151 | EQG_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
152 | 152 | PRIMARY KEY (EQG_ID)"; |
153 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
153 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
154 | 154 | |
155 | 155 | |
156 | 156 | |
157 | - $table_name='esp_event_venue'; |
|
158 | - $sql="EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
157 | + $table_name = 'esp_event_venue'; |
|
158 | + $sql = "EVV_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
159 | 159 | EVT_ID BIGINT(20) UNSIGNED NOT NULL, |
160 | 160 | VNU_ID BIGINT(20) UNSIGNED NOT NULL, |
161 | 161 | EVV_primary TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
162 | 162 | PRIMARY KEY (EVV_ID)"; |
163 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
163 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
164 | 164 | |
165 | 165 | |
166 | 166 | |
167 | - $table_name='esp_extra_meta'; |
|
168 | - $sql="EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
167 | + $table_name = 'esp_extra_meta'; |
|
168 | + $sql = "EXM_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
169 | 169 | OBJ_ID INT(11) DEFAULT NULL, |
170 | 170 | EXM_type VARCHAR(45) DEFAULT NULL, |
171 | 171 | EXM_key VARCHAR(45) DEFAULT NULL, |
172 | 172 | EXM_value TEXT, |
173 | 173 | PRIMARY KEY (EXM_ID)"; |
174 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
174 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
175 | 175 | |
176 | - $table_name='esp_line_item'; |
|
177 | - $sql="LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
176 | + $table_name = 'esp_line_item'; |
|
177 | + $sql = "LIN_ID INT(11) NOT NULL AUTO_INCREMENT, |
|
178 | 178 | LIN_code VARCHAR(245) NOT NULL DEFAULT '', |
179 | 179 | TXN_ID INT(11) DEFAULT NULL, |
180 | 180 | LIN_name VARCHAR(245) NOT NULL DEFAULT '', |
@@ -190,7 +190,7 @@ discard block |
||
190 | 190 | OBJ_ID INT(11) DEFAULT NULL, |
191 | 191 | OBJ_type VARCHAR(45)DEFAULT NULL, |
192 | 192 | PRIMARY KEY (LIN_ID)"; |
193 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB' ); |
|
193 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
194 | 194 | |
195 | 195 | $table_name = 'esp_message_template'; |
196 | 196 | $sql = "MTP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -202,7 +202,7 @@ discard block |
||
202 | 202 | KEY GRP_ID (GRP_ID)"; |
203 | 203 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
204 | 204 | |
205 | - EEH_Activation::drop_index( 'esp_message_template_group', 'EVT_ID' ); |
|
205 | + EEH_Activation::drop_index('esp_message_template_group', 'EVT_ID'); |
|
206 | 206 | |
207 | 207 | $table_name = 'esp_message_template_group'; |
208 | 208 | $sql = "GRP_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -217,7 +217,7 @@ discard block |
||
217 | 217 | MTP_is_active TINYINT(1) NOT NULL DEFAULT '1', |
218 | 218 | PRIMARY KEY (GRP_ID), |
219 | 219 | KEY MTP_user_id (MTP_user_id)"; |
220 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
220 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
221 | 221 | |
222 | 222 | $table_name = 'esp_event_message_template'; |
223 | 223 | $sql = "EMT_ID BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -226,7 +226,7 @@ discard block |
||
226 | 226 | PRIMARY KEY (EMT_ID), |
227 | 227 | KEY EVT_ID (EVT_ID), |
228 | 228 | KEY GRP_ID (GRP_ID)"; |
229 | - $this->_table_should_exist_previously( $table_name, $sql, 'ENGINE=InnoDB'); |
|
229 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
230 | 230 | |
231 | 231 | |
232 | 232 | $table_name = 'esp_payment'; |
@@ -276,8 +276,8 @@ discard block |
||
276 | 276 | PRIMARY KEY (TTM_ID)"; |
277 | 277 | $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
278 | 278 | |
279 | - $table_name='esp_question'; |
|
280 | - $sql='QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
279 | + $table_name = 'esp_question'; |
|
280 | + $sql = 'QST_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
281 | 281 | QST_display_text TEXT NOT NULL, |
282 | 282 | QST_admin_label VARCHAR(255) NOT NULL, |
283 | 283 | QST_system VARCHAR(25) DEFAULT NULL, |
@@ -289,27 +289,27 @@ discard block |
||
289 | 289 | QST_wp_user BIGINT UNSIGNED NULL, |
290 | 290 | QST_deleted TINYINT UNSIGNED NOT NULL DEFAULT 0, |
291 | 291 | PRIMARY KEY (QST_ID)'; |
292 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
292 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
293 | 293 | |
294 | - $table_name='esp_question_group_question'; |
|
295 | - $sql="QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
294 | + $table_name = 'esp_question_group_question'; |
|
295 | + $sql = "QGQ_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
296 | 296 | QSG_ID INT UNSIGNED NOT NULL, |
297 | 297 | QST_ID INT UNSIGNED NOT NULL, |
298 | 298 | QGQ_order INT UNSIGNED NOT NULL DEFAULT 0, |
299 | 299 | PRIMARY KEY (QGQ_ID) "; |
300 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
300 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
301 | 301 | |
302 | 302 | |
303 | 303 | |
304 | - $table_name='esp_question_option'; |
|
305 | - $sql="QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
304 | + $table_name = 'esp_question_option'; |
|
305 | + $sql = "QSO_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
306 | 306 | QSO_value VARCHAR(255) NOT NULL, |
307 | 307 | QSO_desc TEXT NOT NULL, |
308 | 308 | QST_ID INT UNSIGNED NOT NULL, |
309 | 309 | QSO_order INT UNSIGNED NOT NULL DEFAULT 0, |
310 | 310 | QSO_deleted TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, |
311 | 311 | PRIMARY KEY (QSO_ID)"; |
312 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
312 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
313 | 313 | |
314 | 314 | |
315 | 315 | |
@@ -342,8 +342,8 @@ discard block |
||
342 | 342 | |
343 | 343 | |
344 | 344 | |
345 | - $table_name='esp_checkin'; |
|
346 | - $sql="CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
345 | + $table_name = 'esp_checkin'; |
|
346 | + $sql = "CHK_ID INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
|
347 | 347 | REG_ID INT(10) UNSIGNED NOT NULL, |
348 | 348 | DTT_ID INT(10) UNSIGNED NOT NULL, |
349 | 349 | CHK_in TINYINT(1) UNSIGNED NOT NULL DEFAULT 1, |
@@ -431,7 +431,7 @@ discard block |
||
431 | 431 | PRC_wp_user BIGINT UNSIGNED NULL, |
432 | 432 | PRC_parent INT(10) UNSIGNED DEFAULT 0, |
433 | 433 | PRIMARY KEY (PRC_ID)"; |
434 | - $this->_table_should_exist_previously($table_name,$sql, 'ENGINE=InnoDB'); |
|
434 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
435 | 435 | |
436 | 436 | $table_name = "esp_price_type"; |
437 | 437 | $sql = "PRT_ID TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT, |
@@ -468,12 +468,12 @@ discard block |
||
468 | 468 | TKT_parent INT(10) UNSIGNED DEFAULT '0', |
469 | 469 | TKT_deleted TINYINT(1) NOT NULL DEFAULT '0', |
470 | 470 | PRIMARY KEY (TKT_ID)"; |
471 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
471 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
472 | 472 | |
473 | - EEH_Activation::drop_index( 'esp_question_group', 'QSG_identifier_UNIQUE' ); |
|
473 | + EEH_Activation::drop_index('esp_question_group', 'QSG_identifier_UNIQUE'); |
|
474 | 474 | |
475 | 475 | $table_name = 'esp_question_group'; |
476 | - $sql='QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
476 | + $sql = 'QSG_ID INT UNSIGNED NOT NULL AUTO_INCREMENT, |
|
477 | 477 | QSG_name VARCHAR(255) NOT NULL, |
478 | 478 | QSG_identifier VARCHAR(100) NOT NULL, |
479 | 479 | QSG_desc TEXT NULL, |
@@ -485,7 +485,7 @@ discard block |
||
485 | 485 | QSG_wp_user BIGINT UNSIGNED NULL, |
486 | 486 | PRIMARY KEY (QSG_ID), |
487 | 487 | UNIQUE KEY QSG_identifier_UNIQUE (QSG_identifier ASC)'; |
488 | - $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB' ); |
|
488 | + $this->_table_should_exist_previously($table_name, $sql, 'ENGINE=InnoDB'); |
|
489 | 489 | |
490 | 490 | $script_4_1_defaults = EE_Registry::instance()->load_dms('Core_4_1_0'); |
491 | 491 | |
@@ -509,7 +509,7 @@ discard block |
||
509 | 509 | return true; |
510 | 510 | } |
511 | 511 | |
512 | - public function migration_page_hooks(){ |
|
512 | + public function migration_page_hooks() { |
|
513 | 513 | |
514 | 514 | } |
515 | 515 | |
@@ -525,19 +525,19 @@ discard block |
||
525 | 525 | |
526 | 526 | if ($wpdb->get_var("SHOW TABLES LIKE '$price_type_table'") == $price_type_table) { |
527 | 527 | |
528 | - $SQL = 'SELECT COUNT(PRT_ID) FROM ' . $price_type_table; |
|
529 | - $price_types_exist = $wpdb->get_var( $SQL ); |
|
528 | + $SQL = 'SELECT COUNT(PRT_ID) FROM '.$price_type_table; |
|
529 | + $price_types_exist = $wpdb->get_var($SQL); |
|
530 | 530 | |
531 | - if ( ! $price_types_exist ) { |
|
531 | + if ( ! $price_types_exist) { |
|
532 | 532 | $user_id = EEH_Activation::get_default_creator_id(); |
533 | 533 | $SQL = "INSERT INTO $price_type_table ( PRT_ID, PRT_name, PBT_ID, PRT_is_percent, PRT_order, PRT_wp_user, PRT_deleted ) VALUES |
534 | - (1, '" . __('Base Price', 'event_espresso') . "', 1, 0, 0, $user_id, 0), |
|
535 | - (2, '" . __('Percent Discount', 'event_espresso') . "', 2, 1, 20, $user_id, 0), |
|
536 | - (3, '" . __('Dollar Discount', 'event_espresso') . "', 2, 0, 30, $user_id, 0), |
|
537 | - (4, '" . __('Percent Surcharge', 'event_espresso') . "', 3, 1, 40, $user_id, 0), |
|
538 | - (5, '" . __('Dollar Surcharge', 'event_espresso') . "', 3, 0, 50, $user_id, 0);"; |
|
539 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_price_types__SQL', $SQL ); |
|
540 | - $wpdb->query( $SQL ); |
|
534 | + (1, '".__('Base Price', 'event_espresso')."', 1, 0, 0, $user_id, 0), |
|
535 | + (2, '".__('Percent Discount', 'event_espresso')."', 2, 1, 20, $user_id, 0), |
|
536 | + (3, '".__('Dollar Discount', 'event_espresso')."', 2, 0, 30, $user_id, 0), |
|
537 | + (4, '".__('Percent Surcharge', 'event_espresso')."', 3, 1, 40, $user_id, 0), |
|
538 | + (5, '".__('Dollar Surcharge', 'event_espresso')."', 3, 0, 50, $user_id, 0);"; |
|
539 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_price_types__SQL', $SQL); |
|
540 | + $wpdb->query($SQL); |
|
541 | 541 | } |
542 | 542 | } |
543 | 543 | } |
@@ -559,15 +559,15 @@ discard block |
||
559 | 559 | |
560 | 560 | if ($wpdb->get_var("SHOW TABLES LIKE '$price_table'") == $price_table) { |
561 | 561 | |
562 | - $SQL = 'SELECT COUNT(PRC_ID) FROM ' .$price_table; |
|
563 | - $prices_exist = $wpdb->get_var( $SQL ); |
|
562 | + $SQL = 'SELECT COUNT(PRC_ID) FROM '.$price_table; |
|
563 | + $prices_exist = $wpdb->get_var($SQL); |
|
564 | 564 | |
565 | - if ( ! $prices_exist ) { |
|
565 | + if ( ! $prices_exist) { |
|
566 | 566 | $user_id = EEH_Activation::get_default_creator_id(); |
567 | 567 | $SQL = "INSERT INTO $price_table |
568 | 568 | (PRC_ID, PRT_ID, PRC_amount, PRC_name, PRC_desc, PRC_is_default, PRC_overrides, PRC_wp_user, PRC_order, PRC_deleted, PRC_parent ) VALUES |
569 | 569 | (1, 1, '0.00', 'Free Admission', '', 1, NULL, $user_id, 0, 0, 0);"; |
570 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_prices__SQL', $SQL ); |
|
570 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_prices__SQL', $SQL); |
|
571 | 571 | $wpdb->query($SQL); |
572 | 572 | } |
573 | 573 | } |
@@ -585,35 +585,35 @@ discard block |
||
585 | 585 | |
586 | 586 | global $wpdb; |
587 | 587 | $ticket_table = $wpdb->prefix."esp_ticket"; |
588 | - if ( $wpdb->get_var("SHOW TABLES LIKE'$ticket_table'") == $ticket_table ) { |
|
588 | + if ($wpdb->get_var("SHOW TABLES LIKE'$ticket_table'") == $ticket_table) { |
|
589 | 589 | |
590 | - $SQL = 'SELECT COUNT(TKT_ID) FROM ' . $ticket_table; |
|
590 | + $SQL = 'SELECT COUNT(TKT_ID) FROM '.$ticket_table; |
|
591 | 591 | $tickets_exist = $wpdb->get_var($SQL); |
592 | 592 | |
593 | - if ( ! $tickets_exist ) { |
|
593 | + if ( ! $tickets_exist) { |
|
594 | 594 | $user_id = EEH_Activation::get_default_creator_id(); |
595 | 595 | $SQL = "INSERT INTO $ticket_table |
596 | 596 | ( TKT_ID, TTM_ID, TKT_name, TKT_description, TKT_qty, TKT_sold, TKT_uses, TKT_required, TKT_min, TKT_max, TKT_price, TKT_start_date, TKT_end_date, TKT_taxable, TKT_order, TKT_row, TKT_is_default, TKT_parent, TKT_wp_user, TKT_deleted ) VALUES |
597 | - ( 1, 0, '" . __("Free Ticket", "event_espresso") . "', '', 100, 0, -1, 0, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, $user_id, 0);"; |
|
598 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL', $SQL ); |
|
597 | + ( 1, 0, '".__("Free Ticket", "event_espresso")."', '', 100, 0, -1, 0, 0, -1, 0.00, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 1, 1, 0, $user_id, 0);"; |
|
598 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL', $SQL); |
|
599 | 599 | $wpdb->query($SQL); |
600 | 600 | } |
601 | 601 | } |
602 | 602 | $ticket_price_table = $wpdb->prefix."esp_ticket_price"; |
603 | 603 | |
604 | - if ( $wpdb->get_var("SHOW TABLES LIKE'$ticket_price_table'") == $ticket_price_table ) { |
|
604 | + if ($wpdb->get_var("SHOW TABLES LIKE'$ticket_price_table'") == $ticket_price_table) { |
|
605 | 605 | |
606 | - $SQL = 'SELECT COUNT(TKP_ID) FROM ' . $ticket_price_table; |
|
606 | + $SQL = 'SELECT COUNT(TKP_ID) FROM '.$ticket_price_table; |
|
607 | 607 | $ticket_prc_exist = $wpdb->get_var($SQL); |
608 | 608 | |
609 | - if ( ! $ticket_prc_exist ) { |
|
609 | + if ( ! $ticket_prc_exist) { |
|
610 | 610 | |
611 | 611 | $SQL = "INSERT INTO $ticket_price_table |
612 | 612 | ( TKP_ID, TKT_ID, PRC_ID ) VALUES |
613 | 613 | ( 1, 1, 1 ) |
614 | 614 | "; |
615 | 615 | |
616 | - $SQL = apply_filters( 'FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL__ticket_price', $SQL ); |
|
616 | + $SQL = apply_filters('FHEE__EE_DMS_4_5_0__insert_default_tickets__SQL__ticket_price', $SQL); |
|
617 | 617 | $wpdb->query($SQL); |
618 | 618 | } |
619 | 619 | } |
@@ -42,11 +42,11 @@ |
||
42 | 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 | 48 | return false;//changed mind. dont want people thinking they should migrate yet because they cant |
49 | - }else{ |
|
49 | + } else{ |
|
50 | 50 | // echo "$version_string doesnt apply"; |
51 | 51 | return false; |
52 | 52 | } |
@@ -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,19 +597,19 @@ 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 ( $wpdb->get_var( "SHOW TABLES LIKE '" . $table_name . "'") == $table_name ) { |
|
608 | + if ($wpdb->get_var("SHOW TABLES LIKE '".$table_name."'") == $table_name) { |
|
609 | 609 | |
610 | 610 | $SQL = "SELECT COUNT( * ) FROM $table_name"; |
611 | 611 | $existing_payment_methods = $wpdb->get_var($SQL); |
612 | - if ( ! $existing_payment_methods ) { |
|
612 | + if ( ! $existing_payment_methods) { |
|
613 | 613 | //make sure we hae payment method records for the following |
614 | 614 | //so admins can record payments for them from the admin page |
615 | 615 | $default_admin_only_payment_methods = array( |
@@ -623,11 +623,11 @@ discard block |
||
623 | 623 | __("Paypal", 'event_espresso')=> __("Paypal eCheck, Invoice, etc", 'event_espresso'), |
624 | 624 | ); |
625 | 625 | |
626 | - foreach($default_admin_only_payment_methods as $nicename => $description){ |
|
626 | + foreach ($default_admin_only_payment_methods as $nicename => $description) { |
|
627 | 627 | $slug = sanitize_key($nicename); |
628 | 628 | //check that such a payment method exists |
629 | - $exists = $wpdb->get_var($wpdb->prepare("SELECT count(*) FROM $table_name WHERE PMD_slug = %s",$slug)); |
|
630 | - if( ! $exists){ |
|
629 | + $exists = $wpdb->get_var($wpdb->prepare("SELECT count(*) FROM $table_name WHERE PMD_slug = %s", $slug)); |
|
630 | + if ( ! $exists) { |
|
631 | 631 | $values = array( |
632 | 632 | 'PMD_type'=>'Admin_Only', |
633 | 633 | 'PMD_name'=>$nicename, |
@@ -641,17 +641,17 @@ discard block |
||
641 | 641 | $table_name, |
642 | 642 | $values, |
643 | 643 | array( |
644 | - '%s',//PMD_type |
|
645 | - '%s',//PMD_name |
|
646 | - '%s',//PMD_admin_name |
|
647 | - '%s',//PMD_admin_desc |
|
648 | - '%s',//PMD_slug |
|
649 | - '%d',//PMD_wp_user |
|
650 | - '%s',//PMD_scope |
|
644 | + '%s', //PMD_type |
|
645 | + '%s', //PMD_name |
|
646 | + '%s', //PMD_admin_name |
|
647 | + '%s', //PMD_admin_desc |
|
648 | + '%s', //PMD_slug |
|
649 | + '%d', //PMD_wp_user |
|
650 | + '%s', //PMD_scope |
|
651 | 651 | ) |
652 | 652 | ); |
653 | - if( ! $success ){ |
|
654 | - $this->add_error(sprintf(__("Could not insert new admin-only payment method with values %s during migration", "event_espresso"),$this->_json_encode($values))); |
|
653 | + if ( ! $success) { |
|
654 | + $this->add_error(sprintf(__("Could not insert new admin-only payment method with values %s during migration", "event_espresso"), $this->_json_encode($values))); |
|
655 | 655 | } |
656 | 656 | } |
657 | 657 | } |
@@ -670,11 +670,11 @@ discard block |
||
670 | 670 | |
671 | 671 | global $wpdb; |
672 | 672 | $currency_table = $wpdb->prefix."esp_currency"; |
673 | - if ( $wpdb->get_var( "SHOW TABLES LIKE '" . $currency_table . "'") == $currency_table ) { |
|
673 | + if ($wpdb->get_var("SHOW TABLES LIKE '".$currency_table."'") == $currency_table) { |
|
674 | 674 | |
675 | 675 | $SQL = "SELECT COUNT('CUR_code') FROM $currency_table"; |
676 | 676 | $countries = $wpdb->get_var($SQL); |
677 | - if ( ! $countries ) { |
|
677 | + if ( ! $countries) { |
|
678 | 678 | $SQL = "INSERT INTO $currency_table |
679 | 679 | ( CUR_code, CUR_single, CUR_plural, CUR_sign, CUR_dec_plc, CUR_active) VALUES |
680 | 680 | ( 'EUR', 'Euro', 'Euros', '€', 2,1), |
@@ -65,11 +65,11 @@ |
||
65 | 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 | 71 | return false;//changed mind. dont want people thinking they should migrate yet because they cant |
72 | - }else{ |
|
72 | + } else{ |
|
73 | 73 | // echo "$version_string doesnt apply"; |
74 | 74 | return false; |
75 | 75 | } |
@@ -17,7 +17,7 @@ |
||
17 | 17 | */ |
18 | 18 | /** |
19 | 19 | */ |
20 | -class EE_DMS_Unknown_1_0_0 extends EE_Data_Migration_Script_Base{ |
|
20 | +class EE_DMS_Unknown_1_0_0 extends EE_Data_Migration_Script_Base { |
|
21 | 21 | |
22 | 22 | /** |
23 | 23 | * Returns whether or not this data migration script can operate on the given version of the database. |
@@ -34,7 +34,7 @@ discard block |
||
34 | 34 | * _migration_step() (ie, it its a count of rows in the old attendees table in _count_records_to_migrate(), it should also be OLD attendee rows migrated |
35 | 35 | * on each call to _migration_step(). |
36 | 36 | */ |
37 | -abstract class EE_Data_Migration_Script_Stage extends EE_Data_Migration_Class_Base{ |
|
37 | +abstract class EE_Data_Migration_Script_Stage extends EE_Data_Migration_Class_Base { |
|
38 | 38 | /** |
39 | 39 | * The migration script this is a stage of |
40 | 40 | * @var EE_Data_Migration_Script_Base |
@@ -47,7 +47,7 @@ discard block |
||
47 | 47 | * called by EE_Data_Migration_Script_Base's __construct() method so children don't have to |
48 | 48 | * @param EE_Data_Migration_Script_Base $migration_script |
49 | 49 | */ |
50 | - public function _construct_finalize($migration_script){ |
|
50 | + public function _construct_finalize($migration_script) { |
|
51 | 51 | $this->_migration_script = $migration_script; |
52 | 52 | } |
53 | 53 | |
@@ -58,13 +58,13 @@ discard block |
||
58 | 58 | * @param int $num_items_to_migrate |
59 | 59 | * @return int |
60 | 60 | */ |
61 | - public function migration_step($num_items_to_migrate=50){ |
|
61 | + public function migration_step($num_items_to_migrate = 50) { |
|
62 | 62 | //before we run the migration step, we want ot take note of warnings that get outputted |
63 | 63 | ob_start(); |
64 | 64 | $items_migrated = $this->_migration_step($num_items_to_migrate); |
65 | 65 | $output = ob_get_contents(); |
66 | 66 | ob_end_clean(); |
67 | - if( $output ){ |
|
67 | + if ($output) { |
|
68 | 68 | $this->add_error($output); |
69 | 69 | } |
70 | 70 | $this->_records_migrated += $items_migrated; |
@@ -82,7 +82,7 @@ discard block |
||
82 | 82 | * @param int $num_items_to_migrate |
83 | 83 | * @return int number of items ACTUALLY migrated |
84 | 84 | */ |
85 | - abstract protected function _migration_step($num_items_to_migrate=50); |
|
85 | + abstract protected function _migration_step($num_items_to_migrate = 50); |
|
86 | 86 | |
87 | 87 | /** |
88 | 88 | * Counts the records that have been migrated so far |
@@ -96,7 +96,7 @@ discard block |
||
96 | 96 | * returns an array of strings describing errors |
97 | 97 | * @return array |
98 | 98 | */ |
99 | - public function get_errors(){ |
|
99 | + public function get_errors() { |
|
100 | 100 | return $this->_errors; |
101 | 101 | } |
102 | 102 | |
@@ -106,9 +106,9 @@ discard block |
||
106 | 106 | * to have been made from the properties_as_array() function. |
107 | 107 | * @param array $array_of_properties like what's produced from properties_as_array() method |
108 | 108 | */ |
109 | - public function instantiate_from_array_of_properties($array_of_properties){ |
|
109 | + public function instantiate_from_array_of_properties($array_of_properties) { |
|
110 | 110 | unset($array_of_properties['class']); |
111 | - foreach($array_of_properties as $property_name => $property_value){ |
|
111 | + foreach ($array_of_properties as $property_name => $property_value) { |
|
112 | 112 | $this->$property_name = $property_value; |
113 | 113 | } |
114 | 114 | } |
@@ -117,7 +117,7 @@ discard block |
||
117 | 117 | * Gets the script this is a stage of |
118 | 118 | * @return EE_Data_Migration_Script_Base |
119 | 119 | */ |
120 | - protected function get_migration_script(){ |
|
120 | + protected function get_migration_script() { |
|
121 | 121 | return $this->_migration_script; |
122 | 122 | } |
123 | 123 | } |