Necessito de ajuda em meu top fraggers, aqui está meu topFraggers.php.

Eu apenas editei o topRank usado nos novos sites gesior para mostrar as frags mas não está funcionando.

 

Topfragger.php

<?php
$skills = $SQL->query('SELECT * FROM players WHERE deleted = 0 AND group_id < 2 AND account_id != 1 ORDER BY level DESC LIMIT 5');
?>
<style type="text/css" media="all">
  .Toplevelbox {
    position: relative;
    margin-bottom: 10px;
    width: 180px;
    height: 200px;
  }
  .top_level {
    position: absolute;
    top: 30px;
    left: 6px;
    height: 180px;
    width: 168px;
    z-index: 20;
    text-align: center;
    padding-top: 6px;
    font-family: Tahoma, Geneva, sans-serif;
    font-size: 9.2pt;
    color: #FFF;
    font-weight: bold;
    text-align: right;
    text-decoration: inherit;
    text-shadow: 0.1em 0.1em #333
  }

  #Topbar a {
  text-decoration: none;
  cursor: auto;
  }
  a.topfont {
    font-family: Verdana, Arial, Helvetica; 
    font-size: 13px; 
    color: #0F0;
    text-decoration: none
  }
  a:hover.topfont {
    font-family: Verdana, Arial, Helvetica; 
    font-size: 13px;  
    color: #CCC; 
    text-decoration:none
  }
</style>

<div id="Topbar" class="Toplevelbox" style="background-image:url(<?PHP echo $layout_name; ?>/images/top_warlords.png);">
  <div class="top_level" style="background:url(<?PHP echo $layout_name; ?>/images/bg_top.png)" align="left">
    <?php 
    $a = 1;
        $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) {
      echo '<div align="left"><a href="?subtopic=characters&name='.$skill['name'].'" class="topfont">
        <font color="#CCC">&nbsp;</font>'.$skill['name'].'
        <small><br><font color="red">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;frags: '.$frag['frags'].'</font></small>
        <br>
      </a>
      </div>';
      $a++;
    }
    ?>
    <div class="Bottom" style="background-image:url(<?PHP echo $layout_name; ?>/images/box-bottom.gif); left:-5px;"> 
    </div>
  </div>
</div> 

 

Resultado: (muito bugado)

 

 

BUMP

BUMP