# Users Online Not Working With 2.0

[BabyU]

I had a #online users hack that was working great in 1.x, but returns an error in 2.0

There is a file called online.php that consists of:

------------------------------------------------------------------------
<?php
chdir($DOCUMENT_ROOT . "/forums");
require($DOCUMENT_ROOT . "/forums/global.php");

$loggedins=$DB_site->query_first("SELECT COUNT(sessionid) AS sessions FROM session WHERE userid=0");
$guests=$loggedins[sessions];
$loggedins=$DB_site->query_first("SELECT COUNT(sessionid) AS sessions FROM session WHERE userid<>0");
$members=$loggedins[sessions];

echo "There are currently $members forum members and
$guests guests online. <a href=/forums/index.php>Join us!</a>";

?>

------------------------------------------------------------------------

It is called to a non-php homepage via an include statement:

<!--#include virtual="/forums/online.php"-->

The error I am now receiving since upgrading to 2.0 is:

----------------------------------------------------------------------
There seems to have been a slight problem with the database. Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
----------------------------------------------------------------------

Any suggestions to fix this? Thanks!