Show Events on non-vb page

[gopherhockey]

Originally Posted by offlead

I still need some help with this. I managed to finally get it posting only upcoming events, and not events which have already past. However, now I'm getting the wrong dates displaying on the events. If an event is in the calendar for Feb 30, it displays on the non-vb page as being on Feb 29. All events are dated one day early.

Here's what I currently have.

PHP Code:

 <?php
 chdir("/home/vettehea/public_html/forums");
 
 include('./global.php');
   
 $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 10"); 
 $vh_upcomingevents = "";
 if ($DB_site->num_rows($events)) {
     while ($event = $DB_site->fetch_array($events)) {
         $timestring=$event['dateline_from'];
         $dateevent=date("M j, Y",$timestring);
         $vh_upcomingevents .= "$dateevent: <a href=\"/forums/calendar.php?$session[sessionurl]do=getinfo&amp;day=$day&amp;e=$event[eventid]&amp;c=$event[calendarid]\">$event[title]</a><br />";
     }
 } else {
     $vh_upcomingevents .=  " -- no events currently listed -- ";
 }
 
 ?>

I'd greatly appreciate any help clearing up this last issue to this for me.

I used your code and it works for me, plus the dates are all just fine. It isn't picking up all the events, however.. don't know why some are just missing. Could it be a timezone issue with your server maybe? (just grasping for straws) - maybe you could compensate by adding or subtracting one day... ?

One thing I have a problem with is how far out its reaching. It gets the next X number of events, regardless of the dates. I'd like to only display X number of events X days ahead. Currently my test board has 2 events next week and one Oct. of this year and its showing that one.... thats a bit too far out to be reminding people I think

[magmaink]

Anyone Get any updates on this.. V3 is 1 day off still??

[magmaink]

anyone?

[magmaink]

need this bad....somebody please respond!

[magmaink]

no love?

[user 1-2-3]

How can I make the same thing for 3.0.1? I need to place events from calendar into the home page.

[magmaink]

Alright dammit....I am completely clueless in regards to php but I still managed to figure this one out. on the timestring code......you have to add "+= 86400" in order to compensate for the missing 24 hours.....Here's my code:

PHP Code:

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

if ($DB_site->num_rows($events)) {
    while ($event = $DB_site->fetch_array($events)) {
        $timestring=$event['dateline_from'] += 86400;
        $dateevent=date("m-d-Y",$timestring);
        echo "$dateevent <a href=\"/vb/calendar.php?$session[sessionurl]do=getinfo&amp;day=$day&amp;e=$event[eventid]&amp;c=$event[calendarid]\">$event[title]</a><br />";
    }
} else {
    echo $vh_upcomingevents .=  " -- no events currently listed -- ";
    } 


[traderx]

Originally Posted by magmaink

Alright dammit....I am completely clueless in regards to php but I still managed to figure this one out. on the timestring code......you have to add "+= 86400" in order to compensate for the missing 24 hours.....Here's my code:

PHP Code:

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

if ($DB_site->num_rows($events)) {
    while ($event = $DB_site->fetch_array($events)) {
        $timestring=$event['dateline_from'] += 86400;
        $dateevent=date("m-d-Y",$timestring);
        echo "$dateevent <a href=\"/vb/calendar.php?$session[sessionurl]do=getinfo&amp;day=$day&amp;e=$event[eventid]&amp;c=$event[calendarid]\">$event[title]</a><br />";
    }
} else {
    echo $vh_upcomingevents .=  " -- no events currently listed -- ";
    } 


Will the above work for 3.0.3? I am also looking for something to get the last X threads and polls.... any one?

Coll

[Rebecca217]

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

[traderx]

I will give that a try very soon.... Thanks

I went to your site (nice) and saw that you are pulling the lastest threads also, could you point me to the post about that or pm it to me pls

Thanks
Coll