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


[Elenna]

Originally Posted by XrayHead

Hi All

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

You'll need to edit the "vbcms_widget_execphp_page" template to remove the reference to that image.

i.e.
Find:

<h3><img src="{vb:stylevar imgdir_siteicons}/php.png" alt="" /> {vb:raw title}</h3>

Replace with:

<h3>{vb:raw title}</h3>

[vb.help]

Can anybody please post a code ?

I tried with the code in the main page and it gives a blank page.

I also created an event for tomorrow to test but nothing showed up. Please help !!

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 rel="nofollow" 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();

[XrayHead]

Originally Posted by Elenna

You'll need to edit the "vbcms_widget_execphp_page" template to remove the reference to that image.

i.e.
Find:

<h3><img src="{vb:stylevar imgdir_siteicons}/php.png" alt="" /> {vb:raw title}</h3>

Replace with:

<h3>{vb:raw title}</h3>

Cool thanks for that, I changed to the following so I have a nice Calender ICON now

PHP Code:

<h3><img src="{vb:stylevar imgdir_misc}/event.png" alt="" /> {vb:raw title}</h3> 


[Fraggs]

This is probably entirely off-topic to this widget specifically, but I was hoping someone could help me out. Once I create the widget, I click configure, and copy the code in. But when I hit Save, it closes out the Configure box without saving the changes, and when I hit Configure again the default PHP Widget code is still there. I have narrowed it down to pretty much just the PHP Widgets, at least as far as what I use. I can still edit and save my Static HTML Widgets just fine. Any ideas?

Edit: Nevermind, it is Widget specific. It's just not saving THIS code. I can delete the default and save it blank, or save it with random text, but it will not save this code.

[misericorde]

hY

Not work with 4.1.7

[Chiaki]

The widget only shows one date to me, even though I have two test events and even though they have names. How come?
I use the newest vB 4 installment in German.

[mmoore5553]

How do we get this installed. i have tried everything . I setup as per instructions and nothing.

[Ozy]

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

Any way to get help on this? Ranged reoccurring events are problematic and the ONLY issue remaining for me. We have our monthly general and board meetings defined in our calendar, and the widget shows the entire range.


Thunderbird Hamfest
From Sat Jan 7th 2012 to 7th Jan 2012
Board Meeting
From Fri Jan 13th 2012 to 13th Jan 2014
General Meeting
From Fri Jan 20th 2012 to 1st Feb 2013
Arizona Centennial
On Sun Feb 12th 2012

I need it to say the date for the upcoming event, and not display the range. It's completely useless that way. Many people have asked for help on this and they have all gotten ignored.

Please help us!

Thx

[skokarl]

thanks, it's okay with 4.1.9

[UK CHI3F]

Does anyone know how to change the text colour for the header to
#00FF00 (green)

but i want to leave the date as white

Sorry a bit of a newb on code