in line 15 $node->nid should be $nid.

6 /**
7 * @param $nid node ID
8 *
9 * @return event object
10 */
11 function event_get_event_load($nid) {
12 global $user;
13 $shift = variable_get('date_default_timezone', 0);
14
15 return db_fetch_object(db_query("SELECT e.event_start, e.event_end, e.timezone, e.has_time, e.has_end_date, tz.offset, tz.offset_dst, tz.dst_reg ion, tz.is_dst, e.event_start - CASE WHEN tz.is_dst = 1 THEN tz.offset_dst ELSE tz.offset END AS event_start_utc, e.event_end - CASE WHEN tz.is_ds t = 1 THEN tz.offset_dst ELSE tz.offset END AS event_end_utc, e.event_start - CASE WHEN tz.is_dst = 1 THEN tz.offset_dst ELSE tz.offset END + INTE RVAL '%d seconds' AS event_start_user, e.event_end - CASE WHEN tz.is_dst = 1 THEN tz.offset_dst ELSE tz.offset END + INTERVAL '%d seconds' AS even t_end_user, e.event_start - CASE WHEN tz.is_dst = 1 THEN tz.offset_dst ELSE tz.offset END + INTERVAL '%d seconds' AS event_start_site, e.event_end - CASE WHEN tz.is_dst = 1 THEN tz.offset_dst ELSE tz.offset END + INTERVAL '%d seconds' AS event_end_site, tz.name as timezone_name FROM {event} e INNER JOIN {event_timezones} tz ON tz.timezone = e.timezone WHERE nid = %d", (isset($user->timezone) ? $user->timezone : 0), (isset($user->timez one) ? $user->timezone : 0), $shift, $shift, $node->nid));
16 }
17

Comments

Liberation’s picture

killes@www.drop.org’s picture

Status: Active » Closed (duplicate)