Avjeux just 4 fun - -=AvJeux # gungame=-

Daily Awards (Friday 28 Nov)

AK47 No Award Winner 0 kills with ak47	AWP No Award Winner 0 snipings with awp	Best Latency Peppa Pig 6 ms average connection	Colt M4A1 Carbine No Award Winner 0 kills with m4a1	Desert Eagle No Award Winner 0 kills with deagle
Dual Berretta Elites No Award Winner 0 kills with elite	Fusil Automatique No Award Winner 0 kills with famas	Galil No Award Winner 0 kills with galil	Glock No Award Winner 0 kills with glock18	Grenadier No Award Winner 0 kills with grenade
Headshot King No Award Winner 0 headshots	Knife Maniac No Award Winner 0 knifings	P90 No Award Winner 0 kills with p90	Shotgun No Award Winner 0 kills with m3 shotgun	Top Assassin No Award Winner 0 assassinations
Top Defuser No Award Winner 0 bomb defusions	Top Demolitionist No Award Winner 0 bomb plantings	Top Hostage Rescuer No Award Winner 0 hostages rescued	USP Master No Award Winner 0 kills with usp

Global Awards

AK47 I see dead people! 22 kills with ak47	AWP ^^^vVv^^^ 18 snipings with awp	Best Latency AlbAtor 6 ms average connection	Colt M4A1 Carbine I see dead people! 16 kills with m4a1	Desert Eagle I see dead people! 12 kills with deagle
Dual Berretta Elites DimaXa 18 kills with elite	Fusil Automatique ^^^vVv^^^ 16 kills with famas	Galil DimaXa 26 kills with galil	Glock Terminator 20 kills with glock18	Grenadier Luckystrike2006 14 kills with grenade
Headshot King ^^^vVv^^^ 107 headshots	Knife Maniac ^^^vVv^^^ 167 knifings	P90 I see dead people! 20 kills with p90	Shotgun DimaXa 19 kills with m3 shotgun	Top Assassin No Award Winner 0 assassinations
Top Defuser No Award Winner 0 bomb defusions	Top Demolitionist No Award Winner 0 bomb plantings	Top Hostage Rescuer No Award Winner 0 hostages rescued	USP Master 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