Search the Community

Alguem poderia me ajudar com esse simples problema, de alinhar o botão fechar no pop de promoção.. no momento tá assim como poderia deixar centralizado no meio? codigo da promo que está no lastnews.php <div id="LayerPop" style="display:block; position:center; left:20px; top:-400; background-color:#1e1e22; width:100%; height:150%; z-index:50;margin:0px;opacity:0;"></div> <div id="LayerPop2" style="position: absolute; left: 50; top: -400px; z-index: 5000;"><a href="?subtopic=donate" target="_BLANK"><img src="images/promo.png" class="imgBorder"></a><br><a href="javascript:void();" onClick="document.getElementById('LayerPop').style.display = 'none';document.getElementById('LayerPop2').style.display = 'none'"> <b>Fechar</b></a></div>

To com um problema de criar char no meu gesior sempre dando esse erro, vi em outros foruns que seria melhor migrar pro mariadb, mas tem outra solução alem dessa? Error occured! Error ID: Cannot save ItemsList. Player ID not set.More info: File: /var/www/html/classes/itemslist.php Line: 67File: /var/www/html/classes/player.php Line: 87File: /var/www/html/pages/accountmanagement.php Line: 1952File: /var/www/html/system/load.page.php Line: 7File: /var/www/html/index.php Line: 37 Edit /[RESOLVIDO]/ : rodei o comando no sql da minha database SET GLOBAL sql_mode=''; by @movie e vie também o video : https://youtu.be/bRg68tttucQ para resolver. muito obrigado @movie

.Qual servidor ou website você utiliza como base? pokemon Qual o motivo deste tópico? tirar duvida Está surgindo algum erro? Se sim coloque-o aqui. Gostaria de saber se alguem consegue me ajuda a fazer o serve que eu baixei aki no site. Esse serve ele e com site. gostaria de jogar nele sem precisar abrir o site pois to tendo problema no xampp Você tem o código disponível? Se tiver publique-o aqui: Você tem alguma imagem que possa auxiliar no problema? Se sim, coloque-a aqui.

Esta página não está funcionando localhost não consegue atender a esta solicitação no momento. HTTP ERROR 500 estava tentado por um site de um ot online mas so aparece erro alguem pode me ajudar? esse codigo config.php # Account Maker Config $config['site']['C:\Users\nonato\Desktop\realmap-10x-master\realmap-10x-master\config.lua"; $config['site']['useServerConfigCache'] = false; $towns_list = array(1 => 'Venore', 2 => 'Thais', 3 => 'Kazordoon', 4 => 'Carlin', 5 => 'Ab/Dendriel', 6 => 'Rookgaard', 7 => 'Liberty Bay', 8 => 'Port Hope', 9 => 'Ankrahmun', 10 => 'Darashia', 11 => 'Edron', 12 => 'Svargrond', 13 => 'Yalahar', 14 => 'Farmine'); $config['site']['outfit_images_url'] = 'http://outfit-images.ots.me/outfit.php'; $config['site']['item_images_url'] = 'images/items/'; $config['site']['item_images_extension'] = '.gif'; $config['site']['flag_images_url'] = 'images'; $config['site']['flag_images_extension'] = '.png'; # Create Account Options $config['site']['one_email'] = false; $config['site']['create_account_verify_mail'] = false; $config['site']['verify_code'] = true; $config['site']['email_days_to_change'] = 3; $config['site']['newaccount_premdays'] = 7; $config['site']['send_register_email'] = false; # Create Character Options $config['site']['newchar_vocations'] = array(1 => 'Sorcerer Sample', 2 => 'Druid Sample', 3 => 'Paladin Sample', 4 => 'Knight Sample'); $config['site']['newchar_towns'] = array(2); $config['site']['max_players_per_account'] = 4; # Emails Config $config['site']['send_emails'] = true; $config['site']['mail_address'] = "no-reply@tibiaold.org"; $config['site']['smtp_enabled'] = true; $config['site']['smtp_host'] = "mail.tibiaold.org"; $config['site']['smtp_port'] = 25; $config['site']['smtp_auth'] = true; $config['site']['smtp_user'] = "no-reply@tibiaold.org"; $config['site']['smtp_pass'] = "]!uX?SNaQ%nn"; # PAGE: whoisonline.php $config['site']['private-servlist.com_server_id'] = 0; /* Server id on 'private-servlist.com' to show Players Online Chart (whoisonline.php page), set 0 to disable Chart feature. To use this feature you must register on 'private-servlist.com' and add your server. Format: number, 0 [disable] or higher */ # PAGE: characters.php $config['site']['quests'] = array(); $config['site']['show_skills_info'] = false; $config['site']['show_vip_storage'] = 0; # PAGE: accountmanagement.php $config['site']['send_mail_when_change_password'] = true; $config['site']['send_mail_when_generate_reckey'] = true; $config['site']['generate_new_reckey'] = true; $config['site']['generate_new_reckey_price'] = 20; # PAGE: guilds.php $config['site']['guild_need_level'] = 100; $config['site']['guild_need_pacc'] = false; $config['site']['guild_image_size_kb'] = 50; $config['site']['guild_description_chars_limit'] = 250; $config['site']['guild_description_lines_limit'] = 6; $config['site']['guild_motd_chars_limit'] = 250; # PAGE: adminpanel.php $config['site']['access_admin_panel'] = 555; # PAGE: latestnews.php $config['site']['news_limit'] = 6; # PAGE: killstatistics.php $config['site']['last_deaths_limit'] = 50; # PAGE: team.php $config['site']['groups_support'] = array(2, 3, 4, 5, 6); # PAGE: highscores.php $config['site']['groups_hidden'] = array(2, 3, 4); $config['site']['accounts_hidden'] = array(1); # PAGE: shopsystem.php $config['site']['shop_system'] = true; # PAGE: lostaccount.php $config['site']['email_lai_sec_interval'] = 180; # Layout Config $config['site']['layout'] = 'tibiarl'; $config['site']['vdarkborder'] = '#505050'; $config['site']['darkborder'] = '#D4C0A1'; $config['site']['lightborder'] = '#F1E0C6'; $config['site']['download_page'] = true; $config['site']['serverinfo_page'] = true;

Boa noite Poderiam me tirar uma pequena duvida, de como posso "resolver este problema", adicionei o system de pagseguro no meu gesior porém quando logo em uma conta o history fica bugado com uma cor roxa e invisivel e quando passo o mouse em cima ele volta a cor normal. como posso mudar isso? e também as linhas tao totalmente desalinhadas.. como posso arrumar isso? Print sem passar o mouse em cima Depois de passar o mouse em cima

Olá galera! queria saber aqui se vocês sabem como fazer a conexão com o banco de dados do mysql (XAMPP) via php corretamente, por exemplo se usarmos um gesior ou qualquer outro site, não é preciso mecher nas configurações do xampp para liberar acesso para outras máquinas ou algo do tipo, ele conecta perfeitamente, faz consultas nas tabelas, insere dados, atualiza e etc: aqui está um exemplo da minha conexão: assim funciona perfeitamente, mas se eu modificar o $hostname para o ip da minha máquina eu obtenho o seguinte erro: Warning: mysqli_connect() [function.mysqli-connect]: (HY000/2003): Can't connect to MySQL server on 'meu ip aqui' (10061) in C:\xampp\htdocs\poke\config\config.php on line 8Error!

Galera estou tentando utilizar um site de pokemon aqui pelo xampp mas me deparei com o seguinte erro: A Database Error Occurred Error Number: 1146 Table 'pokeruby.poll_answer' doesn't exist SELECT p.id, p.question, GROUP_CONCAT(a.answer SEPARATOR ';') AS answers, GROUP_CONCAT(a.id SEPARATOR ';') AS answers_id FROM poll p JOIN poll_answer a ON p.id = a.poll_id WHERE p.status = 1 AND date_start <= NOW() AND date_end >= NOW() Alguém ai tem o comando SQL para gerar essa tabela e suas colunas?

Bom dia pessoal. Estou com um problemão no meu servidor... Um cara me procurou esta semana e eu achei que fosse só falatório, o cara disse ter encontrado um problema grave no meu site, porém, não levei a sério... Ontem ele me mandou um print, ele estava logado na minha conta de GOD... Minha senha não é fácil, é quase um texto... Gostaria de saber de vocês, alguém mais tem este problema? Não sei mais o que fazer... Estou no desespero... O Cara está me cobrando $USD 50,00 pra resolver o problema... Tentei fazer um SQL Injection, mas não consegui, tentei todas as formas das quais conheço, porém, não consegui acesso em nenhum caso... Alguém consegue me ajudar com isso? Sabem se há alguma brecha de segurança conhecida para o Gesior 2012? Este desesperado fica no aguardo de uma bondosa alma pra ajudar hahaha Abraços.

Ola, instalei meu site do server na minha vps porem esta com esse erro Se alguém poder me ajuda, agradeço

DBNS.EU Do You love Dragon Ball and climate which is present in this anime? If You are Tibia supporter You couldn't have better situation! From perfect coppied Aliens World to game with awesome, anime plot and polished characters divide You just seconds! You only need register account: https://dbns.eu/?subtopic=download and download our client: https://dbns.eu/?subtopic=createaccount What we can offer? - game without P2W (all items from shop u can gain from game); - proffesional, experienced support; - innovativeness (Majority of our scripts are develop from basis); - settled, long game without many resets; - a lot of missions and sagas based on our beloved anime; - casino system; - autoloot system; - auction system; - thievery system; - skin system; -and much more! Then you are not convinced that you want to enter the server? See a few screenshots from our server!

Olá a todos! 😁 Falo espanhol e meu português é ruim XD Por isso vou escrever em inglês 💩 I'd like to contribute all the Open Tibia the community with this project I've been working on for a while: https://opentibia.io/ Basically it's a new alternative to publish your opentibia server or find your perfect fit with a very smart and simple search box. You can actually search things like "brazil pvp 8.6" I developed this site from scratch using some cool Bootstrap features and the Laravel PHP Framework. It's completely free and absolutely new (like there is just 1 OT published lol) but I hope it becomes a strong tool for every open tibia player and developer. Kind regards! Obrigado!!!

.Qual servidor ou website você utiliza como base? Myacc Qual o motivo deste tópico? problema na hora de logar no servidor, na hora que criar a conta no website ele ta criando assim, a senha sem estar codificada, ai quando se vai logar no otserv, ela nao entra, já tentei trocar no config.lua do ot de "Sha1'' para "plain" mais mesmo assim não da pra logar, estou usando a website Myacc Você tem alguma imagem que possa auxiliar no problema? Se sim, coloque-a aqui.

.Qual servidor ou website você utiliza como base? de um servidor que estava no meu pen drive e depois de anos tentei criar account e não consegui Qual o motivo deste tópico? Preciso de ajuda Está surgindo algum erro? Se sim coloque-o aqui. Você tem o código disponível? Se tiver publique-o aqui: <?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 = "adm.lucas88@gmail.com"; // SMTP username $mail->Password = "dohc2007"; // SMTP password $mail->From = "dont-reply@viking-server.com"; $mail->FromName = "Viking Server"; $mail->AddAddress($endereco, $nome); // name is optional $mail->AddReplyTo("dont-reply@viking-server.com", "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: suporte_vikingserver@hotmail.com</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 = "adm.lucas88@gmail.com"; // SMTP username $mail->Password = "dohc2007"; // SMTP password $mail->From = "dont-reply@viking-server.com"; $mail->FromName = "Viking Server"; $mail->AddAddress($endereco, $nome); // name is optional $mail->AddReplyTo("dont-reply@viking-server.com", "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: suporte_vikingserver@hotmail.com</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'); ?> Você tem alguma imagem que possa auxiliar no problema? Se sim, coloque-a aqui.

SALVE, Então, eu queria uma ajuda, quando eu adiciono essa script no meu site, ele da esses erros ai

Bom dia! Senhores tenho uma dúvida, já fucei por tudo e não encontrei, aonde possui um gesior com esse top level disponivel pra download? Pois já vi inumeros servidores com ele igual, inclusive alguns baiak com 10 players, então não creio que seja algo unico... E que a página characters.php seja assim:

Galera, meu site está configurado para a senha aparecer em sha1, gostaria de remover a encriptacao, como faco isso? (Direto no site, sem utilizar sites de 3 pra fazer isso...)

como eu adiciono uma aba de powergaming e que funciona no meu site do ot? pra mostrar quanto de exp a pessoa pegou

Eai pessoal, to fazendo aqui um layout pra um amigo .. o que acharam? LOGIN: ACCOUNT: RANK: FÓRUM: DONATE: Críticas plx!

Boa tarde galera do tk, então to aqui de novo apenas pra querer tirar uma duvida meio besta, tava querendo mudar a cor do layout do site para preto/cinza mas não encontro nada que possa modificar isso em ps no propio layout , no caso agora ele ta assim mas queria deixar ele black/cinza, só tinha visto no layout.ini que teria o layout "Demon" mas como posso mudar ele para black/cinza ou virse e versa. E também queria só saber como poderia alinhar o monster que fica acima do top players, ele é um gif e não no quadrado que era pra tá como poderia alinhar ele? no momento ele fica assim

Boa tarde galera do tk estou aqui novamente, gostaria de tirar uma duvida cuja é sobre website. Tenho um Website que peguei aqui do forum mesmo que estou usando como base para meu projeto, e nele tem o top 10 players etc.. E no caso era pro top 10 players os bonecos se movimentaram andando porém, não está acontecendo isso.. Tem um mesmo website aqui no fórum cujo este sistema de movimento funciona e como sou novo nisso gostaria de saber como implementa-lo no meu site. Link do site que gostaria de pegar os movimentos dos bonecos. como poderia colocar isso no meu website? pois no meu fica assim Não andam apenas ficam nessa posição travados, alguem poderia ajudar?

Boa bom dia galera do TK, bom hoje venho pedir a ajuda de voces pois to tendo um problema no website uso a tfs 0.4, sempre que coloco o site no htdocs e vou para o localhost para poder colocar a senha do adm etc.. fica dando esse erro e quando vou ver o que pode ser não encontro nada que possa ser o problema.. Não sei muito sobre isso, mas tento ne e.e ja tentei isso com varios gesior e esse é o 3 já que da esse erro.. uso o xamp 7.3.6.1 isso poderia ser problema do xampp ou do site em si? segue os arquivos com erro.. Bom não sei qual é o arquivo index que possa tá com problema pois tem varios.. configlua.php load.init.php

Boa noite pessoal estou com 1 problema se alguém poder me auxiliar ficarei muito grato. O erro e no gesior apos confirmar o envio de 1 item do shop para o jogador da este erro e o item chega para o personagem e não remove os pontos que teria que remover da account. segue o erro : Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '413' for key 'PRIMARY'' in C:\xampp\htdocs\shopsystem.php:506 Stack trace: #0 C:\xampp\htdocs\shopsystem.php(506): PDO->query('INSERT INTO `z_...') #1 C:\xampp\htdocs\index.php(402): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\shopsystem.php on line 506 a minha line 506 é esta $SQL->query($save_transaction); obs* uso o site perfeitamente com outro servidor este erro esta dando quando tentei utilizar o shopsystem em outro servidor de testes.

Ola ajuda ai galera por favor estou desisperadooo kkk seguinte quanto eu tava no unbutu 14.4 nao tinha esse bug ai tive de mudar pro 16.4 a apareceu esse bug eu debuguei o index.php pra ver o que pode ser mais eu n faço ideia nao entendo muito de website mais se alguem suber me ajudar ai pago a coca gesior utilizado: configuraççoes da vps Servidor: Localhost via UNIX socket Tipo de servidor: MySQL Versão do servidor: 5.7.26-0ubuntu0.16.04.1 - (Ubuntu) Versão do protocolo: 10 Utilizador: root@localhost Conjunto de caracteres do servidor: UTF-8 Unicode (utf8) Apache/2.4.18 (Ubuntu) Versão do cliente de base de dados: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ Extensão de PHP: mysqli versão do PHP: 5.6.40-8+ubuntu16.04.1+deb.sury.org+1

Alguem poderia me ajudar com esse erro, sempre que tento criar conta ele da erro.

Ola ajuda ai galera por favor estou desisperadooo kkk seguinte quanto eu tava no unbutu 14.4 nao tinha esse bug ai tive de mudar pro 16.4 a apareceu esse bug eu debuguei o index.php pra ver o que pode ser mais eu n faço ideia nao entendo muito de website mais se alguem suber me ajudar ai pago a coca gesior utilizado: configuraççoes da vps Servidor: Localhost via UNIX socket Tipo de servidor: MySQL Versão do servidor: 5.7.26-0ubuntu0.16.04.1 - (Ubuntu) Versão do protocolo: 10 Utilizador: root@localhost Conjunto de caracteres do servidor: UTF-8 Unicode (utf8) Apache/2.4.18 (Ubuntu) Versão do cliente de base de dados: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ Extensão de PHP: mysqli versão do PHP: 5.6.40-8+ubuntu16.04.1+deb.sury.org+1