Completed
Branch FET-Wait-List (ad2a06)
by
unknown
97:18 queued 85:39
created
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.
4_2_0_stages/EE_DMS_4_2_0_datetime_fields.dmsstage.php 1 patch
Spacing   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -5,7 +5,7 @@  discard block
 block discarded – undo
5 5
  * The name is set to just be a string representation of the start date (in UTC time for now), and the description is just left blank
6 6
 */
7 7
 
8
-class EE_DMS_4_2_0_datetime_fields extends EE_Data_Migration_Script_Stage_Table{
8
+class EE_DMS_4_2_0_datetime_fields extends EE_Data_Migration_Script_Stage_Table {
9 9
 	function __construct() {
10 10
 		global $wpdb;
11 11
 		$this->_pretty_name = __("Datetime Fields", "event_espresso");
@@ -25,14 +25,14 @@  discard block
 block discarded – undo
25 25
 				array(
26 26
 					'DTT_ID'=>$old_row['DTT_ID']),
27 27
 				array(
28
-					'%s',//DTT_name,
29
-					'%s',//DTT_description
28
+					'%s', //DTT_name,
29
+					'%s', //DTT_description
30 30
 					),
31 31
 				array(
32
-					'%d',//DTT_ID
32
+					'%d', //DTT_ID
33 33
 					));
34
-		if( FALSE === $updated ){
35
-			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting DTT_name = '' and DTT_description = '' where DTT_ID = %d", 'event_espresso'),$old_row['QST_ID']));
34
+		if (FALSE === $updated) {
35
+			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting DTT_name = '' and DTT_description = '' where DTT_ID = %d", 'event_espresso'), $old_row['QST_ID']));
36 36
 		}
37 37
 		//nothing to map really
38 38
 	}	
Please login to merge, or discard this patch.
4_2_0_stages/EE_DMS_4_2_0_question_group_questions.dmsstage.php 1 patch
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -4,7 +4,7 @@  discard block
 block discarded – undo
4 4
  * Populates the QGQ_order (introduced in this version, 4.2.0) from the QST_order
5 5
 */
6 6
 
7
-class EE_DMS_4_2_0_question_group_questions extends EE_Data_Migration_Script_Stage_Table{
7
+class EE_DMS_4_2_0_question_group_questions extends EE_Data_Migration_Script_Stage_Table {
8 8
 	private $_qgq_table;
9 9
 	function __construct() {
10 10
 		global $wpdb;
@@ -20,12 +20,12 @@  discard block
 block discarded – undo
20 20
 		$updated = $wpdb->update($this->_qgq_table,
21 21
 				array('QGQ_order'=>$old_row['QST_order']),
22 22
 				array('QST_ID'=>$old_row['QST_ID']),
23
-				array('%d',//QGQ_order
23
+				array('%d', //QGQ_order
24 24
 					),
25
-				array('%d',//QST_ID
25
+				array('%d', //QST_ID
26 26
 					));
27
-		if( FALSE === $updated ){
28
-			$this->add_error(sprintf(__("Error in updating table {$this->_qgq_table} setting QGQ_order = %d where QST_ID = %d", 'event_espresso'),$old_row['QST_order'],$old_row['QST_ID']));
27
+		if (FALSE === $updated) {
28
+			$this->add_error(sprintf(__("Error in updating table {$this->_qgq_table} setting QGQ_order = %d where QST_ID = %d", 'event_espresso'), $old_row['QST_order'], $old_row['QST_ID']));
29 29
 		}
30 30
 		//nothing to map really
31 31
 	}	
Please login to merge, or discard this patch.
4_3_0_stages/EE_DMS_4_3_0_event_message_templates.dmsstage.php 3 patches
Indentation   +15 added lines, -15 removed lines patch added patch discarded remove patch
@@ -41,19 +41,19 @@  discard block
 block discarded – undo
41 41
  		//foreach row that has an evt_id ..let's create an equivalent entry in the new event_messages_template table to link the message template to the event (since EVT_ID is no longer referenced in esp_message_template_groups )
42 42
  		global $wpdb;
43 43
  		if ( $old_row['EVT_ID'] > 0 ) {
44
-                                    //let's get the EVT for this id so we can update the custom name on the old row.
45
-                                    $event_name = 'Custom Template for ' . $wpdb->get_var( $wpdb->prepare( "SELECT post_title from $wpdb->posts WHERE ID = %d", absint( $old_row['EVT_ID'] ) ) );
44
+									//let's get the EVT for this id so we can update the custom name on the old row.
45
+									$event_name = 'Custom Template for ' . $wpdb->get_var( $wpdb->prepare( "SELECT post_title from $wpdb->posts WHERE ID = %d", absint( $old_row['EVT_ID'] ) ) );
46 46
 
47
-                                    //update name
48
-                                    $updated = $wpdb->update(
49
-                                        $this->_old_table,
50
-                                        array(
51
-                                            'MTP_name' =>$event_name
52
-                                            ),
53
-                                        array( 'GRP_ID' => (int) $old_row['GRP_ID'] ),
54
-                                        array( '%s' ),
55
-                                        array( '%d' )
56
-                                        );
47
+									//update name
48
+									$updated = $wpdb->update(
49
+										$this->_old_table,
50
+										array(
51
+											'MTP_name' =>$event_name
52
+											),
53
+										array( 'GRP_ID' => (int) $old_row['GRP_ID'] ),
54
+										array( '%s' ),
55
+										array( '%d' )
56
+										);
57 57
 
58 58
  			$inserted = $wpdb->insert(
59 59
  				$this->_emt_table,
@@ -64,9 +64,9 @@  discard block
 block discarded – undo
64 64
  				array( '%d', '%d' )
65 65
  				);
66 66
 
67
-                                    if ( FALSE === $updated ) {
68
-                                        $this->add_error( sprintf( __("Error in updating the row in %s setting 'MTP_name = %s", 'event_espresso'), $this->_old_table, $event_name ) );
69
-                                    }
67
+									if ( FALSE === $updated ) {
68
+										$this->add_error( sprintf( __("Error in updating the row in %s setting 'MTP_name = %s", 'event_espresso'), $this->_old_table, $event_name ) );
69
+									}
70 70
 
71 71
  			if ( FALSE === $inserted ) {
72 72
  				$this->add_error( sprintf( __("Error in inserting a row into  setting EVT_ID = %d and GRP_ID = %d", "event_espresso"), $this->_emt_table, $old_row['EVT_ID'], $old_row['GRP_ID'] ) );
Please login to merge, or discard this patch.
Spacing   +11 added lines, -11 removed lines patch added patch discarded remove patch
@@ -37,12 +37,12 @@  discard block
 block discarded – undo
37 37
 
38 38
 
39 39
 
40
- 	protected function _migrate_old_row( $old_row ) {
40
+ 	protected function _migrate_old_row($old_row) {
41 41
  		//foreach row that has an evt_id ..let's create an equivalent entry in the new event_messages_template table to link the message template to the event (since EVT_ID is no longer referenced in esp_message_template_groups )
42 42
  		global $wpdb;
43
- 		if ( $old_row['EVT_ID'] > 0 ) {
43
+ 		if ($old_row['EVT_ID'] > 0) {
44 44
                                     //let's get the EVT for this id so we can update the custom name on the old row.
45
-                                    $event_name = 'Custom Template for ' . $wpdb->get_var( $wpdb->prepare( "SELECT post_title from $wpdb->posts WHERE ID = %d", absint( $old_row['EVT_ID'] ) ) );
45
+                                    $event_name = 'Custom Template for '.$wpdb->get_var($wpdb->prepare("SELECT post_title from $wpdb->posts WHERE ID = %d", absint($old_row['EVT_ID'])));
46 46
 
47 47
                                     //update name
48 48
                                     $updated = $wpdb->update(
@@ -50,9 +50,9 @@  discard block
 block discarded – undo
50 50
                                         array(
51 51
                                             'MTP_name' =>$event_name
52 52
                                             ),
53
-                                        array( 'GRP_ID' => (int) $old_row['GRP_ID'] ),
54
-                                        array( '%s' ),
55
-                                        array( '%d' )
53
+                                        array('GRP_ID' => (int) $old_row['GRP_ID']),
54
+                                        array('%s'),
55
+                                        array('%d')
56 56
                                         );
57 57
 
58 58
  			$inserted = $wpdb->insert(
@@ -61,15 +61,15 @@  discard block
 block discarded – undo
61 61
  					'EVT_ID' => (int) $old_row['EVT_ID'],
62 62
  					'GRP_ID' => (int) $old_row['GRP_ID'],
63 63
  					),
64
- 				array( '%d', '%d' )
64
+ 				array('%d', '%d')
65 65
  				);
66 66
 
67
-                                    if ( FALSE === $updated ) {
68
-                                        $this->add_error( sprintf( __("Error in updating the row in %s setting 'MTP_name = %s", 'event_espresso'), $this->_old_table, $event_name ) );
67
+                                    if (FALSE === $updated) {
68
+                                        $this->add_error(sprintf(__("Error in updating the row in %s setting 'MTP_name = %s", 'event_espresso'), $this->_old_table, $event_name));
69 69
                                     }
70 70
 
71
- 			if ( FALSE === $inserted ) {
72
- 				$this->add_error( sprintf( __("Error in inserting a row into  setting EVT_ID = %d and GRP_ID = %d", "event_espresso"), $this->_emt_table, $old_row['EVT_ID'], $old_row['GRP_ID'] ) );
71
+ 			if (FALSE === $inserted) {
72
+ 				$this->add_error(sprintf(__("Error in inserting a row into  setting EVT_ID = %d and GRP_ID = %d", "event_espresso"), $this->_emt_table, $old_row['EVT_ID'], $old_row['GRP_ID']));
73 73
  			}
74 74
  		}
75 75
  	}
Please login to merge, or discard this patch.
Braces   +3 added lines, -1 removed lines patch added patch discarded remove patch
@@ -5,7 +5,9 @@
 block discarded – undo
5 5
  * @subpackage 	migrations
6 6
  * @since 			4.3
7 7
  */
8
- if ( ! defined('EVENT_ESPRESSO_VERSION')) exit('No direct script access allowed');
8
+ if ( ! defined('EVENT_ESPRESSO_VERSION')) {
9
+ 	exit('No direct script access allowed');
10
+ }
9 11
 
10 12
 
11 13
 /**
Please login to merge, or discard this patch.
4_3_0_stages/EE_DMS_4_3_0_question_option_order.dmsstage.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -19,12 +19,12 @@
 block discarded – undo
19 19
 		$updated = $wpdb->update($this->_old_table,
20 20
 				array('QSO_order'=>$old_row['QSO_ID']),
21 21
 				array('QSO_ID'=>$old_row['QSO_ID']),
22
-				array('%d',//QSO_order
22
+				array('%d', //QSO_order
23 23
 					),
24
-				array('%d',//QSO_ID
24
+				array('%d', //QSO_ID
25 25
 					));
26
-		if ( FALSE === $updated ) {
27
-			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting QSO_order = %d where QSO_ID = %d", 'event_espresso'),$old_row['QSO_ID'],$old_row['QSO_ID']));
26
+		if (FALSE === $updated) {
27
+			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting QSO_order = %d where QSO_ID = %d", 'event_espresso'), $old_row['QSO_ID'], $old_row['QSO_ID']));
28 28
 		}
29 29
 	}
30 30
 }
31 31
\ No newline at end of file
Please login to merge, or discard this patch.
4_5_0_stages/EE_DMS_4_5_0_invoice_settings.dmsstage.php 2 patches
Braces   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -64,7 +64,7 @@
 block discarded – undo
64 64
 		$invoice_settings = isset( EE_Config::instance()->gateway->payment_settings[ 'Invoice' ] ) ? EE_Config::instance()->gateway->payment_settings[ 'Invoice' ] : NULL;
65 65
 		if( ! $invoice_settings ){
66 66
 			$this->add_error( __( 'Could not migrate EE4.4 invoice settings to EE4.5 because they didnt exist', 'event_espresso' ) );
67
-		}else{
67
+		} else{
68 68
 			$invoice_settings[ 'template_payment_instructions' ] = $invoice_settings[ 'pdf_instructions' ];
69 69
 			$invoice_settings[ 'template_invoice_payee_name' ] = $invoice_settings[ 'payable_to' ];
70 70
 			$invoice_settings[ 'template_invoice_address' ] = $invoice_settings[ 'payment_address' ];
Please login to merge, or discard this patch.
Spacing   +24 added lines, -24 removed lines patch added patch discarded remove patch
@@ -29,7 +29,7 @@  discard block
 block discarded – undo
29 29
 	 * Just initializes the status of the migration
30 30
 	 */
31 31
 	public function __construct() {
32
-		$this->_pretty_name = __( 'Update Invoice Gateway Settings', 'event_espresso' );
32
+		$this->_pretty_name = __('Update Invoice Gateway Settings', 'event_espresso');
33 33
 		parent::__construct();
34 34
 	}
35 35
 
@@ -56,39 +56,39 @@  discard block
 block discarded – undo
56 56
 	 * @throws EE_Error
57 57
 	 * @return int number of items ACTUALLY migrated
58 58
 	 */
59
-	protected function _migration_step( $num_items = 1 ){
59
+	protected function _migration_step($num_items = 1) {
60 60
 		// if this isn't set then something is really wrong
61
-		if ( ! EE_Config::instance()->gateway instanceof EE_Gateway_Config ) {
62
-			throw new EE_Error( __( 'It appears the Event Espresso Core Configuration is not setup correctly.', 'event_espresso' ));
61
+		if ( ! EE_Config::instance()->gateway instanceof EE_Gateway_Config) {
62
+			throw new EE_Error(__('It appears the Event Espresso Core Configuration is not setup correctly.', 'event_espresso'));
63 63
 		}
64
-		$invoice_settings = isset( EE_Config::instance()->gateway->payment_settings[ 'Invoice' ] ) ? EE_Config::instance()->gateway->payment_settings[ 'Invoice' ] : NULL;
65
-		if( ! $invoice_settings ){
66
-			$this->add_error( __( 'Could not migrate EE4.4 invoice settings to EE4.5 because they didnt exist', 'event_espresso' ) );
67
-		}else{
68
-			$invoice_settings[ 'template_payment_instructions' ] = $invoice_settings[ 'pdf_instructions' ];
69
-			$invoice_settings[ 'template_invoice_payee_name' ] = $invoice_settings[ 'payable_to' ];
70
-			$invoice_settings[ 'template_invoice_address' ] = $invoice_settings[ 'payment_address' ];
71
-			$invoice_settings[ 'template_invoice_email' ] = '';
72
-			$invoice_settings[ 'template_invoice_tax_number' ] = '';
73
-			unset( $invoice_settings[ 'pdf_instructions' ] );
74
-			unset( $invoice_settings[ 'payable_to' ] );
75
-			unset( $invoice_settings[ 'payment_address' ] );
76
-			EE_Config::instance()->gateway->payment_settings[ 'Invoice' ] = $invoice_settings;
77
-			EE_Config::instance()->update_espresso_config(false,false);
64
+		$invoice_settings = isset(EE_Config::instance()->gateway->payment_settings['Invoice']) ? EE_Config::instance()->gateway->payment_settings['Invoice'] : NULL;
65
+		if ( ! $invoice_settings) {
66
+			$this->add_error(__('Could not migrate EE4.4 invoice settings to EE4.5 because they didnt exist', 'event_espresso'));
67
+		} else {
68
+			$invoice_settings['template_payment_instructions'] = $invoice_settings['pdf_instructions'];
69
+			$invoice_settings['template_invoice_payee_name'] = $invoice_settings['payable_to'];
70
+			$invoice_settings['template_invoice_address'] = $invoice_settings['payment_address'];
71
+			$invoice_settings['template_invoice_email'] = '';
72
+			$invoice_settings['template_invoice_tax_number'] = '';
73
+			unset($invoice_settings['pdf_instructions']);
74
+			unset($invoice_settings['payable_to']);
75
+			unset($invoice_settings['payment_address']);
76
+			EE_Config::instance()->gateway->payment_settings['Invoice'] = $invoice_settings;
77
+			EE_Config::instance()->update_espresso_config(false, false);
78 78
 
79 79
 			//@todo: check 'invoice_css' too because we can't easily affect that so we might need to set a persistent notice
80 80
 			//(why is it tough to change? because we want to update the receipt and invoice message template, but
81 81
 			//message templates are only initialized AFTER migrations and those two are new in 4.5. So if we wanted to
82 82
 			//update them from a DMS, we'd need to have the DMS create the message templates which is quite a lot of code;
83 83
 			//also we don't want to build a dependency on the messages code because it is likely to change soon
84
-			if( ! in_array( $invoice_settings[ 'invoice_css' ], array( '', 'simple.css' ) ) ){
85
-				EE_Error::add_persistent_admin_notice( 'invoice_css_not_updated', sprintf( __( 'You had previously set your Invoice Payment Method\'s stylesheet to be %1$s, but that setting has moved. PDF and HTML Invoices and Receipts are now Messages, which means you can easily modify them from your Wordpress Dashboard instead of using filters or uploading template files. Please visit Messages -> Receipt and Messages -> Invoice to change their stylesheets.', 'event_espresso'), $invoice_settings[ 'invoice_css' ] ), FALSE );
84
+			if ( ! in_array($invoice_settings['invoice_css'], array('', 'simple.css'))) {
85
+				EE_Error::add_persistent_admin_notice('invoice_css_not_updated', sprintf(__('You had previously set your Invoice Payment Method\'s stylesheet to be %1$s, but that setting has moved. PDF and HTML Invoices and Receipts are now Messages, which means you can easily modify them from your Wordpress Dashboard instead of using filters or uploading template files. Please visit Messages -> Receipt and Messages -> Invoice to change their stylesheets.', 'event_espresso'), $invoice_settings['invoice_css']), FALSE);
86 86
 			}
87 87
 			$templates_relative_path = 'modules/gateways/Invoice/lib/templates/';
88
-			$overridden_invoice_body = EEH_Template::locate_template( $templates_relative_path . 'invoice_body.template.php', NULL, FALSE, FALSE, TRUE );
89
-			$overridden_receipt_body= EEH_Template::locate_template( $templates_relative_path . 'receipt_body.template.php', NULL, FALSE, FALSE, TRUE );
90
-			if( $overridden_invoice_body || $overridden_receipt_body ) {
91
-				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. We recommend deleting your old Invoice/Receipt templates and modifying the new Invoice and Receipt messages\'s content in Messages -> Invoice and Messages -> Receipt.')), TRUE );
88
+			$overridden_invoice_body = EEH_Template::locate_template($templates_relative_path.'invoice_body.template.php', NULL, FALSE, FALSE, TRUE);
89
+			$overridden_receipt_body = EEH_Template::locate_template($templates_relative_path.'receipt_body.template.php', NULL, FALSE, FALSE, TRUE);
90
+			if ($overridden_invoice_body || $overridden_receipt_body) {
91
+				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. We recommend deleting your old Invoice/Receipt templates and modifying the new Invoice and Receipt messages\'s content in Messages -> Invoice and Messages -> Receipt.')), TRUE);
92 92
 			}
93 93
 
94 94
 		}
Please login to merge, or discard this patch.
4_5_0_stages/EE_DMS_4_5_0_update_wp_user_for_price_types.dmsstage.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -21,12 +21,12 @@
 block discarded – undo
21 21
 		$updated = $wpdb->update($this->_old_table,
22 22
 				array('PRT_wp_user'=>$user_id),
23 23
 				array('PRT_ID'=>$old_row['PRT_ID']),
24
-				array('%d',//PRT_wp_user
24
+				array('%d', //PRT_wp_user
25 25
 					),
26
-				array('%d',//PRT_ID
26
+				array('%d', //PRT_ID
27 27
 					));
28
-		if ( FALSE === $updated ) {
29
-			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting PRT_wp_user = %d where PRT_ID = %d", 'event_espresso'),$user_id,$old_row['PRT_ID']));
28
+		if (FALSE === $updated) {
29
+			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting PRT_wp_user = %d where PRT_ID = %d", 'event_espresso'), $user_id, $old_row['PRT_ID']));
30 30
 		}
31 31
 	}
32 32
 }
Please login to merge, or discard this patch.
4_5_0_stages/EE_DMS_4_5_0_update_wp_user_for_prices.dmsstage.php 1 patch
Spacing   +4 added lines, -4 removed lines patch added patch discarded remove patch
@@ -21,12 +21,12 @@
 block discarded – undo
21 21
 		$updated = $wpdb->update($this->_old_table,
22 22
 				array('PRC_wp_user'=>$user_id),
23 23
 				array('PRC_ID'=>$old_row['PRC_ID']),
24
-				array('%d',//PRC_wp_user
24
+				array('%d', //PRC_wp_user
25 25
 					),
26
-				array('%d',//PRC_ID
26
+				array('%d', //PRC_ID
27 27
 					));
28
-		if ( FALSE === $updated ) {
29
-			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting PRC_wp_user = %d where PRC_ID = %d", 'event_espresso'),$user_id,$old_row['PRC_ID']));
28
+		if (FALSE === $updated) {
29
+			$this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting PRC_wp_user = %d where PRC_ID = %d", 'event_espresso'), $user_id, $old_row['PRC_ID']));
30 30
 		}
31 31
 	}
32 32
 }
Please login to merge, or discard this patch.