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

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	Random	1,663 times	93.90%		20,535	17,361	1.18
2	Axis Unteroffizier	47 times	2.65%		789	612	1.29
3	American Master Sergeant	27 times	1.52%		442	393	1.12
4	Axis Sturmtruppe	16 times	0.90%		198	141	1.40
5	American Rifleman	13 times	0.73%		140	112	1.25
6	Axis Scharfschütze	4 times	0.23%		32	24	1.33
7	Axis Grenadier	1 times	0.06%		17	11	1.55

Weapon Usage *

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