Query to display member count globally

[bzcomputers]

I'm looking for a query / hook combination to be able to display the registered member count places other than FORUMHOME.

Thanks.

[Simon Lloyd]

Not tested but something on the lines of

PHP Code:

$query = $vbulletin->db->query_read("SELECT COUNT (userid) FROM ". TABLE_PREFIX."user WHERE userid <>0");
$result = mysql_query($query);
echo "There are ".mysql_num_rows($result)." Users(s)."; 


and you could use global_complete as the hook

[bzcomputers]

Tried to work with it, but just got database errors.

[kh99]

You could do it that way. There's also another way, someone asked about it here: www.vbulletin.org/forum/showthread.php?t=286573

[bzcomputers]

Thanks.