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


[claystation]

I have one custom field on my calendar. Does anyone know how I could show that data from the custom field, along with the title & date in this widget?
Thanks,
Andy

[Kyle Tully]

When I "save" the code in the configure page... it doesn't save.

No errors, just doesn't save. The default code keeps reappearing.

Anyone had that happen before?

[level8]

great widget...
can anyone help with 2 things?
1. How do I add a link at the bottom of the widget called somethign like "Add an Event" which simply will link to the http://****.com/calender.php?
2. Add a small icon image next to all events ( ).

Any help is much appreciated

[NashChristian]

Originally Posted by doopz

can someone please enlighten me how to list recurring events?

I don't believe it works for that. It will just show the FIRST occurrence, as far as I can tell.

[doopz]

Originally Posted by NashChristian

I don't believe it works for that. It will just show the FIRST occurrence, as far as I can tell.

Ah, that explains.
Well I'm willing to pay someone who can make it that way, just name your price

[khuhner]

Originally Posted by level8

great widget...
can anyone help with 2 things?
1. How do I add a link at the bottom of the widget called somethign like "Add an Event" which simply will link to the http://****.com/calender.php?
2. Add a small icon image next to all events ( ).

Any help is much appreciated

Yet another reason why these types of features should be included as standard VB rather than relying on hacks. Why cant VB figure this out? Other CMS systems already have a rich set of widgets (aka blocks) such as Xoops. It just seems as if there is a lot of room for improvement in the wigget space for modules.

[level8]

Originally Posted by level8

great widget...
can anyone help with 2 things?
1. How do I add a link at the bottom of the widget called somethign like "Add an Event" which simply will link to the http://****.com/calender.php?
2. Add a small icon image next to all events ( ).

Any help is much appreciated

The option 2 isnt super important at the moment just cosmetics really....

but I tried to insert simple html link into the code but wouldnt work .. anyone?

[ngcoders]

@level8

1. append the link to $output_bits.
2. prepend icon near

PHP Code:

<a href="calendar.php?do=getinfo&e=%d">%s</a> 


And some css to fix alignment issues.

[mattpist]

i tried copying and pasting the code into a forum block, but nothing shows up. is there a way to adapt this to forum blocks? thanks!

[JesusPokerChile]

Any help on recurring events???