ERRO ao Criar Conta no Gesior Acc

tiroleivi · Junho 18, 2014

Erro ao Criar conta no Gesior acc \/

ERRO :
Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'Global-Rush'@'localhost' (using password: NO) in C:\xampp\htdocs\createaccount.php on line 58
MySQL connection error.

CREATE ACCOUNT.PHP

<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="http://tibiaclient.com/files/tibia'.$version.'.exe" type="application/octet-stream" target="_top"><img style="width:180px;height:180px;border:0px" src="account/download_windows.png"/></a></td><td><a href="http://tibiaclient.com/files/tibia'.$version.'.tar" type="application/octet-stream" target="_top"><img style="width:180px;height:180px;border:0px" src="account/download_linux.png"/><br/></a></td></tr><tr><td valign="top"><a href="http://tibiaclient.com/files/tibia'.$version.'.exe" type="application/octet-stream" target="_top">Windows Tibia Client '.(sprintf('%01.2f', $version / 100)).'</a></td><td valign="top"><a href="http://tibiaclient.com/files/tibia'.$version.'.tar" type="application/octet-stream" target="_top">Linux Tibia Client '.(sprintf('%01.2f', $version / 100)).'</a></td></tr><tr><td colspan="2">[<span class="HelpLink" onClick="window.open(\'http://www.tibia.com/support/content/help.php?subtopic=requirementes\' \'Help\', \'width=380px, height=310px, scrollbars=yes\')"><a>system requirements</a></span>]</td></tr></table></td></tr></table></div></div><div class="TableShadowContainer"><div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif)"><div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif)"></div><div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif)"></div></div></div></td><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 style="text-align:center"><img style="width:254px;height:218px;margin:7px" src="account/successful_download.jpg"/></td></tr></table></div></div><div class="TableShadowContainer"><div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif)"><div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif)"></div><div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif)"></div></div></div></td></tr></table><tr><td><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 class="LabelV">Disclaimer</td></tr><tr><td>The software and any related documentation is provided "as is" without warranty of any kind. The entire risk arising out of use of the software remains with you. In no event shall CipSoft GmbH be liable for any damages to your computer or loss of data.</td></tr></table></div></div><div class="TableShadowContainer"><div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif)"><div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif)"></div><div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif)"></div></div></div></td></tr></table></div></table></div></td></tr>';

return;

}

} else $_POST['step'] = '';

$main_content .= '<script type="text/javascript" src="account/jquery.js"></script>

<script type="text/javascript" src="account/create_character.js"></script>

<script type="text/javascript">var PreselectServerLocation="'.$default.'";var g_FormName="CreateAccountAndCharacter";var g_FieldName="accountname";document.getElementById("ActiveSubmenuItemIcon_createaccount").style.visibility = "visible";';

foreach($worlds as $k =>$v) // create dynamic server list

$main_content .= 'ServerList.push(new Array(\''.$config['site']['worlds'][$k].'\', \''.$v[0].'\', \''.$v[1].'\'));';

$main_content .= '</script><div style="position:relative;top:0px;left:0px"><form action="/index.php?subtopic=createaccount" method=post name="CreateAccountAndCharacter"><div class="TableContainer"><table class="Table5" 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">Create New Account</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><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 class="LabelV150"><span id="accountname_label"'.(isset($e['acc']) ? ' class=red"' : '').'>Account Name:</span></td><td><input id="accountname" name="accountname" class="CipAjaxInput" style="width:206px;float:left" value="'.(isset($_POST['accountname]) ? htmlspecialchars(substr($_POST['accountname'], 0, 30)) : '').'" size=30" maxlength="30" onBlur="SendAjaxCip({DataType: \'Container\'}, {Href: \'account/ajax_accountname.php\',PostData: \'a_AccountName=\'+this.value,Method: \'POST\'})"/><div id="accountname_indicator" class="InputIndicator" style="background-image:url(account/'.($_POST['step] != 'docreate' || isset($e['acc']) ? 'n' : '').'ok.gif)"></div></td></tr><tr><td></td><td><span id=accountname_errormessage" class="FormFieldError">'.(isset($e['acc]) ? $e['acc'] : '').'</span></td></tr><tr><td class=LabelV150"><span id="email_label"'.(isset($e['email]) ? ' class="red"' : '').'>Email Address:</span></td><td><input id="email" name="email" class="CipAjaxInput" style="width:206px;float:left" value="'.(isset($_POST['email']) ? htmlspecialchars(substr($_POST['email'], 0, 50)) : '').'" autocomplete=off" size="30" maxlength="50" onBlur="SendAjaxCip({DataType: \'Container\'}, {Href: \'account/ajax_email.php\',PostData: \'a_EMail=\'+this.value,Method: \'POST\'})"/><div id="email_indicator" class="InputIndicator" style="background-image:url(account/'.($_POST['step] != 'docreate' || isset($e['email']) ? 'n' : '').'ok.gif)"></div></td></tr><tr><td></td><td><span id=email_errormessage" class="FormFieldError">'.(isset($e['email]) ? $e['email'] : '').'</span></td></tr><tr><td class=LabelV150"><span id="password1_label"'.(isset($e['pass]) ? ' class="red"' : '').'>Password:</span></td><td><input id="password1" type="password" autocomplete="off" name="password1" style="width:206px;float:left" value="'.(isset($_POST['password1']) ? htmlspecialchars(substr($_POST['password1'], 0, 30)) : '').'" size=30" maxlength="30" onBlur="SendAjaxCip({DataType: \'Container\'}, {Href: \'account/ajax_password.php\',PostData: \'a_Password1=\'+getElementById(\'password1\').value+\'&a_Password2=\'+getElementById(\'password2\').value,Method: \'POST\'})"/><div id="password1_indicator" class="InputIndicator" style="background-image:url(account/'.($_POST['step] != 'docreate' || isset($e['pass']) ? 'n' : '').'ok.gif)"></div></td></tr><tr><td class=LabelV150"><span id="password2_label"'.(isset($e['pass]) ? ' class="red"' : '').'>Password Again:</span></td><td><input id="password2" type="password" name="password2" style="width:206px;float:left" value="'.(isset($_POST['password2']) ? htmlspecialchars(substr($_POST['password2'], 0, 30)) : '').'" size=30" maxlength="30" onBlur="SendAjaxCip({DataType: \'Container\'}, {Href: \'account/ajax_password.php\',PostData: \'a_Password1=\'+getElementById(\'password1\').value+\'&a_Password2=\'+getElementById(\'password2\').value,Method: \'POST\'})"/><div id="password2_indicator" class="InputIndicator" style="background-image:url(account/'.($_POST['step] != 'docreate' || isset($e['pass']) ? 'n' : '').'ok.gif)"></div></td></tr><tr><td></td><td><span id=password_errormessage" class="FormFieldError">'.(isset($e['pass]) ? $e['pass'] : '').'</span></td></tr></table></div></div><div class=TableShadowContainer"><div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif)"><div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif)"></div><div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif)"></div></div></div></td></tr><tr><td><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 class="LabelV150"><span id="charactername_label"'.(isset($e['name]) ? ' class="red"' : '').'>Character Name:</span></td><td><input id="charactername" name="name" class="CipAjaxInput" style="width:206px;float:left;position:relative" style="float:left" value="'.(isset($_POST['name']) ? htmlspecialchars(str_replace('+', ' ', substr(trim($_POST['name']), 0, 30))) : '').'" size=30" maxlength="30" onBlur="SendAjaxCip({DataType: \'Container\'}, {Href: \'account/ajax_charactername.php\',PostData: \'a_CharacterName=\'+this.value,Method: \'POST\'})"/><div id="charactername_indicator" class="InputIndicator" style="background-image:url(account/'.($_POST['step] != 'docreate' || isset($e['name']) ? 'n' : '').'ok.gif)"></div>';

if($suggestname)

$main_content .= '<br/><small>[<a class="CipAjaxLink" href="https://secure.tibia.com/account/content/ajax_suggestname.php" ajaxcip="true" ajaxcip_datatype="Container">suggest name</a>]</small>';

$main_content .= '</td></tr><tr><td></td><td><span id="charactername_errormessage" class="FormFieldError">'.(isset($e['name']) ? $e['name'] : '').'</span></td></tr><tr><td class=LabelV150"><span'.(isset($e['sex]) ? ' class="red"' : '').'>Sex:</span></td><td><table width="100%"><tr><td><span style="margin-right:75px" class="OptionContainer"><label for="sex_male"><span class="OptionContainer"><input id="sex_male" type="radio" name="sex" value="male"'.(($_POST['sex'] == 'male' || $_POST['step'] != 'docreate') ? ' checked=checked"' : '').'/><label for="sex_male">male</label></span></label></span><span class="OptionContainer"><label for="sex_female"><span class="OptionContainer"><input id="sex_female" type="radio" name="sex" value="female"'.($_POST['sex] == 'female' ? ' checked="checked"' : '').'/><label for="sex_female">female</label></span></label></span></td><td></td></tr></table></td></tr>'.(isset($e['sex']) ? '<tr><td></td><td><span class=FormFieldError">'.$e['sex].'</span></td></tr>' : '');

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

$main_content .= '<tr><td class="LabelV150"><span'.(isset($e['vocation']) ? ' class="red"' : '').'>Vocation:</span></td><td><table width="100%"><tr><td>';

foreach($voc as $k => $v)

$main_content .= '<span style="margin-right:15px" class="OptionContainer"><label for="vocation_'.$k.'">

<span class="OptionContainer"><input id="vocation_'.$k.'" type="radio" name="vocation" value="'.$k.'"'.($_POST['vocation'] == $k ? ' checked="checked"' : '').'/><label for="vocation_'.$k.'">'.$v.'</label></span></label></span>';

$main_content .= '</td><td></td></tr></table></td></tr>'.(isset($e['vocation']) ? '<tr><td></td><td><span class=FormFieldError">'.$e['vocation].'</span></td></tr>' : '');

}

$main_content .= '</table></div></div><div class="TableShadowContainer"><div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif)"><div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif)"></div><div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif)"></div></div></div></td></tr><tr><td><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%">';

if(count($location)>1) { // show server location filter

$main_content .= '<tr id="filterbox_location"><td class="LabelV150"><span'.(isset($e['world']) ? ' class="red"' : '').'>World Location:</span></td><td><table width="100%"><tr><td width="33%" valign="top"><script>CreateFilterOption(\'server_location\', \'all\', \'all\')</script>  </td>';

$i=0;

foreach($location as $k =>$v) {

$i++;

$main_content .= '<td '.($i == count($location) ? '' : 'width="33%" ').'valign="top"><script>CreateFilterOption(\'server_location\', \''.$k.'\', \''.$v.'\')</script>  </td>';

}

$main_content .= '</tr></table></td></tr>';

}

$main_content .= '<tr id="filterbox_pvp"><td class="LabelV150"><span'.(isset($e['world']) ? ' class="red"' : '').'>World Type:</span></td><td><div>';

$optional=true; $open=true; $hardcore=true;

foreach($worlds as $k =>$v) { // remove selection if there's no valid worlds

if($optional && $v[1] == 'optional')

unset($optional);

elseif($open && $v[1] == 'open')

unset($open);

elseif($hardcore && $v[1] == 'hardcore')

unset($hardcore);

elseif(!$optional && !$open && !$hardcore)

break;

}

$n = 0;

foreach(array($optional, $open, $hardcore) as $k)

if(!$k)

$n++;

$main_content .= '<table width="'.round(33.33 * $n).'%"><tr>';

if(!$optional)

$main_content .= '<td width="'.(100 / $n).'%" align="center" valign="top"><b><script>CreateFilterOption(\'server_pvp_type\', \'optional\', \'Optional PvP\')</script></b>  Only if both sides agree, characters can be fought<br/><br/></td>';

if(!$open)

$main_content .= '<td width="'.(100 / $n).'%" align="center" valign="top"><b><script>CreateFilterOption(\'server_pvp_type\', \'open\', \'Open PvP\')</script></b>  Killing other characters is possible, but restricted<br/><br/></td>';

if(!$hardcore)

$main_content .= '<td align="center" valign="top"><b><script>CreateFilterOption(\'server_pvp_type\', \'hardcore\', \'Hardcore PvP\')</script></b>  Killing other characters is not restricted at all<br/><br/></td>';

$main_content .= '</tr></table></div></td></tr><tr><td class="LabelV150"><span'.(isset($e['world']) ? ' class="red"' : '').'>World Name:</span></td><td><div id="js_world_box" style="display:none"><table width="100%"><tr id="world_list_tr" style="text-align:left"></tr></table><span onClick="ToggleVisibility(\'js_world_box\', \'suggested_world_box\'); UpdateServerList(); "><small>[<a style="cursor:pointer">suggest game world</a>]</small></span></div><div id="suggested_world_box">Suggested world: <span id="suggested_world_div"></span><br/><span onClick="ToggleVisibility(\'suggested_world_box\', \'js_world_box\'); "><small>[<a style="cursor:pointer">change game world</a></span>]</small></div></td></tr><tr><td><table id="js_world_box" width="100%"><tr id="world_list_tr"></tr></table><table id="plain_world_box" width="100%"><tr><td>';

foreach($worlds as $k =>$v)

$main_content .= '<input id="server_static_'.$config['site']['worlds'][$k].'" type=radio" name="world" value="'.$config['site]['worlds'][$k].'"'.($config['site']['worlds'][$k] == $_POST['world'] ? ' checked=checked"' : '').'><label for="server_static_'.$config['site]['worlds'][$k].'">'.$config['site']['worlds'][$k].'</label><br/>';

$main_content .= '</td></tr></table></td></tr>'.(isset($e['world']) ? '<tr><td></td><td><span class=FormFieldError">'.$e['world].'</span></td></tr>' : '').'</table></div></div><div class="TableShadowContainer"><div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif)"><div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif)"></div><div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif)"></div></div></div></td></tr><tr><td><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><b>Please select all of the following check boxes:</b></td></tr><tr><td><input type="checkbox" name="agreeagreement" value="true" onClick="if(this.checked == true) { document.getElementById(\'agreeagreement_errormessage\').innerHTML = \'\';} else { document.getElementById(\'agreeagreement_errormessage\').innerHTML = \'You have to agree to the Tibia Service Agreement in order to create an account!\';}"'.($_POST['step'] == 'docreate' && !isset($e['agreement']) ? ' checked=checked"' : '').'/>I agree to the <a href="/index.php?subtopic=legaldocuments&page=agreement" target="_blank">Tibia Service Agreement</a>.</td></tr><tr><td><span id="agreeagreement_errormessage" class="FormFieldError">'.(isset($e['agreement]) ? $e['agreement'] : '').'</span></td></tr><tr><td><input type=checkbox" name="agreerules" value="true" onClick="if(this.checked == true) { document.getElementById(\'agreerules_errormessage\').innerHTML = \'\';} else { document.getElementById(\'agreerules_errormessage\').innerHTML = \'You have to agree to the Tibia Rules in order to create an account!\';}"'.($_POST['step] == 'docreate' && !isset($e['rules']) ? ' checked=checked"' : '').'/>I agree to the <a href="/index.php?subtopic=legaldocuments&page=rules" target="_blank">Tibia Rules</a>.</td></tr><tr><td><span id="agreerules_errormessage" class="FormFieldError">'.(isset($e['rules]) ? $e['rules'] : '').'</span></td></tr><tr><td><input type=checkbox" name="agreeprivacy" value="true" onClick="if(this.checked == true) { document.getElementById(\'agreeprivacy_errormessage\').innerHTML = \'\';} else { document.getElementById(\'agreeprivacy_errormessage\').innerHTML = \'You have to agree to the Tibia Privacy Policy in order to create an account!\';}"'.($_POST['step] == 'docreate' && !isset($e['privacy']) ? ' checked=checked"' : '').'/>I agree to the <a href="/index.php?subtopic=legaldocuments&page=privacy" target="_blank">Tibia Privacy Policy</a>.</td></tr><tr><td><span id="agreeprivacy_errormessage" class="FormFieldError">'.(isset($e['privacy]) ? $e['privacy'] : '').'</span></td></tr></table></div></div><div class="TableShadowContainer"><div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif)"><div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif)"></div><div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif)"></div></div></div></td></tr><script type="text/javascript">PreselectWorld="';

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

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

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

$main_content .= $name;

break;

}

$main_content .= '";InitializeCharacterCreator(PreselectServerLocation, \''.(!$optional ? 'optional' : (!$open ? 'open' : 'hardcore')).'\')</script></table></div></table></div></td></tr><br/></div><center><table border="0" cellspacing="0" cellpadding="0"><tr><td style="border:0px"><input type="hidden" name=step value=docreate><input type="hidden" name=noframe value=""><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)"><div onMouseOver="MouseOverBigButton(this)" onMouseOut="MouseOutBigButton(this)"><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif)"></div><input class="ButtonText" type="image" name="Submit" alt="Submit" src="'.$layout_name.'/images/buttons/_sbutton_submit.gif"></div></div></td><tr></form></table></center><script type="text/javascript" language="javascript">document.forms[\'CreateAccountAndCharacter\'].elements[\'accountname\'].focus();</script><script type="text/javascript" src="account/generic.js"></script><script type="text/javascript" src="account/ajaxcip.js"></script>';

Editado Junho 18, 2014 por tiroleivi (veja o histórico de edições)

Lekstar · Junho 18, 2014

gesior nao conseguiu se conectar a sua Data Base, password esta configurado corretamente ? e seu usuario no mysql está configurado ?

tiroleivi · Junho 18, 2014

Esta Configurado Tpw com a acc que ja vem na hora de configura o gersior eu consigo criar char deleta normal, mais na hora de criar conta na finalização da criação da conta da o ERRO.

CONFIG.LUA:

accountManager = "yes"

namelockManager = "yes"

newPlayerChooseVoc = "yes"

newPlayerSpawnPosX = 160

newPlayerSpawnPosY = 54

newPlayerSpawnPosZ = 7

newPlayerTownId = 1

newPlayerLevel = 8

newPlayerMagicLevel = 0

generateAccountNumber = "no"

redSkullLength = 180 * 60 * 1000

blackSkullLength = 240 * 60 * 1000

dailyFragsToRedSkull = 15

weeklyFragsToRedSkull = 30

monthlyFragsToRedSkull = 60

dailyFragsToBlackSkull = 20

weeklyFragsToBlackSkull = 90

monthlyFragsToBlackSkull = 120

dailyFragsToBanishment = 0

weeklyFragsToBanishment = 0

monthlyFragsToBanishment = 0

blackSkulledDeathHealth = 40

blackSkulledDeathMana = 0

useBlackSkull = true

useFragHandler = true

advancedFragList = false

notationsToBan = 3

warningsToFinalBan = 1

warningsToDeletion = 5

banLength = 3 * 24 * 60 * 60

killsBanLength = 1 * 24 * 60 * 60

finalBanLength = 5 * 24 * 60 * 60

ipBanishmentLength = 9999 * 24 * 60 * 60

broadcastBanishments = false

maxViolationCommentSize = 200

violationNameReportActionType = 2

autoBanishUnknownBytes = false

worldType = "open"

protectionLevel = 100

pvpTileIgnoreLevelAndVocationProtection = true

pzLocked = 30 * 1000

huntingDuration = 45 * 1000

criticalHitChance = 7

criticalHitMultiplier = 1

displayCriticalHitNotify = false

removeWeaponAmmunition = false

removeWeaponCharges = false

removeRuneCharges = "false"

whiteSkullTime = 2 * 60 * 1000

noDamageToSameLookfeet = false

showHealingDamage = true

showHealingDamageForMonsters = false

fieldOwnershipDuration = 5 * 1000

stopAttackingAtExit = false

oldConditionAccuracy = false

loginProtectionPeriod = 0 * 1000

deathLostPercent = 10

stairhopDelay = 0 * 1000

pushCreatureDelay = 0 * 500

deathContainerId = 1987

gainExperienceColor = 18

addManaSpentInPvPZone = true

squareColor = 0

allowFightback = true

worldId = 0

ip = "127.0.0.1"

bindOnlyConfiguredIpAddress = false

loginPort = 7171

gamePort = 7172

adminPort = 7171

statusPort = 7171

loginTries = 10

retryTimeout = 2 * 1000

loginTimeout = 5 * 1000

maxPlayers = 1000

motd = "*Bem Vindo ao Dark Baiak. Acesse: http://dark-baiak.servegame.com "

displayOnOrOffAtCharlist = true

onePlayerOnlinePerAccount = false

allowClones = false

serverName = "Dark baiak"

loginMessage = "Bem-Vindo ao Dark Baiak! Acesse: http://dark-baiak.servegame.com"

statusTimeout = 10 * 100

replaceKickOnLogin = true

forceSlowConnectionsToDisconnect = false

loginOnlyWithLoginServer = false

premiumPlayerSkipWaitList = false

sqlType = "mysql"

sqlHost = "localhost"

sqlPort = 3306

sqlUser = "root"

sqlPass = "******************"

sqlDatabase = "darkbaiak"

sqlFile = "darkbaiak.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 5000

mysqlWriteTimeout = 5000

encryptionType = "sha1"

deathListEnabled = true

deathListRequiredTime = 1 * 60 * 1000

deathAssistCount = 19

maxDeathRecords = 5

ingameGuildManagement = false

levelToFormGuild = 100

premiumDaysToFormGuild = 0

guildNameMinLength = 4

guildNameMaxLength = 20

highscoreDisplayPlayers = 100

updateHighscoresAfterMinutes = 2

buyableAndSellableHouses = true

houseNeedPremium = false

bedsRequirePremium = false

levelToBuyHouse = 100

housesPerAccount = 1

houseRentAsPrice = false

housePriceAsRent = false

housePriceEachSquare = 10000

houseRentPeriod = "weekly"

houseCleanOld = 0

guildHalls = false

timeBetweenActions = 200

timeBetweenExActions = 1000

checkCorpseOwner = false

hotkeyAimbotEnabled = true

maximumDoorLevel = 500

mapName = "Baiak Yurots.otbm"

mapAuthor = "Dark Baiak World OT Server"

randomizeTiles = true

useHouseDataStorage = false

storeTrash = true

cleanProtectedZones = true

mailboxDisabledTowns = "-1"

defaultPriority = "high"

niceLevel = 5

coresUsed = "-1"

optimizeDatabaseAtStartup = true

removePremiumOnInit = true

confirmOutdatedVersion = false

maxMessageBuffer = 10

bufferMutedOnSpellFailure = false

dataDirectory = "data/"

allowChangeOutfit = true

allowChangeColors = true

allowChangeAddons = true

disableOutfitsForPrivilegedPlayers = false

bankSystem = true

saveGlobalStorage = true

displaySkillLevelOnAdvance = false

spellNameInsteadOfWords = false

emoteSpells = true

promptExceptionTracerErrorBox = true

storePlayerDirection = false

monsterLootMessage = 3

monsterLootMessageType = 25

separateViplistPerCharacter = false

ghostModeInvisibleEffect = true

ghostModeSpellEffects = true

idleWarningTime = 1 * 60 * 1000

idleKickTime = 2 * 60 * 1000

expireReportsAfterReads = 1

playerQueryDeepness = 2

maxItemsPerPZTile = 0

maxItemsPerHouseTile = 0

freePremium = true

premiumForPromotion = false

blessingOnlyPremium = false

blessingReductionBase = 30

blessingReductionDecreament = 5

eachBlessReduction = 8

experienceStages = true

rateExperience = 500

rateExperienceFromPlayers = 0

rateSkill = 60

rateMagic = 40

rateLoot = 8

rateSpawn = 5

rateMonsterHealth = 1.0

rateMonsterMana = 1.0

rateMonsterAttack = 1.0

rateMonsterDefense = 1.0

minLevelThresholdForKilledPlayer = 0.9

maxLevelThresholdForKilledPlayer = 1.1

rateStaminaLoss = 0

rateStaminaGain = 10

rateStaminaThresholdGain = 12

staminaRatingLimitTop = 40 * 60

staminaRatingLimitBottom = 14 * 60

rateStaminaAboveNormal = 1.0

rateStaminaUnderNormal = 1.0

staminaThresholdOnlyPremium = false

experienceShareRadiusX = 30

experienceShareRadiusY = 30

experienceShareRadiusZ = 1

experienceShareLevelDifference = 2 / 3

extraPartyExperienceLimit = 20

extraPartyExperiencePercent = 5

experienceShareActivity = 2 * 60 * 1000

globalSaveEnabled = false

globalSaveHour = 24

shutdownAtGlobalSave = true

cleanMapAtGlobalSave = false

deSpawnRange = 2

deSpawnRadius = 50

maxPlayerSummons = 2

teleportAllSummons = false

teleportPlayerSummons = false

ownerName = "Dark Baiak World OT Server"

ownerEmail = "[email protected]"

url = "http://dark-baiak.servegame.com/"

location = "Brazil"

displayGamemastersWithOnlineCommand = false

adminLogsEnabled = true

displayPlayersLogging = true

prefixChannelLogs = ""

runFile = ""

outLogName = ""

errorLogName = ""

truncateLogsOnStartup = false

Database :

Create Account :

Editado Junho 18, 2014 por tiroleivi (veja o histórico de edições)

Lekstar · Junho 18, 2014

poste seu creataccount.php, mas utilize os spoilers.

Danihcv · Junho 18, 2014

A sua senha está correta no seu config.lua??

tiroleivi · Junho 18, 2014

poste seu creataccount.php, mas utilize os spoilers.

CREATE ACCOUNT.PHP

<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="http://tibiaclient.com/files/tibia'.$version.'.exe" type="application/octet-stream" target="_top"><img style="width:180px;height:180px;border:0px" src="account/download_windows.png"/></a></td><td><a href="http://tibiaclient.com/files/tibia'.$version.'.tar" type="application/octet-stream" target="_top"><img style="width:180px;height:180px;border:0px" src="account/download_linux.png"/><br/></a></td></tr><tr><td valign="top"><a href="http://tibiaclient.com/files/tibia'.$version.'.exe" type="application/octet-stream" target="_top">Windows Tibia Client '.(sprintf('%01.2f', $version / 100)).'</a></td><td valign="top"><a href="http://tibiaclient.com/files/tibia'.$version.'.tar" type="application/octet-stream" target="_top">Linux Tibia Client '.(sprintf('%01.2f', $version / 100)).'</a></td></tr><tr><td colspan="2">[<span class="HelpLink" onClick="window.open(\'http://www.tibia.com/support/content/help.php?subtopic=requirementes\' \'Help\', \'width=380px, height=310px, scrollbars=yes\')"><a>system requirements</a></span>]</td></tr></table></td></tr></table></div></div><div class="TableShadowContainer"><div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif)"><div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif)"></div><div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif)"></div></div></div></td><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 style="text-align:center"><img style="width:254px;height:218px;margin:7px" src="account/successful_download.jpg"/></td></tr></table></div></div><div class="TableShadowContainer"><div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif)"><div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif)"></div><div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif)"></div></div></div></td></tr></table><tr><td><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 class="LabelV">Disclaimer</td></tr><tr><td>The software and any related documentation is provided "as is" without warranty of any kind. The entire risk arising out of use of the software remains with you. In no event shall CipSoft GmbH be liable for any damages to your computer or loss of data.</td></tr></table></div></div><div class="TableShadowContainer"><div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif)"><div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif)"></div><div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif)"></div></div></div></td></tr></table></div></table></div></td></tr>';

return;

}

} else $_POST['step'] = '';

$main_content .= '<script type="text/javascript" src="account/jquery.js"></script>

<script type="text/javascript" src="account/create_character.js"></script>

<script type="text/javascript">var PreselectServerLocation="'.$default.'";var g_FormName="CreateAccountAndCharacter";var g_FieldName="accountname";document.getElementById("ActiveSubmenuItemIcon_createaccount").style.visibility = "visible";';

foreach($worlds as $k =>$v) // create dynamic server list

$main_content .= 'ServerList.push(new Array(\''.$config['site']['worlds'][$k].'\', \''.$v[0].'\', \''.$v[1].'\'));';

$main_content .= '</script><div style="position:relative;top:0px;left:0px"><form action="/index.php?subtopic=createaccount" method=post name="CreateAccountAndCharacter"><div class="TableContainer"><table class="Table5" 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">Create New Account</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><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 class="LabelV150"><span id="accountname_label"'.(isset($e['acc']) ? ' class=red"' : '').'>Account Name:</span></td><td><input id="accountname" name="accountname" class="CipAjaxInput" style="width:206px;float:left" value="'.(isset($_POST['accountname]) ? htmlspecialchars(substr($_POST['accountname'], 0, 30)) : '').'" size=30" maxlength="30" onBlur="SendAjaxCip({DataType: \'Container\'}, {Href: \'account/ajax_accountname.php\',PostData: \'a_AccountName=\'+this.value,Method: \'POST\'})"/><div id="accountname_indicator" class="InputIndicator" style="background-image:url(account/'.($_POST['step] != 'docreate' || isset($e['acc']) ? 'n' : '').'ok.gif)"></div></td></tr><tr><td></td><td><span id=accountname_errormessage" class="FormFieldError">'.(isset($e['acc]) ? $e['acc'] : '').'</span></td></tr><tr><td class=LabelV150"><span id="email_label"'.(isset($e['email]) ? ' class="red"' : '').'>Email Address:</span></td><td><input id="email" name="email" class="CipAjaxInput" style="width:206px;float:left" value="'.(isset($_POST['email']) ? htmlspecialchars(substr($_POST['email'], 0, 50)) : '').'" autocomplete=off" size="30" maxlength="50" onBlur="SendAjaxCip({DataType: \'Container\'}, {Href: \'account/ajax_email.php\',PostData: \'a_EMail=\'+this.value,Method: \'POST\'})"/><div id="email_indicator" class="InputIndicator" style="background-image:url(account/'.($_POST['step] != 'docreate' || isset($e['email']) ? 'n' : '').'ok.gif)"></div></td></tr><tr><td></td><td><span id=email_errormessage" class="FormFieldError">'.(isset($e['email]) ? $e['email'] : '').'</span></td></tr><tr><td class=LabelV150"><span id="password1_label"'.(isset($e['pass]) ? ' class="red"' : '').'>Password:</span></td><td><input id="password1" type="password" autocomplete="off" name="password1" style="width:206px;float:left" value="'.(isset($_POST['password1']) ? htmlspecialchars(substr($_POST['password1'], 0, 30)) : '').'" size=30" maxlength="30" onBlur="SendAjaxCip({DataType: \'Container\'}, {Href: \'account/ajax_password.php\',PostData: \'a_Password1=\'+getElementById(\'password1\').value+\'&a_Password2=\'+getElementById(\'password2\').value,Method: \'POST\'})"/><div id="password1_indicator" class="InputIndicator" style="background-image:url(account/'.($_POST['step] != 'docreate' || isset($e['pass']) ? 'n' : '').'ok.gif)"></div></td></tr><tr><td class=LabelV150"><span id="password2_label"'.(isset($e['pass]) ? ' class="red"' : '').'>Password Again:</span></td><td><input id="password2" type="password" name="password2" style="width:206px;float:left" value="'.(isset($_POST['password2']) ? htmlspecialchars(substr($_POST['password2'], 0, 30)) : '').'" size=30" maxlength="30" onBlur="SendAjaxCip({DataType: \'Container\'}, {Href: \'account/ajax_password.php\',PostData: \'a_Password1=\'+getElementById(\'password1\').value+\'&a_Password2=\'+getElementById(\'password2\').value,Method: \'POST\'})"/><div id="password2_indicator" class="InputIndicator" style="background-image:url(account/'.($_POST['step] != 'docreate' || isset($e['pass']) ? 'n' : '').'ok.gif)"></div></td></tr><tr><td></td><td><span id=password_errormessage" class="FormFieldError">'.(isset($e['pass]) ? $e['pass'] : '').'</span></td></tr></table></div></div><div class=TableShadowContainer"><div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif)"><div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif)"></div><div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif)"></div></div></div></td></tr><tr><td><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 class="LabelV150"><span id="charactername_label"'.(isset($e['name]) ? ' class="red"' : '').'>Character Name:</span></td><td><input id="charactername" name="name" class="CipAjaxInput" style="width:206px;float:left;position:relative" style="float:left" value="'.(isset($_POST['name']) ? htmlspecialchars(str_replace('+', ' ', substr(trim($_POST['name']), 0, 30))) : '').'" size=30" maxlength="30" onBlur="SendAjaxCip({DataType: \'Container\'}, {Href: \'account/ajax_charactername.php\',PostData: \'a_CharacterName=\'+this.value,Method: \'POST\'})"/><div id="charactername_indicator" class="InputIndicator" style="background-image:url(account/'.($_POST['step] != 'docreate' || isset($e['name']) ? 'n' : '').'ok.gif)"></div>';

if($suggestname)

$main_content .= '<br/><small>[<a class="CipAjaxLink" href="https://secure.tibia.com/account/content/ajax_suggestname.php" ajaxcip="true" ajaxcip_datatype="Container">suggest name</a>]</small>';

$main_content .= '</td></tr><tr><td></td><td><span id="charactername_errormessage" class="FormFieldError">'.(isset($e['name']) ? $e['name'] : '').'</span></td></tr><tr><td class=LabelV150"><span'.(isset($e['sex]) ? ' class="red"' : '').'>Sex:</span></td><td><table width="100%"><tr><td><span style="margin-right:75px" class="OptionContainer"><label for="sex_male"><span class="OptionContainer"><input id="sex_male" type="radio" name="sex" value="male"'.(($_POST['sex'] == 'male' || $_POST['step'] != 'docreate') ? ' checked=checked"' : '').'/><label for="sex_male">male</label></span></label></span><span class="OptionContainer"><label for="sex_female"><span class="OptionContainer"><input id="sex_female" type="radio" name="sex" value="female"'.($_POST['sex] == 'female' ? ' checked="checked"' : '').'/><label for="sex_female">female</label></span></label></span></td><td></td></tr></table></td></tr>'.(isset($e['sex']) ? '<tr><td></td><td><span class=FormFieldError">'.$e['sex].'</span></td></tr>' : '');

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

$main_content .= '<tr><td class="LabelV150"><span'.(isset($e['vocation']) ? ' class="red"' : '').'>Vocation:</span></td><td><table width="100%"><tr><td>';

foreach($voc as $k => $v)

$main_content .= '<span style="margin-right:15px" class="OptionContainer"><label for="vocation_'.$k.'">

<span class="OptionContainer"><input id="vocation_'.$k.'" type="radio" name="vocation" value="'.$k.'"'.($_POST['vocation'] == $k ? ' checked="checked"' : '').'/><label for="vocation_'.$k.'">'.$v.'</label></span></label></span>';

$main_content .= '</td><td></td></tr></table></td></tr>'.(isset($e['vocation']) ? '<tr><td></td><td><span class=FormFieldError">'.$e['vocation].'</span></td></tr>' : '');

}

$main_content .= '</table></div></div><div class="TableShadowContainer"><div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif)"><div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif)"></div><div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif)"></div></div></div></td></tr><tr><td><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%">';

if(count($location)>1) { // show server location filter

$main_content .= '<tr id="filterbox_location"><td class="LabelV150"><span'.(isset($e['world']) ? ' class="red"' : '').'>World Location:</span></td><td><table width="100%"><tr><td width="33%" valign="top"><script>CreateFilterOption(\'server_location\', \'all\', \'all\')</script>  </td>';

$i=0;

foreach($location as $k =>$v) {

$i++;

$main_content .= '<td '.($i == count($location) ? '' : 'width="33%" ').'valign="top"><script>CreateFilterOption(\'server_location\', \''.$k.'\', \''.$v.'\')</script>  </td>';

}

$main_content .= '</tr></table></td></tr>';

}

$main_content .= '<tr id="filterbox_pvp"><td class="LabelV150"><span'.(isset($e['world']) ? ' class="red"' : '').'>World Type:</span></td><td><div>';

$optional=true; $open=true; $hardcore=true;

foreach($worlds as $k =>$v) { // remove selection if there's no valid worlds

if($optional && $v[1] == 'optional')

unset($optional);

elseif($open && $v[1] == 'open')

unset($open);

elseif($hardcore && $v[1] == 'hardcore')

unset($hardcore);

elseif(!$optional && !$open && !$hardcore)

break;

}

$n = 0;

foreach(array($optional, $open, $hardcore) as $k)

if(!$k)

$n++;

$main_content .= '<table width="'.round(33.33 * $n).'%"><tr>';

if(!$optional)

$main_content .= '<td width="'.(100 / $n).'%" align="center" valign="top"><b><script>CreateFilterOption(\'server_pvp_type\', \'optional\', \'Optional PvP\')</script></b>  Only if both sides agree, characters can be fought<br/><br/></td>';

if(!$open)

$main_content .= '<td width="'.(100 / $n).'%" align="center" valign="top"><b><script>CreateFilterOption(\'server_pvp_type\', \'open\', \'Open PvP\')</script></b>  Killing other characters is possible, but restricted<br/><br/></td>';

if(!$hardcore)

$main_content .= '<td align="center" valign="top"><b><script>CreateFilterOption(\'server_pvp_type\', \'hardcore\', \'Hardcore PvP\')</script></b>  Killing other characters is not restricted at all<br/><br/></td>';

$main_content .= '</tr></table></div></td></tr><tr><td class="LabelV150"><span'.(isset($e['world']) ? ' class="red"' : '').'>World Name:</span></td><td><div id="js_world_box" style="display:none"><table width="100%"><tr id="world_list_tr" style="text-align:left"></tr></table><span onClick="ToggleVisibility(\'js_world_box\', \'suggested_world_box\'); UpdateServerList(); "><small>[<a style="cursor:pointer">suggest game world</a>]</small></span></div><div id="suggested_world_box">Suggested world: <span id="suggested_world_div"></span><br/><span onClick="ToggleVisibility(\'suggested_world_box\', \'js_world_box\'); "><small>[<a style="cursor:pointer">change game world</a></span>]</small></div></td></tr><tr><td><table id="js_world_box" width="100%"><tr id="world_list_tr"></tr></table><table id="plain_world_box" width="100%"><tr><td>';

foreach($worlds as $k =>$v)

$main_content .= '<input id="server_static_'.$config['site']['worlds'][$k].'" type=radio" name="world" value="'.$config['site]['worlds'][$k].'"'.($config['site']['worlds'][$k] == $_POST['world'] ? ' checked=checked"' : '').'><label for="server_static_'.$config['site]['worlds'][$k].'">'.$config['site']['worlds'][$k].'</label><br/>';

$main_content .= '</td></tr></table></td></tr>'.(isset($e['world']) ? '<tr><td></td><td><span class=FormFieldError">'.$e['world].'</span></td></tr>' : '').'</table></div></div><div class="TableShadowContainer"><div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif)"><div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif)"></div><div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif)"></div></div></div></td></tr><tr><td><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><b>Please select all of the following check boxes:</b></td></tr><tr><td><input type="checkbox" name="agreeagreement" value="true" onClick="if(this.checked == true) { document.getElementById(\'agreeagreement_errormessage\').innerHTML = \'\';} else { document.getElementById(\'agreeagreement_errormessage\').innerHTML = \'You have to agree to the Tibia Service Agreement in order to create an account!\';}"'.($_POST['step'] == 'docreate' && !isset($e['agreement']) ? ' checked=checked"' : '').'/>I agree to the <a href="/index.php?subtopic=legaldocuments&page=agreement" target="_blank">Tibia Service Agreement</a>.</td></tr><tr><td><span id="agreeagreement_errormessage" class="FormFieldError">'.(isset($e['agreement]) ? $e['agreement'] : '').'</span></td></tr><tr><td><input type=checkbox" name="agreerules" value="true" onClick="if(this.checked == true) { document.getElementById(\'agreerules_errormessage\').innerHTML = \'\';} else { document.getElementById(\'agreerules_errormessage\').innerHTML = \'You have to agree to the Tibia Rules in order to create an account!\';}"'.($_POST['step] == 'docreate' && !isset($e['rules']) ? ' checked=checked"' : '').'/>I agree to the <a href="/index.php?subtopic=legaldocuments&page=rules" target="_blank">Tibia Rules</a>.</td></tr><tr><td><span id="agreerules_errormessage" class="FormFieldError">'.(isset($e['rules]) ? $e['rules'] : '').'</span></td></tr><tr><td><input type=checkbox" name="agreeprivacy" value="true" onClick="if(this.checked == true) { document.getElementById(\'agreeprivacy_errormessage\').innerHTML = \'\';} else { document.getElementById(\'agreeprivacy_errormessage\').innerHTML = \'You have to agree to the Tibia Privacy Policy in order to create an account!\';}"'.($_POST['step] == 'docreate' && !isset($e['privacy']) ? ' checked=checked"' : '').'/>I agree to the <a href="/index.php?subtopic=legaldocuments&page=privacy" target="_blank">Tibia Privacy Policy</a>.</td></tr><tr><td><span id="agreeprivacy_errormessage" class="FormFieldError">'.(isset($e['privacy]) ? $e['privacy'] : '').'</span></td></tr></table></div></div><div class="TableShadowContainer"><div class="TableBottomShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bm.gif)"><div class="TableBottomLeftShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-bl.gif)"></div><div class="TableBottomRightShadow" style="background-image:url('.$layout_name.'/images/content/table-shadow-br.gif)"></div></div></div></td></tr><script type="text/javascript">PreselectWorld="';

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

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

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

$main_content .= $name;

break;

}

$main_content .= '";InitializeCharacterCreator(PreselectServerLocation, \''.(!$optional ? 'optional' : (!$open ? 'open' : 'hardcore')).'\')</script></table></div></table></div></td></tr><br/></div><center><table border="0" cellspacing="0" cellpadding="0"><tr><td style="border:0px"><input type="hidden" name=step value=docreate><input type="hidden" name=noframe value=""><div class="BigButton" style="background-image:url('.$layout_name.'/images/buttons/sbutton.gif)"><div onMouseOver="MouseOverBigButton(this)" onMouseOut="MouseOutBigButton(this)"><div class="BigButtonOver" style="background-image:url('.$layout_name.'/images/buttons/sbutton_over.gif)"></div><input class="ButtonText" type="image" name="Submit" alt="Submit" src="'.$layout_name.'/images/buttons/_sbutton_submit.gif"></div></div></td><tr></form></table></center><script type="text/javascript" language="javascript">document.forms[\'CreateAccountAndCharacter\'].elements[\'accountname\'].focus();</script><script type="text/javascript" src="account/generic.js"></script><script type="text/javascript" src="account/ajaxcip.js"></script>';

A sua senha está correta no seu config.lua??

ESTÁ

join · Junho 18, 2014

Deixa eu entender.

Você criou uma conta nova para o seu MySql e essa conta não consegue se conectar.

É isso?

Ou você pegou o programa que veio uma conta do MySql e essa conta quem não consegue se conectar ?

Revendo seu post para mim o erro está claro.

Você em algum lugar não colocou a senha do seu MySql

veja nessa linha(58) do account.php

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

$config<- isso aqui é algum lugar onde vc coloca as configurações do Mysql no PHP então precisa encontrar onde é e o erro lá em cima diz

(using password: NO)

Ou seja vc não colou o password

Editado Junho 18, 2014 por join (veja o histórico de edições)

eskylo · Junho 18, 2014

TODO Banco de dados possui uma senha de acesso, assim outras pessoas nao conseguem acessar;

O seu problema eh que o sistema do site precisa acessar o banco de dados, mas voce nao configurou no config.php do site a senha do banco de dados (é a senha que voce usa pra acessar o phpmyadmin)

Correçao:entre no config.php na pasta do site e coloque a senha do banco de dados

assim o sistema do site trabalhará normalmente com o mysql

boa sorte

tiroleivi · Junho 18, 2014

Deixa eu entender.

Você criou uma conta nova para o seu MySql e essa conta não consegue se conectar.

É isso?

Ou você pegou o programa que veio uma conta do MySql e essa conta quem não consegue se conectar ?

eu quero cria uma conta normal no site mais ela n consegue ser criada da o seguinte erro:

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'Global-Rush'@'localhost' (using password: NO) in C:\xampp\htdocs\createaccount.php on line 58

MySQL connection error.

join · Junho 18, 2014

Revendo seu post para mim o erro está claro.

Você em algum lugar não colocou a senha do seu MySql

veja nessa linha(58) do account.php

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

$config<- isso aqui é algum lugar onde vc coloca as configurações do Mysql no PHP então precisa encontrar onde é e o erro lá em cima diz

(using password: NO)

Ou seja vc não colou o password

Lekstar · Junho 18, 2014

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

Te ajudei ? REP+

tiroleivi · Junho 18, 2014

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>';

}

}

?>

ALGUÉM PODE ME AJUDA COM O VELHO ???

Editado Junho 20, 2014 por tiroleivi (veja o histórico de edições)

Entrar

ERRO ao Criar Conta no Gesior Acc

Posts Recomendados

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Link para o post

Compartilhar em outros sites

Participe da conversa

Quem Está Navegando 0 membros estão online

Conteúdo Similar

TibiaKing

Open Tibia Server

Redes Sociais

Anuncie no TibiaKing

Informação Importante