Remover nick de GM dos rankings do site

**francis** · Agosto 25, 2012

Gostaria de saber como posso remover os nicks dos administradores/Gm's dos ranking's(top pk,top pvp,etc) do site.

Se alguem puder me responder desde jah eu agradeço!

Editado Agosto 25, 2012 por francis

**.::ADM::.Spankers** · Agosto 25, 2012

zera os pvps e pks dos adm e gm

**L2-Windows** · Agosto 25, 2012

olha se no seu Script de rank tem essa informação

O conteúdo está oculto, favor efetuar login ou se cadastrar!

**francis** · Agosto 25, 2012

zera os pvps e pks dos adm e gm

Estão zerados,mesmo assim aparecem!

olha se no seu Script de rank tem essa informação
WHERE accesslevel = '1'

coloque assim

WHERE accesslevel = '0'

Não tem esta informação...

Vou postar os 3 scripts:

Ranking
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">'>http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">'>http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">'>http://www.w3.org/1999/xhtml">'>http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

</head>

<h1 style="margin-bottom: 16px;"><font color="#06c">Ranking</font></h1>

<div class="legend" style="margin-bottom: 25px;">

<h3 class="legend-title"><font color="#fff">Os Melhores</font></h3>

<div style="margin-bottom: 8px; margin-top: 10px; color: #CCC;">

<table width="100%" border="0" align="center">

<tr>

<td width="120" bgcolor="#333333"><div align="center" class="button"><a href="?action=top-pvp">TOP PVP</a></div></td>

<td width="120" bgcolor="#333333"><div align="center" class="button"><a href="?action=top-pk">TOP PK</a></div></td>

</tr>

</table>

</div>

</div>

<br />

</body>

Top PK
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

</head>

<h1><font color="#06c">Ranking</font></h1>

<div class="legend" style="margin-bottom: 25px;">

<h3 class="legend-title"><font color="#FFF">Os Melhores</font></h3>

<div style="margin-bottom: 8px; margin-top: 10px; color: #FFF;">

<table width="100%" border="0" align="center">

<tr>

<td width="120" bgcolor="#333333"><div align="center" class="button"><a href="?action=top-pvp">TOP PVP</a></div></td>

<td width="120" bgcolor="#333333"><div align="center" class="button"><a href="?action=top-pk">TOP PK</a></div></td>

</table>

</div>

</div>

<div class="legend" style="margin-bottom: 25px;">

<h3 class="legend-title"><span style="font-size: 13px;"><font color="#FFCC00">TOP PK</font></span></h3>

<div style="margin-bottom: 8px; margin-top: 10px; color: #CCC;">

<?php

$page = @$_GET['page'];

if(!isset($page)){

$page = 1;

}

$result = mysql_num_rows(mysql_query("SELECT * FROM characters"));

$primeira_pagina = ($page*$l2j['pagepk']) - $l2j['pagepk'];

$consulta = mysql_query("SELECT * FROM characters ORDER BY pkkills DESC LIMIT ".$primeira_pagina.",".$l2j['pagepk']);

$soma = $primeira_pagina+1;

$total_paginas = ceil($result/$l2j['pagepk']);

?>

<table width="100%" border="0" align="center">

<tr>

<td align="center" bgcolor="#666666" scope="col"><div align="center" class="">Rank</div></td>

<td align="center" bgcolor="#666666" scope="col"><div align="center" class="">Char</div></td>

<td align="center" bgcolor="#666666" scope="col"><div align="center" class="">Level</div></td>

<td align="center" bgcolor="#666666" scope="col"><div align="center" class="">Clan</div></td>

<td align="center" bgcolor="#666666" scope="col"><div align="center" class="">PKs</div></td>

</tr>

<?php while($res = mysql_fetch_array($consulta)){ ?>

<tr class="textos" onmouseover="this.className='textohover'" onmouseout="this.className='textos'">

<td align="center" bgcolor="#333333" scope="col"><div align="center" class=""><?php echo $soma++ ?></div></td>

<td align="center" bgcolor="#333333" scope="col"><div align="center" class=""><a class="menu" href="?action=ver-player&obj_id=<?php echo $res['obj_Id'] ?>"><?php echo $res['char_name'] ?></div></td>

<td align="center" bgcolor="#333333" scope="col"><div align="center" class=""><?php echo $res['level'] ?></div></td>

<td align="center" bgcolor="#333333" scope="col"><div align="center" class=""><?php if($res['clanid'] == 0){echo('<a class="menu" href="#">Sem Clan</a>');} else{ $clan = mysql_fetch_array(mysql_query('SELECT * FROM clan_data WHERE clan_id = '.$res['clanid'])); echo('<a class="menu" href="?action=clan&clanid='.$res['clanid'].'">'.$clan['clan_name'].'</a>'); } ?></div></td>

<td align="center" bgcolor="#333333" scope="col"><div align="center" class=""><?php echo $res['pkkills'] ?></div></td>

</tr>

<?php } ?>

</table><br />

<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">

<tr>

<th align="center" scope="col"><?php

if($page <= 1){

echo('Anterior ');

}

else{

echo('<a class="menu" href="?action=top-pk&page='.($page-1).'">Anterior</a> ');

}

for($n = 1; $n <= $total_paginas; $n++){

if($n == $page){

echo(' '.$n);

}

else{

echo(' <a class="menu" href="?action=top-pk&page='.$n.'">'.$n.'</a>');

}

}

if($page == $total_paginas){

echo(' Próximo');

}

else{

echo(' <a class="menu" href="?action=top-pk&page='.($page+1).'">Próximo</a>');

}

?></th>

</tr>

</table>

</div>

</div>

<?php

$page = @$_GET['page'];

if(!isset($page)){

$page = 1;

}

$result = mysql_num_rows(mysql_query("SELECT * FROM characters"));

$primeira_pagina = ($page*$l2j['pagepk']) - $l2j['pagepk'];

$consulta = mysql_query("SELECT * FROM characters ORDER BY pkkills DESC LIMIT ".$primeira_pagina.",".$l2j['pagepk']);

$soma = $primeira_pagina+1;

$total_paginas = ceil($result/$l2j['pagepk']);

?>

<br />

</p>

</body>

</html>

Top PvP
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

</head>

<h1><font color="#06c">Ranking</font></h1>

<div class="legend" style="margin-bottom: 25px;">

<h3 class="legend-title"><font color="#FFF">Os Melhores</font></h3>

<div style="margin-bottom: 8px; margin-top: 10px; color: #CCC;">

<table width="100%" border="0" align="center">

<tr>

<td width="120" bgcolor="#333333"><div align="center" class="button"><a href="?action=top-pvp">TOP PVP</a></div></td>

<td width="120" bgcolor="#333333"><div align="center" class="button"><a href="?action=top-pk">TOP PK</a></div></td>

</table>

</div>

</div>

<div class="legend" style="margin-bottom: 25px;">

<h3 class="legend-title"><span style="font-size: 13px;"><font color="#FFCC00">TOP PVP</font></span></h3>

<div style="margin-bottom: 8px; margin-top: 10px; color: #CCC;">

<?php

$page = @$_GET['page'];

if(!isset($page)){

$page = 1;

}

$result = mysql_num_rows(mysql_query("SELECT * FROM characters"));

$primeira_pagina = ($page*$l2j['pagepvp']) - $l2j['pagepvp'];

$consulta = mysql_query("SELECT * FROM characters ORDER BY pvpkills DESC LIMIT ".$primeira_pagina.",".$l2j['pagepvp']);

$soma = $primeira_pagina+1;

$total_paginas = ceil($result/$l2j['pagepvp']);

?>

<table width="100%" border="0" align="center">

<tr>

<td align="center" bgcolor="#666666"><div align="center" class="">Rank</div></td>

<td align="center" bgcolor="#666666"><div align="center" class="">Char</div></td>

<td align="center" bgcolor="#666666"><div align="center" class="">Level</div></td>

<td align="center" bgcolor="#666666"><div align="center" class="">Clan</div></td>

<td align="center" bgcolor="#666666"><div align="center" class="">PvPs</div></td>

</tr>

<?php while($res = mysql_fetch_array($consulta)){ ?>

<tr class="textos" onMouseOver="this.className='textohover'" onMouseOut="this.className='textos'">

<td align="center" bgcolor="#333333"><div align="center" class=""><?php echo $soma++ ?></div></td>

<td align="center" bgcolor="#333333"><div align="center" class=""><a class="menu" href="?action=ver-player&obj_id=<?php echo $res['obj_Id'] ?>"><?php echo $res['char_name'] ?></a></div></td>

<td align="center" bgcolor="#333333"><div align="center" class=""><?php echo $res['level'] ?></div></td>

<td align="center" bgcolor="#333333"><div align="center" class=""><?php if($res['clanid'] == 0){echo('<a class="menu" href="#">Sem Clan</a>');} else{ $clan = mysql_fetch_array(mysql_query('SELECT * FROM clan_data WHERE clan_id = '.$res['clanid'])); echo('<a class="menu" href="?action=clan&clanid='.$res['clanid'].'">'.$clan['clan_name'].'</a>'); } ?></div></td>

<td align="center" bgcolor="#333333"><div align="center" class=""><?php echo $res['pvpkills'] ?></div></td>

</tr>

<?php } ?>

</table><br />

<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">

<tr>

<th align="center" scope="col"><?php

if($page <= 1){

echo('Anterior ');

}

else{

echo('<a class="menu" href="?action=top-pvp&page='.($page-1).'">Anterior</a> ');

}

for($n = 1; $n <= $total_paginas; $n++){

if($n == $page){

echo(' '.$n);

}

else{

echo(' <a class="menu" href="?action=top-pvp&page='.$n.'">'.$n.'</a>');

}

}

if($page == $total_paginas){

echo(' Próximo');

}

else{

echo(' <a class="menu" href="?action=top-pvp&page='.($page+1).'">Próximo</a>');

}

?></th>

</tr>

</table>

</div>

</div>

<br />

</p>

</body>

</html>

**francis** · Agosto 26, 2012

Olá pessoal!!!!

Resolvi um dos problemas aqui com a teste do nosso amigo L2-Windows onde estava:

SELECT * FROM characters ORDER BY pvpkills DESC LIMIT

coloquei

SELECT * FROM characters WHERE acesslevel ='0' ORDER BY pvpkills DESC LIMIT

bom,nas páginas de pk e pvp deu certo porém na index ainda continua mostrando o nick do Gm...

Vou postar a index aki:

<?php

ini_set("display_errors", "OFF");

session_start();

include_once("modules/site-config.php");

include_once("modules/database-config.php");

include('includes/config.php');

include('includes/funcoes.php');

include('anti_ddos/index.php');

include("classes/class.phpmailer.php");

if(!file_exists('includes/config.php')){

header('Location: instalar');

exit();

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "

O conteúdo está oculto, favor efetuar login ou se cadastrar!

Entre

ou

Cadastre-se

<html xmlns="

O conteúdo está oculto, favor efetuar login ou se cadastrar!

Entre

ou

Cadastre-se

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7"/>

<title><?php echo $l2j['titulo'] ?></title>

<link rel="stylesheet" type="text/css" href="css/style.css" media="screen" />

<link rel="stylesheet" type="text/css" href="css/sidebar.css" media="screen" />

<link rel="stylesheet" href="css/plugins/plugin.css" type="text/css" media="screen" />

<link href="images/favicon.gif" rel="shortcut icon" />

<script type="text/javascript">

//desabilita menu de opções após clicar no botão direito

function desabilitaMenu(e)

{

if (window.Event)

{

if (e.which == 2 || e.which == 3)

return false;

}

else

{

event.cancelBubble = true

event.returnValue = false;

return false;

}

}

//desabilita botão direito

function desabilitaBotaoDireito(e)

{

if (window.Event)

{

if (e.which == 2 || e.which == 3)

return false;

}

else

if (event.button == 2 || event.button == 3)

{

event.cancelBubble = true

event.returnValue = false;

return false;

}

}

//desabilita botão direito do mouse

if ( window.Event )

document.captureEvents(Event.MOUSEUP);

if ( document.layers )

document.captureEvents(Event.MOUSEDOWN);

document.oncontextmenu = desabilitaMenu;

document.onmousedown = desabilitaBotaoDireito;

document.onmouseup = desabilitaBotaoDireito;

</script>

<script type="text/javascript" src="css/js/script.js"></script>

<script type="text/javascript" src="css/js/jquery-1.2.3.min.js"></script>

<script type="text/javascript" src="css/js/jquery.easing.min.js"></script>

<script type="text/javascript" src="css/js/jquery.lavalamp.min.js"></script>

<script type="text/javascript" src="jscripts/blockppu.js"></script>

<script type="text/javascript">

$(function() { $("#1, #2, #3").lavaLamp({ fx: "backout", speed: 700, click: function(event,menuItem) { return true;}});});

function MM_swapImgRestore() { //v3.0

var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a)&&x.oSrc;i++) x.src=x.oSrc;

}

function MM_preloadImages() { //v3.0

var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();

var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)

if (a.indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a;}}

}

function MM_findObj(n, d) { //v4.01

var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {

d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}

if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[n];

for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers.document);

if(!x && d.getElementById) x=d.getElementById(n); return x;

}

function MM_swapImage() { //v3.0

var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)

if ((x=MM_findObj(a))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}

}

</script>

</head>

<body onload="MM_preloadImages('images/castle_over.jpg','images/bosses_over.jpg')">

<div id="header">

<div id="hd1"></div>

</div>

<div id="paginas"> <ul class="catnav" id="2">

<li class="current"><a href="index.php">Home</a></li>

<li class="current"><a href="?action=informacoes">Informações</a></li>

<li class="current"><a href="?action=downloads">Downloads</a></li>

<li class="current"><a href="?action=cadastro">Cadastro</a></li>

<li class="current"><a href="?action=doacoes">Doações</a></li>

<li class="current"><a href="?action=regras">Regras</a></li>

<li class="current"><a href="?action=contato">Contato</a></li>

<li class="current"><a href="?action=ranking">Ranking</a></li>

<li class="current"><a href="?action=live">Live Map</a></li>

<li class="current"><a href="forum/index.php" target="_blank">FORUM</a></li>

</ul>

</div><div id="tamanhoconteudo">

<div id="sidebar1">

<div class="dbx-group" id="sidebar-left">

<div id="" class="dbx-box widget_text">

<h3 class="dbx-handle">STATUS</h3>

<div class="dbx-content">

<div class="textwidget"><script src='proturl/protetor.js''></script>

<ul>

<li>Login Server </a> <?php if(!$l2j_login){ echo ('<img border="0" src="images/offline.gif" />'); } else{ echo('<img border="0" src="images/online.gif" />'); } ?></li>

<li>Game Server </a> <?php if(!$l2j_game){ echo ('<img border="0" src="images/offline.gif" />'); } else{ echo('<img border="0" src="images/online.gif" />'); } ?></li>

<li>Players Online </a> <a href="?action=jogando"><?php echo $funcao_ons ?></a></li>

</ul></div>



<script language="Javascript" src="

O conteúdo está oculto, favor efetuar login ou se cadastrar!

Entre

ou

Cadastre-se

type="text/javascript"></script>



</div></div>

</div>

<div class="dbx-group" id="sidebar-left">

<div id="" class="dbx-box widget_text">

<h3 class="dbx-handle">painel de controle</h3>

<div class="dbx-content">

<div class="textwidget"><script src='proturl/protetor.js''></script>

<div align="center"><?php

include_once("login.php"); ?></div>

</div>

</div></div>

</div>

<div class="dbx-group" id="sidebar-left">

<div id="" class="dbx-box widget_text">

<h3 class="dbx-handle">Vote!</h3>

<div class="dbx-content">

<div class="textwidget">

<div align="center">

<script src='proturl/protetor.js''></script>



<center>

<a href="

O conteúdo está oculto, favor efetuar login ou se cadastrar!

Entre

ou

Cadastre-se

<img src="

O conteúdo está oculto, favor efetuar login ou se cadastrar!

Entre

ou

Cadastre-se

border="0" alt="TopPrivates" title="TopPrivates">

</a>

<br>

<b><font size="-1">

<a href="

O conteúdo está oculto, favor efetuar login ou se cadastrar!

Entre

ou

Cadastre-se

</font></b>

</center>



</div>

</div>

</div></div>

</div>

<div class="dbx-group" id="sidebar-left">

<div id="" class="dbx-box widget_text">

<h3 class="dbx-handle">Download</h3>

<div class="dbx-content">

<div class="textwidget">

<div align="center">

<script src='proturl/protetor.js''></script>

<a href="?action=downloads"><img src="images/down.png" border="0" /></a> </div>

</div>

</div></div>

</div>

</div>

<div id="artigos">

<div id="title"><div id="nome"><h2>Notícias</h2>

</div>

<div id="not">Fique por dentro das notícias do servidor!</div><br>

<div id="not">Melhor visualização no Mozilla FireFox.</div>

</div> <div class="entry">

<center>

<br><?php if(!isset($_GET['action'])){ echo('NOTICIAS'); } if(@$_GET['action'] == 'jogando'){ echo('USUARIOS ONLINE'); } if(@$_GET['action'] == 'ver-player') { echo('DETALHES DO JOGADOR'); } ?>

<?php if(!isset($_GET['action'])){

include('paginas/inicio.php');

}

else{

include('paginas/'.$_GET['action'].'.php');

}

?></center>

</div>

<div id="ftctnt"></div>

</div>

</div>

<div id="sidebar2"> </td>

<td class="sidebars">

<div class="dbx-group" id="sidebar-right">

<div id="text-485905146" class="dbx-box widget_text">

<h3 class="dbx-handle"> TOP PLAYERS </h3>

<div class="dbx-content">

<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">

<tr>

<th height="20" colspan="3" align="center" id="menu_texto" scope="col"><div align="center">Top PvP</div></th>

</tr>

<tr class="menuout" id="menu_center">

<th align="center"><div align="center">Rank</div></th>

<th align="center"><div align="center">Nick</div></th>

<th align="right"><div align="center">PvP</div></th>

</tr>

<?php while($rank_pvp = mysql_fetch_array($ranks_pvp)){ ?>

<tr id="menu_center" class="menuout" onmouseover="this.className='menuhover'" onmouseout="this.className='menuout'">

<th align="center""><div align="center"><?php echo $soma++ ?></div></th>

<th align="center"><div align="center"><a href="?action=ver-player&obj_id=<?php echo $rank_pvp['obj_Id'] ?>" class="menu" ><?php echo $rank_pvp['char_name'] ?></a></div></th>

<th align="right" scope="col"><center><font color="#BD2320" style="border-bottom:1px dotted #F00"><?php echo $rank_pvp['pvpkills'] ?></font></center></th>

</tr>

<?php } ?>

<tr>

<th height="20" colspan="3" align="center" id="menu_texto" scope="col"><div align="center">Top PK</div></th>

</tr>

<tr id="menu_center">

<th align="center"><div align="center">Rank</div></th>

<th align="center"><div align="center">Nick</div></th>

<th align="center"><div align="center">PK</div></th>

</tr>

<?php while($rank_pk = mysql_fetch_array($ranks_pk)) { ?>

<tr id="menu_center" onmouseover="this.className='menuhover'" onmouseout="this.className='menuout'">

<th align="center"><center><?php echo $soma1++ ?></center></th>

<th align="center"><div align="center"><a class="" href="?action=ver-player&obj_id=<?php echo $rank_pk['obj_Id'] ?>"><?php echo $rank_pk['char_name'] ?></a></div></th>

<th align="center" scope="col"><center><font color="#BD2320" style="border-bottom:1px dotted #F00"><?php echo $rank_pk['pkkills'] ?></font></center></th>

</tr>

<?php } ?>

</table>

</div>

</div></div>

<div id="text-485905147" class="dbx-box widget_text"><h3 class="dbx-handle">Status Players</h3><div class="dbx-content">

<div class="textwidget">

<a href="?action=bosses"><img src="images/bosses.jpg" alt="Bosses e Grand Bosses" border="0" /></a>

<br>

<a href="?action=castle"><img src="images/castle.jpg" alt="Bosses e Grand Bosses" border="0" /></a>

<br>

<a href="?action=olympiadas"><img src="images/heroes.jpg" alt="Bosses e Grand Bosses" border="0" /></a>

</div>

</div></div>

</div>



</td>

</tr>

</table></div>

<th align="center"><div align="center">L2Resumption by Francis</div></th>

</div>

<div id="footer">

<div id="footer2">

<div id="direitos">Todos os direitos reservados 2011

by <a href="mailto:[email protected]">L2Resumption</a> |

<a href="#">Back to top</a></div>

</div>

</div>

</div>

</body>

</html>

Entrar

Remover nick de GM dos rankings do site

Pergunta

francis

Link para o comentário

Compartilhar em outros sites

4 respostass a esta questão

Posts recomendados

.::ADM::.Spankers

Link para o comentário

Compartilhar em outros sites

L2-Windows

Link para o comentário

Compartilhar em outros sites

francis

Link para o comentário

Compartilhar em outros sites

francis

Link para o comentário

Compartilhar em outros sites

Join the conversation

Anúncios

Quem Está Navegando

Posts

Navegação

Minhas Pesquisas

Atividades

Important Information