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


[nekiw]

what happends if I dont moderate posts on the forum that is assigned to the event module but I do moderate calendar?
will the forum thread be deleted if I moderate the calendar thread and delete it?
curious if I can have that everyone can post on forum, but I can moderate calendars for what that will show up there? and in widget.

[khuhner]

Where is the developer?

[Verionia]

What is the code for forum block?

[doopz]

Originally Posted by khuhner

In vB 4.0.1 I entered an event to occur on March 1st, 2010. In the UPcoming Events block it shows the event occuring on Feb 28th, 2010.

The 2 images below show the correct calendar entry and the second shows the widget showing the wrong date.

Same here. Have events happening before March 28th yet it only seems to show March 28th.

Any solution for this?

edit some debugging:
Query =
SELECT * FROM event WHERE visible = 1 AND (dateline_from > '1267633147' || ( dateline_from > '1267633147' AND dateline_to < '1267633147' )) ORDER BY dateline_from ASC LIMIT 5

seems to be going wrong with the dateline?


edit 2: Hmm I guess this has to do with recurring events.
How do I display these too?

Originally Posted by Bitti

Delete

PHP Code:

 . ' ' . VB::$vbulletin->options['timeformat'] 


Originally Posted by voglermc

from where?

Good question, from where?

[Chrissy_Ratbag]

I get a parsing error, see previous post of mine.

Can anyone help me please?

[cindy helmond]

thx but needed for forumblock ?
thx

[ngcoders]

If you are facing wrong time and date of even being displayed ... then it is related to GMT setup of your host / script.

[khuhner]

Originally Posted by doopz

Same here. Have events happening before March 28th yet it only seems to show March 28th.

Any solution for this?

edit some debugging:
Query =
SELECT * FROM event WHERE visible = 1 AND (dateline_from > '1267633147' || ( dateline_from > '1267633147' AND dateline_to < '1267633147' )) ORDER BY dateline_from ASC LIMIT 5

seems to be going wrong with the dateline?

From a post in this very thread:

Originally Posted by waynem

I set the offset to 86400 and it seems to work, thanks!

So you'll need to adjust the offset to what you need.

Kurt

[betts02]

Originally Posted by Verionia

What is the code for forum block?

I would like also to use this in a forum block, Maybe have it so it fetches a thread title ony ?

I have a gaming site and this would be great to show what matches we have planned

[is_it_me]

Seems to be working great for me ? http://www.doctorwatson.info

But, I have several different calendars and was wondering if there?s anyway to exclude one in particular from showing up in the widget?