Mysidia Adoptables Support Forum

Well, take a look at the script below I made a while ago. It outputs your site stats including forums, users, posts, etc. :)

PHP Code:


		
			
<?php

include("create/mconfig.php");



//Connect to database...

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ("Cannot Authenticate to Database");

mysql_select_db($dbname);



//Loop through and get stats...



$posts = 0;

$users = 0;





$query = "SELECT * FROM hosted_forums";

$result = mysql_query($query);

$num = mysql_numrows($result);



//Loop out code

$i=0;

while ($i < $num) {



//Grab the forum name

$fname=@mysql_result($result,$i,"fname");



//Loop through and see how many posts and users each forum has...



    $query2 = "SELECT * FROM ".$fname."_posts";

    $result2 = mysql_query($query2);

    $num2 = mysql_numrows($result2);



    $posts = $posts + $num2;



    $query3 = "SELECT * FROM ".$fname."_users";

    $result3 = mysql_query($query3);

    $num3 = mysql_numrows($result3);



    $users = $users + $num3;



$i++;

}



echo "<b>Site Statistics: </b><br><br>

Forums: ".$i."<br>Users: ".$users."<br>Posts: ".$posts."";



?>

Hope it's what you need. :)