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

  Clan Information

Statistics Summary
Clan: unknown
Home Page:
Activity: 99.41%
Members: 68 active members (68 total)
Avg. Member Points: 25,443
Total Kills: 721,029
Total Deaths: 594,148
Avg. Kills: 10,603
Kills per Death: 1.21
Kills per Minute: 0.59
Total Connection Time: 855d 10:59:13h
Avg. Connection Time: 12d 13:55:34h
Favorite Server:* * SchlachtHof :|: Dust2 Only :|: *Test* // noAim.eu
Favorite Map:* de_dust2
Favorite Weapon:* Kalashnikov AK-47
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  GermanyZoo elorank 80,528 73d 10:13:40h 64,344 8.92% 39,124 1.64
2  EstoniaAKJˇˇ elorank 71,512 78d 08:34:37h 96,405 13.37% 54,236 1.78
3  AustriaLuckyshO† ²high²fly elorank 64,875 19d 19:28:19h 22,747 3.15% 10,857 2.10
4  Germany// eimbod #awkn elorank 63,220 18d 16:54:13h 20,859 2.89% 10,102 2.06
5  Germany. J o k e r J o e # elorank 63,108 18d 05:04:24h 25,307 3.51% 9,739 2.60
6  Norwayhalfempty.dll elorank 60,173 11d 00:16:59h 13,927 1.93% 6,880 2.02
7  Irelandred_bairn elorank 59,894 31d 10:04:38h 35,186 4.88% 19,783 1.78
8  GermanyFagKiller elorank 57,785 38d 15:38:47h 39,735 5.51% 29,097 1.37
9  Germany[PL] Apfelasch elorank 56,303 19d 13:07:25h 19,347 2.68% 12,281 1.58
10  GermanyNebu elorank 54,163 17d 06:40:58h 17,526 2.43% 10,881 1.61
11  GermanyKeNZaN elorank 52,707 14d 04:13:13h 12,411 1.72% 9,114 1.36
12  GermanyG1N / GH1SKHAN^ elorank 52,129 33d 19:25:03h 32,295 4.48% 27,767 1.16
13  GermanyDarmkind(D)leichtesopfer elorank 51,903 56d 20:59:54h 49,049 6.80% 39,708 1.24
14  GermanyT Y S O N elorank 50,547 49d 01:51:09h 43,310 6.01% 34,540 1.25
15  AustriaFÀÎŁ elorank 50,117 14d 14:10:53h 10,884 1.51% 9,101 1.20
16  GermanySaiya'7 elorank 46,774 15d 06:39:43h 14,433 2.00% 10,895 1.32
17  AustriaMeister elorank 46,605 8d 12:28:03h 8,763 1.22% 6,390 1.37
18  GermanyMAGICO QUE MEXE COM A SUA MENTE elorank 41,667 31d 01:03:04h 23,344 3.24% 21,961 1.06
19  Germanybella elorank 41,227 18d 02:20:22h 12,273 1.70% 13,676 0.90
20  GermanyWalter de Frosch elorank 38,017 10d 12:24:31h 6,200 0.86% 7,473 0.83


Page: 1 2 3 4




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 18,857 times 18,857
2 Double Kill (2 kills) 6,077 times 6,077
3 Pick up the Bomb 3,745 times 11,235
4 Triple Kill (3 kills) 2,595 times 5,190
5 Drop the Bomb 2,041 times -6123
6 Plant the Bomb 1,289 times 7,734
7 Domination (4 kills) 954 times 2,862
8 Start Defusing the Bomb With a Defuse Kit 429 times 0
9 Rampage (5 kills) 296 times 1,184
10 Defuse the Bomb 269 times 2,690
11 Mega Kill (6 kills) 95 times 475
12 Ownage (7 kills) 28 times 168
13 Ultra Kill (8 kills) 8 times 56
14 Start Defusing the Bomb Without a Defuse Kit 5 times 0




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Counter-Terrorist 2,607 times 28.91%
2 Terrorist 2,517 times 27.91%




ERROR
Database Error

Server Address: localhost
Server Username: hlsx

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='css'
			AND hlstats_Players.clan=3159
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'css'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc