Kotelna - Dust2 only - Clan Details - [I]n[L]ove[S]v[K] I]n[L]ove[S]v[K

Sections

Clan Information

Statistics Summary
Clan:	I]n[L]ove[S]v[K
Home Page:
Activity:		81.00%
Members:	1 active members (5 total)
Avg. Member Points:	130,572
Total Kills:	23,947
Total Deaths:	9,315
Avg. Kills:	23,947
Kills per Death:	2.57
Kills per Minute:	1.12
Total Connection Time:	14d 19:40:28h
Avg. Connection Time:	14d 19:40:28h
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	[I]n[L]ove[S]v[K]_	130,572		14d 19:40:28h	23,947		100.00%	9,315	2.57

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Defuse the Bomb	1 times	15
2	Ownage (7 kills)	1 times	6
3	Start Defusing the Bomb With a Defuse Kit	1 times	0
4	Ultra Kill (8 kills)	1 times	7
5	Mega Kill (6 kills)	2 times	10
6	Rampage (5 kills)	10 times	40
7	Drop the Bomb	17 times	-34
8	Domination (4 kills)	20 times	60
9	Pick up the Bomb	25 times	50
10	Plant the Bomb	27 times	405
11	Spawn with the Bomb	28 times	56
12	Triple Kill (3 kills)	32 times	64
13	Double Kill (2 kills)	64 times	64
14	Headshot	186 times	186

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Terrorist	26 times		52.00%
2	Counter-Terrorist	3 times		6.00%

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