Is there a way to show total registered members outside VB?

[rguan]

Hello everyone,

I'm running my business site with custom PHP pages + vBulletin 3.8.7, I want to display the vBulletin total registered members on my custom PHP homepage, is there a way to implement this?

This is my first thread on vb.org... hope I can get solutions from some great guys! :-)

Thanks a lot!

Roy

[rguan]

Anyone can help on this?

[kh99]

You could connect to the vb database and execute this query:

SELECT * FROM datastore WHERE title='userstats'

The result will be one record where the 'data' column is a serialized array with 4 values: numbermembers, activermembers, newusername, and newuserid.

[rguan]

Thanks for reply, could you give a full code solution?

[kh99]

Do your custom pages use vbulletin code at all?

[rguan]

Nope. Actually it's a blank PHP page... that's why I find it hard to work out...

Could you help on this? MANY MANY thanks...

[kh99]

Well, one thing you could do is to do something like in this article: https://vborg.vbsupport.ru/showthread.php?t=228112 . Then if you were to change the $specialtemplates line like this:

$specialtemplates = array('userstats');

you should be able to use $vbulletin->userstats in the custom code. But that's a lot of overhead if all you want is those two numbers. You say the page is blank - what is the page for? What else will be on the page when you're done?

[rguan]

"Blank" actually means it has nothing to do with VB initially... It looks like I have to do a lot of custom coding to get the "active members"...

Anyway, thanks a lot for your kind responses :-)

[kh99]

I don't think it's that much, I was just trying to understand what the situation is. Give me a few minutes...

OK, hopefully this helps:

PHP Code:

// you may need to adjust this path if your custom php 
// isn't in the forum directory.
include('./includes/config.php');

$server = $config['MasterServer']['servername'];
if (!empty($config['MasterServer']['port']))
    $server .= ':' . $config['MasterServer']['port'];
    
if (mysql_connect($server, $config['MasterServer']['username'], $config['MasterServer']['password']))
{
    mysql_selectdb($config['Database']['dbname']);
    $result = mysql_query("SELECT * FROM " . $config['Database']['tableprefix'] . "datastore WHERE title = 'userstats'");
    if ($result AND ($row = mysql_fetch_assoc($result)))
    {
        $vals = unserialize($row['data']);
        echo "Forum has " . $vals['numbermembers'] . " registered members";
    }
    mysql_close();
}