You are hereMW3 Clan Challenge: Hoarder
MW3 Clan Challenge: Hoarder
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 = 8400 in /var/www/clients/client2/web3/web/modules/event/event_database.mysql.inc on line 12.
Hoarder
Most Kills Confirmed
Wednesday, September 12, 1:00 p.m. - Thursday, September 13, 12:00 p.m. EDT
"Get moving and grab those tags! Pair up with a friend and work together to land the kill, grab the tag and provide cover fire. Confirm the most kills and the accolade is yours. Accolades are cumulative through each tier, so keep fighting the good fight to earn more Clan XP."
This coincides perfectly with HoC Nite, which is good because I want people to see how fast Blackwalt wins this challenge for us.