[Jacko]

ok i ventured into adding some stats onto my forumhome template and this is what i added to my "index.php" file:

// BEGIN vbStats Hack [230.01]
// Active/Non?
$activemembers=$numbermembers-$nonposters;
$activityrate=sprintf("%.2f",(100*$activemembers/$numbermembers));

// Staff
$anum = mysql_num_rows(mysql_query("select * from user WHERE usergroupid=5 or usergroupid=6 or usergroupid=7"));

// Total
$totalposts=$countposts['posts'];
if ($totalposts=='') { $totalposts=0; }
$totalthreads=$countthreads['threads'];
if ($totalthreads=='') { $totalthreads=0; }

// Today [FireFly]
$getpoststoday=$DB_site->query_first("SELECT count(*) AS count FROM post WHERE dateline>='$tltoday'");
$poststoday=$getpoststoday[count];

eval("$vbstats = "".gettemplate('vbstats_forumhome')."";");
// END vbStats Hack [230.01]

then i added the following to my forumhome template:

Active Members: $activemembers
Activity Level: $activityrate%

Total Threads: $totalthreads
Total Posts: $totalposts
Posts Today: $poststoday

Staff Members: $anum

and this is the end result:


as you can see my active users is wrong and my percentage too. my total posts and posts today are also wrong.

what have i added wrong and how can i fix this??

Cheers :cheeky: