How to connect to a vB database & sessions

[NTLDR]

All the code to get that information can be found in index.php

[TECK]

Assuming you are using in your 'htdocs' a /forum folder:

PHP Code:

<?php

require_once('./forum/global.php');

$memberscount = $DB_site->query_first("
    SELECT COUNT(*) AS total,MAX(userid) AS max FROM user
");
$memberstotal = number_format($memberscount['total']);
$threadscount = $DB_site->query_first("
    SELECT COUNT(*) AS total FROM thread
");
$threadstotal = number_format($threadscount['total']);
$postscount = $DB_site->query_first("
    SELECT COUNT(*) AS total FROM post
");
$poststotal = number_format($postscount['total']);
if ($displayloggedin)
{
    $datecut = $ourtimenow - $cookietimeout;
    $loggedins = $DB_site->query_first("
        SELECT COUNT(*) AS sessions
        FROM session
        WHERE userid=0
        AND lastactivity>$datecut
    ");
    $numberguest = $loggedins['sessions'];
    $numberregistered = 0;
    $loggedins = $DB_site->query("
        SELECT DISTINCT session.userid,username,invisible,usergroupid
        FROM session
        LEFT JOIN user ON (user.userid=session.userid)
        WHERE session.userid>0
        AND session.lastactivity>$datecut
        ORDER BY invisible ASC, username ASC
    ");
    if ($loggedin = $DB_site->fetch_array($loggedins))
    {
        $numberregistered++;
        while ($loggedin = $DB_site->fetch_array($loggedins))
        {
            $numberregistered++;
        }
    }
    $DB_site->free_result($loggedins);
    $onlinetotal = $numberregistered + $numberguest;
}
$totalposts = number_format($countposts['posts']);

print_r('Members: ' . $memberstotal . '<br />');
print_r('Threads: ' . $threadstotal . '<br />');
print_r('Posts: ' . $poststotal . '<br />');
print_r('Online Users: ' . $onlinetotal);

?>

[kill_emma]

Warning: main(./includes/init.php): failed to open stream: No such file or directory in C:\network\Apache2\htdocs\forum\global.php on line 18

Fatal error: main(): Failed opening required './includes/init.php' (include_path='.;c:\php4\pear') in C:\network\Apache2\htdocs\forum\global.php on line 18

btw: yes, i'm using htdocs/forum :P

EDIT:

i redid the top part to this

PHP Code:

 
chdir('c:\network\Apache2\htdocs\forum'); 
require_once('./global.php'); 


and now i'm getting:

vBulletin Message

Unable to add cookies, header already sent.

File: C:\network\Apache2\htdocs\index.php
Line: 26

line 26 is where the table my page begins on is.

[TECK]

PHP Code:

chdir('./forum');
require_once('./global.php'); 


[kill_emma]

still getting the same message

[bradsears]

Make sure you do the includes before your actual html .... you can't have any html tags before the include.

The key for you is "header already sent".

Some things need to be done by the server before the page starts being sent. This includes redirects but it would not surprise me if cookies were included as well.

Start with an empty script and test things step by step.

[kill_emma]

w00t, now it works.

2 things then i'm done!

1: everything will work except for the users online... why?
2: how would i display a user's info from the getinfo template (ie $userinfo[avatarurl])?