function crf_insert_form_entry($post, $id, $files, $server)
{
global $wpdb;
$crf_fields = $wpdb->prefix . "crf_fields";
$crf_submissions = $wpdb->prefix . "crf_submissions";
$qry1 = "select * from {$crf_fields} where Form_Id= '" . $id . "' and Type not in('heading','paragraph') order by ordering asc";
$reg1 = $wpdb->get_results($qry1);
$entry = array();
$form_type = crf_get_form_option_value('form_type', $id);
$last_insert_id = $wpdb->get_var("SELECT max(`submission_id`) FROM {$crf_submissions}");
$submission_id = $last_insert_id + 1;
$userip = crf_get_global_option_value('userip');
$autoapproval = crf_get_global_option_value('userautoapproval');
$form_options = crf_get_form_option_value('form_option', $id);
$form_option = maybe_unserialize($form_options);
crf_insert_submission($submission_id, $id, 'form_type', $form_type);
crf_insert_submission($submission_id, $id, 'user_approval', $autoapproval);
if ($form_type == 'reg_form') {
$user_name = $post['user_name'];
$user_email = $post['user_email'];
$user_pass = $post['user_pass'];
$role = set_crf_user_role($id, $post, $form_option);
$user_email = $post['user_email'];
crf_insert_submission($submission_id, $id, 'user_name', $user_name);
crf_insert_submission($submission_id, $id, 'user_email', $user_email);
crf_insert_submission($submission_id, $id, 'user_pass', $user_pass);
crf_insert_submission($submission_id, $id, 'role', $role);
}
if (!empty($reg1)) {
foreach ($reg1 as $row1) {
if (!empty($row1)) {
/*file addon start */
$Customfield = crf_get_field_key($row1);
if ($row1->Type == 'file') {
$filefield = $files[$Customfield];
if (is_array($filefield)) {
for ($i = 0; $i <= count($filefield['name']); $i++) {
$file = array('name' => @$filefield['name'][$i], 'type' => @$filefield['type'][$i], 'tmp_name' => @$filefield['tmp_name'][$i], 'error' => @$filefield['error'][$i], 'size' => @$filefield['size'][$i]);
if (@$filefield['error'][$i] === 0) {
if (!function_exists('wp_handle_upload')) {
require_once ABSPATH . 'wp-admin/includes/file.php';
}
$upload_overrides = array('test_form' => false);
$movefile = wp_handle_upload($file, $upload_overrides);
if ($movefile) {
// $filename should be the path to a file in the upload directory.
$filename = $movefile['file'];
// The ID of the post this attachment is for.
$parent_post_id = 0;
// Check the type of tile. We'll use this as the 'post_mime_type'.
$filetype = wp_check_filetype(basename($filename), null);
// Get the path to the upload directory.
$wp_upload_dir = wp_upload_dir();
// Prepare an array of post data for the attachment.
$attachment = array('guid' => $wp_upload_dir['url'] . '/' . basename($filename), 'post_mime_type' => $filetype['type'], 'post_title' => preg_replace('/\\.[^.]+$/', '', basename($filename)), 'post_content' => '', 'post_status' => 'inherit');
// Insert the attachment.
$attach_id[] = wp_insert_attachment($attachment, $filename, $parent_post_id);
}
}
}
}
if (isset($attach_id)) {
$attach_ids = implode(',', $attach_id);
crf_insert_submission($submission_id, $id, $Customfield, $attach_ids);
unset($attach_id);
}
} else {
if (isset($post[$Customfield])) {
if (is_array($post[$Customfield])) {
$value = implode(',', $post[$Customfield]);
} else {
$value = $post[$Customfield];
}
crf_insert_submission($submission_id, $id, $Customfield, $value);
//$entry[$Customfield] = $post[$Customfield];
}
}
/*file addon end */
}
}
}
if ($userip == 'yes') {
crf_insert_submission($submission_id, $id, 'User_IP', $server['REMOTE_ADDR']);
crf_insert_submission($submission_id, $id, 'Browser', $server['HTTP_USER_AGENT']);
}
$time = time();
crf_insert_submission($submission_id, $id, 'entry_time', $time);
return $submission_id;
}
<?php
error_reporting(0);
global $wpdb;
$crf_entries = $wpdb->prefix . "crf_entries";
$crf_submissions = $wpdb->prefix . "crf_submissions";
include 'crf_functions.php';
$qry = "select * from {$crf_entries}";
$reg = $wpdb->get_results($qry);
foreach ($reg as $row) {
$id = $row->id;
$form_id = $row->form_id;
$form_type = $row->form_type;
$user_approval = $row->user_approval;
$value = maybe_unserialize($row->value);
crf_insert_submission($id, $form_id, 'form_type', $form_type);
crf_insert_submission($id, $form_id, 'user_approval', $user_approval);
foreach ($value as $key => $val) {
//echo $key . ' '. $val;
if (is_array($val)) {
$val = implode(',', $val);
}
crf_insert_submission($id, $form_id, $key, $val);
}
}
echo 'submission migrated successful';
update_option("crf_migrate_submission", 'yes');
