noAim HLstatsX - Counter-Strike: Source - Clan Details

Clan Information

Statistics Summary
Clan:	RSPKTSCHELLE
Home Page:
Activity:		89.54%
Members:	22 active members (34 total)
Avg. Member Points:	31,216
Total Kills:	186,678
Total Deaths:	120,663
Avg. Kills:	8,485
Kills per Death:	1.55
Kills per Minute:	0.71
Total Connection Time:	181d 19:26:07h
Avg. Connection Time:	8d 06:20:16h
Favorite Server:*	* SchlachtHof :\|: Dust2 Only :\|: Test // noAim.eu
Favorite Map:*	de_dust2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Rank	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	. J o k e r J o e #		59,618		17d 04:35:27h	23,881		12.79%	9,167	2.61
2	Le`FuXx		51,888		15d 15:02:19h	20,801		11.14%	9,764	2.13
3	ᶨᵘᶨᵘ ♥		50,640		12d 15:50:01h	14,797		7.93%	6,655	2.22
4	[PL] Apfelasch		45,929		16d 11:59:08h	16,114		8.63%	10,388	1.55
5	Schwento		42,863		22d 20:18:57h	18,618		9.97%	15,100	1.23
6	✪plexx♛[♥]		42,806		5d 13:45:25h	7,149		3.83%	2,983	2.40
7	Nebu		39,635		12d 05:43:24h	12,565		6.73%	7,683	1.64
8	Borutoo		39,243		4d 22:57:16h	5,292		2.83%	3,499	1.51
9	G1NGH1SKHAN^		39,214		23d 17:19:50h	22,519		12.06%	19,519	1.15
10	Käsetiger		38,721		5d 14:59:01h	5,874		3.15%	4,223	1.39
11	Käsekätzchen		36,847		14d 12:11:50h	9,852		5.28%	10,939	0.90
12	Saiya'7		36,755		11d 00:01:05h	10,497		5.62%	7,784	1.35
13	SOX		30,659		6d 02:00:46h	5,757		3.08%	3,809	1.51
14	rkiii @ töööörrkkeee		28,490		2d 07:47:40h	2,701		1.45%	1,616	1.67
15	F1R3		28,330		1d 22:01:11h	2,535		1.36%	1,140	2.22
16	S 1 N O X x		22,562		2d 05:46:35h	2,170		1.16%	1,601	1.36
17	monu		20,848		3d 23:29:49h	3,498		1.87%	2,916	1.20
18	ĐДЯKŜPΞΞĐЎ[GER]		12,444		0d 17:11:14h	672		0.36%	426	1.58
19	LuRod		10,966		1d 13:55:54h	1,089		0.58%	1,083	1.01
20	n1		4,719		0d 05:57:48h	185		0.10%	161	1.15

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot	6,193 times	6,193
2	Double Kill (2 kills)	1,832 times	1,832
3	Triple Kill (3 kills)	969 times	1,938
4	Pick up the Bomb	774 times	2,322
5	Domination (4 kills)	489 times	1,467
6	Drop the Bomb	477 times	-1431
7	Plant the Bomb	250 times	1,500
8	Rampage (5 kills)	180 times	720
9	Start Defusing the Bomb With a Defuse Kit	122 times	0
10	Defuse the Bomb	80 times	800
11	Mega Kill (6 kills)	53 times	265
12	Ownage (7 kills)	16 times	96
13	Ultra Kill (8 kills)	5 times	35
14	Killing Spree (9 kills)	3 times	24
15	Monster Kill (10 kills)	1 times	9

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Counter-Terrorist	579 times		29.57%
2	Terrorist	568 times		29.01%

ERROR

Database Error

Server Address: localhost
Server Username: hlsx

Error Diagnostic:
Bad query.

Server Error: (1267) Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_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='css'
			AND hlstats_Players.clan=11
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'css'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc