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..

Quer em BOX?

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

<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>

<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 11 anos por macalo (veja o histórico de edições)