Half-Life DeathMatch Community - Half-Life 1 Multiplayer - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	B
Home Page:
Activity:		48.23%
Members:	26 active members (950 total)
Avg. Member Points:	1,027
Total Kills:	430
Total Deaths:	727
Avg. Kills:	17
Kills per Death:	0.59
Kills per Minute:	0.25
Total Connection Time:	1d 04:25:48h
Avg. Connection Time:	0d 01:05:36h
Favorite Server:*	BECEJIbIU CEPBEP - HLDM.ORG
Favorite Map:*	creambase
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
21	[B] K o H T p E	996		0d 00:03:14h	0		0.00%	2	0.00
22	[B] K o H T p E	994		0d 00:05:49h	2		0.47%	5	0.40
23	[B] K o H T p E	984		0d 00:41:24h	14		3.26%	29	0.48
24	[B] K o H T p E	983		0d 02:31:00h	6		1.40%	26	0.23
25	[B] K o H T p E	975		0d 00:59:38h	3		0.70%	16	0.19
26	[B] K o H T p E	822		0d 06:57:34h	35		8.14%	133	0.26

Page: 1 2

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Убийство в голову	13 times	13
2	Double Kill (2 kills)	9 times	9
3	Air Shot	8 times	80
4	Triple Kill (3 kills)	4 times	8
5	Rampage (5 kills)	4 times	16
6	Полный боекомплект	2 times	2
7	Ownage (7 kills)	1 times	6
8	Mega Kill (6 kills)	1 times	5
9	Killing Spree (9 kills)	1 times	8

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	21		4.88%	3		4.35%	0.14
2		1.00	9		2.09%	0		0.00%	0.00
3		1.50	8		1.86%	3		4.35%	0.38
4		1.00	5		1.16%	0		0.00%	0.00
5		1.00	4		0.93%	1		1.45%	0.25
6		1.60	3		0.70%	0		0.00%	0.00
7		1.00	2		0.47%	0		0.00%	0.00
8		1.20	1		0.23%	0		0.00%	0.00
9		1.60	1		0.23%	1		1.45%	1.00

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		1,242	213	9,996	5	60	0.9524	17.1%	46.9	20.7
2		177	118	8,893	6	50	1.6129	66.7%	75.4	3.5
3		1,532	289	3,780	6	34	1.4783	18.9%	13.1	45.1
4		176	75	3,367	3	24	1.1429	42.6%	44.9	7.3
5		143	40	2,250	2	17	0.2394	28.0%	56.3	8.4
6		607	130	2,016	6	13	4.3333	21.4%	15.5	46.7
7		90	16	1,963	1	12	0.8571	17.8%	122.7	7.5
8		418	27	1,075	0	11	0.9167	6.5%	39.8	38.0
9		39	13	1,800	1	10	1.0000	33.3%	138.5	3.9
10		94	21	1,080	3	7	1.1667	22.3%	51.4	13.4
11		265	98	976	0	6	6.0000	37.0%	10.0	44.2
12		52	17	374	1	2	2.0000	32.7%	22.0	26.0
13		11	3	257	0	1	1.0000	27.3%	85.7	11.0
14		37	0	0	0	0	0.0000	0.0%	0.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1	Chainsaw	1	100.0%	0.0%	0.0%
2		13	46.2%	38.5%	15.4%
3		7	42.9%	14.3%	42.9%
4		130	42.3%	39.2%	18.5%
5		289	41.9%	31.1%	27.0%
6		213	37.1%	37.6%	25.4%
7		3	33.3%	33.3%	33.3%
8	Dbarrel	9	33.3%	22.2%	44.4%
9		16	31.3%	37.5%	31.3%
10		75	30.7%	50.7%	18.7%
11		40	30.0%	32.5%	37.5%
12		116	25.9%	54.3%	19.8%
13		21	23.8%	57.1%	19.0%
14		17	17.6%	64.7%	17.6%
15		1	0.0%	100.0%	0.0%

Targets

Show total target statistics

ERROR

Database Error

Server Address: db
Server Username: hldm_stats

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