CS.Sector.bg HLstatsX - Counter-Strike - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	__
Home Page:
Activity:		62.78%
Members:	14 active members (65 total)
Avg. Member Points:	4,675
Total Kills:	2,768
Total Deaths:	4,765
Avg. Kills:	198
Kills per Death:	0.58
Kills per Minute:	0.27
Total Connection Time:	7d 05:18:41h
Avg. Connection Time:	0d 12:22:45h
Favorite Server:*	SECTOR.BG Classic MASSACRE 18+ [Skins][Gore][HLstatsX]
Favorite Map:*	de_dust2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	___Slabiq___	49,655		6d 21:13:47h	2,601		93.97%	4,620	0.56
2	___uncLe'charLy	3,711		0d 05:23:29h	150		5.42%	122	1.23
3	СИЛНИ УСЕЩАНИЯ____	1,069		0d 00:34:33h	14		0.51%	16	0.88
4	a___	1,018		0d 00:36:38h	3		0.11%	5	0.60
5	___Kokolino____	1,000		0d 00:04:54h	0		0.00%	0	0.00
6	hothyfaa___	1,000		0d 00:17:40h	0		0.00%	0	0.00
7	A_________	1,000		0d 00:04:39h	0		0.00%	0	0.00
8	813________________________	1,000		0d 00:04:39h	0		0.00%	0	0.00
9	___fuzzytr1cK	1,000		0d 00:01:35h	0		0.00%	2	0.00
10	AUDI____RS3____	1,000		0d 00:04:42h	0		0.00%	0	0.00
11	SigSauer____	1,000		0d 00:09:49h	0		0.00%	0	0.00
12	kenzo____	1,000		0d 00:27:53h	0		0.00%	0	0.00
13	1.sedoy___	1,000		0d 00:04:33h	0		0.00%	0	0.00
14	___sadler_____	1,000		0d 00:09:50h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Plant the Bomb	26 times	390
2	Spawn with the Bomb	64 times	128
3	Headshot	121 times	121
4	Double Kill (2 kills)	89 times	89
5	Defuse the Bomb	4 times	60
6	Pick up the Bomb	25 times	50
7	Triple Kill (3 kills)	11 times	22
8	Domination (4 kills)	4 times	12
9	Rampage (5 kills)	2 times	8
10	Start Defusing the Bomb Without a Defuse Kit	7 times	0
11	Start Defusing the Bomb With a Defuse Kit	2 times	0
12	Drop the Bomb	47 times	-94

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Terrorist	52 times		61.90%
2	Counter-Terrorist	32 times		38.10%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.50	1		0.04%	0		0.00%	0.00
2		1.00	1		0.04%	0		0.00%	0.00
3		1.25	4		0.14%	2		0.26%	0.50
4		1.00	7		0.25%	2		0.26%	0.29
5		1.50	15		0.54%	5		0.64%	0.33
6		1.80	24		0.87%	0		0.00%	0.00
7		1.50	28		1.01%	6		0.77%	0.21
8		1.00	36		1.30%	13		1.68%	0.36
9		1.40	64		2.31%	2		0.26%	0.03
10		1.50	73		2.64%	15		1.93%	0.21
11		1.00	88		3.18%	32		4.12%	0.36
12		1.00	171		6.18%	44		5.67%	0.26

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		217	0	0	0	0	0.0000	0.0%	0.0	0.0
2		8	2	84	0	1	1.0000	25.0%	42.0	8.0
3		179	31	481	2	4	0.8000	17.3%	15.5	44.8
4		65	14	374	1	4	4.0000	21.5%	26.7	16.3
5		244	30	744	2	7	0.6364	12.3%	24.8	34.9
6		548	99	1,743	5	16	0.5714	18.1%	17.6	34.3
7		475	374	8,936	0	23	1.7692	78.7%	23.9	20.7
8		963	205	4,107	6	28	0.3889	21.3%	20.0	34.4
9		1,522	188	4,807	14	36	0.5806	12.4%	25.6	42.3
10		290	73	8,304	2	62	1.2400	25.2%	113.8	4.7
11		1,531	279	10,384	15	73	0.6033	18.2%	37.2	21.0
12		3,505	411	11,840	33	90	0.7438	11.7%	28.8	38.9
13		5,853	705	23,047	44	169	0.7717	12.0%	32.7	34.6

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		2	50.0%	50.0%	0.0%
2		14	64.3%	35.7%	0.0%
3		30	63.3%	26.7%	10.0%
4		31	38.7%	38.7%	22.6%
5		73	53.4%	27.4%	19.2%
6		99	36.4%	43.4%	20.2%
7		188	39.4%	41.0%	19.7%
8		205	43.9%	34.1%	22.0%
9		279	44.1%	33.3%	22.6%
10		411	43.6%	39.2%	17.3%
11		705	46.7%	34.3%	19.0%

Targets

Show total target statistics

ERROR

Database Error

Server Address: localhost
Server Username: stats_sector

Error Diagnostic:
Bad query.

Server Error: (1052) Column 'map' in order clause is ambiguous

Last SQL Query:

		SELECT *, 
			IFNULL(kills/deaths, '-') AS kpd,
			IFNULL(headshots / kills, '-') AS hpk,
			ROUND(kills / 2768 * 100, 2) AS kpercent,
			ROUND(headshots / 776 * 100, 2) AS hpercent
		FROM
			tmp_clan_kills, tmp_clan_deaths
		WHERE
			tmp_clan_kills.map = tmp_clan_deaths.map
		ORDER BY
			map desc,
			kills desc