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


[unfv]

Originally Posted by S1OPP

Installed and working great.

Q: Is there a simple way to get it to include upcoming birthdays?

yeah please, can someone help us with this?

Thanks

[Guust]

Hi
Firstly, I love the widget and so far it (kind of) works.

The small problem I have is that it does not seem to adjust for my Default Time Zone Offset, which is GMT + 10. So the homepage says an event is on the 10th and the calendar says it is on the 11th depending on the time of day you visit the site.

Check it out here:
http://www.2cv.com.au/content.php
and here
http://www.2cv.com.au/calendar.php?do=getinfo&e=1

Any fixes anybody ?

UPDATE: The answer is in this post: https://vborg.vbsupport.ru/showpost....8&postcount=33
I just replaced the code provided by NGCoders with the code provided by NicForce and all is good!

[Chrissy_Ratbag]

I get the following parsing error

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/rat10541/public_html/forum2010/includes/class_core.php(4033) : eval()'d code on line 14

Can anyone help?

[Blue91]

Originally Posted by Guust

UPDATE: The answer is in this post: https://vborg.vbsupport.ru/showpost....8&postcount=33
I just replaced the code provided by NGCoders with the code provided by NicForce and all is good!

Same here. NicForce's code worked for me. Thanks to both coders.

[SimplyJoe]

I'm using a hybrid of NicForce's code (formatted to provide the date format that I want), but I noticed that if you are not logged on, the dates are 24 hours ahead (so a July 3rd event will show on July 4), but if you log on, the dates are correct.

here is my code, but I still can figure this out. I don't see anything that tells me to be logged in or not.

ob_start();

// %d
$show_count = 15;

$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)) {
$tz_offset = 86400;
if($event['dateline_to'] == 0 )
{
$format = sprintf("On %s", vbdate(VB::$vbulletin->options['dateformat'],$event['dateline_from']+$tz_offset));
} else {
$format = sprintf("From %s to %s", vbdate(VB::$vbulletin->options['dateformat'],$event['dateline_from']), vbdate(VB::$vbulletin->options['dateformat'],$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();

Thanks in advance.

[Guust]

Originally Posted by SimplyJoe

I'm using a hybrid of NicForce's code

Not that I really understand anything of this, but the major difference between the original code and NicForce's is that the code adds +1 to the date from and the date to. It seems you do not make a time adjustment like that, if I look over your code (not that I understand the coding).
I set it at +1 although my GMT = +10. Maybe the +1 refers to a date (a day) and not an hour.
I also found that when you use an event which covers more than one day, you might have to be creative with the begin and end dates.

[SimplyJoe]

You are correct, I do not use the plus one, because that was giving me the reverse effect.

[karlm]

Seems to be working for me, thank you!

[Peter Lo]

I tried this widget using the default code at Post #1. Setting an event say from 2 April 2010 to 4 April 2010; when 2 April comes (ie today) the whole event no longer appears.

Shouldn't it only disappear after 4th april?

[Guust]

Originally Posted by Peter Lo

I tried this widget using the default code at Post #1. Setting an event say from 2 April 2010 to 4 April 2010; when 2 April comes (ie today) the whole event no longer appears.

Shouldn't it only disappear after 4th april?

Use https://vborg.vbsupport.ru/showpost....8&postcount=33 instead