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

Sections

Clan Information

Statistics Summary
Clan:	HLDM_org
Home Page:
Activity:		66.00%
Members:	3 active members (117 total)
Avg. Member Points:	1,377
Total Kills:	319
Total Deaths:	252
Avg. Kills:	106
Kills per Death:	1.27
Kills per Minute:	2.20
Total Connection Time:	0d 02:24:45h
Avg. Connection Time:	0d 00:48:15h
Favorite Server:*	GunGame 2.4 - HLDM.ORG
Favorite Map:*	basex
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[HLDM_org] Player	2,131		0d 02:16:59h	319		100.00%	252	1.27
2	[HLDM_org] Player	1,000		0d 00:03:03h	0		0.00%	0	0.00
3	[HLDM_org] Player	1,000		0d 00:04:43h	0		0.00%	0	0.00

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Убийство в голову	9 times	9
2	Похититель фрагов	7 times	0
3	Triple Kill (3 kills)	4 times	8
4	Mega Kill (6 kills)	2 times	10
5	Double Kill (2 kills)	2 times	2
6	Rampage (5 kills)	1 times	4
7	Domination (4 kills)	1 times	3

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	10		3.13%	2		3.64%	0.20
2		1.00	10		3.13%	2		3.64%	0.20
3		1.20	8		2.51%	1		1.82%	0.13
4		1.00	6		1.88%	4		7.27%	0.67
5	Egon	1.00	4		1.25%	0		0.00%	0.00
6		1.00	4		1.25%	0		0.00%	0.00
7		1.60	2		0.63%	0		0.00%	0.00
8		1.90	1		0.31%	0		0.00%	0.00

Weapon Stats *

Rank	Weapon	Shots	Hits	Damage	Headshots	Kills	Kills per Death	Accuracy	Damage per Hit	Shots per Kill
1		73	18	1,920	2	10	5.0000	24.7%	106.7	7.3
2		41	15	2,280	2	10	1.4286	36.6%	152.0	4.1
3		32	14	1,240	1	8	2.6667	43.8%	88.6	4.0
4		11	10	1,389	4	6	0.8571	90.9%	138.9	1.8
5	Egon	104	87	932	0	4	1.0000	83.7%	10.7	26.0
6		763	67	924	0	4	1.3333	8.8%	13.8	190.8
7		9	5	200	0	2	2.0000	55.6%	40.0	4.5
8		54	8	200	0	1	0.3333	14.8%	25.0	54.0
9		4	3	105	0	0	0.0000	75.0%	35.0	0.0

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1	Egon	87	35.6%	43.7%	20.7%
2		67	26.9%	41.8%	31.3%
3		18	22.2%	50.0%	27.8%
4		15	26.7%	53.3%	20.0%
5		14	28.6%	42.9%	28.6%
6		10	0.0%	90.0%	10.0%
7		5	40.0%	40.0%	20.0%
8		3	33.3%	33.3%	33.3%
9		2	50.0%	50.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 / 319 * 100, 2) AS kpercent,
			ROUND(headshots / 55 * 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