[ft] THE FOOT CLAN - Day of Defeat: Source

Sections

Daily Awards (Monday 2 Nov)

.30 Caliber Machine Gun No Award Winner 0 kills with .30 Caliber Machine Gun	Area Captured No Award Winner 0 flags captured	Backstabbing Beotch No Award Winner 0 kills with the American Knife	Bar Browning Hor No Award Winner 0 kills with the BAR Browning Automatic Rifle	Bazooka Joe No Award Winner 0 kills with the Bazooka
Best Latency No Award Winner 0 ms average connection	Bomb Planter Killer No Award Winner 0 kills	Capture Blocked No Award Winner 0 flags blocked	Colt Freak No Award Winner 0 kills with the Colt .45 model 1911	GarandMeister No Award Winner 0 kills with the M1 Garand Rifle
German Machine Hor No Award Winner 0 kills with the MG42	German Rifle Grenade No Award Winner 0 kills with German Rifle Grenade	German Smoke Grenade No Award Winner 0 kills with the German Smoke Grenade	Grenade Freak No Award Winner 0 bombings with the German Grenade	M1 Carbine No Award Winner 0 kills with M1 Carbine
M1 Garand Rifle No Award Winner 0 kills with M1 Garand Rifle	Mauser Kar 98k No Award Winner 0 kills with Mauser Kar 98k	Mauser Karbiner k98 Sniper Rifle No Award Winner 0 kills with Mauser Karbiner k98 Sniper Rifle	McVeigh Alert No Award Winner 0 bombings with the U.S. Grenade	MP40 Hor No Award Winner 0 kills with the MP40 Machine Pistol
MP44 Hor No Award Winner 0 kills with the MP44 Assault Rifle	Panzerschreck Hans No Award Winner 0 kills with the Panzerschreck	Pistol 38 No Award Winner 0 kills with Pistol 38	Pistol c96 No Award Winner 0 kills with Pistol c96	Puncher No Award Winner 0 knock-outs
Shovel God No Award Winner 0 kills with the spade	Spring Sniper No Award Winner 0 snipings with the Springfield 03 Rifle	Thompson Hor No Award Winner 0 kills with the Thompson Submachine Gun	Top Defuser No Award Winner 0 bomb defusions	Top Demolitionist No Award Winner 0 bomb plantings
U.S. Smoke Grenade No Award Winner 0 kills with the U.S. Smoke Grenade

Global Awards

.30 Caliber Machine Gun -Rudolf- 3 kills with .30 Caliber Machine Gun	Area Captured Énforcer 20 flags captured	Backstabbing Beotch DiSterben 1 kills with the American Knife	Bar Browning Hor 586 5 kills with the BAR Browning Automatic Rifle	Bazooka Joe Énforcer 8 kills with the Bazooka
Best Latency [D-D] GOZ SLAVA UKRAINI 62 ms average connection	Bomb Planter Killer No Award Winner 0 kills	Capture Blocked Who Cares 4 flags blocked	Colt Freak Petit Poulet 1 kills with the Colt .45 model 1911	GarandMeister DiSterben 17 kills with the M1 Garand Rifle
German Machine Hor DiSterben 3 kills with the MG42	German Rifle Grenade Petit Poulet 2 kills with German Rifle Grenade	German Smoke Grenade No Award Winner 0 kills with the German Smoke Grenade	Grenade Freak Énforcer 8 bombings with the German Grenade	M1 Carbine No Award Winner 0 kills with M1 Carbine
M1 Garand Rifle DiSterben 3 kills with M1 Garand Rifle	Mauser Kar 98k Error 8 kills with Mauser Kar 98k	Mauser Karbiner k98 Sniper Rifle Who Cares 8 kills with Mauser Karbiner k98 Sniper Rifle	McVeigh Alert Petit Poulet 4 bombings with the U.S. Grenade	MP40 Hor Énforcer 8 kills with the MP40 Machine Pistol
MP44 Hor Petit Poulet 2 kills with the MP44 Assault Rifle	Panzerschreck Hans Énforcer 23 kills with the Panzerschreck	Pistol 38 Petit Poulet 2 kills with Pistol 38	Pistol c96 No Award Winner 0 kills with Pistol c96	Puncher No Award Winner 0 knock-outs
Shovel God TooManyWizards 1 kills with the spade	Spring Sniper Petit Poulet 27 snipings with the Springfield 03 Rifle	Thompson Hor Nugget 5 kills with the Thompson Submachine Gun	Top Defuser No Award Winner 0 bomb defusions	Top Demolitionist No Award Winner 0 bomb plantings
U.S. Smoke Grenade No Award Winner 0 kills with the U.S. Smoke Grenade

ERROR

Database Error

Server Address: localhost
Server Username: thefootclan

Error Diagnostic:
Bad query.

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