HLstatsX Community Edition
  • Contents
  • Search
  • Help

  Sections

  Clan Information

Statistics Summary
Clan: KiiNqBl
Home Page:
Activity: 100.00% 100.00%
Members: 1 active members (1 total)
Avg. Member Points: 84,789
Total Kills: 15,615
Total Deaths: 21,853
Avg. Kills: 15,615
Kills per Death: 0.71
Kills per Minute: 0.75
Total Connection Time: 14d 12:23:05h
Avg. Connection Time: 14d 12:23:05h
Favorite Server:* -= GG-Studio089.de =- Turbo GunGame Simpsons
Favorite Map:* gg_simpsons_green_2
Favorite Weapon:* Steyr Scout
Player Locations

  Members

Rank Name Points sort-descending.gif Activity Time Kills Clan Kills % Deaths Kpd
1  GermanyKiiNqBliiNq..<3 84,789 14d 12:23:05h 15,615 100.00% 21,853 0.71




  Player Actions *

Rank Action Achieved sort-ascending.gif Points Bonus
1 Ownage (7 kills) 1 times 6
2 Ultra Kill (8 kills) 1 times 7
3 Drop the Bomb 2 times -4
4 Pick up the Bomb 2 times 4
5 Mega Kill (6 kills) 8 times 40
6 Rampage (5 kills) 10 times 40
7 Domination 40 times 200
8 Domination (4 kills) 40 times 120
9 Revenge 41 times 123
10 Triple Kill (3 kills) 80 times 160
11 Double Kill (2 kills) 212 times 212
12 for WIN the Round! 226 times 11,300
13 Headshot 11,220 times 11,220




  Victims of Player-Player Actions *

Rank Action Times Victimized sort-descending.gif Points Bonus
1 Revenge 175 times -525
2 Domination 65 times -325




  Team Selection *

Rank Team Joined sort-descending.gif Percentage of Times %
1 Counter-Terrorist 485 times 26.39%
2 Terrorist 438 times 23.83%




ERROR
Database Error

Server Address: localhost
Server Username: hl1148

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