yetdog11
08-01-2002, 06:09 PM
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:
<?
$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
<?
$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