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]

Events can be set in calendar , You can see the event module on my site http://www.roboticsindia.com , It works just fine.

[grahamsmythe]

Worked a treat for me!

Great mod. Thanks.

[astrid1]

What must be precisely adjusted? a new calendar with events, or we take the standart calendar ?

[RickyG]

Still not working right fo rme....
http://www.blackberryboards.com/

[SLY LS1]

Works perfect..

Cheers

[wacodep]

Individual events are showing up as occurring the day BEFORE the day they are actually scheduled (e.g., 1/2/09 event shows up as 1/1/09).

But they are showing up correctly on the standard listing on the forum home.

[dale09]

tagged, very nice

[Big-Pete]

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

?Choose PHP Direct Execution as Widget's Type

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

[Conner85]

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??

I have gold and I have that widget type. Not sure why it wouldn't be showing up in yours.

I'm still having trouble with it showing the date it was posted, rather than the day of the event in the widget.

[Bojangles]

This will work perfect once the date gets fixed, everything is showing a day behind on the widget from what the event date is set to be.