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: 3xo > /dev
Home Page:
Activity: 99.00% 99.00%
Members: 1 active members (6 total)
Avg. Member Points: 139,175
Total Kills: 34,444
Total Deaths: 21,554
Avg. Kills: 34,444
Kills per Death: 1.60
Kills per Minute: 0.74
Total Connection Time: 32d 11:00:48h
Avg. Connection Time: 32d 11:00:48h
Favorite Server:* csko.cz | dust2 only
Favorite Map:* de_dust2
Favorite Weapon:* Colt M4A1 Carbine
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  No Country3xo > /dev/null 139,175 99% 32d 11:00:48h 34,444 100.00% 100.00% 21,554 1.60




  Player Actions *

Rank Action Achieved Points Bonus sort-ascending.gif
1 Drop the Bomb 75 times -150
2 Start Defusing the Bomb With a Defuse Kit 14 times 0
3 Ownage (7 kills) 3 times 18
4 Mega Kill (6 kills) 8 times 40
5 Rampage (5 kills) 19 times 76
6 Pick up the Bomb 41 times 82
7 Defuse the Bomb 9 times 135
8 Spawn with the Bomb 70 times 140
9 Domination (4 kills) 63 times 189
10 Triple Kill (3 kills) 115 times 230
11 Double Kill (2 kills) 243 times 243
12 Plant the Bomb 25 times 375
13 Headshot 589 times 589




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Counter-Terrorist 59 times 44.03% 44.03%
2 Terrorist 56 times 41.79% 41.79%




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=628810
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'dust2'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc