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

Banner
  Sections

  Clan Information

Statistics Summary
Clan: D.W.R.
Home Page:
Activity: 100.00% 100.00%
Members: 4 active members (7 total)
Avg. Member Points: 2,061
Total Kills: 1,029
Total Deaths: 1,076
Avg. Kills: 257
Kills per Death: 0.96
Kills per Minute: 0.47
Total Connection Time: 1d 12:43:02h
Avg. Connection Time: 0d 09:10:45h
Favorite Server:* Online-Wars.Ru TF2 | ctf_turbine| S3
Favorite Map:* ctf_turbine
Favorite Weapon:* Tomislav
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Russian federation[D.W.R.] KABOOM! 2,347 100% 0d 07:21:27h 229 22.25% 22.25% 166 1.38
2  Russian federation[D.W.R.] Nick_72 2,087 100% 0d 13:23:51h 274 26.63% 26.63% 301 0.91
3  Russian federation[D.W.R.] Delirium CeyKa 1,976 100% 0d 05:52:59h 221 21.48% 21.48% 212 1.04
4  Ukraine[D.W.R.] Andruha 1,835 100% 0d 10:04:45h 305 29.64% 29.64% 397 0.77




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Stun 405 times 0
2 Ubercharge 262 times 262
3 Critical Kill 138 times 0
4 Airblast Player 111 times 0
5 Kill Assist - Medic 103 times 309
6 Rocket Jump 100 times 0
7 Airshot Rocket 75 times 0
8 Kill Assist 66 times 132
9 Backstab Kill 64 times 128
10 Airshot Stun 56 times 0
11 Defended a Medic 40 times 40
12 Double Kill (2 kills) 39 times 39
13 Force Suicide 34 times 0
14 Destroyed a sentry gun 32 times 128
15 Domination 31 times 155
16 Triple Kill (3 kills) 27 times 54
17 Picked up the flag 24 times 48
18 Extinguished Teammate (Medic) 23 times 23
19 Headshot Kill 21 times 42
20 Revenge 18 times 54
21 Airshot Flare 18 times 0
22 Domination (4 kills) 15 times 45
23 Deflected Rocket 15 times 0
24 Dropped the flag (on death) 12 times 0
25 Defended the flag 9 times 9
26 Jarated player 8 times 0
27 Captured the flag 8 times 40
28 Destroyed a dispenser 6 times 18
29 Ultra Kill (8 kills) 5 times 35
30 Teleporter Used (Not Own) 5 times 0
31 Rocket Jump Kill 5 times 0
32 Rampage (5 kills) 4 times 16
33 MVP #1 4 times 20
34 Mega Kill (6 kills) 4 times 20
35 Airshot Rocket (Airborne) 4 times 0
36 MVP #2 3 times 9
37 Killed charged medic 3 times 3
38 Dropped the flag (while alive) 3 times -6
39 Sticky Jump 2 times 0
40 Removed a Sapper 2 times 2
41 Ownage (7 kills) 2 times 12
42 Extinguished Teammate (Pyro) 2 times 2
43 Destroyed a teleporter 2 times 4
44 God Like (12+ kills) 1 times 11
45 Extinguished Teammate (Engineer) 1 times 1
46 Deployed Buff Flag 1 times 1
47 Airshot Pipebomb 1 times 0
48 Airshot Headshot 1 times 0




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Airblast Player 82 times 0
2 Jarated player 55 times 0
3 Stun 52 times 0
4 Domination 27 times -135
5 Revenge 18 times -54
6 Deflected Rocket 12 times 0
7 Blocked with Shield 2 times 0
8 Steal Sandvich 1 times -2




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 The BLU 29 times 30.53% 30.53%
2 The RED 28 times 29.47% 29.47%




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