debug = TRUE;
$db->setTable("contestants");
$db->useDB("sportsmans");
if ($username) {
if ($db->exists("username", $username, "contestants")) {
if (!$db->pullVal("confirmed", "username", $username)) {
if ($confcode == $db->pullVal("confcode", "username", $username)) {
$db->execute("UPDATE contestants SET confirmed = 1 where username = '$username'");
$ok = 1;
$_SESSION[sLogin] = $username;
}
else {
$err = "Confirmation codes do not match. Please re-check your email.";
}
}
else {
$err = "You have already confirmed your registration. Please log in.";
}
}
else {
$err = "Sorry, but your username was not found in the contestant database. Please register for the contest.";
}
}
?>
Contest Confirmation
Please enter your username and confirmation code below:
'. $err . ''; } ?>
Thank you for confirming. Please click here to enter the contest area..