HLstatsX Community Edition
  • DODS
  • TF2JUMP
  • TF2MGE
  • TF2MVM1
  • TF2SER2
  • TF2ST STANDART
  • Contents
  • Search
  • SourceBans
  • Forum
  • Help

Banner
  Sections

  Clan Information

Statistics Summary
Clan: RUS
Home Page:
Activity: 90.71% 90.71%
Members: 7 active members (58 total)
Avg. Member Points: 1,076
Total Kills: 1,036
Total Deaths: 1,214
Avg. Kills: 148
Kills per Death: 0.85
Kills per Minute: 1.06
Total Connection Time: 0d 16:13:17h
Avg. Connection Time: 0d 02:19:02h
Favorite Server:* Online-Wars.Ru TF2 | MGE
Favorite Map:*
Favorite Weapon:* Knife
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Russian federationmogo(rus) 1,456 100% 0d 04:49:54h 217 20.95% 20.95% 227 0.96
2  Russian federation(RUS) men Mannco.trade 1,311 100% 0d 01:40:00h 91 8.78% 8.78% 63 1.44
3  Russian federationEng bro (Rus) 1,116 100% 0d 06:14:13h 574 55.41% 55.41% 570 1.01
4  Russian federationMAKLAYD (RUS) 1,000 35% 0d 00:05:35h 0 0.00% 0.00% 0 0.00
5  Russian federationMr.Foxy(rus) 969 100% 0d 00:07:22h 1 0.10% 0.10% 13 0.08
6  Russian federationптицка 2.0 :3 (rus) 953 100% 0d 00:24:51h 1 0.10% 0.10% 22 0.05
7  Russian federationIvan (RUS) 726 100% 0d 02:51:22h 152 14.67% 14.67% 319 0.48




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Rocket Jump 910 times 0
2 Airblast Player 393 times 0
3 Airshot Rocket 335 times 0
4 Critical Kill 162 times 0
5 Force Suicide 135 times 0
6 Stun 110 times 0
7 Double Kill (2 kills) 103 times 103
8 Deflected Rocket 93 times 0
9 Sticky Jump 85 times 0
10 Airshot Rocket (Airborne) 84 times 0
11 Backstab Kill 77 times 154
12 Headshot Kill 73 times 146
13 Revenge 58 times 174
14 Domination 49 times 245
15 Airshot Stun 46 times 0
16 Triple Kill (3 kills) 39 times 78
17 Airshot Pipebomb 30 times 0
18 Rocket Jump Kill 27 times 0
19 Jarated player 27 times 27
20 Domination (4 kills) 22 times 66
21 Airshot Flare 17 times 0
22 Deflected Arrow 14 times 0
23 Rampage (5 kills) 9 times 36
24 Mega Kill (6 kills) 8 times 40
25 Ubercharge 7 times 7
26 Airshot Sticky 7 times 0
27 Deflected Directhit Rocket 6 times 0
28 Airshot Arrow 6 times 0
29 Ultra Kill (8 kills) 4 times 28
30 Deflected Baseball 4 times 0
31 Airshot Headshot 4 times 0
32 God Like (12+ kills) 2 times 22
33 Deflected Pipebomb 2 times 0
34 Deflected Flare 2 times 0
35 Killing Spree (9 kills) 1 times 8
36 Killed charged medic 1 times 1
37 Deployed Buff Flag 1 times 1




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Airblast Player 327 times 0
2 Deflected Rocket 91 times 0
3 Domination 65 times -325
4 Stun 53 times 0
5 Revenge 48 times -144
6 Deflected Pipebomb 11 times 0
7 Deflected Flare 10 times 0
8 Deflected Directhit Rocket 4 times 0
9 Mad Milking a player 3 times 0




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 The RED 53 times 26.77% 26.77%
2 The BLU 31 times 15.66% 15.66%




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