Error: You must specify a username! ";
$error = true;
} else {
$aQuery = mysql_query ("SELECT * FROM stagdata_user where username='".$username."' and id != ".$_SESSION['stagdata_user_id']);
if ($row = mysql_fetch_array($aQuery)) {
echo "Error: Username already in use by another user ";
$error = true;
}
}
if (!isset($password) or $password == "" or $password == " ") {
echo "Error: You must specify a password! ";
$error = true;
} else {
if (!isset($repeatPassword) or $repeatPassword == "" or $repeatPassword == " ") {
echo "Error: You must repeat the password! ";
$error = true;
} else {
if ($repeatPassword != $password) {
echo "Error: Your passwords do not match! ";
$error = true;
}
}
}
if (!isset($email) or $email == "" or $email == " ") {
echo "Error: You must specify an email address! ";
$error = true;
} else {
if (strpos($email, "@") < 1) {
echo "Error: Email address does not appear to be valid! ";
$error = true;
} else {
$aQuery = mysql_query ("SELECT * FROM stagdata_user where email='".$email."'");
if ($row = mysql_fetch_array($aQuery) and $row['id'] != $_SESSION['stagdata_user_id']) {
echo "Error: Email address already in use by another user ";
$error = true;
}
}
}
if (!isset($name) or $name == "" or $name == " ") {
echo "Error: You must specify a name! ";
$error = true;
}
}
if (isset($_POST["submit"]) and !$error) {
$sqlQuery = "UPDATE stagdata_user set username='$username', name='$name' where id = ".$_SESSION['stagdata_user_id'];
if (mysql_query($sqlQuery)) {
echo "Account updated sucessfully. Click here to return to your account page. ";
} else {
echo "Sorry, there has been a problem creating your account, please contact Glenn or FieldIT"; //Glenn please put what you like here!
}
if ($password == 'NOT_CHANGED') {
} else {
$sqlQuery = "UPDATE stagdata_user set password='".md5($password)."' where id = ".$_SESSION['stagdata_user_id'];
if (mysql_query($sqlQuery)) {
echo "Password updated sucessfully ";
} else {
echo "Sorry, there has been a problem creating your account, please contact Glenn or FieldIT"; //Glenn please put what you like here!
}
}
if ($email != $original_email) {
$recipient = $email;
$mail_body = "Please click on the following link to confirm your email address change