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: SidoniaN
Home Page:
Activity: 100.00% 100.00%
Members: 1 active members (3 total)
Avg. Member Points: 150,171
Total Kills: 24,381
Total Deaths: 19,100
Avg. Kills: 24,381
Kills per Death: 1.28
Kills per Minute: 0.54
Total Connection Time: 31d 10:38:11h
Avg. Connection Time: 31d 10:38:11h
Favorite Server:* csko.cz | dust2 only
Favorite Map:* de_dust2
Favorite Weapon:* Kalashnikov AK-47
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Slovakia1991991 [SidoniaN] 150,171 100% 31d 10:38:11h 24,381 100.00% 100.00% 19,100 1.28




  Player Actions *

Rank Action Achieved sort-ascending.gif Points Bonus
1 Mega Kill (6 kills) 1 times 5
2 Rampage (5 kills) 1 times 4
3 Start Defusing the Bomb With a Defuse Kit 1 times 0
4 Defuse the Bomb 2 times 30
5 Start Defusing the Bomb Without a Defuse Kit 2 times 0
6 Domination (4 kills) 8 times 24
7 Triple Kill (3 kills) 20 times 40
8 Plant the Bomb 62 times 930
9 Drop the Bomb 63 times -126
10 Pick up the Bomb 63 times 126
11 Spawn with the Bomb 85 times 170
12 Double Kill (2 kills) 110 times 110
13 Headshot 237 times 237




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Terrorist 68 times 75.56% 75.56%
2 Counter-Terrorist 22 times 24.44% 24.44%




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