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

Sections

Clan Information

Statistics Summary
Clan:	LGG
Home Page:
Activity:		78.20%
Members:	15 active members (32 total)
Avg. Member Points:	677
Total Kills:	376,723
Total Deaths:	332,473
Avg. Kills:	25,115
Kills per Death:	1.13
Kills per Minute:	2.46
Total Connection Time:	106d 10:44:13h
Avg. Connection Time:	7d 02:18:56h
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 * MajorBuck(GRANDPA)	803		13d 16:01:19h	48,832		12.96%	34,320	1.42
4	* LGG *THE ICON★	769		8d 03:50:20h	42,980		11.41%	36,557	1.18
5	* LGG * Rider . Qc	764		1d 04:31:14h	4,747		1.26%	3,881	1.22
6	* LGG * SOULJA SOYBOY	730		16d 21:08:57h	76,356		20.27%	52,751	1.45
7	* LGG * HARMLESS	686		7d 09:30:54h	26,541		7.05%	24,143	1.10
8	* LGG * stefke	671		11d 10:57:12h	37,418		9.93%	32,966	1.14
9	* LGG * McBAIN!	645		1d 18:19:16h	7,016		1.86%	7,111	0.99
10	* LGG * Moo	591		3d 00:48:16h	11,176		2.97%	9,196	1.22
11	* LGG * WARPAW	563		1d 17:40:47h	6,275		1.67%	5,892	1.07
12	* LGG * Spartantrooper7	548		0d 19:14:53h	1,736		0.46%	2,695	0.64
13	* LGG * SpitzSox -=PHX=- {EMT}	532		34d 11:46:02h	97,438		25.86%	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.21%	25,942	0.61

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Unstoppable (11 kills)	10 times	100
2	Ultra Kill (8 kills)	45 times	315
3	Triple Kill (3 kills)	1,246 times	2,492
4	Rampage (5 kills)	318 times	1,272
5	Ownage (7 kills)	99 times	594
6	Monster Kill (10 kills)	15 times	135
7	Mega Kill (6 kills)	179 times	895
8	Killing Spree (9 kills)	27 times	216
9	God Like (12+ kills)	25 times	275
10	Double Kill (2 kills)	2,442 times	2,442
11	Domination (4 kills)	631 times	1,893
12	Bomb Planter Killed	13 times	26
13	Bomb Planted	233 times	466

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	1,079 times		29.11%
2	Allies	478 times		12.90%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	1,554 times	94.24%		19,305	16,192	1.19
2	Axis Scharfschütze	3 times	0.18%		32	24	1.33
3	Axis Sturmtruppe	15 times	0.91%		196	134	1.46
4	Axis Unteroffizier	45 times	2.73%		747	576	1.30
5	Axis Grenadier	1 times	0.06%		17	11	1.55
6	American Master Sergeant	25 times	1.52%		402	357	1.13
7	American Rifleman	6 times	0.36%		58	32	1.81

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		3.00	3,589		0.95%	0		0.00%	0.00
2		1.25	1,376		0.37%	0		0.00%	0.00
3		1.25	1,367		0.36%	0		0.00%	0.00
4		1.50	1,323		0.35%	0		0.00%	0.00
5		1.20	1,297		0.34%	0		0.00%	0.00
6		1.30	1,195		0.32%	0		0.00%	0.00
7		1.35	1,180		0.31%	0		0.00%	0.00
8		1.20	1,150		0.31%	0		0.00%	0.00
9		1.30	1,131		0.30%	0		0.00%	0.00
10		1.50	971		0.26%	0		0.00%	0.00
11		1.20	960		0.25%	0		0.00%	0.00
12		1.25	942		0.25%	0		0.00%	0.00
13		1.50	921		0.24%	0		0.00%	0.00
14		2.25	717		0.19%	0		0.00%	0.00
15		2.25	561		0.15%	0		0.00%	0.00
16		1.50	527		0.14%	0		0.00%	0.00
17		1.60	523		0.14%	0		0.00%	0.00
18		1.00	484		0.13%	0		0.00%	0.00
19		1.00	299		0.08%	0		0.00%	0.00
20		3.00	174		0.05%	0		0.00%	0.00
21		1.00	161		0.04%	0		0.00%	0.00
22		3.00	61		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 / 376723 * 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