PluginProbe
UsersWP – Front-end login form, User Registration, User Profile & Members Directory plugin for WP / 1.0.18
UsersWP – Front-end login form, User Registration, User Profile & Members Directory plugin for WP v1.0.18
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 1.0.23 All 172 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.18, at includes/class-activator.php

821 lines 26.7 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 uwp_update_usermeta($user_id, 'uwp_account_display_name', $user_data->display_name);
311 }
312 }
313
314 /**
315 * Saves default custom fields in the database.
316 *
317 * @since 1.0.0
318 * @package userswp
319 * @return void
320 */
321 public static function uwp_create_default_fields()
322 {
323 $form_builder = new UsersWP_Form_Builder();
324
325 $fields = self::uwp_default_custom_fields();
326
327 $fields = apply_filters('uwp_before_default_custom_fields_saved', $fields);
328
329 foreach ($fields as $field_index => $field) {
330 $form_builder->uwp_admin_form_field_save($field);
331 }
332 }
333
334 /**
335 * Returns merged default custom fields.
336 *
337 * @since 1.0.0
338 * @package userswp
339 * @return array Merged custom fields.
340 */
341 public static function uwp_default_custom_fields(){
342
343 $login = self::uwp_default_custom_fields_login();
344 $forgot = self::uwp_default_custom_fields_forgot();
345 $avatar = self::uwp_default_custom_fields_avatar();
346 $banner = self::uwp_default_custom_fields_banner();
347 $change = self::uwp_default_custom_fields_change();
348 $reset = self::uwp_default_custom_fields_reset();
349 $account = self::uwp_default_custom_fields_account();
350
351 $fields = array_merge($login, $forgot, $account, $avatar, $banner, $change, $reset);
352
353 $fields = apply_filters('uwp_default_custom_fields', $fields);
354
355 return $fields;
356
357 }
358
359 /**
360 * Returns Login form default custom fields.
361 *
362 * @since 1.0.0
363 * @package userswp
364 * @return array Login form default custom fields.
365 */
366 public static function uwp_default_custom_fields_login(){
367
368 $fields = array();
369
370 $fields[] = array(
371 'form_type' => 'login',
372 'field_type' => 'text',
373 'data_type' => 'XVARCHAR',
374 'site_title' => __('Username', 'userswp'),
375 'htmlvar_name' => 'username',
376 'default_value' => '',
377 'option_values' => '',
378 'is_default' => '1',
379 'is_active' => '1',
380 'is_required' => '1'
381 );
382
383 $fields[] = array(
384 'form_type' => 'login',
385 'field_type' => 'password',
386 'data_type' => 'XVARCHAR',
387 'site_title' => __('Password', 'userswp'),
388 'htmlvar_name' => 'password',
389 'default_value' => '',
390 'option_values' => '',
391 'is_default' => '1',
392 'is_active' => '1',
393 'is_required' => '1'
394 );
395
396 $fields = apply_filters('uwp_default_custom_fields_login', $fields);
397
398 return $fields;
399 }
400
401 /**
402 * Returns Forgot form default custom fields.
403 *
404 * @since 1.0.0
405 * @package userswp
406 * @return array Forgot form default custom fields.
407 */
408 public static function uwp_default_custom_fields_forgot(){
409
410 $fields = array();
411
412 $fields[] = array(
413 'form_type' => 'forgot',
414 'field_type' => 'email',
415 'data_type' => 'XVARCHAR',
416 'site_title' => __('Email', 'userswp'),
417 'htmlvar_name' => 'email',
418 'default_value' => '',
419 'option_values' => '',
420 'is_default' => '1',
421 'is_active' => '1',
422 'is_required' => '1'
423 );
424
425 $fields = apply_filters('uwp_default_custom_fields_forgot', $fields);
426
427 return $fields;
428 }
429
430 /**
431 * Returns Avatar form default custom fields.
432 *
433 * @since 1.0.0
434 * @package userswp
435 * @return array Avatar form default custom fields.
436 */
437 public static function uwp_default_custom_fields_avatar(){
438
439 $fields = array();
440
441 $fields[] = array(
442 'form_type' => 'avatar',
443 'field_type' => 'file',
444 'data_type' => 'TEXT',
445 'site_title' => __('Avatar', 'userswp'),
446 'htmlvar_name' => 'file',
447 'default_value' => '',
448 'option_values' => '',
449 'is_default' => '1',
450 'is_active' => '1',
451 'is_required' => '1',
452 'extra_fields' => array(
453 'uwp_file_types' => array(
454 'jpg',
455 'jpe',
456 'jpeg',
457 'gif',
458 'png'
459 ),
460 )
461 );
462
463 $fields = apply_filters('uwp_default_custom_fields_avatar', $fields);
464
465 return $fields;
466 }
467
468 /**
469 * Returns Banner form default custom fields.
470 *
471 * @since 1.0.0
472 * @package userswp
473 * @return array Banner form default custom fields.
474 */
475 public static function uwp_default_custom_fields_banner(){
476
477 $fields = array();
478
479 $fields[] = array(
480 'form_type' => 'banner',
481 'field_type' => 'file',
482 'data_type' => 'TEXT',
483 'site_title' => __('Banner', 'userswp'),
484 'htmlvar_name' => 'file',
485 'default_value' => '',
486 'option_values' => '',
487 'is_default' => '1',
488 'is_active' => '1',
489 'is_required' => '1',
490 'extra_fields' => array(
491 'uwp_file_types' => array(
492 'jpg',
493 'jpe',
494 'jpeg',
495 'gif',
496 'png'
497 ),
498 )
499 );
500
501 $fields = apply_filters('uwp_default_custom_fields_banner', $fields);
502
503 return $fields;
504 }
505
506 /**
507 * Returns Change Password form default custom fields.
508 *
509 * @since 1.0.0
510 * @package userswp
511 * @return array Change Password form default custom fields.
512 */
513 public static function uwp_default_custom_fields_change(){
514
515 $fields = array();
516
517 $fields[] = array(
518 'form_type' => 'change',
519 'field_type' => 'password',
520 'data_type' => 'XVARCHAR',
521 'site_title' => __('Old Password', 'userswp'),
522 'htmlvar_name' => 'old_password',
523 'default_value' => '',
524 'option_values' => '',
525 'is_default' => '1',
526 'is_active' => '1',
527 'is_required' => '1'
528 );
529
530 $fields[] = array(
531 'form_type' => 'change',
532 'field_type' => 'password',
533 'data_type' => 'XVARCHAR',
534 'site_title' => __('New Password', 'userswp'),
535 'htmlvar_name' => 'password',
536 'default_value' => '',
537 'option_values' => '',
538 'is_default' => '1',
539 'is_active' => '1',
540 'is_required' => '1'
541 );
542
543 $fields[] = array(
544 'form_type' => 'change',
545 'field_type' => 'password',
546 'data_type' => 'XVARCHAR',
547 'site_title' => __('Confirm Password', 'userswp'),
548 'htmlvar_name' => 'confirm_password',
549 'default_value' => '',
550 'option_values' => '',
551 'is_default' => '1',
552 'is_active' => '1',
553 'is_required' => '1'
554 );
555
556 $fields = apply_filters('uwp_default_custom_fields_change', $fields);
557
558 return $fields;
559 }
560
561 /**
562 * Returns Reset Password form default custom fields.
563 *
564 * @since 1.0.0
565 * @package userswp
566 * @return array Reset Password form default custom fields.
567 */
568 public static function uwp_default_custom_fields_reset(){
569
570 $fields = array();
571
572 $fields[] = array(
573 'form_type' => 'reset',
574 'field_type' => 'password',
575 'data_type' => 'XVARCHAR',
576 'site_title' => __('Password', 'userswp'),
577 'htmlvar_name' => 'password',
578 'default_value' => '',
579 'option_values' => '',
580 'is_default' => '1',
581 'is_active' => '1',
582 'is_required' => '1'
583 );
584
585 $fields[] = array(
586 'form_type' => 'reset',
587 'field_type' => 'password',
588 'data_type' => 'XVARCHAR',
589 'site_title' => __('Confirm Password', 'userswp'),
590 'htmlvar_name' => 'confirm_password',
591 'default_value' => '',
592 'option_values' => '',
593 'is_default' => '1',
594 'is_active' => '1',
595 'is_required' => '1'
596 );
597
598 $fields = apply_filters('uwp_default_custom_fields_reset', $fields);
599
600 return $fields;
601 }
602
603 /**
604 * Returns Account form default custom fields.
605 *
606 * @since 1.0.0
607 * @package userswp
608 * @return array Account form default custom fields.
609 */
610 public static function uwp_default_custom_fields_account(){
611
612 $fields = array();
613
614 $fields[] = array(
615 'form_type' => 'account',
616 'field_type' => 'text',
617 'data_type' => 'XVARCHAR',
618 'site_title' => __('First Name', 'userswp'),
619 'htmlvar_name' => 'first_name',
620 'default_value' => '',
621 'option_values' => '',
622 'is_default' => '1',
623 'is_public' => '1',
624 'is_active' => '1',
625 'is_required' => '1',
626 'is_register_field' => '1',
627 'is_search_field' => '1',
628 'css_class' => 'uwp-half uwp-half-left',
629 );
630
631 $fields[] = array(
632 'form_type' => 'account',
633 'field_type' => 'text',
634 'data_type' => 'XVARCHAR',
635 'site_title' => __('Last Name', 'userswp'),
636 'htmlvar_name' => 'last_name',
637 'default_value' => '',
638 'option_values' => '',
639 'is_default' => '1',
640 'is_public' => '1',
641 'is_active' => '1',
642 'is_required' => '1',
643 'is_register_field' => '1',
644 'is_search_field' => '1',
645 'css_class' => 'uwp-half uwp-half-right',
646 );
647
648 $fields[] = array(
649 'form_type' => 'account',
650 'field_type' => 'text',
651 'data_type' => 'XVARCHAR',
652 'site_title' => __('Username', 'userswp'),
653 'htmlvar_name' => 'username',
654 'default_value' => '',
655 'option_values' => '',
656 'is_default' => '1',
657 'is_public' => '1',
658 'is_active' => '1',
659 'is_required' => '1',
660 'is_register_field' => '1',
661 'is_search_field' => '1',
662 'is_register_only_field' => '1',
663 );
664
665 $fields[] = array(
666 'form_type' => 'account',
667 'field_type' => 'text',
668 'data_type' => 'XVARCHAR',
669 'site_title' => __('Display Name', 'userswp'),
670 'htmlvar_name' => 'display_name',
671 'default_value' => '',
672 'option_values' => '',
673 'is_default' => '1',
674 'is_public' => '1',
675 'is_active' => '1',
676 'is_required' => '0',
677 'is_register_field' => '0',
678 'is_search_field' => '1',
679 );
680
681 $fields[] = array(
682 'form_type' => 'account',
683 'field_type' => 'email',
684 'data_type' => 'XVARCHAR',
685 'site_title' => __('Email', 'userswp'),
686 'htmlvar_name' => 'email',
687 'default_value' => '',
688 'option_values' => '',
689 'is_default' => '1',
690 'is_active' => '1',
691 'is_required' => '1',
692 'is_register_field' => '1',
693 'is_search_field' => '1',
694 );
695
696
697 $fields[] = array(
698 'form_type' => 'account',
699 'field_type' => 'textarea',
700 'data_type' => 'TEXT',
701 'site_title' => __('Bio', 'userswp'),
702 'htmlvar_name' => 'bio',
703 'default_value' => '',
704 'option_values' => '',
705 'is_default' => '1',
706 'is_active' => '1',
707 'is_public' => '1',
708 'is_required' => '1',
709 'is_search_field' => '1',
710 'show_in' => array('[profile_side]', '[users]')
711 );
712
713 $fields[] = array(
714 'form_type' => 'account',
715 'field_type' => 'password',
716 'data_type' => 'XVARCHAR',
717 'site_title' => __('Password', 'userswp'),
718 'htmlvar_name' => 'password',
719 'default_value' => '',
720 'option_values' => '',
721 'is_default' => '1',
722 'is_active' => '1',
723 'is_required' => '1',
724 'is_register_field' => '1',
725 'is_register_only_field' => '1',
726 'extra' => array(
727 'confirm_password' => '1'
728 )
729 );
730
731
732 $fields = apply_filters('uwp_default_custom_fields_account', $fields);
733
734 return $fields;
735 }
736
737 /**
738 * Flushes rewrite rules.
739 *
740 * @since 1.0.0
741 * @package userswp
742 * @return void
743 */
744 public static function uwp_flush_rewrite_rules() {
745 flush_rewrite_rules();
746 }
747
748 /**
749 * Inserts register form custom fields in form extras table.
750 *
751 * @since 1.0.0
752 * @package userswp
753 * @return void
754 */
755 public static function uwp_insert_form_extras() {
756 global $wpdb;
757 $extras_table_name = uwp_get_table_prefix() . 'uwp_form_extras';
758
759 $fields = array();
760
761 $fields[] = array(
762 'form_type' => 'register',
763 'field_type' => 'text',
764 'is_default' => '1',
765 'htmlvar_name' => 'uwp_account_first_name'
766 );
767
768 $fields[] = array(
769 'form_type' => 'register',
770 'field_type' => 'text',
771 'is_default' => '1',
772 'htmlvar_name' => 'uwp_account_last_name'
773 );
774
775 $fields[] = array(
776 'form_type' => 'register',
777 'field_type' => 'text',
778 'is_default' => '1',
779 'htmlvar_name' => 'uwp_account_username'
780 );
781
782 $fields[] = array(
783 'form_type' => 'register',
784 'field_type' => 'email',
785 'is_default' => '1',
786 'htmlvar_name' => 'uwp_account_email'
787 );
788
789 $fields[] = array(
790 'form_type' => 'register',
791 'field_type' => 'password',
792 'is_default' => '1',
793 'htmlvar_name' => 'uwp_account_password'
794 );
795
796
797 foreach ($fields as $field) {
798 $last_order = $wpdb->get_var("SELECT MAX(sort_order) as last_order FROM " . $extras_table_name);
799 $sort_order = (int)$last_order + 1;
800 $wpdb->query(
801 $wpdb->prepare(
802
803 "insert into " . $extras_table_name . " set
804 form_type = %s,
805 field_type = %s,
806 is_default = %s,
807 site_htmlvar_name = %s,
808 sort_order = %s",
809 array(
810 $field['form_type'],
811 $field['field_type'],
812 $field['is_default'],
813 $field['htmlvar_name'],
814 $sort_order
815 )
816 )
817 );
818 }
819 }
820
821 }