Quick Forum Statistics in AdminCP

[HIGH]Quick Forum Statistics in AdminCP[/HIGH]

Author: assassingod

Description: This is a simple and easy way to view some basic statistics to your forum. You can find a list of 5 stats in your AdminCP.

1. [high]User Stats[/high] - Top Poster, Top Thread Starter, Newest Member, Members Online
2. [high]Forum Stats[/high] - Board Name, Board URL, Board Active, Total Threads, Total Posts, Total Members
3. [high]Misc. Stats[/high] - Most Used Avatar, Total Character in posts, Total Views, Attachment Usage (in bytes)
4. [high]Thread Stats[/high] - Most Viewed Thread, Most Replied Thread, Latest Thread
5. [high]Database Stats[/high] - DB name, DB size, DB tables inc each table size

Credits: I would like to thank N9ne for letting me use his 'Most Avatar Used' hack - thanks buddy

Latest Version:
1.3

IF YOU USE THIS HACK DO NOT FORGOT TO CLICK THE INSTALL BUTTON - THANKS YOU

[assassingod]

Thats true, I'll probably need some BETA testers for the stats on one page. I can't test it myself since I havent got a board.

[assassingod]

<font color="red">Update</font>
Changed $bbactive status (Now says Yes/No instead of 1/0)
Credits - hellsatan

[Morpheus84]

When you would like to add the database size statistic ?

[assassingod]

As soon as I figure out how to. My previous DataBase stats hack code may work, but I'll have to configure it to work with vB. Although I can have an attempt at that later tonight

[Hobbes]

nice hack

[high]* Hobbes installs[/high]

[assassingod]

Thanks

No further updates on DB Size.

Btw, if you are interested in BETA testing this hack with all that stats on one page, PM me.

[Sebastian]

here is a script i made that you can use to get the overall database size, even shows you how much space each table is using, feel free to use it.

PHP Code:

$dbhost = 'localhost';
$dbuser = 'username';
$dbpass = 'password';
$database = 'database';

  mysql_connect($dbhost,$dbuser,$dbpass) or die ('unable to connect');
  mysql_select_db($database) or die('unable to select database');

  $result = mysql_query("show table status");

  $total = 0;  $table= '';
  while($status = mysql_fetch_array($result)) {
      $total += ($status['Data_length'] + $status['Index_length']);
      $tables .= $status['Name']. ' : ' .number_format(($status['Data_length']/1024), 2). "kb<br />\n";
  }

  $total = number_format(($total/1024)/1024, 1);

  echo $tables ."<br />\n Total size for " . $database .' (<b> '. $total .' MB </b>)'; 


[assassingod]

Thanks Sebastian. I'll try it soon

[assassingod]

Version 1.3 out

Includes:
New DB stats - DB Name, DB size and DB tables with each table size

[assassingod]

Check 2nd post for updated screenshots