Tiny error, need urgent fix :D

[Mijae]

I currently have

<?php 
error_reporting(7); 
require('http://xxx/forum/global.php'); 

$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user'); 
$numbermembers=number_format($numbersmembers['users']); 

// get total posts 
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post'); 
$totalposts=number_format($countposts['posts']); 

$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread'); 
$totalthreads=number_format($countthreads['threads']);
?>

And I get this:

Fatal error: Call to a member function on a non-object in /home/xxx/public_html/test.php on line 5

How can I make it work? Without using templates

Please someone help, it used to be so easy with vB2, and now I cant make it work.

[Zachery]

Well, your trying to use this on vB3? alot of things as changed

global must be refrecned on the server, not as an outside source

Try

PHP Code:

<?php 
error_reporting(E_ALL & ~E_NOTICE);
require_once("./global.php");

$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user'); 
$numbermembers=number_format($numbersmembers['users']); 

// get total posts 
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post'); 
$totalposts=number_format($countposts['posts']); 

$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread'); 
$totalthreads=number_format($countthreads['threads']);
?>

If global.php isnt in the same directory, use

Try

PHP Code:

<?php 
chdir("./forums");
error_reporting(E_ALL & ~E_NOTICE);
require_once("./global.php");

$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user'); 
$numbermembers=number_format($numbersmembers['users']); 

// get total posts 
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post'); 
$totalposts=number_format($countposts['posts']); 

$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread'); 
$totalthreads=number_format($countthreads['threads']);
?>

[Mijae]

Thanks! It works.

Altho, it gives me a different total post count that the one shown on my forum's index.

What could that be due to?

[Zachery]

Because the total posts / thread count is done logicaly, not from a stright query.

[Mijae]

But which one is correct? And how can I make them both the same?

ZACH! Where are you! Someone tell me how I can make the numbers on both pages match :P

[Mijae]

Bump!

[Mijae]

Ill keep bumping till someone helps :P