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

Sections

Clan Information

Statistics Summary
Clan:	GA
Home Page:
Activity:		85.00%
Members:	3 active members (12 total)
Avg. Member Points:	746
Total Kills:	12,306
Total Deaths:	12,759
Avg. Kills:	4,102
Kills per Death:	0.96
Kills per Minute:	2.79
Total Connection Time:	3d 01:35:59h
Avg. Connection Time:	1d 00:31:59h
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	[GA]Major General Adolf Galland	992		0d 00:02:18h	0		0.00%	4	0.00
2	[GA] R U S T Y	702		0d 22:07:41h	4,654		37.82%	3,582	1.30
3	[GA] Trailer Park Boy	543		2d 03:26:00h	7,652		62.18%	9,173	0.83

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Unstoppable (11 kills)	1 times	10
2	Ultra Kill (8 kills)	7 times	49
3	Triple Kill (3 kills)	187 times	374
4	Rampage (5 kills)	37 times	148
5	Ownage (7 kills)	5 times	30
6	Monster Kill (10 kills)	3 times	27
7	Mega Kill (6 kills)	16 times	80
8	Killing Spree (9 kills)	2 times	16
9	God Like (12+ kills)	1 times	11
10	Double Kill (2 kills)	463 times	463
11	Domination (4 kills)	94 times	282

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Allies	216 times		25.93%
2	Axis	181 times		21.73%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	397 times	100.00%		3,437	3,998	0.86

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	338		2.75%	0		0.00%	0.00
2		1.25	316		2.57%	0		0.00%	0.00
3		1.50	290		2.36%	0		0.00%	0.00
4		1.20	282		2.29%	0		0.00%	0.00
5		1.30	256		2.08%	0		0.00%	0.00
6		1.30	245		1.99%	0		0.00%	0.00
7		1.35	223		1.81%	0		0.00%	0.00
8		1.20	205		1.67%	0		0.00%	0.00
9		1.50	191		1.55%	0		0.00%	0.00
10		3.00	191		1.55%	0		0.00%	0.00
11		1.20	164		1.33%	0		0.00%	0.00
12		1.50	164		1.33%	0		0.00%	0.00
13		1.25	161		1.31%	0		0.00%	0.00
14		2.25	118		0.96%	0		0.00%	0.00
15		2.25	77		0.63%	0		0.00%	0.00
16		1.50	75		0.61%	0		0.00%	0.00
17		1.60	68		0.55%	0		0.00%	0.00
18		1.00	46		0.37%	0		0.00%	0.00
19		1.00	30		0.24%	0		0.00%	0.00
20		3.00	12		0.10%	0		0.00%	0.00
21		3.00	9		0.07%	0		0.00%	0.00
22		1.00	3		0.02%	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 / 12306 * 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