noAim HLstatsX - Counter-Strike: Source - Clan Details

Clan Information

Statistics Summary
Clan:	RSPKTSCHELLE
Home Page:
Activity:		81.00%
Members:	21 active members (32 total)
Avg. Member Points:	30,430
Total Kills:	216,663
Total Deaths:	133,639
Avg. Kills:	10,317
Kills per Death:	1.62
Kills per Minute:	0.74
Total Connection Time:	203d 06:53:06h
Avg. Connection Time:	9d 16:19:40h
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	ϻafia		61,893		16d 11:51:29h	26,979		12.45%	9,116	2.96
2	. J o k e r J o e #		55,654		15d 13:55:05h	21,671		10.00%	8,358	2.59
3	red_bairn		47,200		23d 12:11:47h	26,649		12.30%	14,646	1.82
4	ᶨᵘᶨᵘ ♥		47,037		10d 21:46:41h	12,754		5.89%	5,746	2.22
5	Le`FuXx		45,916		13d 02:51:34h	17,431		8.05%	8,170	2.13
6	[PL] Apfelasch		44,081		15d 02:10:02h	14,884		6.87%	9,483	1.57
7	✪plexx♛[♥]		40,640		5d 01:18:05h	6,535		3.02%	2,702	2.42
8	Schwento		38,050		19d 17:49:31h	16,012		7.39%	13,040	1.23
9	PiLziPiLz		37,839		23d 12:17:37h	24,245		11.19%	17,790	1.36
10	g1N^		34,705		19d 14:32:43h	18,782		8.67%	16,202	1.16
11	Saiya'7		32,148		9d 16:11:10h	9,206		4.25%	6,847	1.34
12	SOX		28,684		5d 16:52:17h	5,409		2.50%	3,571	1.51
13	DaDa Life		25,325		4d 15:37:03h	4,194		1.94%	3,473	1.21
14	// k a r L ´s Я ∪ s h		23,725		12d 02:02:07h	5,196		2.40%	9,008	0.58
15	VOGELSBERGER <AᵗzεHᵃʰᵑ>		20,411		4d 07:40:39h	3,088		1.43%	2,681	1.15
16	S 1 N O X x		18,477		1d 14:15:39h	1,527		0.70%	1,120	1.36
17	HEADSHEET ©		16,996		1d 12:02:38h	1,204		0.56%	951	1.27
18	ĐДЯKŜPΞΞĐЎ[GER]		10,405		0d 12:49:45h	521		0.24%	306	1.70
19	qNNL ³		4,488		0d 07:18:39h	180		0.08%	217	0.83
20	n1		4,209		0d 05:26:13h	164		0.08%	145	1.13

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Headshot	6,712 times	6,712
2	Double Kill (2 kills)	2,050 times	2,050
3	Triple Kill (3 kills)	1,038 times	2,076
4	Pick up the Bomb	919 times	2,757
5	Drop the Bomb	537 times	-1611
6	Domination (4 kills)	484 times	1,452
7	Plant the Bomb	322 times	1,932
8	Rampage (5 kills)	188 times	752
9	Start Defusing the Bomb With a Defuse Kit	116 times	0
10	Defuse the Bomb	78 times	780
11	Mega Kill (6 kills)	71 times	355
12	Ownage (7 kills)	21 times	126
13	Ultra Kill (8 kills)	8 times	56
14	Killing Spree (9 kills)	2 times	16
15	Start Defusing the Bomb Without a Defuse Kit	1 times	0
16	Monster Kill (10 kills)	1 times	9

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Terrorist	658 times		29.59%
2	Counter-Terrorist	606 times		27.25%

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