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

Banner
  Sections

  Clan Information

Statistics Summary
Clan: WCHFM
Home Page:
Activity: 41.60% 41.60%
Members: 5 active members (6 total)
Avg. Member Points: 1,969
Total Kills: 5,711
Total Deaths: 5,157
Avg. Kills: 1,142
Kills per Death: 1.11
Kills per Minute: 1.38
Total Connection Time: 2d 20:52:26h
Avg. Connection Time: 0d 13:46:29h
Favorite Server:* Online-Wars.Ru TF2 | MGE
Favorite Map:* mge_training_v8_beta4b
Favorite Weapon:* Stickybomb Launcher
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Russian federationvitamin4il [WCHFM] 2,670 3% 1d 21:19:56h 3,922 68.67% 68.67% 2,884 1.36
2  Belarus-Harry [WCHFM] 2,356 63% 0d 10:36:40h 772 13.52% 13.52% 801 0.96
3  Russian federationStyX [WCHFM] 1,991 23% 0d 04:17:11h 406 7.11% 7.11% 527 0.77
4  Russian federationКида[WCHFM] 1,856 96% 0d 08:20:47h 601 10.52% 10.52% 925 0.65
5  Russian federationSuper Kvasik, Hardbasik [WCHFM] 972 23% 0d 00:17:52h 10 0.18% 0.18% 20 0.50




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Rocket Jump 1,450 times 0
2 Airshot Rocket 1,110 times 0
3 Airshot Pipebomb 370 times 0
4 Airshot Rocket (Airborne) 318 times 0
5 Sticky Jump 238 times 0
6 Airshot Sticky 226 times 0
7 Double Kill (2 kills) 114 times 114
8 Revenge 80 times 240
9 Domination 75 times 375
10 Force Suicide 65 times 0
11 Critical Kill 58 times 0
12 Rocket Jump Kill 56 times 0
13 Triple Kill (3 kills) 49 times 98
14 Domination (4 kills) 41 times 123
15 Backstab Kill 36 times 72
16 Headshot Kill 24 times 48
17 Airblast Player 20 times 0
18 Mega Kill (6 kills) 12 times 60
19 Rampage (5 kills) 11 times 44
20 God Like (12+ kills) 5 times 55
21 Ultra Kill (8 kills) 4 times 28
22 Ownage (7 kills) 3 times 18
23 Deflected Pipebomb 3 times 0
24 Killed charged medic 2 times 2
25 Deflected Flare 2 times 0
26 Monster Kill (10 kills) 1 times 9
27 Killing Spree (9 kills) 1 times 8
28 Airshot Pipebomb (Airborne) 1 times 0
29 Airshot Flare 1 times 0




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Domination 85 times -425
2 Revenge 71 times -213
3 Airblast Player 40 times 0
4 Deflected Pipebomb 26 times 0
5 Stun 11 times 0
6 Jarated player 1 times -1
7 Deflected Rocket 1 times 0




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 The RED 74 times 27.82% 27.82%
2 The BLU 41 times 15.41% 15.41%




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(76 = 0, 1, 76) * 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='tf2mge'
			AND hlstats_Players.clan=22524
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'tf2mge'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc