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


[Zweeper]

Originally Posted by S1OPP

Installed and working great.

Q: Is there a simple way to get it to include upcoming birthdays?

good question

[nealohara]

Originally Posted by nealohara

Nice. Is there a way of refining this a little?

Let's say we've got a room booked on Thursday the 7th January between 20:00 and 21:00 and we add it to the default calendar. Currently what we get is

Event
7th Jan 2010 to 7th Jan 2010

ideally I'd like it to display as follows:

Event
7th Jan 2010 between 20:00 and 21:00

The dates and times are all stored as variables but I don't want to screw it up

Any ideas?

lol, just realised it was already asked

[Bitti]

Originally Posted by nealohara

Nice. Is there a way of refining this a little?

Let's say we've got a room booked on Thursday the 7th January between 20:00 and 21:00 and we add it to the default calendar. Currently what we get is

Event
7th Jan 2010 to 7th Jan 2010

ideally I'd like it to display as follows:

Event
7th Jan 2010 between 20:00 and 21:00

The dates and times are all stored as variables but I don't want to screw it up

Any ideas?

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("<b>Am:</b> %s", vbdate(VB::$vbulletin->options['dateformat'],$event['dateline_from']));
     } else {
         $format = sprintf("<b>Vom:</b> %s<br /><b>Bis:</b> %s", vbdate(VB::$vbulletin->options['dateformat'] . ' ' . VB::$vbulletin->options['timeformat'],$event['dateline_from']), vbdate(VB::$vbulletin->options['dateformat'] . ' ' . VB::$vbulletin->options['timeformat'],$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(); 


[voglermc]

I can't seem to have it get recurring events listed also. I would also like it to show only the date of the event

[sisterhood]

THX extra nice Mod

[Bitti]

Originally Posted by voglermc

I can't seem to have it get recurring events listed also. I would also like it to show only the date of the event

Delete

PHP Code:

 . ' ' . VB::$vbulletin->options['timeformat'] 


[voglermc]

Originally Posted by Bitti

Delete

PHP Code:

 . ' ' . VB::$vbulletin->options['timeformat'] 


from where?

[winstone]

Looking at the way other widgets are getting cached, I think you can implement the same on this one, I've tried to do it myself but didn't have much time to get it all working

from what I have figured, all you need to do is get the widget id, generate the hash key, store the output using the widget id as an index/key, define time to live (ttl), write the whole thing into the cache using "vB_cache" thing, and the rest will be handled by the CMS, I know that because I stored the wrong info into the cache, set 5 as ttl and the widget showed up the first time I loaded the page, the next time it only showed the wrong data I cached

[M@tt]

I might be getting a little over the top on this one but I would like to have many calendars setup with just the one calendar widget though perhaps where users can choose which calendar is their preferred (times of sporting matches of different codes for example) maybe in their usercp? Just putting it out there

[Shanj]

Is it possible to select events or Hide them from the widget?
Loads of my events are tiny routine things every day or every week.
But for some special dates this would be great.