readfile ("includes/top_inc.php") ?>
VIEW REGISTRATION KEY
if ( !isset($_POST['szLoginID1']) )
{
?>
If you have an account please Login Below.
Your email address does not appear to be valid.
\n"; else if ( $password != $confirmpassword || $confirmpassword == '' ) $failedmessage .= "Your passwords don't match.
\n"; else { if ( $username == '' ) // $ToDo Or in db { $failedmessage .= "Your user name does not appear to be valid.
\n"; } else { $result = Query( "SELECT UserName FROM `CallTheBall`.`WebExcavatorRegister` where UserName = '".$username."'" ); if ( $result != false && Num_Rows($result) > 0 ) $failedmessage .= "Sorry, your chosen user name is already in use.
\n"; else { $sql = "insert into `CallTheBall`.`WebExcavatorRegister` ( UserName, Password, Email, tstamp ) values ( '".$username."', '".$password."', '".$szEmail."', NOW() )"; $result = Query( $sql ); } } } } else { $password = str_replace("'", "''", $_POST['szPassword1'] ); $sql = "SELECT `Key` FROM `CallTheBall`.`WebExcavatorRegister` where UserName = '".$username."' and `Password` = '".$password."'"; $result = Query( $sql ); if ( $result == false || Num_Rows($result) <= 0 ) $failedmessage = "Sorry your account was not found"; else { $key = Result($result, 0, "key"); $paid = true; } // Else if isset($_POST['key1']) temporarily just create a key and add it to the account $paid = true; if ( $failedmessage == '' && (isset($_POST['key1']) || $key == '') ) { include( "includes/key_inc.php" ); $key = GenerateKey( $username ); $sql = "Update `CallTheBall`.`WebExcavatorRegister` set `Key` = '".$key."' where UserName = '".$username."' and `Password` = '".$password."'"; $result = Query( $sql ); $paid = true; } } if ( $failedmessage != '' ) { echo 'Error:Please try again.
\n"; echo $failedmessage .''; echo '
'; echo ' Name: '.$username.' Key: '.$key.'