Server Stat System

[SSS] --- STATUS ---
         [SSS] `Server Stat System` doesn't work now
          MySQL:
         <TAB>Host:<TAB><TAB><TAB>ип
         <TAB>User:<TAB><TAB><TAB>данные
         <TAB>DB:<TAB><TAB><TAB>данные
         <TAB>Queries:<TAB><TAB>0
         <TAB>Errors:<TAB><TAB><TAB>0
         [SSS] --- --- ---

$v['name'] = ($v['name']); // эта строка, изменить на  
$v['name'] = htmlspecialchars($v['name']);

строка 79
                                SELECT SQL_CACHE
                                p.`id`,
                                p.`name`,
                                p.`alltime`,
                                p.`numrounds`,
                                sum(w.`kills`) as kills,
                                sum(w.`deaths`) as deaths,
                                sum(w.`headshots`) as headshots,
                                sum(w.`teamkilling`) as teamkilling,
                                sum(w.`shots`) as shots,
                                sum(w.`hits`) as hits,
                                sum(w.`damage`) as damage

                                FROM `players` as p
                                LEFT JOIN `weapons` as w ON w.user_id=p.id
                                GROUP BY p.id
                                ORDER BY `kills` desc
                                LIMIT ".$start.", ".$perpg."
// эта строка, изменить на  
SELECT SQL_CACHE
p.`id`,
p.`name`,
p.`alltime`,
p.`numrounds`,
sum(w.`kills`) as kills,
sum(w.`deaths`) as deaths,
ROUND((CASE WHEN sum(w.`kills`)<50 THEN 0 ELSE sum(w.`kills`)+1 END)/(CASE WHEN sum(w.`deaths`)=0 THEN 1 ELSE sum(w.`deaths`)+1 END),2) as stat,
sum(w.`headshots`) as headshots,
sum(w.`teamkilling`) as teamkilling,
sum(w.`shots`) as shots,
sum(w.`hits`) as hits,
sum(w.`damage`) as damage
FROM `players` as p
LEFT JOIN `weapons` as w ON w.user_id=p.id
GROUP BY p.id
ORDER BY `stat` desc
                                LIMIT ".$start.", ".$perpg."

строка примерно 51
SELECT SQL_CACHE
                p.`id`,
                p.`name`,
                sum(w.`kills`) as `kills`,
                sum(w.`deaths`) as `deaths`
                FROM `players` as p
                LEFT JOIN `weapons` as w ON w.user_id=p.id
                GROUP BY w.user_id
                ORDER BY `kills` DESC
                LIMIT ".$num;

// заменить на
SELECT SQL_CACHE
                p.`id`,
                p.`name`,
                sum(w.`kills`) as `kills`,
                sum(w.`deaths`) as `deaths`,
                ROUND((CASE WHEN sum(w.`kills`)<50 THEN 0 ELSE sum(w.`kills`)+1 END)/(CASE WHEN sum(w.`deaths`)=0 THEN 1 ELSE sum(w.`deaths`)+1 END),2) as stat
                FROM `players` as p
                LEFT JOIN `weapons` as w ON w.user_id=p.id
                GROUP BY w.user_id
                ORDER BY `stat` DESC
                LIMIT ".$num;

<th class="top" scope="col" width="45">{"PG_PLAYERS_KILLS"|getLangVar}</th>
<th class="top" scope="col" width="45">{"PG_PLAYERS_DEATHS"|getLangVar}</th>
//заменить на
<th class="top" scope="col" width="45">Kоэфф.</th>
<th class="top" scope="col" width="45">{"PG_PLAYERS_KILLS"|getLangVar}<br>{"PG_PLAYERS_DEATHS"|getLangVar}</th>

<td class="tbl_val">{$pla.kills}</td>
<td class="tbl_val">{$pla.deaths}</td>
//заменить на
<td class="tbl_val">{$pla.stat}</td>
<td class="tbl_val">{$pla.kills} | {$pla.deaths}</td>