Tema: Error MySQL
Ver Mensaje Individual
  #6 (permalink)  
Antiguo 26/05/2011, 15:46
Duffing
 
Fecha de Ingreso: mayo-2011
Mensajes: 47
Antigüedad: 13 años
Puntos: 0
Respuesta: Error MySQL

Disculpa es que el post que hice solo me dejaba poner 10000 caracteres y el codigo es de 13000
Código PHP:
Ver original
  1. <?php
  2. $webtitle= "Create a free account";
  3. //CREATED BY MENTALBLANK
  4. //http://cris-is.stylin-on.me/
  5.  
  6. //MODIFIED BY ZEROSKULL
  7.  
  8. # Connect to the database
  9. include("config.php");
  10.  
  11. //IMPORTANT STUFFS
  12. $birthdate = $_POST['yearOfBirth'].$_POST['monthOfBirth'].$_POST['dateOfBirth'];
  13. $age = mysql_real_escape_string(stripslashes(intval((date("Ymd",mktime()) - $birthdate)/10000)));
  14. $dob = $_POST["date"]."/".$_POST["day"]."/".$_POST["year"];
  15. $gender = mysql_real_escape_string(stripslashes($_POST["strGender"]));
  16. $username = mysql_real_escape_string(stripslashes($_POST["strUsername"]));
  17. $password = mysql_real_escape_string(stripslashes($_POST["strPassword"]));
  18. $classid = mysql_real_escape_string(stripslashes($_POST["ClassID"]));
  19. $skincol = mysql_real_escape_string(stripslashes(hexdec($_POST["skincol"])));
  20. $haircol = mysql_real_escape_string(stripslashes(hexdec($_POST["haircol"])));
  21. $eyecol = mysql_real_escape_string(stripslashes(hexdec($_POST["eyecol"])));
  22. $pass = md5($password);
  23. $email = $_POST["strEmail"];
  24.  
  25. //Grabs IP
  26. if ($_SERVER['HTTP_X_FORWARD_FOR']) {
  27.     $ip = $_SERVER['HTTP_X_FORWARD_FOR'];
  28. } else {
  29.     $ip = $_SERVER['REMOTE_ADDR'];
  30. }
  31.  
  32.  //This checks if the form has been submitted.
  33.  if (isset($_POST['submit'])) {
  34.  
  35. //Checks if IP already has an Account
  36. $ipcheck = mysql_query("SELECT * FROM wqw_users WHERE signupip='$ip' AND banned=0");
  37. if (mysql_num_rows($ipcheck) != 0) {
  38.     die("Sorry, This IP has already created an account");
  39. }
  40.  
  41. //Checks if Username, etc. Only Contains Specified Characters and is not blank.
  42. //Helps to Prevent SQL Injection...etc.
  43. if (!preg_match('/^[a-z0-9\s_-]+$/i', $username) || ($username == "")) {
  44.     die('Error, Username must contain Letters and/or Numbers');
  45. }
  46.  
  47. if (!preg_match('/^[a-z0-9]+$/i', $password) || ($password == "")) {
  48.     die('Error, Password must contain Letters and/or Numbers');
  49. }
  50.  
  51. if (!preg_match('/^[0-9]+$/i', $age) || ($age == "")) {
  52.     die('Error, Age Must Be A Number');
  53. }
  54.  
  55. if (!preg_match('/^[a-z]+$/i',$gender) || ($gender != "M" && $gender != "F")) {
  56.     die('Error, Gender Must Be an "M" or "F"');
  57. }
  58. /*
  59. if (!preg_match('/^([\d]|1[0,1,2])/([0-9]|[0,1,2][0-9]|3[0,1])/\d{4}$/i', $dob)){
  60.     die('Error, Date of birth must be in this format 00/00/0000 or 0/0/0000');
  61. }*/
  62. if(!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $email) || ($email == "")) {
  63.     die('Error, Email Must Contain Letters and/or Numbers');
  64. }
  65.  
  66. //Converts Date of Birth to a readable mySQL Query String
  67. $dob = mysql_real_escape_string(stripslashes($_POST["date"]."/".$_POST["day"]."/".$_POST["year"]));
  68.  
  69. //This Checks if the 2 passwords given match
  70.  if ($_POST['strPassword'] != $_POST['strPassword2']) {
  71.     die('Error, Passwords Do not Match. Please Try Again.');
  72.  }
  73.  
  74.  //This checks if the username is in use
  75.  $check = mysql_query("SELECT username FROM wqw_users WHERE username = '$username'") or die(mysql_error());
  76.  if (mysql_num_rows($check) != 0) {
  77.         die('Sorry, the username '.$_POST['strUsername'].' is already in use.');
  78.  }
  79.  
  80.  //Checks if Email has Already been used
  81.  $emailcheck = mysql_query("SELECT * FROM wqw_users WHERE email='$email' AND banned=0") or die("status=Error&strReason=" . mysql_error());
  82.  if (mysql_num_rows($emailcheck) != 0) {
  83.      die("Sorry, This Email has already been used.");
  84.  }
  85.  
  86. //Filtered words
  87. if (ereg("\Admin", $chartype)) {
  88. Die('The username you entered is not allowed, Please enter another one....');
  89.    }
  90. elseif (ereg("\admin", $chartype)) {
  91. Die('The username you entered is not allowed, Please enter another one....');
  92.    }
  93. elseif (ereg("\administrator", $chartype)) {
  94. Die('The username you entered is not allowed, Please enter another one....');
  95.    }
  96. elseif (ereg("\Administrator", $chartype)) {
  97. Die('The username you entered is not allowed, Please enter another one....');
  98.    }
  99. elseif (ereg("\mod", $chartype)) {
  100. Die('The username you entered is not allowed, Please enter another one....');
  101.    }
  102. elseif (ereg("\Mod", $chartype)) {
  103. Die('The username you entered is not allowed, Please enter another one....');
  104.    }
  105. elseif (ereg("\moderatore", $chartype)) {
  106. Die('The username you entered is not allowed, Please enter another one....');
  107.    }
  108. elseif (ereg("\Moderatore", $chartype)) {
  109. Die('The username you entered is not allowed, Please enter another one....');
  110.    }
  111. elseif (ereg("\Game Master", $chartype)) {
  112. Die('The username you entered is not allowed, Please enter another one....');
  113.    }
  114. elseif (ereg("\game master", $chartype)) {
  115. Die('The username you entered is not allowed, Please enter another one....');
  116.    }
  117. elseif (ereg("\gamemaster", $chartype)) {
  118. Die('The username you entered is not allowed, Please enter another one....');
  119.    }
  120. elseif (ereg("\Gamemaster", $chartype)) {
  121. Die('The username you entered is not allowed, Please enter another one....');
  122.    }
  123. elseif (ereg("\GameMaster", $chartype)) {
  124. Die('The username you entered is not allowed, Please enter another one....');
  125.    }
  126. elseif (ereg("\Safiria", $chartype)) {
  127. Die('The username you entered is not allowed, Please enter another one....');
  128.    }
  129. elseif (ereg("\safiria", $chartype)) {
  130. Die('The username you entered is not allowed, Please enter another one....');
  131.    }
  132. elseif (ereg("\zeroskull", $chartype)) {
  133. Die('The username you entered is not allowed, Please enter another one....');
  134.    }
  135. elseif (ereg("\soulreaper", $chartype)) {
  136. Die('The username you entered is not allowed, Please enter another one....');
  137.    }
  138. elseif (ereg("\SoulReaper", $chartype)) {
  139. Die('The username you entered is not allowed, Please enter another one....');
  140.    }
  141. elseif (ereg("\ZeroSkull", $chartype)) {
  142. Die('The username you entered is not allowed, Please enter another one....');
  143.    }
  144. elseif (ereg("\Zeroskull", $chartype)) {
  145. Die('The username you entered is not allowed, Please enter another one....');
  146.    }
  147.    
  148.  //This Inserts the Data into the database
  149.     if($gender == "F"){
  150.         $createuser = mysql_query("INSERT INTO wqw_users (username, password, email, age, dob, signupip, gender, coins, currentclass, hairName, hairFile, hairID, plaColorSkin, plaColorHair, plaColorEyes)
  151.         VALUES ('$username', '$pass', '$email', '$age', '$dob', '$ip','$gender',50000,'1','Saf1','hair/F/saf1.swf','234','$skincol','$haircol','$eyecol')");
  152.     }
  153.     else