Hammer-Terroristen v2.0|www.ht-clan.deHLstatsX - Condition Zero - Clan Details

Clan Information

Statistics Summary
Clan:	RoA
Home Page:
Activity:		99.00%
Members:	1 active members (5 total)
Avg. Member Points:	6,583
Total Kills:	482
Total Deaths:	1,221
Avg. Kills:	482
Kills per Death:	0.39
Kills per Minute:	0.24
Total Connection Time:	1d 08:58:40h
Avg. Connection Time:	1d 08:58:40h
Favorite Server:*	Hammer-Terroristen v2.0\|www.ht-clan.de
Favorite Map:*	de_cocaine
Favorite Weapon:*

Player Locations

Members

Rank	Name	Rank	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	=RoA= Stefanie3108		6,583		1d 08:58:40h	482		100.00%	1,221	0.39

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Spawn with the Bomb	65 times	130
2	Headshot	59 times	59
3	Drop the Bomb	42 times	-84
4	Double Kill (2 kills)	29 times	29
5	Plant the Bomb	18 times	270
6	Pick up the Bomb	10 times	20
7	Triple Kill (3 kills)	4 times	8
8	Start Defusing the Bomb With a Defuse Kit	4 times	0
9	Defuse the Bomb	2 times	30

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Terrorist	25 times		52.08%
2	Counter-Terrorist	20 times		41.67%
3	Spectator	3 times		6.25%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	83		17.22%	36		25.17%	0.43
2		1.00	75		15.56%	17		11.89%	0.23
3		1.50	17		3.53%	3		2.10%	0.18
4		1.50	7		1.45%	1		0.70%	0.14
5		1.50	7		1.45%	2		1.40%	0.29
6		1.00	2		0.41%	0		0.00%	0.00
7		1.25	1		0.21%	0		0.00%	0.00
8		1.00	1		0.21%	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		1,800	329	12,347	36	84	0.7850	18.3%	37.5	21.4
2		1,923	340	9,119	18	73	0.7019	17.7%	26.8	26.3
3		251	78	3,010	3	17	0.3953	31.1%	38.6	14.8
4		170	55	1,092	1	7	0.3889	32.4%	19.9	24.3
5		127	44	870	1	6	0.5000	34.6%	19.8	21.2
6		61	13	243	0	2	0.6667	21.3%	18.7	30.5
7		68	11	130	0	1	0.2500	16.2%	11.8	68.0
8		32	8	166	0	1	1.0000	25.0%	20.8	32.0
9		3	0	0	0	0	0.0000	0.0%	0.0	0.0
10		40	0	0	0	0	0.0000	0.0%	0.0	0.0
11		50	3	28	0	0	0.0000	6.0%	9.3	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		340	44.1%	32.4%	23.5%
2		329	40.4%	41.0%	18.5%
3		78	48.7%	37.2%	14.1%
4		55	43.6%	38.2%	18.2%
5		44	56.8%	22.7%	20.5%
6		13	61.5%	23.1%	15.4%
7		11	36.4%	36.4%	27.3%
8		8	50.0%	37.5%	12.5%

Targets

Show total target statistics

ERROR

Database Error

Server Address: localhost
Server Username: hlstatsx

Error Diagnostic:
Bad query.

Server Error: (1052) Column 'map' in ORDER BY is ambiguous

Last SQL Query:

		SELECT *, 
			IFNULL(kills/deaths, '-') AS kpd,
			IFNULL(headshots / kills, '-') AS hpk,
			ROUND(kills / 482 * 100, 2) AS kpercent,
			ROUND(headshots / 143 * 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