HLstatsX Community Edition
  • AIM
  • AWP
  • CODMW
  • DM
  • DMDUST2
  • DMFFA
  • FFAONLYHS
  • DUST2
  • FURIEN
  • FY
  • GUNGAME
  • KNIFE
  • MEGA
  • OLDSCHOOL
  • PAINTBALL
  • PUBNITE
  • SCOUT
  • VANOCNI
  • Contents
  • Search
  • Forum
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: **D@n3CEK**
Home Page:
Activity: 100.00% 100.00%
Members: 1 active members (1 total)
Avg. Member Points: 12,328
Total Kills: 1,437
Total Deaths: 481
Avg. Kills: 1,437
Kills per Death: 2.99
Kills per Minute: 1.00
Total Connection Time: 0d 23:54:21h
Avg. Connection Time: 0d 23:54:21h
Favorite Server:* csko.cz | dust2 only
Favorite Map:* de_dust2
Favorite Weapon:* Kalashnikov AK-47
Player Locations

  Members

Rank Name Points Activity Time Kills sort-descending.gif Clan Kills % Deaths Kpd
1  No Country-**D@n3CEK**- k!lLmast3r 12,328 100% 0d 23:54:21h 1,437 100.00% 100.00% 481 2.99




  Player Actions *

Rank Action Achieved Points Bonus sort-ascending.gif
1 Drop the Bomb 17 times -34
2 Start Defusing the Bomb With a Defuse Kit 18 times 0
3 Start Defusing the Bomb Without a Defuse Kit 3 times 0
4 Mega Kill (6 kills) 1 times 5
5 Ownage (7 kills) 1 times 6
6 Rampage (5 kills) 14 times 56
7 Pick up the Bomb 40 times 80
8 Spawn with the Bomb 45 times 90
9 Domination (4 kills) 38 times 114
10 Double Kill (2 kills) 156 times 156
11 Triple Kill (3 kills) 89 times 178
12 Defuse the Bomb 17 times 255
13 Headshot 258 times 258
14 Plant the Bomb 45 times 675




  Team Selection *

Rank Team sort-descending.gif Joined Percentage of Times %
1 Terrorist 40 times 40.00% 40.00%
2 Counter-Terrorist 58 times 58.00% 58.00%




ERROR
Database Error

Server Address: 192.168.1.22:3306
Server Username: webik

Error Diagnostic:
Bad query.

Server Error: (1267) Illegal mix of collations (utf8_czech_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Last SQL Query:
		SELECT
			IFNULL(hlstats_Roles.name, hlstats_Events_ChangeRole.role) AS name,
			IFNULL(hlstats_Roles.code, hlstats_Events_ChangeRole.role) AS code,
			COUNT(hlstats_Events_ChangeRole.id) AS rolecount,
			ROUND(COUNT(hlstats_Events_ChangeRole.id) / IF(0 = 0, 1, 0) * 100, 2) AS percent,
			killsTotal,
			deathsTotal,
			ROUND(killsTotal/if(deathsTotal=0,1,deathsTotal), 2) AS kpd
		FROM
			hlstats_Events_ChangeRole
		LEFT JOIN
			hlstats_Roles
		ON
			hlstats_Events_ChangeRole.role = hlstats_Roles.code
		LEFT JOIN
			hlstats_Servers
		ON
			hlstats_Servers.serverId = hlstats_Events_ChangeRole.serverId
		LEFT JOIN
			hlstats_Frags_as_res
		ON
			hlstats_Frags_as_res.role = hlstats_Events_ChangeRole.role
		LEFT JOIN
			hlstats_Players
		ON
			hlstats_Players.playerId = hlstats_Events_ChangeRole.playerId
		WHERE
			hlstats_Servers.game='dust2'
			AND hlstats_Players.clan=686796
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'dust2'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc