vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Calendar events on non-VB pages (https://vborg.vbsupport.ru/showthread.php?t=105215)

wbear 01-12-2006 10:00 PM

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.

Snake 01-13-2006 04:28 PM

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

lazyseller 01-14-2006 06:45 PM

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 01-14-2006 09:13 PM

Did you:
Quote:

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

lazyseller 01-14-2006 09:25 PM

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 01-16-2006 12:18 PM

Nice hack :-)

LBmtb 01-21-2006 09:15 PM

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
Code:

= 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 01-21-2006 11:22 PM

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

Brandon Sheley 01-21-2006 11:49 PM

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

Dave-G 01-22-2006 09:52 AM

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 01-23-2006 04:48 PM

anyone please! this is driving me mad, lol.

LBmtb 01-24-2006 05:40 AM

Does anybody have a screenshot or demo page? I keep getting this error, no matter what I try.
Code:

Unable to add cookies, header already sent.
File: /home/myusername/public_html/test.php
Line: 10


wbear 01-24-2006 11:41 PM

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

wbear 01-24-2006 11:49 PM

Quote:

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 01-24-2006 11:59 PM

Quote:

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
Code:

= 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 01-25-2006 12:43 AM

Quote:

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
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 ""; 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
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 01-25-2006 11:36 AM

Quote:

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

Code:

WHERE calendarid = 2 AND dateline_from >= UNIX_TIMESTAMP()
If its 1 it works, 2 it does not... Now I'm lost -- HELP please

wbear 01-25-2006 12:06 PM

Quote:

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 01-25-2006 12:08 PM

Quote:

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

Code:

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 01-25-2006 05:24 PM

Quote:

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
Code:

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.
Code:

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 01-25-2006 07:16 PM

LBmtb, have you tried moving the test.php file into the forum directory. remembering to change
Code:

chdir("forum/");
to
Code:

chdir("../forum/");

LBmtb 01-25-2006 07:28 PM

Same error.

Dave-G 01-25-2006 09:21 PM

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

wbear 01-25-2006 10:14 PM

Quote:

Originally Posted by Dave-G
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 01-26-2006 01:04 AM

I got it working!

This line
Code:

$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.
Code:

$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

wbear 01-26-2006 01:19 AM

Good for you, LBmtb! Enjoy it...

Pouyan 01-29-2006 06:23 AM

Does this work with recurring events also?

RobAC 01-30-2006 01:10 PM

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 01-31-2006 07:30 AM

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 02-09-2006 02:27 AM

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 02-09-2006 02:35 PM

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/cm...hp?page=events


Frank

fkatzenb 02-10-2006 12:48 PM

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

noonespecial 02-24-2006 06:23 PM

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 02-25-2006 07:26 AM

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 02-27-2006 07:33 PM

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

noonespecial 03-21-2006 12:28 AM

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

dtdesign 03-29-2006 11:12 AM

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 03-31-2006 06:05 PM

Quote:

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

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 04-08-2006 02:30 PM

Quote:

Originally Posted by Gizmo999
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 04-08-2006 08:29 PM

nevermind, i got it to work


All times are GMT. The time now is 05:52 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01421 seconds
  • Memory Usage 1,848KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (13)bbcode_code_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete