Top Fraggers in sidebar

[seleo]

Hello
this is a side bar in my template that shows the top server characters

							<div id="vt_panel_module">
								<div class="header">Top Server Characters</div>
								<?php
									$TopPlayers = $SQL->query("SELECT `name`, `experience`, `level` FROM `players` ORDER BY `experience` DESC LIMIT 5")->fetchAll();
									$Counter = 1;
								?>
                                <table cellspacing="0" cellpadding="5" border="0" width="100%">
									<?php foreach($TopPlayers as $Player): ?>
                                    <tr>
										<td width="10%"><?php echo $Counter; $Counter++; ?>.</td>
										<td><a href="index.php?subtopic=characters&amp;name=<?php echo urlencode($Player['name']); ?>"><?php echo $Player['name']; ?></a></td>
										<td align="right" width="25%"><?php echo $Player['level']; ?> level</td>
									</tr>
                                    <?php endforeach; ?> 
								</table>
							</div>

could someone please edit that so it can shows the top server Fraggers?

 

[seleo]

Bump!!

 

[megazx]

shof de keda

<?php
$main_content .= '<div style="text-align: center; font-weight: bold;"><font color="red"> 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>';
?>

 

[seleo]

its top fraggers page
i need a top fraggers in the sidebar

 

[seleo]

Bump!!

 

[seleo]

Pump!!

 

[Ninja]

                            <div id="vt_panel_module">
                                <div class="header">Top Server Characters</div>
                                <?php
                                    $TopPlayers = $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,5;")->fetchAll();
                                    $Counter = 1;
                                ?>
                                <table cellspacing="0" cellpadding="5" border="0" width="100%">
                                    <?php foreach($TopPlayers as $Player): ?>
                                    <tr>
                                        <td width="10%"><?php echo $Counter; $Counter++; ?>.</td>
                                        <td><a href="index.php?subtopic=characters&amp;name=<?php echo urlencode($Player['name']); ?>"><?php echo $Player['name']; ?></a></td>
                                        <td align="right" width="25%"><?php echo $Player['frags']; ?> kills</td>
                                    </tr>
                                    <?php endforeach; ?> 
                                </table>
                            </div>

 

[seleo]

thanks
working prefectly