Ir para conteúdo
  • Cadastre-se
  • 0

erro no site (pvp/pk)


renan68

Pergunta

boa tarde , estou com um problema aqui no site, preciso adptar para l2jdream o site na parte do ranking

 

este eh o erro

Unknown column 'accesslevel' in 'where clause'

 

 

esta eh a pagina do pk

 

<?php
require("config.php");
include('anti_inject.php');
?>
<link rel="stylesheet" href="css/template.css" type="text/css">
<link rel="stylesheet" href="css/typo.css" type="text/css">
<style type="text/css">
<!--
.style5 {
font-size: 11px;
font-family: Arial, Helvetica, sans-serif;
font-weight: bold;
background-color: #FFFFFF;
}
.style8 {
font-size: 11px;
font-family: Arial, Helvetica, sans-serif;
}

.pvptop {

color: #CC3300;
text-decoration: blink;
font-weight: bolder;
text-align: right;
}
.style9 {font-family: Tahoma}
.style10 {color: #FFFFFF;}
.style11 {font-size: 9px}
.style12 {
font-weight: bold;
font-size: 8px;
}
.titulo {
text-align: center;
color: #FFF;
font-size: 18px;
}
-->
</style>
<body oncontextmenu='return false' onselectstart='return false' ondragstart='return false'>
<p>
<?php
mysql_connect($MySQL['servidor'], $MySQL['usuario'], $MySQL['senha']) or die ("Nao foi possivel se conectar ao Banco de Dados.");
mysql_select_db($MySQL['banco']) or die ("Banco de Dados Nao Existe.");

$ordem = empty($_GET['o']) ? 'pkkills' : base64_decode($_GET['o']);
$sql = mysql_query("SELECT * FROM ".$MySQL['banco_l2'].".characters WHERE accesslevel = 0 ORDER BY ".$ordem." DESC LIMIT 25") or die(mysql_error());
$array = array('pvpkills' => 'TOP 10 PK', ); ?>
</p>
<p class="titulo">TOP PK </p>
<table width="500" border="0" align="center" bordercolor="#EBEBEB">
<?php
$i = 1;
$cor = 0;
while($a = mysql_fetch_object($sql)) {
$cor++;
$bg = ($cor % 2 == 0) ? '' : '';
switch ($i)
{
case 1: $img = "<img src=\"images/1.gif\" alt=\"1º Lugar\">"; break;
case 2: $img = "<img src=\"images/2.gif\" alt=\"2º Lugar\">"; break;
case 3: $img = "<img src=\"images/3.gif\" alt=\"3º Lugar\">"; break;
case 4: $img = "<img src=\"images/4.gif\" alt=\"4º Lugar\">"; break;
default: $img = "[".$i."#]"; break;
}
?>
<tr bordercolor="<?php echo $bg; ?>" bgcolor="<?php echo $bg; ?>" class="style8">
<td width="24%"><div align="center" ><span class="style10"><?php echo $img; ?></span></div></td>
<td width="52%"><div align="center" ><span class="style10"><font class="style1"><?php echo $a->char_name; ?></font></span></div></td>
<td width="24%"><div align="center" ><span class="pvptop"><?php echo $a->$ordem; ?></span></div></td>
<?php
$i++;
}
?>
</table>
</body>

Link para o comentário
Compartilhar em outros sites

1 resposta a esta questão

Posts recomendados


Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Visitante
Responder esta pergunta...

×   Você colou conteúdo com formatação.   Remover formatação

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Processando...




×
×
  • Criar Novo...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.