Reply to thread

Message

<blockquote data-quote="Daltron" data-source="post: 452875" data-attributes="member: 61885">Alrighty so, here is my code [CODE=php]&lt;?php require_once(&quot;inc/core.god.php&quot;);&nbsp; &nbsp; &nbsp; &nbsp; if(Loged == TRUE)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; header(&quot;Location: me&quot;);&nbsp; &nbsp; &nbsp; &nbsp; exit;&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; if(MANTENIMIENTO == '1')&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; header(&quot;Location: mantenimiento&quot;);&nbsp; &nbsp; &nbsp; &nbsp; exit;&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; if(isset($_POST['Usuario']) &amp;&amp; isset($_POST['Mail']) &amp;&amp; isset($_POST['Contrasena']) &amp;&amp; isset($_POST['RContrasena']) &amp;&amp; isset($_POST['Contracode']))&nbsp; &nbsp; {&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $Getnombre = mysql_query(&quot;SELECT * FROM users WHERE username = '&quot;. $_POST['Usuario'] .&quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; $Getmail = mysql_query(&quot;SELECT * FROM users WHERE mail = '&quot;. $_POST['Mail'] .&quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(empty($_POST['Usuario']) || empty($_POST['Mail']) || empty($_POST['Contrasena']) || empty($_POST['RContrasena']) || empty($_POST['Contracode']))&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $regerror = 'Do not leave the fields empty';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; elseif(mysql_num_rows($Getnombre) &gt; 0)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $regerror = 'The username is already in use, put another';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; elseif(mysql_num_rows($Getmail) &gt; 0)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $regerror = 'The email is already in use, put another';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; elseif($_POST['Contrasena'] !== $_POST['RContrasena'])&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $regerror = 'Passwords do not match';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; elseif(strlen($_POST['Usuario']) &gt; 12 || strlen($_POST['Usuario']) &lt; 3)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $regerror = 'The username must be between 3 and 12 characters';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; elseif(strrpos($_POST['Usuario'], &quot;MOD-&quot;) !== false)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $regerror = 'You can not register with the prefix &lt;i&gt;MOD-&lt;/i&gt;';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; elseif(strrpos($_POST['Usuario'], &quot; &quot;) || strrpos($_POST['Usuario'], &quot; &quot;) !== false)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $regerror = 'Your name can not contain spaces';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; elseif(strrpos($_POST['Usuario'], &quot;.&quot;) || strrpos($_POST['Usuario'], &quot;.&quot;) !== false)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $regerror = 'Your name can not contain points';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mysql_query(&quot;INSERT INTO users (username, password, passcode, mail, look, gender, motto, ip_register, credits, account_created, account_day_of_birth) VALUES ('&quot;. filtro($_POST['Usuario']) .&quot;', '&quot;.md5($_POST['Contrasena']).&quot;', '&quot;.md5($_POST['Contracode']).&quot;', '&quot;. filtro($_POST['Mail']) .&quot;', '&quot;. $Holo['look'] .&quot;', '&quot;. $Holo['gender'] .&quot;', '&quot;. $Holo['mision'] .&quot;', '&quot;. $ip .&quot;', '&quot;. $Holo['monedas'] .&quot;', '&quot; . time() .&quot;', '&quot; . time() .&quot;')&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $_SESSION['Username'] = $_POST['Usuario'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $_SESSION['Password'] = $_POST['Contrasena'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $_SESSION['Contracode'] = $_POST['Contracode'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; header(&quot;Location: way&quot;);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; $_GET['Usuario'] = $_POST['Usuario'];&nbsp; &nbsp; $_GET['Mail'] = $_POST['Mail'];&nbsp; &nbsp; $_GET['Contrasena'] = $_POST['Contrasena'];&nbsp; &nbsp; $_GET['RContrasena'] = $_POST['RContrasena'];&nbsp; &nbsp; $_GET['Contracode'] = $_POST['Contracode'];&nbsp; &nbsp; ?&gt;[/CODE]so basically upon registration it takes me to the /me page but it doesnt ever add the user into the users table.All help is greatly appreciated thanks xx</blockquote>

[QUOTE="Daltron, post: 452875, member: 61885"] Alrighty so, here is my code [CODE=php]<?php require_once("inc/core.god.php"); if(Loged == TRUE) { header("Location: me"); exit; } if(MANTENIMIENTO == '1') { header("Location: mantenimiento"); exit; } if(isset($_POST['Usuario']) && isset($_POST['Mail']) && isset($_POST['Contrasena']) && isset($_POST['RContrasena']) && isset($_POST['Contracode'])) { $Getnombre = mysql_query("SELECT * FROM users WHERE username = '". $_POST['Usuario'] ."'"); $Getmail = mysql_query("SELECT * FROM users WHERE mail = '". $_POST['Mail'] ."'"); if(empty($_POST['Usuario']) || empty($_POST['Mail']) || empty($_POST['Contrasena']) || empty($_POST['RContrasena']) || empty($_POST['Contracode'])) { $regerror = 'Do not leave the fields empty'; } elseif(mysql_num_rows($Getnombre) > 0) { $regerror = 'The username is already in use, put another'; } elseif(mysql_num_rows($Getmail) > 0) { $regerror = 'The email is already in use, put another'; } elseif($_POST['Contrasena'] !== $_POST['RContrasena']) { $regerror = 'Passwords do not match'; } elseif(strlen($_POST['Usuario']) > 12 || strlen($_POST['Usuario']) < 3) { $regerror = 'The username must be between 3 and 12 characters'; } elseif(strrpos($_POST['Usuario'], "MOD-") !== false) { $regerror = 'You can not register with the prefix MOD-'; } elseif(strrpos($_POST['Usuario'], " ") || strrpos($_POST['Usuario'], " ") !== false) { $regerror = 'Your name can not contain spaces'; } elseif(strrpos($_POST['Usuario'], ".") || strrpos($_POST['Usuario'], ".") !== false) { $regerror = 'Your name can not contain points'; } else { mysql_query("INSERT INTO users (username, password, passcode, mail, look, gender, motto, ip_register, credits, account_created, account_day_of_birth) VALUES ('". filtro($_POST['Usuario']) ."', '".md5($_POST['Contrasena'])."', '".md5($_POST['Contracode'])."', '". filtro($_POST['Mail']) ."', '". $Holo['look'] ."', '". $Holo['gender'] ."', '". $Holo['mision'] ."', '". $ip ."', '". $Holo['monedas'] ."', '" . time() ."', '" . time() ."')"); $_SESSION['Username'] = $_POST['Usuario']; $_SESSION['Password'] = $_POST['Contrasena']; $_SESSION['Contracode'] = $_POST['Contracode']; header("Location: way"); } } $_GET['Usuario'] = $_POST['Usuario']; $_GET['Mail'] = $_POST['Mail']; $_GET['Contrasena'] = $_POST['Contrasena']; $_GET['RContrasena'] = $_POST['RContrasena']; $_GET['Contracode'] = $_POST['Contracode']; ?>[/CODE] so basically upon registration it takes me to the /me page but it doesnt ever add the user into the users table. All help is greatly appreciated thanks xx [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members