@@ -4,7 +4,7 @@ discard block |
||
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 |
||
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 | } |
@@ -32,7 +32,7 @@ discard block |
||
32 | 32 | * Just initializes the status of the migration |
33 | 33 | */ |
34 | 34 | public function __construct() { |
35 | - $this->_pretty_name = __( 'Update Critical Page Shortcode Tracking', 'event_espresso' ); |
|
35 | + $this->_pretty_name = __('Update Critical Page Shortcode Tracking', 'event_espresso'); |
|
36 | 36 | parent::__construct(); |
37 | 37 | } |
38 | 38 | |
@@ -59,24 +59,24 @@ discard block |
||
59 | 59 | * @throws EE_Error |
60 | 60 | * @return int number of items ACTUALLY migrated |
61 | 61 | */ |
62 | - protected function _migration_step( $num_items = 1 ){ |
|
62 | + protected function _migration_step($num_items = 1) { |
|
63 | 63 | // if this isn't set then something is really wrong |
64 | - if ( ! EE_Config::instance()->core instanceof EE_Core_Config ) { |
|
65 | - throw new EE_Error( __( 'It appears the Event Espresso Core Configuration is not setup correctly.', 'event_espresso' )); |
|
64 | + if ( ! EE_Config::instance()->core instanceof EE_Core_Config) { |
|
65 | + throw new EE_Error(__('It appears the Event Espresso Core Configuration is not setup correctly.', 'event_espresso')); |
|
66 | 66 | } |
67 | 67 | // name of the WP Posts Page |
68 | 68 | $posts_page = $this->_get_page_for_posts(); |
69 | 69 | // make sure critical pages get removed |
70 | - $this->_update_post_shortcodes( $posts_page ); |
|
70 | + $this->_update_post_shortcodes($posts_page); |
|
71 | 71 | // save updated config, but don't add errors |
72 | - if ( ! EE_Config::instance()->update_espresso_config( FALSE, FALSE )) { |
|
73 | - EE_Error::add_error( __( 'The Event Espresso Configuration Settings were not updated when attempting to save the "critical page post shortcodes".', 'event_espresso' ), __FILE__, __FUNCTION__, __LINE__ ); |
|
72 | + if ( ! EE_Config::instance()->update_espresso_config(FALSE, FALSE)) { |
|
73 | + EE_Error::add_error(__('The Event Espresso Configuration Settings were not updated when attempting to save the "critical page post shortcodes".', 'event_espresso'), __FILE__, __FUNCTION__, __LINE__); |
|
74 | 74 | } |
75 | 75 | // check for errors |
76 | - $notices = EE_Error::get_notices( FALSE ); |
|
76 | + $notices = EE_Error::get_notices(FALSE); |
|
77 | 77 | // any errors to report? |
78 | - if( isset( $notices['errors'] )) { |
|
79 | - foreach($notices as $value){ |
|
78 | + if (isset($notices['errors'])) { |
|
79 | + foreach ($notices as $value) { |
|
80 | 80 | $this->add_error($value); |
81 | 81 | } |
82 | 82 | } |
@@ -97,13 +97,13 @@ discard block |
||
97 | 97 | * @return string |
98 | 98 | */ |
99 | 99 | private function _get_page_for_posts() { |
100 | - $page_for_posts = get_option( 'page_for_posts' ); |
|
101 | - if ( ! $page_for_posts ) { |
|
100 | + $page_for_posts = get_option('page_for_posts'); |
|
101 | + if ( ! $page_for_posts) { |
|
102 | 102 | return 'posts'; |
103 | 103 | } |
104 | 104 | global $wpdb; |
105 | - $SQL = 'SELECT post_name from ' . $wpdb->posts . ' WHERE post_type="posts" OR post_type="page" AND post_status="publish" AND ID=%s'; |
|
106 | - return $wpdb->get_var( $wpdb->prepare( $SQL, $page_for_posts )); |
|
105 | + $SQL = 'SELECT post_name from '.$wpdb->posts.' WHERE post_type="posts" OR post_type="page" AND post_status="publish" AND ID=%s'; |
|
106 | + return $wpdb->get_var($wpdb->prepare($SQL, $page_for_posts)); |
|
107 | 107 | } |
108 | 108 | |
109 | 109 | |
@@ -115,45 +115,45 @@ discard block |
||
115 | 115 | * @param $page_for_posts |
116 | 116 | * @return void |
117 | 117 | */ |
118 | - private function _update_post_shortcodes( $page_for_posts = '' ) { |
|
118 | + private function _update_post_shortcodes($page_for_posts = '') { |
|
119 | 119 | // critical page shortcodes that we do NOT want added to the Posts page (blog) |
120 | 120 | $critical_shortcodes = EE_Config::instance()->core->get_critical_pages_shortcodes_array(); |
121 | 121 | // verify that post_shortcodes is set |
122 | - EE_Config::instance()->core->post_shortcodes = isset( EE_Config::instance()->core->post_shortcodes ) && is_array( EE_Config::instance()->core->post_shortcodes ) ? EE_Config::instance()->core->post_shortcodes : array(); |
|
122 | + EE_Config::instance()->core->post_shortcodes = isset(EE_Config::instance()->core->post_shortcodes) && is_array(EE_Config::instance()->core->post_shortcodes) ? EE_Config::instance()->core->post_shortcodes : array(); |
|
123 | 123 | // just in case the site has ever had posts on frontpage at some time, then we should check for a "Posts Page" named "posts" |
124 | - $post_pages_to_check = $page_for_posts == 'posts' ? array( $page_for_posts ) : array( 'posts', $page_for_posts ); |
|
124 | + $post_pages_to_check = $page_for_posts == 'posts' ? array($page_for_posts) : array('posts', $page_for_posts); |
|
125 | 125 | // cycle thru post_shortcodes |
126 | - foreach( $post_pages_to_check as $post_page ){ |
|
126 | + foreach ($post_pages_to_check as $post_page) { |
|
127 | 127 | // cycle thru post_shortcodes |
128 | - foreach( EE_Config::instance()->core->post_shortcodes as $post_name => $shortcodes ){ |
|
128 | + foreach (EE_Config::instance()->core->post_shortcodes as $post_name => $shortcodes) { |
|
129 | 129 | // are there any shortcodes to track ? |
130 | - if ( ! empty( $shortcodes )) { |
|
130 | + if ( ! empty($shortcodes)) { |
|
131 | 131 | // loop thru list of tracked shortcodes |
132 | - foreach( $shortcodes as $shortcode => $post_id ) { |
|
132 | + foreach ($shortcodes as $shortcode => $post_id) { |
|
133 | 133 | // if shortcode is for a critical page, BUT this is NOT the corresponding critical page for that shortcode |
134 | - if ( isset( $critical_shortcodes[ $post_id ] ) && $post_name == $post_page ) { |
|
134 | + if (isset($critical_shortcodes[$post_id]) && $post_name == $post_page) { |
|
135 | 135 | // then remove this shortcode, because we don't want critical page shortcodes like ESPRESSO_TXN_PAGE running on the "Posts Page" (blog) |
136 | - unset( EE_Config::instance()->core->post_shortcodes[ $post_name ][ $shortcode ] ); |
|
136 | + unset(EE_Config::instance()->core->post_shortcodes[$post_name][$shortcode]); |
|
137 | 137 | } |
138 | 138 | // skip the posts page, because we want all shortcodes registered for it |
139 | - if ( $post_name == $post_page ) { |
|
139 | + if ($post_name == $post_page) { |
|
140 | 140 | continue; |
141 | 141 | } |
142 | 142 | // make sure post still exists |
143 | - $post = get_post( $post_id ); |
|
144 | - if ( $post ) { |
|
143 | + $post = get_post($post_id); |
|
144 | + if ($post) { |
|
145 | 145 | // check that the post name matches what we have saved |
146 | - if ( $post->post_name == $post_name ) { |
|
146 | + if ($post->post_name == $post_name) { |
|
147 | 147 | // if so, then break before hitting the unset below |
148 | 148 | continue; |
149 | 149 | } |
150 | 150 | } |
151 | 151 | // we don't like missing posts around here >:( |
152 | - unset( EE_Config::instance()->core->post_shortcodes[ $post_name ] ); |
|
152 | + unset(EE_Config::instance()->core->post_shortcodes[$post_name]); |
|
153 | 153 | } |
154 | 154 | } else { |
155 | 155 | // you got no shortcodes to keep track of ! |
156 | - unset( EE_Config::instance()->core->post_shortcodes[ $post_name ] ); |
|
156 | + unset(EE_Config::instance()->core->post_shortcodes[$post_name]); |
|
157 | 157 | } |
158 | 158 | } |
159 | 159 | } |
@@ -67,8 +67,8 @@ discard block |
||
67 | 67 | // name of the WP Posts Page |
68 | 68 | $posts_page = $this->_get_page_for_posts(); |
69 | 69 | // make sure critical pages get removed |
70 | - $this->_update_post_shortcodes( $posts_page ); |
|
71 | - // save updated config, but don't add errors |
|
70 | + $this->_update_post_shortcodes( $posts_page ); |
|
71 | + // save updated config, but don't add errors |
|
72 | 72 | if ( ! EE_Config::instance()->update_espresso_config( FALSE, FALSE )) { |
73 | 73 | EE_Error::add_error( __( 'The Event Espresso Configuration Settings were not updated when attempting to save the "critical page post shortcodes".', 'event_espresso' ), __FILE__, __FUNCTION__, __LINE__ ); |
74 | 74 | } |
@@ -76,87 +76,87 @@ discard block |
||
76 | 76 | $notices = EE_Error::get_notices( FALSE ); |
77 | 77 | // any errors to report? |
78 | 78 | if( isset( $notices['errors'] )) { |
79 | - foreach($notices as $value){ |
|
79 | + foreach($notices as $value){ |
|
80 | 80 | $this->add_error($value); |
81 | 81 | } |
82 | - } |
|
82 | + } |
|
83 | 83 | //regardless of whether it worked or not, we ought to continue the migration |
84 | 84 | $this->set_completed(); |
85 | - return 1; |
|
85 | + return 1; |
|
86 | 86 | } |
87 | 87 | |
88 | 88 | |
89 | 89 | |
90 | - /** |
|
91 | - * _get_page_for_posts |
|
92 | - * |
|
93 | - * if the wp-option "show_on_front" is set to "page", then this is the post_name for the post set in the wp-option "page_for_posts", or "posts" if no page is selected |
|
94 | - * |
|
95 | - * |
|
96 | - * @access private |
|
97 | - * @return string |
|
98 | - */ |
|
99 | - private function _get_page_for_posts() { |
|
100 | - $page_for_posts = get_option( 'page_for_posts' ); |
|
101 | - if ( ! $page_for_posts ) { |
|
102 | - return 'posts'; |
|
103 | - } |
|
104 | - global $wpdb; |
|
105 | - $SQL = 'SELECT post_name from ' . $wpdb->posts . ' WHERE post_type="posts" OR post_type="page" AND post_status="publish" AND ID=%s'; |
|
106 | - return $wpdb->get_var( $wpdb->prepare( $SQL, $page_for_posts )); |
|
107 | - } |
|
108 | - |
|
109 | - |
|
110 | - |
|
111 | - /** |
|
112 | - * _update_post_shortcodes |
|
113 | - * |
|
114 | - * @access private |
|
115 | - * @param $page_for_posts |
|
116 | - * @return void |
|
117 | - */ |
|
118 | - private function _update_post_shortcodes( $page_for_posts = '' ) { |
|
119 | - // critical page shortcodes that we do NOT want added to the Posts page (blog) |
|
120 | - $critical_shortcodes = EE_Config::instance()->core->get_critical_pages_shortcodes_array(); |
|
121 | - // verify that post_shortcodes is set |
|
122 | - EE_Config::instance()->core->post_shortcodes = isset( EE_Config::instance()->core->post_shortcodes ) && is_array( EE_Config::instance()->core->post_shortcodes ) ? EE_Config::instance()->core->post_shortcodes : array(); |
|
123 | - // just in case the site has ever had posts on frontpage at some time, then we should check for a "Posts Page" named "posts" |
|
124 | - $post_pages_to_check = $page_for_posts == 'posts' ? array( $page_for_posts ) : array( 'posts', $page_for_posts ); |
|
125 | - // cycle thru post_shortcodes |
|
126 | - foreach( $post_pages_to_check as $post_page ){ |
|
127 | - // cycle thru post_shortcodes |
|
128 | - foreach( EE_Config::instance()->core->post_shortcodes as $post_name => $shortcodes ){ |
|
129 | - // are there any shortcodes to track ? |
|
130 | - if ( ! empty( $shortcodes )) { |
|
131 | - // loop thru list of tracked shortcodes |
|
132 | - foreach( $shortcodes as $shortcode => $post_id ) { |
|
133 | - // if shortcode is for a critical page, BUT this is NOT the corresponding critical page for that shortcode |
|
134 | - if ( isset( $critical_shortcodes[ $post_id ] ) && $post_name == $post_page ) { |
|
135 | - // then remove this shortcode, because we don't want critical page shortcodes like ESPRESSO_TXN_PAGE running on the "Posts Page" (blog) |
|
136 | - unset( EE_Config::instance()->core->post_shortcodes[ $post_name ][ $shortcode ] ); |
|
137 | - } |
|
138 | - // skip the posts page, because we want all shortcodes registered for it |
|
139 | - if ( $post_name == $post_page ) { |
|
140 | - continue; |
|
141 | - } |
|
142 | - // make sure post still exists |
|
143 | - $post = get_post( $post_id ); |
|
144 | - if ( $post ) { |
|
145 | - // check that the post name matches what we have saved |
|
146 | - if ( $post->post_name == $post_name ) { |
|
147 | - // if so, then break before hitting the unset below |
|
148 | - continue; |
|
149 | - } |
|
150 | - } |
|
151 | - // we don't like missing posts around here >:( |
|
152 | - unset( EE_Config::instance()->core->post_shortcodes[ $post_name ] ); |
|
153 | - } |
|
154 | - } else { |
|
155 | - // you got no shortcodes to keep track of ! |
|
156 | - unset( EE_Config::instance()->core->post_shortcodes[ $post_name ] ); |
|
157 | - } |
|
158 | - } |
|
159 | - } |
|
90 | + /** |
|
91 | + * _get_page_for_posts |
|
92 | + * |
|
93 | + * if the wp-option "show_on_front" is set to "page", then this is the post_name for the post set in the wp-option "page_for_posts", or "posts" if no page is selected |
|
94 | + * |
|
95 | + * |
|
96 | + * @access private |
|
97 | + * @return string |
|
98 | + */ |
|
99 | + private function _get_page_for_posts() { |
|
100 | + $page_for_posts = get_option( 'page_for_posts' ); |
|
101 | + if ( ! $page_for_posts ) { |
|
102 | + return 'posts'; |
|
103 | + } |
|
104 | + global $wpdb; |
|
105 | + $SQL = 'SELECT post_name from ' . $wpdb->posts . ' WHERE post_type="posts" OR post_type="page" AND post_status="publish" AND ID=%s'; |
|
106 | + return $wpdb->get_var( $wpdb->prepare( $SQL, $page_for_posts )); |
|
107 | + } |
|
108 | + |
|
109 | + |
|
110 | + |
|
111 | + /** |
|
112 | + * _update_post_shortcodes |
|
113 | + * |
|
114 | + * @access private |
|
115 | + * @param $page_for_posts |
|
116 | + * @return void |
|
117 | + */ |
|
118 | + private function _update_post_shortcodes( $page_for_posts = '' ) { |
|
119 | + // critical page shortcodes that we do NOT want added to the Posts page (blog) |
|
120 | + $critical_shortcodes = EE_Config::instance()->core->get_critical_pages_shortcodes_array(); |
|
121 | + // verify that post_shortcodes is set |
|
122 | + EE_Config::instance()->core->post_shortcodes = isset( EE_Config::instance()->core->post_shortcodes ) && is_array( EE_Config::instance()->core->post_shortcodes ) ? EE_Config::instance()->core->post_shortcodes : array(); |
|
123 | + // just in case the site has ever had posts on frontpage at some time, then we should check for a "Posts Page" named "posts" |
|
124 | + $post_pages_to_check = $page_for_posts == 'posts' ? array( $page_for_posts ) : array( 'posts', $page_for_posts ); |
|
125 | + // cycle thru post_shortcodes |
|
126 | + foreach( $post_pages_to_check as $post_page ){ |
|
127 | + // cycle thru post_shortcodes |
|
128 | + foreach( EE_Config::instance()->core->post_shortcodes as $post_name => $shortcodes ){ |
|
129 | + // are there any shortcodes to track ? |
|
130 | + if ( ! empty( $shortcodes )) { |
|
131 | + // loop thru list of tracked shortcodes |
|
132 | + foreach( $shortcodes as $shortcode => $post_id ) { |
|
133 | + // if shortcode is for a critical page, BUT this is NOT the corresponding critical page for that shortcode |
|
134 | + if ( isset( $critical_shortcodes[ $post_id ] ) && $post_name == $post_page ) { |
|
135 | + // then remove this shortcode, because we don't want critical page shortcodes like ESPRESSO_TXN_PAGE running on the "Posts Page" (blog) |
|
136 | + unset( EE_Config::instance()->core->post_shortcodes[ $post_name ][ $shortcode ] ); |
|
137 | + } |
|
138 | + // skip the posts page, because we want all shortcodes registered for it |
|
139 | + if ( $post_name == $post_page ) { |
|
140 | + continue; |
|
141 | + } |
|
142 | + // make sure post still exists |
|
143 | + $post = get_post( $post_id ); |
|
144 | + if ( $post ) { |
|
145 | + // check that the post name matches what we have saved |
|
146 | + if ( $post->post_name == $post_name ) { |
|
147 | + // if so, then break before hitting the unset below |
|
148 | + continue; |
|
149 | + } |
|
150 | + } |
|
151 | + // we don't like missing posts around here >:( |
|
152 | + unset( EE_Config::instance()->core->post_shortcodes[ $post_name ] ); |
|
153 | + } |
|
154 | + } else { |
|
155 | + // you got no shortcodes to keep track of ! |
|
156 | + unset( EE_Config::instance()->core->post_shortcodes[ $post_name ] ); |
|
157 | + } |
|
158 | + } |
|
159 | + } |
|
160 | 160 | } |
161 | 161 | |
162 | 162 |
@@ -41,19 +41,19 @@ discard block |
||
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 |
||
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'] ) ); |
@@ -37,12 +37,12 @@ discard block |
||
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 |
||
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 |
||
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 | } |
@@ -5,7 +5,9 @@ |
||
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 | /** |
@@ -19,12 +19,12 @@ |
||
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 |
@@ -21,12 +21,12 @@ |
||
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 | } |
@@ -21,12 +21,12 @@ |
||
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 | } |
@@ -21,12 +21,12 @@ |
||
21 | 21 | $updated = $wpdb->update($this->_old_table, |
22 | 22 | array('QSG_wp_user'=>$user_id), |
23 | 23 | array('QSG_ID'=>$old_row['QSG_ID']), |
24 | - array('%d',//QSG_wp_user |
|
24 | + array('%d', //QSG_wp_user |
|
25 | 25 | ), |
26 | - array('%d',//QSG_ID |
|
26 | + array('%d', //QSG_ID |
|
27 | 27 | )); |
28 | - if ( FALSE === $updated ) { |
|
29 | - $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting QSG_wp_user = %d where QSG_ID = %d", 'event_espresso'),$user_id,$old_row['QSG_ID'])); |
|
28 | + if (FALSE === $updated) { |
|
29 | + $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting QSG_wp_user = %d where QSG_ID = %d", 'event_espresso'), $user_id, $old_row['QSG_ID'])); |
|
30 | 30 | } |
31 | 31 | } |
32 | 32 | } |
@@ -21,12 +21,12 @@ |
||
21 | 21 | $updated = $wpdb->update($this->_old_table, |
22 | 22 | array('TKT_wp_user'=>$user_id), |
23 | 23 | array('TKT_ID'=>$old_row['TKT_ID']), |
24 | - array('%d',//TKT_wp_user |
|
24 | + array('%d', //TKT_wp_user |
|
25 | 25 | ), |
26 | - array('%d',//TKT_ID |
|
26 | + array('%d', //TKT_ID |
|
27 | 27 | )); |
28 | - if ( FALSE === $updated ) { |
|
29 | - $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting TKT_wp_user = %d where TKT_ID = %d", 'event_espresso'),$user_id,$old_row['TKT_ID'])); |
|
28 | + if (FALSE === $updated) { |
|
29 | + $this->add_error(sprintf(__("Error in updating table {$this->_old_table} setting TKT_wp_user = %d where TKT_ID = %d", 'event_espresso'), $user_id, $old_row['TKT_ID'])); |
|
30 | 30 | } |
31 | 31 | } |
32 | 32 | } |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | -if ( !defined( 'EVENT_ESPRESSO_VERSION' ) ) { |
|
3 | - exit( 'No direct script access allowed' ); |
|
2 | +if ( ! defined('EVENT_ESPRESSO_VERSION')) { |
|
3 | + exit('No direct script access allowed'); |
|
4 | 4 | } |
5 | 5 | |
6 | 6 | /** |
@@ -12,24 +12,24 @@ discard block |
||
12 | 12 | * @author Mike Nelson |
13 | 13 | * |
14 | 14 | */ |
15 | -class EE_DMS_4_6_0_billing_info extends EE_Data_Migration_Script_Stage_Table{ |
|
16 | - function __construct(){ |
|
15 | +class EE_DMS_4_6_0_billing_info extends EE_Data_Migration_Script_Stage_Table { |
|
16 | + function __construct() { |
|
17 | 17 | global $wpdb; |
18 | 18 | $this->_old_table = $wpdb->postmeta; |
19 | 19 | $this->_pretty_name = __('Billing Info', 'event_espresso'); |
20 | 20 | $this->_extra_where_sql = "WHERE meta_key LIKE 'billing_info_%'"; |
21 | 21 | parent::__construct(); |
22 | 22 | } |
23 | - protected function _migrate_old_row( $old_row ) { |
|
23 | + protected function _migrate_old_row($old_row) { |
|
24 | 24 | $new_billing_info = array(); |
25 | - $old_billing_info = maybe_unserialize( $old_row[ 'meta_value' ] ); |
|
26 | - $gateway_name = str_replace( "billing_info_",'',$old_row[ 'meta_key' ] ); |
|
25 | + $old_billing_info = maybe_unserialize($old_row['meta_value']); |
|
26 | + $gateway_name = str_replace("billing_info_", '', $old_row['meta_key']); |
|
27 | 27 | $repetitive_prefix = '_reg-page-billing-'; |
28 | - $repetitive_suffix = "-" . $gateway_name; |
|
29 | - foreach( $old_billing_info as $old_input_name => $input_value ){ |
|
30 | - $old_input_name_important_part = str_replace( array( $repetitive_prefix, $repetitive_suffix ), array( '', ''), $old_input_name ); |
|
28 | + $repetitive_suffix = "-".$gateway_name; |
|
29 | + foreach ($old_billing_info as $old_input_name => $input_value) { |
|
30 | + $old_input_name_important_part = str_replace(array($repetitive_prefix, $repetitive_suffix), array('', ''), $old_input_name); |
|
31 | 31 | |
32 | - switch( $old_input_name_important_part ){ |
|
32 | + switch ($old_input_name_important_part) { |
|
33 | 33 | case 'fname': |
34 | 34 | $new_input_name = 'first_name'; |
35 | 35 | break; |
@@ -39,7 +39,7 @@ discard block |
||
39 | 39 | case 'state': |
40 | 40 | //we used to store the state's id ,but now we just store the name |
41 | 41 | $new_input_name = $old_input_name_important_part; |
42 | - $input_value = $this->_get_state_name_by_ID( $input_value ); |
|
42 | + $input_value = $this->_get_state_name_by_ID($input_value); |
|
43 | 43 | break; |
44 | 44 | case 'card-nmbr': |
45 | 45 | $new_input_name = 'credit_card'; |
@@ -62,9 +62,9 @@ discard block |
||
62 | 62 | $new_input_name = $old_input_name_important_part; |
63 | 63 | |
64 | 64 | } |
65 | - $new_billing_info[ $new_input_name ] = $input_value; |
|
65 | + $new_billing_info[$new_input_name] = $input_value; |
|
66 | 66 | } |
67 | - update_post_meta( $old_row[ 'post_id' ], $old_row[ 'meta_key' ], $new_billing_info ); |
|
67 | + update_post_meta($old_row['post_id'], $old_row['meta_key'], $new_billing_info); |
|
68 | 68 | } |
69 | 69 | /** |
70 | 70 | * |
@@ -72,9 +72,9 @@ discard block |
||
72 | 72 | * @param int $id |
73 | 73 | * @return string |
74 | 74 | */ |
75 | - protected function _get_state_name_by_ID( $id ){ |
|
75 | + protected function _get_state_name_by_ID($id) { |
|
76 | 76 | global $wpdb; |
77 | - return $wpdb->get_var( $wpdb->prepare( "SELECT STA_name FROM " . $wpdb->prefix . "esp_state WHERE STA_ID = %d", $id ) ); |
|
77 | + return $wpdb->get_var($wpdb->prepare("SELECT STA_name FROM ".$wpdb->prefix."esp_state WHERE STA_ID = %d", $id)); |
|
78 | 78 | } |
79 | 79 | |
80 | 80 |