Kotelna - Dust2 only - Clan Details - SETB

Sections

Clan Information

Statistics Summary
Clan:	SETB
Home Page:
Activity:		57.15%
Members:	89 active members (800 total)
Avg. Member Points:	1,105
Total Kills:	1,485
Total Deaths:	2,826
Avg. Kills:	17
Kills per Death:	0.53
Kills per Minute:	0.24
Total Connection Time:	4d 05:09:06h
Avg. Connection Time:	0d 01:08:11h
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 \| ananasko	2,731		0d 04:34:08h	248		16.70%	143	1.73
2	SETB \| ;;j	2,276		0d 05:06:36h	180		12.12%	143	1.26
3	SETB \| erik	1,976		0d 16:51:02h	165		11.11%	456	0.36
4	SETB \| kura na paprike	1,905		0d 07:52:38h	160		10.77%	272	0.59
5	SETB \| Spitfire2	1,791		0d 09:28:00h	70		4.71%	295	0.24
6	SETB \| Klaudy	1,683		0d 05:20:14h	72		4.85%	122	0.59
7	SETB \| Mcgej	1,653		0d 02:12:00h	103		6.94%	78	1.32
8	SETB \| ferko	1,351		0d 02:39:46h	63		4.24%	69	0.91
9	SETB \| kadet BOHUMIL Kulomet	1,194		0d 01:05:16h	41		2.76%	32	1.28
10	SETB \| ja ti dam>:D	1,169		0d 09:02:16h	40		2.69%	243	0.16
11	SETB \| Spawn	1,153		0d 03:09:05h	47		3.16%	91	0.52
12	SETB \| AUGI	1,153		0d 00:40:50h	8		0.54%	19	0.42
13	SETB \| neuro	1,099		0d 02:50:20h	28		1.89%	78	0.36
14	SETB \| JeboZLesaSK	1,089		0d 00:41:03h	4		0.27%	13	0.31
15	SETB \| vyhul_babe_hrabe	1,084		0d 00:46:22h	8		0.54%	19	0.42
16	SETB \| nole	1,075		0d 00:33:23h	3		0.20%	21	0.14
17	SETB \| bioS	1,073		0d 00:42:48h	5		0.34%	20	0.25
18	SETB \| jenda	1,069		0d 00:57:57h	9		0.61%	26	0.35
19	SETB \| paliss	1,061		0d 00:48:15h	19		1.28%	22	0.86
20	SETB \| paulito 1.6	1,060		0d 01:02:16h	11		0.74%	35	0.31

Page: 1 2 3 4 5

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot	242 times	242
2	Spawn with the Bomb	142 times	284
3	Drop the Bomb	138 times	-276
4	Double Kill (2 kills)	99 times	99
5	Pick up the Bomb	74 times	148
6	Plant the Bomb	41 times	615
7	Triple Kill (3 kills)	32 times	64
8	Domination (4 kills)	10 times	30
9	Defuse the Bomb	5 times	75
10	Start Defusing the Bomb Without a Defuse Kit	3 times	0
11	Start Defusing the Bomb With a Defuse Kit	3 times	0
12	Rampage (5 kills)	3 times	12
13	Ultra Kill (8 kills)	1 times	7
14	Ownage (7 kills)	1 times	6
15	Mega Kill (6 kills)	1 times	5

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Counter-Terrorist	205 times		50.87%
2	Terrorist	170 times		42.18%

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