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


[vilhiem]

Are there any other mods out there that may do this and display the events accurately ...?

[Webbstre]

Copied the code into a Forum Block and it worked perfectly. Thanks!

[Eq4bits]

My forum has more than one calendar. Is there any way to only pull events from a specific calendar instead of all of them lumped together?

[khuhner]

This widget doesnt handle reocurring events very well. It lists the beginning and ending date of the range of the event, rather than each instance as one would expect. Anyone have any luck in modifying this?

[Eq4bits]

Originally Posted by Webbstre

Copied the code into a Forum Block and it worked perfectly. Thanks!

I couldn't get it to work this way, perhaps I should have chosen pure text instead of php?

[COL NIL SATIS]

Originally Posted by Webbstre

Copied the code into a Forum Block and it worked perfectly. Thanks!

does this work ????

is the block set as

Choose which content type do you want to use:
Pure Text - Display Pure Text content
HTML - Parse HTML code and display
PHP - Parse PHP code and display

[LBmtb]

Nice, simple, and effective. Thanks

[COL NIL SATIS]

Originally Posted by Eq4bits

I couldn't get it to work this way, perhaps I should have chosen pure text instead of php?

Tried as PHP but still no luck .......any chance that someone can get this working in a forum sideblock ???

[Leeleemu]

Originally Posted by Stadler

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

Sorry been away, by not working, I mean when I add your code, once again the day of the event is stated as being the day before, furthermore on the day, the event still disappears.

Anyway, currently with the original code and edit (to make the days the correct one), I have an event for the 1st August 2010 but it is labelling it as on the 32th July?

[rabidkevin]

I am petitioning on vbulletin.com to implement this as part of the vbulletin code and release us an upcoming events widget.. everyone please voice your opinion about this here -> http://www.vbulletin.com/forum/showt...17#post2014317