HLstatsX Community Edition - Day of Defeat: Source - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	247
Home Page:
Activity:		93.00%
Members:	2 active members (15 total)
Avg. Member Points:	733
Total Kills:	175,583
Total Deaths:	159,810
Avg. Kills:	87,792
Kills per Death:	1.10
Kills per Minute:	3.08
Total Connection Time:	39d 12:39:47h
Avg. Connection Time:	19d 18:19:53h
Favorite Server:*	Adult Gamers Community - DOD:S Gungame
Favorite Map:*	cdc_mario_air_[rm]_[ob1]
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[247] COL Night Raider	854		27d 04:51:57h	130,113		74.10%	113,376	1.15
2	[247] Maj Gen. TriggerFinger	611		12d 07:47:50h	45,470		25.90%	46,434	0.98

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Unstoppable (11 kills)	8 times	80
2	God Like (12+ kills)	10 times	110
3	Monster Kill (10 kills)	10 times	90
4	Bomb Planter Killed	12 times	24
5	Killing Spree (9 kills)	20 times	160
6	Bomb Planted	36 times	72
7	Ownage (7 kills)	50 times	300
8	Ultra Kill (8 kills)	51 times	357
9	Mega Kill (6 kills)	104 times	520
10	Rampage (5 kills)	216 times	864
11	Domination (4 kills)	444 times	1,332
12	Triple Kill (3 kills)	887 times	1,774
13	Double Kill (2 kills)	1,777 times	1,777

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	719 times		38.37%
2	Allies	207 times		11.05%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	926 times	90.25%		13,195	11,705	1.13
2	Axis Unteroffizier	100 times	9.75%		1,640	1,356	1.21

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	46		0.03%	0		0.00%	0.00
2		3.00	64		0.04%	0		0.00%	0.00
3		1.00	153		0.09%	0		0.00%	0.00
4		1.00	342		0.19%	0		0.00%	0.00
5		1.50	377		0.21%	0		0.00%	0.00
6		1.60	394		0.22%	0		0.00%	0.00
7		2.25	493		0.28%	0		0.00%	0.00
8		2.25	650		0.37%	0		0.00%	0.00
9		1.25	768		0.44%	0		0.00%	0.00
10		1.50	770		0.44%	0		0.00%	0.00
11		1.20	806		0.46%	0		0.00%	0.00
12		1.50	819		0.47%	0		0.00%	0.00
13		1.20	860		0.49%	0		0.00%	0.00
14		1.30	864		0.49%	0		0.00%	0.00
15		1.35	872		0.50%	0		0.00%	0.00
16		1.20	890		0.51%	0		0.00%	0.00
17		1.30	899		0.51%	0		0.00%	0.00
18		1.50	905		0.52%	0		0.00%	0.00
19		1.25	913		0.52%	0		0.00%	0.00
20		1.25	929		0.53%	0		0.00%	0.00
21		3.00	2,031		1.16%	0		0.00%	0.00

ERROR

Database Error

Server Address: localhost
Server Username: agc

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 / 175583 * 100, 2) AS kpercent,
			ROUND(headshots / 1 * 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