HLstatsX Community Edition
  • Contents
  • Search
  • Help

  Sections

  Daily Awards (Tuesday 22 Jan)

AK47

ak47

No Award Winner
0 kills with ak47
AWP

awp

No Award Winner
0 snipings with awp
Best Latency

latency

No Award Winner
0 ms average connection
Colt M4A1 Carbine

m4a1

No Award Winner
0 kills with m4a1
Desert Eagle

deagle

No Award Winner
0 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

No Award Winner
0 kills with galil
Glock

glock18

No Award Winner
0 kills with glock18
Grenadier

grenade

No Award Winner
0 kills with grenade
Headshot King

headshot

No Award Winner
0 headshots
Knife Maniac

knife

No Award Winner
0 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

No Award Winner
0 kills with usp
 
  Global Awards

AK47

ak47

No Award Winner
0 kills with ak47
AWP

awp

No Award Winner
0 snipings with awp
Best Latency

latency

No Award Winner
0 ms average connection
Colt M4A1 Carbine

m4a1

No Award Winner
0 kills with m4a1
Desert Eagle

deagle

No Award Winner
0 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

No Award Winner
0 kills with galil
Glock

glock18

No Award Winner
0 kills with glock18
Grenadier

grenade

No Award Winner
0 kills with grenade
Headshot King

headshot

No Award Winner
0 headshots
Knife Maniac

knife

No Award Winner
0 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

No Award Winner
0 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