root/form/import_profile.php

<?php

/*
 * Elgg Forms
 * Kevin Jardine
 * Radagast Solutions
 * http://radagast.biz
 *
 * Reads the current profile.config.php file
 * and stores the result in "profile" and
 * "registration" forms.
 *
 */
 
// Load Elgg framework
@require_once("../../includes.php");
    
// Define context
define("context","form");

$title = __gettext("Profile import");

$return_bit = '<p>'.__gettext('You can return to the').' <a href="'.$CFG->wwwroot.'mod/form/index.php">'.__gettext('main form page by clicking here').'</a>.</p>';

if (isloggedin() && run("users:flags:get", array("admin", $_SESSION['userid']))) { 

    if (record_exists('forms','name','profile')) {
        $body = '<p>'.__gettext('The form "profile" already exists. Please').' <a href="'.$CFG->wwwroot.'mod/form/index.php">'
            .__gettext('rename or delete it').'</a> '.__gettext('before running this profile import.')."</p>\n".$return_bit;
    } else if (record_exists('forms','name','registration')) {
        $body = '<p>'.__gettext('The form "registration" already exists. Please').' <a href="'.$CFG->wwwroot.'mod/form/index.php">'
            .__gettext('rename or delete it').'</a> '.__gettext('before running this profile import.')."</p>\n".$return_bit;
    } else if (record_exists('forms','name','community_profile')) {
        $body = '<p>'.__gettext('The form "community_profile" already exists. Please').' <a href="'.$CFG->wwwroot.'mod/form/index.php">'
            .__gettext('rename or delete it').'</a> '.__gettext('before running this profile import.')."</p>\n".$return_bit;
    } else if (record_exists('forms','name','join')) {
        $body = '<p>'.__gettext('The form "join" already exists. Please').' <a href="'.$CFG->wwwroot.'mod/form/index.php">'
            .__gettext('rename or delete it').'</a> '.__gettext('before running this profile import.')."</p>\n".$return_bit;
    } else {
        require_once($CFG->dirroot.'mod/profile/profile.config.php');
        
        // check for duplicate field names
        $name_list = '';
        $existing_field_list = '';
        $field_list = '';
        if (isset($data['profile:details']) && count($data['profile:details']) > 0) {
            foreach($data['profile:details'] AS $field) {
                $field_list .= ",'{$field->internal_name}'";
            }
            $field_list = substr($field_list,1);
            $results = get_records_sql("SELECT * FROM {$CFG->prefix}form_fields WHERE internal_name in ($field_list)");
            if ($results) {
                foreach($results AS $field) {
                    $existing_field_list .= ", {$field->internal_name}";
                }
                $existing_field_list  = substr($existing_field_list,2);
            }
        }
        
        if ($existing_field_list) {
            $body = '<p>'.__gettext('The profile import cannot be carried out because the following profile fields are already defined'
            .' in the database:').'</p><p>'.$existing_field_list.'</p>'."\n".$return_bit;
        } else {            
            $user_id = $_SESSION['userid'];
            
            // insert profile form
            $form = new stdClass;
            $form->name = 'profile';
            $form->access = 'user'.$user_id;
            $form->owner = $user_id;
            $form->created = time();
            $form->title = __gettext('Profile');
            $form->description = __gettext('You can use this form for testing your profile fields - it should never be directly made public.');
            $form->response_text = __gettext('Thanks for testing these profile fields.');
            $profile_form_id = insert_record('forms',$form);
            
            // insert profile form
            $form = new stdClass;
            $form->name = 'community_profile';
            $form->access = 'user'.$user_id;
            $form->owner = $user_id;
            $form->created = time();
            $form->title = __gettext('Community Profile');
            $form->description = __gettext('You can use this form for testing your community profile fields - it should never be directly made public.');
            $form->response_text = __gettext('Thanks for testing these community profile fields.');
            $community_profile_form_id = insert_record('forms',$form);
            
            // insert join form
            $form = new stdClass;
            $form->name = 'join';
            $form->access = 'user'.$user_id;
            $form->owner = $user_id;
            $sitename = $CFG->sitename;
            $form->created = time();
            $form->title = __gettext('Join').' '.$sitename;
            
            $sitename = sitename;
            $partOne = sprintf(__gettext("Thank you for registering for an account with %s! Registration is completely free, but before you fill in your details, please take a moment to read the following documents:"),$sitename); // gettext variable
            $terms = __gettext("terms and conditions"); // gettext variable
            $privacy = __gettext("Privacy policy"); // gettext variable
            $partFour = __gettext("When you fill in the details below, we will send an \"invitation code\" to your email address in order to validate it. You must then click on this within seven days to create your account."); // gettext variable
                            
            $form->description = <<< END
    <p>
        $partOne
    </p>
    <ul>
        <li><a href="{$CFG->wwwroot}content/terms.php" target="_blank">$sitename $terms</a></li>
        <li><a href="{$CFG->wwwroot}content/privacy.php" target="_blank">$privacy</a></li>
    </ul>
    <p>
        $partFour
    </p>                
END;
            $form->response_text = '';
            insert_record('forms',$form);
            
            // insert registration form
            $form = new stdClass;
            $form->name = 'registration';
            $form->access = 'user'.$user_id;
            $form->owner = $user_id;
            $sitename = $CFG->sitename;
            $form->created = time();
            $form->title = __gettext('Join').' '.$sitename;
            $thankYou = sprintf(__gettext("Thank you for registering for an account with %s! Registration is completely free, but before you confirm your details, please take a moment to read the following documents:"), $sitename);
            $terms = __gettext("terms and conditions"); // gettext variable
            $privacy = __gettext("Privacy policy"); // gettext variable
            $age = __gettext("Submitting the form below indicates acceptance of these terms. Please note that currently you must be at least 13 years of age to join the site."); // gettext variable
            $form->description .= <<< END
                
            <p>
                $thankYou
            </p>
            <ul>
                <li><a href="{$CFG->wwwroot}content/terms.php" target="_blank">$sitename $terms</a></li>
                <li><a href="{$CFG->wwwroot}content/privacy.php" target="_blank">$privacy</a></li>
            </ul>
            <p>
                $age
            </p>
END;
            $form->response_text = __gettext("Your account was created! You can now log in using the username and password you supplied. You have been sent an email containing these details for reference purposes.");
        
            $registration_form_id = insert_record('forms',$form);
            
            // insert the fields
            
            form_import_insert_fields($profile_form_id, $community_profile_form_id, $registration_form_id);

            $body = '<p>'.__gettext('Your profile has been successfully imported into the forms "profile", "community_profile", "join" and "registration".').'</p>';
            $body .= "\n".$return_bit;
        }
    }
} else {
    $body = __gettext("You need to be logged-in as a site administrator to access this page.");
}


// Output to the screen
$body = templates_draw(array(
                'context' => 'contentholder',
                'title' => $title,
                'body' => $body
            )
);

echo templates_page_draw( array(
                $title, $body
            )
);

    
function startsWith( $str, $sub ) {
   return ( substr( $str, 0, strlen( $sub ) ) === $sub );
}
            
function endsWith( $str, $sub ) {
   return ( substr( $str, strlen( $str ) - strlen( $sub ) ) === $sub );
}

function form_import_insert_fields($profile_form_id, $community_profile_form_id, $registration_form_id) {
    
    global $CFG, $data;
    
    $profile_field_count = 0;
    $community_profile_field_count = 0;
    $registration_field_count = 0;
           
    if (isset($data['profile:details']) && count($data['profile:details']) > 0) {
        foreach($data['profile:details'] AS $field) {
            $fd = new stdClass;
            $fd->internal_name = $field->internal_name;
            $fd->original_internal_name = $field->internal_name;
            $fd->title = $field->name;
            $fd->description = $field->description;
            $fd->category = $field->category;
            $fd->default_access = isset($field->default_access)?$field->default_access:'';
            $fd->required = isset($field->required)?$field->required:false;
            $fd->invisible = isset($field->invisible)?$field->invisible:false;
            $fd->profile = 1;
            if (isset($field->col1) && $field->col1) {
                $fd->col = 1;
            } else if (isset($field->col2) && $field->col2) {
                $fd->col = 2;
            } else {
                $fd->col = 0;
            }
                
            if (isset($CFG->prfext_data) && isset($CFG->prfext_data[$field->field_type])) {
                $fd->field_type = 'choices';
                $d = $CFG->prfext_data[$field->field_type];
                $display_type = $d->display_type;
                $fd->is_keyword_tag = $d->is_keyword_tag;
                $fd->default_value = $d->default_value;
                
                if (endsWith($display_type,'radio')) {
                    $fd->choice_type = 'radio';
                    if (startsWith($display_type, 'profile_vertical')) {
                        $fd->orientation = 'vertical';
                    } else {
                        $fd->orientation = 'horizontal';
                    }
                } else if (endsWith($display_type,'checkbox')) {
                    $fd->choice_type = 'checkbox';
                    if (startsWith($display_type, 'profile_vertical')) {
                        $fd->orientation = 'vertical';
                    } else {
                        $fd->orientation = 'horizontal';
                    }
                } else {
                    $fd->choice_type = 'checkbox';
                    $fd->orientation = 'vertical';
                }
            } else {
                $fd->field_type = $field->field_type;
                $fd->is_keyword_tag = 0;
                $fd->default_value = '';
                $fd->orientation = 'horizontal';
            }
            
            // rename community-specific field to avoid potential conflict
            // with person fields
                           
            if (!empty($field->user_type) && $field->user_type == 'community') {
                $fd->internal_name = 'community_'.$fd->internal_name;
            } 
            $field_id = insert_record('form_fields',$fd);
            
            // set up field / form maps
            
            if (empty($field->user_type) || $field->user_type == 'person') {
                $map = new stdClass;            
                $map->form_id = $profile_form_id;
                $map->field_id = $field_id;
                $map->display_order = 10*($profile_field_count+1);
                insert_record('form_fields_map',$map);
                $profile_field_count++;
            }
            
            if (empty($field->user_type) || $field->user_type == 'community') {
                $map = new stdClass;
                $map->form_id = $community_profile_form_id;
                $map->field_id = $field_id;
                $map->display_order = 10*($community_profile_field_count+1);
                insert_record('form_fields_map',$map);
                $community_profile_field_count++;
            }
            
            if (isset($field->registration) && $field->registration) {            
                $map = new stdClass;
                $map->form_id = $registration_form_id;
                $map->field_id = $field_id;
                $map->display_order = 10*($registration_field_count+1);
                insert_record('form_fields_map',$map);
                $registration_field_count++;
            }
            
            // insert options, if any
            if ($fd->field_type == 'choices') {
                if (isset($d->options) and count($d->options) > 0) {
                    if (prfext_array_is_associative ($d->options)) {
                        foreach ($d->options AS $value => $label) {
                            $option = new stdClass;
                            $option->field_id = $field_id;
                            $option->value = $value;
                            $option->label = $label;
                            insert_record('form_fields_choice',$option);
                        }
                    } else {
                        foreach ($d->options AS $value) {
                            $option = new stdClass;
                            $option->field_id = $field_id;
                            $option->value = $value;
                            $option->label = '';
                            insert_record('form_fields_choice',$option);
                        }
                    }
                }
            }
        }
    }
}

?>