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


[Tri@de]

Ah.. yes, because, the customfields record have inside also the setting of the custom field. the only way is to separate the options

[level8]

mm.. still cant work it out anyone else had any joy on this?!?!

[Kiint]

What I would like on this is for it to show recurring events up to 4 weeks in advance, so if i had an event scheduled for every wednesday then the widget would show this event 4 times, plus any other events inbetween them, eg:

weekly event
single event
weekly event
weekly event
monthly event
weekly event
etc etc

with a limit of 10 events,.. possible?

[Kiint]

Anyone? The way it displays recurring event's is pretty bad, only shows the next one coming, not any others, and that one is at the top because it was created before all the others, not inline like the daily events are......

[Eq4bits]

Originally Posted by Kiint

What I would like on this is for it to show recurring events up to 4 weeks in advance, so if i had an event scheduled for every wednesday then the widget would show this event 4 times, plus any other events inbetween them, eg:

weekly event
single event
weekly event
weekly event
monthly event
weekly event
etc etc

with a limit of 10 events,.. possible?

all that's a bit more than I can do code wise =S sorry... what I had to do on mine was enter recurring events individually (i used sql to do that on the database end - i.e. insert into _events - used an online unix date converter for dates )
but
you set your limit of events in the widget code itself:

PHP Code:

$show_count = 5; 


by changing the '5' to whatever you want... 10, 15, 20

[Eq4bits]

Originally Posted by Tri@de

Yes, but how you put in the code. i tried, but i've done somthing wrong...

I read somewhere that with the calendar custom field you have to 'unserialize' it first - in the widget code - then you can pull from it

[N^G]

ignore this post, wrong mod thread!!!

[zapiy]

Can i use this on VBadvanced as a module is some way please?

[mna703]

great plugin, thanks! One problem though.....If I have an event set for lets say 9-11pm EST, the event disappears from the viewer right after 9pm. I would like the event to stay posted throughout the duration of the event...is there anyway to make the event stay for the duration of the event (9-11pm) instead of disappearing rite at 9pm?
Thanks!

[fxdigi-cash]

is it possible to display the upcoming events on top of forumhome instead of sideblock??