![](./hlstatsimg/downarrow.gif)
![](./hlstatsimg/downarrow.gif)
Statistics Summary | ||
Clan: | 390 | |
Home Page: | ||
Activity: | ![]() |
16.00% |
Members: | 1 active members (1 total) | |
Avg. Member Points: | 1,012 | |
Total Kills: | 0 | |
Total Deaths: | 3 | |
Avg. Kills: | 0 | |
Kills per Death: | 0.00 | |
Kills per Minute: | 0.00 | |
Total Connection Time: | 0d 00:20:41h | |
Avg. Connection Time: | 0d 00:20:41h | |
Favorite Server:* | csko.cz | dust2 only | |
Favorite Map:* | de_dust2 | |
Favorite Weapon:* |
Player Locations | ||
![](./hlstatsimg/downarrow.gif)
Rank | Name | Points | Activity | Time | Kills | Clan Kills | % | Deaths | Kpd ![]() |
1 | ![]() |
1,012 | ![]() |
0d 00:20:41h | 0 | ![]() |
0.00% | 3 | 0.00 |
![](./hlstatsimg/downarrow.gif)
ERROR |
Database Error Server Address: 192.168.1.22:3306 Server Username: webik Error Diagnostic: Bad query. Server Error: (1267) Illegal mix of collations (utf8_czech_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' 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(0 = 0, 1, 0) * 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='dust2' AND hlstats_Players.clan=686867 AND (hidden <>'1' OR hidden IS NULL) AND hlstats_Roles.game = 'dust2' GROUP BY hlstats_Events_ChangeRole.role ORDER BY rolecount desc, name desc |