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.

Credits: Sebastian

Screenshots:
https://vborg.vbsupport.ru/attachmen...&postid=431944


Tested on vB version:
2.3.2
2.3.0
2.2.9

If you use this hack please click the INSTALL button - thank you!

[assassingod]

Today at 03:34 AM Boofo said this in Post #19
Yes, I did. When I do it that way, I get some strange db error about a lastpost or something and all of the text on the page suddenly goes to smallfont. Wierd.

Do you have anything else installed in your admin CP? I can't think why its doing that. I'll look into it more

Today at 03:31 AM Kriek said this in Post #18

PHP Code:

$db = mysql_connect($db_host, $db_usr, $db_pwd) or die (mysql_error());
mysql_select_db($tdb, $db) or die (mysql_error()); 


mysql_error() will give a more specific error to work with; definitely a life saver for me. Hope this helps.

Thanks Kriek !!

Today at 06:42 AM Sanjiyan said this in Post #21
Installed just fine, but how do I shorted the MB feedback?

At the moment it looks like this:

Database Stats borg (Using 1.0523281097412 MB of space)

How do I get it to go to: 1.23 MB

I will look into it

[iwearnosox]

This will return the correct DB size after hard coding name and password for me but then it spews out:

Warning: mysql_query(): 1 is not a valid MySQL-Link resource in /path/admin/db_mysql.php on line 86

This error disappears after removing this hack. I have a 2.3 board.

[Kriek]

iwearnosox, let me break your error down for you

mysql_query() throws an error because $result = mysql_query($sql_result); this can not be run because $sql_result = "SHOW TABLE STATUS FROM " .$tdb; and the $tdb variable MUST contain your database name which is in mysql_select_db($tdb, $db); so the connection is broken, because the $tdb variable is incorrect.

As I've already stated in my previous comments from this thread [1][2] that error is specifically caused because the connection to the database was prevented either in mysql_connect() or mysql_select_db() and using mysql_error() will specifically output the error causing the problem.

[iwearnosox]

Thanks for the added info. I'm going on no sleep for like 36 hours now so any attempt at a reasonable reply is beyond me. Once I sleep I'll check back in and try to understand what you just said.

[Kriek]

Starbucks coffee and ice cream in a blender does the trick for me.

59 hrs without sleep, hoping for at least 3 hrs soon.

[Tungsten]

Works great "out of the box" with 2.2.8 running on a Windows 2000 / IIS5 installation.

/me licks install

[Sanjiyan]

assassingod,

Any luck with narrowing down the number of decimal points I posted a few days ago?

ie 1.23 MB instead of 1.23456789 MB

[assassingod]

Not yet - If anyone knows too, would you kindly share how to?

Still working on a new version

[Boofo]

Any luck on the new version?

[assassingod]

Not as yet no.

Its the next thing on my list i assure you