Daily Awards (Wednesday 16 Jul)
AK47 No Award Winner 0 kills with ak47 |
AWP No Award Winner 0 snipings 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 |
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  ChtrK16613 kills with ak47 |
AWP  nasa4669 snipings with awp |
Best Latency  ᵂᵃˢᵗᵉᵈ4 ms average connection |
Colt M4A1 Carbine  netkool5859 kills with m4a1 |
Desert Eagle ChtrK1865 kills with deagle |
Dual Berretta Elites  DimaXa41 kills with elite |
Fusil Automatique  Enigma.Nsnd198 kills with famas |
Galil  sansar412 kills with galil |
Glock  Antonis58 kills with glock18 |
Grenadier Leer846 kills with grenade |
Headshot King ChtrK15246 headshots |
Knife Maniac  Sevchenko1047 knifings |
P90  VEGA X76 kills with p90 |
Shotgun ^][aKu][$][PaPPa][^468 kills with m3 shotgun |
Top Assassin eXtream1 assassinations |
Top Defuser No Award Winner 0 bomb defusions |
Top Demolitionist bleitzi441 bomb plantings |
Top Hostage Rescuer 1Всадник1 hostages rescued |
USP Master Tyler82 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
|