vBulletin Calendar Timezone

[papermonk]

The guys over at vbulletin.com sent me over here with this, I hope someone can help.

I'm having some trouble with the vBulletin calendar. Essentially, I'm using the bbpixel bridge module to bring over the calendar events into Joomla but because the calendar is set to GMT the dates are all messed up whenever it gets close to the time.

Is there a way to set the calendar to EST or any other time zone? Thanks!

[Avian]

I have the exact same problem - any help would be appreciated!

Also, when this plugin gets the date and time of the event, if it's a recurring event, it returns the entire range of the recurring event, not the actual event time. Its query is:

$query = "SELECT e.*, c.title AS cal_title FROM {$bbpixel_vbdb_tbprefix}event e, {$bbpixel_vbdb_tbprefix}calendar c
WHERE e.calendarid = c.calendarid
AND e.calendarid IN ({$bbpixel_calendar_id})
AND visible='1'
AND (
(e.dateline_from <= '{$fromUnix}' AND e.dateline_to >= '{$fromUnix}')
OR (e.dateline_from >= '{$fromUnix}' AND e.dateline_from <= '{$endUnix}')
)
ORDER BY e.dateline_from ASC, e.calendarid DESC";