kackbratzen.net - Counter-Strike: Source

Sections

Daily Awards (Monday 25 Sep)

AK47 No Award Winner 0 kills with ak47	AWP No Award Winner 0 kills with awp	Best Latency No Award Winner 0 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	Five Seven No Award Winner 0 kills with fiveseven	Fusil Automatique No Award Winner 0 kills with famas
G3 SG1 No Award Winner 0 kills with g3sg1	Galil No Award Winner 0 kills with galil	Glock No Award Winner 0 kills with glock	Headshot King No Award Winner 0 shots in the head
Knife Maniac No Award Winner 0 knifings	M3 Shotgun No Award Winner 0 kills with m3 shotgun	Mac 10 No Award Winner 0 kills with mac10	Most Kills No Award Winner 0 kills
Most Valuable Player No Award Winner 0 times earning Round MVP	MP5 Navy No Award Winner 0 kills with mp5	P 228 No Award Winner 0 kills with p228	P 90 No Award Winner 0 kills with p90
Para No Award Winner 0 kills with m249	Scout Elite No Award Winner 0 kills with scout	SG 550 No Award Winner 0 kills with sg550	SG 552 No Award Winner 0 kills with sg552
Steyr Aug No Award Winner 0 kills with aug	Suicides No Award Winner 0 suicides	Team Killer No Award Winner 0 team kills	TMP No Award Winner 0 kills with tmp
Top Defuser No Award Winner 0 bomb defusions	Top Demolitionist No Award Winner 0 bomb plantings	Top grenadier No Award Winner 0 kills with grenade	Top Hostage Killer No Award Winner 0 hostages killed
Top Hostage Rescuer No Award Winner 0 hostages rescued	UMP 45 No Award Winner 0 kills with ump45	USP Master No Award Winner 0 kills with usp	XM automatic Shotgun No Award Winner 0 kills with xm1014

Global Awards

AK47 No Award Winner 0 kills with ak47	AWP No Award Winner 0 kills with awp	Best Latency No Award Winner 0 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	Five Seven No Award Winner 0 kills with fiveseven	Fusil Automatique No Award Winner 0 kills with famas	G3 SG1 No Award Winner 0 kills with g3sg1	Galil No Award Winner 0 kills with galil
Glock No Award Winner 0 kills with glock	Headshot King No Award Winner 0 shots in the head	Knife Maniac No Award Winner 0 knifings	M3 Shotgun No Award Winner 0 kills with m3 shotgun	Mac 10 No Award Winner 0 kills with mac10
Most Kills No Award Winner 0 kills	Most Valuable Player No Award Winner 0 times earning Round MVP	MP5 Navy No Award Winner 0 kills with mp5	P 228 No Award Winner 0 kills with p228	P 90 No Award Winner 0 kills with p90
Para No Award Winner 0 kills with m249	Scout Elite No Award Winner 0 kills with scout	SG 550 No Award Winner 0 kills with sg550	SG 552 No Award Winner 0 kills with sg552	Steyr Aug No Award Winner 0 kills with aug
Suicides No Award Winner 0 suicides	Team Killer No Award Winner 0 team kills	TMP No Award Winner 0 kills with tmp	Top Defuser No Award Winner 0 bomb defusions	Top Demolitionist No Award Winner 0 bomb plantings
Top grenadier No Award Winner 0 kills with grenade	Top Hostage Killer No Award Winner 0 hostages killed	Top Hostage Rescuer No Award Winner 0 hostages rescued	UMP 45 No Award Winner 0 kills with ump45	USP Master No Award Winner 0 kills with usp
XM automatic Shotgun No Award Winner 0 kills with xm1014

ERROR

Database Error

Server Address: localhost
Server Username: hlxce

Error Diagnostic:
Bad query.

Server Error: (1055) Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hlxce.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='css'
		GROUP BY
			rankName,
			minKills