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:	671
Total Kills:	376,772
Total Deaths:	332,528
Avg. Kills:	25,118
Kills per Death:	1.13
Kills per Minute:	2.46
Total Connection Time:	106d 11:06:45h
Avg. Connection Time:	7d 02:20:27h
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.04%	24,143	1.10
8	* LGG * McBAIN!	645		1d 18:19:16h	7,016		1.86%	7,111	0.99
9	* LGG * Moo	591		3d 00:48:16h	11,176		2.97%	9,196	1.22
10	* LGG * stefke	576		11d 11:19:44h	37,467		9.94%	33,021	1.13
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,253 times	2,506
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,448 times	2,448
11	Domination (4 kills)	632 times	1,896
12	Bomb Planter Killed	13 times	26
13	Bomb Planted	233 times	466

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	1,080 times		29.05%
2	Allies	482 times		12.96%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	1,559 times	94.03%		19,341	16,234	1.19
2	Axis Unteroffizier	45 times	2.71%		747	576	1.30
3	American Master Sergeant	28 times	1.69%		408	364	1.12
4	Axis Sturmtruppe	15 times	0.90%		196	134	1.46
5	American Rifleman	7 times	0.42%		66	38	1.74
6	Axis Scharfschütze	3 times	0.18%		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,380		0.37%	0		0.00%	0.00
2		1.50	973		0.26%	0		0.00%	0.00
3		3.00	3,595		0.95%	0		0.00%	0.00
4		3.00	61		0.02%	0		0.00%	0.00
5		2.25	562		0.15%	0		0.00%	0.00
6		1.50	528		0.14%	0		0.00%	0.00
7		1.35	1,183		0.31%	0		0.00%	0.00
8		1.25	1,371		0.36%	0		0.00%	0.00
9		1.20	963		0.26%	0		0.00%	0.00
10		1.20	1,300		0.35%	0		0.00%	0.00
11		1.50	923		0.24%	0		0.00%	0.00
12		1.30	1,134		0.30%	0		0.00%	0.00
13		1.30	1,199		0.32%	0		0.00%	0.00
14		1.00	484		0.13%	0		0.00%	0.00
15		1.00	299		0.08%	0		0.00%	0.00
16		1.00	161		0.04%	0		0.00%	0.00
17		1.60	524		0.14%	0		0.00%	0.00
18		1.50	1,327		0.35%	0		0.00%	0.00
19		2.25	720		0.19%	0		0.00%	0.00
20		1.20	1,153		0.31%	0		0.00%	0.00
21		3.00	174		0.05%	0		0.00%	0.00
22		1.25	945		0.25%	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 / 376772 * 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