Jump to content

Olá Tibiano! Notamos que você está com um adblocker ligado... 

Nós promovemos servidores dentro da comunidade, para que eles tenham visibilidade.

Por favor, nos ajude a continuar promovendo esses servidores. Adicione nosso domínio na whitelist de seu adblocker, ok? :)

Search the Community

Showing results for tags 'error'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • xTibia - Notícias e Suporte
    • Regras
    • Noticias
    • Soluções
    • Projetos Patrocinados
    • Tutoriais para Iniciantes
    • Imprensa
  • OTServ
    • Notícias e Debates
    • OTServlist
    • Recursos
    • Suporte
    • Pedidos
    • Downloads
  • OFF-Topic

Categories

There are no results to display.


Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Sou

Found 37 results

  1. seguinte erro = Parse error: syntax error, unexpected 'case' (T_CASE) in D:\xampp\htdocs\account.php on line 465 || na linha 465 tem assim = #####CHANGE PASSWORD##### case "password": Vou postar o php todo não sei se pode qq coisa me avisa que removo , estou muito precisando da ajuda de vcs código disponível: <?php session_start(); include ('config.php'); $acc_logged = $_SESSION['account']; $pass_logged = $_SESSION['password']; if(!isset($_GET['page'])) { if ((!isset($acc_logged) && isset($pass_logged) && $acc_logged != null && $acc_logged != "" && $pass_logged != null && $pass_logged != "")) header("Location: index.php"); else { connect_db(); include ('top.inc.php'); $noguildid = 0; $empty = ""; $joinchar = $_POST['name']; echo "<script language=\"JavaScript\">\n"; echo "function askConfirm(txt,url) {\n"; echo "if (confirm(txt) == true) {\n"; echo "document.location=url\n"; echo "return true;\n"; echo "} \n"; echo "}\n"; echo "</script>"; if ($acc_logged != "" && $acc_logged != null && $pass_logged != "" && $pass_logged != null) { $login = $_GET['login']; if ($login == "true") { echo "<p>You have successfully logged in!</p>"; } $result = $_GET['result']; if (isset($result) && result != "" && result != null) { if ($result == "char_success") { echo "<h1>Congratulations!</h1><p>Your character was successfully created!</p>"; } } echo '<h1>Account Home:</h1>'; echo '<h2>Options:</h2>'; echo '<a href="account.php?page=char">Create new Character</a><br />'; echo '<a href="account.php?page=password">Change Password</a><br />'; $query2 = mysql_query("SELECT * FROM `accounts` WHERE (`accno` = '".mysql_escape_string($acc_logged)."') ") or die(mysql_error()); while($sql2 = mysql_fetch_array($query2)) { $ownguild_check = mysql_query("SELECT ownguild FROM players WHERE account = '".mysql_escape_string($acc_logged)."' AND ownguild = '1'") or die(mysql_error()); if(mysql_num_rows($ownguild_check) == 1){ echo '<a href="guild.php">Manage Guild</a><br />'; } else { if($sql2['premDays'] >= $guild_premdays) echo '<a href="guild.php?page=create">Create Guild</a><br />'; } if($sql2['hide'] == 1) { $hide = "Yes"; } else { $hide = "No"; } if($sql2['hidemail'] == 1) { $hidemail = "Yes"; } else { $hidemail = "No"; } if($sql2['type'] > 2) { echo '<a href="manager.php">SQL Manager</a><br />'; echo '<a href="news.php?act=post">Post News</a><br />'; } echo '<h2>Personal Information:</h2>'; echo '<table>'; echo '<tr><td>Name: </td><td>'.$sql2['rlname'].'</td></tr>'; echo '<tr><td>Location: </td><td>'.$sql2['location'].'</td></tr>'; echo '<tr><td>Email: </td><td>'.$sql2['email'].'</td></tr>'; echo '<tr><td>Hidden info: </td><td><a href="account.php?page=hide&type=2">'.$hide.'</a></td></tr>'; echo '<tr><td>Hidden email: </td><td><a href="account.php?page=hide&type=3">'.$hidemail.'</a></td></tr>'; } echo '</table><br />'; echo '<h1>Character information:</h1>'; echo '<table border="0" cellSpacing="0" cellpadding="2" width="500px">'; echo '<tr>'; echo '<td><b>Name:</b></td><td><b>Comment:</b></td><td><b>Hidden:</b></td><td><b>Access:</b></td><td><b>Level:</b></td><td><b>Guild:</b></td>'; echo '</tr>'; $query = mysql_query("SELECT * FROM `players` WHERE (`account` = '".mysql_escape_string($acc_logged)."') ") or die(mysql_error()); while($sql = mysql_fetch_array($query)) { if($sql['hide'] == 1) { $hidechar = "Yes"; } else { $hidechar = "No"; } $id=$i+1; echo ($i % 2) ? "<tr bgcolor=\"\">" : "<tr bgcolor=\"\">"; echo '<td><a href="info.php?act=players&char='.$sql['name'].'">'.$sql['name'].'</a></td>'; echo '<td><a href="account.php?page=comment&charname='.$sql['name'].'">Edit</a></td>'; echo '<td><a href="account.php?page=hide&char='.$sql['name'].'&type=1">'.$hidechar.'</a></td>'; echo '<td>'.$sql['level'].'</td>'; echo '<td>'; $guild_query = mysql_query("SELECT * FROM `guilds` WHERE (`guildid` = '".mysql_escape_string($sql['guildid'])."') "); while($guild_sql = mysql_fetch_array($guild_query)) { if($sql['guildid'] >= 1) { if($sql['ownguild'] >= 1) { echo "<a href=\"javascript:askConfirm('Do you want to delete " . htmlentities($guild_sql['guildname']) . "?','guild.php?page=leave&show=delete&id=".$sql['id']."&guildid=".$sql['guildid']."');\">Delete</a></center></td>"; } else { echo "<a href=\"javascript:askConfirm('Do you want to leave " . htmlentities($guild_sql['guildname']) . "?','guild.php?page=leave&show=leave&id=".$sql['id']."&guildid=".$sql['guildid']."');\">Leave</a></center></td>"; } } } echo '</tr>'; ++$i; } echo '</table>'; } } } switch($_GET['page']){ #####HIDE ACTIONS##### case "hide": $type = $_GET['type']; $char = $_GET['char']; if ((!isset($acc_logged) && isset($pass_logged) && $acc_logged != null && $acc_logged != "" && $pass_logged != null && $pass_logged != "" && $type != null)) header("Location: index.php"); else { connect_db(); switch($type){ case 1: $player_query = mysql_query("SELECT hide FROM players WHERE (`name` = '".mysql_escape_string($char)."') ") or die(mysql_error()); $player_sql = mysql_fetch_array($player_query); if(mysql_num_rows($player_query)==0) { echo "<h1>Error</h1><p>Please contact the webmaster.</p>"; } else { if($player_sql['hide'] == 1){ mysql_query("UPDATE players set `hide` = `hide`-1 WHERE name='".mysql_escape_string($char)."'") or die(mysql_error()); } else { mysql_query("UPDATE players set `hide` = `hide`+1 WHERE name='".mysql_escape_string($char)."'") or die(mysql_error()); } } break; case 2: $acc_logged_query = mysql_query("SELECT hide FROM `accounts` WHERE accno = '".mysql_escape_string($acc_logged)."'") or die(mysql_error()); $acc_logged_sql = mysql_fetch_array($acc_logged_query); if($acc_logged_sql['hide'] == 1){ mysql_query("UPDATE accounts set `hide` = `hide`-1 WHERE accno='".mysql_escape_string($acc_logged)."'") or die(mysql_error()); } else { mysql_query("UPDATE accounts set `hide` = `hide`+1 WHERE accno='".mysql_escape_string($acc_logged)."'") or die(mysql_error()); } break; case 3: $acc_logged_query = mysql_query("SELECT hidemail FROM `accounts` WHERE accno = '".mysql_escape_string($acc_logged)."'") or die(mysql_error()); $acc_logged_sql = mysql_fetch_array($acc_logged_query); if($acc_logged_sql['hidemail'] == 1){ mysql_query("UPDATE accounts set `hidemail` = `hidemail`-1 WHERE accno='".mysql_escape_string($acc_logged)."'") or die(mysql_error()); } else { mysql_query("UPDATE accounts set `hidemail` = `hidemail`+1 WHERE accno='".mysql_escape_string($acc_logged)."'") or die(mysql_error()); } break; } header("Location: account.php"); } break; #####DELETE CHARACTER##### case "delete": if ((!isset($acc_logged) && isset($pass_logged) && $acc_logged != null && $acc_logged != "" && $pass_logged != null && $pass_logged != "")) header("Location: index.php"); else { include ('top.inc.php'); connect_db(); $char = $_GET['charname']; $passin = $_POST['password']; $query = mysql_query("SELECT * FROM players WHERE (account = '".mysql_escape_string($acc_logged)."' AND name = '".mysql_escape_string($char)."')") or die(mysql_error()); $query_sql = mysql_fetch_array($query); $acc_logged_query = mysql_query("SELECT * FROM `accounts` WHERE (`accno` = '".mysql_escape_string($acc_logged)."') ") or die(mysql_error()); $acc_logged_sql = mysql_fetch_array($acc_logged_query); if($acc_logged_sql['password'] == $passin) { if(mysql_num_rows($query) == 0) { echo '<h2>Error</h2>'; echo '<p>This is not you char, or it does not exist.</p>'; include ('footer.inc.php'); die; } else { $query_sql['id'] = mysql_escape_string($query_sql['id']); $skills = "DELETE FROM skills where player = '" .mysql_escape_string($query_sql['id']). "'"; mysql_query($skills) or die(mysql_error()); $deaths = "DELETE FROM deathlist where player = '" .mysql_escape_string($query_sql['id']). "'"; mysql_query($deaths) or die(mysql_error()); $items = "DELETE FROM items where player = '" .mysql_escape_string($query_sql['id']). "'"; mysql_query($items) or die(mysql_error()); $Sql = "DELETE FROM players WHERE account='".mysql_escape_string($_SESSION['account'])."' AND id = '".mysql_escape_string($query_sql['id'])."'"; if (!$Result = mysql_query($Sql)){ echo "Error at updating.<br />\n"; echo "Error is: <b>" . mysql_error() . "</b><br/>\n"; echo "Error in SQL: <b>" . $Sql . "</b><br/>\n"; die(); } else { echo '<h1>Congratulations!</h1>'; echo '<p>You have now deleted ' .$query_sql['name']. ' from your account. <br />Please click <a href="account.php">here</a> to go back home!</p>'; include ('footer.inc.php'); die; } } } else { ?> <h1>Character deletion:</h1> <p>You want to delete: <a href="info.php?act=players&char=<? echo $char;?>"><? echo $char;?></a></p> <form action="account.php?page=delete&charname=<?=$char;?>" method="POST"> <p>Password: <input name="password" type="password" value="" class="textfield"></p> <input type="Submit" value="Delete Character"> <input type="Reset" value="Clear Form"> </form> <p><a href="account.php">Return home.</a></p> <?php } } break; #####LOGIN##### case "login": $acc_logged = $_REQUEST['account']; $pass_logged = $_REQUEST['password']; if (isset($acc_logged) && isset($pass_logged)) { connect_db(); $query = mysql_query("SELECT * FROM `accounts` WHERE (`accno` = '".mysql_escape_string($acc_logged)."' AND `password` = '".mysql_escape_string($pass_logged)."') "); if(mysql_num_rows($query) == 1) { $sql = mysql_fetch_array($query); $_SESSION["account"] = $acc_logged; $_SESSION["password"] = $pass_logged; header ("Location: account.php"); } else { header ("Location: index.php"); } } else { header ("Location: index.php"); } break; #####LOGOUT##### case "logout": session_unset(); header("Location: index.php"); break; #####REGISTER##### case "register": include ('top.inc.php'); connect_db(); $error = 0; $id = 0; $id++; $mail = $_POST['mail']; $acc_logged = $_POST['account']; $pass_logged = $_POST['password']; $hidemail = $_POST['hidemail']; $rlname = $_POST['rlname']; $location = $_POST['location']; $show = $_POST['hide']; $md = md5($acc_logged); if (isset($acc_logged) && isset($pass_logged) && $acc_logged != "" && $pass_logged != "") { if ($acc_logged == "111111" || $acc_logged == "1") { echo "<h1>Error!</h1><p>Due to safetey reasons this account number is blocked!</p><br />"; $error = 1; } if (strlen($acc_logged) < 6 || strlen($acc_logged) > 8 || strlen($pass_logged) < 3 || strlen($rlname) > 17 || strlen($location) > 25 || strlen($mail) > 40) { echo "<h1>Error!</h1><p>Please fill out the form correctly!</p>"; $error = 1; } else if (!is_numeric($acc_logged)) { echo "<h1>Error!</h1><p>Your account number must consist of 6 to 8 digits!</p>"; $error = 1; } else { $temp = strspn("$pass_logged", "qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM1234567890 "); if ($temp != strlen($pass_logged)) { echo "<h1>Error!</h1><p>Your password must consist of more then 2 letters or numbers (ABC, abc, 123 and blankspaces)!</p>"; $error = 1; } else { if ($rlname == '') { echo "<h1>Error!</h1><p>Please fill your real life name due to safety reasons.</p>"; $error = 1; } else { if ($location == '') { echo "<h1>Error!</h1><p>Please fill in your location due to safety reasons.</p>"; $error = 1; } else { if ($mail == '') { echo "<h1>Error!</h1><p>Please fill your email adress due to safety reasons.</p>"; $error = 1; } else { if ($error == 0) { $query = mysql_query('SELECT * FROM accounts WHERE (accno = '.mysql_escape_string($acc_logged).')'); if (mysql_num_rows($query) != 0) { echo("<h1>Error!</h1><p>This account number already exist. Please go <a href=\"account.php?page=register\">back</a> and refill the form.</p>"); include ('footer.inc.php'); die; } //$sql = "INSERT INTO accounts(id, accno, password, type, premDays, email, blocked, rlname, location, hide, hidemail) values(NULL,'$acc_logged','$pass_logged','1','0','$mail','0', '$rlname', '$location', '$show', '$hidemail')"; $__reg['account'] = mysql_escape_string($acc_logged); $__reg['pwd'] = mysql_escape_string($pass_logged); $__reg['mail'] = mysql_escape_string($mail); $__reg['rln'] = mysql_escape_string($rlname); $__reg['loc'] = mysql_escape_string($location); $__reg['show'] = mysql_escape_string($show); $__reg['hidemail'] = mysql_escape_string($hidemail); $sql = "INSERT INTO accounts(id, accno, password, type, premDays, " . "premEnd, email, blocked, rlname, location, hide, hidemail)" . " values(NULL,'$__reg[account]','$__reg[pwd]','1','0','0'," . "'$__reg[mail]','0', '$__reg[rln]', '$__reg[loc]', " . "'$__reg[show]', '$__reg[hidemail]')"; mysql_query($sql); session_unset(); ?> <h1>Congratulations!</h1><p>Your account were successfully created. Please login to create your first character.<br /></p> <? } } } } } } } else { if ($acc_logged != "") { ?> <h1>Error!</h1><p>Please fill in all fields.</p><br /><br /> <?php } } if ($created != true) { ?> <h1>Create account:</h1> <form action="account.php?page=register" method="post"> <p>Account Number:<br /> <input name="account" type="password" value="" class="textfield" maxlength="8" /><font color="red">* <i>(6-8 digits)</i></font></p> <p>Password:<br /> <input name="password" type="password" value="" class="textfield" /><font color="red">* <i>(at least 3 characters)</i></font></p> <h1>Real life information:</h1> <p>Real name:<br /> <input name="rlname" type="text" value="" class="textfield"></p> <p>Location:<br /> <input name="location" type="text" value="" class="textfield"></p> <p>Hide real life info?<br /> Yes <input type="radio" name="hide" value="1" style="border: 0;" checked /> No <input type="radio" name="hide" value="0" style="border: 0;"></p> <p>Email adress:<br /> <input name="mail" type="text" value="" class="textfield"></p> <p>Hide Email Adress?<br /> Yes<input type="radio" name="hidemail" value="1" style="border: 0;" checked /> No <input type="radio" name="hidemail" value="0" style="border: 0;"></p> <p><font color="red">Note: The real life information is a way for you to recieve your account again if it gets hacked. So please type it in.</font></p> <br /> <input type="submit" value="Create Account" /> <input type="reset" value="Clear Form" /> </form> <?php } mysql_close(); break; #####CHANGE PASSWORD##### case "password": if ((!isset($acc_logged) && isset($pass_logged) && $acc_logged != null && $acc_logged != "" && $pass_logged != null && $pass_logged != "")) header("Location: index.php"); else { include ('top.inc.php'); connect_db(); ob_start(); $query = mysql_query("SELECT * FROM accounts WHERE (accno = '".mysql_escape_string($_SESSION['account'])."' AND password = '".mysql_escape_string($_SESSION['password'])."')") or die(mysql_error()); if(mysql_num_rows($query) == 0) { echo '<h1>Unknown error.</h1><p>Please contact the webmaster.</p>'; include ('footer.inc.php'); die; } else $query2 = mysql_query("SELECT * FROM `accounts` WHERE (`accno` = '".mysql_escape_string($acc_logged)."') ") or die(mysql_error()); while($sql = mysql_fetch_array($query2)) { echo "<h1>Change Password:</h1>"; if($sql['password'] == $_POST['opass']) { $Sql = "UPDATE accounts SET password = '".mysql_escape_string($_POST['npass'])."' WHERE accno = '".mysql_escape_string($_SESSION['account'])."' AND password = '".mysql_escape_string($_SESSION['password'])."'"; if (!$Result = mysql_query($Sql)) { echo "Error at updateing.<br/>\n"; echo "Error is: <b>" . mysql_error() . "</b><br/>\n"; echo "Error in SQL: <b>" . $Sql . "</b><br/>\n"; die(); } else { echo "<p>Succesfully changed your password.</p>"; $_SESSION['password'] = $_POST['npass']; echo '<p><a href="account.php">Return home</a></p>'; include ('footer.inc.php'); die; } } echo ' <form method="post" action="account.php?page=password"> <p>Current Password:<br /><input type="password" name="opass" size="21"></p> <p>New Password:<br /><input type="password" name="npass" size="21"></p> <p><input type="submit" value="Submit" name="submit"></p> </form> <p><a href="account.php">Return home</a></p>'; } } break; #####COMMENT##### case "comment": if ((!isset($acc_logged) && isset($pass_logged) && $acc_logged != null && $acc_logged != "" && $pass_logged != null && $pass_logged != "")) header("Location: index.php"); else { include ('top.inc.php'); connect_db(); $comment = $_POST['comment']; $query = mysql_query("SELECT * FROM players WHERE (account = '".mysql_escape_string($_SESSION['account'])."' AND name = '".mysql_escape_string($_REQUEST['charname'])."')") or die(mysql_error()); if(mysql_num_rows($query) == 0) { echo "<h1>Error</h1><p>This is not you char, or it does not exist.</p>"; include ('footer.inc.php'); die; } // elseif(isset($_POST['form'])) if ($_SERVER['REQUEST_METHOD'] == "POST") { if(strlen($_POST['comment']) > 255) { echo '<h1>Error:</h1>'; echo '<p>Your comment is too big.</p>'; include ('footer.inc.php'); die; } else { $comment = $_POST['comment']; $comment = htmlentities($comment); $Sql = "UPDATE players SET comment = '".mysql_real_escape_string($comment)."' WHERE account = '".$_SESSION['account']."' AND name = '".$_REQUEST['charname']."'"; if (!$Result = mysql_query($Sql)) { echo "<h1>Error</h1>"; echo "<p>Error in: <b>" . mysql_error() . "</b></p>"; include ('footer.inc.php'); die(); } else { echo '<h1>Congratulations!</h1>'; echo '<p>Your comment has been changed.</p>'; } } } else { $sql = mysql_fetch_assoc($query); ?> <form action="account.php?page=comment&charname=<?= $_REQUEST['charname'];?>" method="POST"> <h1>Comment edit:</h1> <p> <textarea name="comment" cols="45" rows="10"> <?= stripslashes($sql['comment']); ?> </textarea> </p> <input type="Submit" value="Edit comment" name="form"> <input type="Reset" value="Clear Form"> </form> <? } echo '<p><a href="account.php">Return home</a></p>'; } break; #####CHARACTER CREATE FORM##### case "char": if ((!isset($acc_logged) && isset($pass_logged) && $acc_logged != null && $acc_logged != "" && $pass_logged != null && $pass_logged != "")) header("Location: index.php"); else { include ('top.inc.php'); connect_db(); $check = mysql_query('SELECT * FROM players WHERE (name = '.mysql_escape_string($namein).')'); $acc = ""; $pass = ""; $acc = $_SESSION['account']; $pass = $_SESSION['password']; $playername = $_POST['name']; echo '<h1>Create new character:</h1>'; echo '<form action="account.php?page=chargo" method="POST">'; echo '<h2>Name:</h2>'; echo '<input type="text" name="name" class="textfield" maxlength="'.$charlenght.'" /><br />'; echo '<br /><h2>Vocation:</h2>'; if ($chartype == 'rook') { echo '<input type="radio" name="voc" value="0" style="border: 0;" checked /> No Vocation<br />'; } else { echo '<input type="radio" name="voc" value="1" style="border: 0;" checked /> Sorcerer<br />'; echo '<input type="radio" name="voc" value="2" style="border: 0;" /> Druid<br />'; echo '<input type="radio" name="voc" value="3" style="border: 0;" /> Paladin<br />'; echo '<input type="radio" name="voc" value="4" style="border: 0;" /> Knight<br />'; } echo '<br /><h2>Sex:</h2>'; echo '<input type="radio" name="sex" value="1" style="border: 0;" checked /> Male<br />'; echo '<input type="radio" name="sex" value="0" style="border: 0;" /> Female<br />'; echo '<br />'; echo '<input type="submit" value="Create" />'; } break; #####CREATE CHARACTER ACTION##### case "chargo": if ((!isset($acc_logged) && isset($pass_logged) && $acc_logged != null && $acc_logged != "" && $pass_logged != null && $pass_logged != "")) header("Location: index.php"); else { include ('top.inc.php'); connect_db(); ob_start(); $error = 0; $namein = preg_replace('/\s\s+/', ' ', $_POST['name']); $vocin = (int)$_POST['voc']; $sexin = (int)$_POST['sex']; $check = mysql_query("SELECT * FROM players WHERE name = '".mysql_escape_string($namein)."' LIMIT 1") or die(mysql_error()); if ($sexin != 0 && $sexin != 1) { $error_msg = 'Invalid sex.'; $error++; } elseif( ( $vocin != 0 && $chartype == 'rook' ) || ( ( $vocin < 1 || $vocin > 4 ) && $chartype != 'rook' ) ) { $error_msg = 'Invalid vocation.'; $error++; } elseif ($namein == "" || $_POST['sex'] == "" || $_POST['voc'] == "") { $error_msg = 'You did not fill in all fields.'; $error++; } elseif(!preg_match("/^[a-zA-Z][a-zA-Z ]*[a-zA-Z]$/", $namein)) { $error_msg = 'Your name contains illegal characters.'; $error++; } elseif(preg_match("/[ ]{2,}/", $namein)) { $error_msg = 'Check the ammount of spaces in your nickname.'; $error++; } elseif(preg_match("/^gm/i", $namein)) { $error_msg = 'You may not create a Gamemaster.'; $error++; } elseif(preg_match("/^premium/i", $namein)) { $error_msg = 'You may not create a Gamemaster.'; $error++; } elseif(preg_match("/^prem/i", $namein)) { $error_msg = 'You may not create a Gamemaster.'; $error++; } elseif(preg_match("/^admin/i", $namein)) { $error_msg = 'You may not create a Gamemaster.'; $error++; } elseif(preg_match("/^vip/i", $namein)) { $error_msg = 'You may not create a Gamemaster.'; $error++; } elseif(preg_match("/^suport/i", $namein)) { $error_msg = 'You may not create a Gamemaster.'; $error++; } elseif(preg_match("/^account/i", $namein)) { $error_msg = 'You may not create a Gamemaster.'; $error++; } elseif(preg_match("/^adm/i", $namein)) { $error_msg = 'You may not create a Gamemaster.'; $error++; } elseif(preg_match("/^cm/i", $namein)) { $error_msg = 'You may not create a God.'; $error++; } elseif(preg_match("/^supote/i", $namein)) { $error_msg = 'You may not create a God.'; $error++; } elseif(preg_match("/^g o d/i", $namein)) { $error_msg = 'You may not create a God.'; $error++; } elseif(preg_match("/^g m/i", $namein)) { $error_msg = 'You may not create a God.'; $error++; } elseif(preg_match("/^npc/i", $namein)) { $error_msg = 'You may not create a God.'; $error++; } elseif(preg_match("/^lgm/i", $namein)) { $error_msg = 'You may not create a God.'; $error++; } elseif(preg_match("/^lgod/i", $namein)) { $error_msg = 'You may not create a God.'; $error++; } elseif(preg_match("/^norwa/i", $namein)) { $error_msg = 'You may not create a God.'; $error++; } elseif(preg_match("/^gud/i", $namein)) { $error_msg = 'You may not create a God.'; $error++; } elseif(preg_match("/^gamemaster/i", $namein)) { $error_msg = 'You may not create a Gamemaster.'; $error++; } elseif(preg_match("/^god/i", $namein)) { $error_msg = 'You may not create a God.'; $error++; } elseif(preg_match("/^god/i", $namein)) { $error_msg = 'You may not create a God.'; $error++; } elseif(mysql_num_rows($check) != 0) { $error_msg = 'The character name is taken. Please go <a href="create_character.php">back</a>.'; $error++; } elseif (strlen($namein) < 2 || strlen($namein) > $charlenght) { $error_msg = 'You may not have characters with more than '.$charlenght.' characters.'; $error++; } if ($error != 0) { echo '<h1>Error</h1><p>'.$error_msg.'</p>'; include ('footer.inc.php'); } else { $namein = mysql_escape_string($namein); // No voc settings. if($vocin == 0) { mysql_query("INSERT INTO players(name, access, account, level, vocation," . " cid, health, healthmax, direction, experience, lookbody, lookfeet, " . "lookhead, looklegs, looktype, maglevel, mana, manamax, manaspent, " . "masterpos, pos, speed, cap, maxdepotitems, food, sex, guildid, " . "guildrank, guildnick, lastlogin, lastip, save, redskulltime, redskull)" . " values('".$namein."','0','$acc_logged','$startlvl','0','675','" .$novoc['hp'] . "','" .$novoc['hp']. "','2','$startexp','116','116','116','116','128','" . $novoc['mag']. "','" .$novoc['mana']. "','" .$novoc['mana']. "','0','$templepos','$templepos','$startspeed','" .$novoc['cap']. "','$maxdepotitems','0','$sexin','0','','','0','0','1','0','0')") or die(mysql_error()); $query2 = mysql_query("SELECT * FROM `players` WHERE (`name` = '".$namein."') ") or die(mysql_error()); while($sql2 = mysql_fetch_array($query2)) { $playerid = $sql2['id']; } $item1 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','1','0','0','2461','0','0','0','','')"; $item2 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','2','0','0','2170','0','0','0','','')"; $item3 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','3','0','0','1988','0','0','0','','')"; $item4 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','4','0','0','2467','0','0','0','','')"; $item5 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','5','0','0','2512','0','0','0','','')"; $item6 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','6','0','0','2398','0','0','0','','')"; $item7 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','7','0','0','2649','0','0','0','','')"; $item8 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','8','0','0','2643','0','0','0','','')"; $item10 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','10','0','0','2120','0','0','0','','')"; $skills1 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','0','" .$novoc['fist']. "','0')"; $skills2 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','1','" .$novoc['club']. "','0')"; $skills3 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','2','" .$novoc['sword']. "','0')"; $skills4 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','3','" .$novoc['axe']. "','0')"; $skills5 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','4','" .$novoc['dist']. "','0')"; $skills6 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','5','" .$novoc['shield']. "','0')"; $skills7 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','6','" .$novoc['fish']. "','0')"; mysql_query($item1) or die(mysql_error()); mysql_query($item2) or die(mysql_error()); mysql_query($item3) or die(mysql_error()); mysql_query($item4) or die(mysql_error()); mysql_query($item5) or die(mysql_error()); mysql_query($item6) or die(mysql_error()); mysql_query($item7) or die(mysql_error()); mysql_query($item8) or die(mysql_error()); mysql_query($item10) or die(mysql_error()); mysql_query($skills1) or die(mysql_error()); mysql_query($skills2) or die(mysql_error()); mysql_query($skills3) or die(mysql_error()); mysql_query($skills4) or die(mysql_error()); mysql_query($skills5) or die(mysql_error()); mysql_query($skills6) or die(mysql_error()); mysql_query($skills7) or die(mysql_error()); } // Sorcerer settings. elseif($vocin == 1) { mysql_query("INSERT INTO players(name, access, account, level, vocation, cid, health, healthmax, direction, experience, lookbody, lookfeet, lookhead, looklegs, looktype, maglevel, mana, manamax, manaspent, masterpos, pos, speed, cap, maxdepotitems, food, sex, guildid, guildrank, guildnick, lastlogin, lastip, save, redskulltime, redskull) values('$namein','0','$acc_logged','$startlvl','1','675','" .$sorc['hp']. "','" .$sorc['hp']. "','2','$startexp','116','116','116','116','128','" .$sorc['mag']. "','" .$sorc['mana']. "','" .$sorc['mana']. "','0','$templepos','$templepos','$startspeed','" .$sorc['cap']. "','$maxdepotitems','0','$sexin','0','','','0','0','1','0','0')") or die(mysql_error()); $query2 = mysql_query("SELECT * FROM `players` WHERE (`name` = '".$namein."') ") or die(mysql_error()); while($sql2 = mysql_fetch_array($query2)) { $playerid = $sql2['id']; } $item1 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','1','0','0','2461','0','0','0','','')"; $item2 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','2','0','0','2170','0','0','0','','')"; $item3 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','3','0','0','1988','0','0','0','','')"; $item4 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','4','0','0','2467','0','0','0','','')"; $item5 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','5','0','0','2512','0','0','0','','')"; $item6 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','6','0','0','2190','0','0','0','','')"; $item7 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','7','0','0','2649','0','0','0','','')"; $item8 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','8','0','0','2643','0','0','0','','')"; $item10 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','10','0','0','2120','0','0','0','','')"; $skills1 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','0','" .$sorc['fist']. "','0')"; $skills2 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','1','" .$sorc['club']. "','0')"; $skills3 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','2','" .$sorc['sword']. "','0')"; $skills4 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','3','" .$sorc['axe']. "','0')"; $skills5 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','4','" .$sorc['dist']. "','0')"; $skills6 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','5','" .$sorc['shield']. "','0')"; $skills7 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','6','" .$sorc['fish']. "','0')"; mysql_query($item1) or die(mysql_error()); mysql_query($item2) or die(mysql_error()); mysql_query($item3) or die(mysql_error()); mysql_query($item4) or die(mysql_error()); mysql_query($item5) or die(mysql_error()); mysql_query($item6) or die(mysql_error()); mysql_query($item7) or die(mysql_error()); mysql_query($item8) or die(mysql_error()); mysql_query($item10) or die(mysql_error()); mysql_query($skills1) or die(mysql_error()); mysql_query($skills2) or die(mysql_error()); mysql_query($skills3) or die(mysql_error()); mysql_query($skills4) or die(mysql_error()); mysql_query($skills5) or die(mysql_error()); mysql_query($skills6) or die(mysql_error()); mysql_query($skills7) or die(mysql_error()); } // Druid settings. elseif($vocin == 2) { mysql_query("INSERT INTO players(name, access, account, level, vocation, cid, health, healthmax, direction, experience, lookbody, lookfeet, lookhead, looklegs, looktype, maglevel, mana, manamax, manaspent, masterpos, pos, speed, cap, maxdepotitems, food, sex, guildid, guildrank, guildnick, lastlogin, lastip, save, redskulltime, redskull) values('$namein','0','$acc_logged','$startlvl','2','675','" .$druid['hp']. "','" .$druid['hp']. "','2','$startexp','116','116','116','116','128','" .$druid['mag']. "','" .$druid['mana']. "','" .$druid['mana']. "','0','$templepos','$templepos','$startspeed','" .$druid['cap']. "','$maxdepotitems','0','$sexin','0','','','0','0','1','0','0')") or die(mysql_error()); $query2 = mysql_query("SELECT * FROM `players` WHERE (`name` = '".$namein."') ") or die(mysql_error()); while($sql2 = mysql_fetch_array($query2)) { $playerid = $sql2['id']; } $item1 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','1','0','0','2461','0','0','0','','')"; $item2 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','2','0','0','2170','0','0','0','','')"; $item3 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','3','0','0','1988','0','0','0','','')"; $item4 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','4','0','0','2467','0','0','0','','')"; $item5 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','5','0','0','2512','0','0','0','','')"; $item6 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','6','0','0','2182','0','0','0','','')"; $item7 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','7','0','0','2649','0','0','0','','')"; $item8 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','8','0','0','2643','0','0','0','','')"; $item10 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','10','0','0','2120','0','0','0','','')"; $skills1 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','0','" .$druid['fist']. "','0')"; $skills2 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','1','" .$druid['club']. "','0')"; $skills3 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','2','" .$druid['sword']. "','0')"; $skills4 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','3','" .$druid['axe']. "','0')"; $skills5 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','4','" .$druid['dist']. "','0')"; $skills6 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','5','" .$druid['shield']. "','0')"; $skills7 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','6','" .$druid['fish']. "','0')"; mysql_query($item1) or die(mysql_error()); mysql_query($item2) or die(mysql_error()); mysql_query($item3) or die(mysql_error()); mysql_query($item4) or die(mysql_error()); mysql_query($item5) or die(mysql_error()); mysql_query($item6) or die(mysql_error()); mysql_query($item7) or die(mysql_error()); mysql_query($item8) or die(mysql_error()); mysql_query($item10) or die(mysql_error()); mysql_query($skills1) or die(mysql_error()); mysql_query($skills2) or die(mysql_error()); mysql_query($skills3) or die(mysql_error()); mysql_query($skills4) or die(mysql_error()); mysql_query($skills5) or die(mysql_error()); mysql_query($skills6) or die(mysql_error()); mysql_query($skills7) or die(mysql_error()); } // Paladin settings. elseif($vocin == 3) { mysql_query("INSERT INTO players(name, access, account, level, vocation, cid, health, healthmax, direction, experience, lookbody, lookfeet, lookhead, looklegs, looktype, maglevel, mana, manamax, manaspent, masterpos, pos, speed, cap, maxdepotitems, food, sex, guildid, guildrank, guildnick, lastlogin, lastip, save, redskulltime, redskull) values('$namein','0','$acc_logged','$startlvl','3','675','" .$paladin['hp']. "','" .$paladin['hp']. "','2','$startexp','116','116','116','116','128','" .$paladin['mag']. "','" .$paladin['mana']. "','" .$paladin['mana']. "','0','$templepos','$templepos','$startspeed','" .$paladin['cap']. "','$maxdepotitems','0','$sexin','0','','','0','0','1','0','0')") or die(mysql_error()); $query2 = mysql_query("SELECT * FROM `players` WHERE (`name` = '".$namein."') ") or die(mysql_error()); while($sql2 = mysql_fetch_array($query2)) { $playerid = $sql2['id']; } $item1 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','1','0','0','2461','0','0','0','','')"; $item2 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','2','0','0','2170','0','0','0','','')"; $item3 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','3','0','0','1988','0','0','0','','')"; $item4 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','4','0','0','2467','0','0','0','','')"; $item5 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','5','0','0','2512','0','0','0','','')"; $item6 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','6','0','0','3964','0','0','0','','')"; $item7 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','7','0','0','2649','0','0','0','','')"; $item8 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','8','0','0','2643','0','0','0','','')"; $item10 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','10','0','0','2120','0','0','0','','')"; $skills1 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','0','" .$paladin['fist']. "','0')"; $skills2 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','1','" .$paladin['club']. "','0')"; $skills3 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','2','" .$paladin['sword']. "','0')"; $skills4 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','3','" .$paladin['axe']. "','0')"; $skills5 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','4','" .$paladin['dist']. "','0')"; $skills6 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','5','" .$paladin['shield']. "','0')"; $skills7 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','6','" .$paladin['fish']. "','0')"; mysql_query($item1) or die(mysql_error()); mysql_query($item2) or die(mysql_error()); mysql_query($item3) or die(mysql_error()); mysql_query($item4) or die(mysql_error()); mysql_query($item5) or die(mysql_error()); mysql_query($item6) or die(mysql_error()); mysql_query($item7) or die(mysql_error()); mysql_query($item8) or die(mysql_error()); mysql_query($item10) or die(mysql_error()); mysql_query($skills1) or die(mysql_error()); mysql_query($skills2) or die(mysql_error()); mysql_query($skills3) or die(mysql_error()); mysql_query($skills4) or die(mysql_error()); mysql_query($skills5) or die(mysql_error()); mysql_query($skills6) or die(mysql_error()); mysql_query($skills7) or die(mysql_error()); } // Knight settings. elseif($vocin == 4) { mysql_query("INSERT INTO players(name, access, account, level, vocation, cid, health, healthmax, direction, experience, lookbody, lookfeet, lookhead, looklegs, looktype, maglevel, mana, manamax, manaspent, masterpos, pos, speed, cap, maxdepotitems, food, sex, guildid, guildrank, guildnick, lastlogin, lastip, save, redskulltime, redskull) values('$namein','0','$acc_logged','$startlvl','4','675','" .$knight['hp']. "','" .$knight['hp']. "','2','$startexp','116','116','116','116','128','" .$knight['mag']. "','" .$knight['mana']. "','" .$knight['mana']. "','0','$templepos','$templepos','$startspeed','" .$knight['cap']. "','$maxdepotitems','0','$sexin','0','','','0','0','1','0','0')") or die(mysql_error()); $query2 = mysql_query("SELECT * FROM `players` WHERE (`name` = '".$namein."') ") or die(mysql_error()); while($sql2 = mysql_fetch_array($query2)) { $playerid = $sql2['id']; } $item1 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','1','0','0','2461','0','0','0','','')"; $item2 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','2','0','0','2170','0','0','0','','')"; $item3 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','3','0','0','1988','0','0','0','','')"; $item4 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','4','0','0','2467','0','0','0','','')"; $item5 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','5','0','0','2512','0','0','0','','')"; $item6 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','6','0','0','2409','0','0','0','','')"; $item7 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','7','0','0','2649','0','0','0','','')"; $item8 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','8','0','0','2643','0','0','0','','')"; $item10 = "INSERT INTO items(player, slot, sid, pid, type, number, actionid, decaystate, text, specialdesc) values('$playerid','10','0','0','2120','0','0','0','','')"; $skills1 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','0','" .$knight['fist']. "','0')"; $skills2 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','1','" .$knight['club']. "','0')"; $skills3 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','2','" .$knight['sword']. "','0')"; $skills4 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','3','" .$knight['axe']. "','0')"; $skills5 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','4','" .$knight['dist']. "','0')"; $skills6 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','5','" .$knight['shield']. "','0')"; $skills7 = "INSERT INTO skills(player, id, skill, tries) values('$playerid','6','" .$knight['fish']. "','0')"; mysql_query($item1) or die(mysql_error()); mysql_query($item2) or die(mysql_error()); mysql_query($item3) or die(mysql_error()); mysql_query($item4) or die(mysql_error()); mysql_query($item5) or die(mysql_error()); mysql_query($item6) or die(mysql_error()); mysql_query($item7) or die(mysql_error()); mysql_query($item8) or die(mysql_error()); mysql_query($item10) or die(mysql_error()); mysql_query($skills1) or die(mysql_error()); mysql_query($skills2) or die(mysql_error()); mysql_query($skills3) or die(mysql_error()); mysql_query($skills4) or die(mysql_error()); mysql_query($skills5) or die(mysql_error()); mysql_query($skills6) or die(mysql_error()); mysql_query($skills7) or die(mysql_error()); } echo '<h1>Congratulations</h1><p>Successfully created character '.$namein.'.<br />Please click <a href="account.php">here </a>to go back home.</p>'; } } break; ##### ACCOUNT RECOVERY ##### case "lost": include('top.inc.php'); connect_db(); echo '<h1>Lost account interface:</h1>'; if ($_POST['op'] == "recuperar") { if($_POST['tipo'] == "email") { if(isset($_POST['email']) && $_POST['email'] != "") { $acc_query = mysql_query("SELECT * FROM `accounts` WHERE (`email` = '" .mysql_escape_string($_POST['email']). "') LIMIT 1"); if(mysql_num_rows($acc_query)==0) { $error='Invalid e-mail.'; } while($acc_sql=mysql_fetch_array($acc_query)) { $rec_acc=$acc_sql['accno']; $rec_pass=$acc_sql['password']; $endereco=$acc_sql['email']; $nome=$acc_sql['rlname']; } } else { $error='You did not fill in the field.'; } if(empty($error)) { require("class.phpmailer.php"); $mail = new PHPMailer(); // To load the Portuguese version $mail->SetLanguage("br", "language/"); $mail->IsSMTP(); // set mailer to use SMTP $mail->Host = "ssl://smtp.gmail.com"; // specify main and backup server $mail->SMTPAuth = true; // turn on SMTP authentication $mail->Username = "[email protected]"; // SMTP username $mail->Password = "dohc2007"; // SMTP password $mail->From = "[email protected]"; $mail->FromName = "Viking Server"; $mail->AddAddress($endereco, $nome); // name is optional $mail->AddReplyTo("[email protected]", "Viking Server"); $mail->WordWrap = 50; // set word wrap to 50 characters $mail->IsHTML(true); // set email format to HTML $mail->Subject = "Account information"; $mail->Body = "<p>Dear Viking player,</p> <p>Here is your login information:</p> <p><b>Account number:</b> " .$rec_acc. "<br /> <b>Password:</b> " .$rec_pass. "</p> <br /><br /><p>See you in Viking Server!<br /> Your Viking Server Team</p>"; $mail->AltBody = "Account number: " .$rec_acc. " || Password: " .$rec_pass. ""; if(!$mail->Send()) { echo "The message cannot sended. <p>"; echo "Mailer Error: " . $mail->ErrorInfo; echo "</p><p>Inform the Viking-Server Suport about this error: [email protected]</p>"; exit; } echo "<p>Email sent successfully.</p>"; } else { echo '<p>' .$error. ' Please turn <a href="account.php?page=lost">back</a>.</p>'; } } else if($_POST['tipo'] == "account") { if(isset($_POST['account']) && $_POST['account'] != "") { $acc_query = mysql_query("SELECT * FROM `accounts` WHERE (`accno` = '" .mysql_escape_string($_POST['account']). "') LIMIT 1"); if(mysql_num_rows($acc_query)==0) { $error='Invalid account number.'; } while($acc_sql=mysql_fetch_array($acc_query)) { $rec_acc=$acc_sql['accno']; $rec_pass=$acc_sql['password']; $endereco=$acc_sql['email']; $nome=$acc_sql['rlname']; } } else { $error='You did not fill in the field.'; } if(empty($error)) { require("class.phpmailer.php"); $mail = new PHPMailer(); // To load the Portuguese version $mail->SetLanguage("br", "language/"); $mail->IsSMTP(); // set mailer to use SMTP $mail->Host = "ssl://smtp.gmail.com"; // specify main and backup server $mail->SMTPAuth = true; // turn on SMTP authentication $mail->Username = "[email protected]"; // SMTP username $mail->Password = "dohc2007"; // SMTP password $mail->From = "[email protected]"; $mail->FromName = "Viking Server"; $mail->AddAddress($endereco, $nome); // name is optional $mail->AddReplyTo("[email protected]", "Viking Server"); $mail->WordWrap = 50; // set word wrap to 50 characters $mail->IsHTML(true); // set email format to HTML $mail->Subject = "Account information"; $mail->Body = "<p>Dear Viking player,</p> <p>Here is your login information:</p> <p><b>Account number:</b> " .$rec_acc. "<br /> <b>Password:</b> " .$rec_pass. "</p> <br /><br /><p>See you in Viking Server!<br /> Your Viking Server Team</p>"; $mail->AltBody = "Account number: " .$rec_acc. " || Password: " .$rec_pass. ""; if(!$mail->Send()) { echo "The message cannot sended. <p>"; echo "Mailer Error: " . $mail->ErrorInfo; echo "</p><p>Inform the Viking-Server Suport about this error: [email protected]</p>"; exit; } echo "<p>Email sent successfully.</p>"; } else { echo '<p>' .$error. ' Please turn <a href="account.php?page=lost">back</a>.</p>'; } } } else { echo '<p>If you have forgotten your account number or password, you can request to have your account information emailed. Please fill in your registered email address or your account number.</p>'; echo '<table><tr><td align="center" width="50%"><form action="account.php?page=lost" method="post">'; echo '<br />Insert your e-mail:<br /><input type="text" class="textfield" name="email">'; echo '<input type="hidden" name="op" value="recuperar"><input type="submit" value="Send"><input type="hidden" name="tipo" value="email"></form></td>'; echo '<td align="center" width="50%"><form action="account.php?page=lost" method="post">'; echo '<br />Insert your account number:<br /><input type="text" class="textfield" name="account">'; echo '<input type="hidden" name="op" value="recuperar"><input type="submit" value="Send"><input type="hidden" name="tipo" value="account"></form></td></tr></table>'; } break; } include ('footer.inc.php'); ?>
  2. Peguei essa spr e data e não consigo abri-la já tentei mudar o código no obd, adicionar , extend e transparência mas nada vai, gostaria de ajuda. https://www.4shared.com/rar/CHfMid6Iei/DATA.html?
  3. Estou tendo um problema no site do meu Server de Nto, quando qualquer pessoa tenta criar conta está dando o Seguinte erro: The Email field must contain a valid email address. Mesmo o Email e todos os dados estando corretos, este erro persiste em todas as tentativas, se alguém souber resolver por favor da um Help ai. Já tentei trocar de site, já tentei todos os tipos de E-mail e não da. Uso uso TFS 0.4 PROVAVELMENTE O TÓPICO ESTÁ EM ÁREA ERRADA, ENTÃO PEÇO QUE MOVAM PARA MIM, OBRIGADO ! Prints: http://prntscr.com/b1wjs5 http://prntscr.com/b1wjxz
  4. Boa tarde galera, Bom baixei um otserv onde contém oque eu preciso para poder montar um otserv do meu jeito, e do jeito que eu queria. Porém quando eu ligo ele, ele funciona 100% porem eu nao consigo usar o 1/1 ou dando so o Enter.. AI aindei olhando uns tutoriais tem aver com essa Tag Tag encryptionType = "sha1" Eu abrindo o servido assim, ele nao da nenhum erro, porem eu nao consigo cria acc nem entrar pois nao consigo ver a senha do GOD! Agora eu usando "plain" eu consigo usar o 1/1, mais nisso da um erro no distro Alguem sabe dizer o porque? [18/12/2016 14:31:26] >>> WARNING: This method is completely unsafe! [18/12/2016 14:31:26] >>> Please set encryptionType = "sha1" (or any other available method) in config.lua
  5. Olá, queria começar a criar meu primeiro pokétibia, achei uma base bem legal aqui pelos fóruns mas não consigo ligar o servidor, ja mudei o ip da config.lua e tudo mais, lembrando que sou iniciante ainda e talvez tenha feita algo errado, por isso estou pedindo ajuda. obrigado. ERROR: couldn't establish connection to SQL database
  6. Olá, Não tenho certeza se estou postando no local correto, caso não esteja se algum moderador poder me redirecionar. Meu problema e o seguinte... Eu abri as portas do modem 7171 - 7172 TCP/UDP Mais quando eu verifico da como se estive-se CLOSED (FECHADA) Fiz o teste de deixar o servidor online com o seguinte configuração Eu uso o DUC (NO-IP) para deixar IP/FIXO Eu uso o The Forgotten Server Se eu tento acessar meu servidor eu consigo abrir até a SELEÇÃO DE CAMPEÃO Mais quando eu tento conectar Meu firewall portas 7171 - 7172 Acho que deu para vocês ter 1 ideia do oque estou passando... se alguém de bom coração poder me esclarecer como arrumar isso... Minhas configurações: Uso modem Thomson TG800 OTServ 10.90
  7. Ola amiguinhos do xtibia preciso de uma peguana ajuda de vçs eu comprei uma maquina linux dai compilei sem error mais quando fica on nao consigo logar aqui esta a print! poderiam me ajudar? Agradecido
  8. Olá boa tarde alquem sabe como resolver esse erro na base dxp ? Error - TalkAction Interface][05/10/2016 11:14:41] data/talkactions/scripts/move1.lua:onSay[05/10/2016 11:14:41] Description:[05/10/2016 11:14:41] data/lib/pokemon moves.lua:520: attempt to perform arithmetic on a boolean value[05/10/2016 11:14:42] stack traceback:[05/10/2016 11:14:42] data/lib/pokemon moves.lua:520: in function 'docastspell'[05/10/2016 11:14:42] data/talkactions/scripts/move1.lua:182: in function <data/talkactions/scripts/move1.lua:20>
  9. Estou tendo esse error ao ligar o server: - MYSQL ERROR: Table 'servidor.player_statements' doesn't exist (1146) Tentei usar esse comando no site: CREATE TABLE `player_statements` ( `id` int(11) NOT NULL AUTO_INCREMENT, `player_id` int(11) NOT NULL, `channel_id` int(11) NOT NULL DEFAULT '0', `text` varchar(255) NOT NULL, `date` bigint(20) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `player_id` (`player_id`), KEY `channel_id` (`channel_id`), CONSTRAINT `player_statements_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Mas tive esse erro abaixo: #1005 - Can't create table 'servidor.player_statements' (errno: 150)
  10. Olá, fiz um piso no qual o jogador pisa e 3 segundos após ele toma dano, porém, se o jogador morre no meio desse dano, ou até mesmo desloga antes de tomar o dano, da erro no console, alguém sabe me ajudar a solucionar esse error? Segue abaixo o script function onStepIn(cid, item, pos)if isPlayer(cid) == TRUE thenaddEvent(doTargetCombatHealth, 100, 0, cid, COMBAT_PHYSICALDAMAGE, 0, 0, 59)addEvent(doTargetCombatHealth, 500, 0, cid, COMBAT_PHYSICALDAMAGE, 0, 0, 59)addEvent(doTargetCombatHealth, 1000, 0, cid, COMBAT_PHYSICALDAMAGE, 0, 0, 59)addEvent(doTargetCombatHealth, 1500, 0, cid, COMBAT_PHYSICALDAMAGE, 0, 0, 59)addEvent(doTargetCombatHealth, 2000, 0, cid, COMBAT_PHYSICALDAMAGE, 0, 0, 59)addEvent(doTargetCombatHealth, 2500, 0, cid, COMBAT_PHYSICALDAMAGE, -250, -750, 57)endif(not isPlayer(cid)) thenaddEvent(doTargetCombatHealth, 100, 0, cid, COMBAT_PHYSICALDAMAGE, 0, 0, 59)addEvent(doTargetCombatHealth, 500, 0, cid, COMBAT_PHYSICALDAMAGE, 0, 0, 59)addEvent(doTargetCombatHealth, 1000, 0, cid, COMBAT_PHYSICALDAMAGE, 0, 0, 59)addEvent(doTargetCombatHealth, 1500, 0, cid, COMBAT_PHYSICALDAMAGE, 0, 0, 59)addEvent(doTargetCombatHealth, 2000, 0, cid, COMBAT_PHYSICALDAMAGE, 0, 0, 59)addEvent(doTargetCombatHealth, 2500, 0, cid, COMBAT_PHYSICALDAMAGE, -250, -750, 57)end return trueend [19:57:45.252] [Error - MoveEvents Interface] [19:57:45.259] In a timer event called from: [19:57:45.265] data/movements/scripts/espinhos.lua:onStepIn [19:57:45.270] Description: [19:57:45.280] (luaDoTargetCombatHealth) Creature not found
  11. Olá estou criando otserver em linux, compilei tudo certinho o otserver intalei apache2,phpmyadmin,mysql, dei permissão nas pastas, enviei os aquivos do ot e do site via ftp. Porem, quando vou entrar no site do ot da esse erro. da uma ajudinha por favor. It works! This is the default web page for this server. The web server software is running but no content has been added, yet.
  12. miupinho

    1 ERROR

    E aí galera, Não sei se é só comigo, ou com outros membros, mas o fórum está bugando sempre, sobre mensagens da caixa de entrada, você consegue ver que tem mensagem, mas não abre. Gostaria de receber um feedback sobre esse bug, se já estão cientes ou se é o primeiro caso que reclama sobre. @Daniel Atenciosamente, m1up
  13. Gente, tô desenvolvendo um jogo e estou tendo um erro com um script. Tentei outros forums mas não obtive sucesso com o auxilio... Bom o script é o seguinte. Ele é em Python e seu trabalho é o seguinte: Quando o personagem colidir com nuvem, a nuvem mudará de cor para a cor da cabeça do personagem. o script pode ser encontrado no spoiler:
  14. Bom galera, direto ao assunto, segui um tópico no OTLand(aqui) para adicionar o evento Zombie Event no meu server. Tudo certo até os players entrarem no mapa do zombie, mas ai começa uns bugs no console: Ai vai o meu lib/zombie_event.lua globalevents/scripts/zombie/onthink.lua POR FAVOR, ME AJUDEM!! Quero muito esse evento, e nenhum outro na internet funcionou comigo... NENHUM!
  15. Ola pessoal recentemente baixei um servidor Nto United porem esta dando um "erro" (não sei se e kkkk) ao iniciar o servidor Alguém poderia me ajudar por favor A Db do servidor so abre como txt não ser porq Erro ao iniciar Desde ja agradecido (Desculpem por qqr erro) -- Database -- NOTE: sqlFile is used only by sqlite database, and sqlKeepAlive by mysql database. -- To disable sqlKeepAlive such as mysqlReadTimeout use 0 value. sqlType = "mysql" sqlHost = "localhost" sqlPort = 3306 sqlUser = "root" sqlPass = "" sqlDatabase = "naruto" sqlFile = "naruto" sqlKeepAlive = 0 mysqlReadTimeout = 10 mysqlWriteTimeout = 10 encryptionType = "sha1"
  16. Adriez

    Debug Error

    fala galera, eu peguei uma area donate de outro ot e coloquei no meu só q agora qualquer lugar q eu logo da esse debug erro, como resolver ???
  17. Bom galera, eu tenho um mapa Hero com a distro Allisow Server, não uso o TFS 0.4 por conta dos inúmeros erros que ele provoca nesse mapa, por favor, não diga para trocar de distrô, primeiro quero resolver alguns erros. É o seguinte, nesse server tem as talkactions: Porém, quando usados, aparecem alguns erros, segue abaixo os erros escritos no pastebin: !axe http://pastebin.com/MGW88xcT !sword http://pastebin.com/SMw1LhLx !club http://pastebin.com/ewfTvXg5 !knightshield http://pastebin.com/aUnft63S !knightmagic http://pastebin.com/QRz6CHAX -- NÃO RECEBE O ML 250 !distance http://pastebin.com/DfxwmJPw !paladinshield http://pastebin.com/GkdbEwn6 !paladinmagic http://pastebin.com/fc28HbfD -- NÃO RECEBE O ML 250 !sorcerer http://pastebin.com/mqhiyk5z !druid http://pastebin.com/DQwS4vYA Segue os arquivos ligados aos erros axefull https://www.sendspace.com/file/u9gduz shieldfull https://www.sendspace.com/file/6u9pz7 shieldfull2 https://www.sendspace.com/file/xqin5l swordfull https://www.sendspace.com/file/9ikl8i clubfull https://www.sendspace.com/file/jx6hsl distancefull https://www.sendspace.com/file/5gwnar magicfull https://www.sendspace.com/file/ksv8ak magicfull2 https://www.sendspace.com/file/afytjk magicfull3 https://www.sendspace.com/file/bfnq2f magicfull4 https://www.sendspace.com/file/q833d7 npc/scripts/default.lua https://www.sendspace.com/file/hze5by npc/scripts/promotion.lua https://www.sendspace.com/file/a60geu OBS.: Todos os comandos precisam da promotion "hero" para tal vocação, mas, nenhuma bloqueia o player de usar a talk se ele não ter a promotion, ocorrendo o erro envolvendo o arquivo promotion.lua Obrigado desde já! Edit: Se precisar de scan, por favor, me ajudem com isso!
  18. EAE GALERA, PRECISO DE AJUDA URGENTE!!!! Quando eu digito ./autogen.sh no terminal, eu ganho essa merda de erro: autoreconf: Entering directory `.' autoreconf: configure.ac: not using Gettext autoreconf: running: aclocal --force autoreconf: configure.ac: tracing autoreconf: configure.ac: not using Libtool autoreconf: running: /usr/bin/autoconf --force autoreconf: running: /usr/bin/autoheader --force autoreconf: running: automake --add-missing --copy --force-missing /usr/share/automake-1.11/am/depend2.am: am__fastdepCC does not appear in AM_CONDITIONAL /usr/share/automake-1.11/am/depend2.am: The usual way to define `am__fastdepCC' is to add `AC_PROG_CC' /usr/share/automake-1.11/am/depend2.am: to `configure.ac' and run `aclocal' and `autoconf' again. Makefile.am: C source seen but `CC' is undefined Makefile.am: The usual way to define `CC' is to add `AC_PROG_CC' Makefile.am: to `configure.ac' and run `autoconf' again. Makefile.am:23: variable `theforgottenserver_SOURCES' is defined but no program or Makefile.am:23: library has `theforgottenserver' as canonical name (possible typo) Makefile.am:8: variable `theforgottenserver_LDADD' is defined but no program or Makefile.am:8: library has `theforgottenserver' as canonical name (possible typo) autoreconf: automake failed with exit status: 1 POR FAVOR ME AJUDEM, ESTOU USANDO UBUNTU 12.04
  19. Olá, eu coloquei um script de quest ele ta dando erro não sei o que fazer kkk... Meu Script Error [04/01/2016 21:32:20] [Error - LuaScriptInterface::loadFile] data/actions/scripts/gem.lua:3: unexpected symbol near '=' [04/01/2016 21:32:20] [Warning - Event::loadScript] Cannot load script (data/actions/scripts/gem.lua) [04/01/2016 21:32:20] data/actions/scripts/gem.lua:3: unexpected symbol near '='
  20. Bom galera, vamos direto ao assunto: Eu sempre tive esse server de tibia, ele nunca apresentou esse problema, mas hoje, mais precisamente, 20 minutos atrás, apareceu isso no distro: Poxa, EU QUE COMPILEI o TFS 0.4, nunca deu esse problema, essa distro contém muitas features e eu não gostaria de trocar ela, NEM PENSAR NESSA HIPÓTESE. Ja passei o Laatido no executável, ja procurei vários tópicos na internet, vários falaram pra compilar em 64 bits, mas eu usei o Stian's Repack DevCPP configurado para 64 bits. Como pode dar esse problema? Meu PC: Windows 7 Ultimate 64 bits 4 gb de RAM 500 gb de HD Processador Inter® Core i5-3210M CPU @ 2.50GHz 2.50GHz Service Pack 1 Por favor, me ajudem! Não quero nem pensar em trocar a distro, e estou limpando o server desde fevereiro desse ano... Corrigi MUITOS, MAS MUITOS bugs mesmo... OBRIGADO!
  21. Estou tentando usar esse script em uma talkaction: function onSay(cid, words, param) local coisas = db.getResult("SELECT `level` FROM `global`.`players` WHERE `name` = 'Master Pig';") player_level = coisas:getDataInt("level") player:sendTextMessage(MESSAGE_STATUS_CONSOLE_BLUE, "Name: " .. player_level) end ( Já tentei trocar o argumento da função onSay de cid para player, mas o erro continuou) tentei simplificar o máximo possivel, mas o erro persiste Lua Script Error: [TalkAction Interface] data/talkactions/scripts/teste.lua:onSay data/talkactions/scripts/teste.lua:3: attempt to call field 'getResult' (a nil value) stack traceback: [C]: in function 'getResult' data/talkactions/scripts/teste.lua:3: in function <data/talkactions/scripts/teste.lua:1> Quando eu jogo a Query no phpmyadmin ela da o retorno certo. Estou Usando o TFS 1.0 para 10.82
  22. Bom galera, eu tenho um mapa aqui, eu uso TFS 0.4 nele, eu que compilei e tals, uso esse distro em todo mapa que eu tenho, mas nesse, aparece um problema que eu não entendi, ai vai uma screenshot: Quero resolver essa parada logo! Por favor galera! Obrigado! up up!
  23. Daao

    erro Look

    Boa tarde Galera. Estou com um problema em meu ot,n consigo dar look em nenhum char em inclusive no meu tbm n,gostaria de uma ajudar fazendo favor,posso dar look em tudo,menos em chars,n aparece nada,qm poder me ajudar ficarei grato!E esse bug so apareceu quando eu coloquei site no ot,quando n tinha ot,o look em player funcionava normal. OBS:da esse error aqui quando dar look [07/12/2015 13:42:10] mysql_real_query(): SELECT `rep` FROM `players` WHERE `id` = 9 LIMIT 1 - MYSQL ERROR: Unknown column 'rep' in 'field list' (1054) [07/12/2015 13:42:10] [Error - CreatureScript Interface] [07/12/2015 13:42:10] data/creaturescripts/scripts/rep/repLook.lua:onLook [07/12/2015 13:42:10] Description: [07/12/2015 13:42:11] data/lib/004-database.lua:60: [Result:getDataInt] Result not set! [07/12/2015 13:42:11] stack traceback: [07/12/2015 13:42:11] [C]: in function 'error' [07/12/2015 13:42:11] data/lib/004-database.lua:60: in function 'getDataInt' [07/12/2015 13:42:11] data/lib/050-function.lua:667: in function 'getRepPoints' [07/12/2015 13:42:11] data/creaturescripts/scripts/rep/repLook.lua:8: in function <data/creaturescripts/scripts/rep/repLook.lua:5>
  24. Eu estou tentando abrir um ot global(eu irei hostear) , veio os seguintes arquivos pra download - " Datapack Soucers com cast 10.82 Executavel x64 Windows Website compativel 100% Database , -- Baixei o xampp 1.7.3 , liguei apache e mysql e tal , criei um banco de dados , importei o database que veio nos links para download , fui na pasta htdocss deletei td q tinha e copiei oq veio na pasta "www" que no caso é o site eu acho, e colei la , abri o admin do apache no xampp e deu esse erro " Error occured!Error ID: #C-2 More info: ERROR: #C-2 : Class::ConfigLUA - LUA config file doesn't exist. Path: /otserv/config.lua File: C:\xampp\htdocs\classes/configlua.php Line: 24 File: C:\xampp\htdocs\classes/configlua.php Line: 12 File: C:\xampp\htdocs\system/load.init.php Line: 42 File: C:\xampp\htdocs/index.php Line: 18 ----------- Alguem pode me ajudar fazendo um favor ? Não tenho experiencia nenhuma com isso e nem tenho ideia do que fazer ...
  25. Olá pessoas, recentemente eu quero e muito compilar uma distro TFS 1.2 e não to conseguindo, tinha erros em cima de erros, antes era da boost, consegui resolver e tudo. Agora ta esse erro maldito ai - http://prntscr.com/94y3sx Alguém? Obs - Já segui mais de 6 tutoriais de compilação, e todos para nesse erro.
×
×
  • Create New...