vBulletin CMS Widgets - Upcoming Events

Upcoming Events

Released 28/12/2009
By Vikas - http://www.ngcoders.com

Installation

• Goto Admincp->vBullietin CMS->Widgets->Create New Widget
• Choose PHP Direct Execution as Widget's Type
• Place a Title. eg Upcoming Events. Keep it short as this is what will appear as title on your pages.
• Click Save
• Click Configure on the right of the new created widget.
• Remove the default code that appears. Be sure to not leave behind even a single letter.
• Copy and Paste the code that you can find below.
• Leave the template name as is (vbcms_widget_execphp_page)
• Click Save
• Goto Admincp->vBullietin CMS->Layout Manager
• Click Go on the Default Layout
• Add the Widget to your Layout
• Click Save
• That's all !!

PHP Code

PHP Code:


ob_start();


//  %d
$show_count = 5;

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%d' || (  dateline_from > '%d' AND dateline_to < '%d' )) ORDER BY dateline_from ASC LIMIT %d",TIMENOW,TIMENOW,TIMENOW,$show_count);

$event_get = vB::$db->query_read($query);

$output_bits = '';
while($event = vB::$db->fetch_array($event_get)) {

     if($event['dateline_to'] == 0 )
     {
         $format = sprintf("On %s",date('jS M Y',$event['dateline_from']));
     } else {
         $format = sprintf("From %s to %s",date('jS M Y',$event['dateline_from']),date('jS M Y',$event['dateline_to']));
     }
     
     $output_bits .= sprintf('
        <div class = "cms_widget_post_bit"><h4 class="cms_widget_post_header"><a href="calendar.php?do=getinfo&e=%d">%s</a></h4>
            <p class="cms_widget_post_content">%s</p>
        </div>
        ',$event['eventid'],$event['title'],$format);

}
$output = $output_bits;

ob_end_clean(); 


[ngcoders]

IT works fine for me , maybe it has to do with the Time setting on your server. The DST setting please look into it.

[Conner85]

It shouldn't matter what our DST settings are set to (for my problem anyway). The fact of the matter is, when I post an event for .. lets say.. January 1st, 2010, It displays the time the event was posted, not the date of the event.

[Radek Klein]

Works perfectly on my site, thank you.

[wacodep]

Originally Posted by ngcoders

IT works fine for me , maybe it has to do with the Time setting on your server. The DST setting please look into it.

If it had anything to do with the DST or time setting on the server, then the calendar itself (not just the widget, but the vB calendar) would be displaying the events on the wrong date, too.

But it's not.

FYI: All events are showing up correctly on the calendar *and* the server time and DST is set correctly.

[imagirlgeek]

Originally Posted by wacodep

If it had anything to do with the DST or time setting on the server, then the calendar itself (not just the widget, but the vB calendar) would be displaying the events on the wrong date, too.

But it's not.

FYI: All events are showing up correctly on the calendar *and* the server time and DST is set correctly.

I have the same issue. I have an upcoming event in the calendar scheduled for January 23rd, but on upcoming events it lists January 22nd.

[imagirlgeek]

Okay, I found something.

If my event is a Single, all day event, it shows up on Upcoming Events a day early.

However, if I change it to a Ranged event (start time and end time), I get an option to change the time zone. It defaults to GMT. I change it to GMT-5 and it displays correctly in Upcoming Events.

I'm not sure why I don't have the option to set a time zone on a Single, all day event. Nor do I understand why vB4 stores it in the database as GMT unless I choose a Ranged event.

Is there anyway to compensate for this?

[ngcoders]

The GMT setting should have been there in both or should be there in none, only vb4 guys can answer why is it so.

[wacodep]

The problem appears to be a VB bug.

When setting a "Single, All Day Event", vBulletin still sets a start and end datetime, but the END datetime is being set for the DAY BEFORE the event's start datetime. No idea why it is doing this, but it appears to be a bug.

[wacodep]

The single day and ranged events seem OK, but the way this widget displays the start and end datetimes for a recurring event is confusing.

If you have an recurring event that occurs once a week for 2 years, it looks like this in the widget:

Event Name X
From 2nd Jan 2010 to 2nd Jan 2012

This makes it look like the event is ranged event, taking place for two years solid, every day.

Recurring events should show up not as a range, but as a single event for each day they occur, such as:

Event Name X
On 2nd Jan 2010

Event Name X
On 9th Jan 2010

Event Name X
On 16th Jan 2010

[NickyNet]

nice mod! thank you for that!

but just one more info:
recurring events which are setup before "today", will not be shown.