vb.org Archive - View Single Post - Show Events on non-vb page

Rebecca217 · #49 11-17-2004, 02:39 PM

I'm using 3.0.3 also, and needed this same thing. The above code didn't work for me as-is, so I tweaked it a bit until I got what I needed. I don't claim to be a programmer, so use this at your own risk.

Alter this to point to your own Vb installation, then paste it above everything else in your page. (Before the <html> tag, etc.)

PHP Code:


			
<?php 



// Require global.php



chdir ('forums');



require ("global.php");



?>

Paste this where you'd like the events to appear. Alter the $day format to your preferences. Also, the LIMIT variable can be changed to however many entries you'd like listed.

PHP Code:


			


<?php



print "<ul>";



$events = $DB_site->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 3"); 



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



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



$timestring=$event['dateline_from'] += 86400; 



$dateevent=date("F d, Y",$timestring); 



$day=date("Y-m-d",$timestring);



echo "<LI><B>$dateevent</b> - <a href="/\"/forums/calendar.php?$session[sessionurl]do=getinfo&amp;day=$day&amp;e=$event[eventid]&amp;c=1\">$event[title]</a></li>"; 



} 



} else { 



echo $vh_upcomingevents .= " -- no events currently listed -- "; 



} 



print '<LI><B><a href="./forums/calendar.php">view other events</a> &raquo;</b></li>';



print "</ul>";



?>

Hope this helps!

Rebecca

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01634 seconds Memory Usage 1,781KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: