Calander on non-VB pages

[Curll]

I'm looking for a hack or a PHP script that can put today's events from the calander on a non-vB page, namely my site's main page. Maybe something cute in a Calander square looking dealy.

Thanks

[Pseudomizer]

Originally Posted by Curll

I'm looking for a hack or a PHP script that can put today's events from the calander on a non-vB page, namely my site's main page. Maybe something cute in a Calander square looking dealy.

Thanks

Hi Curl,

please use the following code to get the last 5 events in an array:

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))
        {

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

    $fromdate = getdate(TIMENOW + (-12 - $serveroffset) * 3600);
    $new_date = date('d-m-Y', TIMENOW + (-12 - $serveroffset) * 3600 );
 
             echo $new_date," ";
//             echo $ev['userid']," ";
//             echo $ev['dateline']," ";
             echo $ev['title'],"<BR>";
        }
} 


Cheers,

[Curll]

Yay, thanks. That's a good start.

[Pseudomizer]

Originally Posted by Curll

Yay, thanks. That's a good start.

Hi Curl,

sorry but i just found one mistake. The dateline will never change in my previous code. Please use the following code:

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


[P.Jackson]

what would be the code to get total threads and how many users online?

[Pseudomizer]

Originally Posted by P.Jackson

what would be the code to get total threads and how many users online?

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,

[P.Jackson]

didnt work got parse errors

[Pseudomizer]

Originally Posted by P.Jackson

didnt work got parse errors

What didn't work ? What kind of errors do you get ? Sorry but without any information i will not be able to help you at all.

Cheers,

[Curll]

Odd, with the new code, no events are showing.

[Pseudomizer]

Originally Posted by Curll

Odd, with the new code, no events are showing.

I bet you did not write :tired:

PHP Code:

echo news; 


Cheers,