vBulletin Forum Sideblocks - NGG - Upcoming Events - Forum Side Block

not Supported

Upcoming Events in Forum Block

I recently had a friend make this for me so i DO NOT support this and/or take any credit

I simply show you how to add the "Upcoming Events" in the forum side block

1/ Goto your Admincp

2/ Forums and moderators - Forum Blocks Manager

3/ Add block

4/ Name : Your choice

5/ Active : Yes

6/ Select : PHP

7/ In Content copy and paste :

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; 


8/ Template top use : block_html

You can see it in action and working here : NGG Clan

This is on vb4.0.5 and as stated - I can NOT SUPPORT this as i am no coder but i had it made for me at a small price and wanted to share it with the community here

Enjoy and please mark installed and comment if you use it, Cheers

Donations are welcome to betts02@tiscali.co.uk via paypal

[CharlieDelta]

Working fine! I have multiple calendars on my forum and there are events that I would not want shown in upcoming events. How would I specify a calendar?

[betts02]

Maybe check the calendar permissions ?

Will have a look as i dont use this anymore myself and get back to you

Cheers

[preswylde]

I put this in a sidebar block on my forums and tested it out. It's a great concept if it actually posted the event there reflecting the same day that the event is listed on the calendar. http://www.norcalbots.com/forums have a look and see. In the calendar, I placed a new event titled GAME RELEASE | Call of Duty: Black Ops and set it as an all day event for November 9, 2010 but when it showed up in the block, it shows as the 8th. I probably wouldn't even have noticed the discrepancy if it hadn't been for the COD:Bops game.

[Videx]

Yes, the date discrepancy is bizarre. Somebody's going to figure it out someday, but until then the only way you can get Upcoming Events to work right anywhere is to copy the original code.

[peugeot405]

Not working for me. tried the two codes and none is working.
Getting the same error on both

Fatal error: Class 'vB' not found in /home/peugeot405/domains/fsrclan.com/public_html/fsr-test/includes/block/html.php(95) : eval()'d code on line 9

i have vb 4.0.8.

anyone know how to fix this

[peugeot405]

working perfectly in vb 4.0.7

[digibyte]

There is an error in the query.
This line:

PHP Code:

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


should become

PHP Code:

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


The new query will display multi-day events till the last day of the event.

[Zweeper]

is this showing the birhtdays as well?

[oldfan]

Nothing showing up at all

[PrincessFiona]

Thanks for that fix. I was wondering why I couldn't get mine to work and now it's doing it's job!