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

Sections

Clan Information

Statistics Summary
Clan:	HUN
Home Page:
Activity:		81.00%
Members:	2 active members (3 total)
Avg. Member Points:	848
Total Kills:	26,757
Total Deaths:	20,444
Avg. Kills:	13,379
Kills per Death:	1.31
Kills per Minute:	2.82
Total Connection Time:	6d 14:11:53h
Avg. Connection Time:	3d 07:05:56h
Favorite Server:*	Adult Gamers Community - DOD:S Gungame
Favorite Map:*	agc_small_court_hrh_v2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	Norbi (HUN)	696		6d 14:05:59h	26,757		100.00%	20,444	1.31
2	Budapest (HUN)	1,000		0d 00:05:54h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	37 times	37
2	Bomb Planted	26 times	52
3	Triple Kill (3 kills)	20 times	40
4	Domination (4 kills)	11 times	33
5	Rampage (5 kills)	8 times	32
6	Ownage (7 kills)	4 times	24
7	Ultra Kill (8 kills)	2 times	14
8	Mega Kill (6 kills)	2 times	10
9	God Like (12+ kills)	1 times	11

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Allies	14 times		29.79%
2	Axis	8 times		17.02%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	22 times	100.00%		322	210	1.53

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	23		0.09%	0		0.00%	0.00
2		1.50	21		0.08%	0		0.00%	0.00
3		3.00	38		0.14%	0		0.00%	0.00
4		2.25	9		0.03%	0		0.00%	0.00
5		1.50	6		0.02%	0		0.00%	0.00
6		1.35	22		0.08%	0		0.00%	0.00
7		1.25	24		0.09%	0		0.00%	0.00
8		1.20	16		0.06%	0		0.00%	0.00
9		1.20	19		0.07%	0		0.00%	0.00
10		1.50	18		0.07%	0		0.00%	0.00
11		1.30	20		0.07%	0		0.00%	0.00
12		1.30	19		0.07%	0		0.00%	0.00
13		1.00	7		0.03%	0		0.00%	0.00
14		1.00	5		0.02%	0		0.00%	0.00
15		1.00	26		0.10%	0		0.00%	0.00
16		1.60	7		0.03%	0		0.00%	0.00
17		1.50	20		0.07%	0		0.00%	0.00
18		2.25	10		0.04%	0		0.00%	0.00
19		1.20	23		0.09%	0		0.00%	0.00
20		1.25	17		0.06%	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 / 26757 * 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