HLstatsX ~TAMBOV-WOLF~ - - Clan Details

Clan Information

Statistics Summary
Clan:
Home Page:
Activity:		59.28%
Members:	7 active members (74 total)
Avg. Member Points:	1,293
Total Kills:	294
Total Deaths:	427
Avg. Kills:	42
Kills per Death:	0.69
Kills per Minute:	0.54
Total Connection Time:	0d 09:03:04h
Avg. Connection Time:	0d 01:17:34h
Favorite Server:*	~TAMBOFF-WOLF [NIGHT VIP] PUBLIC NOSTEAM~
Favorite Map:*	de_dust2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Rank	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	NeD1bil		2,545		0d 05:41:07h	150		51.02%	259	0.58
2	Hentai		1,279		0d 02:05:07h	58		19.73%	99	0.59
3	neko nyan :3		1,136		0d 00:26:32h	23		7.82%	13	1.77
4	Maxtraveller		1,039		0d 00:23:41h	49		16.67%	45	1.09
5	KOMETA		1,033		0d 00:08:34h	6		2.04%	2	3.00
6	owo		1,020		0d 00:13:53h	8		2.72%	8	1.00
7	천사 \| Okitofu		998		0d 00:04:10h	0		0.00%	1	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Pick up the Bomb	132 times	264
2	Headshot	90 times	90
3	Drop the Bomb	79 times	-158
4	Round MVP	74 times	0
5	Double Kill (2 kills)	34 times	34
6	Plant the Bomb	22 times	220
7	Revenge	14 times	42
8	Domination	12 times	60
9	Start Defusing the Bomb With a Defuse Kit	2 times	0
10	Domination (4 kills)	2 times	6
11	Defuse the Bomb	2 times	20
12	Triple Kill (3 kills)	1 times	2
13	Rampage (5 kills)	1 times	4

Victims of Player-Player Actions *

Rank	Action	Times Victimized	Points Bonus
1	Domination	21 times	-105
2	Revenge	10 times	-30

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1	M3	29	49	594	1	5	1.6667	169.0%	12.1	5.8
2	Awp	2	2	215	0	2	2.0000	100.0%	107.5	1.0
3	Xm1014	46	41	395	1	4	4.0000	89.1%	9.6	11.5
4	P90	18	12	264	1	2	2.0000	66.7%	22.0	9.0
5	Elite	15	9	275	1	2	2.0000	60.0%	30.6	7.5
6	Fiveseven	23	12	234	1	2	2.0000	52.2%	19.5	11.5
7	Ump45	32	14	204	0	2	2.0000	43.8%	14.6	16.0
8	Famas	36	15	344	0	2	2.0000	41.7%	22.9	18.0
9	Usp	61	21	337	1	2	2.0000	34.4%	16.0	30.5
10	Mp5navy	43	14	214	0	2	2.0000	32.6%	15.3	21.5
11	Scout	84	27	1,620	2	9	3.0000	32.1%	60.0	9.3
12	Glock	83	26	213	0	2	1.0000	31.3%	8.2	41.5
13	P228	41	12	214	0	2	1.0000	29.3%	17.8	20.5
14	Tmp	45	13	204	0	2	2.0000	28.9%	15.7	22.5
15	Aug	133	37	1,003	3	6	6.0000	27.8%	27.1	22.2
16	Deagle	227	52	3,071	13	20	2.5000	22.9%	59.1	11.4
17	Mac10	78	16	249	1	2	2.0000	20.5%	15.6	39.0
18	Galil	45	9	207	0	2	2.0000	20.0%	23.0	22.5
19	M4a1	1,133	201	5,993	20	41	8.2000	17.7%	29.8	27.6
20	Sg552	104	16	472	1	3	3.0000	15.4%	29.5	34.7
21	Ak47	2,578	344	12,803	42	86	2.7742	13.3%	37.2	30.0
22	M249	304	22	748	2	5	5.0000	7.2%	34.0	60.8
23	Knife	204	6	201	0	1	0.5000	2.9%	33.5	204.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1	Ak47	344	26.7%	57.6%	15.7%
2	M4a1	201	32.8%	55.2%	11.9%
3	Deagle	52	25.0%	65.4%	9.6%
4	M3	49	24.5%	55.1%	20.4%
5	Xm1014	41	36.6%	43.9%	19.5%
6	Aug	37	29.7%	67.6%	2.7%
7	Scout	27	44.4%	40.7%	14.8%
8	Glock	26	30.8%	61.5%	7.7%
9	M249	22	27.3%	45.5%	27.3%
10	Usp	21	28.6%	47.6%	23.8%
11	Sg552	16	37.5%	56.3%	6.3%
12	Mac10	16	43.8%	43.8%	12.5%
13	Famas	15	20.0%	66.7%	13.3%
14	Ump45	14	71.4%	14.3%	14.3%
15	Mp5navy	14	35.7%	50.0%	14.3%
16	Tmp	13	7.7%	61.5%	30.8%
17	P90	12	16.7%	83.3%	0.0%
18	P228	12	41.7%	41.7%	16.7%
19	Fiveseven	12	25.0%	58.3%	16.7%
20	Galil	9	44.4%	22.2%	33.3%
21	Elite	9	33.3%	33.3%	33.3%
22	Awp	2	50.0%	50.0%	0.0%

Targets

Show total target statistics

ERROR

Database Error

Server Address: localhost
Server Username: hlstatsxce

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 / 294 * 100, 2) AS kpercent,
			ROUND(headshots / 138 * 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