vBulletin CMS Widgets - [WIDGET] Upcoming Events

Another upcoming events widget...
I am really waiting for someone to kickout an integrated calendar/events widget...
But until then, I am using this PHP widget for my events. I saw a few others on here, but they were not quite what I was looking for...

Feel free to use/hack/slash this code for your own use...

Navigate to AdminCP -> CMS -> Widgets.
Create a PHP Type Widget and paste the below code.

PHP Code:

ob_start();
global $db,$vbulletin;
$calendarid="1";
$per_page = "10";
//################################################
$d=date("d");
$m=date("m");
$y=date("y");
$sdate = mktime(0, 0, 0, date("$m"), date("$d"),  date("$y"));
$edate = mktime(0, 0, 0, date("$m"), date("31"),  date("$y"));
$and=" and dateline_from > '".$sdate."'";

$getevents=$db->query_read("SELECT eventid, title, dateline_from from " . TABLE_PREFIX . "event WHERE calendarid='".$calendarid."' $and order by dateline_from ASC LIMIT $per_page");
$count=0;
if(!$db->num_rows($getevents))
{
}
else
{
WHILE ($events=$db->fetch_array($getevents))
{
$dtitle=$events['title'];
$did=$events['eventid'];
$date = vbdate('m-d-y
',$events['dateline_from'], false,true,false,true);
if ($count = 2){$class="alt2";}else {$class="alt1";}
$year=date("Y");
$pagetitle = $f;
$pagetitle .= " ";
$pagetitle.=$year;
$eventbits .="<tr><td nowrap class=''><strong>".$date.":</strong></td><td width='100%' class=''><a href='calendar.php?do=getinfo&e=$did&c=".$calendarid."'>".$dtitle."</a></td></tr>";
$count++;
}
}
echo "<table align='center' width='100%'>";
echo $eventbits;
echo "</table>";
$db->free_result($getevents);
unset($events);
$output=ob_get_contents();
ob_end_clean(); 


[Bouncer222]

Is it possible to use this with vbadvanced as a module?

[cory_booth]

Most likey, but unfortunately I am not using VBadvanced...
If I remember right, you could load php files as modules.

So take the code, drop the first line ob_start and the last two lines...
Save as a php file and then try loading as a module...

[SuperGLS]

Gonna try this and see how it works. Thanks!

[4thstar]

Thankyou this works well, i have one small issue though that you may be able to help with please.

this displays upcoming events but it does not show an event for the day itself, if you have an event on the 20th and it is the 20th it wont show that event, for us the events are on in the evening so during that day we would still like to show it as being an upcoming event,

i edited this bit from

PHP Code:

$and=" and dateline_from > '".$sdate."'" 


to

PHP Code:

$and=" and dateline_from >= '".$sdate."'" 


thankyou
Kind Regards
Carl

[NashChristian]

Thanks!

[NashChristian]

Originally Posted by 4thstar

This displays upcoming events but it does not show an event for the day itself, if you have an event on the 20th and it is the 20th it wont show that event, for us the events are on in the evening so during that day we would still like to show it as being an upcoming event,

i edited this bit from

PHP Code:

$and=" and dateline_from > '".$sdate."'" 


to

PHP Code:

$and=" and dateline_from >= '".$sdate."'" 


Hello,

I implemented this modification, as I too want to post events from the current day as well as future dates. I'm having one problem with this, for some reason, though it will list events that are occuring TODAY, it displays TOMORROW's date next to it. Does anyone know how I can fix this?

Here are a couple screen shots (look at the top listing on the widget):





The dates are correct for every day's events except TODAY's. I need to find a solution for this. Any help would be appreciated.

Thanks!
Jeff

[HobbesGTS]

Is there anyway to modify this code to get it to display a custom field as well?

[NashChristian]

Now I'm confused! Ok, I couldn't figure out how to get yesterdays events (04-30-10) to display with yesterday's date (they showed 05-01-10), SO I reverted to Cory's original code (without the '>=' mod), the results have me scrathing my head.

I cleared my CMS cache and tested this using a couple different browsers, here's what I found (the top two events listed are actually 04-30-10 events):



NOTHING CHANGED. Which confuses me for two reasons. The first, is since I'm running the original code without the slightest change, why am I the only one claiming to have a problem with this. Second, it was my understanding that events for TODAY would NOT show up with this widget, which is why 4thstar added the '>=' mod.

Is anyone else experiencing similar difficulties?

Another thing that has me scratching my head, is now that the clock reads 12:20 AM, and the day has effectively changed to 05-01-10 (first day of the month) the events listed for TODAY display the correct date (05-01-10) in the widget.



Is this just some sort of "end-of-the-month bug"? Has anyone else noticed this or come up with some sort of work-around?

Help me out here people, I'm confused.

Thanks!
Jeff

[NashChristian]

Actually, upon further investigation, I see that I'm having the same problem on SEVERAL of my upcoming event posts with this widget. Here are two screen shots that illustrate this problem (compare the event dates with those displayed in the widget above):





This isn't happening on EVERY event, however it is happening on close to 50% of them! I don't think the date syntax works in this code. I appreciate what it is trying to accomplish, instead of listing it in long form like the other mod out there, I really prefer the short format, but I don't think it works right. When the date is off, it is always off by exactly 1 day.

Is anyone using this with a site that posts a lot of events, and can you provide a link to your site so I can compare the widget dates to the actual calendar event dates? I'd be curious to see how this is working for other people.

What a shame! I really like this mod, and don't want to use the long form date range display.

Bummer!
Jeff