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

Sections

Clan Information

Statistics Summary
Clan:	1
Home Page:
Activity:		28.80%
Members:	5 active members (1028 total)
Avg. Member Points:	1,356
Total Kills:	20,058
Total Deaths:	20,297
Avg. Kills:	4,012
Kills per Death:	0.99
Kills per Minute:	1.02
Total Connection Time:	13d 16:27:04h
Avg. Connection Time:	2d 17:41:24h
Favorite Server:*	GunGame 2.4 - HLDM.ORG
Favorite Map:*	dm_snow
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	(1)Player	2,757		13d 13:56:30h	20,028		99.85%	20,261	0.99
2	(1)Zeldari	1,033		0d 00:24:22h	28		0.14%	28	1.00
3	(1)Fullserver	1,000		0d 00:00:18h	0		0.00%	0	0.00
4	(1)Fullserver	996		0d 00:00:48h	0		0.00%	2	0.00
5	(1)Fullserver	993		0d 02:05:06h	2		0.01%	6	0.33

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Убийство в голову	20 times	20
2	Похититель фрагов	18 times	0
3	Double Kill (2 kills)	8 times	8
4	Triple Kill (3 kills)	2 times	4
5	Победитель GunGame	1 times	15
6	Mega Kill (6 kills)	1 times	5
7	God Like (12+ kills)	1 times	11
8	Domination (4 kills)	1 times	3

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	2		0.01%	2		0.05%	1.00
2		1.00	3		0.01%	1		0.02%	0.33
3	Egon	1.00	9		0.04%	7		0.16%	0.78
4		1.00	7		0.03%	1		0.02%	0.14
5		1.00	8		0.04%	2		0.05%	0.25
6		1.00	14		0.07%	3		0.07%	0.21
7		1.20	3		0.01%	1		0.02%	0.33
8		1.30	2		0.01%	0		0.00%	0.00
9		1.50	6		0.03%	0		0.00%	0.00
10		1.50	4		0.02%	0		0.00%	0.00
11		1.60	3		0.01%	2		0.05%	0.67
12		1.60	4		0.02%	1		0.02%	0.25
13		1.80	2		0.01%	0		0.00%	0.00
14		1.90	3		0.01%	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		2	3	71	0	0	0.0000	150.0%	23.7	0.0
2		140	32	320	0	2	2.0000	22.9%	10.0	70.0
3		58	44	440	0	2	0.6667	75.9%	10.0	29.0
4		469	51	948	3	3	3.0000	10.9%	18.6	156.3
5		17	4	720	1	3	1.5000	23.5%	180.0	5.7
6		26	9	1,000	1	3	3.0000	34.6%	111.1	8.7
7		67	7	549	1	3	0.4286	10.4%	78.4	22.3
8		34	11	840	4	6	0.6667	32.4%	76.4	5.7
9		267	59	1,068	0	6	1.0000	22.1%	18.1	44.5
10		23	21	1,639	2	7	0.3889	91.3%	78.0	3.3
11		497	18	450	0	8	1.1429	3.6%	25.0	62.1
12	Egon	395	302	3,802	7	9	1.0000	76.5%	12.6	43.9
13		146	51	2,199	1	10	2.0000	34.9%	43.1	14.6
14		56	56	3,264	1	17	4.2500	100.0%	58.3	3.3
15		107	32	4,741	4	18	1.8000	29.9%	148.2	5.9

Weapon Targets *

Rank	Weapon	Hits	Left	Middle	Right
1		3	33.3%	33.3%	33.3%
2		4	25.0%	50.0%	25.0%
3		7	28.6%	57.1%	14.3%
4		7	28.6%	42.9%	28.6%
5		9	22.2%	66.7%	11.1%
6		11	27.3%	63.6%	9.1%
7		12	8.3%	91.7%	0.0%
8		21	23.8%	38.1%	38.1%
9		32	37.5%	43.8%	18.8%
10		51	27.5%	58.8%	13.7%
11		51	31.4%	47.1%	21.6%
12		55	36.4%	36.4%	27.3%
13		59	25.4%	54.2%	20.3%
14	Egon	301	28.9%	47.8%	23.3%

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 / 20058 * 100, 2) AS kpercent,
			ROUND(headshots / 4306 * 100, 2) AS hpercent
		FROM
			tmp_clan_kills, tmp_clan_deaths
		WHERE
			tmp_clan_kills.map = tmp_clan_deaths.map
		ORDER BY
			map asc,
			kills asc