 Error MySQL
Hola, ¿como les va?
Estoy haciendo una web en PHP pero resulta que nececito un creador de cuentas para un juego.
Saque los codigos de fuente de una web pero me tira el siguiente error:
"Error adding class! contact PDL Staff immediately!Incorrect integer value: '' for column 'userid' at row 1"
El codigo es:
[CODE]<?php
ob_start();
session_start();
$webtitle= "Create a free account";
//CREATED BY MENTALBLANK
//http://cris-is.stylin-on.me/
//MODIFIED BY ZEROSKULL
# Connect to the database
include("config.php");
//IMPORTANT STUFFS
$birthdate = $_POST['yearOfBirth'].$_POST['monthOfBirth'].$_POST['dateOfBirth'];
$age = mysql_real_escape_string(stripslashes(intval((date ("Ymd",mktime()) - $birthdate)/10000)));
$dob = $_POST["date"]."/".$_POST["day"]."/".$_POST["year"];
$gender = mysql_real_escape_string(stripslashes($_POST["strGender"]));
$username = mysql_real_escape_string(stripslashes($_POST["strUsername"]));
$password = mysql_real_escape_string(stripslashes($_POST["strPassword"]));
$classid = mysql_real_escape_string(stripslashes($_POST["ClassID"]));
$skincol = mysql_real_escape_string(stripslashes(hexdec($_POS T["skincol"])));
$haircol = mysql_real_escape_string(stripslashes(hexdec($_POS T["haircol"])));
$eyecol = mysql_real_escape_string(stripslashes(hexdec($_POS T["eyecol"])));
$pass = md5($password);
$email = $_POST["strEmail"];
//Grabs IP
if ($_SERVER['HTTP_X_FORWARD_FOR']) {
$ip = $_SERVER['HTTP_X_FORWARD_FOR'];
} else {
$ip = $_SERVER['REMOTE_ADDR'];
}
//This checks if the form has been submitted.
if (isset($_POST['submit'])) {
//Checks if IP already has an Account
$ipcheck = mysql_query("SELECT * FROM wqw_users WHERE signupip='$ip' AND banned=0");
if (mysql_num_rows($ipcheck) != 0) {
die("Sorry, This IP has already created an account");
}
//Checks if Username, etc. Only Contains Specified Characters and is not blank.
//Helps to Prevent SQL Injection...etc.
if (!preg_match('/^[a-z0-9\s_-]+$/i', $username) || ($username == "")) {
die('Error, Username must contain Letters and/or Numbers');
}
if (!preg_match('/^[a-z0-9]+$/i', $password) || ($password == "")) {
die('Error, Password must contain Letters and/or Numbers');
}
if (!preg_match('/^[0-9]+$/i', $age) || ($age == "")) {
die('Error, Age Must Be A Number');
}
if (!preg_match('/^[a-z]+$/i',$gender) || ($gender != "M" && $gender != "F")) {
die('Error, Gender Must Be an "M" or "F"');
}
/*
if (!preg_match('/^([\d]|1[0,1,2])/([0-9]|[0,1,2][0-9]|3[0,1])/\d{4}$/i', $dob)){
die('Error, Date of birth must be in this format 00/00/0000 or 0/0/0000');
}*/
if(!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $email) || ($email == "")) {
die('Error, Email Must Contain Letters and/or Numbers');
}
//Converts Date of Birth to a readable mySQL Query String
$dob = mysql_real_escape_string(stripslashes($_POST["date"]."/".$_POST["day"]."/".$_POST["year"]));
//This Checks if the 2 passwords given match
if ($_POST['strPassword'] != $_POST['strPassword2']) {
die('Error, Passwords Do not Match. Please Try Again.');
}
//This checks if the username is in use
$check = mysql_query("SELECT username FROM wqw_users WHERE username = '$username'") or die(mysql_error());
if (mysql_num_rows($check) != 0) {
die('Sorry, the username '.$_POST['strUsername'].' is already in use.');
}
//Checks if Email has Already been used
$emailcheck = mysql_query("SELECT * FROM wqw_users WHERE email='$email' AND banned=0") or die("status=Error&strReason=" . mysql_error());
if (mysql_num_rows($emailcheck) != 0) {
die("Sorry, This Email has already been used.");
}
//Filtered words
if (ereg("\Admin", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\admin", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\administrator", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\Administrator", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\mod", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\Mod", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\moderatore", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\Moderatore", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\Game Master", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\game master", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\gamemaster", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\Gamemaster", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\GameMaster", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\Safiria", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\safiria", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\zeroskull", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\soulreaper", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\SoulReaper", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\ZeroSkull", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
elseif (ereg("\Zeroskull", $chartype)) {
Die('The username you entered is not allowed, Please enter another one....');
}
//This Inserts the Data into the database
if($gender == "F"){
$createuser = mysql_query("INSERT INTO wqw_users (username, password, email, age, dob, signupip, gender, coins, currentclass, hairName, hairFile, hairID, plaColorSkin, plaColorHair, plaColorEyes)
VALUES ('$username', '$pass', '$email', '$age', '$dob', '$ip','$gender',50000,'1','Saf1','hair/F/saf1.swf','234','$skincol','$haircol','$eyecol')") ;
}
else |