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

Sections

Clan Information

Statistics Summary
Clan:	LGG
Home Page:
Activity:		78.26%
Members:	15 active members (32 total)
Avg. Member Points:	674
Total Kills:	376,801
Total Deaths:	332,553
Avg. Kills:	25,120
Kills per Death:	1.13
Kills per Minute:	2.46
Total Connection Time:	106d 11:17:41h
Avg. Connection Time:	7d 02:21:10h
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 * Infidel	1,000		0d 00:08:45h	0		0.00%	0	0.00
2	* LGG * AssassiN	1,000		0d 00:04:56h	0		0.00%	0	0.00
3	* LGG * MajorBuck(GRANDPA)	803		13d 16:01:19h	48,832		12.96%	34,320	1.42
4	* LGG *THE ICON★	769		8d 03:50:20h	42,980		11.41%	36,557	1.18
5	* LGG * Rider . Qc	764		1d 04:31:14h	4,747		1.26%	3,881	1.22
6	* LGG * SOULJA SOYBOY	730		16d 21:08:57h	76,356		20.26%	52,751	1.45
7	* LGG * HARMLESS	726		7d 09:41:50h	26,570		7.05%	24,168	1.10
8	* LGG * McBAIN!	645		1d 18:19:16h	7,016		1.86%	7,111	0.99
9	* LGG * Moo	591		3d 00:48:16h	11,176		2.97%	9,196	1.22
10	* LGG * stefke	576		11d 11:19:44h	37,467		9.94%	33,021	1.13
11	* LGG * WARPAW	563		1d 17:40:47h	6,275		1.67%	5,892	1.07
12	* LGG * Spartantrooper7	548		0d 19:14:53h	1,736		0.46%	2,695	0.64
13	* LGG * SpitzSox -=PHX=- {EMT}	532		34d 11:46:02h	97,438		25.86%	96,529	1.01
14	* LGG * Jimmy Respawn	469		0d 03:17:41h	331		0.09%	490	0.68
15	* LGG * YaYa	390		5d 17:23:41h	15,877		4.21%	25,942	0.61

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Bomb Planted	234 times	468
2	Bomb Planter Killed	13 times	26
3	Domination (4 kills)	632 times	1,896
4	Double Kill (2 kills)	2,452 times	2,452
5	God Like (12+ kills)	25 times	275
6	Killing Spree (9 kills)	27 times	216
7	Mega Kill (6 kills)	180 times	900
8	Monster Kill (10 kills)	15 times	135
9	Ownage (7 kills)	99 times	594
10	Rampage (5 kills)	318 times	1,272
11	Triple Kill (3 kills)	1,256 times	2,512
12	Ultra Kill (8 kills)	45 times	315
13	Unstoppable (11 kills)	10 times	100

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	1,081 times		29.01%
2	Allies	484 times		12.99%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	1,562 times	94.04%		19,370	16,259	1.19
2	Axis Unteroffizier	45 times	2.71%		747	576	1.30
3	American Master Sergeant	28 times	1.69%		408	364	1.12
4	Axis Sturmtruppe	15 times	0.90%		196	134	1.46
5	American Rifleman	7 times	0.42%		66	38	1.74
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,604		0.96%	0		0.00%	0.00
2		1.25	1,383		0.37%	0		0.00%	0.00
3		1.25	1,374		0.36%	0		0.00%	0.00
4		1.50	1,331		0.35%	0		0.00%	0.00
5		1.20	1,303		0.35%	0		0.00%	0.00
6		1.30	1,201		0.32%	0		0.00%	0.00
7		1.35	1,184		0.31%	0		0.00%	0.00
8		1.20	1,153		0.31%	0		0.00%	0.00
9		1.30	1,136		0.30%	0		0.00%	0.00
10		1.50	973		0.26%	0		0.00%	0.00
11		1.20	963		0.26%	0		0.00%	0.00
12		1.25	945		0.25%	0		0.00%	0.00
13		1.50	923		0.24%	0		0.00%	0.00
14		2.25	720		0.19%	0		0.00%	0.00
15		2.25	562		0.15%	0		0.00%	0.00
16		1.50	528		0.14%	0		0.00%	0.00
17		1.60	524		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	163		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 / 376801 * 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