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


[Stadler]

Nice widget, but it won't show 'All Day'-events.

To fix this find:

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

and replace it with:

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

HTH,
Christian Stadler

[schlottkej]

Originally Posted by Leeleemu

I second this, would be a great addition

In fact is there an area which is dedicated on creating certain forum blocks?

No, I don't believe there is. Would be great to see one.

[Leeleemu]

Originally Posted by nader

how can fix to show the event of current day?

Anyone, for instance the Cotto v Foreman fight has been on the widget all week but now its come to the day of the fight it has disappeared, therefore, is there any way to keep today's event on the widget?

[Stadler]

Originally Posted by Leeleemu

Anyone, for instance the Cotto v Foreman fight has been on the widget all week but now its come to the day of the fight it has disappeared, therefore, is there any way to keep today's event on the widget?

It this an 'All Day'-event? Then check my post and see if that fixes it for you.

[Leeleemu]

Originally Posted by Stadler

It this an 'All Day'-event? Then check my post and see if that fixes it for you.

Sadly no dice. It turns my whole Front page off giving it an error.

[Stadler]

Try again. I fixed a typo in my post above. It should work now.

[your24hourstore]

ahha i just noticed something

the problem only occurs if you don't use ranged events and set an end date ...

to make it work correctly you have to have a starting and ending day.
so the weird thing happens only on single all day events
haven't tried reoccurring yet !
works i figured it out now

installed

[Leeleemu]

Originally Posted by Stadler

Try again. I fixed a typo in my post above. It should work now.

Nope doesnt work. This is annoying.

Thanks for helping though Stadler.

[vilhiem]

The two issues that seem to persist are:

(1) Getting re-curring events to display after the initial day (even though I have specific date ranges); and
(2) Getting the current day's events to display

Otherwise, it's a great mod and in spite of these issues, I use it on my main page.

Think it's funny that vBulletin does not provide this as a built-in feature (similar to their built-in feature that displays recent posts)

[Stadler]

Originally Posted by Leeleemu

Nope doesnt work. This is annoying.

Thanks for helping though Stadler.

What 'doesnt work'? Can you please be more specific?

[Edit:]Here's the full code in my widget:

PHP Code:

ob_start();


//  %d
$show_count = 5;

$query = sprintf("SELECT * FROM ".TABLE_PREFIX."event WHERE visible = 1 AND (dateline_from > '%1\$d' || (  dateline_from > '%1\$d' AND dateline_to < '%1\$d' ) || (dateline_to = 0 AND DATE(FROM_UNIXTIME(dateline_from)) = DATE(FROM_UNIXTIME(%1\$d)))) ORDER BY dateline_from ASC LIMIT %2\$d",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.php5?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();