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

Sections

Clan Information

Statistics Summary
Clan:	LGG
Home Page:
Activity:		87.78%
Members:	14 active members (32 total)
Avg. Member Points:	616
Total Kills:	381,673
Total Deaths:	336,570
Avg. Kills:	27,262
Kills per Death:	1.13
Kills per Minute:	2.46
Total Connection Time:	107d 21:59:17h
Avg. Connection Time:	7d 16:59: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 *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	556		11d 14:54:05h	37,796		9.90%	33,312	1.13
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	Bomb Planter Killed	13 times	26
2	Unstoppable (11 kills)	13 times	130
3	Monster Kill (10 kills)	19 times	171
4	God Like (12+ kills)	27 times	297
5	Killing Spree (9 kills)	30 times	240
6	Ultra Kill (8 kills)	49 times	343
7	Ownage (7 kills)	109 times	654
8	Mega Kill (6 kills)	187 times	935
9	Bomb Planted	219 times	438
10	Rampage (5 kills)	327 times	1,308
11	Domination (4 kills)	613 times	1,839
12	Triple Kill (3 kills)	1,210 times	2,420
13	Double Kill (2 kills)	2,422 times	2,422

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	1,046 times		29.00%
2	Allies	478 times		13.25%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	1,520 times	94.59%		19,399	16,022	1.21
2	Axis Unteroffizier	37 times	2.30%		602	469	1.28
3	American Master Sergeant	28 times	1.74%		419	373	1.12
4	Axis Sturmtruppe	13 times	0.81%		152	106	1.43
5	American Rifleman	6 times	0.37%		74	40	1.85
6	Axis Grenadier	1 times	0.06%		17	11	1.55
7	Axis Scharfschütze	2 times	0.12%		13	11	1.18

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		3.00	3,460		0.91%	0		0.00%	0.00
2		1.25	1,358		0.36%	0		0.00%	0.00
3		1.25	1,345		0.35%	0		0.00%	0.00
4		1.50	1,330		0.35%	0		0.00%	0.00
5		1.20	1,296		0.34%	0		0.00%	0.00
6		1.30	1,197		0.31%	0		0.00%	0.00
7		1.35	1,178		0.31%	0		0.00%	0.00
8		1.20	1,142		0.30%	0		0.00%	0.00
9		1.30	1,137		0.30%	0		0.00%	0.00
10		1.50	999		0.26%	0		0.00%	0.00
11		1.20	970		0.25%	0		0.00%	0.00
12		1.25	961		0.25%	0		0.00%	0.00
13		1.50	937		0.25%	0		0.00%	0.00
14		2.25	731		0.19%	0		0.00%	0.00
15		2.25	569		0.15%	0		0.00%	0.00
16		1.50	537		0.14%	0		0.00%	0.00
17		1.60	531		0.14%	0		0.00%	0.00
18		1.00	474		0.12%	0		0.00%	0.00
19		1.00	300		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 / 381673 * 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