Total views on non-vb page (Query included)

[wooolF[RM]]

]Hmmm... now I use this script:

PHP Code:

<?

$path = "/home/wooolf/WWW/forum/admin";                                                                            //where's config
require("$path/config.php");                                                                                    //get config settings


mysql_connect("$servername", "$dbusername", "$dbpassword") or die("Couldnt find MYSQL!");                        //connect to the server
mysql_select_db("$dbname")  or die ("Couldnt find DB!");                                                        //select proper DB

// STARTING QUERIES HERE
$aktiveuser = mysql_query("SELECT COUNT(userid) as anzahl FROM user");
$registers = mysql_query("SELECT userid, username FROM user ORDER BY userid DESC LIMIT 1");
$datecut=time()-$cookietimeout;
$loggedins=mysql_query("SELECT COUNT(*) AS sessions FROM session WHERE userid=0 AND lastactivity>$datecut");
$numberguest=mysql_result($loggedins,0);
$loggedins=mysql_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");
while ($loggedin=mysql_query($loggedins)) {
    $numberregistered++;
    if ($loggedin['invisible']==0 or $bbuserinfo['usergroupid']==6) {
      $numbervisible++;
    }
}
$totalonline=$numberregistered+$numberguest;
$numberinvisible=$numberregistered-$numbervisible;
// END OF QUERIES HERE

if (mysql_error()) {echo "mySQL error:"; echo mysql_error(); exit;}                                                //show error if any
else
{echo $totalonline;} echo("<br><br>");
{echo $numbervisible;} echo("<br><br>");
{echo mysql_result($numberguest,0);} echo("<br><br>");

?>

same result : Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/wooolf/WWW/forum/totalviews.php on line 43



line 43:

PHP Code:

{echo mysql_result($numberguest,0);} echo("<br><br>");