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

Sections

Clan Information

Statistics Summary
Clan:	LGG
Home Page:
Activity:		80.20%
Members:	15 active members (32 total)
Avg. Member Points:	667
Total Kills:	372,390
Total Deaths:	329,053
Avg. Kills:	24,826
Kills per Death:	1.13
Kills per Minute:	2.46
Total Connection Time:	105d 08:04:41h
Avg. Connection Time:	7d 00:32:18h
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}	417		34d 08:23:12h	96,991		26.05%	96,026	1.01
2	* LGG * SOULJA SOYBOY	674		16d 14:18:45h	75,091		20.16%	51,898	1.45
3	* LGG * MajorBuck(GRANDPA)	740		13d 09:51:11h	47,779		12.83%	33,680	1.42
4	* LGG * stefke	748		11d 04:47:20h	36,502		9.80%	32,208	1.13
5	* LGG *THE ICON★	706		8d 03:28:24h	42,898		11.52%	36,499	1.18
6	* LGG * HARMLESS	621		7d 07:37:43h	26,223		7.04%	23,838	1.10
7	* LGG * YaYa	390		5d 17:23:41h	15,877		4.26%	25,942	0.61
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.86%	7,001	0.99
10	* LGG * WARPAW	686		1d 17:02:09h	6,195		1.66%	5,795	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	454		0d 03:09:38h	317		0.09%	465	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,569 times	2,569
2	Triple Kill (3 kills)	1,280 times	2,560
3	Domination (4 kills)	685 times	2,055
4	Rampage (5 kills)	330 times	1,320
5	Bomb Planted	271 times	542
6	Mega Kill (6 kills)	170 times	850
7	Ownage (7 kills)	92 times	552
8	Ultra Kill (8 kills)	47 times	329
9	Killing Spree (9 kills)	24 times	192
10	God Like (12+ kills)	20 times	220
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,147 times		28.96%
2	Allies	511 times		12.90%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	1,657 times	94.52%		20,095	17,434	1.15
2	Axis Unteroffizier	40 times	2.28%		675	524	1.29
3	American Master Sergeant	22 times	1.25%		335	321	1.04
4	Axis Sturmtruppe	15 times	0.86%		168	132	1.27
5	American Rifleman	15 times	0.86%		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,890		1.04%	0		0.00%	0.00
2		1.25	1,473		0.40%	0		0.00%	0.00
3		1.25	1,453		0.39%	0		0.00%	0.00
4		1.50	1,427		0.38%	0		0.00%	0.00
5		1.20	1,351		0.36%	0		0.00%	0.00
6		1.30	1,256		0.34%	0		0.00%	0.00
7		1.35	1,212		0.33%	0		0.00%	0.00
8		1.20	1,191		0.32%	0		0.00%	0.00
9		1.30	1,171		0.31%	0		0.00%	0.00
10		1.50	994		0.27%	0		0.00%	0.00
11		1.20	981		0.26%	0		0.00%	0.00
12		1.25	953		0.26%	0		0.00%	0.00
13		1.50	927		0.25%	0		0.00%	0.00
14		2.25	745		0.20%	0		0.00%	0.00
15		2.25	518		0.14%	0		0.00%	0.00
16		1.60	489		0.13%	0		0.00%	0.00
17		1.50	484		0.13%	0		0.00%	0.00
18		1.00	430		0.12%	0		0.00%	0.00
19		1.00	269		0.07%	0		0.00%	0.00
20		1.00	178		0.05%	0		0.00%	0.00
21		3.00	163		0.04%	0		0.00%	0.00
22		3.00	68		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 / 372390 * 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