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 :D

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
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
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