ERRO ao Criar Conta no Gesior Acc

Postado Junho 18, 2014 10 anos

como o join disse acima, basta procurar a linha 58 que o erro cita e configurar corretamente a senha.

Te ajudei ? REP+

Citar

Mention

Postado Junho 18, 2014 10 anos

Autor

Galera o ERRO ta no CreateAccount eu troquei oque tava no site por outro e deu de criar conta normal.

CreateAccount - Velho :

<b>

<?php

$location = array(

'GER' =>'Europe',

// 'USA' =>'North America'

);

$default = 'all';

$worlds = array();

$worlds[0] = array('GER', 'open');

/*

$worlds[1] = array('GER', 'optional');

$worlds[2] = array('GER', 'hardcore');

$worlds[3] = array('USA', 'open');

$worlds[4] = array('USA', 'optional');

$worlds[5] = array('USA', 'hardcore');

*/

$voc = array(); // if empty, Rook Sample will be used

$voc[1] = 'Sorcerer';

$voc[2] = 'Druid';

$voc[3] = 'Paladin';

$voc[4] = 'Knight';

$suggestname = NULL; // not available

$version = '860'; // for download link

foreach($worlds as $k =>$v) // remove invalid worlds

if(!isset($location[$v[0]]) || !isset($config['site']['worlds'][$k]))

unset($worlds[$k]);

$tmp = array();

foreach($location as $k =>$v) // remove invalid/unused locations

foreach($worlds as $i =>$j)

if($j[0] == $k) {

$tmp[$k] = $v;

break;

}

$location = $tmp; unset($tmp);

if(isset($_POST['step']) && $_POST['step'] == 'docreate') {

$e = array();

$s = isset($_POST['accountname']) ? $_POST['accountname'] : '';

if($s == '')

$e['acc'] = 'Please enter an account name!';

elseif(strlen($s) < 6)

$e['acc'] = 'This account name is too short!';

elseif(strlen($s) > 30)

$e['acc'] = 'This account name is too long!';

else {

$s = strtoupper($s);

if(!ctype_alnum($s))

$e['acc'] = 'This account name has an invalid format. Your account name may only consist of numbers 0-9 and letters A-Z!';

elseif(!preg_match('/[A-Z]/', $s))

$e['acc'] = 'Your account name must include at least one letter A-Z!';

else {

$con = mysql_pconnect($config['server']['sqlHost'], $config['server']['sqlUser'], $config['server']['sqlPass']) or die('MySQL connection error.');

mysql_select_db($config['server']['sqlDatabase']);

if(mysql_num_rows(mysql_query('SELECT id FROM accounts WHERE name=\''.mysql_escape_string($s).'\' LIMIT 1')) != 0)

$e['acc'] = 'This account name is already used. Please select another one!';

}

}

$s = isset($_POST['name']) ? trim($_POST['name']) : '';

if(empty($s))

$e['name'] = 'Please enter a name for your character!';

elseif(strlen($s) < 2 || strlen($s) > 29)

$e['name'] = 'A name must have at least 2 but no more than 29 letters!';

elseif(preg_match('/[^a-zA-Z ]/', $s))

$e['name'] = 'This name contains invalid letters. Please use only A-Z, a-z and space!';

elseif(!ctype_upper($s[0]))

$e['name'] = 'The first letter of a name has to be a capital letter!';

elseif(strpos($s, ' ') !== false)

$e['name'] = 'This name contains more than one space between words. Please use only one space between words!';

else {

foreach(explode(' ', $s) as $k =>$v) {

$words[$k] = str_split($v);

$len = strlen($v);

if($len == 1) {

$e['name'] = 'This name contains a word with only one letter. Please use more than one letter for each word!';

break;

}

elseif($len > 14) {

$e['name'] = 'This name contains a word that is too long. Please use no more than 14 letters for each word!';

break;

}

}

if(!isset($e['name'])) {

$total=0;

foreach($words as $k =>$p) {

if(isset($e['name']))

break;

$total++;

if($total > 3) {

$e['name'] = 'This name contains more than 3 words. Please choose another name!';

break;

}

$len=0;

foreach($p as $i =>$j) {

$len++;

if($i != 0 && ctype_upper($j)) {

$e['name'] = 'In names capital letters are only allowed at the beginning of a word!';

break;

}

elseif($i == $len-1) {

$ff=null;

for($h=0;$h<strlen($v); $h++) {

if(in_array(strtolower($v[$h]), array('a','e','i','o','u')) !== false) {

$ff=true;

break;

}

}

if(!$ff) {

$e['name'] = 'This name contains a word without vowels. Please choose another name!';

break;

}

}

}

}

if(!isset($e['name'])) {

$s = strtolower($s);

for($i = 0; $i < strlen($s); $i++)

if($s[$i] == $s[($i+1)] && $s[$i] == $s[($i+2)]) {

$e['name'] = 'This character name is already used. Please select another one!';

break;

}

if(!isset($e['name'])) {

foreach(array('aa ', 'ee', 'ii', 'oo', 'uu', 'gm','cm', 'aff ', 'god ', 'abc', 'tutor', 'game', 'admin', 'the ') as $v)

if($v == substr($s, 0, strlen($v))) {

$e['name'] = 'This character name is already used. Please select another one!';

break;

}

if(!isset($e['name'])) {

foreach(array('game', 'customer', 'support', 'fuck', 'haha', 'sux', ' abc', 'suck', 'noob', 'tutor', 'admin', 'account', 'gay', 'password', 'manager') as $v)

if(strpos($s, $v) !== false) {

$e['name'] = 'This character name is already used. Please select another one!';

break;

}

if(!isset($e['name'])) {

if(!isset($con)) {

$con = mysql_pconnect($config['server']['sqlHost'], $config['server']['sqlUser'], $config['server']['sqlPass']) or die('MySQL connection error.');

mysql_select_db($config['server']['sqlDatabase']);

}

if(mysql_num_rows(mysql_query('SELECT id FROM players WHERE name=\''.mysql_escape_string($s).'\' LIMIT 1')) != 0)

$e['name'] = 'This character name is already used. Please select another one!';

}

}

}

}

}

}

if(!isset($_POST['world']) || empty($_POST['world']))

$e['world'] = 'Please select a game world for your character!';

if(!isset($_POST['sex']) || ($_POST['sex'] != 'male' && $_POST['sex'] != 'female'))

$e['sex'] = 'Please select the sex for your character!';

if(count($voc) != 0 && (!isset($_POST['vocation']) || !is_numeric($_POST['vocation']) || !isset($voc[$_POST['vocation']])))

$e['vocation'] = 'Please select the vocation for your character!';

$s = isset($_POST['email']) ? $_POST['email'] : '';

if($s == '')

$e['email'] = 'Please enter your email address!';

elseif(strlen($s) > 49)

$e['email'] = 'Your email address is too long!';

elseif(!filter_var($s, FILTER_VALIDATE_EMAIL))

$e['email'] = 'This email address has an invalid format. Please enter a correct email address!';

else {

if(!isset($con)) {

$con = mysql_pconnect($config['server']['sqlHost'], $config['server']['sqlUser'], $config['server']['sqlPass']) or die('MySQL connection error.');

mysql_select_db($config['server']['sqlDatabase']);

}

if(mysql_num_rows(mysql_query('SELECT id FROM accounts WHERE email=\''.mysql_escape_string($s).'\' LIMIT 1')) != 0)

$e['email'] = 'This email address is already used. Please enter another email address!';

}

$s1 = isset($_POST['password1']) ? $_POST['password1'] : '';

$s2 = isset($_POST['password2']) ? $_POST['password2'] : '';

if(empty($s2))

$e['pass'] = 'Please enter the password again!';

elseif($s1 != $s2)

$e['pass'] = 'The two passwords do not match!';

else {

$err = array();

if(strlen($s1) < 8 || strlen($s1) > 29)

$err[] = 'The password must have at least 8 and less than 30 letters!';

if(!ctype_alnum($s1))

$err[] = 'The password contains invalid letters!';

if(!preg_match('/[a-zA-Z]/', $s1))

$err[] = 'The password must contain at least one letter A-Z or a-z!';

elseif(!preg_match('/[0-9]/', $s1))

$err[] = 'The password must contain at least one letter other than A-Z or a-z!';

if(count($err) != 0) {

$e['pass'] = '';

for($i=0; $i < count($err); $i++)

$e['pass'] .= ($i == 0 ? '' : '<br/>').$err[$i];

}

}

if(!isset($_POST['agreeagreement']) || empty($_POST['agreeagreement']))

$e['agreement'] = 'You have to agree to the Tibia Service Agreement in order to create an account!';

if(!isset($_POST['agreerules']) || empty($_POST['agreerules']))

$e['rules'] = 'You have to agree to the Tibia Rules in order to create an account!';

if(!isset($_POST['agreeprivacy']) || empty($_POST['agreeprivacy']))

$e['privacy'] = 'You have to agree to the Tibia Privacy Policy in order to create an account!';

if(count($e) == 0) {

$worldid = NULL;

foreach($config['site']['worlds'] as $id =>$name)

if($worlds[$id] && $name == $_POST['world']) {

$worldid = $id;

break;

}

if($worldid === FALSE)

$e['world'] = 'Please select a valid game world.';

}

if(count($e) != 0) {

$main_content = '<div class="SmallBox"><div class="MessageContainer"><div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif)"/></div><div class="BoxFrameEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif)"/></div><div class="BoxFrameEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif)"/></div><div class="ErrorMessage"><div class="BoxFrameVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif)"/></div><div class="BoxFrameVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif)"/></div><div class="AttentionSign" style="background-image:url('.$layout_name.'/images/content/attentionsign.gif)"/></div><b>The Following Errors Have Occurred:</b><br/>';

foreach($e as $error) $main_content .= $error.'<br/>';

$main_content .= '</div><div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif)"/></div><div class="BoxFrameEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif)"/></div><div class="BoxFrameEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif)"/></div></div></div><br/>';

}

else {

$random = rand(1, 9999999);

$n = $random;

$cur = array();

$q = mysql_query('SELECT id FROM accounts');

while ($r = mysql_fetch_array($q, MYSQL_NUM))

$cur[] = $r[0];

while(true)

{

if(!in_array($n, $cur))

break;

$n++;

if($n > 9999999)

$n = 1;

if($n == $random)

die('Failed to create account.');

}

if(mysql_query("INSERT INTO accounts (id,name,password,email,created) VALUES($n,'".$_POST['accountname']."','".($config['server']['encryptionType'] == 'plain' ? $_POST['password1'] : hash($config['server']['encryptionType'], $_POST['password1']))."','".$_POST['email']."',".time().")") === true) {

$sample = (count($voc) == 0 ? 'Rook' : $voc[$_POST['vocation']]).' Sample';

$q = mysql_query("SELECT id,vocation,town_id,experience,level,maglevel,health,healthmax,mana,manamax,soul,lookbody,lookfeet,lookhead,looklegs,lookaddons,cap,save,posx,posy,posz FROM players WHERE name='$sample' LIMIT 1");

if(mysql_num_rows($q) != 1)

die('Missing sample character ('.$sample.')');

$q = mysql_fetch_array($q);

mysql_query('INSERT INTO players (name,world_id,account_id,level,vocation,health,healthmax,experience,lookbody,lookfeet,lookhead,looklegs,looktype,lookaddons,maglevel,mana,manamax,soul,town_id,posx,posy,posz,cap,sex,created) VALUES(\''.$_POST['name'].'\','.$worldid.','.$n.','.$q['level'].','.$q['vocation'].','.$q['health'].','.$q['healthmax'].','.$q['experience'].','.$q['lookbody'].','.$q['lookfeet'].','.$q['lookhead'].','.$q['looklegs'].','.($_POST['sex'] == 'female' ? 136 : 128).','.$q['lookaddons'].','.$q['maglevel'].','.$q['mana'].','.$q['manamax'].','.$q['soul'].','.$q['town_id'].','.$q['posx'].','.$q['posy'].','.$q['posz'].','.$q['cap'].','.($_POST['sex'] == 'female' ? 0 : 1).','.time().')');

}

else die('Failed to create account.');

$main_content = '<div class="SmallBox"><div class="MessageContainer"><div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif)"/></div><div class="BoxFrameEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif)"/></div><div class="BoxFrameEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif)"/></div><div class="Message"><div class="BoxFrameVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif)"/></div><div class="BoxFrameVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif)"/></div><table><tr><td class="LabelV">Note:</td><td style="width:100%"><p>Your account and character have been created successfully.</p></td></tr></table></div><div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif)"/></div><div class="BoxFrameEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif)"/></div><div class="BoxFrameEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif)"/></div></div></div><div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif)"></div><div class="BoxFrameEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif)"></div><div class="BoxFrameEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif)"></div><br/><div class="TableContainer"><table class="Table4" cellpadding="0" cellspacing="0"><div class="CaptionContainer"><div class="CaptionInnerContainer"><span class="CaptionEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif)"/></span><span class="CaptionEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif)"/></span><span class="CaptionBorderTop" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif)"></span><span class="CaptionVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif)"/></span><div class="Text">Download Client</div><span class="CaptionVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif)"/></span><span class="CaptionBorderBottom" style="background-image:url('.$layout_name.'/images/content/table-headline-border.gif)"></span><span class="CaptionEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif)"/></span><span class="CaptionEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif)"/></span></div></div><tr><td><div class="InnerTableContainer"><table style="width:100%"><tr><td><table width="100%" cellpadding=0 cellspacing=0><tr><td style="vertical-align:top"><div class="TableShadowContainerRightTop"><div class="TableShadowRightTop" style="background-image:url('.$layout_name.'/images/content/table-shadow-rt.gif)"></div></div><div class="TableContentAndRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-rm.gif)"><div class="TableContentContainer"><table class="TableContent" width="100%"><tr><td><table style="width:100%;text-align:center"><tr><td><a href="

<p>Account name: <b>'.$reg_name.'</b></p>

<p>Password: <b>'.trim($reg_password).'</b></p>

<br />

<p>After login you can:</p>

<li>Create new characters

<li>Change your current password

<li>Change your current e-mail

</body>

</html>';

require("phpmailer/class.phpmailer.php");

$mail = new PHPMailer();

if ($config['site']['smtp_enabled'] == "yes")

{

$mail->IsSMTP();

$mail->Host = $config['site']['smtp_host'];

$mail->Port = (int)$config['site']['smtp_port'];

$mail->SMTPAuth = ($config['site']['smtp_auth'] ? true : false);

$mail->Username = $config['site']['smtp_user'];

$mail->Password = $config['site']['smtp_pass'];

}

else

$mail->IsMail();

$mail->IsHTML(true);

$mail->From = $config['site']['mail_address'];

$mail->AddAddress($reg_email);

$mail->Subject = $config['server']['serverName']." - Registration";

$mail->Body = $mailBody;

if($mail->Send())

{

$main_content .= 'Conta Criada ! Vejo Voce no Tibia !<BR><BR>';

$main_content .= '<TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4>

<TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Conta Criada !</B></TD></TR>

<TR><TD BGCOLOR="'.$config['site']['darkborder'].'">

<TABLE BORDER=0 CELLPADDING=1><TR><TD>

<BR>Your account name is <b>'.$reg_name.'</b>.

<BR><b><i>You will receive e-mail (<b>'.$reg_email.'</b>) with your password.</b></i><br>';

$main_content .= '<a href="http://www.dynamic-world.com.br/?subtopic=accountmanagement''>http://www.dynamic-world.com.br/?subtopic=accountmanagement'>http://www.dynamic-world.com.br/?subtopic=accountmanagement" width="120"><b><font size=3">Logue Aqui</font></b></a>.<BR><BR>';

$main_content .= '<br /><small>These informations were send on email address <b>'.$reg_email.'</b>. Please check your inbox/spam folder.';

}

else

{

$main_content .= '<br /><small>An error occorred while sending email! Account not created. Try again.</small>';

$reg_account->delete();

}

}

else

{

$main_content .= 'Your account has been created. Now you can login and create your first character. See you in Tibia!<BR><BR>';

$main_content .= '<TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4>

<TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Account Created</B></TD></TR>

<TR><TD BGCOLOR="'.$config['site']['darkborder'].'">

<TABLE BORDER=0 CELLPADDING=1><TR><TD>

<BR>Your account name is <b>'.$reg_name.'</b><br>You will need the account name and your password to play on '.$config['server']['serverName'].'.

Please keep your account name and password in a safe place and

never give your account name or password to anybody.<BR><BR>';

if($config['site']['send_emails'] && $config['site']['send_register_email'])

{

$mailBody = '<html>

<body>

<h3>Your account name and password!</h3>

<p>You or someone else registred on server <a href="'.$config['server']['url'].'"><b>'.$config['server']['serverName'].'</b></a> with this e-mail.</p>

<p>Account name: <b>'.$reg_name.'</b></p>

<p>Password: <b>'.trim($reg_password).'</b></p>

<br />

<p>After login you can:</p>

<li>Create new characters

<li>Change your current password

<li>Change your current e-mail

</body>

</html>';

require("phpmailer/class.phpmailer.php");

$mail = new PHPMailer();

if ($config['site']['smtp_enabled'] == "yes")

{

$mail->IsSMTP();

$mail->Host = $config['site']['smtp_host'];

$mail->Port = (int)$config['site']['smtp_port'];

$mail->SMTPAuth = ($config['site']['smtp_auth'] ? true : false);

$mail->Username = $config['site']['smtp_user'];

$mail->Password = $config['site']['smtp_pass'];

}

else

$mail->IsMail();

$mail->IsHTML(true);

$mail->From = $config['site']['mail_address'];

$mail->AddAddress($reg_email);

$mail->Subject = $config['server']['serverName']." - Registration";

$mail->Body = $mailBody;

if($mail->Send())

$main_content .= '<br /><small>These informations were send on email address <b>'.$reg_email.'</b>.';

else

$main_content .= '<br /><small>An error occorred while sending email (<b>'.$reg_email.'</b>)!</small>';

}

}

$main_content .= '</TD></TR></TABLE></TD></TR></TABLE><BR><BR>';

}

else

{

//SHOW ERRORs if data from form is wrong

$main_content .= '<div class="SmallBox" > <div class="MessageContainer" > <div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif);" /></div> <div class="BoxFrameEdgeLeftTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> <div class="BoxFrameEdgeRightTop" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> <div class="ErrorMessage" > <div class="BoxFrameVerticalLeft" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></div> <div class="BoxFrameVerticalRight" style="background-image:url('.$layout_name.'/images/content/box-frame-vertical.gif);" /></div> <div class="AttentionSign" style="background-image:url('.$layout_name.'/images/content/attentionsign.gif);" /></div><b>The Following Errors Have Occurred:</b><br/>';

foreach($reg_form_errors as $show_msg)

{

$main_content .= '<li>'.$show_msg;

}

$main_content .= '</div> <div class="BoxFrameHorizontal" style="background-image:url('.$layout_name.'/images/content/box-frame-horizontal.gif);" /></div> <div class="BoxFrameEdgeRightBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> <div class="BoxFrameEdgeLeftBottom" style="background-image:url('.$layout_name.'/images/content/box-frame-edge.gif);" /></div> </div></div><br/>

<BR>

<CENTER>

<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0><FORM ACTION=?subtopic=createaccount METHOD=post><TR><TD>

<INPUT TYPE=hidden NAME=email VALUE="">

<INPUT TYPE=image NAME="Back" ALT="Back" SRC="'.$layout_name.'/images/buttons/sbutton_back.gif" BORDER=0 WIDTH=120 HEIGHT=18>

</TD></TR></FORM></TABLE>

</CENTER>';

}

}

?>