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 . '

'; } ?>
Username:
Conf Code:
 

Thank you for confirming. Please click here to enter the contest area..