Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-24-2004, 04:51 PM
Caster Caster is offline
 
Join Date: Jul 2004
Location: Cali
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Calendar Events on Non-vB Pages

Hey everyone, I'm having a little trouble with a script posted on this forum. Basically I just want show 1 calendar event (the script was to show 5) and jsut the title of the event and a link to it in the calendar page. Here is the code:

(sorry I forgot who posted it)

PHP Code:
<?php BEGIN__VBULLETIN__CODE__SNIPPET 

$events 
$DB_site->query("select * from event order by dateline DESC limit 5"); 

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

        while (
$ev $DB_site->fetch_array($events)) 
        { 
             
$news=""
             
$new_date vbdate('Y.m.d'$ev['dateline'], falsefalse); 
             
$news .= "<B>".$new_date."</B><BR>"
             
$news .= $ev['title']."<BR>"

echo 
"<A HREF=\"calendar.php?do=getinfo&e=$ev[eventid]&day=$new_date&c=1\">$news</A>"
               
        } 



?>
I'm having a little trouble trying to understand the script, what exactly is "BEGIN__VBULLETIN__CODE__SNIPPET" and to make the script work, I would have to select event, title, eventid, and dateline right?
Reply With Quote
  #2  
Old 07-24-2004, 05:03 PM
Dark_Wizard Dark_Wizard is offline
 
Join Date: Nov 2001
Location: North Carolina
Posts: 1,251
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Caster
Hey everyone, I'm having a little trouble with a script posted on this forum. Basically I just want show 1 calendar event (the script was to show 5) and jsut the title of the event and a link to it in the calendar page. Here is the code:

(sorry I forgot who posted it)

PHP Code:
<?php BEGIN__VBULLETIN__CODE__SNIPPET 

$events 
$DB_site->query("select * from event order by dateline DESC limit 5"); 

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

        while (
$ev $DB_site->fetch_array($events)) 
        { 
             
$news=""
             
$new_date vbdate('Y.m.d'$ev['dateline'], falsefalse); 
             
$news .= "<B>".$new_date."</B><BR>"
             
$news .= $ev['title']."<BR>"

echo 
"<A HREF=\"calendar.php?do=getinfo&e=$ev[eventid]&day=$new_date&c=1\">$news</A>"
               
        } 



?>
I'm having a little trouble trying to understand the script, what exactly is "BEGIN__VBULLETIN__CODE__SNIPPET" and to make the script work, I would have to select event, title, eventid, and dateline right?
Change this:
PHP Code:
limit 5 
to this:
PHP Code:
limit 1 
and disregard the "BEGIN__VBULLETIN__CODE__SNIPPET" as it's not needed.

And to just show the title...

change this:
PHP Code:
            $news=""
             
$new_date vbdate('Y.m.d'$ev['dateline'], falsefalse); 
             
$news .= "<B>".$new_date."</B><BR>"
             
$news .= $ev['title']."<BR>"
to this:
PHP Code:
              $news $ev['title']; 
Reply With Quote
  #3  
Old 07-24-2004, 05:10 PM
Caster Caster is offline
 
Join Date: Jul 2004
Location: Cali
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That was quick lol...

Thank you so much, going to try it out right now

Ok well I tried it out, and changed the script so it looks like...

PHP Code:
<?
$connection = mysql_connect("localhost", "dbusername", "dbpass") or die("err");

mysql_select_db("db",$connection) or die ("err2");

$events = $DB_site->query("select * from event order by dateline DESC limit 1"); 

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

        while ($ev = $DB_site->fetch_array($events)) 
        { 
        $news = $ev['title']; 

echo "<A HREF=\"calendar.php?do=getinfo&e=$ev[eventid]&day=$new_date&c=1\">$news</A>"; 
               
        } 



?>
"Fatal error: Call to a member function on a non-object in /home/socalbi/public_html/bikenights.php on line 6"

Whats that mean?
Reply With Quote
  #4  
Old 07-24-2004, 06:14 PM
Dark_Wizard Dark_Wizard is offline
 
Join Date: Nov 2001
Location: North Carolina
Posts: 1,251
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Use this:

PHP Code:
<?php

// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('NO_REGISTER_GLOBALS'1);

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');

$events $DB_site->query("SELECT * FROM event ORDER BY dateline DESC LIMIT 1"); 

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

        while (
$ev $DB_site->fetch_array($events)) 
        { 
        
$news $ev['title']; 

echo 
"<A HREF=\"calendar.php?do=getinfo&e=$ev[eventid]&day=$new_date&c=1\">$news</A>"
                
        } 



?>
Reply With Quote
  #5  
Old 07-24-2004, 06:25 PM
Caster Caster is offline
 
Join Date: Jul 2004
Location: Cali
Posts: 11
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks, but I'm still having a problem (its the php include problem) on my site, I put the script (bikenights.php) in my forums folder, (so I don't have to edit the script) and when I use <?php include('/forums/bikenight.php'); ?> it says:

"Warning: main(/forums/bikenights.php): failed to open stream: No such file or directory in /home/socalbi/public_html/index2.php on line 111"

Forgive me for being a noob, but php/mysql is just not my thing ><
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:11 AM.


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.06016 seconds
  • Memory Usage 2,238KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (8)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete