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

Sections

Clan Information

Statistics Summary
Clan:	D.T.B
Home Page:
Activity:		60.62%
Members:	24 active members (66 total)
Avg. Member Points:	732
Total Kills:	29,410
Total Deaths:	30,852
Avg. Kills:	1,225
Kills per Death:	0.95
Kills per Minute:	2.29
Total Connection Time:	8d 22:03:33h
Avg. Connection Time:	0d 08:55:08h
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] TARCAM	968		0d 00:14:25h	20		0.07%	27	0.74
5	[D.T.B]Korea	947		0d 00:32:38h	15		0.05%	20	0.75
6	[D.T.B] Vedurovsk	931		0d 00:30:04h	49		0.17%	54	0.91
7	[D.T.B] Cascão	900		0d 05:29:54h	1,001		3.40%	753	1.33
8	[D.T.B] SirCavalier	886		0d 00:30:10h	27		0.09%	77	0.35
9	[D.T.B] Gaudêncio	824		0d 01:12:00h	159		0.54%	153	1.04
10	[D.T.B] Мσятє ϟ	823		0d 07:17:11h	952		3.24%	824	1.16
11	[D.T.B]BozerMachado	793		0d 01:36:27h	220		0.75%	183	1.20
12	[D.T.B] Tá Combinado™	680		0d 14:31:14h	2,341		7.96%	1,901	1.23
13	[D.T.B] FANTASMA	678		0d 10:57:19h	1,211		4.12%	1,320	0.92
14	[D.T.B] só na bala	639		0d 03:37:38h	481		1.64%	494	0.97
15	[D.T.B] Grilo	633		0d 04:59:08h	660		2.24%	723	0.91
16	[D.T.B] PEKING-ROCKZEN	622		0d 09:01:34h	1,684		5.73%	1,385	1.22
17	[D.T.B] Heráclito [filósofo]	598		1d 14:19:47h	5,346		18.18%	4,765	1.12
18	[D.T.B] Galo Cinza Misterioso	598		0d 03:13:44h	303		1.03%	385	0.79
19	[D.T.B] abc	574		0d 01:10:26h	168		0.57%	194	0.87
20	[D.T.B] Carniceiro	567		0d 17:54:39h	2,888		9.82%	2,849	1.01

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	413 times	413
2	Triple Kill (3 kills)	189 times	378
3	Domination (4 kills)	89 times	267
4	Rampage (5 kills)	36 times	144
5	Mega Kill (6 kills)	17 times	85
6	Ownage (7 kills)	13 times	78
7	God Like (12+ kills)	3 times	33
8	Unstoppable (11 kills)	2 times	20
9	Bomb Planter Killed	2 times	4
10	Ultra Kill (8 kills)	1 times	7
11	Monster Kill (10 kills)	1 times	9
12	Killing Spree (9 kills)	1 times	8
13	Bomb Planted	1 times	2

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Allies	159 times		25.00%
2	Axis	153 times		24.06%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	312 times	99.36%		3,096	3,239	0.96
2	Axis Grenadier	2 times	0.64%		14	14	1.00

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	277		0.94%	0		0.00%	0.00
2		1.25	271		0.92%	0		0.00%	0.00
3		3.00	267		0.91%	0		0.00%	0.00
4		1.50	255		0.87%	0		0.00%	0.00
5		1.20	242		0.82%	0		0.00%	0.00
6		1.30	234		0.80%	0		0.00%	0.00
7		1.30	219		0.74%	0		0.00%	0.00
8		1.35	207		0.70%	0		0.00%	0.00
9		1.20	198		0.67%	0		0.00%	0.00
10		1.50	174		0.59%	0		0.00%	0.00
11		1.50	155		0.53%	0		0.00%	0.00
12		1.20	153		0.52%	0		0.00%	0.00
13		1.25	142		0.48%	0		0.00%	0.00
14		2.25	99		0.34%	0		0.00%	0.00
15		2.25	80		0.27%	0		0.00%	0.00
16		1.60	55		0.19%	0		0.00%	0.00
17		1.00	39		0.13%	0		0.00%	0.00
18		1.50	38		0.13%	0		0.00%	0.00
19		1.00	30		0.10%	0		0.00%	0.00
20		3.00	6		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 / 29410 * 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