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

Sections

Clan Information

Statistics Summary
Clan:	D.T.B
Home Page:
Activity:		68.03%
Members:	27 active members (66 total)
Avg. Member Points:	739
Total Kills:	28,438
Total Deaths:	30,387
Avg. Kills:	1,053
Kills per Death:	0.94
Kills per Minute:	2.24
Total Connection Time:	8d 19:16:39h
Avg. Connection Time:	0d 07:49:30h
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	[D.T.B] System32_Br	1,025		0d 00:23:06h	29		0.10%	23	1.26
2	[D.T.B] Amazonense	1,000		0d 00:00:52h	0		0.00%	0	0.00
3	[D.T.B] Lama.Na.Veia	999		0d 00:10:19h	14		0.05%	16	0.88
4	[D.T.B] Clim@	981		0d 00:13:43h	5		0.02%	15	0.33
5	[D.T.B] ic3n3t	970		0d 00:30:33h	53		0.19%	52	1.02
6	[D.T.B] TARCAM	968		0d 00:14:25h	20		0.07%	27	0.74
7	[D.T.B]KOREA	947		0d 00:31:42h	15		0.05%	20	0.75
8	[D.T.B] Vedurovsk	931		0d 00:30:04h	49		0.17%	54	0.91
9	[D.T.B] SirCavalier	886		0d 00:30:10h	27		0.09%	77	0.35
10	[D.T.B] Мσятє ϟ	824		0d 06:49:30h	884		3.11%	783	1.13
11	[D.T.B]BozerMachado	793		0d 01:36:27h	220		0.77%	183	1.20
12	[D.T.B] Korvo	746		0d 01:19:33h	172		0.60%	197	0.87
13	[D.T.B] Heráclito [filósofo]	719		1d 13:35:14h	5,237		18.42%	4,655	1.13
14	[D.T.B] Kilson do Agreste™	691		0d 14:29:52h	2,339		8.22%	1,898	1.23
15	[D.T.B] Grilo	685		0d 03:27:13h	445		1.56%	506	0.88
16	[D.T.B] FANTASMA	678		0d 10:57:19h	1,211		4.26%	1,320	0.92
17	[D.T.B] Carniceiro	648		0d 15:20:24h	2,458		8.64%	2,457	1.00
18	[D.T.B] só na bala	639		0d 03:37:38h	481		1.69%	494	0.97
19	[D.T.B] PEKING-ROCKZEN	622		0d 09:01:34h	1,684		5.92%	1,385	1.22
20	[D.T.B] Galo Cinza Misterioso	598		0d 03:13:44h	303		1.07%	385	0.79

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	438 times	438
2	Triple Kill (3 kills)	186 times	372
3	Domination (4 kills)	88 times	264
4	Rampage (5 kills)	49 times	196
5	Mega Kill (6 kills)	19 times	95
6	Ownage (7 kills)	12 times	72
7	Monster Kill (10 kills)	4 times	36
8	Killing Spree (9 kills)	2 times	16
9	God Like (12+ kills)	2 times	22
10	Bomb Planter Killed	2 times	4
11	Ultra Kill (8 kills)	1 times	7

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	183 times		25.56%
2	Allies	170 times		23.74%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Axis Grenadier	1 times	0.28%
2	Axis Scharfschütze	1 times	0.28%		4	7	0.57
3	Axis Sturmtruppe	1 times	0.28%		3	3	1.00
4	Axis Unteroffizier	1 times	0.28%		2	4	0.50
5	American Rifleman	5 times	1.38%		29	34	0.85
6	Random	353 times	97.51%		3,359	3,630	0.93

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	316		1.11%	0		0.00%	0.00
2		1.25	303		1.07%	0		0.00%	0.00
3		1.50	289		1.02%	0		0.00%	0.00
4		3.00	288		1.01%	0		0.00%	0.00
5		1.20	274		0.96%	0		0.00%	0.00
6		1.30	257		0.90%	0		0.00%	0.00
7		1.30	238		0.84%	0		0.00%	0.00
8		1.35	228		0.80%	0		0.00%	0.00
9		1.20	208		0.73%	0		0.00%	0.00
10		1.50	185		0.65%	0		0.00%	0.00
11		1.50	169		0.59%	0		0.00%	0.00
12		1.20	166		0.58%	0		0.00%	0.00
13		1.25	155		0.55%	0		0.00%	0.00
14		2.25	113		0.40%	0		0.00%	0.00
15		2.25	75		0.26%	0		0.00%	0.00
16		1.60	56		0.20%	0		0.00%	0.00
17		1.50	37		0.13%	0		0.00%	0.00
18		1.00	31		0.11%	0		0.00%	0.00
19		1.00	29		0.10%	0		0.00%	0.00
20		3.00	4		0.01%	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 / 28438 * 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