vb.org Archive - Modifying custom include to act as global.php?

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01040 seconds Memory Usage 1,718KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: