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: 54.10% 54.10%
Members: 38 active members (709 total)
Avg. Member Points: 1,185
Total Kills: 1,108
Total Deaths: 2,632
Avg. Kills: 29
Kills per Death: 0.42
Kills per Minute: 0.22
Total Connection Time: 3d 13:30:46h
Avg. Connection Time: 0d 02:15:01h
Favorite Server:* csko.cz | dust2 only
Favorite Map:* de_dust2
Favorite Weapon:* Kalashnikov AK-47
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  No CountrySETB | O.S.T.R.A.V.A.C.E.K 3,366 44% 0d 19:13:30h 307 27.71% 27.71% 729 0.42
2  No CountrySETB | kokoska 3,201 80% 1d 06:55:45h 331 29.87% 29.87% 900 0.37
3  No CountrySETB | kura na paprike 1,883 96% 0d 07:10:43h 151 13.63% 13.63% 253 0.60
4  No CountrySETB | Klaudy 1,704 24% 0d 05:11:54h 72 6.50% 6.50% 116 0.62
5  No CountrySETB | skoricovy_trdelnik 1,231 38% 0d 02:19:49h 37 3.34% 3.34% 65 0.57
6  No CountrySETB | ja ti dam>:D 1,151 66% 0d 07:59:06h 38 3.43% 3.43% 214 0.18
7  No CountrySETB | poštěváček 1,114 42% 0d 00:32:06h 37 3.34% 3.34% 17 2.18
8  No CountrySETB | Jenda 1,068 63% 0d 00:55:10h 8 0.72% 0.72% 25 0.32
9  No CountrySETB | ddw69 1,054 29% 0d 00:18:32h 4 0.36% 0.36% 9 0.44
10  No CountrySETB | AnF4anger fastdrop 1,044 49% 0d 01:52:57h 20 1.81% 1.81% 55 0.36
11  No CountrySETB | Folwiii 1,042 13% 0d 00:44:01h 5 0.45% 0.45% 23 0.22
12  No CountrySETB | jL 1,039 36% 0d 00:32:08h 11 0.99% 0.99% 17 0.65
13  No CountrySETB | dneska to jede 1,030 58% 0d 00:34:22h 11 0.99% 0.99% 23 0.48
14  No CountrySETB | Mikulas Vareha 1,028 62% 0d 00:26:03h 9 0.81% 0.81% 15 0.60
15  No CountrySETB | Spawn 1,024 99% 0d 01:48:35h 24 2.17% 2.17% 52 0.46
16  No CountrySETB | macko usko 1,023 11% 0d 00:23:27h 1 0.09% 0.09% 7 0.14
17  No CountrySETB | Jochec 1,013 100% 0d 00:18:04h 5 0.45% 0.45% 6 0.83
18  No CountrySETB | Moisokita 1,012 45% 0d 00:43:29h 5 0.45% 0.45% 15 0.33
19  No CountrySETB | raker3 1,011 40% 0d 00:22:07h 3 0.27% 0.27% 6 0.50
20  No CountrySETB | Blecha :) 1,010 26% 0d 00:03:26h 0 0.00% 0.00% 3 0.00


Page: 1 2




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 83 times 83
2 Spawn with the Bomb 49 times 98
3 Drop the Bomb 41 times -82
4 Double Kill (2 kills) 37 times 37
5 Pick up the Bomb 21 times 42
6 Plant the Bomb 17 times 255
7 Triple Kill (3 kills) 9 times 18
8 Domination (4 kills) 5 times 15
9 Rampage (5 kills) 2 times 8




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Terrorist 97 times 56.40% 56.40%
2 Counter-Terrorist 73 times 42.44% 42.44%




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