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

Sections

Clan Information

Statistics Summary
Clan:	ROB
Home Page:
Activity:		95.00%
Members:	1 active members (1 total)
Avg. Member Points:	584
Total Kills:	7,214
Total Deaths:	9,272
Avg. Kills:	7,214
Kills per Death:	0.78
Kills per Minute:	1.47
Total Connection Time:	3d 09:50:25h
Avg. Connection Time:	3d 09:50:25h
Favorite Server:*	Adult Gamers Community - DOD:S Gungame
Favorite Map:*	gg_lego_SpaceTower
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	\|$m0k!n\| - Silverstone ROB	584		3d 09:50:25h	7,214		100.00%	9,272	0.78

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	288 times	288
2	Triple Kill (3 kills)	128 times	256
3	Domination (4 kills)	61 times	183
4	Rampage (5 kills)	24 times	96
5	Mega Kill (6 kills)	12 times	60
6	Ownage (7 kills)	5 times	30
7	Ultra Kill (8 kills)	2 times	14
8	Killing Spree (9 kills)	2 times	16

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Allies	147 times		24.54%
2	Axis	132 times		22.04%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	279 times	100.00%		2,185	2,654	0.82

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	218		3.02%	0		0.00%	0.00
2		1.25	205		2.84%	0		0.00%	0.00
3		1.50	194		2.69%	0		0.00%	0.00
4		1.20	190		2.63%	0		0.00%	0.00
5		1.30	190		2.63%	0		0.00%	0.00
6		2.00	160		2.22%	0		0.00%	0.00
7		1.35	155		2.15%	0		0.00%	0.00
8		1.20	149		2.07%	0		0.00%	0.00
9		1.50	130		1.80%	0		0.00%	0.00
10		3.00	107		1.48%	0		0.00%	0.00
11		1.50	105		1.46%	0		0.00%	0.00
12		1.25	94		1.30%	0		0.00%	0.00
13		1.20	85		1.18%	0		0.00%	0.00
14		2.25	63		0.87%	0		0.00%	0.00
15		2.25	41		0.57%	0		0.00%	0.00
16		1.00	31		0.43%	0		0.00%	0.00
17		1.60	28		0.39%	0		0.00%	0.00
18		1.50	27		0.37%	0		0.00%	0.00
19		1.00	8		0.11%	0		0.00%	0.00
20		1.00	3		0.04%	0		0.00%	0.00
21		10.00	2		0.03%	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 / 7214 * 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