HLstatsX Community Edition
  • Contents
  • Search
  • Help

  Sections

  Daily Awards (Saturday 23 Jun)

AK47

ak47

   .:: HENRY III::.#|DAVAJ|
65 kills with ak47
AWP

awp

   No RuLzZ #|DAVAJ|
134 snipings with awp
Best Latency

latency

   Craniax
6 ms average connection
Colt M4A1 Carbine

m4a1

   Blaze
85 kills with m4a1
Desert Eagle

deagle

   No RuLzZ #|DAVAJ|
50 kills with deagle
Dual Berretta Elites

elite

No Award Winner
0 kills with elite
Fusil Automatique

famas

   Killer
9 kills with famas
Galil

galil

   Blaze
20 kills with galil
Glock

glock18

   ZeuS- #|G.^o^.D|
1 kills with glock18
Grenadier

grenade

   Blaze
8 kills with grenade
Headshot King

headshot

   No RuLzZ #|DAVAJ|
58 headshots
Knife Maniac

knife

   ZeuS- #|G.^o^.D|
5 knifings
P90

p90

   blackline antanio spenza
3 kills with p90
Shotgun

m3

   pashtet
1 kills with m3 shotgun
Top Assassin

Assassinated_The_VIP

No Award Winner
0 assassinations
Top Defuser

Defused_The_Bomb

   zxcvb
7 bomb defusions
Top Demolitionist

Planted_The_Bomb

   No RuLzZ #|DAVAJ|
25 bomb plantings
Top Hostage Rescuer

Rescued_A_Hostage

No Award Winner
0 hostages rescued
USP Master

usp

   Homo Sapien
8 kills with usp
 
  Global Awards

AK47

ak47

   ScreaM
588 kills with ak47
AWP

awp

   .:: HENRY III::.#|DAVAJ|
1038 snipings with awp
Best Latency

latency

   pinkfloyd
3 ms average connection
Colt M4A1 Carbine

m4a1

   Blaze
332 kills with m4a1
Desert Eagle

deagle

   No RuLzZ #|DAVAJ|
257 kills with deagle
Dual Berretta Elites

elite

   No RuLzZ #|DAVAJ|
5 kills with elite
Fusil Automatique

famas

   unnamed
20 kills with famas
Galil

galil

   Blaze
116 kills with galil
Glock

glock18

   ScreaM
11 kills with glock18
Grenadier

grenade

   Warlord
48 kills with grenade
Headshot King

headshot

   Player
554 headshots
Knife Maniac

knife

   No RuLzZ #|DAVAJ|
22 knifings
P90

p90

   BIN LADEN
53 kills with p90
Shotgun

m3

   mOVe On
51 kills with m3 shotgun
Top Assassin

Assassinated_The_VIP

No Award Winner
0 assassinations
Top Defuser

Defused_The_Bomb

   Blaze
16 bomb defusions
Top Demolitionist

Planted_The_Bomb

   .:: HENRY III::.#|DAVAJ|
137 bomb plantings
Top Hostage Rescuer

Rescued_A_Hostage

   Player
2 hostages rescued
USP Master

usp

   RJ ! ! !
10 kills with usp
 
ERROR
Database Error

Server Address: localhost
Server Username: root

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlx.hlstats_Ranks.rankId' 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
			rankName,
			minKills,
			rankId,
			count(playerId) AS obj_count
		FROM
			hlstats_Ranks
		INNER JOIN
			hlstats_Players
		ON (
           hlstats_Ranks.game=hlstats_Players.game
           )	
		WHERE
			kills>=minKills
			AND kills<=maxKills
			AND hlstats_Ranks.game='newcode'
		GROUP BY
			rankName,
			minKills