Completed
Branch BUG-9583-fix-fetching-term-rel... (646110)
by
unknown
539:15 queued 523:53
created
core/admin/templates/admin_reports.template.php 1 patch
Spacing   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -1,6 +1,6 @@
 block discarded – undo
1 1
 <?php //EEH_Debug_Tools::printr( $admin_reports, '$admin_reports' ); ?>
2 2
 
3
-<?php foreach ( $admin_reports as $report) : ?>
3
+<?php foreach ($admin_reports as $report) : ?>
4 4
 
5 5
 	<div id="<?php echo $report; ?>" class="admin-report-chart-dv" style="width:95%; min-height:420px; margin:20px 4% 40px 1%;"></div>
6 6
 
Please login to merge, or discard this patch.
core/admin/templates/espresso_ratings_request_content.template.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -1,5 +1,5 @@
 block discarded – undo
1 1
 <div class="padding">
2
-	<p><?php _e( 'We need your help to continue maintaining and providing this plugin for free. You can help by leaving a positive review in the WordPress plugin directory. 5 star ratings bring Event Espresso Decaf to the attention of more users which increases our support and features for this version of Event Espresso.', 'event_espresso' ); ?></p>
3
-	<p><?php _e( 'Rate it five stars today!', 'event_espresso' ); ?></p><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span>
4
-	<p><a class="button button-primary" href="https://wordpress.org/plugins/event-espresso-decaf/"><?php _e( 'Rate It!', 'event_espresso' ); ?></a></p>
2
+	<p><?php _e('We need your help to continue maintaining and providing this plugin for free. You can help by leaving a positive review in the WordPress plugin directory. 5 star ratings bring Event Espresso Decaf to the attention of more users which increases our support and features for this version of Event Espresso.', 'event_espresso'); ?></p>
3
+	<p><?php _e('Rate it five stars today!', 'event_espresso'); ?></p><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span><span class="ee-wp-blue dashicons dashicons-star-filled"></span>
4
+	<p><a class="button button-primary" href="https://wordpress.org/plugins/event-espresso-decaf/"><?php _e('Rate It!', 'event_espresso'); ?></a></p>
5 5
 </div>
6 6
\ No newline at end of file
Please login to merge, or discard this patch.
core/admin/templates/status_dropdown.template.php 1 patch
Spacing   +2 added lines, -2 removed lines patch added patch discarded remove patch
@@ -3,8 +3,8 @@
 block discarded – undo
3 3
 	<span id="localized_status_save"><?php echo $localized_status_save; ?></span>
4 4
 	<span id="cur_stat_id"><?php echo $cur_status; ?></span>
5 5
 	<select name='ee_post_status' id='ee_post_status'>
6
- 	<?php foreach ( $statuses as $status => $label ) : ?>
7
-		<option<?php selected( $cur_status, $status ); ?> value='<?php echo $status; ?>'><?php echo $label; ?></option>
6
+ 	<?php foreach ($statuses as $status => $label) : ?>
7
+		<option<?php selected($cur_status, $status); ?> value='<?php echo $status; ?>'><?php echo $label; ?></option>
8 8
 	<?php
9 9
 	endforeach;
10 10
 	?>
Please login to merge, or discard this patch.
4_1_0_stages/EE_DMS_4_1_0_category_details.dmsstage.php 1 patch
Spacing   +7 added lines, -7 removed lines patch added patch discarded remove patch
@@ -6,16 +6,16 @@  discard block
 block discarded – undo
6 6
  * Authorize.net AIM, Bank, Check, Invoice, Paypal Pro and Paypal Standard.
7 7
  * 
8 8
  */
9
-class EE_DMS_4_1_0_category_details extends EE_Data_Migration_Script_Stage{
9
+class EE_DMS_4_1_0_category_details extends EE_Data_Migration_Script_Stage {
10 10
 private $_old_table;
11 11
 private $_new_table;
12 12
 private $_new_term_table;
13
-function _migration_step($num_items=50){
13
+function _migration_step($num_items = 50) {
14 14
 	global $wpdb;
15 15
 	$start_at_record = $this->count_records_migrated();
16
-	$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A);
16
+	$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A);
17 17
 	$items_actually_migrated = 0;
18
-	foreach($rows as $category_detail_row){
18
+	foreach ($rows as $category_detail_row) {
19 19
 		$term_and_taxonomy_ids = wp_insert_term(
20 20
 				stripslashes($category_detail_row['category_name']),
21 21
 				'espresso_event_categories',
@@ -23,8 +23,8 @@  discard block
 block discarded – undo
23 23
 					'description'=>  stripslashes($category_detail_row['category_desc']),
24 24
 					'slug'=>$category_detail_row['category_identifier']
25 25
 				));
26
-		if($term_and_taxonomy_ids instanceof WP_Error){
27
-			$this->add_error(sprintf(__("Could not create WP Term_Taxonomy from old category: %s. The Error was: %s", "event_espresso"),  $this->_json_encode($category_detail_row),$term_and_taxonomy_ids->get_error_message()));
26
+		if ($term_and_taxonomy_ids instanceof WP_Error) {
27
+			$this->add_error(sprintf(__("Could not create WP Term_Taxonomy from old category: %s. The Error was: %s", "event_espresso"), $this->_json_encode($category_detail_row), $term_and_taxonomy_ids->get_error_message()));
28 28
 			$items_actually_migrated++;
29 29
 			continue;
30 30
 		}
@@ -34,7 +34,7 @@  discard block
 block discarded – undo
34 34
 		$this->get_migration_script()->set_mapping($this->_old_table, $category_detail_row['id'], $this->_new_table, $term_taxonomy_id);
35 35
 		$items_actually_migrated++;
36 36
 	}
37
-	if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){
37
+	if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
38 38
 		$this->set_completed();
39 39
 	}
40 40
 	return $items_actually_migrated;
Please login to merge, or discard this patch.
4_1_0_stages/EE_DMS_4_1_0_event_category.dmsstage.php 3 patches
Spacing   +20 added lines, -20 removed lines patch added patch discarded remove patch
@@ -28,22 +28,22 @@  discard block
 block discarded – undo
28 28
 
29 29
  *
30 30
  */
31
-class EE_DMS_4_1_0_event_category extends EE_Data_Migration_Script_Stage{
31
+class EE_DMS_4_1_0_event_category extends EE_Data_Migration_Script_Stage {
32 32
 	private $_old_table;
33 33
 	private $_new_table;
34
-	function _migration_step($num_items=50){
34
+	function _migration_step($num_items = 50) {
35 35
 		global $wpdb;
36 36
 		$start_at_record = $this->count_records_migrated();
37
-		$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A);
37
+		$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A);
38 38
 		$items_actually_migrated = 0;
39
-		foreach($rows as $event_venue_rel){
39
+		foreach ($rows as $event_venue_rel) {
40 40
 			$term_relation_id = $this->_add_relation_from_event_to_term_taxonomy($event_venue_rel);
41
-			if($term_relation_id){
41
+			if ($term_relation_id) {
42 42
 				$this->get_migration_script()->set_mapping($this->_old_table, $event_venue_rel['id'], $this->_new_table, $term_relation_id);
43 43
 			}
44 44
 			$items_actually_migrated++;
45 45
 		}
46
-		if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){
46
+		if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
47 47
 			$this->set_completed();
48 48
 		}
49 49
 		return $items_actually_migrated;
@@ -67,16 +67,16 @@  discard block
 block discarded – undo
67 67
 	 * @param array $old_event_cat_relation
68 68
 	 * @return int
69 69
 	 */
70
-	private function _add_relation_from_event_to_term_taxonomy($old_event_cat_relation){
70
+	private function _add_relation_from_event_to_term_taxonomy($old_event_cat_relation) {
71 71
 		global $wpdb;
72 72
 		$new_event_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_detail", intval($old_event_cat_relation['event_id']), $wpdb->prefix."posts");
73 73
 		$new_term_taxonomy_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_category_detail", intval($old_event_cat_relation['cat_id']), $wpdb->prefix."term_taxonomy");
74
-		if( ! $new_event_id){
75
-			$this->add_error(sprintf(__("Could not find 4.1 event id for 3.1 event #%d.", "event_espresso"),$old_event_cat_relation['event_id']));
74
+		if ( ! $new_event_id) {
75
+			$this->add_error(sprintf(__("Could not find 4.1 event id for 3.1 event #%d.", "event_espresso"), $old_event_cat_relation['event_id']));
76 76
 			return 0;
77 77
 		}
78
-		if( ! $new_term_taxonomy_id){
79
-			$this->add_error(sprintf(__("Could not find 4.1 term-taxonomy id for 3.1 category #%d.", "event_espresso"),$old_event_cat_relation['cat_id']));
78
+		if ( ! $new_term_taxonomy_id) {
79
+			$this->add_error(sprintf(__("Could not find 4.1 term-taxonomy id for 3.1 category #%d.", "event_espresso"), $old_event_cat_relation['cat_id']));
80 80
 			return 0;
81 81
 		}
82 82
 		$cols_n_values = array(
@@ -85,19 +85,19 @@  discard block
 block discarded – undo
85 85
 			'term_order'=>0
86 86
 		);
87 87
 		$datatypes = array(
88
-			'%d',//object_id
89
-			'%d',//term_taxonomy_id
90
-			'%d',//term_order
88
+			'%d', //object_id
89
+			'%d', //term_taxonomy_id
90
+			'%d', //term_order
91 91
 		);
92
-		$success = $wpdb->insert($this->_new_table,$cols_n_values,$datatypes);
93
-		if ( ! $success){
92
+		$success = $wpdb->insert($this->_new_table, $cols_n_values, $datatypes);
93
+		if ( ! $success) {
94 94
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_event_cat_relation, $this->_new_table, $cols_n_values, $datatypes));
95 95
 			return 0;
96
-		}else{
96
+		} else {
97 97
 			//increment the term-taxonomie's count
98
-			$success = $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->term_taxonomy} SET count = count +1 WHERE term_taxonomy_id=%d", $new_term_taxonomy_id ) );
99
-			if( ! $success ){
100
-				$this->add_error(sprintf( __( 'Could not increment term_taxonomy\'s count because %s', 'event_espresso' ),$wpdb->last_error));
98
+			$success = $wpdb->query($wpdb->prepare("UPDATE {$wpdb->term_taxonomy} SET count = count +1 WHERE term_taxonomy_id=%d", $new_term_taxonomy_id));
99
+			if ( ! $success) {
100
+				$this->add_error(sprintf(__('Could not increment term_taxonomy\'s count because %s', 'event_espresso'), $wpdb->last_error));
101 101
 			}
102 102
 		}
103 103
 		return $wpdb->insert_id;
Please login to merge, or discard this patch.
Indentation   -2 removed lines patch added patch discarded remove patch
@@ -12,8 +12,6 @@
 block discarded – undo
12 12
   KEY `group_id` (`group_id`),
13 13
   KEY `question_id` (`question_id`)
14 14
 ) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8$$
15
-
16
-
17 15
  * 4.1 question group question model's tables and fields:
18 16
  $this->_tables = array(
19 17
 			'Question_Group_Question'=>new EE_Primary_Table('esp_question_group_question','QGQ_ID')
Please login to merge, or discard this patch.
Braces   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -90,7 +90,7 @@
 block discarded – undo
90 90
 		//so in case teh IPN is arriving later, let's try to process an IPN!
91 91
 		if($_SERVER['REQUEST_METHOD'] == 'POST'){
92 92
 			return $this->handle_ipn($_POST, $transaction );
93
-		}else{
93
+		} else{
94 94
 			return parent::finalize_payment_for( $transaction );
95 95
 		}
96 96
 	}
Please login to merge, or discard this patch.
data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_event_venue.dmsstage.php 2 patches
Indentation   -3 removed lines patch added patch discarded remove patch
@@ -25,9 +25,6 @@
 block discarded – undo
25 25
 				
26 26
 			)
27 27
 		);
28
-
29
-
30
-
31 28
  * 
32 29
  */
33 30
 class EE_DMS_4_1_0_event_venue extends EE_Data_Migration_Script_Stage{
Please login to merge, or discard this patch.
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch
@@ -30,20 +30,20 @@  discard block
 block discarded – undo
30 30
 
31 31
  * 
32 32
  */
33
-class EE_DMS_4_1_0_event_venue extends EE_Data_Migration_Script_Stage{
33
+class EE_DMS_4_1_0_event_venue extends EE_Data_Migration_Script_Stage {
34 34
 	private $_old_table;
35 35
 	private $_new_table;
36
-	function _migration_step($num_items=50){
36
+	function _migration_step($num_items = 50) {
37 37
 		
38 38
 		global $wpdb;
39 39
 		$start_at_record = $this->count_records_migrated();
40
-		$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A);
40
+		$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A);
41 41
 		$items_actually_migrated = 0;
42
-		foreach($rows as $event_venue_rel){
42
+		foreach ($rows as $event_venue_rel) {
43 43
 			$this->_insert_new_event_to_venue_rel($event_venue_rel);
44 44
 			$items_actually_migrated++;
45 45
 		}
46
-		if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){
46
+		if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
47 47
 			$this->set_completed();
48 48
 		}
49 49
 		return $items_actually_migrated;
@@ -67,26 +67,26 @@  discard block
 block discarded – undo
67 67
 	 * @param array $old_event_venue_rel
68 68
 	 * @return int
69 69
 	 */
70
-	private function _insert_new_event_to_venue_rel($old_event_venue_rel){
70
+	private function _insert_new_event_to_venue_rel($old_event_venue_rel) {
71 71
 		global $wpdb;
72 72
 		$new_event_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_detail", $old_event_venue_rel['event_id'], $wpdb->prefix."posts");
73 73
 		$new_venue_id = $this->get_migration_script()->get_mapping_new_pk($wpdb->prefix."events_venue", $old_event_venue_rel['venue_id'], $wpdb->prefix."posts");
74
-		if( ! $new_event_id){
75
-			$this->add_error(sprintf(__("Could not find 4.1 event id for 3.1 event #%d.", "event_espresso"),$old_event_venue_rel['event_id']));
74
+		if ( ! $new_event_id) {
75
+			$this->add_error(sprintf(__("Could not find 4.1 event id for 3.1 event #%d.", "event_espresso"), $old_event_venue_rel['event_id']));
76 76
 			return 0;
77 77
 		}
78
-		if( ! $new_venue_id){
79
-			$this->add_error(sprintf(__("Could not find 4.1 venue id for 3.1 venue #%d.", "event_espresso"),$old_event_venue_rel['venue_id']));
78
+		if ( ! $new_venue_id) {
79
+			$this->add_error(sprintf(__("Could not find 4.1 venue id for 3.1 venue #%d.", "event_espresso"), $old_event_venue_rel['venue_id']));
80 80
 			return 0;
81 81
 		}
82 82
 		//first ensure there are no other relation entries for this event
83 83
 		//because although EE4 supports it, EE3 didn't really
84
-		$wpdb->delete( $this->_new_table, 
84
+		$wpdb->delete($this->_new_table, 
85 85
 				array(
86 86
 					'EVT_ID' => $new_event_id,
87 87
 				),
88 88
 				array(
89
-					'%d',//EVT_ID
89
+					'%d', //EVT_ID
90 90
 				));
91 91
 //		echo "last query". $wpdb->last_query;die;
92 92
 		$cols_n_values = array(
@@ -95,12 +95,12 @@  discard block
 block discarded – undo
95 95
 			'EVV_primary'=>true
96 96
 		);
97 97
 		$datatypes = array(
98
-			'%d',//EVT_ID
99
-			'%d',//VNU_ID
100
-			'%d',//EVT_primary
98
+			'%d', //EVT_ID
99
+			'%d', //VNU_ID
100
+			'%d', //EVT_primary
101 101
 		);
102
-		$success = $wpdb->insert($this->_new_table,$cols_n_values,$datatypes);
103
-		if ( ! $success){
102
+		$success = $wpdb->insert($this->_new_table, $cols_n_values, $datatypes);
103
+		if ( ! $success) {
104 104
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_event_venue_rel, $this->_new_table, $cols_n_values, $datatypes));
105 105
 			return 0;
106 106
 		}
Please login to merge, or discard this patch.
data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_line_items.dmsstage.php 1 patch
Spacing   +38 added lines, -38 removed lines patch added patch discarded remove patch
@@ -36,7 +36,7 @@  discard block
 block discarded – undo
36 36
 			)
37 37
 		);
38 38
  */
39
-class EE_DMS_4_1_0_line_items extends EE_Data_Migration_Script_Stage_Table{
39
+class EE_DMS_4_1_0_line_items extends EE_Data_Migration_Script_Stage_Table {
40 40
 	private $_new_line_table;
41 41
 	private $_new_transaction_table;
42 42
 	private $_new_reg_table;
@@ -52,21 +52,21 @@  discard block
 block discarded – undo
52 52
 	
53 53
 	protected function _migrate_old_row($old_row) {
54 54
 		//insert line items if its a primary id
55
-		if(intval($old_row['is_primary'])){
55
+		if (intval($old_row['is_primary'])) {
56 56
 			$txn_id = $this->get_migration_script()->get_mapping_new_pk($this->_old_table, $old_row['id'], $this->_new_transaction_table);
57
-			if ( ! $txn_id ){
58
-				$this->add_error(sprintf(__("Could not find the transaction for the 3.1 attendee %d from row %s", "event_espresso"),$old_row['id'],$this->_json_encode($old_row)));
57
+			if ( ! $txn_id) {
58
+				$this->add_error(sprintf(__("Could not find the transaction for the 3.1 attendee %d from row %s", "event_espresso"), $old_row['id'], $this->_json_encode($old_row)));
59 59
 				return;
60 60
 			}
61 61
 			$txn = $this->_get_txn($txn_id);
62
-			$new_line_items = $this->_insert_new_line_items($txn,$old_row);
63
-			$this->get_migration_script()->set_mapping($this->_old_table,$old_row['id'],$this->_new_line_table,$new_line_items);
62
+			$new_line_items = $this->_insert_new_line_items($txn, $old_row);
63
+			$this->get_migration_script()->set_mapping($this->_old_table, $old_row['id'], $this->_new_line_table, $new_line_items);
64 64
 		}
65 65
 	}
66 66
 	
67
-	private function _get_txn($txn_id){
67
+	private function _get_txn($txn_id) {
68 68
 		global $wpdb;
69
-		$txn = $wpdb->get_row($wpdb->prepare("SELECT * FROM $this->_new_transaction_table WHERE TXN_ID=%d",$txn_id),ARRAY_A);
69
+		$txn = $wpdb->get_row($wpdb->prepare("SELECT * FROM $this->_new_transaction_table WHERE TXN_ID=%d", $txn_id), ARRAY_A);
70 70
 		return $txn;
71 71
 	}
72 72
 	
@@ -77,9 +77,9 @@  discard block
 block discarded – undo
77 77
 	 * @param array $transaction
78 78
 	 * @return array new line item ids
79 79
 	 */
80
-	private function _insert_new_line_items($transaction,$old_attendee){
80
+	private function _insert_new_line_items($transaction, $old_attendee) {
81 81
 		global $wpdb;
82
-		$regs_on_this_transaction = $wpdb->get_results($wpdb->prepare("SELECT * FROM ".$this->_new_reg_table." WHERE TXN_ID=%d",$transaction['TXN_ID']),ARRAY_A);
82
+		$regs_on_this_transaction = $wpdb->get_results($wpdb->prepare("SELECT * FROM ".$this->_new_reg_table." WHERE TXN_ID=%d", $transaction['TXN_ID']), ARRAY_A);
83 83
 		$new_line_item_ids = array();
84 84
 		//create a totla line item
85 85
 		$total_line_item_id = $this->_insert_new_line_item(array(
@@ -90,11 +90,11 @@  discard block
 block discarded – undo
90 90
 			'LIN_type'=>'total',
91 91
 			'OBJ_ID'=>$transaction['TXN_ID'],
92 92
 			'OBJ_type'=>'Transaction'
93
-		),$old_attendee);
93
+		), $old_attendee);
94 94
 		$new_line_item_ids[] = $total_line_item_id;
95 95
 		//create a subtotal line item
96 96
 		$reg_total = 0;
97
-		foreach($regs_on_this_transaction as $new_reg){
97
+		foreach ($regs_on_this_transaction as $new_reg) {
98 98
 			$reg_total += floatval($new_reg['REG_final_price']);
99 99
 		}
100 100
 		$subtotal_line_item_id = $this->_insert_new_line_item(array(
@@ -104,26 +104,26 @@  discard block
 block discarded – undo
104 104
 			'LIN_total'=>$reg_total,
105 105
 			'LIN_parent'=>$total_line_item_id,
106 106
 			'LIN_type'=>'sub-total',
107
-		),$old_attendee);
107
+		), $old_attendee);
108 108
 		$new_line_item_ids[] = $subtotal_line_item_id;
109 109
 		//group REGs by TKT_ID
110 110
 		$regs_by_tkt = array();
111
-		foreach($regs_on_this_transaction as $new_reg){
111
+		foreach ($regs_on_this_transaction as $new_reg) {
112 112
 			$regs_by_tkt[$new_reg['TKT_ID']][] = $new_reg;
113 113
 		}
114 114
 		
115 115
 		//create individual line items
116 116
 		
117
-		foreach($regs_by_tkt as $ticket_id => $regs){
117
+		foreach ($regs_by_tkt as $ticket_id => $regs) {
118 118
 			$count = count($regs);
119 119
 			$line_total = 0;
120
-			foreach($regs as $new_reg){
120
+			foreach ($regs as $new_reg) {
121 121
 				$line_total += $new_reg['REG_final_price'];
122 122
 			}
123 123
 			$a_reg = reset($regs);
124 124
 			$new_ticket = $this->_get_new_ticket_row($a_reg['TKT_ID']);
125 125
 			$reg_line_item_id = $this->_insert_new_line_item(array(
126
-				'LIN_code'=> md5( 'Ticket' . $ticket_id . time() ),
126
+				'LIN_code'=> md5('Ticket'.$ticket_id.time()),
127 127
 				'TXN_ID'=>$transaction['TXN_ID'],
128 128
 				'LIN_name'=>$new_ticket['TKT_name'],
129 129
 				'LIN_unit_price'=>$a_reg['REG_final_price'],
@@ -133,7 +133,7 @@  discard block
 block discarded – undo
133 133
 				'LIN_parent'=>$subtotal_line_item_id,
134 134
 				'OBJ_ID'=>$ticket_id,
135 135
 				'OBJ_type'=>'Ticket'
136
-			),$old_attendee);
136
+			), $old_attendee);
137 137
 			$new_line_item_ids[] = $reg_line_item_id;
138 138
 		}
139 139
 		
@@ -147,13 +147,13 @@  discard block
 block discarded – undo
147 147
 	 * @param type $new_ticket_id
148 148
 	 * @return array
149 149
 	 */
150
-	private function _get_new_ticket_row($new_ticket_id){
150
+	private function _get_new_ticket_row($new_ticket_id) {
151 151
 		global $wpdb;
152
-		$ticket_row = $wpdb->get_row($wpdb->prepare("SELECT * FROM ".$wpdb->prefix."esp_ticket WHERE TKT_ID=%d",$new_ticket_id),ARRAY_A);
152
+		$ticket_row = $wpdb->get_row($wpdb->prepare("SELECT * FROM ".$wpdb->prefix."esp_ticket WHERE TKT_ID=%d", $new_ticket_id), ARRAY_A);
153 153
 		return $ticket_row;
154 154
 	}
155 155
 	
156
-	private function _insert_new_line_item($cols_n_values,$old_attendee){
156
+	private function _insert_new_line_item($cols_n_values, $old_attendee) {
157 157
 		global $wpdb;
158 158
 		$default_cols_n_values = array(
159 159
 			'LIN_code'=>'',
@@ -171,25 +171,25 @@  discard block
 block discarded – undo
171 171
 			'OBJ_ID'=>null,
172 172
 			'OBJ_type'=>null
173 173
 		);
174
-		$cols_n_values = array_merge($default_cols_n_values,$cols_n_values);
174
+		$cols_n_values = array_merge($default_cols_n_values, $cols_n_values);
175 175
 			$datatypes = array(
176
-				'%s',//LIN_code
177
-				'%d',//TXN_ID
178
-				'%s',//LIN_name
179
-				'%s',//LIN_desc
180
-				'%f',//LIN_unit_price
181
-				'%f',//LIN_percent
182
-				'%d',//LIN_is_taxable
183
-				'%d',//LIN_order
184
-				'%f',//LIN_total
185
-				'%d',//LIN_quantity
186
-				'%d',//LIN_parent
187
-				'%s',//LIN_type
188
-				'%d',//OBJ_ID
189
-				'%s',//OBJ_type
176
+				'%s', //LIN_code
177
+				'%d', //TXN_ID
178
+				'%s', //LIN_name
179
+				'%s', //LIN_desc
180
+				'%f', //LIN_unit_price
181
+				'%f', //LIN_percent
182
+				'%d', //LIN_is_taxable
183
+				'%d', //LIN_order
184
+				'%f', //LIN_total
185
+				'%d', //LIN_quantity
186
+				'%d', //LIN_parent
187
+				'%s', //LIN_type
188
+				'%d', //OBJ_ID
189
+				'%s', //OBJ_type
190 190
 			);
191
-			$success = $wpdb->insert($this->_new_line_table,$cols_n_values,$datatypes);
192
-			if ( ! $success){
191
+			$success = $wpdb->insert($this->_new_line_table, $cols_n_values, $datatypes);
192
+			if ( ! $success) {
193 193
 				$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_attendee, $this->_new_reg_table, $cols_n_values, $datatypes));
194 194
 				return 0;
195 195
 			}
Please login to merge, or discard this patch.
4_1_0_stages/EE_DMS_4_1_0_question_groups.dmsstage.php 2 patches
Spacing   +25 added lines, -25 removed lines patch added patch discarded remove patch
@@ -38,7 +38,7 @@  discard block
 block discarded – undo
38 38
 		);
39 39
  * 
40 40
  */
41
-class EE_DMS_4_1_0_question_groups extends EE_Data_Migration_Script_Stage{
41
+class EE_DMS_4_1_0_question_groups extends EE_Data_Migration_Script_Stage {
42 42
 	private $_old_table;
43 43
 	private $_new_table;
44 44
 	/**
@@ -49,19 +49,19 @@  discard block
 block discarded – undo
49 49
 	 * @var boolean
50 50
 	 */
51 51
 	private $_already_got_system_question_group_1 = false;
52
-	function _migration_step($num_items=50){
52
+	function _migration_step($num_items = 50) {
53 53
 		
54 54
 		global $wpdb;
55 55
 		$start_at_record = $this->count_records_migrated();
56
-		$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A);
56
+		$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A);
57 57
 		$items_actually_migrated = 0;
58
-		foreach($rows as $question_group){
58
+		foreach ($rows as $question_group) {
59 59
 			$new_id = $this->_insert_new_question_group($question_group);
60 60
 
61 61
 			$this->get_migration_script()->set_mapping($this->_old_table, $question_group['id'], $this->_new_table, $new_id);
62 62
 			$items_actually_migrated++;
63 63
 		}
64
-		if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){
64
+		if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
65 65
 			$this->set_completed();
66 66
 		}
67 67
 		return $items_actually_migrated;
@@ -85,24 +85,24 @@  discard block
 block discarded – undo
85 85
 	 * @param array $old_question_group
86 86
 	 * @return int
87 87
 	 */
88
-	private function _insert_new_question_group($old_question_group){
88
+	private function _insert_new_question_group($old_question_group) {
89 89
 		global $wpdb;
90 90
 		//try to guess what the QST_system int should be... finding the Personal info system
91 91
 		//question group is quite easy. But in 3.1 address info WASN'T a system group, it just exitsed by default but
92 92
 		//could be easily removed.
93
-		if($old_question_group['system_group'] && ! $this->_already_got_system_question_group_1()){
93
+		if ($old_question_group['system_group'] && ! $this->_already_got_system_question_group_1()) {
94 94
 			$guess_at_system_number = 1;
95
-		}elseif($old_question_group['id'] == '2' && strpos($old_question_group['group_name'],'Address')!==FALSE){
95
+		}elseif ($old_question_group['id'] == '2' && strpos($old_question_group['group_name'], 'Address') !== FALSE) {
96 96
 			$guess_at_system_number = 2;
97
-		}else{
97
+		} else {
98 98
 			$guess_at_system_number = 0;
99 99
 		}
100 100
 		//if the question group wasn't made by the normal admin, 
101 101
 		//we'd like to keep track of who made it
102
-		if(intval($old_question_group['wp_user'])!=1){
103
-			$username = $wpdb->get_var($wpdb->prepare("SELECT user_nicename FROM ".$wpdb->users." WHERE ID = %d",$old_question_group['wp_user']));
102
+		if (intval($old_question_group['wp_user']) != 1) {
103
+			$username = $wpdb->get_var($wpdb->prepare("SELECT user_nicename FROM ".$wpdb->users." WHERE ID = %d", $old_question_group['wp_user']));
104 104
 			$identifier = $old_question_group['group_identifier']."-by-".$username;
105
-		}else{
105
+		} else {
106 106
 			$identifier = $old_question_group['group_identifier'];
107 107
 		}
108 108
 		$cols_n_values = array(
@@ -116,17 +116,17 @@  discard block
 block discarded – undo
116 116
 			'QSG_deleted'=>false
117 117
 		);
118 118
 		$datatypes = array(
119
-			'%s',//QSG_name
120
-			'%s',//QSG_identifier
121
-			'%s',//QSG_desc
122
-			'%d',//QSG_order
123
-			'%d',//QSG_show_group_name
124
-			'%d',//QSG_show_group_desc
125
-			'%d',//QSG_system
126
-			'%d',//QSG_deleted
119
+			'%s', //QSG_name
120
+			'%s', //QSG_identifier
121
+			'%s', //QSG_desc
122
+			'%d', //QSG_order
123
+			'%d', //QSG_show_group_name
124
+			'%d', //QSG_show_group_desc
125
+			'%d', //QSG_system
126
+			'%d', //QSG_deleted
127 127
 		);
128
-		$success = $wpdb->insert($this->_new_table,$cols_n_values,$datatypes);
129
-		if ( ! $success){
128
+		$success = $wpdb->insert($this->_new_table, $cols_n_values, $datatypes);
129
+		if ( ! $success) {
130 130
 			$this->add_error($this->get_migration_script()->_create_error_message_for_db_insertion($this->_old_table, $old_question_group, $this->_new_table, $cols_n_values, $datatypes));
131 131
 			return 0;
132 132
 		}
@@ -138,12 +138,12 @@  discard block
 block discarded – undo
138 138
 	 * @global type $wpdb
139 139
 	 * @return boolean
140 140
 	 */
141
-	private function _already_got_system_question_group_1(){
142
-		if( ! $this->_already_got_system_question_group_1 ){
141
+	private function _already_got_system_question_group_1() {
142
+		if ( ! $this->_already_got_system_question_group_1) {
143 143
 			//check the db
144 144
 			global $wpdb;
145 145
 			$exists = $wpdb->get_var("SELECT COUNT(*) FROM {$this->_new_table} WHERE QSG_system=1");
146
-			if(intval($exists)>0){
146
+			if (intval($exists) > 0) {
147 147
 				$this->_already_got_system_question_group_1 = true;
148 148
 			}
149 149
 		}		
Please login to merge, or discard this patch.
Braces   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -92,9 +92,9 @@  discard block
 block discarded – undo
92 92
 		//could be easily removed.
93 93
 		if($old_question_group['system_group'] && ! $this->_already_got_system_question_group_1()){
94 94
 			$guess_at_system_number = 1;
95
-		}elseif($old_question_group['id'] == '2' && strpos($old_question_group['group_name'],'Address')!==FALSE){
95
+		} elseif($old_question_group['id'] == '2' && strpos($old_question_group['group_name'],'Address')!==FALSE){
96 96
 			$guess_at_system_number = 2;
97
-		}else{
97
+		} else{
98 98
 			$guess_at_system_number = 0;
99 99
 		}
100 100
 		//if the question group wasn't made by the normal admin, 
@@ -102,7 +102,7 @@  discard block
 block discarded – undo
102 102
 		if(intval($old_question_group['wp_user'])!=1){
103 103
 			$username = $wpdb->get_var($wpdb->prepare("SELECT user_nicename FROM ".$wpdb->users." WHERE ID = %d",$old_question_group['wp_user']));
104 104
 			$identifier = $old_question_group['group_identifier']."-by-".$username;
105
-		}else{
105
+		} else{
106 106
 			$identifier = $old_question_group['group_identifier'];
107 107
 		}
108 108
 		$cols_n_values = array(
Please login to merge, or discard this patch.
data_migration_scripts/4_1_0_stages/EE_DMS_4_1_0_shortcodes.dmsstage.php 2 patches
Indentation   +1 added lines, -2 removed lines patch added patch discarded remove patch
@@ -2,8 +2,7 @@
 block discarded – undo
2 2
 
3 3
 /**
4 4
  * Goes through all the posts and pages, and converts old shortcodes to new ones
5
-	
6
-*/
5
+ */
7 6
 
8 7
 class EE_DMS_4_1_0_shortcodes extends EE_Data_Migration_Script_Stage{	
9 8
 	function __construct() {
Please login to merge, or discard this patch.
Spacing   +12 added lines, -12 removed lines patch added patch discarded remove patch
@@ -5,7 +5,7 @@  discard block
 block discarded – undo
5 5
 	
6 6
 */
7 7
 
8
-class EE_DMS_4_1_0_shortcodes extends EE_Data_Migration_Script_Stage{	
8
+class EE_DMS_4_1_0_shortcodes extends EE_Data_Migration_Script_Stage {	
9 9
 	function __construct() {
10 10
 		global $wpdb;
11 11
 		$this->_pretty_name = __("Shortcodes", "event_espresso");
@@ -15,13 +15,13 @@  discard block
 block discarded – undo
15 15
 	protected function _migrate_old_row($old_row) {
16 16
 		$new_post_content = $this->_change_event_list_shortcode($old_row['post_content']);
17 17
 		global $wpdb;
18
-		$wpdb->query($wpdb->prepare("UPDATE ".$this->_old_table." SET post_content=%s WHERE ID=%d",$new_post_content,$old_row['ID']));
18
+		$wpdb->query($wpdb->prepare("UPDATE ".$this->_old_table." SET post_content=%s WHERE ID=%d", $new_post_content, $old_row['ID']));
19 19
 		$slug = $old_row['post_name'];
20 20
 		$matches = array();
21
-		$success = preg_match_all('(ESPRESSO_[^ \]]*)',$new_post_content,$matches);;
22
-		if($success){
21
+		$success = preg_match_all('(ESPRESSO_[^ \]]*)', $new_post_content, $matches); ;
22
+		if ($success) {
23 23
 			$shortcodes = $matches[0];
24
-			foreach($shortcodes as $shortcode){
24
+			foreach ($shortcodes as $shortcode) {
25 25
 				EE_Config::instance()->core->post_shortcodes[$slug][$shortcode] = $old_row['ID'];
26 26
 				EE_Config::instance()->core->post_shortcodes['posts'][$shortcode] = $old_row['ID'];
27 27
 			}
@@ -41,20 +41,20 @@  discard block
 block discarded – undo
41 41
 	 * replaces [EVENT_LIST... with [ESPRESSO_EVENTS...]
42 42
 	 * @param string $old_content
43 43
 	 */
44
-	private function _change_event_list_shortcode($old_content){
45
-		return str_replace("[EVENT_LIST","[ESPRESSO_EVENTS",$old_content);
44
+	private function _change_event_list_shortcode($old_content) {
45
+		return str_replace("[EVENT_LIST", "[ESPRESSO_EVENTS", $old_content);
46 46
 	}
47 47
 	
48
-	function _migration_step($num_items=50){
48
+	function _migration_step($num_items = 50) {
49 49
 		global $wpdb;
50 50
 		$start_at_record = $this->count_records_migrated();
51
-		$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table {$this->_sql_to_only_select_non_drafts()} LIMIT %d,%d",$start_at_record,$num_items),ARRAY_A);
51
+		$rows = $wpdb->get_results($wpdb->prepare("SELECT * FROM $this->_old_table {$this->_sql_to_only_select_non_drafts()} LIMIT %d,%d", $start_at_record, $num_items), ARRAY_A);
52 52
 		$items_actually_migrated = 0;
53
-		foreach($rows as $old_row){
53
+		foreach ($rows as $old_row) {
54 54
 			$this->_migrate_old_row($old_row);
55 55
 			$items_actually_migrated++;
56 56
 		}
57
-		if($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()){
57
+		if ($this->count_records_migrated() + $items_actually_migrated >= $this->count_records_to_migrate()) {
58 58
 			$this->set_completed();
59 59
 		}
60 60
 		return $items_actually_migrated;
@@ -65,7 +65,7 @@  discard block
 block discarded – undo
65 65
 		return $count;
66 66
 	}
67 67
 	
68
-	private function _sql_to_only_select_non_drafts(){
68
+	private function _sql_to_only_select_non_drafts() {
69 69
 		return " WHERE post_type NOT IN ('revision','auto-draft') ";
70 70
 	}
71 71
 	
Please login to merge, or discard this patch.