Showing posts/member count on non-forum HTML page

[wii]

Showing posts and member count on non-forum HTML page.

Like this:

12116 forum members - 1104618 posts

[wii]

Anyone? I would even pay a little (using paypal) to get this done !

Thanks

[sabret00the]

PHP Code:

// get total members
$numbersmembers=$db->query_first('SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user');
$numbermembers = number_format($numbersmembers['users']);
// get total posts
$countposts=$db->query_first('SELECT COUNT(*) AS " . TABLE_PREFIX . "posts FROM post');
$totalposts = number_format($countposts['posts']);
//$countthreads=$db->query_first('SELECT COUNT(*) AS " . TABLE_PREFIX . "threads FROM thread');
//$totalthreads = number_format($countthreads['threads']);

echo $numbermembers . " forum members - " . $totalposts  . " posts"; 


it's really not worth the money, but theirs the query you need to get the data, i commented out the data you may want but never requested.

[wii]

Thanks a lot, which file do I need to include in my non-forum page to get this data ?

[sabret00the]

include your forums' global.php

[wii]

Thanks a lot...

I can´t seem to get it right - in my HTML page I added a little include, like this:

<?php include("stats.php"); ?>

In the stats.php file I have this:

<?php
include_once('../forum/global.php');

// get total members
$numbersmembers=$db->query_first('SELECT COUNT(*) AS users FROM " . TABLE_PREFIX . "user');
$numbermembers = number_format($numbersmembers['users']);
// get total posts
$countposts=$db->query_first('SELECT COUNT(*) AS " . TABLE_PREFIX . "posts FROM post');
$totalposts = number_format($countposts['posts']);
//$countthreads=$db->query_first('SELECT COUNT(*) AS " . TABLE_PREFIX . "threads FROM thread');
//$totalthreads = number_format($countthreads['threads']);

echo $numbermembers . " forum members - " . $totalposts . " posts";

?>

What is wrong?

Thanks

[sabret00the]

what happens when you run the stats.php?

[wii]

Fatal error: Call to a member function query_first() on a non-object in D:\home\mysite\stats.php on line 5

[Marco van Herwaarden]

Use $vbulletin->db->query_first instead of $db->query_first

[wii]

Same result:

Fatal error: Call to a member function query_first() on a non-object in D:\home\mysite\stats.php on line 5