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


[Lexor]

I installed the widget on 4.0.7
But when i adde an area in my cms and want to choose it i became an error message like this:

Call to undefined function vbgmdate() in /www/htdocs/XXX/XXXX/packages/vbcms/widget/execphp.php(194) : eval()'d code on line 43

Can you help ?

[TCB]

Looks and works great. Thanks

[Eq4bits]

Originally Posted by NashChristian

Alright, at least I'm not going crazy. I did some research at our neighboring events widget mod, and found that they have encounterd the exact same problem, with a solution outlined here.

My GMT is -6, so whenever an event is scheduled to begin at 6pm or later, it displays the date for the following day.

Now, I just need to figure out how to apply this same solution to this mod.

At least there is hope.
Jeff

I went with the other code as well, set the GMT offset to match my site's 'time'.
Had to laugh tho when I went to check to see if it was displaying right.
Display for 'today' was perfect... but April 1st events showed as being

On 32th Mar 2011

Not sure if that's an intentional 'funny' or something weird because March has 31 days... and I don't have have any events for the 29th, 30th or 31st. the wording is a bit 'fonky' for 2nd displaying as '2th' and 3rd displaying as '3th'. Also only 1 event per date is showing when I know at least one has 2 events scheduled

[Eq4bits]

Originally Posted by SuperGLS

Also, I wish the colon had a space on the RIGHT instead of the LEFT. Any ideas?

I was able to add a space *after* the colon (but unable to remove the space to the left by changing
THIS

$eventbits .="<tr><td nowrap class=''><strong>".$date.":</align></td><td width='100%' class=''><a href='calendar.php?do=getinfo&e=$did&c=".$calendarid."'>".$dtitle."</a></td></tr>";

TO THIS

$eventbits .="<tr><td nowrap class=''><strong>".$date.":</strong></td><td width='100%' class=''>&npsb;<a href='calendar.php?do=getinfo&e=$did&c=".$calendarid."'>".$dtitle."</a></td></tr>";

[Eq4bits]

I finally got mine to pull the 'current' date & it's events

FIND:

PHP Code:

ob_start(); 
global $db,$vbulletin; 
$calendarid="1"; 
$per_page = "10"; 


CHANGE TO:

PHP Code:

ob_start();
global $db,$vbulletin;
$mydate =  mktime(0, 0, 0, date("m"), date("d")-1, date("Y"));
$calendarid="1";
$per_page = "10"; 


FIND:

PHP Code:

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


CHANGE TO:

PHP Code:

$getevents=$db->query_read("SELECT * FROM ".TABLE_PREFIX."event WHERE calendarid='".$calendarid."' AND visible= '1' AND (dateline_from >= '$mydate' || (  dateline_from >= '$mydate' AND dateline_to <= '$mydate' )) ORDER BY dateline_from ASC LIMIT $per_page"); 


[Onkeltyson]

Thanks for that

[ReBe]

I have some recurring entrys, but in the widget only the first from the recurring entrys are shown. Is there a solution for it?

[barnsi]

changed to

PHP Code:

$date = vbdate('j. F Y 


vor dem "j." muss das Hochkomma stehen, wird hier leider nicht richtig dargestellt.
Das ergibt dann die Anzeige: "9. August 2012" statt "08.09.12"

[Arrogant-One]

Originally Posted by cory_booth

Create a PHP Type Widget and paste the below code.

Hi Cory.

How do I do this exactly? I am a bit of a novice at vB but have learned some stuff. Editting templates is a breeze. Is this like that?

What do you mean by 'Create a PHP Type Widget'

[otterag]

The calendar im trying to show events for is almost all recurring events and this mod does not show any of them.

Is there a way to pull those for the dates that they actually occur on with out having to redo the entire calendar day by day?

here is a screen shot of the mod on the left and the calendar on the right.

http://armadagames.com/forums/images...s_calendar.jpg