HLstatsX Community Edition
  • PUBLIC1
  • PUBLIC2
  • DUST1
  • DUST2
  • HNS_CLASSIC
  • MANIAC
  • HNSRPG
  • JAIL
  • AWP1
  • AWP2
  • MG1
  • SURFCL
  • SURFNEW
  • SURFOLD
  • SURFRPG
  • TIMER
  • PUBLIC3
  • DUST3
  • DUST4
  • HNSCLPRE
  • MIRAGE1
  • Contents
  • Search
  • Help

  Clan Information

Statistics Summary
Clan: 109 bat
Home Page:
Activity: 78.71%
Members: 7 active members (8 total)
Avg. Member Points: 4,567
Total Kills: 11,163
Total Deaths: 8,463
Avg. Kills: 1,595
Kills per Death: 1.32
Kills per Minute: 0.62
Total Connection Time: 12d 11:06:09h
Avg. Connection Time: 1d 18:43:44h
Favorite Server:* [bamigos.ru]Classic Public #2
Favorite Map:* de_dust2
Favorite Weapon:* Kalashnikov AK-47
Player Locations

  Members

Rank Name Rank Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  .gifsmith-¯\_( ͡° ͜ʖ ͡°)_/¯ elorank 10,351 3d 12:04:41h 3,980 35.65% 1,894 2.10
2  .gifChelovek-¯\_( ͡° ͜ʖ ͡°)_/ elorank 7,477 4d 09:37:03h 4,434 39.72% 3,826 1.16
3  .gifch0ji elorank 5,218 1d 00:39:45h 1,211 10.85% 654 1.85
4  .gifzakir1923 elorank 3,795 1d 20:18:43h 1,027 9.20% 1,178 0.87
5  .gifВИТЕЧКа elorank 2,173 1d 08:40:32h 376 3.37% 752 0.50
6  .gifBrouk elorank 1,935 0d 07:30:32h 132 1.18% 158 0.84
7  .gifNASA elorank 1,019 0d 00:14:53h 3 0.03% 1 3.00




  Player Actions *

Rank Action Achieved sort-descending.gif Points Bonus
1 Headshot 764 times 764
2 Double Kill (2 kills) 279 times 279
3 Round MVP 218 times 0
4 Pick up the Bomb 211 times 422
5 Drop the Bomb 151 times -302
6 Triple Kill (3 kills) 110 times 220
7 Domination (4 kills) 49 times 147
8 Plant the Bomb 47 times 470
9 Touch a Hostage 18 times 0
10 Start Defusing the Bomb With a Defuse Kit 13 times 0
11 Rampage (5 kills) 12 times 48
12 Defuse the Bomb 8 times 80
13 Rescue a Hostage 5 times 25
14 Mega Kill (6 kills) 5 times 25
15 Ultra Kill (8 kills) 1 times 7
16 Ownage (7 kills) 1 times 6




ERROR
Database Error

Server Address: localhost
Server Username: c1_hlstats

Error Diagnostic:
Bad query.

Server Error: (1267) Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_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(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='Public2'
AND hlstats_Players.clan=63
AND (hidden <>'1' OR hidden IS NULL)
AND hlstats_Roles.game = 'Public2'
GROUP BY
hlstats_Events_ChangeRole.role
ORDER BY
rolecount desc,
name desc