PluginProbe
UsersWP – Front-end login form, User Registration, User Profile & Members Directory plugin for WP / 1.0.17
UsersWP – Front-end login form, User Registration, User Profile & Members Directory plugin for WP v1.0.17
1.2.73 1.2.72 1.2.71 1.2.70 1.2.69 1.2.68 1.2.67 1.2.66 1.2.65 1.2.64 1.2.63 trunk 1.0.10 1.0.11 1.0.12 1.0.13 1.0.14 1.0.15 1.0.16 1.0.17 1.0.18 1.0.19 1.0.20 1.0.21 1.0.22 All 173 releases
userswp / includes / class-activator.php

class-activator.php in UsersWP – Front-end login form, User Registration, User Profile & Members Directory plugin for WP 1.0.17, at includes/class-activator.php

820 lines 26.6 KB
No matching file
Up and down to move Enter to open Esc to close
Raw Download Zip
1 <?php
2 /**
3 * Fired during plugin activation.
4 *
5 * This class defines all code necessary to run during the plugin's activation.
6 *
7 * @since 1.0.0
8 * @author GeoDirectory Team <info@wpgeodirectory.com>
9 */
10 class UsersWP_Activator {
11
12 /**
13 * This method gets fired during plugin activation.
14 *
15 * @since 1.0.0
16 * @package userswp
17 * @return void
18 */
19 public static function activate($network_wide = false) {
20
21 self::load_dependencies();
22
23 if (is_multisite()) {
24 $main_site = get_network()->site_id;
25 if($network_wide){
26 if (defined('UWP_ROOT_PAGES')) {
27 if (UWP_ROOT_PAGES == 'all') {
28 $blog_ids = self::uwp_get_blog_ids();
29
30 foreach ( $blog_ids as $blog_id ) {
31 switch_to_blog( $blog_id );
32 self::install();
33 }
34 restore_current_blog();
35 } else {
36 $blog_id = UWP_ROOT_PAGES;
37 switch_to_blog( $blog_id );
38 self::install();
39 restore_current_blog();
40 }
41 } else {
42 switch_to_blog( $main_site );
43 self::install();
44 restore_current_blog();
45 }
46
47 switch_to_blog( $main_site );
48 self::uwp101_create_tables();
49 self::uwp_insert_usermeta();
50 restore_current_blog();
51 } else {
52 self::install();
53 self::uwp101_create_tables();
54 self::uwp_insert_usermeta();
55 }
56 } else {
57 self::install();
58 self::uwp101_create_tables();
59 self::uwp_insert_usermeta();
60 }
61
62 }
63
64 public static function install(){
65
66 self::generate_pages();
67 self::uwp_create_tables();
68
69 if (!get_option('uwp_default_data_installed')) {
70 self::add_default_options();
71 self::uwp_create_default_fields();
72 self::uwp_insert_form_extras();
73 update_option('uwp_default_data_installed', 1);
74 update_option('uwp_activation_redirect', 1);
75 }
76
77 self::uwp_flush_rewrite_rules();
78 update_option('uwp_flush_rewrite', 1);
79
80 }
81
82 /**
83 * Get all IDs of blogs that are not activated, not spam, and not deleted
84 *
85 * @global object $wpdb
86 * @return array|false Array of IDs or false if none are found
87 */
88 public static function uwp_get_blog_ids() {
89 global $wpdb;
90
91 // Get an array of IDs
92 $sql = "SELECT blog_id FROM $wpdb->blogs
93 WHERE archived = '0' AND spam = '0'
94 AND deleted = '0'";
95
96 return $wpdb->get_col( $sql );
97 }
98
99 /**
100 * Loads all dependencies during plugin activation.
101 *
102 * @since 1.0.0
103 * @package userswp
104 * @return void
105 */
106 public static function load_dependencies() {
107 require_once dirname( __FILE__ ) . '/class-tables.php';
108 require_once dirname( __FILE__ ) . '/class-meta.php';
109 require_once dirname( __FILE__ ) . '/class-pages.php';
110 require_once dirname(dirname( __FILE__ )) . '/admin/settings/class-formbuilder.php';
111 }
112
113 /**
114 * Generates the default pages during plugin activation.
115 *
116 * @since 1.0.0
117 * @package userswp
118 * @return void
119 */
120 public static function generate_pages() {
121 uwp_generate_default_pages();
122 }
123
124 /**
125 * Adds default settings during plugin activation.
126 *
127 * @since 1.0.0
128 * @package userswp
129 * @return void
130 */
131 public static function add_default_options() {
132
133 $settings = get_option( 'uwp_settings', array());
134
135 //general
136 if (!isset($settings['profile_no_of_items'])) {
137 $settings['profile_no_of_items'] = '10';
138 }
139
140 //login
141 if (!isset($settings['login_redirect_to'])) {
142 $settings['login_redirect_to'] = -1;
143 }
144
145 //profile
146 if (!isset($settings['enable_profile_header'])) {
147 $settings['enable_profile_header'] = '1';
148 }
149 if (!isset($settings['enable_profile_body'])) {
150 $settings['enable_profile_body'] = '1';
151 }
152 if (!isset($settings['enable_profile_posts_tab'])) {
153 $settings['enable_profile_posts_tab'] = '1';
154 }
155 if (!isset($settings['enable_profile_comments_tab'])) {
156 $settings['enable_profile_comments_tab'] = '1';
157 }
158
159 if (isset($settings['enable_profile_tabs']) && is_array($settings['enable_profile_tabs'])) {
160 if (!isset($settings['enable_profile_tabs']['more_info'])) {
161 $settings['enable_profile_tabs'][] = 'more_info';
162 }
163 if (!isset($settings['enable_profile_tabs']['posts'])) {
164 $settings['enable_profile_tabs'][] = 'posts';
165 }
166 if (!isset($settings['enable_profile_tabs']['comments'])) {
167 $settings['enable_profile_tabs'][] = 'comments';
168 }
169 } else {
170 $settings['enable_profile_tabs'] = array('more_info', 'posts', 'comments');
171 }
172
173
174 //notifications
175
176 // admin
177 $registration_success_email_subject_admin = __( 'New account registration', 'userswp' );
178 $registration_success_email_content_admin = __("A user has been registered recently on your website. [#extras#]", "userswp");
179
180 if (!isset($settings['registration_success_email_subject_admin'])) {
181 $settings['registration_success_email_subject_admin'] = $registration_success_email_subject_admin;
182 }
183 if (!isset($settings['registration_success_email_content_admin'])) {
184 $settings['registration_success_email_content_admin'] = $registration_success_email_content_admin;
185 }
186
187
188 // User
189
190 // Register
191 $registration_success_email_subject = __('Your Log In Details', 'userswp');
192 $registration_success_email_content = __("<p>Dear [#user_name#],</p><p>You can log in with the following information:</p>[#login_details#]<p>You can login here: [#login_url#]</p><p>Thank you,<br /><br />[#site_name_url#].</p>" ,'userswp');
193
194 if (!isset($settings['registration_success_email_subject'])) {
195 $settings['registration_success_email_subject'] = $registration_success_email_subject;
196 }
197 if (!isset($settings['registration_success_email_content'])) {
198 $settings['registration_success_email_content'] = $registration_success_email_content;
199 }
200
201 // Activate
202 $registration_activate_email_subject = __('Please activate your account', 'userswp');
203 $registration_activate_email_content = __("<p>Dear [#user_name#],</p><p>Thank you for signing up with [#site_name#]</p>[#login_details#]<p>Thank you,<br /><br />[#site_name_url#].</p>" ,'userswp');
204
205 if (!isset($settings['registration_activate_email_subject'])) {
206 $settings['registration_activate_email_subject'] = $registration_activate_email_subject;
207 }
208 if (!isset($settings['registration_activate_email_content'])) {
209 $settings['registration_activate_email_content'] = $registration_activate_email_content;
210 }
211
212 // Forgot
213 $forgot_password_email_subject = __('[#site_name#] - Your new password', 'userswp');
214 $forgot_password_email_content = __("<p>Dear [#user_name#],</p>[#login_details#]<p>You can login here: [#login_url#]</p><p>Thank you,<br /><br />[#site_name_url#].</p>" ,'userswp');
215
216 if (!isset($settings['forgot_password_email_subject'])) {
217 $settings['forgot_password_email_subject'] = $forgot_password_email_subject;
218 }
219 if (!isset($settings['forgot_password_email_content'])) {
220 $settings['forgot_password_email_content'] = $forgot_password_email_content;
221 }
222
223 // Change
224 $change_password_email_subject = __('[#site_name#] - Password has been changed', 'userswp');
225 $change_password_email_content = __("<p>Dear [#user_name#],</p><p>Your password has been changed successfully.</p><p>You can login here: [#login_url#]</p><p>Thank you,<br /><br />[#site_name_url#].</p>" ,'userswp');
226
227 if (!isset($settings['change_password_email_subject'])) {
228 $settings['change_password_email_subject'] = $change_password_email_subject;
229 }
230 if (!isset($settings['change_password_email_content'])) {
231 $settings['change_password_email_content'] = $change_password_email_content;
232 }
233
234 // Reset
235 $reset_password_email_subject = __('[#site_name#] - Password has been reset', 'userswp');
236 $reset_password_email_content = __("<p>Dear [#user_name#],</p><p>Your password has been reset</p><p>You can login here: [#login_url#]</p><p>Thank you,<br /><br />[#site_name_url#].</p>" ,'userswp');
237
238 if (!isset($settings['reset_password_email_subject'])) {
239 $settings['reset_password_email_subject'] = $reset_password_email_subject;
240 }
241 if (!isset($settings['reset_password_email_content'])) {
242 $settings['reset_password_email_content'] = $reset_password_email_content;
243 }
244
245 // Update
246 $account_update_email_subject = __('[#site_name#] - Account has been updated', 'userswp');
247 $account_update_email_content = __("<p>Dear [#user_name#],</p><p>Your account has been updated successfully</p><p>Thank you,<br /><br />[#site_name_url#].</p>" ,'userswp');
248
249 if (!isset($settings['account_update_email_subject'])) {
250 $settings['account_update_email_subject'] = $account_update_email_subject;
251 }
252 if (!isset($settings['account_update_email_content'])) {
253 $settings['account_update_email_content'] = $account_update_email_content;
254 }
255
256 update_option( 'uwp_settings', $settings );
257
258 }
259
260 /**
261 * Creates tables during plugin activation.
262 *
263 * @since 1.0.0
264 * @package userswp
265 * @return void
266 */
267 public static function uwp_create_tables()
268 {
269 uwp_create_tables();
270 }
271
272 /**
273 * Creates the new tables added in version 1.0.1 during plugin activation.
274 *
275 * @since 1.0.0
276 * @package userswp
277 * @return void
278 */
279 public static function uwp101_create_tables() {
280 uwp101_create_tables();
281 }
282
283 /**
284 * Syncs WP usermeta with UsersWP usermeta during plugin activation.
285 *
286 * @since 1.0.0
287 * @package userswp
288 * @return void
289 */
290 public static function uwp_insert_usermeta()
291 {
292 global $wpdb;
293 $sort= "user_registered";
294 $all_users_id = $wpdb->get_col( $wpdb->prepare(
295 "SELECT $wpdb->users.ID FROM $wpdb->users ORDER BY %s ASC"
296 , $sort ));
297
298 //we got all the IDs, now loop through them to get individual IDs
299 foreach ( $all_users_id as $user_id ) {
300 // get user info by calling get_userdata() on each id
301 $user_data = get_userdata($user_id);
302 $first_name = get_user_meta( $user_id, 'first_name', true );
303 $last_name = get_user_meta( $user_id, 'last_name', true );
304 $bio = get_user_meta( $user_id, 'description', true );
305 uwp_update_usermeta($user_id, 'uwp_account_username', $user_data->user_login);
306 uwp_update_usermeta($user_id, 'uwp_account_email', $user_data->user_email);
307 uwp_update_usermeta($user_id, 'uwp_account_first_name', $first_name);
308 uwp_update_usermeta($user_id, 'uwp_account_last_name', $last_name);
309 uwp_update_usermeta($user_id, 'uwp_account_bio', $bio);
310 }
311 }
312
313 /**
314 * Saves default custom fields in the database.
315 *
316 * @since 1.0.0
317 * @package userswp
318 * @return void
319 */
320 public static function uwp_create_default_fields()
321 {
322 $form_builder = new UsersWP_Form_Builder();
323
324 $fields = self::uwp_default_custom_fields();
325
326 $fields = apply_filters('uwp_before_default_custom_fields_saved', $fields);
327
328 foreach ($fields as $field_index => $field) {
329 $form_builder->uwp_admin_form_field_save($field);
330 }
331 }
332
333 /**
334 * Returns merged default custom fields.
335 *
336 * @since 1.0.0
337 * @package userswp
338 * @return array Merged custom fields.
339 */
340 public static function uwp_default_custom_fields(){
341
342 $login = self::uwp_default_custom_fields_login();
343 $forgot = self::uwp_default_custom_fields_forgot();
344 $avatar = self::uwp_default_custom_fields_avatar();
345 $banner = self::uwp_default_custom_fields_banner();
346 $change = self::uwp_default_custom_fields_change();
347 $reset = self::uwp_default_custom_fields_reset();
348 $account = self::uwp_default_custom_fields_account();
349
350 $fields = array_merge($login, $forgot, $account, $avatar, $banner, $change, $reset);
351
352 $fields = apply_filters('uwp_default_custom_fields', $fields);
353
354 return $fields;
355
356 }
357
358 /**
359 * Returns Login form default custom fields.
360 *
361 * @since 1.0.0
362 * @package userswp
363 * @return array Login form default custom fields.
364 */
365 public static function uwp_default_custom_fields_login(){
366
367 $fields = array();
368
369 $fields[] = array(
370 'form_type' => 'login',
371 'field_type' => 'text',
372 'data_type' => 'XVARCHAR',
373 'site_title' => __('Username', 'userswp'),
374 'htmlvar_name' => 'username',
375 'default_value' => '',
376 'option_values' => '',
377 'is_default' => '1',
378 'is_active' => '1',
379 'is_required' => '1'
380 );
381
382 $fields[] = array(
383 'form_type' => 'login',
384 'field_type' => 'password',
385 'data_type' => 'XVARCHAR',
386 'site_title' => __('Password', 'userswp'),
387 'htmlvar_name' => 'password',
388 'default_value' => '',
389 'option_values' => '',
390 'is_default' => '1',
391 'is_active' => '1',
392 'is_required' => '1'
393 );
394
395 $fields = apply_filters('uwp_default_custom_fields_login', $fields);
396
397 return $fields;
398 }
399
400 /**
401 * Returns Forgot form default custom fields.
402 *
403 * @since 1.0.0
404 * @package userswp
405 * @return array Forgot form default custom fields.
406 */
407 public static function uwp_default_custom_fields_forgot(){
408
409 $fields = array();
410
411 $fields[] = array(
412 'form_type' => 'forgot',
413 'field_type' => 'email',
414 'data_type' => 'XVARCHAR',
415 'site_title' => __('Email', 'userswp'),
416 'htmlvar_name' => 'email',
417 'default_value' => '',
418 'option_values' => '',
419 'is_default' => '1',
420 'is_active' => '1',
421 'is_required' => '1'
422 );
423
424 $fields = apply_filters('uwp_default_custom_fields_forgot', $fields);
425
426 return $fields;
427 }
428
429 /**
430 * Returns Avatar form default custom fields.
431 *
432 * @since 1.0.0
433 * @package userswp
434 * @return array Avatar form default custom fields.
435 */
436 public static function uwp_default_custom_fields_avatar(){
437
438 $fields = array();
439
440 $fields[] = array(
441 'form_type' => 'avatar',
442 'field_type' => 'file',
443 'data_type' => 'TEXT',
444 'site_title' => __('Avatar', 'userswp'),
445 'htmlvar_name' => 'file',
446 'default_value' => '',
447 'option_values' => '',
448 'is_default' => '1',
449 'is_active' => '1',
450 'is_required' => '1',
451 'extra_fields' => array(
452 'uwp_file_types' => array(
453 'jpg',
454 'jpe',
455 'jpeg',
456 'gif',
457 'png'
458 ),
459 )
460 );
461
462 $fields = apply_filters('uwp_default_custom_fields_avatar', $fields);
463
464 return $fields;
465 }
466
467 /**
468 * Returns Banner form default custom fields.
469 *
470 * @since 1.0.0
471 * @package userswp
472 * @return array Banner form default custom fields.
473 */
474 public static function uwp_default_custom_fields_banner(){
475
476 $fields = array();
477
478 $fields[] = array(
479 'form_type' => 'banner',
480 'field_type' => 'file',
481 'data_type' => 'TEXT',
482 'site_title' => __('Banner', 'userswp'),
483 'htmlvar_name' => 'file',
484 'default_value' => '',
485 'option_values' => '',
486 'is_default' => '1',
487 'is_active' => '1',
488 'is_required' => '1',
489 'extra_fields' => array(
490 'uwp_file_types' => array(
491 'jpg',
492 'jpe',
493 'jpeg',
494 'gif',
495 'png'
496 ),
497 )
498 );
499
500 $fields = apply_filters('uwp_default_custom_fields_banner', $fields);
501
502 return $fields;
503 }
504
505 /**
506 * Returns Change Password form default custom fields.
507 *
508 * @since 1.0.0
509 * @package userswp
510 * @return array Change Password form default custom fields.
511 */
512 public static function uwp_default_custom_fields_change(){
513
514 $fields = array();
515
516 $fields[] = array(
517 'form_type' => 'change',
518 'field_type' => 'password',
519 'data_type' => 'XVARCHAR',
520 'site_title' => __('Old Password', 'userswp'),
521 'htmlvar_name' => 'old_password',
522 'default_value' => '',
523 'option_values' => '',
524 'is_default' => '1',
525 'is_active' => '1',
526 'is_required' => '1'
527 );
528
529 $fields[] = array(
530 'form_type' => 'change',
531 'field_type' => 'password',
532 'data_type' => 'XVARCHAR',
533 'site_title' => __('New Password', 'userswp'),
534 'htmlvar_name' => 'password',
535 'default_value' => '',
536 'option_values' => '',
537 'is_default' => '1',
538 'is_active' => '1',
539 'is_required' => '1'
540 );
541
542 $fields[] = array(
543 'form_type' => 'change',
544 'field_type' => 'password',
545 'data_type' => 'XVARCHAR',
546 'site_title' => __('Confirm Password', 'userswp'),
547 'htmlvar_name' => 'confirm_password',
548 'default_value' => '',
549 'option_values' => '',
550 'is_default' => '1',
551 'is_active' => '1',
552 'is_required' => '1'
553 );
554
555 $fields = apply_filters('uwp_default_custom_fields_change', $fields);
556
557 return $fields;
558 }
559
560 /**
561 * Returns Reset Password form default custom fields.
562 *
563 * @since 1.0.0
564 * @package userswp
565 * @return array Reset Password form default custom fields.
566 */
567 public static function uwp_default_custom_fields_reset(){
568
569 $fields = array();
570
571 $fields[] = array(
572 'form_type' => 'reset',
573 'field_type' => 'password',
574 'data_type' => 'XVARCHAR',
575 'site_title' => __('Password', 'userswp'),
576 'htmlvar_name' => 'password',
577 'default_value' => '',
578 'option_values' => '',
579 'is_default' => '1',
580 'is_active' => '1',
581 'is_required' => '1'
582 );
583
584 $fields[] = array(
585 'form_type' => 'reset',
586 'field_type' => 'password',
587 'data_type' => 'XVARCHAR',
588 'site_title' => __('Confirm Password', 'userswp'),
589 'htmlvar_name' => 'confirm_password',
590 'default_value' => '',
591 'option_values' => '',
592 'is_default' => '1',
593 'is_active' => '1',
594 'is_required' => '1'
595 );
596
597 $fields = apply_filters('uwp_default_custom_fields_reset', $fields);
598
599 return $fields;
600 }
601
602 /**
603 * Returns Account form default custom fields.
604 *
605 * @since 1.0.0
606 * @package userswp
607 * @return array Account form default custom fields.
608 */
609 public static function uwp_default_custom_fields_account(){
610
611 $fields = array();
612
613 $fields[] = array(
614 'form_type' => 'account',
615 'field_type' => 'text',
616 'data_type' => 'XVARCHAR',
617 'site_title' => __('First Name', 'userswp'),
618 'htmlvar_name' => 'first_name',
619 'default_value' => '',
620 'option_values' => '',
621 'is_default' => '1',
622 'is_public' => '1',
623 'is_active' => '1',
624 'is_required' => '1',
625 'is_register_field' => '1',
626 'is_search_field' => '1',
627 'css_class' => 'uwp-half uwp-half-left',
628 );
629
630 $fields[] = array(
631 'form_type' => 'account',
632 'field_type' => 'text',
633 'data_type' => 'XVARCHAR',
634 'site_title' => __('Last Name', 'userswp'),
635 'htmlvar_name' => 'last_name',
636 'default_value' => '',
637 'option_values' => '',
638 'is_default' => '1',
639 'is_public' => '1',
640 'is_active' => '1',
641 'is_required' => '1',
642 'is_register_field' => '1',
643 'is_search_field' => '1',
644 'css_class' => 'uwp-half uwp-half-right',
645 );
646
647 $fields[] = array(
648 'form_type' => 'account',
649 'field_type' => 'text',
650 'data_type' => 'XVARCHAR',
651 'site_title' => __('Username', 'userswp'),
652 'htmlvar_name' => 'username',
653 'default_value' => '',
654 'option_values' => '',
655 'is_default' => '1',
656 'is_public' => '1',
657 'is_active' => '1',
658 'is_required' => '1',
659 'is_register_field' => '1',
660 'is_search_field' => '1',
661 'is_register_only_field' => '1',
662 );
663
664 $fields[] = array(
665 'form_type' => 'account',
666 'field_type' => 'text',
667 'data_type' => 'XVARCHAR',
668 'site_title' => __('Display Name', 'userswp'),
669 'htmlvar_name' => 'display_name',
670 'default_value' => '',
671 'option_values' => '',
672 'is_default' => '1',
673 'is_public' => '1',
674 'is_active' => '1',
675 'is_required' => '0',
676 'is_register_field' => '0',
677 'is_search_field' => '1',
678 );
679
680 $fields[] = array(
681 'form_type' => 'account',
682 'field_type' => 'email',
683 'data_type' => 'XVARCHAR',
684 'site_title' => __('Email', 'userswp'),
685 'htmlvar_name' => 'email',
686 'default_value' => '',
687 'option_values' => '',
688 'is_default' => '1',
689 'is_active' => '1',
690 'is_required' => '1',
691 'is_register_field' => '1',
692 'is_search_field' => '1',
693 );
694
695
696 $fields[] = array(
697 'form_type' => 'account',
698 'field_type' => 'textarea',
699 'data_type' => 'TEXT',
700 'site_title' => __('Bio', 'userswp'),
701 'htmlvar_name' => 'bio',
702 'default_value' => '',
703 'option_values' => '',
704 'is_default' => '1',
705 'is_active' => '1',
706 'is_public' => '1',
707 'is_required' => '1',
708 'is_search_field' => '1',
709 'show_in' => array('[profile_side]', '[users]')
710 );
711
712 $fields[] = array(
713 'form_type' => 'account',
714 'field_type' => 'password',
715 'data_type' => 'XVARCHAR',
716 'site_title' => __('Password', 'userswp'),
717 'htmlvar_name' => 'password',
718 'default_value' => '',
719 'option_values' => '',
720 'is_default' => '1',
721 'is_active' => '1',
722 'is_required' => '1',
723 'is_register_field' => '1',
724 'is_register_only_field' => '1',
725 'extra' => array(
726 'confirm_password' => '1'
727 )
728 );
729
730
731 $fields = apply_filters('uwp_default_custom_fields_account', $fields);
732
733 return $fields;
734 }
735
736 /**
737 * Flushes rewrite rules.
738 *
739 * @since 1.0.0
740 * @package userswp
741 * @return void
742 */
743 public static function uwp_flush_rewrite_rules() {
744 flush_rewrite_rules();
745 }
746
747 /**
748 * Inserts register form custom fields in form extras table.
749 *
750 * @since 1.0.0
751 * @package userswp
752 * @return void
753 */
754 public static function uwp_insert_form_extras() {
755 global $wpdb;
756 $extras_table_name = uwp_get_table_prefix() . 'uwp_form_extras';
757
758 $fields = array();
759
760 $fields[] = array(
761 'form_type' => 'register',
762 'field_type' => 'text',
763 'is_default' => '1',
764 'htmlvar_name' => 'uwp_account_first_name'
765 );
766
767 $fields[] = array(
768 'form_type' => 'register',
769 'field_type' => 'text',
770 'is_default' => '1',
771 'htmlvar_name' => 'uwp_account_last_name'
772 );
773
774 $fields[] = array(
775 'form_type' => 'register',
776 'field_type' => 'text',
777 'is_default' => '1',
778 'htmlvar_name' => 'uwp_account_username'
779 );
780
781 $fields[] = array(
782 'form_type' => 'register',
783 'field_type' => 'email',
784 'is_default' => '1',
785 'htmlvar_name' => 'uwp_account_email'
786 );
787
788 $fields[] = array(
789 'form_type' => 'register',
790 'field_type' => 'password',
791 'is_default' => '1',
792 'htmlvar_name' => 'uwp_account_password'
793 );
794
795
796 foreach ($fields as $field) {
797 $last_order = $wpdb->get_var("SELECT MAX(sort_order) as last_order FROM " . $extras_table_name);
798 $sort_order = (int)$last_order + 1;
799 $wpdb->query(
800 $wpdb->prepare(
801
802 "insert into " . $extras_table_name . " set
803 form_type = %s,
804 field_type = %s,
805 is_default = %s,
806 site_htmlvar_name = %s,
807 sort_order = %s",
808 array(
809 $field['form_type'],
810 $field['field_type'],
811 $field['is_default'],
812 $field['htmlvar_name'],
813 $sort_order
814 )
815 )
816 );
817 }
818 }
819
820 }