Sobre o Ranks.php va no seu ranks.php e subistitua por esse aki
<?php/*
Copyright © 2007 - 2008 Nicaw
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
*/
include ("include.inc.php");
$ptitle="Highscores - $cfg[server_name]";
include ("header.inc.php");
$SQL = new SQL();
?>
<div id="content">
<div class="top">Recordes</div>
<div class="mid">
<select name="sort" onchange="self.location.href=this.value">
<?php
if (empty($_GET['sort'])) $_GET['sort'] = 'level';
$options = array_merge(array('level', 'maglevel'), $cfg['skill_names']);
foreach ($options as $skill){
if ($skill == $_GET['sort'])
$selected = ' selected="selected"';
else
$selected = '';
echo '<option value="ranks.php?sort='.$skill.'"'.$selected.'>'.ucfirst($skill).'</option>';
}
echo '</select>';
if (!isset($_GET['page']) || $_GET['page'] < 0) $p = 0;
else $p = (int) $_GET['page'];
if ($_GET['sort'] == 'level' || $_GET['sort'] == 'maglevel'){
$query = 'SELECT groups.access, groups.id, players.name, players.level, players.maglevel, players.experience FROM players LEFT OUTER JOIN groups ON players.group_id = groups.id ORDER BY `'.mysql_escape_string($_GET['sort']).'` DESC LIMIT '.$cfg['ranks_per_page']*$p.', '.$cfg['ranks_per_page'].';';
$key = $_GET['sort'];
}elseif (in_array($_GET['sort'],$cfg['skill_names'])){
$query = 'SELECT groups.access, a1.* FROM (SELECT players.group_id, players.name, player_skills.value FROM players, player_skills WHERE players.id = player_skills.player_id AND player_skills.skillid = '.array_search($_GET['sort'], $cfg['skill_names']) .') AS a1 LEFT OUTER JOIN groups ON a1.group_id = groups.id ORDER BY `value` DESC LIMIT '.$cfg['ranks_per_page']*$p.', '.$cfg['ranks_per_page'].';';
$key = 'value';
}elseif ($_GET['sort'] == 'census'){
$SQL->myQuery('SELECT players.sex, COUNT(players.id) as number FROM `players` GROUP BY players.sex');
$total = 0;
while ($a = $SQL->fetch_array()){
$genders[$a['sex']] = $a['number'];
$total += $a['number'];
}
$gender_names = array(0 => 'Female',1 => 'Male');
echo '<p><h2>Gender</h2>';
echo '<table style="font-weight: bold">';
foreach (array_keys($genders) as $gender)
echo '<tr><td>'.$gender_names[$gender].'</td><td>'.percent_bar($genders[$gender],$total).'</td><td>('.$genders[$gender].')</td></tr>';
echo '</table></p>';
$SQL->myQuery('SELECT players.vocation, COUNT(players.id) as number FROM `players` GROUP BY players.vocation');
$total = 0;
while ($a = $SQL->fetch_array()){
$vocations[$a['vocation']] = $a['number'];
$total += $a['number'];
}
echo '<p><h2>Vocations</h2>';
echo '<table style="font-weight: bold">';
foreach (array_keys($vocations) as $vocation)
echo '<tr><td>'.$cfg['vocations'][$vocation]['name'].'</td><td>'.percent_bar($vocations[$vocation],$total).'</td><td>('.$vocations[$vocation].')</td></tr>';
echo '</table></p>';
}else{$error = "Invalid sort argument";}
if (isset($query)){
?>
<input type="button" value="<<" onclick="self.window.location.href='ranks.php?sort=<?php echo urlencode($_GET['sort'])?>&page=<?php echo $p-1?>'"/>
<b>Statistics page: <?php echo $p+1?></b>
<input type="button" value=">>" onclick="self.window.location.href='ranks.php?sort=<?php echo urlencode($_GET['sort'])?>&page=<?php echo $p+1?>'"/>
<table>
<tr class="color0"><td style="width:30px">#</td><td style="width:150px"><b>Nome</b></td><td style="width:60px"><b><?php echo htmlspecialchars(ucfirst($_GET['sort']))?></b></td></tr>
<?php
$SQL->myQuery($query);
if ($SQL->failed())
throw new Exception('SQL query failed:<br/>'.$SQL->getError());
else{
$i = $cfg['ranks_per_page']*$p;
while($a = $SQL->fetch_array())
if ($a['access'] < $cfg['ranks_access'])
{
$i++;
echo '<tr '.getStyle($i).'><td>'.$i.'</td><td><a href="characters.php?player_name='.urlencode($a['name']).'">'.htmlspecialchars($a['name']).'</a></td><td>'.$a[$key].'</td></tr>'."\n";
}
}
}
?>
</table>
</div>
<div class="bot">
<?php include ("footer.inc.php");?>
e dps vai na pasta class em sql.php e troca por este
<?php/*
Copyright © 2007 - 2008 Nicaw
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
*/
class SQL{
private $last_query, $last_error, $connection;
public function __construct(){
$this->_init();
}
//creates new connection
protected function _init(){
global $cfg;
if (!isset($this->connection)){
$con = @mysql_connect($cfg['SQL_Server'],$cfg['SQL_User'],$cfg['SQL_Password']);
if ($con === false){
throw new Exception('Unable to connect to mysql server. Please make sure it is up and running and you have correct user/password in config.inc.php.');
return false;
}
if (!@mysql_select_db($cfg['SQL_Database'])){
throw new Exception('Unable to select databse: '.$cfg['SQL_Database'].'. Make sure it exists.');
return false;
}
$this->connection = $con;
}
return true;
}
//Creates tables
public function setup(){
$tables = explode(';', @file_get_contents('database.sql'));
foreach ($tables as $table) mysql_query($table);
}
//Perform simple SQL query
public function myQuery($q){
$this->last_query = @mysql_query($q);
if ($this->last_query === false){
$this->last_error = 'Error #'.mysql_errno()."\n".$q."\n" . mysql_error() . "\n";
$analysis = $this->analyze();
if ($analysis !== false)
throw new Exception($analysis."\n".$this->last_error);
}
return $this->last_query;
}
//True is last query failed
public function failed(){
if ($this->last_query === false) return true;
return false;
}
//Returns current array with data values
public function fetch_array() {
if (!$this->failed())
if (isset($this->last_query))
return mysql_fetch_array($this->last_query);
else
throw new ClassException('Attempt to fetch failed query.');
}
//Returns the last insert id
public function insert_id(){
return mysql_insert_id();
}
//Returns the number of rows affected
public function num_rows()
{
if (!$this->failed())
return mysql_num_rows($this->last_query);
else
throw new Exception('Attempt to count failed query'."\n".$this->last_error);
}
//Quotes a string
public function escape_string($string)
{
return mysql_real_escape_string($string);
}
//Quotes a value so it's safe to use in SQL statement
public function quote($value)
{
if(is_numeric($value))
return (int) $value;
else
return '\''.$this->escape_string($value).'\'';
}
//Return last error
public function getError()
{
return $this->last_error;
}
public function analyze()
{
$result = @mysql_query('SHOW TABLES');
if ($result === false) return false;
while ($a = mysql_fetch_array($result))
$t[] = $a[0];
$is_aac_db = in_array('nicaw_accounts',$t);
$is_server_db = in_array('accounts',$t) && in_array('players',$t);
$is_svn = in_array('player_depotitems',$t) && in_array('groups',$t);
$is_cvs = in_array('playerstorage',$t) && in_array('skills',$t);
if (!$is_aac_db){
$this->setup();
return 'Notice: AutoSetup has attempted to create missing tables for you. This message should not repeat.';
}elseif (!$is_server_db){
return 'It appears you don\'t have SQL sample imported for OT server or it is not supported';
}elseif ($is_cvs && !$is_svn){
return 'This AAC version does not support your server. Consider using SQL v1.5';
}return false;
}
public function repairTables()
{
$result = mysql_query('SHOW TABLES');
while ($a = mysql_fetch_array($result))
$tables[] = $a[0];
if (isset($tables))
foreach($tables as $table)
mysql_query('REPAIR TABLE '.$table);
return $return;
}
######################################
# Methods for simple data access #
######################################
//Insert data
public function myInsert($table,$data)
{global $cfg;
$fields = array_keys($data);
$values = array_values($data);
$query = 'INSERT INTO `'.mysql_escape_string($table).'` (';
foreach ($fields as $field)
$query.= '`'.mysql_escape_string($field).'`,';
$query = substr($query, 0, strlen($query)-1);
$query.= ') VALUES (';
foreach ($values as $value)
if ($value === null)
$query.= 'NULL,';
else
$query.= $this->quote($value).',';
$query = substr($query, 0, strlen($query)-1);
$query.= ');';
if ($this->myQuery($query) === false)
return false;
else
return true;
}
//Replace data
public function myReplace($table,$data)
{global $cfg;
$fields = array_keys($data);
$values = array_values($data);
$query = 'REPLACE INTO `'.mysql_escape_string($table).'` (';
foreach ($fields as $field)
$query.= '`'.mysql_escape_string($field).'`,';
$query = substr($query, 0, strlen($query)-1);
$query.= ') VALUES (';
foreach ($values as $value)
if ($value === null)
$query.= 'NULL,';
else
$query.= $this->quote($value).',';
$query = substr($query, 0, strlen($query)-1);
$query.= ');';
if ($this->myQuery($query) === false)
return false;
else
return true;
}
//Retrieve single row
public function myRetrieve($table,$data)
{
$fields = array_keys($data);
$values = array_values($data);
$query = 'SELECT * FROM `'.mysql_escape_string($table).'` WHERE (';
for ($i = 0; $i < count($fields); $i++)
$query.= '`'.mysql_escape_string($fields[$i]).'` = '.$this->quote($values[$i]).' AND ';
$query = substr($query, 0, strlen($query)-4);
$query.=');';
$this->myQuery($query);
if ($this->failed()) return false;
if ($this->num_rows() <= 0) return false;
if ($this->num_rows() > 1) throw new Exception('Unexpected SQL answer. More than one item exists.');
return $this->fetch_array();
}
//Update data
public function myUpdate($table,$data,$where,$limit=1)
{
$fields = array_keys($data);
$values = array_values($data);
$query = 'UPDATE `'.mysql_escape_string($table).'` SET ';
for ($i = 0; $i < count($fields); $i++)
$query.= '`'.mysql_escape_string($fields[$i]).'` = '.$this->quote($values[$i]).', ';
$query = substr($query, 0, strlen($query)-2);
$query.=' WHERE (';
$fields = array_keys($where);
$values = array_values($where);
for ($i = 0; $i < count($fields); $i++)
$query.= '`'.mysql_escape_string($fields[$i]).'` = '.$this->quote($values[$i]).' AND ';
$query = substr($query, 0, strlen($query)-4);
if (isset($limit))
$query.=') LIMIT '.$limit.';';
else
$query.=');';
$this->myQuery($query);
if ($this->failed()) return false;
return true;
}
//Delete data
public function myDelete($table,$data,$limit = 1)
{
$fields = array_keys($data);
$values = array_values($data);
$query = 'DELETE FROM `'.mysql_escape_string($table).'` WHERE (';
for ($i = 0; $i < count($fields); $i++)
$query.= '`'.mysql_escape_string($fields[$i]).'` = '.$this->quote($values[$i]).' AND ';
$query = substr($query, 0, strlen($query)-4);
if ($limit > 0)
$query.=') LIMIT '.$limit.';';
else
$query.=');';
$this->myQuery($query);
if ($this->failed()) return false;
return true;
}
}
?>
ve se vai da certo aew 
info
Grupo: Campones
Registrado: 13/12/11
Posts: 34
Reputação: +1
Gênero: Masculino
Char no Tibia: Lord Of The Chaos
vei tem como vc min ajudar eu to com esses erros quando criar conta
quando eu entro no site e clico em records da erro tambem guilds e tals da erro no xampp veio como faço para tirar esses erros:
alguem min ajuda ai por favor espero respostas
Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\ranks.php on line 47
Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\class\sql.php on line 199
Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\class\sql.php on line 201
Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\class\sql.php on line 199
Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\class\sql.php on line 201