Quick Database Stats

Quick Database Stats

Author: assassingod

Description: This hacks gives a quick list of database stats for your forums. Includes name and ammount of MB its using

Final hack:
https://vborg.vbsupport.ru/showthrea...threadid=51828

[assassingod]

The original code did that

Thanks Amy, does it work for you now?

[amykhar]

Yes. It works now.

Amy

[assassingod]

You help is appreciated. I can put this in final release now

[DigitalDesktops]

Today at 02:39 AM filburt1 said this in Post #4
From PHP.net user comments:

<?
/*
  Function that returns whole size of a given MySQL database
  Returns false if no db by that name is found
*/

function getdbsize($tdb) {
   $db_host='localhost';
  $db_usr='USER';
   $db_pwd='XXXXXXXX';
   $db = mysql_connect($db_host, $db_usr, $db_pwd) or die ("Error connecting to MySQL Server!\n");
   mysql_select_db($tdb, $db);

  $sql_result = "SHOW TABLE STATUS FROM " .$tdb;
   $result = mysql_query($sql_result);
   mysql_close($db);

   if($result) {
       $size = 0;
       while ($data = mysql_fetch_array($result)) {
            $size = $size + $data["Data_length"] + $data["Index_length"];
     }
       return $size;
   }
   else {
       return FALSE;
   }
 }

?>

<?
/*
  Implementation example
*/

 $tmp = getdbsize("DATABASE_NAME");
 if (!$tmp) { echo "ERROR!"; }
 else { echo $tmp; }
?>

where do i place this code?

EDIT: nvm found it