![](./hlstatsimg/downarrow.gif)
![](./hlstatsimg/downarrow.gif)
Statistics Summary | ||
Clan: | USA | |
Home Page: | ||
Activity: | ![]() |
32.00% |
Members: | 1 active members (2 total) | |
Avg. Member Points: | 565 | |
Total Kills: | 792 | |
Total Deaths: | 957 | |
Avg. Kills: | 792 | |
Kills per Death: | 0.83 | |
Kills per Minute: | 1.42 | |
Total Connection Time: | 0d 09:18:22h | |
Avg. Connection Time: | 0d 09:18:22h | |
Favorite Server:* | Adult Gamers Community - DOD:S Gungame | |
Favorite Map:* | dod_2rooms_clusterpit | |
Favorite Weapon:* | ![]() |
Player Locations | ||
![](./hlstatsimg/downarrow.gif)
Rank | Name | Points ![]() |
Activity | Time | Kills | Clan Kills | % | Deaths | Kpd |
1 | ![]() |
565 | ![]() |
0d 09:18:22h | 792 | ![]() |
100.00% | 957 | 0.83 |
![](./hlstatsimg/downarrow.gif)
Rank | Action ![]() |
Achieved | Points Bonus |
1 | Triple Kill (3 kills) | 1 times | 2 |
2 | Double Kill (2 kills) | 4 times | 4 |
![](./hlstatsimg/downarrow.gif)
ERROR |
Database Error Server Address: localhost Server Username: agc Error Diagnostic: Bad query. Server Error: (1055) Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'agc.hlstats_Frags_as_res.killsTotal' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by Last SQL Query: SELECT IFNULL(hlstats_Roles.name, hlstats_Events_ChangeRole.role) AS name, IFNULL(hlstats_Roles.code, hlstats_Events_ChangeRole.role) AS code, COUNT(hlstats_Events_ChangeRole.id) AS rolecount, ROUND(COUNT(hlstats_Events_ChangeRole.id) / IF(4 = 0, 1, 4) * 100, 2) AS percent, killsTotal, deathsTotal, ROUND(killsTotal/if(deathsTotal=0,1,deathsTotal), 2) AS kpd FROM hlstats_Events_ChangeRole LEFT JOIN hlstats_Roles ON hlstats_Events_ChangeRole.role = hlstats_Roles.code LEFT JOIN hlstats_Servers ON hlstats_Servers.serverId = hlstats_Events_ChangeRole.serverId LEFT JOIN hlstats_Frags_as_res ON hlstats_Frags_as_res.role = hlstats_Events_ChangeRole.role LEFT JOIN hlstats_Players ON hlstats_Players.playerId = hlstats_Events_ChangeRole.playerId WHERE hlstats_Servers.game='dods' AND hlstats_Players.clan=72 AND (hidden <>'1' OR hidden IS NULL) AND hlstats_Roles.game = 'dods' GROUP BY hlstats_Events_ChangeRole.role ORDER BY killsTotal desc, name desc |