Calander on non-VB pages

[Curll]

echo $news; you mean?

Now, anyway I could make those link to the expanded info on the Calander pages?

[Pseudomizer]

Originally Posted by Curll

echo $news; you mean?

Now, anyway I could make those link to the expanded info on the Calander pages?

Sure. Link to the calendarid and that's it.

Cheers,

[Curll]

That was a wee bit vague...or very vague.

PHP Code:

echo "<a href=\"calendar.php?$calendarid\">$news</a>"; 


Obviously isn't going to work.

So, exactly how should I link to the Calendarid?

[Pseudomizer]

Try this one:

PHP Code:

$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'], false, false); 
             $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>";
              
        } 
} 


Cheers,

[Richardg]

Hey Pseudomizer..maybe you can help me!

I'm trying to add events from an external calendar.

I've inserted rows with the start date in the dateline_from column & the end date in dateline_to column. I've converted my dates & times using the UNIX_TIMSTAMP
I'm not sure what goes in the dateline or UTC columns
I'm running into trouble with timezone offsets (!)...which may be something to do with the dateline & UTC columns...
I am in BST timezone (British Summer Time).
The event I inserted from my external calendar shows up in he vBulletin calendar but it says it was posted for GMT.
What I want to do is to insert events which always show up correctly for my local time (GTM/BST) even if a) the event spans the point at which local time changes from BST to GMT and b) I insert now (BST) an event which will take place when daylight saving ends and we change to GMT.
cheers

[Pseudomizer]

Originally Posted by Richardg

Hey Pseudomizer..maybe you can help me!

I'm trying to add events from an external calendar.

I've inserted rows with the start date in the dateline_from column & the end date in dateline_to column. I've converted my dates & times using the UNIX_TIMSTAMP
I'm not sure what goes in the dateline or UTC columns
I'm running into trouble with timezone offsets (!)...which may be something to do with the dateline & UTC columns...
I am in BST timezone (British Summer Time).
The event I inserted from my external calendar shows up in he vBulletin calendar but it says it was posted for GMT.
What I want to do is to insert events which always show up correctly for my local time (GTM/BST) even if a) the event spans the point at which local time changes from BST to GMT and b) I insert now (BST) an event which will take place when daylight saving ends and we change to GMT.
cheers

Hi Richard,

i have never done such a thing before but i can give you some guidance in which direction you should look to find the error. When you post something or you create a thread in all php files they are using the same function. Please have a closer look into this section:

PHP Code:

    $serveroffset = date('Z', TIMENOW) / 3600; 

    $fromdate = getdate(TIMENOW + (-12 - $serveroffset) * 3600); 
    $new_date = date('d-m-Y', TIMENOW + (-12 - $serveroffset) * 3600 ); 


In addition i would suggest that you look into the calendar_functions.php in your /includes directory.

Hope this helps.

Cheers,

[Curll]

Hmm, I fooled around with it to get it to work, or at least link correctly (for my site and my settings.)

PHP Code:

echo "<hr><b><a href=\"http://www.xblgamers.com/forums/calendar.php?\">Latest Events</a> . . .</b><b><p>";




$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)) 
        { 
            
            $new_date = vbdate('m.d.Y', $ev['dateline'], false, false); 
            $link_date = vbdate('Y-m-d', $ev['dateline'], false, false); 
             $news .= "<b>".$new_date."</b>"."<BR>"; 
             $news .= "</b>".$ev['title']."<BR>"; 
              
        } 
} 

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


But, the array, all 5 items, link to one day, the day of the last item. Sooo, how could we put in a check thingy to get a link to each event?

[Pseudomizer]

Originally Posted by Curll

Hmm, I fooled around with it to get it to work, or at least link correctly (for my site and my settings.)

PHP Code:

echo "<hr><b><a href=\"http://www.xblgamers.com/forums/calendar.php?\">Latest Events</a> . . .</b><b><p>";




$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)) 
        { 
            
            $new_date = vbdate('m.d.Y', $ev['dateline'], false, false); 
            $link_date = vbdate('Y-m-d', $ev['dateline'], false, false); 
             $news .= "<b>".$new_date."</b>"."<BR>"; 
             $news .= "</b>".$ev['title']."<BR>"; 
              
        } 
} 

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


But, the array, all 5 items, link to one day, the day of the last item. Sooo, how could we put in a check thingy to get a link to each event?

This is very easy to answer. If you look at my original post you will see that i did put the echo with the link IN THE if and while loop. You placed it outside. Just have a look at my original code.

Cheers,

[Curll]

Yeah...but....looking is hard :'(

[Pseudomizer]

Originally Posted by Curll

Yeah...but....looking is hard :'(

Sorry, i did not get this. Does it work now ? Or is something else wrong now ?

Cheers,