[apdcanari]

Hello,

How to post the total number members and posts on a page of its site?

For example : The forum had 55.000 posts and 2.000 members

My code with Vbulletin 3.0.7

Count member

PHP Code:

<?php
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM vb3_post');
$totalposts=number_format($countposts['posts']);
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM vb3_user');
$numbermembers=number_format($numbersmembers['users']);
echo "$numbermembers";
?>

Count Posts

PHP Code:

<?php
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM vb3_post');
$totalposts=number_format($countposts['posts']);
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM vb3_user');
$numbermembers=number_format($numbersmembers['users']);
echo "$totalposts";
?>

Thank you very much,

Good evening

C?dric

PS : I'm french and i don't speak English very well... :ermm: