[Problema con script]Registro

-YC- · May 12, 2014

Hola amigos de zone tengo un problema he montado una web pero el registro no me anda me da el error de que la cuenta ya existe y no es asi ya que he checado en la db y no hay ninguna con ese ID les dejo el script aver si pueden ayudarme:

<h2>

Registro

</h2>

</div>

<?PHP

function get_client_ip() {

$ipaddress = '';

if ($_SERVER['HTTP_CLIENT_IP'])

$ipaddress = $_SERVER['HTTP_CLIENT_IP'];

else if($_SERVER['HTTP_X_FORWARDED_FOR'])

$ipaddress = $_SERVER['HTTP_X_FORWARDED_FOR'];

else if($_SERVER['HTTP_X_FORWARDED'])

$ipaddress = $_SERVER['HTTP_X_FORWARDED'];

else if($_SERVER['HTTP_FORWARDED_FOR'])

$ipaddress = $_SERVER['HTTP_FORWARDED_FOR'];

else if($_SERVER['HTTP_FORWARDED'])

$ipaddress = $_SERVER['HTTP_FORWARDED'];

else if($_SERVER['REMOTE_ADDR'])

$ipaddress = $_SERVER['REMOTE_ADDR'];

else

$ipaddress = 'UNKNOWN';

return $ipaddress;

}

$regCoins = 0; // Startcoins

$laufZeit = 365; //Tage autoloot,safebox

$calcLZ = (60*60*24)*365;

$expireStamp = time()+$calcLZ;

$expireDate = date("Y-m-d H:i:s",$expireStamp);

if($serverSettings['register_on'] && (!isset($_SESSION['user_admin']) && !checkInt($_SESSION['user_admin']) && !$_SESSION['user_admin']>=0)) {

if(isset($_POST['submit']) && $_POST['submit']=="REGISTAR") {

if((checkAnum($_POST['account']) && strlen($_POST['account'])>=8 && strlen($_POST['account'])<=16) && checkAnum($_POST['pass']) && strlen($_POST['pass'])>=8 && strlen($_POST['pass2'])<=16 && !empty($_POST['pass2']) && (checkName($_POST['uname']) && strlen($_POST['uname'])>=3 && strlen($_POST['uname'])<=20) && $_POST['pass']==$_POST['pass2'] && checkMail($_POST['email']) && strlen($_POST['email'])<=40 && $_POST['captcha']==$_SESSION['captcha_id'] && $_POST['email']==$_POST['email2'] && (checkAnum($_POST['sicherheitsa']) && strlen($_POST['sicherheitsa'])>=3 && strlen($_POST['sicherheitsa'])<=16) && checkInt($_POST['sicherheitsf']) && (checkAnum($_POST['loeschcode']) && strlen($_POST['loeschcode'])==7)) {

$hashSF = md5($_POST['sicherheitsa']);

$sfNum = mysql_real_escape_string($_POST['sicherheitsf']);

$lcode = mysql_real_escape_string($_POST['loeschcode']);

$zuFall = rand(99999,999999999);

$userpass=mysql_real_escape_string($_POST['pass']);

$aktivHash = ($serverSettings['mail_activation']) ? md5($zuFall):'';

$accountStatus = ($serverSettings['mail_activation']) ? 'BLOCK':'OK';

$tuserip = get_client_ip();

$sqlCmd = "INSERT INTO account.account

(login,password,real_name,email,social_id,question1,answer1,create_time,status,coins,autoloot_expire,safebox_expire,web_aktiviert,web_ip,last_play)

VALUES

('".$_POST['account']."',PASSWORD('".$userpass."'),'".mysql_real_escape_string($_POST['uname'])."','".mysql_real_escape_string($_POST['email'])."','".$lcode."','".$sfNum."','".$hashSF."','".$sqlZeit."','".$accountStatus."','".$regCoins."','".$expireDate."','".$expireDate."','".$aktivHash."','".$tuserip."',NOW())";

$sqlQry = mysql_query($sqlCmd,$sqlServ);

if($sqlQry) {

$absender = $serverSettings['titel']." Registration";

$email = $serverSettings['reg_mail'];

$empfaenger = $_POST['email'];

$mail_body = "Hallo ".$_POST['uname'].",

deine Registration auf ".$serverSettings['titel']." war erfolgreich! Um auch auf dem Server spielen zu können, musst du deinen Account aktivieren.

Das kannst du über den folgenden Link tun:

".$serverSettings['url']."/index.php?s=login&do=aktivieren&hash=".$aktivHash."

Deine Daten sind:

Account: ".$_POST['account']."

Passwort: ".$userpass."

Löschcode: ".$lcode."

Sicherheitsfrage: ".$sFrage[$sfNum]."

Antwort: ".$_POST['sicherheitsa']."

Viel Spaß beim Spielen,

Dein ".$serverSettings['titel']."-Team

Diese E-Mail wurde automatisch generiert. Bitte keine Antworten an diese Adresse schicken.";

$titel = "Registrierung auf ".$serverSettings['titel'];

$header = "X-Priority: 3n";

$header .= "X-Mailer: ".$serverSettings['titel']." Homepage Mailern";

$header .= "MIME-Version: 1.0n";

$header .= "From: ".$absender." <".$serverSettings['reg_mail'].">n";

$header .= "Reply-To: ".$serverSettings['reg_mail']."n";

$header .= "Content-Type: text/plain; charset=iso-8859-1n";

if($serverSettings['mail_activation']) {

mail($empfaenger, $titel, $mail_body, $header);

echo'<p class="meldung">Tu cuenta ha sido creada con exito!!</p>';

}

else {

echo'<p class="meldung">Cuenta Creada!!</p>';

}

else {

echo'<p class="meldung">No se ha podido registrarse la cuenta ya existe.</p>';

}

else {

echo'<p class="meldung">No es posible que te egistres, rellena bien los campos</p>';

}

?>

<p>Todos los campos los obligatorios y deben ser rellenados correctamente.<?PHP if($serverSettings['mail_activation']) { echo'<br/><b>Der Account wird per E-Mail aktiviert, also eine richtige E-Mail eingeben!</b>'; } ?></p>

<table>

<tr>

<th class="topLine">Cuenta:</th>

<td class="tdunkel"><input class="txt" type="text" name="account" maxlength="16" size="16"/> <br> 8-16 Caráct. (de a-Z,0-9)</td>

</tr>

<tr>

<th class="topLine">Nombre:</th>

<td class="thell"><input class="txt" type="text" name="uname" maxlength="16" size="16"/> <br> 3-20 Caráct. (de a-Z,0-9)</td>

</tr>

<tr>

<th class="topLine">Password:</th>

<td class="tdunkel"><input class="txt" type="password" name="pass" maxlength="16" size="16"/> <br> 8-16 Caráct. (de a-Z,0-9)</td>

</tr>

<tr>

<th class="topLine">Repita tu Password:</th>

</tr>

<tr>

<td class="tdunkel"><input class="txt" type="text" name="email" maxlength="50" size="25"/><br> max. 40 Caráct.</td>

</tr>

<tr>

<th class="topLine">Repita tu E-Mail:</th>

</tr>

<tr>

<th class="topLine">Codigo de Borrado:</th>

<td class="tdunkel"><input class="txt" type="text" name="loeschcode" maxlength="7" size="7"/> <br> 7 Caráct. (de a-Z,0-9)</td>

</tr>

<tr>

<th class="topLine">Pregunta de seguridad:</th>

<?PHP

foreach($sFrage AS $fragew => $frage) {

echo'<option value="'.$fragew.'">'.$frage.'</option>';

}

?>

</select>

<input class="txt" type="text" name="sicherheitsa" maxlength="16" size="16"/> <br> 3-16 Carácteres (de a-Z,0-9)

</td>

</tr>

<tr>

<th class="topLine">Captcha:</th>

</tr>

<tr>

</tr>

</table>

</form>

<?PHP

}

else {

echo'<p class="meldung">El registro fue desactivado, por problemas tecnicos.</p>';

}

?>

</div>

</div></div>

Яǿ×αS©™MagعSti¢ · May 12, 2014

ESTE NO!, MIRA DEBAJO XD

Яǿ×αS©™MagعSti¢ · May 12, 2014

Mira men yo tengo esto...

<?php if($securite!='JEREMaimelaquequete!numero:0687541251'){exit();}?> <form id="login" method="POST" action="?p=5"><div class="entry-title"><h2>Inscription au serveur</h2><span class="date">Général</span></div><div class="entry-con" align="justify"><div align="center">Merci de remplir ces champs:<br /><br /></div><table style="padding-left: 50px;"> <tr><td>Nom de compte: </td><td><input type="text" class="bar" name="compte" id="compte" /></td></tr><script type="text/javascript"> var compte = new LiveValidation('compte');compte.add(Validate.Presence);compte.add( Validate.Length, { minimum: 6 } );</script> <tr><td height="10" colspan="2"></td></tr><tr><td>Mot de passe: </td><td><input type="password" class="bar" name="password1" id="psw1" /></td></tr> <script type="text/javascript"> var psw1 = new LiveValidation('psw1');psw1.add(Validate.Presence);</script> <tr><td height="10" colspan="2"></td></tr><tr><td>Mot de passe (vérification): </td><td><input type="password" class="bar" name="password2" id="psw2" /></td></tr><script type="text/javascript"> var psw2 = new LiveValidation('psw2');psw2.add(Validate.Presence);psw2.add(Validate.Confirmation, { match: 'psw1'} );</script> <tr><td height="10" colspan="2"></td></tr><tr><td>Code effacement personnage: </td><td><input type="password" class="bar" name="suppr" id="eff"/></td></tr><script type="text/javascript"> var eff = new LiveValidation('eff');eff.add(Validate.Presence); eff.add(Validate.Length, { minimum: 5, maximum: 7 } );</script> <tr><td height="10" colspan="2"></td></tr><tr><td>Adresse e-mail: </td><td><input type="text" class="bar" name="mail" id="mail" /></td></tr><script type="text/javascript"> var mail = new LiveValidation('mail');mail.add(Validate.Presence); mail.add( Validate.Email );</script> </table></div><div class="entry-end"></div><br /> <div class="entry-title"><h2><font color="orange">IMPORTANT</font> (utile pour changer/renvoyer MDP)</h2><span class="date">Secret</span></div> <div class="entry-con" align="justify"> <table style="padding-left: 50px;"><tr><td>Question secrète:</td> <td><select name="question"><option value="1">Quel est votre lieu de naissance?</option><option value="2">Quel est le nom de votre animal de compagnie?</option><option value="3">Quel est le nom de jeune fille de votre mè?</option><option value="4">Quel est le prénom de votre père?</option><option value="5">Quelle est votre couleur préférée?</option></select> </td></tr> <tr><td height="15" colspan="2"></td></tr><tr><td>Réponse secrète:</td><td><input type="password" class="bar" name="reponse" id="rep" /></td><td colspan="50">     </td><td><font color="orange"><b>A Retenir</b></font></td></tr> <script type="text/javascript"> var rep = new LiveValidation('rep');rep.add(Validate.Presence);rep.add(Validate.Length, { minimum: 3 } );</script> <tr><td height="15" colspan="2"></td></tr></table> </div><div class="entry-end"></div><br /> <div class="entry-title"><h2>Validation de l'inscription</h2><span class="date">Vérification</span></div> <div class="entry-con" align="justify"> <table style="padding-left: 50px;"><tr><td colspan="2">De quel couleur est le cheval blanc d'Henri IV ?</td><td width="280px"><marquee> !! The answer is "white (blanc)" you must write in French !! Răspunsul este "alb (blanc)", trebuie să scrieţi în limba franceză !! </marquee></td></tr> <tr><td height="15" colspan="2"></td></tr><tr><td>Réponse: </td><td><input type="password" class="bar" name="captcha" id="cap" /></td></tr><script type="text/javascript"> var cap = new LiveValidation('cap');cap.add(Validate.Presence);cap.add(Validate.Inclusion, { within: [ 'blanc' , 'Blanc', 'BLANC' ] } );</script> <tr><td height="30" colspan="2"></td></tr></table><center><hr width="80%"></center><br /><br /><table style="padding-left: 50px;"> <tr><td>Comment Avez-vous connu M2Mage ?</td> <td><select name="stat"> <option value="1">Publicité</option><option value="2">Forum d'émulation</option><option value="3">Par un(e) ami(e)</option><option value="4">Top-Serveurs</option><option value="5">Autre...</option></select> </td></tr></table></table> <br /><center> Merci de patientez après validation de votre inscription, nous traitons sa conformité </center><br /> <div align="center"><input type="submit" class="btn" value="Envoyé" /></div></div><div class="entry-end"></div><br /></form>

y

<div class="entry-title"> <h2>Inscription au serveur</h2> <span class="date">Validation</span> </div> <div class="entry-con"><?php if(isset($_GET['login']) and !empty($_GET['login'])) {  $pseudo = mysql_real_escape_string($_GET['login']); if(isset($_POST['code']) and !empty($_POST['code'])) { mysql_select_db("$db_account"); $retour = mysql_query("SELECT active FROM account WHERE login = '$pseudo'") or die("erreur de connexion".mysql_error()); $donnees = mysql_fetch_array($retour); $code_bd = $donnees['active']; $code = mysql_real_escape_string($_POST['code']); if($code_bd == $code) { mysql_select_db("$db_account"); $sql="UPDATE account SET status = 'OK', active = '' WHERE login = '$pseudo'"; mysql_query($sql) or die (mysql_error()); ?> <p class="success" align="center"><b>Votre compte a été activé avec succès !</b></p><br /><br />                 <center><img src="img/ui/insc-loading.gif" /></center> <meta http-equiv="refresh" content="3; url=index.php?p=connexion" /> <?php } else { ?> <p class="error" align="center"> Le code que vous avez saisi n'est pas correct !</p><br /><br />   <center><img src="img/ui/insc-loading.gif" /> </center>    <meta http-equiv="refresh" content="3; url="" />    <?php } } else { ?>             <p class="notice" align="center">Veuillez entrer le code d'activation du compte <strong><?php echo $pseudo; ?></strong></p> <form action="" method="post" id="login_form">        <p align="center">        <input type="text" name="code" value="Code" id="bar" onfocus="if(this.value=='Code') this.value='';" onblur="if(this.value=='') this.value='Code';"/><br /><br /> <input class="btn" type="submit" value="Activer"/>        </p>        </form>         <?php }  } else{header("Location:index.php"); } ?>   <?php    if(isset($_GET['send']) and !empty($_GET['send']) and isset($_GET['compte']) and !empty($_GET['compte']) and $_GET['send'] == 1) { $compte = $_GET['compte']; mysql_select_db("$db_account"); $retour = mysql_query("SELECT active, email FROM account WHERE login = '$compte'") or die("erreur de connexion".mysql_error()); $donnees = mysql_fetch_array($retour); $code = $donnees['active']; $mail = $donnees['email']; $Sujet = "Bienvenue sur Metin2Mage : International"; $From  = "From:[email protected]… "; // Remplacer par votre email ou celui du serveur. $From .= "MIME-version: 1.0n"; $From .= "Content-type: text/html; charset= iso-8859-1n"; $Message =  " Bonjour " . $compte . ", merci de vous être enregistré sur Metin2Mage : International.<br/><br/> Avant de pouvoir commencer à jouer vous devez confirmer votre enregistrement en entrant le code suivant :<br/><br/> <span style='color:#cc0000;'>" . $code . "</span><br/><br/> à cette adresse :  <a href='http://www.metin2mage.com/international/index.php?p=active&login=" . $compte . "'>Activer mon compte Metin2Mage : International</a> <br/><br/> M2Mage. "; mail($mail,$Sujet,$Message,$From); ?>                                        <p class="notice" align="center">Un email contenant votre code d'enregistrement vient de vous être envoyé.<br /><br />                    Il se pourrait qu'il soit dans les courriers indésirables ...</p>  <meta http-equiv="refresh" content="5; url=index.php?p=active&login=<?php echo $compte; ?>" /> <?php }  ?>  </div> <div class="entry-end"></div>

Яǿ×αS©™MagعSti¢ · May 12, 2014

Si necesitas algo mas avisa

Miguelito · May 12, 2014

Reviza Mensajes

Sign In

[Problema con script]Registro

Recommended Posts

-YC-

Яǿ×αS©™MagعSti¢

Яǿ×αS©™MagعSti¢

Яǿ×αS©™MagعSti¢

Miguelito

Recently Browsing 0 members

Browse

Activity

Important Information