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: 69.75% 69.75%
Members: 4 active members (10 total)
Avg. Member Points: 26,189
Total Kills: 102,446
Total Deaths: 66,986
Avg. Kills: 25,612
Kills per Death: 1.53
Kills per Minute: 1.08
Total Connection Time: 66d 02:33:01h
Avg. Connection Time: 16d 12:38:15h
Favorite Server:* Online-Wars.Ru TF2 | Only cp_orange x3 | S2
Favorite Map:* cp_orange_x3_exe
Favorite Weapon:* Eyelander
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Russian federation[23s']Kamikaze 39,740 39% 24d 22:46:22h 31,927 31.16% 31.16% 20,223 1.58
2  Russian federation[23s']Blutgardist 32,737 81% 10d 03:55:47h 15,756 15.38% 15.38% 8,148 1.93
3  Ukraine[23s']Little_Scout 26,327 100% 18d 23:18:10h 37,241 36.35% 36.35% 19,164 1.94
4  Russian federation[23s']DreamMaker 5,951 59% 12d 00:32:42h 17,522 17.10% 17.10% 19,451 0.90




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Rocket Jump 736 times 0
2 Stun 299 times 0
3 Airshot Stun 295 times 0
4 Kill Assist 263 times 263
5 Airblast Player 195 times 0
6 Critical Kill 181 times 0
7 Airshot Rocket 161 times 0
8 Sticky Jump 129 times 0
9 Mad Milking a player 122 times 0
10 Domination 121 times 605
11 Kill Assist - Medic 114 times 114
12 Double Kill (2 kills) 83 times 83
13 Triple Kill (3 kills) 67 times 134
14 Ubercharge 51 times 51
15 Extinguished Teammate (Medic) 47 times 47
16 Deflected Rocket 40 times 0
17 Destroyed a sentry gun 30 times 120
18 Deflected Pipebomb 26 times 0
19 Rocket Jump Kill 24 times 0
20 Revenge 24 times 72
21 Domination (4 kills) 23 times 69
22 Airshot Rocket (Airborne) 23 times 46
23 Defended a Medic 22 times 22
24 Extinguished Teammate (Pyro) 21 times 21
25 Destroyed a mini sentry gun 21 times 84
26 Force Suicide 20 times 0
27 Rampage (5 kills) 15 times 60
28 God Like (12+ kills) 14 times 154
29 Extinguished Teammate (Scout) 14 times 14
30 Destroyed a dispenser 14 times 42
31 Capture Blocked 13 times 13
32 Teleporter Used (Not Own) 12 times 0
33 Headshot Kill 12 times 12
34 Destroyed a teleporter 11 times 22
35 Point Captured 10 times 50
36 Mega Kill (6 kills) 9 times 45
37 Ownage (7 kills) 5 times 30
38 Killing Spree (9 kills) 4 times 32
39 Deflected Arrow 4 times 12
40 Unstoppable (11 kills) 3 times 30
41 Monster Kill (10 kills) 3 times 27
42 Ultra Kill (8 kills) 2 times 14
43 Killed charged medic 2 times 4
44 Deflected Flare 2 times 2
45 Deflected Directhit Rocket 2 times 0
46 Backstab Kill 2 times 4
47 Airshot Flare 2 times 0
48 Sticky Jump Kill 1 times 0
49 MVP #1 1 times 5
50 Blocked with Shield 1 times 0
51 Airshot Pipebomb 1 times 0




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Stun 258 times 0
2 Airblast Player 118 times 0
3 Revenge 64 times -192
4 Domination 39 times -195
5 Jarated player 31 times 0
6 Mad Milking a player 24 times 0
7 Deflected Rocket 3 times 0




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 The RED 33 times 27.27% 27.27%
2 The BLU 30 times 24.79% 24.79%




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(204 = 0, 1, 204) * 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