HLstatsX Community Edition
  • Contents
  • Search
  • Help

Banner
  Daily Awards (Friday 28 Nov)

AK47

ak47

BE   WooHoO.be
206 kills with ak47
AWP

awp

BE   Jean-Michel
32 snipings with awp
Best Latency

latency

GB   `RTB | whyy0umaD
8 ms average connection
Colt M4A1 Carbine

m4a1

BE   WooHoO.be
62 kills with m4a1
Desert Eagle

deagle

BE   WooHoO.be
20 kills with deagle
Dual Berretta Elites

elite

No Award Winner
0 kills with elite
Fusil Automatique

famas

No Award Winner
0 kills with famas
Galil

galil

NL   Saint69 goodfellas 070
35 kills with galil
Glock

glock18

BE   Jean-Michel
2 kills with glock18
Grenadier

grenade

BE   WooHoO.be
72 kills with grenade
Headshot King

headshot

BE   WooHoO.be
127 headshots
Knife Maniac

knife

DE   Fleischermeister Geschnitten
45 knifings
P90

p90

No Award Winner
0 kills with p90
Shotgun

m3

No Award Winner
0 kills with m3 shotgun
Top Assassin

Assassinated_The_VIP

No Award Winner
0 assassinations
Top Defuser

Defused_The_Bomb

No Award Winner
0 bomb defusions
Top Demolitionist

Planted_The_Bomb

No Award Winner
0 bomb plantings
Top Hostage Rescuer

Rescued_A_Hostage

No Award Winner
0 hostages rescued
USP Master

usp

LB   kevyy
2 kills with usp
 
  Global Awards

AK47

ak47

Belgium   WooHoO.be
1946 kills with ak47
AWP

awp

Morocco   renderguy1
1329 snipings with awp
Best Latency

latency

United Kingdom   RuskiBlyat
5 ms average connection
Colt M4A1 Carbine

m4a1

France   Zer0Fr4G
1126 kills with m4a1
Desert Eagle

deagle

Brazil   TuroK 157
173 kills with deagle
Dual Berretta Elites

elite

India   Bad Dental Full Mental
14 kills with elite
Fusil Automatique

famas

United States   Deagle_May_Cry
204 kills with famas
Galil

galil

Netherlands   Saint69 goodfellas 070
2697 kills with galil
Glock

glock18

Morocco   renderguy1
9 kills with glock18
Grenadier

grenade

Belgium   WooHoO.be
751 kills with grenade
Headshot King

headshot

Belgium   WooHoO.be
1414 headshots
Knife Maniac

knife

United Arab Emirates   NANA
803 knifings
P90

p90

Netherlands   ©®GoLdSteiN®©
57 kills with p90
Shotgun

m3

United States   ^][aKu][$][PaPPa][^
185 kills with m3 shotgun
Top Assassin

Assassinated_The_VIP

No Award Winner
0 assassinations
Top Defuser

Defused_The_Bomb

No Award Winner
0 bomb defusions
Top Demolitionist

Planted_The_Bomb

No Award Winner
0 bomb plantings
Top Hostage Rescuer

Rescued_A_Hostage

No Award Winner
0 hostages rescued
USP Master

usp

Morocco   renderguy1
45 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 'amx.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='dqsd'
		GROUP BY
			rankName,
			minKills