function validateaccount($email, $rand_key_confirm)
{
$rand_key = $rand_key_confirm;
$PDO = Record::getConnection();
$check_validated = "SELECT * FROM " . TABLE_PREFIX . "user WHERE email='{$email}'";
$result = $PDO->prepare($check_validated);
$result->execute();
$count = $result->rowCount();
if ($count > 0) {
$settings = Plugin::getAllSettings("registered_users");
$met = $settings["message_error_technical"];
$message_empty_name = $settings["message_empty_name"];
$message_empty_email = $settings["message_empty_email"];
$message_empty_username = $settings["message_empty_username"];
$message_empty_password = $settings["message_empty_password"];
$message_empty_password_confirm = $settings["message_empty_password_confirm"];
$message_notvalid_password = $settings["message_notvalid_password"];
$message_notvalid_username = $settings["message_notvalid_username"];
$message_notvalid_email = $settings["message_notvalid_email"];
$message_error_already_validated = $settings["message_error_already_validated"];
echo $message_error_already_validated;
} else {
$today = date('Y-m-d G:i:s');
$registration_temp = "SELECT * FROM " . TABLE_PREFIX . "registered_users_temp WHERE email='{$email}'";
foreach ($PDO->query($registration_temp) as $row) {
$name = $row['name'];
$email = $row['email'];
$username = $row['username'];
$password = $row['password'];
$rand_key = $row['rand_key'];
$reg_date = $row['reg_date'];
$welcome_message = $row['welcome_message'];
$message_notvalid_password = $row['message_notvalid_password'];
}
if ($rand_key_confirm == $rand_key) {
// Let's transfer the user from the temp table to the user table
//$update_user_table = "INSERT INTO ".TABLE_PREFIX."user (`id`,`name`,`email`,`username`,`password`,`created_on`,`updated_on`,`created_by_id`,`updated_by_id`) VALUES ('','$name','$email','$username','$password','$reg_date','$today','','');";
//$stmt = $__CMS_CONN__->prepare($update_user_table);
//$stmt->execute();
$user = new User();
$user->name = $name;
$user->email = $email;
$user->username = $username;
$user->salt = AuthUser::generateSalt();
$user->password = AuthUser::generateHashedPassword($password, $user->salt);
$user->created_on = $reg_date;
$user->updated_on = $today;
$user->save();
// We don't need them in the temp table anymore
$delete_temp_user = "******" . TABLE_PREFIX . "registered_users_temp WHERE email='{$email}'";
$stmt = $PDO->prepare($delete_temp_user);
$stmt->execute();
// And let's make sure we have some permissions set so that user can then do something!
// First we need the default permssion ID
$def_permission = Plugin::getSetting("default_permissions", "registered_users");
// Then we need the correct user ID
/*$user = "******".TABLE_PREFIX."user WHERE email='$email'";
foreach ($__CMS_CONN__->query($user) as $row) {
$id = $row['id'];
}*/
$id = $user->id;
$set_permissions = "INSERT INTO " . TABLE_PREFIX . "user_role (`user_id`,`role_id`) VALUES ('{$id}','{$permission_id}');";
$stmt = $PDO->prepare($set_permissions);
$stmt->execute();
// We also need to add the profile settings into DB
$addprofile = "INSERT INTO " . TABLE_PREFIX . "user_profile (`id`,`firstlogin`,`subscribe`,`sysnotifications`,`haspic`,`profile_blurb`) VALUES ({$id},'1','1','1','0','your public profile...');";
$addprofile = $PDO->prepare($addprofile);
$addprofile->execute();
echo $welcome_message;
$loadloginclass = new RegisteredUser();
$loadloginclass->login_page();
} else {
echo $message_notvalid_password;
}
}
}
function ru_login_page()
{
$registered_users_class = new RegisteredUser();
$loginpage = $registered_users_class->login_page();
echo $loginpage;
}
