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

Sections

Clan Information

Statistics Summary
Clan:	LGG
Home Page:
Activity:		85.64%
Members:	14 active members (32 total)
Avg. Member Points:	625
Total Kills:	381,954
Total Deaths:	336,788
Avg. Kills:	27,282
Kills per Death:	1.13
Kills per Minute:	2.46
Total Connection Time:	107d 23:59:44h
Avg. Connection Time:	7d 17:08:33h
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.26%	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)	715		13d 23:38:41h	50,082		13.11%	35,117	1.43
5	* LGG * McBAIN!	691		1d 20:52:41h	7,466		1.95%	7,518	0.99
6	* LGG * HARMLESS	674		7d 10:44:22h	26,710		6.99%	24,302	1.10
7	* LGG * SpitzSox -=PHX=- {EMT}	667		34d 17:58:51h	98,139		25.69%	97,232	1.01
8	* LGG * SOULJA SOYBOY	644		17d 04:31:36h	77,690		20.34%	53,721	1.45
9	* LGG * WARPAW	621		1d 18:17:01h	6,381		1.67%	5,972	1.07
10	* LGG * stefke	556		11d 14:54:05h	37,796		9.90%	33,312	1.13
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	Killing Spree (9 kills)	29 times	232
5	God Like (12+ kills)	27 times	297
6	Ultra Kill (8 kills)	48 times	336
7	Bomb Planted	214 times	428
8	Ownage (7 kills)	108 times	648
9	Mega Kill (6 kills)	176 times	880
10	Rampage (5 kills)	314 times	1,256
11	Domination (4 kills)	596 times	1,788
12	Double Kill (2 kills)	2,355 times	2,355
13	Triple Kill (3 kills)	1,193 times	2,386

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	1,020 times		29.13%
2	Allies	458 times		13.08%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	1,475 times	94.79%		18,923	15,613	1.21
2	Axis Unteroffizier	32 times	2.06%		516	410	1.26
3	American Master Sergeant	28 times	1.80%		419	373	1.12
4	Axis Sturmtruppe	12 times	0.77%		152	106	1.43
5	American Rifleman	6 times	0.39%		74	40	1.85
6	Axis Scharfschütze	2 times	0.13%		13	11	1.18
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		3.00	3,351		0.88%	0		0.00%	0.00
2		1.25	1,316		0.34%	0		0.00%	0.00
3		1.25	1,301		0.34%	0		0.00%	0.00
4		1.50	1,291		0.34%	0		0.00%	0.00
5		1.20	1,256		0.33%	0		0.00%	0.00
6		1.30	1,161		0.30%	0		0.00%	0.00
7		1.35	1,145		0.30%	0		0.00%	0.00
8		1.20	1,113		0.29%	0		0.00%	0.00
9		1.30	1,105		0.29%	0		0.00%	0.00
10		1.50	972		0.25%	0		0.00%	0.00
11		1.20	948		0.25%	0		0.00%	0.00
12		1.25	932		0.24%	0		0.00%	0.00
13		1.50	911		0.24%	0		0.00%	0.00
14		2.25	712		0.19%	0		0.00%	0.00
15		2.25	560		0.15%	0		0.00%	0.00
16		1.50	530		0.14%	0		0.00%	0.00
17		1.60	522		0.14%	0		0.00%	0.00
18		1.00	471		0.12%	0		0.00%	0.00
19		1.00	301		0.08%	0		0.00%	0.00
20		3.00	177		0.05%	0		0.00%	0.00
21		1.00	154		0.04%	0		0.00%	0.00
22		3.00	41		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 / 381954 * 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