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

  Clan Information

Statistics Summary
Clan: 보스
Home Page:
Activity: 100.00%
Members: 22 active members (44 total)
Avg. Member Points: 1,483
Total Kills: 649
Total Deaths: 1,957
Avg. Kills: 30
Kills per Death: 0.33
Kills per Minute: 0.20
Total Connection Time: 2d 06:21:15h
Avg. Connection Time: 0d 02:28:14h
Favorite Server:*
Favorite Map:*
Favorite Weapon:* Bundeswehr Advanced Combat Knife
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  No Country[보스] 라미아 아르세인 elorank 7,430 0d 13:11:26h 298 45.92% 318 0.94
2  No Country[보스] 신디아 일리지스 elorank 2,796 0d 07:36:00h 117 18.03% 399 0.29
3  No Country[보스] 잭 펠드릭스 elorank 2,179 0d 05:50:53h 93 14.33% 400 0.23
4  No Country[보스] 플레타 옥시노스 elorank 1,493 0d 08:28:57h 63 9.71% 517 0.12
5  No Country[보스] 세이람 이아가르 elorank 1,456 0d 17:25:13h 63 9.71% 270 0.23
6  No Country[보스] 뱀파이어 백작 � elorank 1,208 0d 01:13:53h 3 0.46% 13 0.23
7  No Country[보스] 뱀파이어 백작 elorank 1,024 0d 00:10:07h 0 0.00% 0 0.00
8  No Country[보스] 메이즈 오르시아 elorank 1,023 0d 00:02:49h 8 1.23% 1 8.00
9  No Country[보스] 골목 지배자 잭 elorank 1,005 0d 00:04:04h 2 0.31% 2 1.00
10  No Country[보스] 신디아 오르시아 elorank 1,004 0d 00:03:52h 1 0.15% 0 1.00
11  No Country[보스] 라미아 아르세인 elorank 1,002 0d 00:00:47h 1 0.15% 2 0.50
12  No Country[보스] 화염술사 신디아 elorank 1,000 0d 00:00:26h 0 0.00% 1 0.00
13  No Country[보스] 신디아 일리지스 elorank 1,000 0d 00:00:25h 0 0.00% 1 0.00
14  No Country[보스] 라미아 아르세인 elorank 1,000 0d 00:00:46h 0 0.00% 2 0.00
15  No Country[보스] 잭 펠드릭스 elorank 1,000 0d 00:00:22h 0 0.00% 1 0.00
16  No Country[보스] 신디아 일리지스 elorank 1,000 0d 00:03:18h 0 0.00% 9 0.00
17  No Country[보스] 니베르크 elorank 1,000 0d 00:01:55h 0 0.00% 5 0.00
18  No Country[보스] 제드 elorank 1,000 0d 00:01:01h 0 0.00% 3 0.00
19  No Country[보스] 세이람 이아가르 elorank 1,000 0d 00:01:06h 0 0.00% 3 0.00
20  No Country[보스] 플레타 옥시노스 elorank 1,000 0d 00:01:50h 0 0.00% 5 0.00


Page: 1 2




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Round MVP 1,567 times 0
2 Double Kill (2 kills) 779 times 779
3 Triple Kill (3 kills) 323 times 646
4 Killing Spree (9 kills) 230 times 1,840
5 God Like (12+ kills) 223 times 2,453
6 Monster Kill (10 kills) 137 times 1,233
7 Domination (4 kills) 117 times 351
8 Ultra Kill (8 kills) 97 times 679
9 Rampage (5 kills) 86 times 344
10 Unstoppable (11 kills) 76 times 760
11 Ownage (7 kills) 71 times 426
12 Mega Kill (6 kills) 48 times 240
13 Domination 15 times 75
14 Headshot 2 times 2




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 4 times -12
2 Domination 1 times -5




ERROR
Database Error

Server Address: localhost
Server Username: hlstatsx

Error Diagnostic:
Bad query.

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