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

Sections

Clan Information

Statistics Summary
Clan:	D.T.B
Home Page:
Activity:		66.52%
Members:	17 active members (65 total)
Avg. Member Points:	654
Total Kills:	28,833
Total Deaths:	30,684
Avg. Kills:	1,696
Kills per Death:	0.94
Kills per Minute:	2.28
Total Connection Time:	8d 19:06:20h
Avg. Connection Time:	0d 12:25:04h
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]Korea	940		0d 00:36:25h	18		0.06%	27	0.67
2	[D.T.B] Verdureiro	931		0d 00:30:20h	49		0.17%	54	0.91
3	[D.T.B] Cascão	900		0d 05:29:54h	1,001		3.47%	753	1.33
4	[D.T.B] Gaudêncio	824		0d 01:12:00h	159		0.55%	153	1.04
5	[D.T.B] Мσятє ϟ	823		0d 07:17:11h	952		3.30%	824	1.16
6	[D.T.B] Tá Combinado™	680		0d 14:31:14h	2,341		8.12%	1,901	1.23
7	[D.T.B] FANTASMA	678		0d 10:57:19h	1,211		4.20%	1,320	0.92
8	[D.T.B] Grilo	633		0d 04:59:08h	660		2.29%	723	0.91
9	[D.T.B] Heráclito [filósofo]	599		1d 14:46:59h	5,410		18.76%	4,833	1.12
10	[D.T.B] Galo Cinza Misterioso	598		0d 03:13:44h	303		1.05%	385	0.79
11	[D.T.B] Carniceiro	597		0d 23:34:55h	3,781		13.11%	3,720	1.02
12	[D.T.B] Maluko Kamikaze	551		2d 02:27:50h	6,867		23.82%	8,301	0.83
13	[D.T.B] abc	546		0d 02:17:31h	342		1.19%	413	0.83
14	[D.T.B] Teofilo	531		0d 04:39:26h	640		2.22%	611	1.05
15	[D.T.B] ary	480		1d 10:48:03h	4,234		14.68%	5,585	0.76
16	[D.T.B] só na bala	408		0d 03:47:47h	552		1.91%	569	0.97
17	[D.T.B] BRSOLDIER	396		0d 03:56:34h	313		1.09%	512	0.61

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Double Kill (2 kills)	501 times	501
2	Triple Kill (3 kills)	208 times	416
3	Domination (4 kills)	116 times	348
4	Rampage (5 kills)	48 times	192
5	Mega Kill (6 kills)	21 times	105
6	Ownage (7 kills)	13 times	78
7	Ultra Kill (8 kills)	3 times	21
8	God Like (12+ kills)	3 times	33
9	Unstoppable (11 kills)	2 times	20
10	Killing Spree (9 kills)	2 times	16
11	Bomb Planter Killed	2 times	4
12	Monster Kill (10 kills)	1 times	9
13	Bomb Planted	1 times	2

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Axis	171 times		23.27%
2	Allies	185 times		25.17%

Role Selection *

Rank	Role	Joined	%	Ratio	Kills	Deaths	K:D
1	Random	356 times	98.34%		3,649	3,817	0.96
2	American Rifleman	2 times	0.55%		18	35	0.51
3	Axis Unteroffizier	1 times	0.28%		13	12	1.08
4	Axis Sturmtruppe	1 times	0.28%		2	1	2.00
5	Axis Grenadier	1 times	0.28%		14	14	1.00
6	American Sniper	1 times	0.28%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.25	328		1.14%	0		0.00%	0.00
2		1.50	210		0.73%	0		0.00%	0.00
3		3.00	309		1.07%	0		0.00%	0.00
4		2.25	109		0.38%	0		0.00%	0.00
5		1.50	56		0.19%	0		0.00%	0.00
6		1.35	250		0.87%	0		0.00%	0.00
7		1.25	311		1.08%	0		0.00%	0.00
8		1.20	180		0.62%	0		0.00%	0.00
9		1.20	277		0.96%	0		0.00%	0.00
10		1.50	189		0.66%	0		0.00%	0.00
11		1.30	259		0.90%	0		0.00%	0.00
12		1.30	268		0.93%	0		0.00%	0.00
13		1.00	54		0.19%	0		0.00%	0.00
14		1.00	35		0.12%	0		0.00%	0.00
15		1.00	1		0.00%	0		0.00%	0.00
16		1.60	69		0.24%	0		0.00%	0.00
17		1.50	299		1.04%	0		0.00%	0.00
18		2.25	127		0.44%	0		0.00%	0.00
19		1.20	235		0.82%	0		0.00%	0.00
20		3.00	11		0.04%	0		0.00%	0.00
21		1.25	167		0.58%	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 / 28833 * 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