HLX:CE - [BZ] - www.betreutesZocken.de - Public II [AllTalk|FastDL] - Clan Details

Sections

Clan Information

Statistics Summary
Clan:	BZ
Home Page:
Activity:		51.00%
Members:	6 active members (320 total)
Avg. Member Points:	63,527
Total Kills:	167,211
Total Deaths:	180,169
Avg. Kills:	27,869
Kills per Death:	0.93
Kills per Minute:	0.66
Total Connection Time:	175d 15:41:07h
Avg. Connection Time:	29d 06:36:51h
Favorite Server:*	[BZ] - www.betreutesZocken.de - Public II [AllTalk\|FastDL]
Favorite Map:*	de_bz_dust2
Favorite Weapon:*

Player Locations

Members

Rank	Name	Points	Activity	Time	Kills	Clan Kills	%	Deaths	Kpd
1	[BZ]NIT\|<Ducati>	138,859		50d 18:05:44h	53,234		31.84%	57,725	0.92
2	[BZ]Schlaubi\|<Datschiburger>	121,243		104d 14:39:26h	93,362		55.83%	104,204	0.90
3	[BZ]=RoA= Dackel\|<Derek>	52,312		5d 23:40:31h	7,131		4.26%	5,465	1.30
4	[BZ]dasTier\|<im Bier>	34,250		4d 16:59:46h	5,925		3.54%	3,468	1.71
5	[BZ]ddbmaster\|<walter>	31,843		8d 03:37:53h	7,227		4.32%	7,604	0.95
6	[BZ]Bommel\|<Tomcat>	2,654		1d 10:37:47h	332		0.20%	1,703	0.19

Player Actions *

Rank	Action	Achieved	Points Bonus
1	Plant the Bomb	18 times	270
2	Spawn with the Bomb	77 times	154
3	Defuse the Bomb	5 times	75
4	Double Kill (2 kills)	41 times	41
5	Pick up the Bomb	8 times	16
6	Triple Kill (3 kills)	2 times	4
7	Domination (4 kills)	1 times	3
8	Start Defusing the Bomb Without a Defuse Kit	6 times	0
9	Start Defusing the Bomb With a Defuse Kit	1 times	0
10	Drop the Bomb	29 times	-58

Team Selection *

Rank	Team	Joined	Percentage of Times	%
1	Terrorist	14 times		50.00%
2	Counter-Terrorist	14 times		50.00%

Weapon Usage *

Rank	Weapon	Points Modifier	Kills	Percentage of Kills	%	Headshots	Percentage of Headshots	%	Hpk
1		1.00	75		0.04%	0		0.00%	0.00
2		1.00	2		0.00%	0		0.00%	0.00
3		1.00	71		0.04%	0		0.00%	0.00
4		1.00	8		0.00%	0		0.00%	0.00
5		1.25	3		0.00%	0		0.00%	0.00
6		1.50	13		0.01%	0		0.00%	0.00
7		1.50	3		0.00%	0		0.00%	0.00
8		1.60	4		0.00%	0		0.00%	0.00
9		1.80	1		0.00%	0		0.00%	0.00
10		1.80	1		0.00%	0		0.00%	0.00

ERROR

Database Error

Server Address: localhost
Server Username: hlxce

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 / 167211 * 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 asc,
			kills asc