/**
* Sends back the password to the email used for the registration.
*/

echo "

\n";
if($_GET["EMAIL"] <> "")
{
$res=$db->Execute("SELECT ID,USERNAME,PASSWORD,AUTHORIZED FROM PLAYER WHERE EMAIL = ".$db->qstr(trim($_GET["EMAIL"])));
if(!$res->EOF)
{
if($res->fields[3] == 'Y')
{
$msg="Hi there,

It appears someone tried to recover your password for the RPG game 'No where else and beyond', hopefully it's you.
Here is the login information needed:

Username: ".$res->fields[1]."
Password: ".$res->fields[2]."

This information has been sent only via email. That means if someone else tried to recover your password,
he/she will fail to get the needed information.

Sincerely,

The No where else and beyond staff.";
mail($_GET["EMAIL"],"No where else and beyond",$msg,"From: [e-mail]\n");
echo "You should receive an email with your username and password in your mailbox.

\n";
echo "[Ok...]";
}
else
{
$msg="Hi,

In order to enable your 'No where else and beyond' account, please click
on the following link, or copy and paste it in your browser:

http://www.nodalideas.com/rpg/index.php?ACTION=REGISTER&DO=CONFIRM&ID=".$res->fields[0]."

The No where else and beyond staff.";
mail($_GET["EMAIL"],"No where else and beyond registration",$msg,"From: [e-mail]\n");
echo "This account as not yet been activated. We sent again an activation email. Follow the email instructions in order to activate your account.

\n";
echo "[Ok...]";
}
}
else
{
echo "There is no registration with this email. Sorry...

\n";
echo "[Mmm...]";
}
$res->Close();
}
else
{
$focus="document.forms['recover'].EMAIL.focus();";
?>

Lost password
Enter the email used during the registartion: [Recover password]

}
?>