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

Sections

Clan Information

Statistics Summary
Clan:	D.T.B
Home Page:
Activity:		64.74%
Members:	27 active members (66 total)
Avg. Member Points:	737
Total Kills:	28,455
Total Deaths:	30,409
Avg. Kills:	1,054
Kills per Death:	0.94
Kills per Minute:	2.24
Total Connection Time:	8d 19:25:26h
Avg. Connection Time:	0d 07:49:49h
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]BozerMachado	793		0d 01:36:27h	220		0.77%	183	1.20
11	[D.T.B] Мσятє ϟ	763		0d 06:55:09h	895		3.15%	797	1.12
12	[D.T.B] Korvo	746		0d 01:19:33h	172		0.60%	197	0.87
13	[D.T.B] Heráclito [filósofo]	702		1d 13:35:55h	5,238		18.41%	4,658	1.12
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:48h	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.06%	385	0.79

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	408 times	408
2	Triple Kill (3 kills)	176 times	352
3	Domination (4 kills)	85 times	255
4	Rampage (5 kills)	45 times	180
5	Mega Kill (6 kills)	19 times	95
6	Ownage (7 kills)	12 times	72
7	Monster Kill (10 kills)	4 times	36
8	God Like (12+ kills)	2 times	22
9	Killing Spree (9 kills)	2 times	16
10	Bomb Planter Killed	2 times	4

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	170 times		25.26%
2	Allies	162 times		24.07%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	332 times	97.65%		3,159	3,407	0.93
2	American Rifleman	4 times	1.18%		29	34	0.85
3	Axis Unteroffizier	1 times	0.29%		2	4	0.50
4	Axis Sturmtruppe	1 times	0.29%		3	3	1.00
5	Axis Scharfschütze	1 times	0.29%		4	7	0.57
6	Axis Grenadier	1 times	0.29%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	300		1.05%	0		0.00%	0.00
2		1.25	283		0.99%	0		0.00%	0.00
3		3.00	270		0.95%	0		0.00%	0.00
4		1.50	269		0.95%	0		0.00%	0.00
5		1.20	259		0.91%	0		0.00%	0.00
6		1.30	242		0.85%	0		0.00%	0.00
7		1.30	221		0.78%	0		0.00%	0.00
8		1.35	211		0.74%	0		0.00%	0.00
9		1.20	196		0.69%	0		0.00%	0.00
10		1.50	173		0.61%	0		0.00%	0.00
11		1.50	160		0.56%	0		0.00%	0.00
12		1.20	159		0.56%	0		0.00%	0.00
13		1.25	148		0.52%	0		0.00%	0.00
14		2.25	108		0.38%	0		0.00%	0.00
15		2.25	72		0.25%	0		0.00%	0.00
16		1.60	54		0.19%	0		0.00%	0.00
17		1.50	34		0.12%	0		0.00%	0.00
18		1.00	30		0.11%	0		0.00%	0.00
19		1.00	28		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 / 28455 * 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