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: 23s'
Home Page:
Activity: 84.60% 84.60%
Members: 5 active members (8 total)
Avg. Member Points: 22,823
Total Kills: 112,547
Total Deaths: 77,925
Avg. Kills: 22,509
Kills per Death: 1.44
Kills per Minute: 1.04
Total Connection Time: 75d 03:16:05h
Avg. Connection Time: 15d 00:39:13h
Favorite Server:* Online-Wars.Ru TF2 | Only cp_orange x3 | S2
Favorite Map:* cp_orange_x3_exe
Favorite Weapon:* Pyro Shotgun
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Russian federation[23s']Kamikaze 39,936 97% 25d 00:42:54h 32,044 28.47% 28.47% 20,256 1.58
2  Russian federation[23s']Blutgardist 37,599 100% 12d 08:21:57h 19,345 17.19% 17.19% 9,598 2.02
3  Ukraine[23s']Little_Scout 27,081 89% 20d 08:36:42h 40,150 35.67% 35.67% 20,770 1.93
4  Russian federation[23s']DreamMaker 5,951 84% 12d 00:32:44h 17,522 15.57% 15.57% 19,451 0.90
5  Russian federation[23s']BootbOi! 3,546 53% 5d 09:01:48h 3,486 3.10% 3.10% 7,850 0.44




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Airblast Player 1,887 times 0
2 Kill Assist 703 times 703
3 Deflected Rocket 390 times 0
4 Airshot Rocket 376 times 0
5 Rocket Jump 374 times 0
6 Critical Kill 338 times 0
7 Domination 305 times 1,525
8 Deflected Pipebomb 287 times 0
9 Headshot Kill 244 times 244
10 Extinguished Teammate (Pyro) 201 times 201
11 Double Kill (2 kills) 166 times 166
12 Teleporter Used (Not Own) 134 times 0
13 Kill Assist - Medic 118 times 118
14 Defended a Medic 100 times 100
15 Triple Kill (3 kills) 95 times 190
16 Sticky Jump 85 times 0
17 Deflected Directhit Rocket 79 times 0
18 Domination (4 kills) 66 times 198
19 Capture Blocked 60 times 60
20 Revenge 56 times 168
21 Deflected Arrow 54 times 162
22 Airshot Pipebomb 49 times 0
23 Rampage (5 kills) 45 times 180
24 Extinguished Teammate (Medic) 42 times 42
25 Force Suicide 40 times 0
26 Ubercharge 39 times 39
27 Mega Kill (6 kills) 38 times 190
28 Point Captured 33 times 165
29 Destroyed a sentry gun 32 times 128
30 God Like (12+ kills) 29 times 319
31 Stun 28 times 0
32 Deployed Buff Flag 27 times 27
33 Airshot Headshot 22 times 0
34 Ultra Kill (8 kills) 21 times 147
35 Destroyed a mini sentry gun 20 times 80
36 Ownage (7 kills) 19 times 114
37 Rocket Jump Kill 16 times 0
38 Killing Spree (9 kills) 16 times 128
39 Destroyed a teleporter 16 times 32
40 Destroyed a dispenser 16 times 48
41 Deflected Flare 15 times 15
42 Teleporter used 13 times 13
43 Killed charged medic 12 times 24
44 Monster Kill (10 kills) 10 times 90
45 Airshot Rocket (Airborne) 10 times 20
46 Teleporter used (self) 9 times 0
47 Airshot Stun 9 times 0
48 Unstoppable (11 kills) 7 times 70
49 Backstab Kill 7 times 14
50 Airshot Flare 6 times 0
51 Removed a Sapper 4 times 4
52 MVP #2 2 times 6
53 Jarated player 2 times 0
54 Airshot Arrow 2 times 0
55 MVP #1 1 times 5
56 Mad Milking a player 1 times 0
57 Extinguished Teammate (Scout) 1 times 1
58 Deflected Baseball 1 times 1
59 Blocked with Shield 1 times 0




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Airblast Player 301 times 0
2 Stun 283 times 0
3 Revenge 179 times -537
4 Domination 72 times -360
5 Jarated player 63 times 0
6 Mad Milking a player 30 times 0
7 Deflected Rocket 19 times 0
8 Deflected Pipebomb 2 times 0




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 The RED 42 times 26.58% 26.58%
2 The BLU 28 times 17.72% 17.72%




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