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

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		3.00	61		0.02%	0		0.00%	0.00
3		3.00	174		0.05%	0		0.00%	0.00
4		2.25	562		0.15%	0		0.00%	0.00
5		2.25	720		0.19%	0		0.00%	0.00
6		1.60	524		0.14%	0		0.00%	0.00
7		1.50	973		0.26%	0		0.00%	0.00
8		1.50	528		0.14%	0		0.00%	0.00
9		1.50	923		0.24%	0		0.00%	0.00
10		1.50	1,331		0.35%	0		0.00%	0.00
11		1.35	1,184		0.31%	0		0.00%	0.00
12		1.30	1,136		0.30%	0		0.00%	0.00
13		1.30	1,201		0.32%	0		0.00%	0.00
14		1.25	1,383		0.37%	0		0.00%	0.00
15		1.25	1,374		0.36%	0		0.00%	0.00
16		1.25	945		0.25%	0		0.00%	0.00
17		1.20	963		0.26%	0		0.00%	0.00
18		1.20	1,303		0.35%	0		0.00%	0.00
19		1.20	1,153		0.31%	0		0.00%	0.00
20		1.00	484		0.13%	0		0.00%	0.00
21		1.00	299		0.08%	0		0.00%	0.00
22		1.00	163		0.04%	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