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)

Quote:

Originally Posted by opelgtman

nevermind, i got it to work

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

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

Quote:

Originally Posted by opelgtman

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

Code:

<!--#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)

Code:

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

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!

Does this work? ornot? THanks!

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?

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:

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");

this is the second line in the file:

Code:

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

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

troy

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

Code:

chdir("forum/");

require('./global.php');  

chdir("../");

(your folder names and paths may be different)

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.

for my website i use this

Code:

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

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

have u put in this bit?:

Code:

order by dateline DESC LIMIT 10

because that should grab the last events and only show ten

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

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>" ;

}

?>

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.

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

Quote:

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!

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

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

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.

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.

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 (3)bbcode_php_printable (3)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 (21)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.01458 seconds Memory Usage 1,837KB 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 (3)bbcode_php_printable (3)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 (21)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: