se supone que este codigo deve grabar el usuario en la base de datos peor no quiere quero que me ayuden para saber donde esta el error. ya estan todas las bases solo falta grabar al usuario
<?php
$title ="New Account";
require_once("php121db.php");
function newuserCheck($username, $password, $confirm_password, $user_email) {
global $db, $prefix, $password, $confirmpassword;
$stop="";
if ((!$username) || ($username=="") || (ereg("[^a-zA-Z0-9_-]",$username))) $stop .= "<font color=\"FF0000\">Invalid USERNAME</font><br>";
if (eregi("^((root)|(adm)|(linux)|(webmaster)|(admin) |(god)|(administrator)|(administrador)|(nobody)|(a nonymous)|(anonimo)|(anónimo)|(operator))$",$usern ame)) $stop .= "<font color=\"FF0000\">Invalid USERNAME</font><br>";
if (strrpos($username,' ') > 0) $stop .= "<font color=\"FF0000\">USERNAMES cannot contain spaces</font><br>";
if (mysql_num_rows(mysql_query("SELECT uname FROM ".$prefix."_users WHERE uname='$username'",$db)) > 0) $stop .= "<font color=\"FF0000\">Please choose a different USERNAME</font><br>";
if ((!$user_email) || ($user_email=="") || (!eregi("^[_\.0-9a-z-]+@([0-9a-z][0-9a-z-]+\.)+[a-z]{2,6}$",$user_email))) $stop .= "<font color=\"FF0000\">Invalid EMAIL</font><br>";
if (strrpos($user_email,' ') > 0) $stop .= "<font color=\"FF0000\">EMAIL addresses cannot contain spaces</font><br>";
if (mysql_num_rows(mysql_query("SELECT uemail FROM ".$prefix."_users WHERE uemail='$user_email'",$db)) > 0) $stop .= "<font color=\"FF0000\">This email address has already been registered</font><br>";
if (strlen($password)<6) $stop.="<font color=\"FF0000\">PASSWORD too short</font><br>";
if ($password!=$confirmpassword) { $stop.="<font color=\"FF0000\">PASSWORDs do not match</font><br>"; $password=""; $confirmpassword=""; }
return($stop);
}
?>
<html>
<head>
<title>PHP121 - New User</title>
</head>
<body>
<?php
echo $opentable;
$username=$HTTP_POST_VARS[username];
$password=$HTTP_POST_VARS[password];
$confirmpassword=$HTTP_POST_VARS[confirmpassword];
$user_email=$HTTP_POST_VARS[email];
$submit=$HTTP_POST_VARS[check];
if ($submit==1){
$stop=newuserCheck($username, $password, $confirmpassword, $user_email);
if ($stop=="") {
mysql_query("INSERT into ".$prefix."_users (`uname`,`upassword`,`uemail`) VALUES ( '$username', md5('$password'), '$user_email')",$db);
echo "Thanks for registering!<br>Please <a href=\"php121login.php\">login</a>.<br></font></td></tr></table></body></html>";
die;
} else {
echo "<font color=\"FF0000\"><b>Error: </b>$stop</font>";
}
}
?>
<form name="newuser" method="POST">
Username:<br><input type="text" style="FONT-FAMILY: Verdana,Helvetica; FONT-SIZE: 12px" name="username" size="20" maxlength="25" value="<?php echo $username; ?>">
<p>
Email:<br><input type="text" style="FONT-FAMILY: Verdana,Helvetica; FONT-SIZE: 12px" name="email" size="20" maxlength="255" value="<?php echo $user_email; ?>">
<p>
Password:<br><font style="FONT-FAMILY: Verdana,Helvetica; FONT-SIZE: 10px">(between 6 and 10 characters)</font><br><input type="password" style="FONT-FAMILY: Verdana,Helvetica; FONT-SIZE: 12px" name="password" size="10" maxlength="10" value="<?php echo $password; ?>">
<p>
Confirm Password:<br><input type="password" style="FONT-FAMILY: Verdana,Helvetica; FONT-SIZE: 12px" name="confirmpassword" size="10" maxlength="10" value="<?php echo $confirmpassword; ?>">
<p>
<input type="submit" action="php121newuser.php" value="Registrar" style="FONT-FAMILY: Verdana,Helvetica; FONT-SIZE: 12px">
<input type="hidden" name="check" value="1">
</form>
<font style="FONT-SIZE: 10px">
<a href="php121login.php">Cancel</a>
<BR>
<a href="php121recoveruser.php">Lost Login Details?</a><br>
</font>
<?php echo $closetable; ?>
</body>
</html>