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


[mfowler70]

Only problem I have with this mod is that it shows an event for tomorrow just fine, but not the next one, which is two weeks away.

[killerford]

No file to download for some reason?

[Schoelle]

Originally Posted by killerford

No file to download for some reason?

Just read the description. It's only a few lines. Everything what you need is there.

[Volvoholic]

This widget does not display recurring events

Instead, it displays an event name with a date range. Is there a way to make the widget display recurring events? For example;

PHP programming 101 <---- Recurring
Tuesday March 1 2012

Advanced PHP programing
Wednesday March 2 2012

Weekend Coffee Morning
Saturday March 5 2012

PHP programming 101 <--- Recurring repeated
Tuesday March 8 2012

[AkihiroKytori]

Same issue here. Its a pain to find a widget to do what we need. I really think im gonna have to keep modding the heck out of what I find for every thing I need to do.

And im not a PhP coder...

[Toorak Times]

Mate, you have made my week!!!! I have been trying to find a simple events widget for my gig guide for a long time. Perfect little tool. I also need something 'bigger' in this area, keep me posted. Thanks again, woohoo! So easy too, a mod I couldn't muck up!

[Tri@de]

There's a way to get events from a differend calendar?

[nasko]

Can I make this block to show events from chosen calendar not all calendars?

[Elenna]

See updated code in future post.

[SweCastel]

After the latest update from vBulletin 4.1.12 the calender is not showing when using the option: Show whole article on sectionpage.

It´s have been working before, now is it only showing the raw code!
When visiting the articles own page to display the article then it is working.

But I want it to be displayed as before on "the multi-articles page".