HLstatsX Community Edition
  • Contents
  • Search
  • SourceBans
  • Forum
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: ECU
Home Page:
Activity: 96.00% 96.00%
Members: 1 active members (1 total)
Avg. Member Points: 6,785
Total Kills: 2,626
Total Deaths: 1,503
Avg. Kills: 2,626
Kills per Death: 1.75
Kills per Minute: 1.50
Total Connection Time: 1d 05:06:36h
Avg. Connection Time: 1d 05:06:36h
Favorite Server:* Lokis School of Combat
Favorite Map:* dm_spookface1L_OB
Favorite Weapon:* .357 Magnum
Player Locations

  Members

Rank Name Points sort-ascending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  United states(ECU) BaliCruz 6,785 96% 1d 05:06:36h 2,626 100.00% 100.00% 1,503 1.75




  Player Actions *

Rank Action Achieved Points Bonus sort-ascending.gif
1 Headshot Kill 318 times 0
2 Monster Kill (10 kills) 2 times 18
3 Ultra Kill (8 kills) 7 times 49
4 Unstoppable (11 kills) 5 times 50
5 Killing Spree (9 kills) 8 times 64
6 God Like (12+ kills) 6 times 66
7 Ownage (7 kills) 12 times 72
8 Rampage (5 kills) 20 times 80
9 Mega Kill (6 kills) 21 times 105
10 Domination (4 kills) 46 times 138
11 Double Kill (2 kills) 141 times 141
12 Triple Kill (3 kills) 85 times 170




ERROR
Database Error

Server Address: localhost
Server Username: loki

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'loki.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(0 = 0, 1, 0) * 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='hl2mp'
			AND hlstats_Players.clan=173
			AND (hidden <>'1' OR hidden IS NULL)
			AND hlstats_Roles.game = 'hl2mp'
		GROUP BY
			hlstats_Events_ChangeRole.role
		ORDER BY
			rolecount desc,
			name desc