Calendar events on non-VB pages

This extension allows you to pull calendar events to display on a non-VB page. You'll need to change the first few lines to reflect your current site information, and look within the code for the site URL to change to your own. In this script, it occurs three times (DOMAIN.COM/FORUM_ADDRESS).

Needs to be on a page that is parsed for PHP content, either by way of naming the page '.php', or by using .htaccess to add it to the list of files that are parsed by PHP. [AddType application/x-httpd-php .html]

I've seen lots of requests for this, but couldn't locate anyone that had released one, so here goes (mods, if there is one like this, feel free to remove mine..I couldn't find it). The code was gathered from a number of sources long ago and slapped together by me. I don't know the full origin of each bit, so if you wrote any of this and want credit, go for it. In it's current (unpolished) state, it's been heavily adapted by me anyway, and there's room for improvement, certainly. It's inelegant code (an understatement), but works AFAIK.

[MamboCube]

for my website i use this

<?php  
$host   = 'localhost'; 
$dbUser = 'db_user';   
$dbPass = 'password'; 
$db = 'db_name'; 
mysql_connect("$host", "$dbUser", "$dbPass") or die(mysql_error());
mysql_select_db("$db") or die(mysql_error());

$result = mysql_query("SELECT * FROM vb3_event order by dateline DESC LIMIT 10" ) or die(mysql_error());   
while($row = mysql_fetch_array( $result )) {	
print  "<a href='http://www.DOMAIN.COM/FORUM_ADDRESS/calendar.php?do=getinfo&e=" . $row['eventid'] . "&c=2'>". $row['title'] . "</a><br>" ;
}
?>

this grabs the last events from the database, it does not use global.php

i find this works just as well

[Zilvia]

MamboCube: This actually worked on my CMS site, but it dosent display correctly. Its not in order and it will display old and out of date events. Is there a way to add a date and then order it from latest to oldest and have it remove the old events? I played around with it a bit but couldnt get it to work right with my limited knowledge. Thanks

[MamboCube]

have u put in this bit?:

order by dateline DESC LIMIT 10

because that should grab the last events and only show ten

[rabidkevin]

If you want it to list it with the date, and not show events which have already passed, use this code

<?php  
$host   = 'localhost'; 
$dbUser = 'username';   
$dbPass = 'pass'; 
$db = 'database'; 
mysql_connect("$host", "$dbUser", "$dbPass") or die(mysql_error());
mysql_select_db("$db") or die(mysql_error());

$result = mysql_query("SELECT * FROM vb35_event where dateline_from >= UNIX_TIMESTAMP() order by dateline_from ASC LIMIT 10" ) or die(mysql_error());   
while($row = mysql_fetch_array( $result )) {	
$dateevent = date('M j, Y', $row[dateline_from]);
print  "$dateevent - <a href='http://WWW.DOMAIN.COM/FORUMS/calendar.php?do=getinfo&e=" . $row['eventid'] . "&c=1'>". $row['title'] . "</a><br>" ;
}
?>

[Zilvia]

I have tried both of those options.

dateline dosent display in the correct order nor does dateline_from or to or really any other filds I tried.

[rabidkevin]

works for me... http://www.eternalbeats.net/home2.php
using the code i just pasted

[Zilvia]

Originally Posted by rabidkevin

works for me... http://www.eternalbeats.net/home2.php
using the code i just pasted

Oh man! I read over and swore it was identical to what I had tried and retried many time. This got it working for me! You ROCK!

[rabidkevin]

no prob
if you wanna see it in action use http://www.eternalbeats.net/home.php now, i updated

also if someone could help with code to retrive the custom fields, that would be dope

[helden]

Final workin Code also for 3.6

sorry for my poor english

PHP Code:

<?php  
$host   = 'localhost'; 
$dbUser = 'user';   
$dbPass = 'wort'; 
$db = 'db666'; 
mysql_connect("$host", "$dbUser", "$dbPass") or die(mysql_error());
mysql_select_db("$db") or die(mysql_error());

$result = mysql_query("SELECT * FROM vb3_event where dateline_from >= UNIX_TIMESTAMP() order by dateline_from ASC LIMIT 10" ) or die(mysql_error());   
while($row = mysql_fetch_array( $result )) {    
$dateevent = date('M j, Y', $row[dateline_from]);
print  "$dateevent - <a href='http://www.deinehomepage.com/vbullitin/calendar.php?do=getinfo&e=" . $row['eventid'] . "&c=1'>". $row['title'] . "</a><br>" ;
}
?>

LIMIT 10 say "show 10 dates" and is changebel

[NorthwoodsFella]

I was looking for a way to display the calendar events from a specific calendar on certain sub-forums. I looked and looked and tried dozens of "working code" examples, but could NOT get anything to work properly.

I found the previous example code to be very close, but I kept having problems with the date, so I made a couple of modifications to get it to work the way I wanted.

The following example will display the Calendar ID 3 events if the Forum ID is 3. This is done with two modifcations. A modification to the forumdisplay.php code and a modification to the ForumDisplay Template. I also set the number of event days to 45 because I have it set to '0' in the vb options.

forumdisplay.php

PHP Code:

if ($vbulletin->GPC['forumid'] == 3 )
{

if ($vbulletin->GPC['forumid'] == 3 ) {$calendarid = 3 ;}

$host   = "your_localhost";  
$dbUser = "your_dbuuser";    
$dbPass = "your_dbpass";  
$mydb = "your_db";  

mysql_connect("$host", "$dbUser", "$dbPass") or die(mysql_error()); 
mysql_select_db("$mydb") or die(mysql_error());

$u = TIMENOW;

$vbulletin->options['showevents']=45;

$futuredate = ($vbulletin->options['showevents'] * 86400)+$u;

$result = mysql_query("SELECT * FROM event where (dateline_from+172800) >= UNIX_TIMESTAMP() 
AND dateline_from+86400 < $futuredate 
AND calendarid = $calendarid 
order by dateline_from ASC LIMIT 10" ) or die(mysql_error());    

while($row = mysql_fetch_array( $result )) {     
$dateevent = date('m-d-Y', ($row[dateline_from]+86400)); 
$upcomingevents = "$upcomingevents" . "<a 
href='http://www.yourwebsite.com/calendar.php?do=getinfo&e=$row[eventid]&c=$calendarid'>$row[title]</a>: " . "$dateevent" ."<br>";
} 

} 


I use the same events format as the one used for index.php and have inserted it into the forumdisplay template.


ForumDisplay Template

PHP Code:

<!-- upcoming events -->
<if condition="$vbulletin->GPC['forumid'] == 3">

<table class="tborder" cellpadding="6" cellspacing="1" border="0" width="100%" align="center">
<tbody>
    <tr>
        <td class="thead" colspan="2">
            <a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_events')"><img id="collapseimg_forumhome_events" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_events].gif" alt="" border="0" /></a>
            <if condition="$show['todaysevents']">$vbphrase[todays_events]<else /><phrase 1="$vboptions[showevents]">$vbphrase[upcoming_events_for_the_next_x_days]</phrase></if>
        </td>
    </tr>
</tbody>
<tbody id="collapseobj_forumhome_events" style="$vbcollapse[collapseobj_forumhome_events]">
    <tr>
        <td class="alt2"><a href="calendar.php$session[sessionurl_q]"><img src="$stylevar[imgdir_misc]/calendar.gif" alt="$vbphrase[calendar]" border="0" /></a></td>
        <td class="alt1" width="100%"><div class="smallfont">$upcomingevents</div></td>
    </tr>
</tbody>
</table>
<br>
</if>
<!-- / upcoming events --> 


This modification was installed on a board using 3.6.5.