/**
* 将作文大赛的用户迁移至悠游网数据库中
*/
require 'connect.php';
set_time_limit(0);
//$sql = "SELECT * FROM `users_zuowen` ORDER BY uid ";
$sql = "SELECT * FROM `users_zuowen` ";
$rs = mysql_query($sql);
$user_fields = user_fields();
$i = 0;
while ($row = mysql_fetch_assoc($rs)) {
if (!user_exits($row['name'])) {
user_save($user_fields, user_insert($row));
} else {
$user_info = user_insert(user_info_change($row));
user_save($user_fields, $user_info);
}
$i++;
}
echo $i . "个用户";
function user_save($fields, $arr)
{
$query = "\tINSERT INTO `users` (" . implode(",", $fields) . ") VALUES (" . implode(",", $arr) . ") ";
$rs = mysql_query($query);
if ($rs) {
return true;
} else {
return false;
}
}
$bio = mysqli_real_escape_string($dbc, $_POST['bio']);
$password = sha1(SHA1_SALT . $_POST['password']);
$confirm = sha1(SHA1_SALT . $_POST['confirm']);
if ($email == false) {
$_SESSION['register_errors'][] = "Email is not valid";
} else {
if (user_email_exists($email)) {
$_SESSION['register_errors'][] = "Email already exists";
}
}
if ($password != '' && $confirm != '') {
if ($password != $confirm) {
$_SESSION['register_errors'][] = "Passwords don't match";
}
} else {
$_SESSION['register_errors'][] = "Please complete password fields";
}
if (!isset($_SESSION['register_errors'])) {
$update = user_insert($name, $email, $bio, $password);
if ($update) {
header('Location: index.php?controller=login');
break;
} else {
$_SESSION['register_errors'][] = "Sorry! There has been an error with the database: " . mysqli_error($dbc);
}
}
$_SESSION['name'] = $name;
$_SESSION['email'] = $email;
$_SESSION['bio'] = $bio;
header('Location: index.php?controller=register');
}
}
//If there are input validations, redirect back to the register form
if ($errflag) {
$tpl->errors = $errmsg_arr;
} else {
// insert to database
unset($_POST['data']['number1']);
unset($_POST['data']['number2']);
unset($_POST['data']['captchatotal']);
$data = array();
$data["firstname"] = $first_name;
$data["lastname"] = $last_name;
$data["fullname"] = clean($fullname);
$data["password"] = $n_password;
$data["user_email"] = $user_email;
$userdata = user_insert($database, $data);
if ($userdata) {
// Send password to email
$to = $user_email;
$subject = 'Registration Successfull at ' . site_name;
$message = 'Hello ' . $first_name . '<br>You have successfully registered at ' . site_name . '. If you have any questions, please do reply back to the same email.' . '<br>' . 'Thanks ' . '<br>' . site_name;
$sendmail = sendEmail($to, $subject, $message, $shortcodes = null, $from = null, $mail);
if ($sendmail) {
header("Location: " . main_url . "/register/success");
exit;
}
}
}
} catch (Exception $e) {
// CSRF attack detected
$result = $e->getMessage() . ' Form ignored.';
