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

Sections

Clan Information

Statistics Summary
Clan:	D.T.B
Home Page:
Activity:		66.38%
Members:	31 active members (64 total)
Avg. Member Points:	780
Total Kills:	26,854
Total Deaths:	29,350
Avg. Kills:	866
Kills per Death:	0.91
Kills per Minute:	2.20
Total Connection Time:	8d 11:35:11h
Avg. Connection Time:	0d 06:34:02h
Favorite Server:*	Adult Gamers Community - DOD:S Gungame
Favorite Map:*	arena_mayhem
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[D.T.B] Verdureiro	1,007		0d 00:19:35h	24		0.09%	23	1.04
2	[D.T.B] System32_Br	1,006		0d 00:09:32h	3		0.01%	1	3.00
3	[D.T.B] TARCAM	1,000		0d 00:01:15h	0		0.00%	0	0.00
4	[D.T.B] Daniel	1,000		0d 00:00:17h	0		0.00%	0	0.00
5	[D.T.B] CURinha	986		0d 00:10:23h	20		0.07%	20	1.00
6	[D.T.B] Clim@	981		0d 00:13:43h	5		0.02%	15	0.33
7	[D.T.B] ic3n3t	970		0d 00:30:33h	53		0.20%	52	1.02
8	[D.T.B]KOREA	949		0d 00:30:06h	15		0.06%	19	0.79
9	[D.T.B] KaFuRiNgA	933		0d 00:22:06h	58		0.22%	62	0.94
10	[D.T.B] SirCavaliLerdo	898		0d 00:25:20h	24		0.09%	67	0.36
11	[D.T.B] Cascão	867		0d 05:25:56h	988		3.68%	748	1.32
12	[D.T.B] JESSYKÉT	806		0d 00:42:52h	86		0.32%	108	0.80
13	[D.T.B] abc	796		0d 00:23:04h	65		0.24%	83	0.78
14	[D.T.B] só na bala	753		0d 02:21:07h	305		1.14%	319	0.96
15	[D.T.B] Мσятє ϟ	750		0d 06:36:48h	851		3.17%	762	1.12
16	[D.T.B] Recruit Garcia	746		0d 02:03:24h	296		1.10%	291	1.02
17	[D.T.B] Korvo	746		0d 01:19:33h	172		0.64%	197	0.87
18	[D.T.B] Heráclito [filósofo]	719		1d 13:35:14h	5,237		19.50%	4,655	1.13
19	[D.T.B] El Paco Loco™	716		0d 14:18:21h	2,310		8.60%	1,872	1.23
20	[D.T.B] Teofilo	716		0d 03:53:20h	531		1.98%	484	1.10

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	399 times	399
2	Triple Kill (3 kills)	201 times	402
3	Domination (4 kills)	85 times	255
4	Rampage (5 kills)	46 times	184
5	Mega Kill (6 kills)	16 times	80
6	Ownage (7 kills)	7 times	42
7	Monster Kill (10 kills)	5 times	45
8	Ultra Kill (8 kills)	3 times	21
9	Bomb Planter Killed	2 times	4
10	Killing Spree (9 kills)	1 times	8
11	God Like (12+ kills)	1 times	11

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	173 times		25.37%
2	Allies	157 times		23.02%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	330 times	95.65%		3,089	3,250	0.95
2	American Rifleman	7 times	2.03%		68	62	1.10
3	Axis Sturmtruppe	5 times	1.45%		51	60	0.85
4	Axis Unteroffizier	1 times	0.29%		2	4	0.50
5	Axis Scharfschütze	1 times	0.29%		4	7	0.57
6	American Support Infantry	1 times	0.29%		11	4	2.75

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	304		1.13%	0		0.00%	0.00
2		1.25	296		1.10%	0		0.00%	0.00
3		1.50	280		1.04%	0		0.00%	0.00
4		1.20	268		1.00%	0		0.00%	0.00
5		3.00	267		0.99%	0		0.00%	0.00
6		1.30	244		0.91%	0		0.00%	0.00
7		1.30	229		0.85%	0		0.00%	0.00
8		1.35	223		0.83%	0		0.00%	0.00
9		1.20	195		0.73%	0		0.00%	0.00
10		1.50	180		0.67%	0		0.00%	0.00
11		1.50	159		0.59%	0		0.00%	0.00
12		1.25	148		0.55%	0		0.00%	0.00
13		1.20	144		0.54%	0		0.00%	0.00
14		2.25	106		0.39%	0		0.00%	0.00
15		2.25	64		0.24%	0		0.00%	0.00
16		1.60	49		0.18%	0		0.00%	0.00
17		1.50	38		0.14%	0		0.00%	0.00
18		1.00	24		0.09%	0		0.00%	0.00
19		1.00	17		0.06%	0		0.00%	0.00
20		3.00	5		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 / 26854 * 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