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(); 


[waynem]

I set the offset to 86400 and it seems to work, thanks!

[Front Range]

Is there a way to make this as a forum block too?

[reefland]

I have a question. Does anyone know how I could make this show the upcoming 5 as well as the previous 5 events?

[Chrissy_Ratbag]

Does this link with the Forum Calendar?

[SonicGT]

Installed this and it appears to be showing all events 1 day ahead of schedule on the calendar, any ideas or thoughts?

[Sotonforum.co.u]

Originally Posted by Big-Pete

Just tried this in VB4 gold and there's not a widget type like this


Was the php direct execution widget type removed from the gold release??

It isnt showing up for me either. It's VERY annoying. I hope they fix this soon.

[Eq4bits]

it's in the dropdown
if you still can't find it try reuploading all the vbCMS files & contents of them (this happened to me and that solved the problem)

[Front Range]

Originally Posted by waynem

I set the offset to 86400 and it seems to work, thanks!

That worked for me too.

Installed.

[Eq4bits]

Originally Posted by Front Range

That worked for me too.

Installed.

What timezone offset you for that to work?

[Easific]

Originally Posted by Eq4bits

What timezone offset you for that to work?

Dont know where this is pulling the time from. I am in GMT +5.5, but the calendar worked even for a 5 hour offset value of 18000 seconds. Confusing.

86400 is the offset for 24 hours, so this is not the best way to do it.