Solved Top 25 Fragers Help

[MxSoft]

Hi i got this script but is not working

<?php 
function coloured_value($valuein) 
{ 
$value2 = $valuein; 
while(strlen($value2) > 3) 
{ 
$value .= ' '.substr($value2, -3, 3); 
$value2 = substr($value2, 0, strlen($value2)-3); 
} 
$value = $value2.$value; 
if($valuein > 0) 
return ''.$value.''; 
elseif($valuein < 0) 
return '<font color="red">-'.$value.'</font>'; 
else 
return ''.$value.''; 
} 
function placeImages($count){ 
if($count > 300) return "<img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/blackskull.gif'><img src='images/blackskull.gif'><img src='images/blackskull.gif'>"; 
if($count > 260) return "<img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/blackskull.gif'><img src='images/blackskull.gif'>"; 
if($count > 230) return "<img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskullhalf.gif'>"; 
if($count > 190) return "<img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskull.gif'>"; 
if($count > 150) return "<img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskullhalf.gif'>"; 
if($count > 120) return "<img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskull.gif'>"; 
if($count > 90) return "<img src='images/redskull.gif'><img src='images/redskull.gif'><img src='images/redskullhalf.gif'>"; 
if($count > 70) return "<img src='images/redskull.gif'><img src='images/redskull.gif'>"; 
if($count > 50) return "<img src='images/redskull.gif'><img src='images/redskullhalf.gif'>"; 
if($count > 30) return "<img src='images/redskull.gif'>"; 
if($count > 10) return "<img src='images/redskullhalf.gif'>"; 
} 
function showTopExp() 
{ 
global $SQL; 
global $config,$connect; 
$world = $_GET['world']; 
if ($world > 0 && is_numeric($world)){ 
$world = " WHERE `world_id` = ".(int)($world-1)."10"; 
} 
$return .= "<br><h2><center><font color='red'>Top 25 Fragers on ".$config['server']['serverName']."</font></center></h2><br> 
<table border=0 cellspacing=1 cellpadding=4 width=100%> 
<tr bgcolor=\"".$config['site']['vdarkborder']."\"> 
<td class=white><font><b>Lp.</b></font></td> 
<td class=white width=\"40%\"><font><b>Name</b></font></td> 
<td class=white><font><b>Online</b></font></td> 
<td class=white width=\"20%\"><font><b>World</b></font></td> 
<td class=white width=\"40%\"><font><b>Count</b></font></td></tr>"; 
$groupMembers = $SQL->query('SELECT `name`,`frags_all`,`level`,`world_id`,`online`,`account_id` FROM `players`'.$world.' ORDER BY `frags_all` DESC LIMIT 25'); 
$membersCount = 0; 
$memberss = 0; 
foreach($groupMembers as $member) 
{ 
$membersCount++; 
if(is_int($membersCount / 2)) 
$bgcolor = $config['site']['darkborder']; 
else 
$bgcolor = $config['site']['lightborder']; 
$return .= "<tr bgcolor=\"".$bgcolor."\"><td>".$membersCount.".</td> 
<td><center>".$on."</center></td> 
<td>".$config['server']['serverName']."</td> 
<td>".$member['frags_all']." different people<br/>".placeImages($member['frags_all'])."</td> 
</tr>"; 
$memberss++; 
} 
if ($membersCount = 0) $return .= "<tr bgcolor=\"".$config['site']['darkborder']."\"> 
<td colspan=\"2\">No statistics available.</td> 
</tr>"; 
$return .= "</table>"; 
if($memberss > 0){ 
$memberss = 0; 
return $return; 
}else 
{ 
return false; 
} 
} 
$main_content .= showTopExp();
?>

 

[bolero]

<?php
$main_content .= '<div style="text-align: center; font-weight: bold;">Top 30 Frags on ' . $config['server']['serverName'] . '</div>
<table border="0" cellspacing="1" cellpadding="4" width="100%">
	<tr bgcolor="' . $config['site']['vdarkborder'] . '">
		<td class="white" style="text-align: center; font-weight: bold;">Name</td>
		<td class="white" style="text-align: center; font-weight: bold;">Frags</td>
	</tr>';

$i = 0;
foreach($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
	GROUP BY `name`
	ORDER BY `frags` DESC, `name` ASC
	LIMIT 0,30;') as $player)
{
	$i++;
	$main_content .= '<tr bgcolor="' . (is_int($i / 2) ? $config['site']['lightborder'] : $config['site']['darkborder']) . '">
		<td><a href="?subtopic=characters&name=' . urlencode($player['name']) . '">' . $player['name'] . '</a></td>
		<td style="text-align: center;">' . $player['frags'] . '</td>
	</tr>';
}

$main_content .= '</table>';
?>

 

[MxSoft]

Ty Bolero ++REP