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

Sections

Clan Information

Statistics Summary
Clan:	__
Home Page:
Activity:		65.76%
Members:	13 active members (64 total)
Avg. Member Points:	4,934
Total Kills:	2,741
Total Deaths:	4,721
Avg. Kills:	211
Kills per Death:	0.58
Kills per Minute:	0.27
Total Connection Time:	7d 04:00:01h
Avg. Connection Time:	0d 13:13:50h
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,345		6d 20:10:14h	2,574		93.91%	4,576	0.56
2	___uncLe'charLy	3,711		0d 05:23:29h	150		5.47%	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	hothyfaa___	1,000		0d 00:12:23h	0		0.00%	0	0.00
6	A_________	1,000		0d 00:04:39h	0		0.00%	0	0.00
7	813________________________	1,000		0d 00:04:39h	0		0.00%	0	0.00
8	___fuzzytr1cK	1,000		0d 00:01:35h	0		0.00%	2	0.00
9	AUDI____RS3____	1,000		0d 00:04:42h	0		0.00%	0	0.00
10	SigSauer____	1,000		0d 00:09:49h	0		0.00%	0	0.00
11	kenzo____	1,000		0d 00:27:53h	0		0.00%	0	0.00
12	1.sedoy___	1,000		0d 00:04:33h	0		0.00%	0	0.00
13	___Kokolino____	1,000		0d 00:04:54h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Start Defusing the Bomb With a Defuse Kit	1 times	0
2	Rampage (5 kills)	2 times	8
3	Defuse the Bomb	3 times	45
4	Domination (4 kills)	5 times	15
5	Start Defusing the Bomb Without a Defuse Kit	7 times	0
6	Triple Kill (3 kills)	13 times	26
7	Pick up the Bomb	25 times	50
8	Plant the Bomb	26 times	390
9	Drop the Bomb	49 times	-98
10	Spawn with the Bomb	64 times	128
11	Double Kill (2 kills)	85 times	85
12	Headshot	119 times	119

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Terrorist	53 times		62.35%
2	Counter-Terrorist	32 times		37.65%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	4		0.15%	2		0.26%	0.50
2		1.00	34		1.24%	13		1.69%	0.38
3		1.00	84		3.06%	31		4.04%	0.37
4		1.50	19		0.69%	7		0.91%	0.37
5		1.00	7		0.26%	2		0.26%	0.29
6		1.00	162		5.91%	40		5.22%	0.25
7		1.50	28		1.02%	6		0.78%	0.21
8		1.50	76		2.77%	16		2.09%	0.21
9		1.40	63		2.30%	2		0.26%	0.03
10		1.00	1		0.04%	0		0.00%	0.00
11		1.50	1		0.04%	0		0.00%	0.00
12		1.80	28		1.02%	0		0.00%	0.00

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		5,735	669	21,663	40	158	0.7149	11.7%	32.4	36.3
2		3,520	405	11,560	32	86	0.6935	11.5%	28.5	40.9
3		1,578	282	10,565	16	76	0.5984	17.9%	37.5	20.8
4		287	72	8,194	2	61	1.2200	25.1%	113.8	4.7
5		1,438	181	4,653	14	34	0.5667	12.6%	25.7	42.3
6		987	198	4,029	6	28	0.3944	20.1%	20.3	35.3
7		471	373	8,990	0	27	2.2500	79.2%	24.1	17.4
8		598	114	2,140	7	20	0.6667	19.1%	18.8	29.9
9		244	30	744	2	7	0.6364	12.3%	24.8	34.9
10		65	14	374	1	4	4.0000	21.5%	26.7	16.3
11		191	31	481	2	4	0.6667	16.2%	15.5	47.8
12		8	2	84	0	1	1.0000	25.0%	42.0	8.0
13		220	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		669	48.0%	33.2%	18.8%
2		405	42.7%	40.2%	17.0%
3		282	43.3%	34.4%	22.3%
4		198	43.4%	33.8%	22.7%
5		181	39.8%	42.0%	18.2%
6		114	36.8%	42.1%	21.1%
7		72	52.8%	27.8%	19.4%
8		31	38.7%	38.7%	22.6%
9		30	63.3%	26.7%	10.0%
10		14	64.3%	35.7%	0.0%
11		2	50.0%	50.0%	0.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 / 2741 * 100, 2) AS kpercent,
			ROUND(headshots / 767 * 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