Calendar events on non-VB pages

[wbear]

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.

[Snake]

<font color="#15a018">* Aftermath clicks on install</font>

[lazyseller]

Warning: chdir(): No such file or directory (errno 2) in /home/xxxx/public_html/indexbackup.php on line 120

Fatal error: Cannot redeclare class vbulletinhook in /home/xxxx/public_html/forums/includes/class_hook.php on line 29

[wbear]

Did you: change the first few lines to reflect your current site information?

[lazyseller]

I see why not its conflicing with the vbexternal addon i am using

<?php
chdir('./forums');
require_once('./vBExternal.php');
?>

is there a way i can use both ?

[SHD Born2Fight]

Nice hack :-)

[LBmtb]

How can I use this in a forum page? I want to display this in the header. I suppose delete the chdir lines and simply have 'global.php'?

I tried that and got this printed out on the page

= UNIX_TIMESTAMP() ORDER BY dateline_from LIMIT 10"); if (()) { echo ""; while ( = ()) { #=,false,true,false,true; = vbdate("M j, Y", ,false,true,false,true); echo " "; } //} } else { echo "
Upcoming Events
(click here for full month)

"; } echo "
Upcoming Events
No Events Upcoming Currently
"; ?>

[silurius]

<font color="#15a018">* silurius subscribes to thread.</font>

[Brandon Sheley]

good hack, I don't need it yet, but i might someday soon

[Dave-G]

Been trying to get this to output only from my Calander 2 without any luck. I've changed the references from 1 to 2 but it just says No events, even though there are. Changing it all back from 2 to 1 and it works.

Anyone get this working with calanderid 2 ?

[Dave-G]

anyone please! this is driving me mad, lol.

[LBmtb]

Does anybody have a screenshot or demo page? I keep getting this error, no matter what I try.
Unable to add cookies, header already sent.
File: /home/myusername/public_html/test.php
Line: 10

[wbear]

Here's a screen shot of the site I made this for. Maybe it'll help you.

[wbear]

Been trying to get this to output only from my Calander 2 without any luck. I've changed the references from 1 to 2 but it just says No events, even though there are. Changing it all back from 2 to 1 and it works.

Anyone get this working with calanderid 2 ?
Just tested with id 2 and it works perfectly. Can you check that calendar 2 has publicly viewable permissions?
You might also make sure that the calendar you're choosing is actually id 2...if you've made more than one in the past it might be a different number.

[wbear]

How can I use this in a forum page? I want to display this in the header. I suppose delete the chdir lines and simply have 'global.php'?

I tried that and got this printed out on the page

= UNIX_TIMESTAMP() ORDER BY dateline_from LIMIT 10"); if (()) { echo ""; while ( = ()) { #=,false,true,false,true; = vbdate("M j, Y", ,false,true,false,true); echo " "; } //} } else { echo "
Upcoming Events
(click here for full month)

"; } echo "
Upcoming Events
No Events Upcoming Currently
"; ?>

As a guess, you left in the starting <? tag, and it's confusing the forum's parsing of the code? Start with the line: $events = $db->query ...and leave off the closing ?> as well. Make sure you're placing it somewhere not inside some other code block..(if , else, or what have you.)

[LBmtb]

As a guess, you left in the starting <? tag, and it's confusing the forum's parsing of the code? Start with the line: $events = $db->query ...and leave off the closing ?> as well. Make sure you're placing it somewhere not inside some other code block..(if , else, or what have you.)
You're right I did leave that there. I'll try it once I get home.

Wbear, thanks a lot of the screenshot - that looks awesome!

edit: Got home and still no luck.
I get a lot of this
$events = $db->query ("SELECT UNIX_TIMESTAMP() AS dateline, dateline_from, eventid, title FROM event WHERE calendarid = 1 AND dateline_from >= UNIX_TIMESTAMP() ORDER BY dateline_from LIMIT 10"); if ($db->num_rows($events)) { echo ""; while ($event = $db->fetch_array($events)) { #$timestring=$event[dateline_from],false,true,false,true; $dateevent= vbdate("M j, Y", $event[dateline_from],false,true,false,true); echo " "; } //} } else { echo "
Upcoming Events
(click here for full month)
$dateevent $event[title]
"; } echo "
Upcoming Events
No Events Upcoming Currently
";
Here's the page code




$events = $db->query ("SELECT UNIX_TIMESTAMP() AS dateline, dateline_from, eventid, title

FROM event

WHERE calendarid = 1 AND dateline_from >= UNIX_TIMESTAMP()



ORDER BY dateline_from LIMIT 10");

if ($db->num_rows($events)) {

echo "<table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"1\">

<tr>

<td COLSPAN=2 align=\"center\" width=\"100%\" bgcolor=\"#FFFFFF\"><font face=\"arial, helvetica\" color=\"000000\"><b><a href='http://www.socaltrailriders.org/forum/calendar.php?c=1&do=displaymonth'>Upcoming Events <br>(click here for full month)</a></b></font></td>

</tr>

";

while ($event = $db->fetch_array($events)) {



#$timestring=$event[dateline_from],false,true,false,true;

$dateevent= vbdate("M j, Y", $event[dateline_from],false,true,false,true);

echo "

<tr>

<td align=\"center\" width=\"80\" bgcolor=\"FFFFFF\"><font size=\"-1\" face=\"arial, helvetica\" color=\"000000\">$dateevent</font></td>

<td align=\"left\" bgcolor=\"FFFFFF\" width=\"183\"><font size=\"-1\" face=\"arial, helvetica\"><b><a href='http://www.socaltrailriders.org/forum/calendar.php?do=getinfo&e=$event[eventid]&c=1'>$event[title]</a></b></font></td>

</tr>

<tr>

<td colspan=\"2\" bgcolor=\"FFFFFF\"></td>

</tr>

";

}

//}

} else {

echo "<table border=\"0\" width=\"100%\" cellpadding=\"0\" cellspacing=\"1\">

<tr>

<td COLSPAN=2 align=\"center\" width=\"100%\" bgcolor=\"#FFFFFF\"><font class=\"heading\" face=\"arial, helvetica\" size=\"1\" color=\"000000\"><b><a href='http://www.socaltrailriders.org/forum/calendar.php?c=1&do=displaymonth'>Upcoming Events</a></b></font></td>

</tr>

<tr>

<td COLSPAN=2 align=\"center\" width=\"100%\" bgcolor=\"#FFFFFF\"><font size=\"-1\" face=\"arial, helvetica\" color=\"000000\"><b>No Events Upcoming Currently</b></font></td>

</tr>

<tr>

<td colspan=\"2\" bgcolor=\"FFFFFF\"></td>

</tr> ";

}

echo "</table>";
Here's the link (http://socaltrailriders.org/test.php).

$10 bucks to whoever helps me get this working. Wbear, what version of vBulletin are you using? I installed event forums mod btw, not sure if that matters.

Thanks!

[Dave-G]

Just tested with id 2 and it works perfectly. Can you check that calendar 2 has publicly viewable permissions?
You might also make sure that the calendar you're choosing is actually id 2...if you've made more than one in the past it might be a different number.

Still driving me mad. Checked the database and it is ID2, checked the permissions and they are all identical to ID1. Even if they were not, login in as admin I still should see all.

The links to ID2 work just not the top code to display the events

WHERE calendarid = 2 AND dateline_from >= UNIX_TIMESTAMP()

If its 1 it works, 2 it does not... Now I'm lost -- HELP please

[wbear]

Here's the link (http://socaltrailriders.org/test.php).
$10 bucks to whoever helps me get this working. Wbear, what version of vBulletin are you using? I installed event forums mod btw, not sure if that matters.
On that test page, you don't have the opening and closing PHP tags. In order for PHP to parse it, that has to be there...I thought you were trying this on a forum page, and that was why I'd suggested removing them. Sorry.

Include the entire script on the test page (with <? and ?>, and change the paths in the top to your site.
chdir("forum/");
require('./global.php');
chdir("../");
This switches to the forum directory, grabs the config file and switches back. Make sure the closing PHP tag is present as well.

I'm using 3.5.2 on this, but had it working (with a small change) on 3.07/8.

[wbear]

Still driving me mad. Checked the database and it is ID2, checked the permissions and they are all identical to ID1. Even if they were not, login in as admin I still should see all.

The links to ID2 work just not the top code to display the events

WHERE calendarid = 2 AND dateline_from >= UNIX_TIMESTAMP()

If its 1 it works, 2 it does not... Now I'm lost -- HELP please

Can you provide the link to the board in question? The basic board link would do, if guests can view both calendars. A link to the test page may help too. PM if you don't want this public.

[LBmtb]

On that test page, you don't have the opening and closing PHP tags. In order for PHP to parse it, that has to be there...I thought you were trying this on a forum page, and that was why I'd suggested removing them. Sorry.

Include the entire script on the test page (with <? and ?>, and change the paths in the top to your site.
chdir("forum/");
require('./global.php');
chdir("../");
This switches to the forum directory, grabs the config file and switches back. Make sure the closing PHP tag is present as well.

I'm using 3.5.2 on this, but had it working (with a small change) on 3.07/8.
Thanks for your time. I added chdir("forum/");
require('./global.php');
chdir("../"); and <? at the beginning and ?> at the end but got a databse error message. The email I received said a table that it's looking for doesn't exist.

Invalid SQL:
SELECT UNIX_TIMESTAMP() AS dateline, dateline_from, eventid, title
FROM event
WHERE calendarid = 1 AND dateline_from >= UNIX_TIMESTAMP()

ORDER BY dateline_from LIMIT 10;

MySQL Error : Table 'socaltra_vbforum.event' doesn't exist
Error Number : 1146
Date : Wednesday, January 25th 2006 @ 02:14:42 PM
Script : http://socaltrailriders.org/test.php
Referrer :
IP Address : 134.139.107.72
Username : Unregistered
Classname : vb_database

[Dave-G]

LBmtb, have you tried moving the test.php file into the forum directory. remembering to change
chdir("forum/"); to chdir("../forum/");

[LBmtb]

Same error.

[Dave-G]

wbear disregard PM, were using an external Calendar now, saves the problems.

[wbear]

wbear disregard PM, were using an external Calendar now, saves the problems.
Lol...wish I'd read this before the PM...
Disregard my forum signup, would you? Details in the PM.

[LBmtb]

I got it working!

This line $events = $db->query ("SELECT UNIX_TIMESTAMP() AS dateline, dateline_from, eventid, title

FROM event

WHERE calendarid = 1 AND dateline_from >= UNIX_TIMESTAMP()
Looked at the wrong table because it didn't include the prefix to the table. So I merely added the prefix to the event table and changed the calenderid to the calender I wanted.
$events = $db->query ("SELECT UNIX_TIMESTAMP() AS dateline, dateline_from, eventid, title

FROM vb_event

WHERE calendarid = 2 AND dateline_from >= UNIX_TIMESTAMP()
and it worked. Here's the link to the test page (http://socaltrailriders.org/test2.php)

[wbear]

Good for you, LBmtb! Enjoy it...

[Pouyan]

Does this work with recurring events also?

[RobAC]

Has anyone tested this out in a .html file instead of PHP and if using a .htaccess file to parse PHP code in a .html file as suggested in the first post in this thread, does that cause any additional server load?

[andreamarucci]

This is one step ahead regarding my dream. To have also a minicalendar show up in non-vb pages. I'm talking about the mini calendar that is shown in the bottom of the calendar page. Do you think it's possible to have it in a non-vb page as well?

[Freesteyelz]

I'm currently trying to get this working on the forum home (without) having the use of Frames or iframes. Anyone has achieved it?

[fkatzenb]

Awesome work. I pushed thru some of the bugs and used it on my CMPS.... however I have some problems.... what can I do to fix it?
http://www.turbo-mopar.com/forums/cmps_index.php?page=events


Frank

[fkatzenb]

Anyone ^^^^^^^^^^^^^^^^

[noonespecial]

changing the "require" to:

require_once('./global.php');

Fixed the weird errors I had.

Great code, really going to help out on a function of my website.

[rabidkevin]

I get this error if I open a fresh browser

Unable to add cookies, header already sent.
File: /home/eternalb/public_html/home.php
Line: 20


If i go to the forum, then back to home.php, the calendar works.
It will continue to work until I close the browser window.

How can I resolve this?

http://www.eternalbeats.net/home2.php

[phifou]

It runs nice for me ... except that I don't get the event date, it only prints "M j, Y"

[noonespecial]

Also, this shows events that are not approved by a moderator yet; anyone know how to fix that?

[dtdesign]

Is there anyway to group the events by month so that you can list them like say

April
event 1
event 2

June
event 3

[Gizmo999]

I get this error if I open a fresh browser

Unable to add cookies, header already sent.
File: /home/eternalb/public_html/home.php
Line: 20


If i go to the forum, then back to home.php, the calendar works.
It will continue to work until I close the browser window.

How can I resolve this?

http://www.eternalbeats.net/home2.php

I've got the same error, it seems like you need to be logged into the forum to get it to display which is useless for what I want. is there a line in the php code that sends a cookie or any way to get it to work????

[opelgtman]

I've got the same error, it seems like you need to be logged into the forum to get it to display which is useless for what I want. is there a line in the php code that sends a cookie or any way to get it to work????

Does anyone have the answer to this error?

[opelgtman]

nevermind, i got it to work

[Gizmo999]

nevermind, i got it to work


How please?? it'll save me lots of time updating my website home if this works

[opelgtman]

make the file on here its own php page, then on your main page use a php include statement and it works fine

[rastyx]

make the file on here its own php page, then on your main page use a php include statement and it works fine

I've got the same problem ("Unable to add cookies, header already sent"), but only sometimes:

If my page is .shtml and include the hack as a server-side include

<!--#include virtual="/community_events.php" -->
<!-- this is the calendar_on_nonvb.txt file -->

ie http://www.tear.org.au/index-new.shtml

then the code works.

If my page is php and I use a php include it doesn't:
http://www.tear.org.au/index-new.php

I get an error relating to line 6 which is the first line after <title>...</title>. I can move this line, or change it (in index-new.php) but I still get the error referring to the whatever line of code comes after the html <title> tags.

I've found the line in vBulletin's includes/functions.php (line 1607)

eval(standard_error(fetch_error('cant_set_cookies' , $filename, $linenum)));

which calls the error message we're getting, but it is beyond me what is triggering it or how to fix it.

Any help appreciated. I really don't want to change my index page back to .shtml. I've probably got 1000 pages linked to it as index.php

[CocteauBoy]

Hi!

I am so happy with this, but I've noticed a problem recently. For some reason, only one of my entries consistently gets translated as being a day LATER in the calender feed. I have deleted and re-entered it over and over and it still feeds as one day later. It's strange, because it is only that one event, no matter what date I post it.

Note: DST is in effect for both vBullletin and Subdreamer. Keep in mind that other events are not affected, for some reason.

Any suggestions as to what to fix?

Thanks!

Troy

PS otherwise, WONDERFUL hack here!

[MissKalunji]

Does this work? ornot? THanks!

[MamboCube]

i get this error

Fatal error: Call to a member function on a non-object in /home/****/public_html/forum/global.php on line 235

any ideas?

[MamboCube]

anyone know how to fix this error:

Fatal error: Call to a member function on a non-object in /home/****/public_html/includes/calendar.txt on line 2

this thing is really bugging me now

can anyone help?

--------------------------------------------------------
this is a block of code i have at the top of calendar.txt:

$events = $db->query ("SELECT UNIX_TIMESTAMP() AS dateline, dateline_from, eventid, title
FROM event
WHERE calendarid = 1 AND dateline_from >= UNIX_TIMESTAMP()

ORDER BY dateline_from LIMIT 10");

this is the second line in the file:
$events = $db->query ("SELECT UNIX_TIMESTAMP() AS dateline, dateline_from, eventid, title

[CocteauBoy]

I guess no one is around to support this thread anymore? Too bad. This is a great mod.

troy

[wbear]

If you note the details above, it's unsupported. I didn't write this, but pulled a few similar bits of code I found to get it working for me and thought I'd share.

@MamboCube, do you have the rest of the code that allows it to connect to the VB database in that page as well? The code you gave is the same as mine, but it's missing the calls to VB...
chdir("forum/");
require('./global.php');
chdir("../");
(your folder names and paths may be different)

[CocteauBoy]

Okay, after hours upon hours of trying to get this to work, it just isn't going to happen.

For those considering using this, my experience has been this:

1. the formatting for the layout is awful and very tedious to alter
2. some events are fed to your non-vb page as being one full day ahead of its actual schedule (I have no idea why or how this happens to only certain events)
3. Recurring events are not fed to your non-vb page

For me, it has been a waste of time.

**clicks uninstall**

Very unfortunate... we really need something like this.

[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]

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
$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

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

<!-- 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.

[FCS-Webmaster]

Maybe someone read this and could help me out
I tred this script bu it seems to be he doesn`t interpret UNIX_TIMESTAMP()
It only shows me upcoming dates 1 day ahead.