HLstatsX Community Edition
  • L4D2
  • TF
  • Contents
  • Search
  • SourceBans
  • Forum
  • Help

  Daily Awards (Saturday 3 Jun)

Adrenaline Junkie

used_adrenaline

No Award Winner
0 adrenaline shots used
AK-47

rifle_ak47

No Award Winner
0 kills with the AK-47
Akimbo Assassin

dual_pistols

No Award Winner
0 kills with Dual Pistols
Ammo Saver

pistol

No Award Winner
0 kills with Pistol
Automation

autoshotgun

No Award Winner
0 kills with Auto Shotgun
AWP

sniper_awp

No Award Winner
0 kills with awp
BANG Headshot.

frying_pan

No Award Winner
0 kills with the Frying Pan
Barf Bagged

vomit

No Award Winner
0 vomited on Survivors
Batter Up!

baseball_bat

No Award Winner
0 kills with the Baseball Bat
Black Scottish Psyclops

grenade_launcher_projectile

No Award Winner
0 kills with the Grenade Launcher
Boom!

boomer_claw

No Award Winner
0 kills with Boomer's Claws
Brain Salad

headshot

No Award Winner
0 headshot kills
Bumrush Thwarter

killed_charger

No Award Winner
0 killed Chargers
Burger Tank

tank_claw

No Award Winner
0 kills with Tank's Claws
Chain Smoker

smoker_claw

No Award Winner
0 kills with Smoker's Claws
Cheerio.

cricket_bat

No Award Winner
0 kills with the Cricket Bat
Chrome Shotgun

shotgun_chrome

No Award Winner
0 kills with the Chrome Shotgun
Combat Rifle

rifle_desert

No Award Winner
0 kills with the Combat Rifle
Combat Shotgun

shotgun_spas

No Award Winner
0 kills with the Combat Shotgun
Commando

rifle

No Award Winner
0 kills with M16 Assault Rifle
Crowbar

crowbar

No Award Winner
0 kills with the Crowbar
Dead Wreckening

killed_survivor

No Award Winner
0 downed Survivors
Dr. Shocker

defibrillated_teammate

No Award Winner
0 teammates defibrillated
Drag & Drop

tongue_grab

No Award Winner
0 constricted Survivors
Field Medic

healed_teammate

No Award Winner
0 healed Survivors
Fight fire with an axe

fireaxe

No Award Winner
0 kills with the Fireaxe
Fists of RAGGEE

melee

No Award Winner
0 melee kills
Free to Fly

pounce

No Award Winner
0 pounced Survivors
GET OFF MY LAWN

gnome

No Award Winner
0 gnome smash kills
Going for a ride!

jockey_ride

No Award Winner
0 jockey rides
Golf Club

golfclub

No Award Winner
0 kills with the Golf Club
Green can't be healthy..

bilebomb_tank

No Award Winner
0 tank bilebombs
Ground Cover

rescued_survivor

No Award Winner
0 rescued Survivors
Hawk Eye

hunting_rifle

No Award Winner
0 kills with Hunting Rifle
Helping Hand

revived_teammate

No Award Winner
0 revived Survivors
Hi Dr. Nick!

first_aid_kit

No Award Winner
0 kills with a First Aid Kit
Hulk Smash!

charger_pummel

No Award Winner
0 pummelings as a charger
Hunter Punter

killed_hunter

No Award Winner
0 killed Hunters
Hunter Punter

killed_jockey

No Award Winner
0 killed Jockeys
Hunter Punter

hunter_punter

No Award Winner
0 hunter punts
Inquisitor

killed_witch

No Award Winner
0 killed Witches
Katana

katana

No Award Winner
0 kills with the Katana
Knife

knife

No Award Winner
0 kills with the Knife
Little Man Claws

jockey_claw

No Award Winner
0 kills with Jockey's Claws
Lowest Ping

latency

No Award Winner
0 ms average connection
M60

rifle_m60

No Award Winner
0 kills with M60
Machete

machete

No Award Winner
0 kills with the Machete
Magnum

pistol_magnum

No Award Winner
0 kills with the Magnum
MP5 Navy

smg_mp5

No Award Winner
0 kills with mp5
No One Left Behind

prop_minigun

No Award Winner
0 kills with Mounted Machine Gun
No Smoking Section

killed_smoker

No Award Winner
0 killed Smokers
Open Season

hunter_claw

No Award Winner
0 kills with Hunter's Claws
Protector

protect_teammate

No Award Winner
0 hunter punts
Pump It!

pumpshotgun

No Award Winner
0 kills with Pump Shotgun
Pyromaniac

inferno

No Award Winner
0 cremated Infected
Pyrotechnician

pipe_bomb

No Award Winner
0 blown up Infected
Rock Star

tank_rock

No Award Winner
0 kills with Tank's Rock
Safety First

smg

No Award Winner
0 kills with Uzi
Scout Elite

sniper_scout

No Award Winner
0 kills with scout
SG 552

rifle_sg552

No Award Winner
0 kills with sg552
Slice and Dice

chainsaw

No Award Winner
0 kills with the Chainsaw
Snap Crackle Pop

fire_cracker_blast

No Award Winner
0 kills with fire crackers
Sniper Rifle

sniper_military

No Award Winner
0 kills with the Sniper Rifle
Spit shine

spitter_acidbath

No Award Winner
0 spitter acid attacks
Spittle Splatter

killed_spitter

No Award Winner
0 Spitters Splated
Stomach Upset

killed_boomer

No Award Winner
0 killed Boomers
TAAN... What is this?!

charger_claw

No Award Winner
0 kills with Charger's Claws
Tankbuster

killed_tank

No Award Winner
0 killed Tanks
Those nails could kill

spitter_claw

No Award Winner
0 kills with Spitter's Claws
Tonfa

tonfa

No Award Winner
0 kills with the Tonfa
Uzi (Silenced)

smg_silenced

No Award Winner
0 kills with the Uzi (silenced)
Wayne's world party on!

electric_guitar

No Award Winner
0 kills with the Electric Guitar
   
  Global Awards

Adrenaline Junkie

used_adrenaline

No Award Winner
0 adrenaline shots used
AK-47

rifle_ak47

No Award Winner
0 kills with the AK-47
Akimbo Assassin

dual_pistols

No Award Winner
0 kills with Dual Pistols
Ammo Saver

pistol

No Award Winner
0 kills with Pistol
Automation

autoshotgun

No Award Winner
0 kills with Auto Shotgun
AWP

sniper_awp

No Award Winner
0 kills with awp
BANG Headshot.

frying_pan

No Award Winner
0 kills with the Frying Pan
Barf Bagged

vomit

No Award Winner
0 vomited on Survivors
Batter Up!

baseball_bat

No Award Winner
0 kills with the Baseball Bat
Black Scottish Psyclops

grenade_launcher_projectile

No Award Winner
0 kills with the Grenade Launcher
Boom!

boomer_claw

No Award Winner
0 kills with Boomer's Claws
Brain Salad

headshot

No Award Winner
0 headshot kills
Bumrush Thwarter

killed_charger

No Award Winner
0 killed Chargers
Burger Tank

tank_claw

No Award Winner
0 kills with Tank's Claws
Chain Smoker

smoker_claw

No Award Winner
0 kills with Smoker's Claws
Cheerio.

cricket_bat

No Award Winner
0 kills with the Cricket Bat
Chrome Shotgun

shotgun_chrome

No Award Winner
0 kills with the Chrome Shotgun
Combat Rifle

rifle_desert

No Award Winner
0 kills with the Combat Rifle
Combat Shotgun

shotgun_spas

No Award Winner
0 kills with the Combat Shotgun
Commando

rifle

No Award Winner
0 kills with M16 Assault Rifle
Crowbar

crowbar

No Award Winner
0 kills with the Crowbar
Dead Wreckening

killed_survivor

No Award Winner
0 downed Survivors
Dr. Shocker

defibrillated_teammate

No Award Winner
0 teammates defibrillated
Drag & Drop

tongue_grab

No Award Winner
0 constricted Survivors
Field Medic

healed_teammate

No Award Winner
0 healed Survivors
Fight fire with an axe

fireaxe

No Award Winner
0 kills with the Fireaxe
Fists of RAGGEE

melee

No Award Winner
0 melee kills
Free to Fly

pounce

No Award Winner
0 pounced Survivors
GET OFF MY LAWN

gnome

No Award Winner
0 gnome smash kills
Going for a ride!

jockey_ride

No Award Winner
0 jockey rides
Golf Club

golfclub

No Award Winner
0 kills with the Golf Club
Green can't be healthy..

bilebomb_tank

No Award Winner
0 tank bilebombs
Ground Cover

rescued_survivor

No Award Winner
0 rescued Survivors
Hawk Eye

hunting_rifle

No Award Winner
0 kills with Hunting Rifle
Helping Hand

revived_teammate

No Award Winner
0 revived Survivors
Hi Dr. Nick!

first_aid_kit

No Award Winner
0 kills with a First Aid Kit
Hulk Smash!

charger_pummel

No Award Winner
0 pummelings as a charger
Hunter Punter

killed_hunter

No Award Winner
0 killed Hunters
Hunter Punter

killed_jockey

No Award Winner
0 killed Jockeys
Hunter Punter

hunter_punter

No Award Winner
0 hunter punts
Inquisitor

killed_witch

No Award Winner
0 killed Witches
Katana

katana

No Award Winner
0 kills with the Katana
Knife

knife

No Award Winner
0 kills with the Knife
Little Man Claws

jockey_claw

No Award Winner
0 kills with Jockey's Claws
Lowest Ping

latency

No Award Winner
0 ms average connection
M60

rifle_m60

No Award Winner
0 kills with M60
Machete

machete

No Award Winner
0 kills with the Machete
Magnum

pistol_magnum

No Award Winner
0 kills with the Magnum
MP5 Navy

smg_mp5

No Award Winner
0 kills with mp5
No One Left Behind

prop_minigun

No Award Winner
0 kills with Mounted Machine Gun
No Smoking Section

killed_smoker

No Award Winner
0 killed Smokers
Open Season

hunter_claw

No Award Winner
0 kills with Hunter's Claws
Protector

protect_teammate

No Award Winner
0 hunter punts
Pump It!

pumpshotgun

No Award Winner
0 kills with Pump Shotgun
Pyromaniac

inferno

No Award Winner
0 cremated Infected
Pyrotechnician

pipe_bomb

No Award Winner
0 blown up Infected
Rock Star

tank_rock

No Award Winner
0 kills with Tank's Rock
Safety First

smg

No Award Winner
0 kills with Uzi
Scout Elite

sniper_scout

No Award Winner
0 kills with scout
SG 552

rifle_sg552

No Award Winner
0 kills with sg552
Slice and Dice

chainsaw

No Award Winner
0 kills with the Chainsaw
Snap Crackle Pop

fire_cracker_blast

No Award Winner
0 kills with fire crackers
Sniper Rifle

sniper_military

No Award Winner
0 kills with the Sniper Rifle
Spit shine

spitter_acidbath

No Award Winner
0 spitter acid attacks
Spittle Splatter

killed_spitter

No Award Winner
0 Spitters Splated
Stomach Upset

killed_boomer

No Award Winner
0 killed Boomers
TAAN... What is this?!

charger_claw

No Award Winner
0 kills with Charger's Claws
Tankbuster

killed_tank

No Award Winner
0 killed Tanks
Those nails could kill

spitter_claw

No Award Winner
0 kills with Spitter's Claws
Tonfa

tonfa

No Award Winner
0 kills with the Tonfa
Uzi (Silenced)

smg_silenced

No Award Winner
0 kills with the Uzi (silenced)
Wayne's world party on!

electric_guitar

No Award Winner
0 kills with the Electric Guitar
   
ERROR
Database Error

Server Address: 192.168.1.101
Server Username: motd

Error Diagnostic:
Bad query.

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