[PEDIDO] 5 Top frags GESIOR

[macalo 22]

queria pedir ajuda de vcs criar um top frags no luga do do level 

 

esta aki meu script do top level 

<div id="Topbar" class="Toplevelbox" style="background-image:url(/images/top_level.png);">
<div class="top_level" style="background:url(/images/bg_top.png)" align="left">
<?php

$limitt = 6;
$zap = $SQL->query('SELECT `name`,`level` FROM `players` WHERE `group_id` < '.$config['site']['players_group_id_block'].' AND `name` != "Account Manager" ORDER BY `level` DESC, `experience` DESC LIMIT 5;');
$number_of_rows = 0; 
foreach($zap as $wynik) 
{
$number_of_rows++;
echo '<div align="left"><a href="index.php?subtopic=characters&name='.urlencode($wynik['name']).'" class="topfont"><b><font color="black">&nbsp;&nbsp;&nbsp;&nbsp; '.$number_of_rows.' - </font></b> '.$wynik['name'].' <br/><small><b><font color="white">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Level: ('.$wynik['level'].')</font></b></small><br/></a></div>'; 
} 
?>
</div>
<div class="Bottom" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/box-bottom.gif);"></div>
</div>

se alguém poder ajuda  fico grato e dou rep + quem ajudar..

[Absolute 0]

Quer em BOX?

[glacialot 2]

Boa jovem, tambem estou atras deste Script.. Seria em BOX do lado direito, igual ao top 5 level, mas sendo top 5 frags...

[luanluciano93 1994]

<div id="Topbar" class="Toplevelbox" style="background-image:url(/images/top_level.png);">
	<div class="top_level" style="background:url(/images/bg_top.png)" align="left">
		<?php
		$zap = $SQL->query('SELECT `name`,`level` FROM `players` WHERE `group_id` < '.$config['site']['players_group_id_block'].' AND `name` != "Account Manager" ORDER BY `level` DESC, `experience` DESC LIMIT 5;');
		$frags_database = $SQL->query('SELECT `p`.`name` AS `name`, COUNT(`p`.`name`) as `frags` FROM `killers` k LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id` WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 0,30;');
		$number_of_rows1 = 0; 
		foreach($frags_database as $frag) 
		{
			$number_of_rows1++;
			echo '<div align="left"> <a href="index.php?subtopic=characters&name='.urlencode($frag['name']).'" class="topfont"> <b>
			<font color="black">&nbsp;&nbsp;&nbsp;&nbsp; '.$number_of_rows1.' - </font></b>'.htmlspecialchars($frag['name']).' <br/><small><b>
			<font color="white">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frags: '.$frag['frags'].' </font></b></small><br/></a></div>'; 
		} 
		?>
	</div>
	<div class="Bottom" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/box-bottom.gif);"></div>
</div>

[macalo 22]

<div id="Topbar" class="Toplevelbox" style="background-image:url(/images/top_level.png);">
	<div class="top_level" style="background:url(/images/bg_top.png)" align="left">
		<?php
		$zap = $SQL->query('SELECT `name`,`level` FROM `players` WHERE `group_id` < '.$config['site']['players_group_id_block'].' AND `name` != "Account Manager" ORDER BY `level` DESC, `experience` DESC LIMIT 5;');
		$frags_database = $SQL->query('SELECT `p`.`name` AS `name`, COUNT(`p`.`name`) as `frags` FROM `killers` k LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id` WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 0,30;');
		$number_of_rows1 = 0; 
		foreach($frags_database as $frag) 
		{
			$number_of_rows1++;
			echo '<div align="left"> <a href="index.php?subtopic=characters&name='.urlencode($frag['name']).'" class="topfont"> <b>
			<font color="black">&nbsp;&nbsp;&nbsp;&nbsp; '.$number_of_rows1.' - </font></b>'.htmlspecialchars($frag['name']).' <br/><small><b>
			<font color="white">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frags: '.$frag['frags'].' </font></b></small><br/></a></div>'; 
		} 
		?>
	</div>
	<div class="Bottom" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/box-bottom.gif);"></div>
</div>

vlw... por ter ajudado luciano esta meu rep +

a mais uma duvida aki como eu mudo a cor do numero que aparece antes do player e a cor do nome do frags.

ex: 1- nome do player

       frags: 1

Editado Junho 17, 2014 por macalo (veja o histórico de edições)

[luanluciano93 1994]

<font color="black">&nbsp;&nbsp;&nbsp;&nbsp; '.$number_of_rows1.' - </font>

a tag FONT tem o valor COLOR, que basicamente é a cor da fonte ... basta alterar ali color="black" para color"red" ...

[glacialot 2]

No meu não da certo, enquanto o codigo esta como top level ele funciona:

 

Codigo com os 2 como Top LEVEL:

 

<div id="Topbar" class="Toplevelbox" style="background-image:url(layouts/tibiacom/images/top_level.png);">
  <div class="top_level" style="background:url(layouts/tibiacom/images/bg_top.png)" align="left">
    <div align="left"><a href="?subtopic=characters&name=Last Slayer" class="topfont">
       <?php 


$limitt = 6; 
$zap = $SQL->query('SELECT `name`,`level` FROM `players` WHERE `group_id` < '.$config['site']['players_group_id_block'].' AND `name` != "Account Manager" ORDER BY `level` DESC, `experience` DESC LIMIT 10;'); 
$number_of_rows = 0; 
foreach($zap as $wynik) 
{ 
$number_of_rows++; 
echo '<div align="left"><a href="index.php?subtopic=characters&name='.urlencode($wynik['name']).'" class="topfont"><b><font color="black">&nbsp;&nbsp;&nbsp;&nbsp; '.$number_of_rows.' - </font></b> '.$wynik['name'].' <br/><small><b><font color="white">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Level: ('.$wynik['level'].')</font></b></small><br/></a></div>'; 
} 
?>
<div class="Bottom" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/box-bottom.gif); top: 265px;; left:-6px;"> </div>
      </div>    
  </div>

E quando mudo o Codigo conforme nosso amigo falou:

 

 

Codigo:

<div id="Topbar" class="Toplevelbox" style="background-image:url(/images/top_level.png);">
	<div class="top_level" style="background:url(/images/bg_top.png)" align="left">
		<?php
		$zap = $SQL->query('SELECT `name`,`level` FROM `players` WHERE `group_id` < '.$config['site']['players_group_id_block'].' AND `name` != "Account Manager" ORDER BY `level` DESC, `experience` DESC LIMIT 5;');
		$frags_database = $SQL->query('SELECT `p`.`name` AS `name`, COUNT(`p`.`name`) as `frags` FROM `killers` k LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id` WHERE `k`.`unjustified` = 1 AND `k`.`final_hit` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 0,30;');
		$number_of_rows1 = 0; 
		foreach($frags_database as $frag) 
		{
			$number_of_rows1++;
			echo '<div align="left"> <a href="index.php?subtopic=characters&name='.urlencode($frag['name']).'" class="topfont"> <b>
			<font color="black">&nbsp;&nbsp;&nbsp;&nbsp; '.$number_of_rows1.' - </font></b>'.htmlspecialchars($frag['name']).' <br/><small><b>
			<font color="white">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Frags: '.$frag['frags'].' </font></b></small><br/></a></div>'; 
		} 
		?>
	</div>
	<div class="Bottom" style="background-image:url(<?PHP echo $layout_name; ?>/images/general/box-bottom.gif);"></div>
</div>  

Alguem sabe oque pode ser?

 

- Acho que os FRAGS do meu OTServ não estão aparecendo no Site, nem no TOP FRAGers ele aparece, Como faço pra adiconar?

Editado Junho 17, 2014 por glacialot (veja o histórico de edições)

[Lvm65 0]

Como que Instala isso ?

[Marcio Santos 26]

Olá Luan, o meu tá dando esse erro aqui repetindo as imagens vc tem como resolver  isso para mim? agradeço desde já Luan meu top