HLstatsX Community Edition
  • Contents
  • Search
  • Help

Banner
  Daily Awards (Friday 28 Nov)

AK47

ak47

No Award Winner
0 kills with ak47
AWP

awp

No Award Winner
0 snipings with awp
Best Latency

latency

GB   Peppa Pig
6 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

United Kingdom   I see dead people!
22 kills with ak47
AWP

awp

Turkey   ^^^vVv^^^
18 snipings with awp
Best Latency

latency

France   AlbAtor
6 ms average connection
Colt M4A1 Carbine

m4a1

United Kingdom   I see dead people!
16 kills with m4a1
Desert Eagle

deagle

United Kingdom   I see dead people!
12 kills with deagle
Dual Berretta Elites

elite

Russia   DimaXa
18 kills with elite
Fusil Automatique

famas

Turkey   ^^^vVv^^^
16 kills with famas
Galil

galil

Russia   DimaXa
26 kills with galil
Glock

glock18

Germany   Terminator
20 kills with glock18
Grenadier

grenade

Germany   Luckystrike2006
14 kills with grenade
Headshot King

headshot

Turkey   ^^^vVv^^^
107 headshots
Knife Maniac

knife

Turkey   ^^^vVv^^^
167 knifings
P90

p90

United Kingdom   I see dead people!
20 kills with p90
Shotgun

m3

Russia   DimaXa
19 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

Spain   cabano
15 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='Counter-Strike: Condition Zero'
		GROUP BY
			rankName,
			minKills