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: 99.00% 99.00%
Members: 1 active members (1 total)
Avg. Member Points: 11,282
Total Kills: 1,291
Total Deaths: 442
Avg. Kills: 1,291
Kills per Death: 2.92
Kills per Minute: 0.99
Total Connection Time: 0d 21:47:52h
Avg. Connection Time: 0d 21:47:52h
Favorite Server:* csko.cz | dust2 only
Favorite Map:* de_dust2
Favorite Weapon:* Kalashnikov AK-47
Player Locations

  Members

Rank Name Points Activity Time Kills Clan Kills % Deaths sort-descending.gif Kpd
1  No Country-**D@n3CEK**- k!lLmast3r 11,282 99% 0d 21:47:52h 1,291 100.00% 100.00% 442 2.92




  Player Actions *

Rank Action Achieved sort-ascending.gif Points Bonus
1 Ownage (7 kills) 1 times 6
2 Start Defusing the Bomb Without a Defuse Kit 2 times 0
3 Mega Kill (6 kills) 4 times 20
4 Rampage (5 kills) 14 times 56
5 Defuse the Bomb 18 times 270
6 Drop the Bomb 19 times -38
7 Start Defusing the Bomb With a Defuse Kit 20 times 0
8 Pick up the Bomb 37 times 74
9 Domination (4 kills) 42 times 126
10 Spawn with the Bomb 47 times 94
11 Plant the Bomb 49 times 735
12 Triple Kill (3 kills) 93 times 186
13 Double Kill (2 kills) 174 times 174
14 Headshot 307 times 307




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Counter-Terrorist 67 times 58.26% 58.26%
2 Terrorist 43 times 37.39% 37.39%




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