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

Sections

Clan Information

Statistics Summary
Clan:	LGG
Home Page:
Activity:		78.13%
Members:	15 active members (32 total)
Avg. Member Points:	678
Total Kills:	376,427
Total Deaths:	332,242
Avg. Kills:	25,095
Kills per Death:	1.13
Kills per Minute:	2.46
Total Connection Time:	106d 08:51:44h
Avg. Connection Time:	7d 02:11:26h
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★	769		8d 03:50:20h	42,980		11.42%	36,557	1.18
2	* LGG * YaYa	390		5d 17:23:41h	15,877		4.22%	25,942	0.61
3	* LGG * WARPAW	563		1d 17:40:47h	6,275		1.67%	5,892	1.07
4	* LGG * stefke	578		11d 09:51:43h	37,281		9.90%	32,838	1.14
5	* LGG * SpitzSox -=PHX=- {EMT}	532		34d 11:46:02h	97,438		25.88%	96,529	1.01
6	* LGG * Spartantrooper7	548		0d 19:14:53h	1,736		0.46%	2,695	0.64
7	* LGG * SOULJA SOYBOY	730		16d 21:08:57h	76,356		20.28%	52,751	1.45
8	* LGG * Rider . Qc	764		1d 04:31:14h	4,747		1.26%	3,881	1.22
9	* LGG * Moo	591		3d 00:48:16h	11,176		2.97%	9,196	1.22
10	* LGG * McBAIN!	645		1d 18:19:16h	7,016		1.86%	7,111	0.99
11	* LGG * MajorBuck(GRANDPA)	912		13d 15:14:19h	48,673		12.93%	34,217	1.42
12	* LGG * Jimmy Respawn	469		0d 03:17:41h	331		0.09%	490	0.68
13	* LGG * Infidel	1,000		0d 00:08:45h	0		0.00%	0	0.00
14	* LGG * HARMLESS	686		7d 09:30:54h	26,541		7.05%	24,143	1.10
15	* LGG * AssassiN	1,000		0d 00:04:56h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Triple Kill (3 kills)	1,230 times	2,460
2	Double Kill (2 kills)	2,400 times	2,400
3	Domination (4 kills)	624 times	1,872
4	Rampage (5 kills)	311 times	1,244
5	Mega Kill (6 kills)	178 times	890
6	Ownage (7 kills)	98 times	588
7	Bomb Planted	233 times	466
8	Ultra Kill (8 kills)	45 times	315
9	God Like (12+ kills)	25 times	275
10	Killing Spree (9 kills)	26 times	208
11	Monster Kill (10 kills)	14 times	126
12	Unstoppable (11 kills)	10 times	100
13	Bomb Planter Killed	13 times	26

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	1,065 times		29.06%
2	Allies	474 times		12.93%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	1,536 times	94.29%		19,034	15,986	1.19
2	Axis Unteroffizier	43 times	2.64%		721	551	1.31
3	American Master Sergeant	25 times	1.53%		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,534		0.94%	0		0.00%	0.00
2		1.25	1,360		0.36%	0		0.00%	0.00
3		1.25	1,353		0.36%	0		0.00%	0.00
4		1.50	1,303		0.35%	0		0.00%	0.00
5		1.20	1,283		0.34%	0		0.00%	0.00
6		1.30	1,182		0.31%	0		0.00%	0.00
7		1.35	1,163		0.31%	0		0.00%	0.00
8		1.20	1,132		0.30%	0		0.00%	0.00
9		1.30	1,119		0.30%	0		0.00%	0.00
10		1.50	957		0.25%	0		0.00%	0.00
11		1.20	942		0.25%	0		0.00%	0.00
12		1.25	926		0.25%	0		0.00%	0.00
13		1.50	906		0.24%	0		0.00%	0.00
14		2.25	707		0.19%	0		0.00%	0.00
15		2.25	549		0.15%	0		0.00%	0.00
16		1.50	515		0.14%	0		0.00%	0.00
17		1.60	512		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	172		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 / 376427 * 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