HLstatsX Community Edition
  • Contents
  • Search
  • SourceBans
  • Forum
  • Help

  Clan Information

Statistics Summary
Clan: нeadнuNteR
Home Page:
Activity: 84.33%
Members: 6 active members (10 total)
Avg. Member Points: 29,742
Total Kills: 54,537
Total Deaths: 38,291
Avg. Kills: 9,090
Kills per Death: 1.42
Kills per Minute: 0.59
Total Connection Time: 64d 04:53:55h
Avg. Connection Time: 10d 16:48:59h
Favorite Server:* * SchlachtHof :|: Dust2 Only :|: *Test* // noAim.eu
Favorite Map:* de_dust2
Favorite Weapon:* M249 PARA Light Machine Gun
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  AustriaLuckyshO† ²high²fly elorank 44,645 11d 15:34:41h 13,393 24.56% 6,270 2.14
2  Germany.ReD_SaV!Na`chK elorank 37,172 5d 04:56:44h 6,056 11.10% 2,733 2.22
3  The netherlands☆Dipsy-Goldwing♥ elorank 35,184 29d 13:45:47h 22,768 41.75% 20,482 1.11
4  GermanyeLoQiiX elorank 32,682 12d 14:22:52h 8,309 15.24% 6,335 1.31
5  GermanyrAiN elorank 21,386 4d 10:24:03h 3,658 6.71% 2,089 1.75
6  GermanyJAWS elorank 7,384 0d 17:49:48h 353 0.65% 382 0.92




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 1,707 times 1,707
2 Double Kill (2 kills) 543 times 543
3 Pick up the Bomb 295 times 885
4 Triple Kill (3 kills) 274 times 548
5 Drop the Bomb 147 times -441
6 Plant the Bomb 121 times 726
7 Domination (4 kills) 99 times 297
8 Start Defusing the Bomb With a Defuse Kit 57 times 0
9 Defuse the Bomb 40 times 400
10 Rampage (5 kills) 33 times 132
11 Mega Kill (6 kills) 10 times 50
12 Ownage (7 kills) 7 times 42
13 Ultra Kill (8 kills) 2 times 14
14 Start Defusing the Bomb Without a Defuse Kit 2 times 0




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Counter-Terrorist 216 times 29.83%
2 Terrorist 209 times 28.87%




ERROR
Database Error

Server Address: localhost
Server Username: hlsx

Error Diagnostic:
Bad query.

Server Error: (1267) Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_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='css'
			AND hlstats_Players.clan=20
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'css'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc