godthunder

8.1 Novo Otserver 8.12 Test Server, Com Scan!

tópico respondeu ao rubinhobarrichelo de godthunder em Lixeira Pública

qui mané todos os update anuciada ... isso ai nem tem sistema de npcs e outras coisas q eu n verifiquei vc botou algum kl ai q eu tou ligadooo. NÃO RECOMENDO!!

8.1 Novo Otserver 8.12 Test Server, Com Scan!

tópico respondeu ao rubinhobarrichelo de godthunder em Lixeira Pública

q sacanagem é essa? o update nem saiu e jah tem otserv? quero só ver esse systema do npc se ta bom msm

8.1 [8.11] The Forgotten Server Com Pet System + Magias Novas + Map Editado + Blacksmith + Tudo De Bom!

tópico respondeu ao Mesenga de godthunder em Lixeira Pública

ai kra ta muito perfeito mandou bemmm recomendo vlw!

Junho 28, 2008
179 respostas
- otserv
- tibia
- (e 1 mais)
  Tags:
  - otserv
  - tibia
  - script

Deletando Chars Inativos Sql/xml

um tópico no fórum postou godthunder Tutoriais de Websites

Codigo Bem util para servidores serios =] Codigo do PHP: <? $self = basename($_SERVER['PHP_SELF']); ?> <html><title>Character Deletion!</title> <body> <form name="form" method="POST" action="<? echo $self; ?>"> Configurations <input name="source" type="radio" value="XML"> XML (mark this if you use xml, and leave all sql configuration blank!) <input name="source" type="radio" value="SQL"> SQL (mark this if you use sql) SQL Part Host: <input name="host" type="text" id="host" value="" size="15"> User: <input name="user" type="text" id="user" value="" size="15"> Pass: <input name="pass" type="password" value="" id="pass" size="15"> Data: <input name="data" type="text" id="data" value="" size="15"> (name of your database) Script Config Days: <input name="days" type="text" id="days" value="" size="2"><input name="never" type="radio" value="0"> (Select if you just want to delete never loggedin players) Delete player with level below: <input name="level" type="text" id="level" value="" size="2"> (You can leave it blank if you don't want to use this feature) <input type="submit" value="Submit"> </form> <?php include('config.php'); $source = $_POST['source']; $host = $_POST['host']; $user = $_POST['user']; $pass = $_POST['pass']; $data = $_POST['data']; $level = $_POST['level']; $days = $_POST['days']; $dels = $_POST['never']; $dir = $pasta.'players/'; $xmlfile = $dir.'players.xml'; if($dels == NULL && $days != NULL){ $manydays = $days * 86400; $time = time() - $manydays; }elseif($dels == '0' && $days == NULL){ $time = $dels; } elseif($dels == NULL && $days == NULL){ $time = -1; } if($days != NULL or $dels != NULL or $level != NULL){ $x = 0; $y = 0; $z = 0; if($source == "SQL" && $pass != NULL){ mysql_connect($host,$user,$pass) or die("Unable to connect with the SQL Server!"); mysql_select_db($data) or die("Unable to select the SQL Database!"); $result = mysql_query("SELECT * FROM players"); while($player = mysql_fetch_object($result)){ if($level != NULL && $player->level < $level){ $sql_ = "SELECT * FROM players WHERE account='$player->account'"; $res = mysql_query($sql_); $rows = mysql_fetch_object($res); $numrows = mysql_num_rows($res); if($numrows == '1'){ $_sql = mysql_query("DELETE FROM accounts WHERE accno='$player->account'"); $y++; } $delplayer = mysql_query("DELETE FROM players WHERE name='$player->name'"); $delskills = mysql_query("DELETE FROM skills WHERE player='$player->id'"); $dellitems = mysql_query("DELETE FROM items WHERE player='$player->id'"); $z++; } if($player->lastlogin <= $time){ $sql_ = "SELECT * FROM players WHERE account='$player->account'"; $res = mysql_query($sql_); $rows = mysql_fetch_object($res); $numrows = mysql_num_rows($res); if($numrows == '1'){ $_sql = mysql_query("DELETE FROM accounts WHERE accno='$player->account'"); $y++; } $delplayer = mysql_query("DELETE FROM players WHERE name='$player->name'"); $delskills = mysql_query("DELETE FROM skills WHERE player='$player->id'"); $dellitems = mysql_query("DELETE FROM items WHERE player='$player->id'"); $x++; } } print($x.' players were deleted '); print($y.' accounts were deleted '); if($z != NULL){ print($z.' players were deleted because of low level '); } } elseif($source == "XML" && $pass == NULL){ if ($dh = opendir($dir)) { while (($file = readdir($dh)) !== false) { $path_parts = pathinfo($file); if(filetype($dir . $file) == 'file' && $file != 'players.xml' && $path_parts['extension'] == 'xml'){ $playersxml = file_get_contents($xmlfile); $player = file_get_contents($dir.$file); $xml = simplexml_load_string($player); $accgetcont = file_get_contents($pasta."accounts/".$xml['account'].".xml"); if(isset($level) && isset($time)){ if($xml['lastlogin'] <= $time && $xml['level'] < $level){ $str_replace = str_replace('<player guid="'.$xml['id'].'" name="'.$xml['name'].'"/>','', $playersxml); $replace_acc = str_replace('<character name="'.$xml['name'].'"/>','', $accgetcont); $fopen = fopen($xmlfile,"w+"); $fwrite = fwrite($fopen,$str_replace); $fopen = fopen($pasta."accounts/".$xml['account'].".xml","w+"); $fwrite = fwrite($fopen,$replace_acc); if(unlink($dir . $file)){ $x++; } } }else{ if($xml['lastlogin'] <= $time){ $str_replace = str_replace('<player guid="'.$xml['id'].'" name="'.$xml['name'].'"/>','', $playersxml); $replace_acc = str_replace('<character name="'.$xml['name'].'"/>','', $accgetcont); $fopen = fopen($xmlfile,"w+"); $fwrite = fwrite($fopen,$str_replace); $fopen = fopen($pasta."accounts/".$xml['account'].".xml","w+"); $fwrite = fwrite($fopen,$replace_acc); if(unlink($dir . $file)){ $x++; } } elseif($level != NULL && $xml['level'] < $level){ $str_replace = str_replace('<player guid="'.$xml['id'].'" name="'.$xml['name'].'"/>','', $playersxml); $replace_acc = str_replace('<character name="'.$xml['name'].'"/>','', $accgetcont); $fopen = fopen($xmlfile,"w+"); $fwrite = fwrite($fopen,$str_replace); $fopen = fopen($pasta."accounts/".$xml['account'].".xml","w+"); $fwrite = fwrite($fopen,$replace_acc); if(unlink($dir . $xml['name'] . ".xml")){ $z++; } } } } } print($x+$z.' players were deleted '); if($z != NULL){ print($z.' of them because of low level '); } } } } ?> Adicionar no Config.php $pasta = "C:/whatever/data/"; Espero ter ajudado