dúvida [erro] website dbo

[Master68 1]

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

[Junior001 362]

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

[Master68 1]

rep++++ vlws vei tu é o cara

[Junior001 362]

Fico Feliz em ajudar

Duvida sanada reportado para que mova !

[Master68 1]

ei manow quando eu crio a conta da esse erro tb

 

 

Error #1048

INSERT INTO `nicaw_account_logs` (id, ip, account_id, date, action) VALUES(NULL, INET_ATON('::1'), 1, UNIX_TIMESTAMP(NOW()), 'Created character: Dende')

Column 'ip' cannot be null

 

account.php on line: 129

Script was terminated because something unexpected happened. You can report this, if you think it's a bug.

[Junior001 362]

quando cria conta ou character ??

[Roksas 846]

Tópico movido para a seção de dúvidas e pedidos resolvidos.

[luaneflavia82 0]

vei fis tudo que se mando mais nao consegui n ai entra no meu site ai dbko.sytes.net

[cimmeria 0]

I have the same problem and I do not solve that

 

 

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\site\class\sql.php on line 199

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\site\class\sql.php on line 201

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\site\class\sql.php on line 199

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\site\class\sql.php on line 201

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\site\class\sql.php on line 199

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\site\class\sql.php on line 201

---

Nome: adam Level: 174 Ki Level: 105 Vocation: Goku Sexo: Male Residencia: DBHO City Entrou em: 11th October 2017 02:03:52

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\site\class\sql.php on line 199

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\site\class\sql.php on line 201

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\site\class\sql.php on line 199

Deprecated: mysql_escape_string(): This function is deprecated; use mysql_real_escape_string() instead. in C:\xampp\htdocs\site\class\sql.php on line 201