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

Sections

Clan Information

Statistics Summary
Clan:	LGG
Home Page:
Activity:		77.93%
Members:	15 active members (32 total)
Avg. Member Points:	671
Total Kills:	376,381
Total Deaths:	332,229
Avg. Kills:	25,092
Kills per Death:	1.13
Kills per Minute:	2.46
Total Connection Time:	106d 08:29:34h
Avg. Connection Time:	7d 02:09:58h
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 * SOULJA SOYBOY	730		16d 21:08:57h	76,356		20.29%	52,751	1.45
2	* LGG * MajorBuck(GRANDPA)	801		13d 14:52:09h	48,627		12.92%	34,204	1.42
3	* LGG * Rider . Qc	764		1d 04:31:14h	4,747		1.26%	3,881	1.22
4	* LGG * Moo	591		3d 00:48:16h	11,176		2.97%	9,196	1.22
5	* LGG *THE ICON★	769		8d 03:50:20h	42,980		11.42%	36,557	1.18
6	* LGG * stefke	578		11d 09:51:43h	37,281		9.91%	32,838	1.14
7	* LGG * HARMLESS	686		7d 09:30:54h	26,541		7.05%	24,143	1.10
8	* LGG * WARPAW	563		1d 17:40:47h	6,275		1.67%	5,892	1.07
9	* LGG * SpitzSox -=PHX=- {EMT}	532		34d 11:46:02h	97,438		25.89%	96,529	1.01
10	* LGG * McBAIN!	645		1d 18:19:16h	7,016		1.86%	7,111	0.99
11	* LGG * Jimmy Respawn	469		0d 03:17:41h	331		0.09%	490	0.68
12	* LGG * Spartantrooper7	548		0d 19:14:53h	1,736		0.46%	2,695	0.64
13	* LGG * YaYa	390		5d 17:23:41h	15,877		4.22%	25,942	0.61
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,394 times	2,394
2	Triple Kill (3 kills)	1,229 times	2,458
3	Domination (4 kills)	623 times	1,869
4	Rampage (5 kills)	310 times	1,240
5	Bomb Planted	233 times	466
6	Mega Kill (6 kills)	178 times	890
7	Ownage (7 kills)	97 times	582
8	Ultra Kill (8 kills)	45 times	315
9	Killing Spree (9 kills)	26 times	208
10	God Like (12+ kills)	25 times	275
11	Monster Kill (10 kills)	14 times	126
12	Bomb Planter Killed	13 times	26
13	Unstoppable (11 kills)	10 times	100

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	1,059 times		29.04%
2	Allies	473 times		12.97%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	1,529 times	94.27%		18,990	15,973	1.19
2	Axis Unteroffizier	43 times	2.65%		721	551	1.31
3	American Master Sergeant	25 times	1.54%		402	357	1.13
4	Axis Sturmtruppe	15 times	0.92%		196	134	1.46
5	American Rifleman	6 times	0.37%		58	32	1.81
6	Axis Scharfschütze	3 times	0.18%		32	24	1.33
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,526		0.94%	0		0.00%	0.00
2		1.25	1,357		0.36%	0		0.00%	0.00
3		1.25	1,350		0.36%	0		0.00%	0.00
4		1.50	1,300		0.35%	0		0.00%	0.00
5		1.20	1,280		0.34%	0		0.00%	0.00
6		1.30	1,180		0.31%	0		0.00%	0.00
7		1.35	1,161		0.31%	0		0.00%	0.00
8		1.20	1,130		0.30%	0		0.00%	0.00
9		1.30	1,116		0.30%	0		0.00%	0.00
10		1.50	957		0.25%	0		0.00%	0.00
11		1.20	940		0.25%	0		0.00%	0.00
12		1.25	924		0.25%	0		0.00%	0.00
13		1.50	905		0.24%	0		0.00%	0.00
14		2.25	705		0.19%	0		0.00%	0.00
15		2.25	546		0.15%	0		0.00%	0.00
16		1.50	513		0.14%	0		0.00%	0.00
17		1.60	510		0.14%	0		0.00%	0.00
18		1.00	480		0.13%	0		0.00%	0.00
19		1.00	295		0.08%	0		0.00%	0.00
20		3.00	171		0.05%	0		0.00%	0.00
21		1.00	161		0.04%	0		0.00%	0.00
22		3.00	61		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 / 376381 * 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