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

Sections

Clan Information

Statistics Summary
Clan:	LGG
Home Page:
Activity:		85.86%
Members:	15 active members (32 total)
Avg. Member Points:	668
Total Kills:	373,177
Total Deaths:	329,657
Avg. Kills:	24,878
Kills per Death:	1.13
Kills per Minute:	2.46
Total Connection Time:	105d 13:25:44h
Avg. Connection Time:	7d 00:53:42h
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	* LGG * Infidel	1,000		0d 00:08:45h	0		0.00%	0	0.00
2	* LGG * AssassiN	1,000		0d 00:04:56h	0		0.00%	0	0.00
3	* LGG * SOULJA SOYBOY	803		16d 14:48:18h	75,180		20.15%	51,939	1.45
4	* LGG *THE ICON★	769		8d 03:50:20h	42,980		11.52%	36,557	1.18
5	* LGG * Rider . Qc	764		1d 04:31:14h	4,747		1.27%	3,881	1.22
6	* LGG * HARMLESS	718		7d 07:48:52h	26,255		7.04%	23,856	1.10
7	* LGG * McBAIN!	631		1d 17:42:23h	6,908		1.85%	7,001	0.99
8	* LGG * MajorBuck(GRANDPA)	616		13d 10:43:29h	47,911		12.84%	33,762	1.42
9	* LGG * WARPAW	615		1d 17:29:59h	6,249		1.67%	5,859	1.07
10	* LGG * Moo	591		3d 00:48:16h	11,176		2.99%	9,196	1.22
11	* LGG * stefke	581		11d 07:07:22h	36,834		9.87%	32,456	1.13
12	* LGG * SpitzSox -=PHX=- {EMT}	537		34d 08:36:11h	97,015		26.00%	96,053	1.01
13	* LGG * Spartantrooper7	533		0d 19:04:17h	1,714		0.46%	2,665	0.64
14	* LGG * Jimmy Respawn	469		0d 03:17:41h	331		0.09%	490	0.68
15	* LGG * YaYa	390		5d 17:23:41h	15,877		4.25%	25,942	0.61

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Unstoppable (11 kills)	10 times	100
2	Monster Kill (10 kills)	11 times	99
3	Bomb Planter Killed	14 times	28
4	God Like (12+ kills)	22 times	242
5	Killing Spree (9 kills)	24 times	192
6	Ultra Kill (8 kills)	46 times	322
7	Ownage (7 kills)	93 times	558
8	Mega Kill (6 kills)	172 times	860
9	Bomb Planted	279 times	558
10	Rampage (5 kills)	332 times	1,328
11	Domination (4 kills)	702 times	2,106
12	Triple Kill (3 kills)	1,316 times	2,632
13	Double Kill (2 kills)	2,624 times	2,624

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	1,156 times		28.71%
2	Allies	532 times		13.21%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	1,687 times	94.30%		20,428	17,721	1.15
2	Axis Unteroffizier	42 times	2.35%		702	542	1.30
3	American Master Sergeant	26 times	1.45%		414	370	1.12
4	Axis Sturmtruppe	15 times	0.84%		168	132	1.27
5	American Rifleman	15 times	0.84%		171	136	1.26
6	Axis Scharfschütze	3 times	0.17%		32	24	1.33
7	Axis MG42-Schütze	1 times	0.06%		8	6	1.33

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	1,501		0.40%	0		0.00%	0.00
2		1.50	1,014		0.27%	0		0.00%	0.00
3		3.00	3,928		1.05%	0		0.00%	0.00
4		3.00	66		0.02%	0		0.00%	0.00
5		2.25	538		0.14%	0		0.00%	0.00
6		1.50	503		0.13%	0		0.00%	0.00
7		1.35	1,238		0.33%	0		0.00%	0.00
8		1.25	1,482		0.40%	0		0.00%	0.00
9		1.20	999		0.27%	0		0.00%	0.00
10		1.20	1,389		0.37%	0		0.00%	0.00
11		1.50	947		0.25%	0		0.00%	0.00
12		1.30	1,196		0.32%	0		0.00%	0.00
13		1.30	1,282		0.34%	0		0.00%	0.00
14		1.00	445		0.12%	0		0.00%	0.00
15		1.00	282		0.08%	0		0.00%	0.00
16		1.00	180		0.05%	0		0.00%	0.00
17		1.60	505		0.14%	0		0.00%	0.00
18		1.50	1,455		0.39%	0		0.00%	0.00
19		2.25	758		0.20%	0		0.00%	0.00
20		1.20	1,214		0.33%	0		0.00%	0.00
21		3.00	170		0.05%	0		0.00%	0.00
22		1.25	970		0.26%	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 / 373177 * 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