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

Sections

Clan Information

Statistics Summary
Clan:	LGG
Home Page:
Activity:		81.53%
Members:	15 active members (32 total)
Avg. Member Points:	662
Total Kills:	375,774
Total Deaths:	331,756
Avg. Kills:	25,052
Kills per Death:	1.13
Kills per Minute:	2.46
Total Connection Time:	106d 04:56:12h
Avg. Connection Time:	7d 01:55:44h
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 *THE ICON★	769		8d 03:50:20h	42,980		11.44%	36,557	1.18
4	* LGG * Rider . Qc	764		1d 04:31:14h	4,747		1.26%	3,881	1.22
5	* LGG * MajorBuck(GRANDPA)	738		13d 13:39:25h	48,416		12.88%	34,076	1.42
6	* LGG * SOULJA SOYBOY	673		16d 20:39:04h	76,254		20.29%	52,682	1.45
7	* LGG * HARMLESS	661		7d 08:48:35h	26,443		7.04%	24,064	1.10
8	* LGG * McBAIN!	645		1d 18:19:16h	7,016		1.87%	7,111	0.99
9	* LGG * WARPAW	615		1d 17:29:59h	6,249		1.66%	5,859	1.07
10	* LGG * Moo	591		3d 00:48:16h	11,176		2.97%	9,196	1.22
11	* LGG * stefke	545		11d 09:04:41h	37,133		9.88%	32,704	1.14
12	* LGG * Spartantrooper7	533		0d 19:04:17h	1,714		0.46%	2,665	0.64
13	* LGG * SpitzSox -=PHX=- {EMT}	532		34d 11:46:02h	97,438		25.93%	96,529	1.01
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.23%	25,942	0.61

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Unstoppable (11 kills)	11 times	110
2	Monster Kill (10 kills)	14 times	126
3	Bomb Planter Killed	15 times	30
4	God Like (12+ kills)	26 times	286
5	Killing Spree (9 kills)	28 times	224
6	Ultra Kill (8 kills)	46 times	322
7	Ownage (7 kills)	102 times	612
8	Mega Kill (6 kills)	182 times	910
9	Bomb Planted	245 times	490
10	Rampage (5 kills)	343 times	1,372
11	Domination (4 kills)	687 times	2,061
12	Triple Kill (3 kills)	1,340 times	2,680
13	Double Kill (2 kills)	2,613 times	2,613

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	1,159 times		29.28%
2	Allies	507 times		12.81%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Axis Grenadier	1 times	0.06%		17	11	1.55
2	Axis Sturmtruppe	16 times	0.90%		198	141	1.40
3	Axis Scharfschütze	4 times	0.23%		32	24	1.33
4	Axis Unteroffizier	47 times	2.65%		789	612	1.29
5	American Rifleman	13 times	0.73%		140	112	1.25
6	Random	1,663 times	93.90%		20,535	17,361	1.18
7	American Master Sergeant	27 times	1.52%		442	393	1.12

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		3.00	3,911		1.04%	0		0.00%	0.00
2		1.25	1,470		0.39%	0		0.00%	0.00
3		1.25	1,458		0.39%	0		0.00%	0.00
4		1.50	1,415		0.38%	0		0.00%	0.00
5		1.20	1,378		0.37%	0		0.00%	0.00
6		1.30	1,278		0.34%	0		0.00%	0.00
7		1.35	1,246		0.33%	0		0.00%	0.00
8		1.20	1,221		0.32%	0		0.00%	0.00
9		1.30	1,205		0.32%	0		0.00%	0.00
10		1.50	1,037		0.28%	0		0.00%	0.00
11		1.20	1,025		0.27%	0		0.00%	0.00
12		1.25	997		0.27%	0		0.00%	0.00
13		1.50	974		0.26%	0		0.00%	0.00
14		2.25	770		0.20%	0		0.00%	0.00
15		2.25	583		0.16%	0		0.00%	0.00
16		1.50	549		0.15%	0		0.00%	0.00
17		1.60	549		0.15%	0		0.00%	0.00
18		1.00	501		0.13%	0		0.00%	0.00
19		1.00	312		0.08%	0		0.00%	0.00
20		3.00	192		0.05%	0		0.00%	0.00
21		1.00	172		0.05%	0		0.00%	0.00
22		3.00	63		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 / 375774 * 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