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

  Daily Awards (Thursday 26 May)

Adrenaline Junkie

used_adrenaline

MX   Ze̸rø T̷w̸͙̽ø™★
2 adrenaline shots used
AK-47

rifle_ak47

MX   iha19
296 kills with the AK-47
Akimbo Assassin

dual_pistols

MX   pacoeltaco
37 kills with Dual Pistols
Ammo Saver

pistol

MX   Desshomaru
52 kills with Pistol
Automation

autoshotgun

MX   Desshomaru
91 kills with Auto Shotgun
AWP

sniper_awp

MX   WinterMint15195
44 kills with awp
BANG Headshot.

frying_pan

No Award Winner
0 kills with the Frying Pan
Barf Bagged

vomit

MX   ★★ BLU3ST4R ★★
15 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

MX   pacoeltaco
72 headshot kills
Bumrush Thwarter

killed_charger

MX   ★★ BLU3ST4R ★★
8 killed Chargers
Burger Tank

tank_claw

MX   Ze̸rø T̷w̸͙̽ø™★
4 kills with Tank's Claws
Chain Smoker

smoker_claw

MX   EternalParadox
1 kills with Smoker's Claws
Cheerio.

cricket_bat

No Award Winner
0 kills with the Cricket Bat
Chrome Shotgun

shotgun_chrome

MX   *Luis Miguel*
109 kills with the Chrome Shotgun
Combat Rifle

rifle_desert

MX   WinterMint15195
153 kills with the Combat Rifle
Combat Shotgun

shotgun_spas

MX   WinterMint15195
228 kills with the Combat Shotgun
Commando

rifle

MX   Desshomaru
45 kills with M16 Assault Rifle
Crowbar

crowbar

MX   iha19
37 kills with the Crowbar
Dead Wreckening

killed_survivor

MX   Ze̸rø T̷w̸͙̽ø™★
13 downed Survivors
Dr. Shocker

defibrillated_teammate

No Award Winner
0 teammates defibrillated
Drag & Drop

tongue_grab

MX   Ze̸rø T̷w̸͙̽ø™★
10 constricted Survivors
Field Medic

healed_teammate

MX   pacoeltaco
2 healed Survivors
Fight fire with an axe

fireaxe

MX   SinInsultosPlox
71 kills with the Fireaxe
Fists of RAGGEE

melee

No Award Winner
0 melee kills
Free to Fly

pounce

MX   Ze̸rø T̷w̸͙̽ø™★
7 pounced Survivors
GET OFF MY LAWN

gnome

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

jockey_ride

MX   Ze̸rø T̷w̸͙̽ø™★
8 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

MX   iha19
113 kills with Hunting Rifle
Helping Hand

revived_teammate

MX   EternalParadox
6 revived Survivors
Hi Dr. Nick!

first_aid_kit

MX   EternalParadox
1 kills with a First Aid Kit
Hulk Smash!

charger_pummel

MX   Ze̸rø T̷w̸͙̽ø™★
6 pummelings as a charger
Hunter Punter

killed_hunter

MX   Ze̸rø T̷w̸͙̽ø™★
9 killed Hunters
Hunter Punter

killed_jockey

MX   Ze̸rø T̷w̸͙̽ø™★
10 killed Jockeys
Hunter Punter

hunter_punter

MX   *Luis Miguel*
3 hunter punts
Inquisitor

killed_witch

MX   WinterMint15195
3 killed Witches
Katana

katana

MX   WinterMint15195
52 kills with the Katana
Knife

knife

MX   iha19
24 kills with the Knife
Little Man Claws

jockey_claw

MX   ★★ BLU3ST4R ★★
2 kills with Jockey's Claws
Lowest Ping

latency

MX   Desshomaru
49 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

MX   DieGallo
1 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

MX   Ze̸rø T̷w̸͙̽ø™★
12 killed Smokers
Open Season

hunter_claw

MX   Ze̸rø T̷w̸͙̽ø™★
1 kills with Hunter's Claws
Protector

protect_teammate

MX   iha19
132 hunter punts
Pump It!

pumpshotgun

MX   Tetsuky McFly
8 kills with Pump Shotgun
Pyromaniac

inferno

MX   iha19
38 cremated Infected
Pyrotechnician

pipe_bomb

MX   iha19
30 blown up Infected
Rock Star

tank_rock

MX   Ze̸rø T̷w̸͙̽ø™★
1 kills with Tank's Rock
Safety First

smg

MX   pacoeltaco
42 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

MX   LaQuesadilla
46 kills with the Chainsaw
Snap Crackle Pop

fire_cracker_blast

MX   WinterMint15195
17 kills with fire crackers
Sniper Rifle

sniper_military

MX   Fîdêl RDZ
103 kills with the Sniper Rifle
Spit shine

spitter_acidbath

No Award Winner
0 spitter acid attacks
Spittle Splatter

killed_spitter

MX   Ze̸rø T̷w̸͙̽ø™★
10 Spitters Splated
Stomach Upset

killed_boomer

MX   Ze̸rø T̷w̸͙̽ø™★
18 killed Boomers
TAAN... What is this?!

charger_claw

MX   Ze̸rø T̷w̸͙̽ø™★
2 kills with Charger's Claws
Tankbuster

killed_tank

MX   iha19
3 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

MX   Ze̸rø T̷w̸͙̽ø™★
143 kills with the Uzi (silenced)
Wayne's world party on!

electric_guitar

MX   EternalParadox
36 kills with the Electric Guitar
   
  Global Awards

Adrenaline Junkie

used_adrenaline

United States   Iforgot42
9 adrenaline shots used
AK-47

rifle_ak47

Mexico   E_PlusOne
316 kills with the AK-47
Akimbo Assassin

dual_pistols

Mexico   KekoXD
48 kills with Dual Pistols
Ammo Saver

pistol

Mexico   Desshomaru
52 kills with Pistol
Automation

autoshotgun

Mexico   Desshomaru
143 kills with Auto Shotgun
AWP

sniper_awp

Peru   VIPER
111 kills with awp
BANG Headshot.

frying_pan

Mexico   André-Pierre Gignac
24 kills with the Frying Pan
Barf Bagged

vomit

Mexico   Albedo Kenshin Nyuu
36 vomited on Survivors
Batter Up!

baseball_bat

Mexico   Genio
75 kills with the Baseball Bat
Black Scottish Psyclops

grenade_launcher_projectile

United States   imagepicman
491 kills with the Grenade Launcher
Boom!

boomer_claw

Mexico   Profesor Utonio
1 kills with Boomer's Claws
Brain Salad

headshot

Mexico   pacoeltaco
72 headshot kills
Bumrush Thwarter

killed_charger

Mexico   Profesor Utonio
20 killed Chargers
Burger Tank

tank_claw

United States   R_Williams
8 kills with Tank's Claws
Chain Smoker

smoker_claw

United States   Variable
3 kills with Smoker's Claws
Cheerio.

cricket_bat

Mexico   Sarventa
15 kills with the Cricket Bat
Chrome Shotgun

shotgun_chrome

Mexico   Naͣya.
214 kills with the Chrome Shotgun
Combat Rifle

rifle_desert

Mexico   El Alcalde
157 kills with the Combat Rifle
Combat Shotgun

shotgun_spas

Mexico   WinterMint15195
228 kills with the Combat Shotgun
Commando

rifle

Mexico   Josh
120 kills with M16 Assault Rifle
Crowbar

crowbar

Mexico   mercuryruiz12
52 kills with the Crowbar
Dead Wreckening

killed_survivor

Mexico   Profesor Utonio
20 downed Survivors
Dr. Shocker

defibrillated_teammate

Mexico   elecтυѕ
1 teammates defibrillated
Drag & Drop

tongue_grab

Mexico   El Alcalde
16 constricted Survivors
Field Medic

healed_teammate

Peru   VIPER
6 healed Survivors
Fight fire with an axe

fireaxe

Mexico   Albedo Kenshin Nyuu
108 kills with the Fireaxe
Fists of RAGGEE

melee

No Award Winner
0 melee kills
Free to Fly

pounce

Mexico   Albedo Kenshin Nyuu
14 pounced Survivors
GET OFF MY LAWN

gnome

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

jockey_ride

Mexico   Albedo Kenshin Nyuu
15 jockey rides
Golf Club

golfclub

Mexico   /-$
80 kills with the Golf Club
Green can't be healthy..

bilebomb_tank

Mexico   elecтυѕ
1 tank bilebombs
Ground Cover

rescued_survivor

United States   Iforgot42
1 rescued Survivors
Hawk Eye

hunting_rifle

United States   R_Williams
128 kills with Hunting Rifle
Helping Hand

revived_teammate

Mexico   IISlayerII
11 revived Survivors
Hi Dr. Nick!

first_aid_kit

Mexico   PacoGTR
1 kills with a First Aid Kit
Hulk Smash!

charger_pummel

Mexico   Albedo Kenshin Nyuu
14 pummelings as a charger
Hunter Punter

killed_hunter

Mexico   elecтυѕ
18 killed Hunters
Hunter Punter

killed_jockey

Mexico   E_PlusOne
16 killed Jockeys
Hunter Punter

hunter_punter

Mexico   まふまふ
9 hunter punts
Inquisitor

killed_witch

Argentina   PERRO-TOXICO
5 killed Witches
Katana

katana

Mexico   Levi
99 kills with the Katana
Knife

knife

Mexico   iha19
24 kills with the Knife
Little Man Claws

jockey_claw

United States   MeatBallz
3 kills with Jockey's Claws
Lowest Ping

latency

United States   Player Slot Available
37 ms average connection
M60

rifle_m60

Mexico   elecтυѕ
16 kills with M60
Machete

machete

Mexico   FPG majneto
46 kills with the Machete
Magnum

pistol_magnum

Mexico   Genio
96 kills with the Magnum
MP5 Navy

smg_mp5

Mexico   El Alcalde
86 kills with mp5
No One Left Behind

prop_minigun

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

killed_smoker

Mexico   Profesor Utonio
24 killed Smokers
Open Season

hunter_claw

Mexico   Profesor Utonio
6 kills with Hunter's Claws
Protector

protect_teammate

Mexico   Meriyein
146 hunter punts
Pump It!

pumpshotgun

Peru   ✯あおき✯
130 kills with Pump Shotgun
Pyromaniac

inferno

United States   Zar
77 cremated Infected
Pyrotechnician

pipe_bomb

Mexico   elecтυѕ
67 blown up Infected
Rock Star

tank_rock

United States   Zar
2 kills with Tank's Rock
Safety First

smg

Mexico   Meriyein
76 kills with Uzi
Scout Elite

sniper_scout

Mexico   Genio
75 kills with scout
SG 552

rifle_sg552

Mexico   09 KHK
42 kills with sg552
Slice and Dice

chainsaw

Mexico   AshKitt
48 kills with the Chainsaw
Snap Crackle Pop

fire_cracker_blast

Mexico   WinterMint15195
17 kills with fire crackers
Sniper Rifle

sniper_military

United States   lLlLlLlL
189 kills with the Sniper Rifle
Spit shine

spitter_acidbath

No Award Winner
0 spitter acid attacks
Spittle Splatter

killed_spitter

Mexico   Profesor Utonio
18 Spitters Splated
Stomach Upset

killed_boomer

Mexico   Profesor Utonio
26 killed Boomers
TAAN... What is this?!

charger_claw

Mexico   Albedo Kenshin Nyuu
5 kills with Charger's Claws
Tankbuster

killed_tank

Mexico   Naͣya.
4 killed Tanks
Those nails could kill

spitter_claw

Mexico   elecтυѕ
1 kills with Spitter's Claws
Tonfa

tonfa

Ecuador   Nevets1992
29 kills with the Tonfa
Uzi (Silenced)

smg_silenced

Mexico   09 KHK
174 kills with the Uzi (silenced)
Wayne's world party on!

electric_guitar

United States   CastleHearth
70 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