ERRO AO TENTAR VER AS INFORMACOES DOS CHARS NO SITE

[feelipeeleite 0]

Ola quando eu clico no nome do Char no rank vai para uma pagina em branco, e a mesma coisa acontece quando tento ver a lista de banidos,

 

os links sao esses aqui:

 

http://baiakiller.servegame.com/index.php?subtopic=bans

 

http://baiakiller.servegame.com/index.php?subtopic=characters&name=Corvo (neste caso eh para ver o char Corvo)

 

Descobri que o mesmo o corre quado tento criar char pelo site 

http://baiakiller.com/index.php?subtopic=accountmanagement&action=createcharacter

Editado Dezembro 28, 2014 por feelipeeleite (veja o histórico de edições)

[seila2 1]

Amigão seguinte tenta editar os arquivos bans.php e characters.php que geralmente ficam em C:\xampp\htdocs

 

Lembrando de realizar backup de seus arquivos. 

 

bans.php

 

$ban_types = array(1 => 'IP Banishment', 2 => 'Namelock', 3 => 'Account Banishment', 4 => 'Notation', 5 => 'Until Deletion');

$ban_reason = array("Offensive Name", "Invalid Name Format", "Unsuitable Name", "Name Inciting Rule Violation", "Offensive Statement", "Spamming", "Illegal Advertising", "Off-Topic Public Statement", "Non-English Public Statement", "Inciting Rule Violation", "Bug Abuse", "Game Weakness Abuse", "Using Unofficial Software to Play", "Hacking", "Multi-Clienting", "Account Trading or Sharing", "Threatening Gamemaster", "Pretending to Have Influence on Rule Enforcer", "False Report to Gamemaster", "Destructive Behaviour", "Excessive Unjustified Player Killing", "Invalid Payment", "Spoiling Auction");
$players_banned = $SQL->query('SELECT `bans`.`type`, `bans`.`value`, `bans`.`comment`,`bans`.`admin_id`, `bans`.`expires`, `bans`.`added`, `bans`.`reason` FROM `bans`, `players` WHERE `players`.`account_id` = `bans`.`value` AND `bans`.`active` = 1 GROUP BY `bans`.`value` ORDER BY `bans`.`added` DESC')->fetchAll();
if(!$players_banned) {
$main_content .= '   Ninguem foi banido ainda...

';
} else{
$number_of_players = 0;
foreach($players_banned as $player) {
$nick = $SQL->query("SELECT name, id, level, account_id FROM `players` WHERE account_id =".$player['value']." ORDER BY level DESC LIMIT 1")->fetch();
$gmnick = $SQL->query("SELECT name, id FROM `players` WHERE id =".$player['admin_id']."")->fetch();

if($player['admin_id'] >= "1")
$banby = "".$gmnick['name']."";
else
$banby = "FunOT System";

$number_of_players++;

if(is_int($number_of_players / 2))
$bgcolor = $config['site']['darkborder'];
else
$bgcolor = $config['site']['lightborder'];

if ($player['expires'] == "-1") // If the banishment is permanent
$expires = "Permament";
else
$expires = date("d/m/Y, G:i:s", $player['expires']);


$players_rows .= ''.$nick['name'].''.$ban_reason[$player['reason']].''.$player['comment'].''.$banby.''.$expires.'';
}
//list of players
$main_content .= ''.$players_rows.'

Banned Player Reason Comment Banned By Expires

';
}
//COPY RIGHTS!! DO NOT DELETE!
$main_content .= '';
?>

 

Do Characters faça o download pois está dando problemas de formatação!!

 

Scan: https://www.virustotal.com/pt/file/9fa7ab12ab3287a838174da24e8449755a4c0572fe137804deb6697dd43c5269/analysis/1419815040/

Download: http://www.4shared.com/rar/yEOidVoIba/characters.html?

 

Espero ter ajudado.

 

[feelipeeleite 0]

Amigo o Character continuou a msm coisa o ban funcionou parece, mas em cima do site aparece essa mensagem :

 

 

$ban_types = array(1 => 'IP Banishment', 2 => 'Namelock', 3 => 'Account Banishment', 4 => 'Notation', 5 => 'Until Deletion'); $ban_reason = array("Offensive Name", "Invalid Name Format", "Unsuitable Name", "Name Inciting Rule Violation", "Offensive Statement", "Spamming", "Illegal Advertising", "Off-Topic Public Statement", "Non-English Public Statement", "Inciting Rule Violation", "Bug Abuse", "Game Weakness Abuse", "Using Unofficial Software to Play", "Hacking", "Multi-Clienting", "Account Trading or Sharing", "Threatening Gamemaster", "Pretending to Have Influence on Rule Enforcer", "False Report to Gamemaster", "Destructive Behaviour", "Excessive Unjustified Player Killing", "Invalid Payment", "Spoiling Auction"); $players_banned = $SQL->query('SELECT `bans`.`type`, `bans`.`value`, `bans`.`comment`,`bans`.`admin_id`, `bans`.`expires`, `bans`.`added`, `bans`.`reason` FROM `bans`, `players` WHERE `players`.`account_id` = `bans`.`value` AND `bans`.`active` = 1 GROUP BY `bans`.`value` ORDER BY `bans`.`added` DESC')->fetchAll(); if(!$players_banned) { $main_content .= ' Ninguem foi banido ainda... '; } else{ $number_of_players = 0; foreach($players_banned as $player) { $nick = $SQL->query("SELECT name, id, level, account_id FROM `players` WHERE account_id =".$player['value']." ORDER BY level DESC LIMIT 1")->fetch(); $gmnick = $SQL->query("SELECT name, id FROM `players` WHERE id =.$player['admin_id]."")->fetch(); if($player['admin_id'] >= "1") $banby = "".$gmnick['name'].""; else $banby = "FunOT System"; $number_of_players++; if(is_int($number_of_players / 2)) $bgcolor = $config['site']['darkborder']; else $bgcolor = $config['site']['lightborder']; if ($player['expires'] == "-1") // If the banishment is permanent $expires = "Permament"; else $expires = date("d/m/Y, G:i:s", $player['expires']); $players_rows .= ''.$nick['name'].''.$ban_reason[$player['reason']].''.$player['comment'].''.$banby.''.$expires.''; } //list of players $main_content .= ''.$players_rows.' Banned Player Reason Comment Banned By Expires '; } //COPY RIGHTS!! DO NOT DELETE! $main_content .= ''; ?>

 

 

link : http://baiakiller.com/index.php?subtopic=bans

 

 

[Victor Fasano Raful 156]

Cara, você pode por gentileza postar aqui quais são as colunas existentes em sua database existentes em players. E sequentemente postar os arquivos para eu tentar solucionar este erro...

 

 

O bans é só voce executar este comando no banco de dados, é provavel que falte isto.

ALTER TABLE  `bans` ADD  `reason` VARCHAR( 20 ) NOT NULL AFTER  `comment` ;