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


[tomsch]

ok the range events not displaying is fixed in this version

ob_start(); 
global $db,$vbulletin;


$mydate =  mktime(0, 0, 0, date("m"), date("d")-1, date("Y"));
$show_count =10; 

$query = sprintf("	SELECT * FROM ".TABLE_PREFIX."event 
					WHERE visible = 1 
					AND (dateline_from >= '$mydate' || (dateline_from >= '$mydate' AND dateline_to <= '$mydate' ) || ('$mydate' BETWEEN dateline_from AND dateline_to)) 
					ORDER BY dateline_from ASC LIMIT $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",vbdate('D M jS Y',$event['dateline_from'],false,true,false,true)); 
     } else { 
         $format = sprintf("From %s to %s",vbdate('D M jS Y',$event['dateline_from'],false,true,false,true),vbdate('jS M Y',$event['dateline_to'],false,true,false,true)); 
     } 
      
     $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();

[Eq4bits]

Awesome, tomsch! Thanks bunches!.
I added the horizontal line to mine like this:

<p class="cms_widget_post_content">%s<br><img src="images/hz-line.png"></p>

[toxin]

Range events are working, but when there's a recurring event the widget only displays the range.

I have created a recurring event. The range is starting Jan 01, ending Dec 31 and the event is 1st Sunday of every month.

The event is listed, but the widget just displays this:

My Event
From Sat Jan 1st 2011 to 31st Dec 2011

And because the range started Jan 1st, this event is always at the top of the list.

[rcull]

I just tried this code and got the following error:

Parse error: syntax error, unexpected T_STRING in /home/teambuic/public_html/forums/packages/vbcms/widget/execphp.php(191) : eval()'d code on line 32

Thanks

[tomsch]

[QUOTE=rcull;2215721]I just tried this code and got the following error:

Parse error: syntax error, unexpected T_STRING in /home/teambuic/public_html/forums/packages/vbcms/widget/execphp.php(191) : eval()'d code on line 32

Thanks[/Q

sounds like you either have a cut and paste error or the widget configured wrong

[rcull]

Thanks,
It was a cut and paste error!

[kylek]

Originally Posted by Eq4bits

Awesome, tomsch! Thanks bunches!.
I added the horizontal line to mine like this:

<p class="cms_widget_post_content">%s<br><img src="images/hz-line.png"></p>

Where would you add this to the code? Looking for either a line between events or just a space.

Thanks tomsch for all your input you have added!

[level8]

wow great updates thanks for making this even better... is it possible to add a generic icon next to each post?
if so where would you insert the code?

[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

this is what i need help on

[XrayHead]

Hi All

Anyone know how to lose the stupid PHP icon in the upper top left?