Kotelna - Dust2 only - Clan Details - SETB

Sections

Clan Information

Statistics Summary
Clan:	SETB
Home Page:
Activity:		56.44%
Members:	94 active members (846 total)
Avg. Member Points:	1,172
Total Kills:	2,489
Total Deaths:	5,340
Avg. Kills:	26
Kills per Death:	0.47
Kills per Minute:	0.21
Total Connection Time:	8d 02:38:16h
Avg. Connection Time:	0d 02:04:14h
Favorite Server:*	csko.cz \| dust2 only
Favorite Map:*	de_dust2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	SETB \| kokoska	3,273		1d 08:14:37h	339		13.62%	921	0.37
2	SETB \| wegeta	3,085		0d 17:27:53h	184		7.39%	480	0.38
3	SETB \| neviem to hrat	2,497		0d 17:00:18h	174		6.99%	459	0.38
4	SETB \| ;;j	2,453		0d 06:01:53h	210		8.44%	166	1.27
5	SETB \| sn1per	2,306		0d 03:37:48h	169		6.79%	67	2.52
6	SETB \| jablon	2,196		0d 11:17:13h	163		6.55%	311	0.52
7	SETB \| erik	1,999		0d 17:43:06h	175		7.03%	478	0.37
8	SETB \| kura na paprike	1,905		0d 07:52:38h	160		6.43%	272	0.59
9	SETB \| Spitfire2	1,791		0d 09:28:00h	70		2.81%	295	0.24
10	SETB \| skoricovy_trdelnik	1,558		0d 04:24:43h	83		3.33%	117	0.71
11	SETB \| ferko	1,498		0d 03:34:48h	78		3.13%	86	0.91
12	SETB \| Spawn	1,284		0d 04:38:23h	74		2.97%	130	0.57
13	SETB \| lili	1,266		0d 04:45:56h	52		2.09%	119	0.44
14	SETB \| ja ti dam>:D	1,194		0d 09:22:41h	40		1.61%	251	0.16
15	SETB \| Arwi	1,189		0d 01:14:23h	37		1.49%	34	1.09
16	SETB \| Bila Hus 52	1,182		0d 01:49:17h	37		1.49%	33	1.12
17	SETB \| smradlavanoha	1,147		0d 01:12:32h	15		0.60%	31	0.48
18	SETB \| [SuperBOOST]CS-DOWNLOAD	1,109		0d 01:06:42h	19		0.76%	30	0.63
19	SETB \| Fogooo	1,105		0d 00:41:19h	15		0.60%	23	0.65
20	SETB \| fuckyou	1,091		0d 00:37:26h	15		0.60%	16	0.94

Page: 1 2 3 4 5

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot	428 times	428
2	Spawn with the Bomb	224 times	448
3	Double Kill (2 kills)	223 times	223
4	Drop the Bomb	209 times	-418
5	Pick up the Bomb	118 times	236
6	Plant the Bomb	83 times	1,245
7	Triple Kill (3 kills)	50 times	100
8	Start Defusing the Bomb With a Defuse Kit	12 times	0
9	Domination (4 kills)	8 times	24
10	Start Defusing the Bomb Without a Defuse Kit	6 times	0
11	Defuse the Bomb	5 times	75
12	Rampage (5 kills)	4 times	16
13	Ownage (7 kills)	1 times	6
14	Mega Kill (6 kills)	1 times	5

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Counter-Terrorist	302 times		47.63%
2	Terrorist	301 times		47.48%

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