vb.org Archive - vBulletin Calendar Timezone

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - vBulletin Calendar Timezone (https://vborg.vbsupport.ru/showthread.php?t=119832)

papermonk

06-28-2006 11:14 PM

vBulletin Calendar Timezone

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

08-08-2006 11:43 PM

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:

Code:

$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";

All times are GMT. The time now is 06:31 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01065 seconds Memory Usage 1,709KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: