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.

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

Originally Posted by 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 ?

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]

Originally Posted by 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
"; ?>

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]

Originally Posted by wbear

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.

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

Originally Posted by wbear

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]

Originally Posted by LBmtb

Here's the link.
$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]

Originally Posted by Dave-G

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]

Originally Posted by wbear

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