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 'ajuda'.



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 291 results

  1. Boa tarde a todos, gostaria de saber onde fica os códigos (em quais arquivos) sobre Card System na base PokeMasterX , estou querendo adicionar em base PDA, até logo Obrigado
  2. Boa noite a todos do xTibia, gostaria de uma ajuda pra adicionar uma funçao chamada GetSpectators Base que uso : PDA {Base PokexTibiano desse forúm} agradeco a ajuda
  3. olá, eu gostaria de saber se alguém pode me ajudar com um npc pra resetar a storege dos players pra q eles possam fazer as quests dnv, em troca de um certo item, ou até msm um item q reset a storage q dai faço o npc q troca ele pelo outro item, tentei algumas formas, mas n consigo resetar tds asstoreges ;-; , bem axo q é isso desde já obgd
  4. Alguém poderia me ajudar, eu estou adicionando a Master Ball no meu servidor utilizo um pda open source, porém qndo eu uso o comando /i pra chamar ela acontece isso: --> Já adicionei em todos os arquivos, actions, items, catch system, e continua acontecendo isso o item ganha um novo look, só que não funciona e ainda buga o char. Por favor alguém me ajuda, já tentei de tudo. Aguardo a resposta. E desculpem a formatação.
  5. NiCaDo

    (Duvida) OTClient

    como alterar essa sprite efeito ou imagem que fica em volta do pokemon quando passa o mouse em cima selecionado: https://prnt.sc/pvhwd4 Atacando: https://prnt.sc/pvhvxx
  6. Olá Galera, eu estou com uma pequena dificuldade no meu site, eu queria por exemplo: Fula vai criar uma acc, ele vai e ganhar um determinado de dias premium.. como consigo isso ?
  7. Olá! Boa tarde à todos. Como vocês estão? Pessoal, Não sei se estou com o título correto ou algo do tipo (foi o melhor que pensei). Gostaria de solicitar uma Talkaction/System que mandaria o player para a Jail e retirasse 15% da XP TOTAL do player. Eu tenho uma prisão montada e só falta os comandos e o sistema. A Versão do servidor é uma das mais recentes: 12.1/12.15. TFS: 1.3. Teria como me ajudar com algo? Desde já, agradeço a compreensão. Obs. Não sei se estou na sessão correta, caso contrário, por gentileza poderia coloca-lo? Obrigado. 
  8. alguém poderia me passar um tutorial de como instalar este serve??
  9. Emtão, eu vi um servidor a um tempo atrás que tinha uns rings, que quando você usava dobrava seu damage, porém ficava tipo assim por exemplo: avalanche rune, bate de 150 +100 com o ring, e os números do extra damage do ring, sobem de outra cor, para diferenciar não sei se da para entender. meu server 8.6 baiak rox ice
  10. Pessoal preciso de uma ajuda com coisas do shop no site de poketibia , tipo eu entendo só de html e javascript nd de php nem mysql , e bem que seria material para estudo n em si para um servidor vou citar um problema que é meio bobo mas não tenho informação nenhuma sobre então por isso estou pedindo ajuda 1- não sei me dar adm noo site 😣
  11. Boa tarde ,noite ou dia o/ galera gostaria de tirar uma duvida com voçes , antigamente eu jogava alguns servidores aleatórios de poketibia que achava no otservelist, e gostaria de baixar o server base ou alguma versão parecida para fazer algumas modificações e jogar com uns amigos , o servidor era daqueles que os pokemons usavam as habilidades automaticamente e não eram espalhados pelo mapa , e sim cada um tinha a sua zona separada q era acessada por um teleporte (bem parecido com os baiaks 8,6) não sei o nome do server base , se alguém tiver algum link ou pelo menos o nome base desse tipo de server já ajudaria o/ des de já grato 😁
  12. Não sei se estou postando no local correto, desculpe se não estiver e peço que movam para o local apropriado. Eu estou com um problema nos Liquids/Potions - Eles estão dando muito exhaust, ao ponto de não conseguir abrir um corpo ou equipar um ring. Alguém poderia me ajudar? Já tentei criar outro "Between" no config.lua: -> timeBetweenPotActions e alterei nos em todos arquivos lá de potion na pasta actions, mas não resolveu, nem sei se esta alteração que fiz teria como resolver . Alguém pode me ajudar?
  13. Bom dia, tudo bem? Cara, eu estou com uma duvida um pouco relativa... Sempre que eu finalizo uma compra no meu site com o seu sistema de pagamento, os pontos não são entregues a conta... Pq? Poderia me dizer se estou fazendo alguma coisa errada? # Pagseguro config By IVENSPONTES $config['pagSeguro']['email'] = "meu email"; //Email Pagseguro $config['pagSeguro']['token'] = "TOKEN TA CORRETO"; // TOKEN $config['pagSeguro']['urlRedirect'] = 'ipdoserver/?subtopic=donate&action=final'; //turn off redirect and notifications in pagseguro.com.br $config['pagSeguro']['urlNotification'] = 'ipdoserver/retpagseguro.php'; //your return location $config['pagSeguro']['productName'] = 'Premium Points'; $config['pagSeguro']['productValue'] = 1.00; // 1.50 = R$ 1,50 etc... $config['pagSeguro']['doublePoints'] = true; ## Double points - true is on / false is off $config['pagSeguro']['host'] = 'localhost'; ## YOUR HOST <--------------- Essa é minha duvida, pois uso servidor/site criado pela #####, deixo localhost ou tenho q colocar ( IpDoHost/phpmyadmin-secure) ??????? $config['pagSeguro']['database'] = 'MINHADB'; ## DATABASE $config['pagSeguro']['databaseUser'] = 'root'; ## USER $config['pagSeguro']['databasePass'] = ''; ## PASSWORD Meu retpagseguro.php
  14. 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'); ?>
  15. galera vocês poderiam me ajudar com um sicript, tipo o player morreu para um alakazam ae ele usa item "x" e volta no lugar onde ele morreu para o alakazam, alguem poderia me ajudar com isso vlw
  16. Ola Amigos do Xtibia Gostaria de saber como eu adiciono novos Efeitos , Magias , Sei que tem que adicionar as magias no Object , e Depois???
  17. GHelty

    Ajuda Mapa

    Bom dia, galera Alguém teria o mapa da quest The curse spreads (Segunda cave dos monstros de Grimvale), quem puder ajudar agradeço.
  18. Bom dia,  Recriei todo o mapa dos Falcons Com os mínimos detalhes porém 6 itens [Banquinhos] do mapa não encontrei o nome nem o item no RME, quem puder ajudar agradeço muito.
  19. Bom dia, Galera alguém tem os scripts dos npcs do global por que o servidor que estou editando esta faltando vários os principais seriam esses quem puder ajudar: 90% ou 100% são de quest NPC Eclesius NPC Jerom NPC Bunny NPC Norman The Foreman NPC guia(ex:Aneus, Gnomad, Guide Elena NPC Rafzan NPC Iriana NPC Ashari NPC Costello NPC Eroth NPC Rapanaio NPC Oldrak NPC Baxter NPC Wyrdin NPC Julius NPC Zoltan NPC Raymond Striker NPC One-eyed Joe NPC Larek NPC Rotem Valos NPC Sinatuki NPC Alkestios NPC Mr Brandon NPC Guardian of the deep seas NPC Oldrak
  20. E aí, galera! Comecei a estudar PixelArt e Spriting, faz bem pouco tempo, mas já me arrisquei a fazer algumas coisas. Essa semana fiz um monstro clássico pra quem curte jogar D&D ou outros RPG's de mesa, o Bulette. Eu procurei fazer uma paleta de cores decente, conforme alguns tutoriais, mas apesar de eu até achar que está bom, queria saber se vocês tem algumas dicas ou críticas construtivas, sobre a paleta, outline, iluminação... Qualquer coisa! Apenas pra ver melhor onde estão meus erros e controlar o meu aprendizado. Valeu!!
  21. Olá, gostaria de ajuda em uma spell, o Amaterasu. Ao castar aparece um efeito passageiro em min(109) e aparece o fogo do target (effect80), após esse hit o target fica com a condition dazzled, cada dazzled (effect 79) o player vai receber 5( de dano com um intervalo de 2 segundos durando 10 hits. E teria outra magia (stop Amaterasu) que so poderia castar se o target estiver com condition dazzled, ao castar apareceria um effect em min (109) retiraria 1k de dano em min e removeria a condition dazzled do target.. Uffa,complicada kk. Eu peguei o spell maker e tentei fazer a spell, ela até funciona só que fica dando erro na distro (condition not found. Amaterasu
  22. ola poderiam me ajudar numa coisa, então eu estava la adicionando um poke shiny no meu poketibia, e eu estava configurando e coloquei meu shiny venusaur para evoluir com 7 shiny stone, blz ate ai quando abri o serve e fui testa não esteva evoluindo com 7 shiny stone e sim com 2 shiny stone, voutei la e vi se não tinha posto errado o numero, mais não eu não coloquei o numero errado estava 7 ai eu resolvi colocar outro numero e mesmo assim não foi aguem ai pode me ajudar aki esta um link com o meu configutarion.lua pra vcs darem uma olhada link http://www.mediafire.com/file/64zvzlcno68m8o4/configuration.lua scan https://www.virustotal.com/#/url/724e009137b12f44ca7f9ff6acb04f668fb44b13c82bd9c4f64bf041e6576ed5/detection tam bem terá saguns print pra vcs verem
  23. Ola Xtibianos precisava de um npc que fale com um char de cada vez. Ex1: char nr1 fala hi NPC fala hi Ex2: char nr2 fala hi NPC fala calma estou ocupado no momento Versão 8.6 Tfs 0.4
  24. Olá pessoal do xtibia, tudo bem? sou novo nisso e necessito de ajuda ;/ nem sei se é o lugar certo do topico se nao for por favor já peço desculpas e mova pra area correta. lembrando que nao estou divulgando. já tem um script assim no forum eu so quero aprimorar porém nao tenho conhecimento se puder ajudar sem julgar agradeço. No escript a seguir ele realiza a seguinte função = ara a terra planta rega colhe corta ----- segue o script function onUse(cid, item, frompos, item2, topos, pos) if item.itemid == 2552 and item2.itemid == 103 then doSendMagicEffect(getThingPos(item2.uid), 2) doTransformItem(item2.uid, 806, 1) doPlayerSendTextMessage(cid, 27, ". Você Preparou a Terra, Agora Plante a Semente .") return true elseif item.itemid == 2147 and item2.itemid == 806 then doSendMagicEffect(getThingPos(item2.uid), 45) doTransformItem(item2.uid, 804, 1) doPlayerRemoveItem(cid, 2147, 1) doPlayerSendTextMessage(cid, 27, ". Você Plantou a Semente, Agora Jogue Um Pouco de Água .") return true elseif item.itemid == 7734 and item2.itemid == 804 then doSendMagicEffect(getThingPos(item2.uid), 53) doCreateItem(2785, 1, getThingPos(item2.uid)) doPlayerSendTextMessage(cid, 27, ". A Planta Cresceu, Colha Os Frutos e Depois à Corte Para Plantar Novamente .") return true elseif item.itemid == 2552 and item2.itemid == 2786 then doSendMagicEffect(getThingPos(item2.uid), 34) doTransformItem(item2.uid, 103, 1) doPlayerSendTextMessage(cid, 27, ". Você Cortou a Árvore Sem Frutos, Parabéns .") return true elseif item.itemid == 2552 and item2.itemid == 806 then doSendMagicEffect(getThingPos(item2.uid), 2) doTransformItem(item2.uid, 103, 1) return true elseif item.itemid == 2552 and item2.itemid == 804 then doSendMagicEffect(getThingPos(item2.uid), 2) doTransformItem(item2.uid, 103, 1) return true end end ----- Eu queria o sequinte.... que ele arasse a terra, plantasse o item, porém quando plantar ele teria um tempo determinado pra que a planta cresça. ex:: eu queria usar a semente [id 7732] quando usar a semente e na terra 804 ela iria virar o inicio da planta que é [id 2781] depois do primeiro estágio que é o inicio [id 2781] ela vai para o segundo estágio [id 5471] e quando ela crescer por completo ela fica no estágio [id 5466] por final quando ela ficar pronta no [id 5466] queria a ação de clicar com o botão direito do mouse pra poder colher e na hora que colher viesse um item EXemplo [id 2328] e ai sim poder cortar a planta colhida pra que possa começar tudo novamente. agradeço a compreensão de todos sse puder ajudar fico muito grato !!!!
  25. Boa noite galera, Gostaria pedir a ajuda de vocês para extrair essas sprites sem elas ficarem rosas... Pode ser algum tipo de criptografia, mas deve ter algum jeito para poder usá-las. Já tentei abrir no modo extendida, mas da erro no meu spr editor. Se alguém ajudar, agradeço demaaaaaaaaaaaais ! Link: https://www.4shared.com/rar/lbunaZ4nca/spritesnaka.html? Scan: https://www.virustotal.com/pt/file/1476c2ff652b1bcff6125a1dd07f25a371361c20038c99e2dade506724518dfb/analysis/1512261685/
×
×
  • Create New...