DarkPyro's Servers
  • CSS
  • TF

  Clan Information

Statistics Summary
Clan: trans
Home Page:
Activity: 100.00%
Members: 1 active members (1 total)
Avg. Member Points: 4,780
Total Kills: 912
Total Deaths: 1,573
Avg. Kills: 912
Kills per Death: 0.58
Kills per Minute: 0.71
Total Connection Time: 0d 21h 29m 36s
Avg. Connection Time: 0d 21h 29m 36s
Favorite Server:* ★ DarkPyro's 2FART+ TX *DOUBLE XP WEEKEND*
Favorite Map:* ctf_2fort
Favorite Weapon:* Direct Hit

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  Steam Community AvatarUnited statesmicah_jester-girl.SFM(trans) 4,780 0d 21h 29m 36s 912 100.00% 1,573 0.58




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Kill Assist 436 times 872
2 Stun 309 times 0
3 Rocket Jump 250 times 0
4 Critical Kill 192 times 0
5 Double Kill (2 kills) 101 times 101
6 Revenge 84 times 252
7 Backstab Kill 78 times 156
8 Picked up the flag 53 times 106
9 Kill Assist - Medic 52 times 156
10 Airshot Stun 48 times 0
11 Triple Kill (3 kills) 43 times 86
12 Teleporter used 37 times 37
13 Dropped the flag (on death) 32 times 0
14 Domination 25 times 125
15 Teleporter Used (Not Own) 23 times 0
16 Airblast Player 20 times 0
17 Captured the flag 15 times 75
18 Rocket Jump Kill 12 times 0
19 Force Suicide 12 times 0
20 Teleporter used (self) 11 times 0
21 Airshot Pipebomb 11 times 0
22 Headshot Kill 10 times 20
23 Sticky Jump 8 times 0
24 Domination (4 kills) 8 times 24
25 Defended the flag 8 times 8
26 Airshot Sticky 8 times 0
27 Airshot Flare 8 times 0
28 Dropped the flag (while alive) 6 times -12
29 Killed charged medic 4 times 4
30 Defended a Medic 4 times 4
31 Airshot Rocket (Airborne) 4 times 0
32 Steal Sandvich 3 times 6
33 Rampage (5 kills) 3 times 12
34 Ownage (7 kills) 2 times 12
35 Mega Kill (6 kills) 2 times 10
36 Airshot Arrow 2 times 0
37 Player Penetration 1 times 4
38 Deflected Baseball 1 times 0
39 Airshot Headshot 1 times 0




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Stun 348 times 0
2 Airblast Player 122 times 0
3 Domination 118 times -590
4 Revenge 17 times -51
5 Deflected Directhit Rocket 3 times 0
6 Deflected Rocket 2 times 0
7 Steal Sandvich 1 times -2
8 Deflected Pipebomb 1 times 0
9 Deflected Baseball 1 times 0




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 BLU 35 times 35.35%
2 RED 17 times 17.17%




ERROR
Database Error

Server Address: localhost
Server Username: root

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dpgweb_stats.hlstats_Frags_as_res.killsTotal' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

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