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

Sections

Clan Information

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

Player Actions *

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

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	1,154 times		28.73%
2	Allies	530 times		13.19%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	1,683 times	94.29%		20,400	17,680	1.15
2	Axis Unteroffizier	42 times	2.35%		702	542	1.30
3	American Master Sergeant	26 times	1.46%		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		3.00	3,928		1.05%	0		0.00%	0.00
2		1.25	1,497		0.40%	0		0.00%	0.00
3		1.25	1,478		0.40%	0		0.00%	0.00
4		1.50	1,451		0.39%	0		0.00%	0.00
5		1.20	1,383		0.37%	0		0.00%	0.00
6		1.30	1,279		0.34%	0		0.00%	0.00
7		1.35	1,234		0.33%	0		0.00%	0.00
8		1.20	1,213		0.33%	0		0.00%	0.00
9		1.30	1,194		0.32%	0		0.00%	0.00
10		1.50	1,014		0.27%	0		0.00%	0.00
11		1.20	999		0.27%	0		0.00%	0.00
12		1.25	970		0.26%	0		0.00%	0.00
13		1.50	947		0.25%	0		0.00%	0.00
14		2.25	758		0.20%	0		0.00%	0.00
15		2.25	538		0.14%	0		0.00%	0.00
16		1.60	505		0.14%	0		0.00%	0.00
17		1.50	503		0.13%	0		0.00%	0.00
18		1.00	445		0.12%	0		0.00%	0.00
19		1.00	282		0.08%	0		0.00%	0.00
20		1.00	180		0.05%	0		0.00%	0.00
21		3.00	170		0.05%	0		0.00%	0.00
22		3.00	66		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 / 373149 * 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