You are hereMW3 clan Challenge: Efficiency
MW3 clan Challenge: Efficiency
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, tz.offset_dst AS offset_dst, tz.dst_region, tz.is_dst, e.event_start ...' at line 1
query: SELECT e.event_start, e.event_end, e.timezone, e.has_time, e.has_end_date, tz.offset AS offset, tz.offset_dst AS offset_dst, tz.dst_region, tz.is_dst, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_start_utc, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND AS event_end_utc, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL 0 SECOND AS event_start_user, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL 0 SECOND AS event_end_user, e.event_start - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL -18000 SECOND AS event_start_site, e.event_end - INTERVAL IF(tz.is_dst, tz.offset_dst, tz.offset) HOUR_SECOND + INTERVAL -18000 SECOND AS event_end_site, tz.name as timezone_name FROM event e INNER JOIN event_timezones tz ON tz.timezone = e.timezone WHERE nid = 8355 in /var/www/clients/client2/web3/web/modules/event/event_database.mysql.inc on line 12.
Efficiency
Most Headshots
Monday, September 3, 1:00 p.m. - Tuesday, September 4, 12:00 p.m. EDT
"One shot, one kill. This Clan Challenge is all about blasting your target right in the head. Equip your best precision weapon and aim high to start racking up the headshots. Get more than anyone else in the match and the accolade is yours. Accolades are cumulative through each tier, so keep fighting the good fight to earn more Clan XP."
This should not be confused with the OTHER current headshot challenge, which is cumulative over one week. THIS one is for the Sharpshooter accolade, which is given for most headshots in any given match. Slightly harder.
All we needed was one more to get 100 clan XP.
did my part XD