HLstatsX Community Edition
  • CSGOARENA
  • CSGO
  • CSSDR
  • CSSJAIL
  • CSSMG
  • CSSWCS
  • DODS
  • TF2JUMP
  • TF2MGE
  • TF2MVM1
  • TF2SER2
  • TF2ST STANDART
  • Contents
  • Search
  • SourceBans
  • Forum
  • Help

Banner
  Sections

  Clan Information

Statistics Summary
Clan: :D
Home Page:
Activity: 82.20% 82.20%
Members: 5 active members (10 total)
Avg. Member Points: 10,470
Total Kills: 13,370
Total Deaths: 6,643
Avg. Kills: 2,674
Kills per Death: 2.01
Kills per Minute: 0.66
Total Connection Time: 14d 00:33:15h
Avg. Connection Time: 2d 19:18:39h
Favorite Server:* [Online-Wars.Ru] CSS |WarCraft| S1
Favorite Map:* surf_4fun_e
Favorite Weapon:* Colt M4A1 Carbine
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Ukraine2D Kuuppi [:D] 29,203 31% 7d 15:00:32h 8,937 66.84% 66.84% 3,500 2.55
2  Russian federation2D SHAPKA [:D] 12,780 95% 4d 16:59:20h 3,073 22.98% 22.98% 2,176 1.41
3  Ukraine2D I.G.O.R [:D] 5,791 98% 1d 00:36:28h 973 7.28% 7.28% 627 1.55
4  Ukraine2D Kuuppi [:D] 2,392 92% 0d 03:32:40h 158 1.18% 1.18% 30 5.27
5  Russian federation2D DaMak [:D] 2,185 95% 0d 12:24:15h 229 1.71% 1.71% 310 0.74




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Round MVP 191 times 0
2 Headshot 132 times 132
3 Double Kill (2 kills) 110 times 110
4 Pick up the Bomb 65 times 130
5 Domination 38 times 190
6 Plant the Bomb 15 times 150
7 Drop the Bomb 15 times -30
8 Triple Kill (3 kills) 4 times 8
9 Revenge 4 times 12
10 Defuse the Bomb 3 times 30
11 Start Defusing the Bomb With a Defuse Kit 2 times 0
12 Start Defusing the Bomb Without a Defuse Kit 1 times 0




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 17 times -51
2 Domination 9 times -45




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Terrorist 63 times 25.82% 25.82%
2 Counter-Terrorist 52 times 21.31% 21.31%




ERROR
Database Error

Server Address: localhost
Server Username: servers

Error Diagnostic:
Bad query.

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