vb.org Archive - Calendar events on non-VB pages

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)

anyone please! this is driving me mad, lol.

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

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

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.

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

Quote:

Originally Posted by wbear

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!

Quote:

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

Code:

WHERE calendarid = 2 AND dateline_from >= UNIX_TIMESTAMP()

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

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.

Quote:

Originally Posted by Dave-G

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.

Quote:

Originally Posted by wbear

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

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (8)bbcode_code_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01279 seconds Memory Usage 1,762KB 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 (8)bbcode_code_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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
Messages: