vBulletin Forum Sideblocks - UpComing Events SideBlock/Bar With/Without Image

Upcoming Events in Forum Block/Sidebar



Add the "Upcoming Events" in the forum side block
(Added as a few people seem to have issues with other mods the same)

Start by logging into your Admin cp

Goto Forums and moderators - Forum Blocks Manager and add a new Block.
Call the Block Upcoming Events(Or what ever suits your liking)
Set the block to Active
And use PhP Format.

Now add the content below :

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(); 
return $output; 


Then just make sure the template to use is set to Block_HTML

This will then show the latest upcoming event from your calendar with multi-day events shown until the last day of the event.



Update Thanks to dcuellar
What this does is add a picture centered above the upcoming event. The picture is uploaded to 'images/' as event.jpg. You can change that to whatever you want. It also corrects the issue I had with the date. It's now projecting the proper date.


NOTE:
I changed the number of events to display to 1.
I do not need the range on my forum so I did not test that part.
Here you go for those interested (change what's in Red):

PHP Code:

ob_start(); 


//  %d 
$show_count = 1; 

$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%s %s %s",date("j",$event['dateline_from'])+1, date("S",$event['dateline_from']), date("M",$event['dateline_from']), date("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"><center><a href="calendar.php?do=getinfo&e=%d"><img src="http://www.YourForum.com/forum/images/event.jpg" width="200px" alt="Upcoming Event"/><h4 class="cms_widget_post_header">%s</a></h4> 
            <p class="cms_widget_post_content">%s</p></center>
        </div> 
        ',$event['eventid'],$event['title'],$format); 

} 
$output = $output_bits; 


ob_end_clean(); 
return $output; 


Thanks go to cybaGirl for this fix:
Anyone who has the date showing as the day before can use this code in there forum block.

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"><center><a href="calendar.php?do=getinfo&e=%d"><img src="http://www.YourForum.com/forum/images/event.jpg" width="200px" alt="Upcoming Event"/><h4 class="cms_widget_post_header">%s</a></h4> 
            <p class="cms_widget_post_content">%s</p></center>
        </div> 
        ',$event['eventid'],$event['title'],$format); 

} 
$output = $output_bits; 


ob_end_clean(); 
return $output; 


[Mark4865]

2-) another issue i have right now is when an even is on Feb 9th, as soon as clock turn to FEB 9th, the even is gone, is it possible to keep it until end of the current date?

Second that important point for me as well

[bitbender]

Hi Mark --

Getting that image like you want it is going to be some template work as they are calling a function to make that line up. To do what is wanted we'd have to track back, clone the function and makes changes, then change the widget to call your new function. I'd have to dig into that and I'm a bit crunched for time for the next 10 days or so.

Btw - Never change the base VBulletin templates - always make a new style and then modify the template to be changed in YOUR style - Save you it will, at upgrade time - bcause the default VB style will always work. I learned many years ago not to try to fool mother nature

Now, you may ask, how in tarnation would I do that? Simple - Export the default style to your 'puter as an xml file and then reimport it - following the guideline below;

Create a new style with no parent style and give it a NEW name - Like "MarksTest".

Leave it as non-selectable by users.
================================================
Now - You have your own little test style that you can do what you want with and no one but yor hairdresser will know for sure Once you get stuff like you want, you can publish your style to your community by making it selectable. Or cast it into the unknown depths of the bit-bucket and start over.

2nd post - Check your recurring dates/times - make sure the end time is beyond what you are looking at. On the site I am building, there is an event that takes place this evening, but my calendar shows it and so does this mod as a widget in the CMS.

--> I also added location selection logic to seperate by location (based upon a rexexp i am looking for in the title field) so that I can list music events by location on location specific CMS pages, or lump them all together in a sidebar by using the basic widget above.

[Mark4865]

thanks for all the effort and info will have to think seriously about this as I dont want to mess with templates

[Mark4865]

Am I to understand this will work fine if I dont want the images on the side but leave them as is in their current position??

I just want the event title, date of event and a thumbnail picture, is that possible?? If so please advise exact code I need. Thanks in advance sorry for all the questions.

Mark

[way2xtreme]

hi, is there a way to show just the starting date for an event the carries over 2 days. I'd like to make this look tidy and neat.. thanks

[otterag]

a problem i am having with this is that i have not found a mod that will show a recurring event in an upcoming event widget on a daily basis instead of the range of its repeats.
I have the same type of event occuring every Friday at 3:00pm and instead of making 1 event for each Friday for the entire year i have made 1 that recurs every Friday for the rest of the year and my upcoming events widget shows instead Friday March 1st - 700pm it shows From March 1st to March 31st

is there any way to change the display output on this

from current
Event Name
From 1st March 2011 to 31st March 2011

to
Event Name
March 1st - 7:00pm

this is something that is really bothering me and i cant figure out how to make the changes after reading these boards for a few days and looking at the code. help would be greatly appreciated.

[southeastminis]

I've installed this and it works great, however I am trying to change the color of the background (where the events are actually posted.)

Anyone know what Stylevar this would be under?

[Mark4865]

Hello everyone need help please.

I have used this in the CMS with a few changes (images on right text on left) works great BUT cant get images to show. They show up fine in the actual event but not in the widget here is an example of my image address for one image http://www.mywebsite.co.za/temp%20lo...Beach_2010.jpg

this is the code I have used, how do I get the image to show

ob_start();


// %d
$show_count = 10;


$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%s %s %s",date("j",$event['dateline_from'])+1, date("S",$event['dateline_from']), date("M",$event['dateline_from']), date("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"><a href="calendar.php?do=getinfo&e=%d"><img src="http://www.YourForum.com/forum/images/event.jpg" width="75" height="60" alt="Upcoming Event" HSPACE="7" VSPACE="3" align="left"/><h4 class="cms_widget_post_header"><b>%s</b></a></h4>
<p class="cms_widget_post_content"><b>%s</b></p>

</div> <BR/><BR/>
',$event['eventid'],$event['title'],$format);

}
$output = $output_bits;


ob_end_clean();
return $output;

[Voeltz]

This.. is.. AMAZING!! thanks, works wonderfully:
http://goo.gl/p2SqP

[tomsch]

<a href="https://vborg.vbsupport.ru/showthread.php?t=231365" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=231365</a>

this post has a corrected query that take into account time zone and dst.