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

Sections

Clan Information

Statistics Summary
Clan:	__
Home Page:
Activity:		64.23%
Members:	13 active members (65 total)
Avg. Member Points:	4,958
Total Kills:	2,768
Total Deaths:	4,765
Avg. Kills:	213
Kills per Death:	0.58
Kills per Minute:	0.27
Total Connection Time:	7d 05:14:08h
Avg. Connection Time:	0d 13:19:32h
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	___sadler_____	1,000		0d 00:09:50h	0		0.00%	0	0.00
2	___Kokolino____	1,000		0d 00:04:54h	0		0.00%	0	0.00
3	hothyfaa___	1,000		0d 00:17:40h	0		0.00%	0	0.00
4	A_________	1,000		0d 00:04:39h	0		0.00%	0	0.00
5	813________________________	1,000		0d 00:04:39h	0		0.00%	0	0.00
6	___fuzzytr1cK	1,000		0d 00:01:35h	0		0.00%	2	0.00
7	AUDI____RS3____	1,000		0d 00:04:42h	0		0.00%	0	0.00
8	SigSauer____	1,000		0d 00:09:49h	0		0.00%	0	0.00
9	kenzo____	1,000		0d 00:27:53h	0		0.00%	0	0.00
10	a___	1,018		0d 00:36:38h	3		0.11%	5	0.60
11	СИЛНИ УСЕЩАНИЯ____	1,069		0d 00:34:33h	14		0.51%	16	0.88
12	___uncLe'charLy	3,711		0d 05:23:29h	150		5.42%	122	1.23
13	___Slabiq___	49,655		6d 21:13:47h	2,601		93.97%	4,620	0.56

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Triple Kill (3 kills)	10 times	20
2	Start Defusing the Bomb Without a Defuse Kit	7 times	0
3	Start Defusing the Bomb With a Defuse Kit	2 times	0
4	Spawn with the Bomb	58 times	116
5	Rampage (5 kills)	2 times	8
6	Plant the Bomb	23 times	345
7	Pick up the Bomb	23 times	46
8	Headshot	115 times	115
9	Drop the Bomb	45 times	-90
10	Double Kill (2 kills)	85 times	85
11	Domination (4 kills)	4 times	12
12	Defuse the Bomb	4 times	60

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Terrorist	49 times		62.03%
2	Counter-Terrorist	30 times		37.97%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.50	28		1.01%	6		0.77%	0.21
2		1.00	1		0.04%	0		0.00%	0.00
3		1.50	1		0.04%	0		0.00%	0.00
4		1.25	4		0.14%	2		0.26%	0.50
5		1.00	87		3.14%	31		3.99%	0.36
6		1.80	22		0.79%	0		0.00%	0.00
7		1.50	14		0.51%	5		0.64%	0.36
8		1.00	7		0.25%	2		0.26%	0.29
9		1.00	33		1.19%	13		1.68%	0.39
10		1.50	71		2.57%	15		1.93%	0.21
11		1.40	64		2.31%	2		0.26%	0.03
12		1.00	155		5.60%	39		5.03%	0.25

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		5,415	659	21,091	39	153	0.7427	12.2%	32.0	35.4
2		3,473	404	11,634	32	89	0.7479	11.6%	28.8	39.0
3		1,496	267	10,040	15	71	0.6017	17.8%	37.6	21.1
4		281	70	8,087	2	62	1.3191	24.9%	115.5	4.5
5		1,407	167	4,354	14	33	0.5500	11.9%	26.1	42.6
6		922	197	3,984	6	28	0.4179	21.4%	20.2	32.9
7		455	355	8,420	0	21	1.6154	78.0%	23.7	21.7
8		533	96	1,702	5	15	0.5556	18.0%	17.7	35.5
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		179	31	481	2	4	0.8000	17.3%	15.5	44.8
12		8	2	84	0	1	1.0000	25.0%	42.0	8.0
13		213	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		659	47.2%	34.3%	18.5%
2		404	43.3%	39.4%	17.3%
3		267	44.6%	32.6%	22.8%
4		197	42.6%	35.5%	21.8%
5		167	41.3%	38.3%	20.4%
6		96	36.5%	44.8%	18.8%
7		70	55.7%	24.3%	20.0%
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 / 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