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!

Nice:)

Satan

I installed it but it says; :/

There are some comments on line 5 and 7

Try following those instructions and see if it works:)

I ended up having to hard code in my username and password to get it to work. The localhost line didn't have to change for me though.

Amy

Maybe I should have kept 'require("./config"); '?
I'll test it out

I'm fine now. I neglected to look for configurables. Sorry about that!

Glad to here its working:)

Working fine.

When I hard-coded my username and password in, this is the error I got:

Warning: mysql_query(): 5 is not a valid MySQL-Link resource in /home/bear/public_html/forum/admin/db_mysql.php on line 86

If I don't hardcode it, it get the line

(Using ERROR! MB of space)

Nice, nice, nice!

Did you check the comments on lines 5 and 7?

I get this error even after changing all the user/pass/server vars in script.

No worries, I removed the hack anyways. But good idea!

Not too sure why you got that error:confused:
Oh well:(

Maybe it only works on certain OS's?

Maybe - Some say it work some say it dont.

Weird

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

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.

$tdb MUST equal your database name.

I'm willing to bet that mysql_error() will return "No database selected" ;)

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

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

Thanks Kriek !!


I will look into it:)

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.

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.

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. :)

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

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

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

/me licks install

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

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

Still working on a new version

Any luck on the new version?

Not as yet no.

Its the next thing on my list i assure you:)

REMOVED UNTIL ALL BUGS ARE FIXED

The [real] final version is being worked on now.

<font color="red">Updated the v3</font>

This should be a working version. I've tested it and there appears the be NO errors.

Let me now if anything is wrong.

Screenshot