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]

ya ... appears to only show the FIRST of a recurring events series. Is there any way to resolve this ...? Thanks! Otherwise, great mod!!!

[vilhiem]

and ... grrr ... it's off by a day!!! was there something here I missed to fix this ...?

[JesusPokerChile]

Hi really need help on recurring events!!! PLEASE HELP SOME ONE!

[Guust]

Originally Posted by vilhiem

and ... grrr ... it's off by a day!!! was there something here I missed to fix this ...?

Try this: https://vborg.vbsupport.ru/showpost....8&postcount=33

[ssanin]

Originally Posted by Guust

Try this: https://vborg.vbsupport.ru/showp...8&postcount=33

link doesn't work mine is off by a day as well.

[Guust]

Originally Posted by ssanin

link doesn't work mine is off by a day as well.

Updated the link: https://vborg.vbsupport.ru/showpost....8&postcount=33

[ssanin]

Thank you very much! Love it

[level8]

Originally Posted by 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.

Thanks for the code.. but complete newbie on this type of code.. how/where do I add this into the orginal code above???

[schlottkej]

What changes need to be made to make this work as a BLOCK in the sidebar?

[Leeleemu]

Originally Posted by schlottkej

What changes need to be made to make this work as a BLOCK in the sidebar?

I second this, would be a great addition

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