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: 100.00% 100.00%
Members: 1 active members (6 total)
Avg. Member Points: 144,381
Total Kills: 36,088
Total Deaths: 22,646
Avg. Kills: 36,088
Kills per Death: 1.59
Kills per Minute: 0.74
Total Connection Time: 34d 01:09:59h
Avg. Connection Time: 34d 01:09:59h
Favorite Server:* csko.cz | dust2 only
Favorite Map:* de_dust2
Favorite Weapon:* Colt M4A1 Carbine
Player Locations

  Members

Rank Name Points Activity Time Kills sort-descending.gif Clan Kills % Deaths Kpd
1  No Country3xo > /dev/null 144,381 100% 34d 01:09:59h 36,088 100.00% 100.00% 22,646 1.59




  Player Actions *

Rank Action Achieved Points Bonus sort-ascending.gif
1 Drop the Bomb 94 times -188
2 Start Defusing the Bomb With a Defuse Kit 11 times 0
3 Ownage (7 kills) 1 times 6
4 Ultra Kill (8 kills) 1 times 7
5 Mega Kill (6 kills) 4 times 20
6 Defuse the Bomb 6 times 90
7 Pick up the Bomb 58 times 116
8 Rampage (5 kills) 30 times 120
9 Domination (4 kills) 56 times 168
10 Spawn with the Bomb 85 times 170
11 Double Kill (2 kills) 235 times 235
12 Triple Kill (3 kills) 128 times 256
13 Plant the Bomb 34 times 510
14 Headshot 580 times 580




  Team Selection *

Rank Team sort-descending.gif Joined Percentage of Times %
1 Terrorist 55 times 51.89% 51.89%
2 Counter-Terrorist 45 times 42.45% 42.45%




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