| Player |
Time |
Frags |
FPG |
FPH |
Deaths |
DPG |
DPH |
Suicides |
SPG |
SPH |
Games |
Efficiency |
Avg Ping |
Line 46 in /home/apoc/public_html/phpStats/stats/GroupStats.php: Error while getting statusesAccess denied for user 'www-data'@'localhost' (using password: NO), Query = SELECT PlayerInGame.PID, Name, SUM(PlayTime) AS TotalPlayTime, SUM(Kills) AS NumKills, ROUND(SUM(Kills)/COUNT(GID),1) AS FPG, ROUND((SUM(Kills)*3600)/SUM(PlayTime),1) AS FPH, SUM(Deaths) AS NumDeaths, ROUND(SUM(Deaths)/COUNT(GID),1) AS DPG, ROUND((SUM(Deaths)*3600)/SUM(PlayTime),1) AS DPH, SUM(Suicides) AS NumSuicides, ROUND(SUM(Suicides)/COUNT(GID),1) AS SPG, ROUND((SUM(Suicides)*3600)/SUM(PlayTime),1) AS SPH, ROUND((Sum(Kills)*100)/(Sum(Kills)+Sum(Deaths)+SUM(Suicides)), 2) AS Eff, COUNT(GID) AS NumGames, AVG(AveragePing) AS AvgPing, IsBot FROM PlayerInGame, Players WHERE PlayerInGame.PID = Players.PID AND Deaths != 0 GROUP BY PID HAVING COUNT(GID) > 5 ORDER BY TotalPlayTime DESC