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

Sections

Clan Information

Statistics Summary
Clan:	LGG
Home Page:
Activity:		78.20%
Members:	15 active members (32 total)
Avg. Member Points:	676
Total Kills:	376,708
Total Deaths:	332,464
Avg. Kills:	25,114
Kills per Death:	1.13
Kills per Minute:	2.46
Total Connection Time:	106d 10:38:30h
Avg. Connection Time:	7d 02:18:34h
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 * SpitzSox -=PHX=- {EMT}	532		34d 11:46:02h	97,438		25.87%	96,529	1.01
2	* LGG * SOULJA SOYBOY	730		16d 21:08:57h	76,356		20.27%	52,751	1.45
3	* LGG * MajorBuck(GRANDPA)	803		13d 16:01:19h	48,832		12.96%	34,320	1.42
4	* LGG * stefke	650		11d 10:51:29h	37,403		9.93%	32,957	1.13
5	* LGG *THE ICON★	769		8d 03:50:20h	42,980		11.41%	36,557	1.18
6	* LGG * HARMLESS	686		7d 09:30:54h	26,541		7.05%	24,143	1.10
7	* LGG * YaYa	390		5d 17:23:41h	15,877		4.21%	25,942	0.61
8	* LGG * Moo	591		3d 00:48:16h	11,176		2.97%	9,196	1.22
9	* LGG * McBAIN!	645		1d 18:19:16h	7,016		1.86%	7,111	0.99
10	* LGG * WARPAW	563		1d 17:40:47h	6,275		1.67%	5,892	1.07
11	* LGG * Rider . Qc	764		1d 04:31:14h	4,747		1.26%	3,881	1.22
12	* LGG * Spartantrooper7	548		0d 19:14:53h	1,736		0.46%	2,695	0.64
13	* LGG * Jimmy Respawn	469		0d 03:17:41h	331		0.09%	490	0.68
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,439 times	2,439
2	Triple Kill (3 kills)	1,246 times	2,492
3	Domination (4 kills)	631 times	1,893
4	Rampage (5 kills)	317 times	1,268
5	Bomb Planted	233 times	466
6	Mega Kill (6 kills)	179 times	895
7	Ownage (7 kills)	99 times	594
8	Ultra Kill (8 kills)	45 times	315
9	Killing Spree (9 kills)	27 times	216
10	God Like (12+ kills)	25 times	275
11	Monster Kill (10 kills)	15 times	135
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,079 times		29.15%
2	Allies	477 times		12.88%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	1,553 times	94.24%		19,291	16,183	1.19
2	Axis Scharfschütze	3 times	0.18%		32	24	1.33
3	Axis Sturmtruppe	15 times	0.91%		196	134	1.46
4	Axis Unteroffizier	45 times	2.73%		747	576	1.30
5	Axis Grenadier	1 times	0.06%		17	11	1.55
6	American Master Sergeant	25 times	1.52%		402	357	1.13
7	American Rifleman	6 times	0.36%		58	32	1.81

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		3.00	3,589		0.95%	0		0.00%	0.00
2		1.25	1,375		0.37%	0		0.00%	0.00
3		1.25	1,366		0.36%	0		0.00%	0.00
4		1.50	1,322		0.35%	0		0.00%	0.00
5		1.20	1,296		0.34%	0		0.00%	0.00
6		1.30	1,194		0.32%	0		0.00%	0.00
7		1.35	1,179		0.31%	0		0.00%	0.00
8		1.20	1,149		0.31%	0		0.00%	0.00
9		1.30	1,130		0.30%	0		0.00%	0.00
10		1.50	970		0.26%	0		0.00%	0.00
11		1.20	959		0.25%	0		0.00%	0.00
12		1.25	941		0.25%	0		0.00%	0.00
13		1.50	920		0.24%	0		0.00%	0.00
14		2.25	716		0.19%	0		0.00%	0.00
15		2.25	560		0.15%	0		0.00%	0.00
16		1.50	527		0.14%	0		0.00%	0.00
17		1.60	523		0.14%	0		0.00%	0.00
18		1.00	484		0.13%	0		0.00%	0.00
19		1.00	299		0.08%	0		0.00%	0.00
20		3.00	174		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 / 376708 * 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