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

Sections

Clan Information

Statistics Summary
Clan:	LGG
Home Page:
Activity:		87.64%
Members:	14 active members (32 total)
Avg. Member Points:	619
Total Kills:	381,607
Total Deaths:	336,500
Avg. Kills:	27,258
Kills per Death:	1.13
Kills per Minute:	2.46
Total Connection Time:	107d 21:19:29h
Avg. Connection Time:	7d 16:57:06h
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 *THE ICON★	847		8d 04:00:32h	43,024		11.27%	36,591	1.18
2	* LGG * Rider . Qc	733		1d 04:52:00h	4,805		1.26%	3,918	1.23
3	* LGG * the bad as Junglecat!	724		0d 05:33:51h	497		0.13%	558	0.89
4	* LGG * MajorBuck(GRANDPA)	703		13d 22:22:04h	49,892		13.07%	34,980	1.43
5	* LGG * McBAIN!	691		1d 20:52:41h	7,466		1.96%	7,518	0.99
6	* LGG * HARMLESS	674		7d 10:44:22h	26,710		7.00%	24,302	1.10
7	* LGG * SOULJA SOYBOY	644		17d 04:31:36h	77,690		20.36%	53,721	1.45
8	* LGG * WARPAW	621		1d 18:17:01h	6,381		1.67%	5,972	1.07
9	* LGG * stefke	602		11d 14:14:17h	37,730		9.89%	33,242	1.14
10	* LGG * SpitzSox -=PHX=- {EMT}	551		34d 17:15:01h	98,048		25.69%	97,151	1.01
11	* LGG * Spartantrooper7	548		0d 19:14:53h	1,736		0.45%	2,695	0.64
12	* LGG * Moo	514		3d 02:27:04h	11,405		2.99%	9,390	1.21
13	* LGG * Jimmy Respawn	425		0d 03:30:26h	346		0.09%	520	0.67
14	* LGG * YaYa	390		5d 17:23:41h	15,877		4.16%	25,942	0.61

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	2,414 times	2,414
2	Triple Kill (3 kills)	1,204 times	2,408
3	Domination (4 kills)	610 times	1,830
4	Rampage (5 kills)	327 times	1,308
5	Mega Kill (6 kills)	186 times	930
6	Ownage (7 kills)	109 times	654
7	Bomb Planted	219 times	438
8	Ultra Kill (8 kills)	49 times	343
9	God Like (12+ kills)	27 times	297
10	Killing Spree (9 kills)	30 times	240
11	Monster Kill (10 kills)	19 times	171
12	Unstoppable (11 kills)	13 times	130
13	Bomb Planter Killed	13 times	26

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	1,043 times		29.09%
2	Allies	475 times		13.25%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	1,514 times	94.68%		19,366	15,984	1.21
2	Axis Unteroffizier	36 times	2.25%		593	455	1.30
3	American Master Sergeant	27 times	1.69%		395	355	1.11
4	Axis Sturmtruppe	13 times	0.81%		152	106	1.43
5	American Rifleman	6 times	0.38%		74	40	1.85
6	Axis Grenadier	1 times	0.06%		17	11	1.55
7	Axis Scharfschütze	2 times	0.13%		13	11	1.18

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		3.00	3,458		0.91%	0		0.00%	0.00
2		1.25	1,353		0.35%	0		0.00%	0.00
3		1.25	1,340		0.35%	0		0.00%	0.00
4		1.50	1,325		0.35%	0		0.00%	0.00
5		1.20	1,291		0.34%	0		0.00%	0.00
6		1.30	1,191		0.31%	0		0.00%	0.00
7		1.35	1,173		0.31%	0		0.00%	0.00
8		1.20	1,137		0.30%	0		0.00%	0.00
9		1.30	1,132		0.30%	0		0.00%	0.00
10		1.50	994		0.26%	0		0.00%	0.00
11		1.20	968		0.25%	0		0.00%	0.00
12		1.25	959		0.25%	0		0.00%	0.00
13		1.50	934		0.24%	0		0.00%	0.00
14		2.25	729		0.19%	0		0.00%	0.00
15		2.25	567		0.15%	0		0.00%	0.00
16		1.50	535		0.14%	0		0.00%	0.00
17		1.60	530		0.14%	0		0.00%	0.00
18		1.00	472		0.12%	0		0.00%	0.00
19		1.00	298		0.08%	0		0.00%	0.00
20		3.00	178		0.05%	0		0.00%	0.00
21		1.00	158		0.04%	0		0.00%	0.00
22		3.00	44		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 / 381607 * 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