if(mysql_result(mysql_query("SELECT COUNT(`user_id`) FROM `users` WHERE `email` = '$email' AND `email_code` = '$email_code' AND `active` = 0"), 0) == 1) {
if(mysql_result(mysql_query("SELECT COUNT(`user_id`) FROM `users` WHERE `email` = '$email' AND `email_code` = '$email_code' AND `active` = 0"), 0) == 1) {
mysql_query("UPDATE `users` SET `active` = 1 WHERE `email` = '$email'");
mysql_query("UPDATE `users` SET `active` = 1 WHERE `email` = '$email'");
return true;
return true;
} else {
} else {
return false;
return false;
}
}
}
}
function change_password($user_id, $password) {
function change_password($user_id, $password) {
$user_id = (int)$user_id;
$user_id = (int)$user_id;
$password = md5($password);
$password = md5($password);
mysql_query("UPDATE `users` SET `password` = '$password' WHERE `user_id` = $user_id");
mysql_query("UPDATE `users` SET `password` = '$password' WHERE `user_id` = $user_id");