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: DSTR
Home Page:
Activity: 93.75% 93.75%
Members: 4 active members (8 total)
Avg. Member Points: 3,055
Total Kills: 14,617
Total Deaths: 15,747
Avg. Kills: 3,654
Kills per Death: 0.93
Kills per Minute: 1.52
Total Connection Time: 6d 16:38:43h
Avg. Connection Time: 1d 16:09:40h
Favorite Server:* Online-Wars.Ru TF2 | MGE
Favorite Map:* mge_training_v8_beta4b
Favorite Weapon:* Scatter Gun
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Russian federation[DSTR]DarkBlaze 3,806 100% 2d 08:02:03h 5,938 40.62% 40.62% 6,268 0.95
2  Ukraine[DSTR]Dark_Dragon[APG].ukr 3,169 100% 2d 21:48:13h 6,416 43.89% 43.89% 6,264 1.02
3  Ukraine[DSTR]Diw3r4m 2,630 100% 0d 22:04:28h 1,320 9.03% 9.03% 1,914 0.69
4  Ukraine[DSTR]Mishka 2,615 75% 0d 12:43:59h 943 6.45% 6.45% 1,301 0.72




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Rocket Jump 4,686 times 0
2 Airshot Rocket 3,696 times 0
3 Airshot Rocket (Airborne) 897 times 0
4 Double Kill (2 kills) 464 times 464
5 Headshot Kill 435 times 870
6 Revenge 276 times 828
7 Domination 205 times 1,025
8 Critical Kill 202 times 0
9 Force Suicide 196 times 0
10 Rocket Jump Kill 187 times 0
11 Triple Kill (3 kills) 185 times 370
12 Airshot Pipebomb 177 times 0
13 Sticky Jump 173 times 0
14 Airshot Sticky 136 times 0
15 Domination (4 kills) 82 times 246
16 Rampage (5 kills) 45 times 180
17 Jarated player 31 times 31
18 Mega Kill (6 kills) 22 times 110
19 Ownage (7 kills) 17 times 102
20 Airshot Headshot 12 times 0
21 Ultra Kill (8 kills) 10 times 70
22 Kill Assist 10 times 20
23 Killing Spree (9 kills) 8 times 64
24 God Like (12+ kills) 7 times 77
25 Monster Kill (10 kills) 5 times 45
26 Backstab Kill 5 times 10
27 Airshot Sticky (Airborne) 4 times 0
28 Airblast Player 3 times 0
29 Unstoppable (11 kills) 2 times 20
30 Sticky Jump Kill 2 times 0




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Domination 304 times -1520
2 Revenge 178 times -534
3 Deflected Rocket 59 times 0
4 Airblast Player 58 times 0
5 Jarated player 28 times -28
6 Stun 4 times 0




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 The RED 211 times 25.00% 25.00%
2 The BLU 118 times 13.98% 13.98%




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