Modifying custom include to act as global.php?

[yetdog11]

I run a site that is built around vB's membership system, and we use a custom file (antsglobals.php) to include any kind of login information a page might require:

PHP Code:

<?
$dbserver = "**";
$dbname = "**";
$dbusername = "**";
$dbpassword = "**";

$db = mysql_connect($dbserver, $dbusername, $dbpassword);
mysql_select_db($dbname,$db);
    
    
    $sql = "select count(ss.songid) as c from song s inner join showsong ss on ss.songid = s.songid";
    $result = mysql_query($sql, $db) or die(mysql_error());
    $totalnumbersongs = mysql_fetch_assoc($result);
    $totalnum = $totalnumbersongs["c"];
    
if(isset($sessionhash))
{
    $sessionsql="SELECT sessionhash,userid,host,useragent,styleid FROM session WHERE sessionhash='$sessionhash' AND host='".addslashes($REMOTE_ADDR)."'";
    $sessionresult = mysql_query($sessionsql, $db) or die(mysql_error());    
    if(mysql_num_rows($sessionresult) == 1)
    {    
        $session = mysql_fetch_array($sessionresult);
        extract($session);
    }        
    
    if(isset($userid) && $userid != 0)
    {
        $usersql="SELECT userid, password FROM user WHERE userid=$userid";
        $userresult = mysql_query($usersql, $db) or die(mysql_error());    
        $user = mysql_fetch_assoc($userresult);
        extract($user);
        $bbuserid = $userid;
        $bbpassword = $password;
        
    }
}
mysql_close($db);
?>

Now, basically I want to edit who's online to show the location of users as they browse thru non-vb pages on the site (obviously they are still logged in as they browse other pages that require being logged in. However, this is done using the antsglobals.php file. I see that in order to make this work, I should just require global.php in all of my files. However, when I do so, all I get is a blank white page, no matter if I load global before antsglobals, or even comment out the antsglobals include. the second i require/include globals.php, i get a white page.

So basically my question is, from the code above, is there anyway to slightly modify antsglobals.php that so it provides the same function(s) as global.php that is necessary for users to show up in who's online?

Matthew Yette
matt@antsmarching.org

[yetdog11]

Nothing? :ermm:

[yetdog11]

It looks like I'm going to be using sessions to do this, and storing PHP_SELF in the location column of the session table for each page. However - do I need to include sessions.php to carry on the session to non-vb pages?

Matthew Yette
matt@antsmarching.org