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


[betts02]

Been waiting for this to be made to work in a forum block, hope it can be sorted

[ragtek]

Originally Posted by FatalCure

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();
return $output; 


in a forum block as php.

As i said, it's working fine for me.

[betts02]

vb4.0.5 and not even showing up, tried the code you posted but for some reason nothing at all shows up

EDIT :

Confirms it works BUT....

It does not show the event on the day, it only shows the events leading up to the date, and not on the date of the event

The dates are moxed up, I posted a test event for tomorrow, yet this shows it for today

[ragtek]

Yea, just wanted to write the same^^

[TransAmDan]

How about Repeated events. It doesn't appear to show them.

The regular Calendar is here:- http://forum2.solent-renegades.co.uk/calendar.php we have a club night every other Tuesday.

However it doesn't show up on your widget:- http://forum2.solent-renegades.co.uk/content.php

Great mod by the way. It was just what I needed. I haven't started learning PHP yet, I've come from an ASP / VB background. PHP looks simple enough but at this point I wont be looking into modifying your code.

[FatalCure]

Anyone know what could be causing my error?

[sulasno]

can this widget include holidays?

[bassmonkeys]

the mod works all good, except - what several users wrote - the events of the actual day are not displayed.

i have browsed the whole discussion and did not find a solution - if anyone can help that would be great!

[FatalCure]

Originally Posted by bassmonkeys

the mod works all good, except - what several users wrote - the events of the actual day are not displayed.

i have browsed the whole discussion and did not find a solution - if anyone can help that would be great!

Yep this would be great.

[FatalCure]

bump