HLstatsX Community Edition
  • L4D2
  • TF
  • Contents
  • Search
  • SourceBans
  • Forum
  • Help

  Clan Information

Statistics Summary
Clan: 1
Home Page:
Activity: 25.66%
Members: 9 active members (14 total)
Avg. Member Points: 2,009
Total Kills: 5,035
Total Deaths: 208
Avg. Kills: 559
Kills per Death: 24.21
Kills per Minute: 6.83
Total Connection Time: 0d 12:17:07h
Avg. Connection Time: 0d 01:21:54h
Favorite Server:*
Favorite Map:*
Favorite Weapon:*
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  United states(1)Ellis elorank 6,081 0d 04:54:55h 2,703 53.68% 74 36.53
2  United states(1)Nebula elorank 2,525 0d 02:13:05h 832 16.52% 5 166.40
3  MexicoArJPsPz(1) elorank 1,949 0d 01:26:34h 482 9.57% 36 13.39
4  United states(1)Ellis elorank 1,560 0d 01:25:29h 418 8.30% 23 18.17
5  United states(1)Nick elorank 1,347 0d 00:38:10h 167 3.32% 15 11.13
6  Mexico(1)virenque_fitsin elorank 1,291 0d 00:40:30h 123 2.44% 33 3.73
7  United states(1)ellis elorank 1,246 0d 00:08:23h 95 1.89% 2 47.50
8  United states(1)Johnston45 elorank 1,083 0d 00:49:53h 215 4.27% 20 10.75
9  Mexico(1)Bill elorank 1,000 0d 00:00:08h 0 0.00% 0 0.00




ERROR
Database Error

Server Address: 192.168.1.101
Server Username: motd

Error Diagnostic:
Bad query.

Server Error: (1267) Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_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='l4d2'
			AND hlstats_Players.clan=30
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'l4d2'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc