Clan Information
Members
Statistics Summary | ||
Clan: | USA | |
Home Page: | ||
Activity: | 29.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_zx_sky | |
Favorite Weapon:* |
Player Locations | ||
Members
Rank | Name | Points | Activity | Time | Kills | Clan Kills | % | Deaths | Kpd |
1 | Sgt. Rock {USA} | 565 | 0d 09:18:22h | 792 | 100.00% | 957 | 0.83 |
Player Actions *
Team Selection *
Rank | Action | Achieved | Points Bonus |
1 | Triple Kill (3 kills) | 1 times | 2 |
2 | Double Kill (2 kills) | 4 times | 4 |
Team Selection *
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 |