![]() |
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;
Quote:
|
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!
|
Quote:
|
I get this error
Quote:
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 |
PHP Code:
|
Quote:
|
Quote:
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 |
Quote:
Quote:
Quote:
|
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
|
All times are GMT. The time now is 05:02 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|