Show Events on non-vb page

[Daderin]

Could you let us know how you solved that problem Webmasta please ? I remember getting the same errors when I was trying something and I gave up after it

[Clegg]

I am not a programmer or anything cool like that. I am a geek who just knew how to read a SQL DB and get this thing working under vB3

So here is the code: (EDIT - Corrected a major error in the code date setup due to vb3)

PHP Code:

$events = $DB_site->query ("SELECT UNIX_TIMESTAMP() AS dateline, dateline_from, eventid, title 
                           FROM event
                           WHERE calendarid = 1 AND dateline_from > dateline
                           ORDER BY dateline_from LIMIT 4"); 


dateline_from is the vb3 variable for the starting date of the event, and am defining the field dateline for the current date and getting a unix timestamp to so the comparison in the where is more reliable ( had some issue with YYYY-DD-MM formats). Then later with a string like this:

PHP Code:

$timestring=$event['dateline_from']; 
$dateevent=date("M j,Y",$timestring); 


I convert the dateline_from into a readable format.


works like a freaking charm

[roxics]

Is there anyway to get this to show up easily on any VB (really a webtemplates) page via an $events tag or something?

Thanks

[offlead]

Okay, does anyone have the full code for this for vb3, that they could share? I've managed to get, well, something, pulling into the non-forum page, and I have it linking to the calendar, but I'm only getting one event, and the link isn't quite correct (it links to the calendar okay, but not to the event). I'm all confused.

[filmhobbit]

Right so this doesn't work even a little or is just to complex for me to understand. Probably both.

[filmhobbit]

ah there it goes! kicked in with some tinkering. Nice little script guys! Good work.

[krit]

Hi guys.

I too would love someone to simply post the php coding they are using for vB3. I presume most are creating a file, say eventlist.php, and calling it into their page via include statements? If someone could post the code in the php file that would be appreciated greatly!

Cheers
Krit

[offlead]

I actually managed to get this working, eventually, but just discovered that it's showing old events that are already past. Eep! I've checked over the code, and it looks like it should be working correctly, but I'm definitely getting old events.

I checked the sql query in phpmyadmin, and I get the same results. The query is:

SELECT UNIX_TIMESTAMP( ) AS dateline, dateline_from, eventid, title
FROM event
WHERE calendarid = 1 AND dateline_from > dateline
ORDER BY dateline_from
LIMIT 5

and in phpmyadmin when I run this I get the same events as I do in the script. Here are the dateline and dateline_from values from the five events returned:

dateline   	      dateline_from   	  eventid   	  title
1075968522 	1074603600 	    1 	               Hernando Beach Blast III
1075968522 	1074704400 	    3 	               HBBIII 2004
1075968522 	1077840000 	    11 	              Hinkster's Birthday
1075968522 	1082246400 	    12 	              Michigan NCRS Swap Meet
1075968522 	1083283200           7  	       New England Chapter Event

I can see that the dateline value being returned appears correct...it's the same for each row returned. But event 1 and event 3 were in January, and clearly their dateline_from values are less than the dateline values. So why are they being returned?

*confused*

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

[offlead]

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.

*bump*

Anyone?