<?
session_start();
include "includes/db_connect.php";
 
 
$accepted=$_POST['accepted'];
{
mysql_query("UPDATE users SET accepted='yes' WHERE username='$accepted'");
mysql_query("SELECT * FROM users WHERE username='$accepted' AND betakey='$betakey' AND id='$userid' AND email='$email'");
 
$sendto = "$email"; 
$subject = "You've Been Accepted";
$message = "Congratulations $accepted, You have been selected to beta test GAME NAME.
Click To Activate Your Beta Account: http://www.gameurl.com/betaactivate.php?id=$userid&code=$betakey
 
Beta Information:
Username: $accepted
Beta Key: $betakey
Hope You Enjoy
GAME NAME Staff.
This is an automated response, please do not reply!";
mail($sendto, $subject, $message,
"From: GAME NAME<admin@gamename.com>");
print "You made $accepted a beta tester ";
}
?>

mysql_query("SELECT * FROM users WHERE username='$accepted' AND betakey='$betakey' AND id='$userid' AND email='$email'");

$result = mysql_query("SELECT * FROM users WHERE username='$accepted'");
 
$record = mysql_fetch_array($result, MYSQL_ASSOC);
if (!empty($record))
{
$betakey = $record['betakey'];
$userid = $record['userid'];
$email = $record['email'];
}
else
{
// Insert error handler/User notification that sending of email has failed
}