Calander on non-VB pages

[upnorth]

Sorry My bad. Got so excited when I read the posts I didn't read the subject close enough. I'll give it a try and see if I can get it to work.

Sorry for that :nervous:

[upnorth]

k hopefully I haven't overlooked anything so please be patient with me as this is all new to me.

I tried your code and it works fine. How hard would it be to only show todays events and the next 3 or 4 days. Make sense?

[WildEye]

Originally Posted by Pseudomizer

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,

I've been trying to get this to work now, as posted in #18, but i'm getting an error message:

Fatal error: Call to a member function on a non-object in /home/n4f/html/calendarexport.php on line 3

What am i doing wrong? Not very familiar with what to do... Shouldn't my databasename be somewhere? or... Any help appreciated.

PHP Code:

echo "<hr><b><a href=\"http://www.mysite.com/forum/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=\"/forum/calendar.php?do=getinfo$ev[eventid]&day=$link_date&c=1\">$news</A>"; 


[Pseudomizer]

Originally Posted by WildEye

I've been trying to get this to work now, as posted in #18, but i'm getting an error message:

Fatal error: Call to a member function on a non-object in /home/n4f/html/calendarexport.php on line 3

What am i doing wrong? Not very familiar with what to do... Shouldn't my databasename be somewhere? or... Any help appreciated.

PHP Code:

echo "<hr><b><a href=\"http://www.mysite.com/forum/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=\"/forum/calendar.php?do=getinfo$ev[eventid]&day=$link_date&c=1\">$news</A>"; 


Hi,

the DBsite command is using the SQL PHP class from VBulletin. If you have included the global.php you should not have the problems you have. Keep in mind that you have to change the directory to include the global.php if you are not in your forum home directory.

Cheers,

[smdani]

I used the information on this post and it worked like a charm for me!
THANKS A LOT.

On showing users online code:

WHERE session.lastactivity > $online[datecut]

I cant found $online variable.
Which file must I include in order to work?

And, how can I show the total numer of users online?

Here another question:
Maybe this is not the correct thread, but I think you can help me because it is a very similar problem.
I would like to show TODAY BIRTHDAY's on a non-vb page.
What I dontknow how to do is to compare today date DATE(now), with users.birthday_search and find thos users whose celebrate their birthday.
Any help?

Thanks in advance.

Originally Posted by Pseudomizer

Users online:

PHP Code:

$onlineusers = $DB_site->query("
                        ## GET ONLINE USERS ##
                        SELECT user.username, (user.options & $_USEROPTIONS[invisible]) AS invisible,
                        user.usergroupid, session.userid, session.lastactivity,
                        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
                        FROM ".TABLE_PREFIX."session AS session
                        LEFT JOIN ".TABLE_PREFIX."user AS user ON (user.userid = session.userid)
                        WHERE session.lastactivity > $online[datecut]
                        ORDER BY ".iif($permissions['genericpermissions'] & CANSEEHIDDEN, 'invisible ASC, ')."username ASC"); 


Total Threads:

PHP Code:

$totalthreads = $DB_site->query("Select count(threadid) from thread where visible = '1' ); 


Cheers,