HLstatsX Community Edition
  • AIM
  • AWP
  • CODMW
  • DM
  • DMFFA
  • FFAONLYHS
  • DUST2
  • FURIEN
  • FY
  • GUNGAME
  • KNIFE
  • MEGA
  • OLDSCHOOL
  • PAINTBALL
  • SCOUT
  • VANOCNI
  • Contents
  • Search
  • Forum
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: SETB
Home Page:
Activity: 64.33% 64.33%
Members: 54 active members (737 total)
Avg. Member Points: 1,086
Total Kills: 853
Total Deaths: 2,177
Avg. Kills: 16
Kills per Death: 0.39
Kills per Minute: 0.19
Total Connection Time: 3d 01:45:41h
Avg. Connection Time: 0d 01:21:57h
Favorite Server:* csko.cz | dust2 only
Favorite Map:* de_dust2
Favorite Weapon:* Colt M4A1 Carbine
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  No CountrySETB | kokoska 3,201 27% 1d 06:55:45h 331 38.80% 38.80% 900 0.37
2  No CountrySETB | kura na paprike 1,905 74% 0d 07:18:51h 154 18.05% 18.05% 256 0.60
3  No CountrySETB | Bouky 1,566 100% 0d 04:21:49h 95 11.14% 11.14% 136 0.70
4  No CountrySETB | Gigga Nigga 1,218 63% 0d 02:23:04h 41 4.81% 4.81% 83 0.49
5  No CountrySETB | ja ti dam>:D 1,149 95% 0d 08:06:53h 38 4.45% 4.45% 218 0.17
6  No CountrySETB | Spawn 1,092 100% 0d 02:15:22h 33 3.87% 3.87% 63 0.52
7  No CountrySETB | nole 1,075 100% 0d 00:33:08h 3 0.35% 0.35% 21 0.14
8  No CountrySETB | Jenda 1,068 9% 0d 00:55:10h 8 0.94% 0.94% 25 0.32
9  No CountrySETB | puskaris 1,058 87% 0d 00:22:41h 6 0.70% 0.70% 12 0.50
10  No CountrySETB | factory238 1,048 70% 0d 03:41:24h 19 2.23% 2.23% 111 0.17
11  No CountrySETB | Patress 1,041 69% 0d 01:49:34h 24 2.81% 2.81% 59 0.41
12  No CountrySETB | Krstny Tato 1,038 95% 0d 00:27:08h 7 0.82% 0.82% 12 0.58
13  No CountrySETB | TommyDKnL 1,032 96% 0d 01:30:44h 11 1.29% 1.29% 26 0.42
14  No CountrySETB | strojnickapico 1,032 80% 0d 00:36:04h 1 0.12% 0.12% 9 0.11
15  No CountrySETB | SwagSigmaBoss 1,031 79% 0d 00:45:34h 3 0.35% 0.35% 5 0.60
16  No CountrySETB | dneska to jede 1,030 4% 0d 00:34:22h 11 1.29% 1.29% 23 0.48
17  No CountrySETB | Mikulas Vareha 1,028 8% 0d 00:26:03h 9 1.06% 1.06% 15 0.60
18  No CountrySETB | keketr 1,019 64% 0d 00:25:08h 4 0.47% 0.47% 23 0.17
19  No CountrySETB | paulito 1.6 1,018 59% 0d 00:41:58h 9 1.06% 1.06% 26 0.35
20  No CountrySETB | Freed 1,016 70% 0d 00:04:15h 2 0.23% 0.23% 2 1.00


Page: 1 2 3




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 77 times 77
2 Spawn with the Bomb 46 times 92
3 Drop the Bomb 38 times -76
4 Double Kill (2 kills) 27 times 27
5 Pick up the Bomb 14 times 28
6 Plant the Bomb 12 times 180
7 Triple Kill (3 kills) 9 times 18
8 Defuse the Bomb 3 times 45
9 Start Defusing the Bomb Without a Defuse Kit 2 times 0
10 Start Defusing the Bomb With a Defuse Kit 2 times 0
11 Domination (4 kills) 2 times 6
12 Rampage (5 kills) 1 times 4




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Counter-Terrorist 98 times 54.14% 54.14%
2 Terrorist 80 times 44.20% 44.20%




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