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

Sections

Clan Information

Statistics Summary
Clan:	LGG
Home Page:
Activity:		87.40%
Members:	15 active members (32 total)
Avg. Member Points:	716
Total Kills:	362,191
Total Deaths:	320,297
Avg. Kills:	24,146
Kills per Death:	1.13
Kills per Minute:	2.45
Total Connection Time:	102d 17:57:49h
Avg. Connection Time:	6d 20:23:51h
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 * SOULJA SOYBOY	857		16d 04:47:01h	73,258		20.23%	50,532	1.45
4	* LGG * stefke	818		10d 17:52:24h	34,960		9.65%	30,835	1.13
5	* LGG * HARMLESS	785		7d 00:02:16h	25,038		6.91%	22,537	1.11
6	* LGG * Rider . Qc	715		1d 04:13:44h	4,681		1.29%	3,834	1.22
7	* LGG * MajorBuck(GRANDPA)	714		12d 21:06:56h	45,874		12.67%	32,383	1.42
8	* LGG *THE ICON★	706		7d 18:00:41h	40,667		11.23%	34,717	1.17
9	* LGG * WARPAW	659		1d 15:49:39h	6,025		1.66%	5,651	1.07
10	* LGG * SpitzSox -=PHX=- {EMT}	641		34d 00:29:59h	96,017		26.51%	94,990	1.01
11	* LGG * Moo	635		3d 00:22:27h	11,148		3.08%	9,163	1.22
12	* LGG * YaYa	619		5d 16:46:41h	15,814		4.37%	25,812	0.61
13	* LGG * Spartantrooper7	588		0d 18:47:04h	1,686		0.47%	2,624	0.64
14	* LGG * McBAIN!	538		1d 17:04:38h	6,809		1.88%	6,890	0.99
15	* LGG * Jimmy Respawn	462		0d 02:20:38h	214		0.06%	329	0.65

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	3,380 times	3,380
2	Triple Kill (3 kills)	1,661 times	3,322
3	Domination (4 kills)	848 times	2,544
4	Bomb Planted	495 times	990
5	Rampage (5 kills)	417 times	1,668
6	Mega Kill (6 kills)	193 times	965
7	Ownage (7 kills)	119 times	714
8	Ultra Kill (8 kills)	62 times	434
9	Killing Spree (9 kills)	39 times	312
10	God Like (12+ kills)	30 times	330
11	Monster Kill (10 kills)	19 times	171
12	Unstoppable (11 kills)	10 times	100
13	Bomb Planter Killed	8 times	16

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	1,475 times		27.61%
2	Allies	796 times		14.90%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	2,270 times	95.50%		26,585	23,938	1.11
2	Axis Unteroffizier	49 times	2.06%		768	616	1.25
3	American Master Sergeant	23 times	0.97%		362	282	1.28
4	American Rifleman	18 times	0.76%		175	152	1.15
5	Axis Sturmtruppe	11 times	0.46%		113	98	1.15
6	Axis Scharfschütze	4 times	0.17%		47	30	1.57
7	American Support Infantry	1 times	0.04%		9	9	1.00
8	Axis MG42-Schütze	1 times	0.04%		8	6	1.33

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		3.00	4,795		1.32%	0		0.00%	0.00
2		1.25	2,033		0.56%	0		0.00%	0.00
3		1.25	2,003		0.55%	0		0.00%	0.00
4		1.50	1,990		0.55%	0		0.00%	0.00
5		1.20	1,850		0.51%	0		0.00%	0.00
6		1.30	1,757		0.49%	0		0.00%	0.00
7		1.35	1,639		0.45%	0		0.00%	0.00
8		1.30	1,589		0.44%	0		0.00%	0.00
9		1.20	1,574		0.43%	0		0.00%	0.00
10		1.50	1,324		0.37%	0		0.00%	0.00
11		1.20	1,230		0.34%	0		0.00%	0.00
12		1.50	1,194		0.33%	0		0.00%	0.00
13		1.25	1,181		0.33%	0		0.00%	0.00
14		2.25	891		0.25%	0		0.00%	0.00
15		2.25	603		0.17%	0		0.00%	0.00
16		1.50	572		0.16%	0		0.00%	0.00
17		1.60	554		0.15%	0		0.00%	0.00
18		1.00	479		0.13%	0		0.00%	0.00
19		1.00	381		0.11%	0		0.00%	0.00
20		1.00	290		0.08%	0		0.00%	0.00
21		3.00	169		0.05%	0		0.00%	0.00
22		3.00	40		0.01%	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 / 362191 * 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