Admin Quick Stats

[Freddie Bingham]

I don't use vBhacker so you will have to do this the old fashioned way. Also forgive me if something like this has already been released. I think everything is good but it is hard to code in vb2 style after working on the vb3 style so much.

This hack shows some quick stats on your Admin index page such as PHP version, server type, mysql version, Database usage, attachment usage, avatar usage, moderation and forum stats. I can add support for calculating attachments from PPN's attachments as files but I have to actually look at it first, which I will do tomorrow. In vb3 there is a filesize column in the attachment table so you don't need to do anything different if the attachments are currently in the file system (you can move them back and forth) but I assume I will have to run through the directory with filesize() to get an attachment total with the hack.

Anyway open admin/index.php and find:if ($moderatenewmembers==1 or $usecoppa==1) {
$waiting=$DB_site->query_first("SELECT COUNT(*) AS users FROM user WHERE usergroupid=4");
if ($waiting[users]==0) {
echo "<font size='1'>There are currently $waiting[users] user(s) awaiting <a href=\"user.php?s=$session[sessionhash]&action=moderate\">moderation</a>.</font>";
} else {
echo "<b><a href=\"user.php?s=$session[sessionhash]&action=moderate\">There are currently $waiting[users] user(s) awaiting moderation</a>.</b>";
}
}

Delete that and replace it with:

function kbtomb($value) {
if ($value == 'N/A') {
return $value;
} elseif (!$value) {
return '0.0 MB';
} else {
return sprintf('%.2f', $value / 1024000) . ' MB';
}
}

$starttime = mktime(0, 0, 0, date('m'), date('d'), date('Y'));

$attach = $DB_site->query_first("SELECT SUM(LENGTH(filedata)) AS size FROM attachment");
$avatar = $DB_site->query_first("SELECT SUM(LENGTH(avatardata)) AS size FROM customavatar");

$newusers = $DB_site->query_first("SELECT COUNT(*) AS count FROM user WHERE joindate >= $starttime");
$newthreads = $DB_site->query_first("SELECT COUNT(*) AS count FROM thread WHERE dateline >= $starttime");
$newposts = $DB_site->query_first("SELECT COUNT(*) AS count FROM post WHERE dateline >= $starttime");
$users = $DB_site->query_first("SELECT COUNT(*) AS count FROM user WHERE lastactivity >= $starttime");

$mysqlversion = $DB_site->query_first("SELECT VERSION() AS version");

$indexsize = 0;
$datasize = 0;
if ($mysqlversion['version'] >= '3.23') {
$DB_site->reporterror = 0;
$tables = $DB_site->query("SHOW TABLE STATUS");
$errno = $DB_site->errno;
$DB_site->reporterror = 1;
if (!$errno) {
while ($table = $DB_site->fetch_array($tables)) {
$datasize += $table['Data_length'];
$indexsize += $table['Index_length'];
}
if (!$indexsize) {
$indexsize = 'N/A';
}
if (!datasize) {
$datasize = 'N/A';
}
} else {
$datasize = 'N/A';
$indexsize = 'N/A';
}
}

$attachcount = $DB_site->query_first("SELECT COUNT(*) AS count FROM attachment WHERE visible = 0");

$serverinfo = PHP_OS . ' / PHP v' . phpversion();

if (phpversion() >= '4.0.3') {
$serverinfo .= iif(ini_get('safe_mode'), ' Safe Mode', '');
$serverinfo .= iif(ini_get('file_uploads'), '', '<br />FILE_UPLOADS disabled');
}

doformheader('', '');
maketableheader('Quick Stats');
makelabelcode('Server Type', $serverinfo);
makelabelcode('MySQL', 'v' . $mysqlversion['version']);
makelabelcode('Database Data Usage:', kbtomb($datasize));
makelabelcode('Database Index Usage:', kbtomb($indexsize));
makelabelcode('Attachment Usage:', kbtomb($attach['size']));
makelabelcode('Custom Avatar Usage:', kbtomb($avatar['size']));

// Only display if the admin has moderation enabled on an active postable forum.
if ($DB_site->query_first("SELECT forumid FROM forum WHERE moderatenew = 1 AND cancontainthreads = 1 AND active = 1 AND allowposting = 1")) {
$postcount = $DB_site->query_first("SELECT COUNT(*) AS count FROM post WHERE visible=0");
$threadcount = $DB_site->query_first("SELECT COUNT(*) AS count FROM thread WHERE visible=0");
makelabelcode("Threads Awaiting <a href=\"../mod/moderate.php?s=$session[sessionhash]&action=posts\">Moderation</a>:", $threadcount['count']);
makelabelcode("Posts Awaiting <a href=\"../mod/moderate.php?s=$session[sessionhash]&action=posts\">Moderation</a>:", $postcount['count']);
}
if ($moderatenewmembers==1 or $usecoppa==1) {
$waiting=$DB_site->query_first("SELECT COUNT(*) AS users FROM user WHERE usergroupid=4");
makelabelcode("Users Awaiting <a href=\"user.php?s=$session[sessionhash]&action=moderate\">Moderation</a>:", $waiting['users']);
}
makelabelcode("Attachments Awaiting <a href=\"../mod/moderate.php?s=$session[sessionhash]&action=attachments\">Moderation</a>:", $attachcount['count']);
makelabelcode('New Users Today:', $newusers['count']);
makelabelcode('Registered Visitors Today:', $users['count']);
makelabelcode('New Threads Today:', $newthreads['count']);
makelabelcode('New Posts Today:', $newposts['count']);
dotablefooter();

[JulianD]

Looks great freddie Installing right now :D

[Recluse]

problem closing the php

Parse error: parse error in /admin/index.php on line 283

line 282 =<?php
line 283 = }

[JulianD]

Yeap.. having the same issue.... :(

[JulianD]

Already fixed:

Replace

function kbtomb($value) {
if ($value == 'N/A') {
return $value;
} elseif (!$value) {
return '0.0 MB';
} else
return sprintf('%.2f', $value / 1024000) . ' MB';
}
}


with

function kbtomb($value) {
if ($value == 'N/A') {
return $value;
} elseif (!$value) {
return '0.0 MB';
} else {
return sprintf('%.2f', $value / 1024000) . ' MB';
}
}


( note the extra { )

[JulianD]

BTW, very cool hack, thanks freddie :)

[Floris]

w00h00 freddie :) Thank you kindly for this hack, nice one and I can use it! By the way, nice Admin Control Panel theme you got going there.

[FWC]

Very nice, Freddie! Thanks. :)

[Recluse]

Originally posted by JulianD
Already fixed:


( note the extra { )

beat me to it :), thanks for the hack freddie

heres mine

[MarkB]

Very cool! Thanks for the hack, Freddie, and thanks to JulianD for the quick fix :)

[Scott MacVicar]

I've installed this hack and its very handy, to get the size of attachments when they are files?
You could either read through the directory adding the file sizes together or exec("du -sm $attachpath");
Thats the only ways I can think of doing it unless there is a nice php function to get the size of a directory.

Scott

[wooolF[RM]]

]installed, voted 5! very good! :D

[TECK]

great hack. congrats. :)

[inetd]

Good! Super hack! Thanks, freddie!

I have one question: what is Database index usage?

[WallStreat]

Top NOTCH! Simple Yet Handy :)

[Freddie Bingham]

Originally posted by inetd
Good! Super hack! Thanks, freddie!

I have one question: what is Database index usage? Your database takes space for the data and it takes space to maintain the indeces.

[MrLister]

Awsome job! This is extremly useful!

[Freddie Bingham]

I am interested in what is displayed if you are using php < 4.0.3 or INNODB tables in mysql.

[Steve Machol]

Works great! Thanks freddie! :)

[Xelation]

awsome hack! I will install it as soon as I get some time. :)

[LouChipher]

New Threads Today: 8866

the normal statistik says something eles.. hm.. i will search..

[g-force2k2]

Great Job Freddie... looks great... keep up the good hacks ;D

~gforce2001~

[Aaow AnD wHiTe]

Thank you freddie :) Gonna install it now :) BTW.... I smell some of the official v3 colors... ;)

[Erwin]

Sweet. Thanks!

[SWFans.net]

Great hack! :)

I?m curious if there is any way to optimize the database index so that its space allocation is lessened as much as possible?

[Freddie Bingham]

No those colors are from my vb2 forum.

[Freddie Bingham]

Originally posted by LouChipher
New Threads Today: 8866

the normal statistik says something eles.. hm.. i will search.. What 'normal statistic' are you referring to? The stats.php that is in the admin panel? I checked and the stats match on my forum.

[Freddie Bingham]

I have the version that supports the attachments as files hack as well as some additional stats / averages. I will post it tonight when I get home.

[SWFans.net]

Originally posted by SWFans.net
Great hack! :)

I?m curious if there is any way to optimize the database index so that its space allocation is lessened as much as possible? Odd. My post should have been number 28 from what I saw of this thread when I replied. @_@

Oh well, nevermind me and my seeing things.

[Ian]

Hmm, do you guys know if it'd be possible to add this hack to the mod control panel?

[Vivi Ornitier]

Exellant hack, very simple and yet very useful

[LouChipher]

I checked the MySQL Query but didn't found any Problem, it must work! Maybe someone has an idea?

Im using vB 2.2.4, PHP 4.4.1 and MySQL 3.23.41

It always says that we have about 8000 new Threads this day.


$newthreads = $DB_site->query_first("SELECT count(*) AS count FROM thread WHERE dateline >= $starttime");
$newposts = $DB_site->query_first("SELECT count(*) AS count FROM post WHERE dateline >= $starttime");


So this is the same line, but Posts are working, Threads not...!?

[Xelation]

Ah, worked great! this is incrediably useful to me! Thank You Freddie!!

[SirSteve]

Excellent hack! This needs to be in VB3! :)

[Freddie Bingham]

Originally posted by SirSteve
Excellent hack! This needs to be in VB3! :) Maybe it already is? ;)

[SirSteve]

Originally posted by freddie
Maybe it already is? ;)

Very cool!! :D

[ryanhulce]

Strange I did what I thought I needed to but it gives me this error

Parse error: parse error in /home/clanomn/public_html/omni/admin/index.php on line 106

Here is my admin/index.php

[ryanhulce]

Line 106 in my admin/index.php is

function kbtomb($value) {

[FWC]

Originally posted by ryanhulce
Strange I did what I thought I needed to but it gives me this error



Here is my admin/index.php What did you use for a code editor? Everything is weirdly spaced. The lines are double spaced and the space between function and kbtomb is not a real space. That's causing the parse error. But everything below it has the same problem, too. You need to start over. Also, we're not supposed to post complete vB files. You should delete that attachment.

[ryanhulce]

I copied it using Opera not Internet Explorer and for some reason Opera had it all spaced!! It works great now thanks for helping.

[FWC]

Cool. I'm glad it worked. It's a great hack!

[ryanhulce]

Here is what Opera Showed!

[inphinity]

nice hack freddy :)

on my board i've found that it slows the loading of the admin page by a few seconds and also adds to the load of the machine.

so i've moved it to a seperate file and added a link to my admin nav bar :)

Save Freddys hack to admin/adminquickstats.php at the top of the file add:
<?php

error_reporting(7);

require("./global.php");

cpheader();and the bottom of the file addcpfooter();

?>

In admin/index.php find makenavoption("Back-up Database","backup.php?action=choose","<br>");above it addmakenavoption("Database Stats","adminquickstats.php?action=","<br>");

[Freddie Bingham]

Yes it will do a full scan of the post/thread/user tables so it can appear slow. I don't see any long term effects on load happening though unless you are reloading the Admin CP index often.

[Harvey]

Hi,

I don't reccoment if you don't call admin/index.php every few seconds, but if you want to try at your own risk, query some SQL-commands:

create index joindate on user (joindate)
create index dateline on thread (dateline)
create index dateline on post (dateline)
create index lastactivity on user (lastactivity)

If you don't get what you want, you can undo with:

alter table user drop index joindate
alter table thread drop index dateline
alter table post drop index dateline
alter table user drop index lastactivity

[Freddie Bingham]

Don't add those indeces to your forum as it will result in a general slowdown.

It will make these stats appear instantly but you will then have dateline indexed twice in thread and post since it is part of a multi-record index already. You will then have lastactivity indexed on the user table which will then have to be updated on every pageview which can be a bad thing.

It is important to devote optimization to the user side of the forum at the admin panel's cost.

[Harvey]

huh - did I miss something in the upgrades? I can't find any indices of dateline (checked with show create table post / thread)

But you're right, it would slow down update/insert/delete-statements.

[Freddie Bingham]

Your right. I am getting confused with vb3 tables I think. Just ignore me. I still woudn't put that index on the user.lastactivity though.

[Martz]

Excellent, works well apart from the slow admin/index.php - but that I can handle.

[Austin Dea]

Works bootyfully :D.

[Harvey]

works greate on 2.2.4 without modification (no surprise). I installed. Without index. PHP is 412, so I cannot be a tester for < 4.0.3. Sorry.

[eiSecure]

Originally posted by xiphoid
w00h00 freddie :) Thank you kindly for this hack, nice one and I can use it! By the way, nice Admin Control Panel theme you got going there. Isn't that the vB3 admin CP theme? :bunny:

[Twig Deez]

splendid. :)

[Freddie Bingham]

Originally posted by eiSecure
Isn't that the vB3 admin CP theme? :bunny: No, that is just my own vb2 forum.

[eoc_Jason]

I love this little additon to my control panel....

It's Zesty! Yes.... Zesty!

[SaintDog]

Great hack freddie, it is great, no longer will I have to backup my database to get a count on the size of it :).

Great Job,

SaintDog

[psico]

freddie,
Any news about the version for Avatars and Attachs as files?

[inetd]

freddie, i install this hack (https://vborg.vbsupport.ru/showthread.php?s=&threadid=37780). But don't see how thread's want moderates in your hack... Please help me.
:)
Please :)

[pgowder]

Love the hack!

But, I get 0's for database data usuage and index usage??

[DWZ]

* DWZ scratches head... err.. I cant find any of that code in admin/index.php ...

(using 2.2.5)

EDIT: augh, im an idiot, i know... im using a new program to edit my files and ticked the wrong box in the search window... my bad.. sorry

[ceo_tfw]

I have installed this and it did not take that long to put in, however I would like to add the visits from non.members, how can I did that,
can anyone help

[Harvey]

@ceo_tfw: this would require to develop an extra hack. You would have to store the sessions in the DB for 1 day.

-----------

I made an extension to show modified threads (without # of new threads)
after freddie's $newthreads = $DB_site->query_first("SELECT count(*) AS count FROM thread WHERE dateline >= $starttime");add$changedthreads = $DB_site->query_first("SELECT count(*) AS count FROM thread WHERE lastpost >= $starttime");
after freddie's makelabelcode('New Threads Today:', $newthreads['count']);addmakelabelcode('Modified Threads Today:', $changedthreads['count']-$newthreads['count']);

Replace 'Modified Threads Today:' by better english if nessesary.

[ceo_tfw]

thanks for that, I have added it great stuff,
I still would like to know how to do the above
thanks

[inetd]

freddir, why "Post Awaiting Moderation:" in Admin Quick Stats don't show? I enable premoderation in some forums.

[LouChipher]

New Threads Today: 8605
Modified Threads Today: -8553

funny effect... and i can't see any reason..

[The Realist]

Working fine, well done :)

Here is my stats:

[The Realist]

Working fine, well done :)

Here is my stats:

[Harvey]

Originally posted by LouChipher
New Threads Today: 8605
Modified Threads Today: -8553

funny effect... and i can't see any reason..

Hi,

this can't be my modification. I didn't touch "New Threads".

uff, my english :( I can't explain, but I guess you have 52 modified threads and an unknown number of new threads.

You have to add my lines below freddies lines, not to change anything. But i think you do so.

Our site is OK.

If you don't understand my english, sorry, don't worry. I copuld not help.

[cihangir]

i thicnk i have a little problem with this hack :)


Server Type
Linux / PHP v4.1.2

MySQL
v3.23.41

Database Data Usage:
56.02 MB

Database Index Usage:
32.15 MB

Attachment Usage:
0.0 MB

Custom Avatar Usage:
0.03 MB

Users Awaiting Moderation:
0

Attachments Awaiting Moderation:
0

New Users Today:
2

Registered Visitors Today:
58

New Threads Today:
1097

New Posts Today:
17




17 new posts, but 1097 new threads

[Mntsnow]

Very cool! Thanks :)

[KuraFire]

Thx for the hack Freddie, works great. :):up:

I had to remove a small section of the query for Registered Users Today though (the Where clause) because it didn't show up without. Why was it in there, anyway?

[ZiRu$]

nice stuff :) I will install

[Lethal]

Nice hack freddie, works like a charm.

[Dark Odin]

Is there any plans to make this work with Attachments as Files?

[Amasov]

Great Hack :)

I love this one, since my provider was'nt able to tell me the usage of my database :D :D

[Henry-RS]

Heh....I didn't really like it much above the "Useful Admin Stuff" section, so I put it below it.

If you want to do the same...

Find & Delete:
if ($moderatenewmembers==1 or $usecoppa==1) {
$waiting=$DB_site->query_first("SELECT count(*) AS users FROM user WHERE usergroupid=4");
if ($waiting[users]==0) {
echo "<font size='1'>There are currently $waiting[users] user(s) awaiting <a href=\"user.php?s=$session[sessionhash]&action=moderate\">moderation</a>.</font>";
} else {
echo "<b><a href=\"user.php?s=$session[sessionhash]&action=moderate\">There are currently $waiting[users] user(s) awaiting moderation</a>.</b>";
}
}

Then Find:
<tr class="secondalt">
<td>Useful Links</td>
<td><select onchange="jumpto(this.options[this.selectedIndex].value)">
<option>&raquo; Useful Links &laquo;</option>
<option value="http://www.vbulletin.com/">vBulletin Home Page</option>
<option value="http://www.vbulletin.com/members/">vBulletin Members' Area</option>
<option value="http://www.vbulletin.com/forum/">vBulletin Support Forums</option>
<option value="http://www.vbulletin.com/manual/">vBulletin Online Manual</option>
<option value="http://www.php.net/">PHP Home Page</option>
<option value="http://www.php.net/manual/">PHP Online Manual</option>
<option value="http://www.mysql.com/">MySQL Home Page</option>
<option value="http://www.mysql.com/documentation/">MySQL Documentation</option>
</select></td>
</tr>
</form>
</table>
</td></tr></table>
</form>

Add this below:
<?php

function kbtomb($value) {
if ($value == 'N/A') {
return $value;
} elseif (!$value) {
return '0.0 MB';
} else {
return sprintf('%.2f', $value / 1024000) . ' MB';
}
}

$starttime = mktime(0, 0, 0, date('m'), date('d'), date('Y'));

$attach = $DB_site->query_first("SELECT SUM(LENGTH(filedata)) AS size FROM attachment");
$avatar = $DB_site->query_first("SELECT SUM(LENGTH(avatardata)) AS size FROM customavatar");

$newusers = $DB_site->query_first("SELECT count(*) AS count FROM user WHERE joindate >= $starttime");
$newthreads = $DB_site->query_first("SELECT count(*) AS count FROM thread WHERE dateline >= $starttime");
$newposts = $DB_site->query_first("SELECT count(*) AS count FROM post WHERE dateline >= $starttime");
$users = $DB_site->query_first("SELECT count(*) AS count FROM user WHERE lastactivity >= $starttime");

$mysqlversion = $DB_site->query_first("SELECT VERSION() AS version");

$indexsize = 0;
$datasize = 0;
if ($mysqlversion['version'] >= '3.23') {
$DB_site->reporterror = 0;
$tables = $DB_site->query("SHOW TABLE STATUS");
$errno = $DB_site->errno;
$DB_site->reporterror = 1;
if (!$errno) {
while ($table = $DB_site->fetch_array($tables)) {
$datasize += $table['Data_length'];
$indexsize += $table['Index_length'];
}
if (!$indexsize) {
$indexsize = 'N/A';
}
if (!datasize) {
$datasize = 'N/A';
}
} else {
$datasize = 'N/A';
$indexsize = 'N/A';
}
}

$attachcount = $DB_site->query_first("SELECT count(*) AS count FROM attachment WHERE visible = 0");

$serverinfo = PHP_OS . ' / PHP v' . phpversion();

if (phpversion() >= '4.0.3') {
$serverinfo .= iif(ini_get('safe_mode'), ' Safe Mode', '');
$serverinfo .= iif(ini_get('file_uploads'), '', '<br />FILE_UPLOADS disabled');
}

doformheader('', '');
maketableheader('Quick Stats');
makelabelcode('Server Type', $serverinfo);
makelabelcode('MySQL', 'v' . $mysqlversion['version']);
makelabelcode('Database Data Usage:', kbtomb($datasize));
makelabelcode('Database Index Usage:', kbtomb($indexsize));
makelabelcode('Attachment Usage:', kbtomb($attach['size']));
makelabelcode('Custom Avatar Usage:', kbtomb($avatar['size']));

// Only display if the admin has moderation enabled on an active postable forum.
if ($DB_site->query_first("SELECT forumid FROM forum WHERE moderatenew = 1 AND cancontainthreads = 1 AND active = 1 AND allowposting = 1")) {
$postcount = $DB_site->query_first("SELECT count(*) AS count FROM post WHERE visible=0");
$threadcount = $DB_site->query_first("SELECT count(*) AS count FROM thread WHERE visible=0");
makelabelcode("Threads Awaiting <a href=\"../mod/moderate.php?s=$session[sessionhash]&action=posts\">Moderation</a>:", $threadcount['count']);
makelabelcode("Posts Awaiting <a href=\"../mod/moderate.php?s=$session[sessionhash]&action=posts\">Moderation</a>:", $postcount['count']);
}
if ($moderatenewmembers==1 or $usecoppa==1) {
$waiting=$DB_site->query_first("SELECT count(*) AS users FROM user WHERE usergroupid=4");
makelabelcode("Users Awaiting <a href=\"user.php?s=$session[sessionhash]&action=moderate\">Moderation</a>:", $waiting['users']);
}
makelabelcode("Attachments Awaiting <a href=\"../mod/moderate.php?s=$session[sessionhash]&action=attachments\">Moderation</a>:", $attachcount['count']);
makelabelcode('New Users Today:', $newusers['count']);
makelabelcode('Registered Visitors Today:', $users['count']);
makelabelcode('New Threads Today:', $newthreads['count']);
makelabelcode('New Posts Today:', $newposts['count']);
dotablefooter();
?>


:)

Hopefully that'll work for anyone who would actually do it. ;)

[cdrforum]

Superb easy hack well done m8 !! 5 out of 5 !!

[yetdog11]

I am running vB 2.2.2 - I seemingly have installed it correctly, but nothing in my CP looks different. Do I need at least 2.2.5?

Matt
matt@antsmarching.org

[Boofo]

Did you ever get this done and posted? I can't seem to find it in here. Did I miss it? BTW: Great hack, Freddie! :)

Originally posted by freddie
I have the version that supports the attachments as files hack as well as some additional stats / averages. I will post it tonight when I get home.

[GuruXL]

Good Hack man, i installed it and it works flawlessly. :p

[irn-bru]

thanx for the hack nice work freddie :classic:

[freakyshiat]

is it possible to have these stats viewable from a php file outside of the admin directory?

Its integrated in the control panel now, but what if I wanted to show this info in a non vb public page

[The Ghost]

hi,

looks very cool and work's fine!

thx!

Greetz

The Ghost

[Derek]

What exactly was the pointt of the modified threads thing? I can't seem to find it's purpose...

[Bro_Joey_Gowdy]

nice addition

[Kars10]

Great Hack - Thank you very much!! ;)

[Schorsch]

works great!!! Thank You :banana:

[LOD-squa]

I like it installed.

[Mr. X]

Great hack, very useful. If anyone cares, heres what it looks like on mine:

[Darkwolf]

Cool hack!

[PHiXTiT]

Great addition!

ThanX

Here is a screenshot

[Floris]

Just installed this on 2.2.9 and it works :)

[SirSteve]

Why does it take like 20 seconds (on cable modem) for the quick stats page to come up?

[Cyberhouse]

Very nice addition!

Great work ;)
clicks install :D

[agfisdn]

Very nice and simple ! 5/5

Thanx !

My first hack :)

Works on 2.2.9

Additional stuff:
vBPortal 3.0pr1
PHP 4.3.0RC2
Apache 1.3.27

[Kohhal]

Nice hack, installed with no problems on 2.2.9 :D

[Freddie Bingham]

Originally posted by SirSteve
Why does it take like 20 seconds (on cable modem) for the quick stats page to come up? Your database must be large and it is doing things that would only be sped up by adding indexes. These indexes would cause the user side of the forum to become slower so you have to suffer :)

[Xer]

working on my 2.2.9 ..thx!

[Raptor]

works great on 2.2.9

http://digital-forums.com/forum/images/stats.gif

[Doubledoom]

thank you. very simple to install and is working fine on 2.3.0

[yousuf]

sweet hack thanx dude i installed on 2.2.9

[Dras]

Great addon! This saves me lots of time to find out my DB usuage and such!

[msimplay]

excellent hack :D

[Dras]

Great Hack, Works on 2.3.0

[Josh Combs]

Great Hack!

[Rampag33]

installed vb 232
works perfectly, great hacc

[Josh Combs]

I am wondering if there is some way to incorperate how many members are on the forums into this feature?

[Rampag33]

I am wondering if there is some way to incorperate how many members are on the forums into this feature?

That's already on the admin cp. Infact that's on the same page as the original hacc. Look not even an inch under the hacc.

[Josh Combs]

no I am sorry I mean the total registered members on the whole forum.

[Josh Combs]

I figured it out :) I know it isn't much but I am proud of my self :)

in admin/index.php go to line 133: and paste this underneath it:
$numbersmembers=$DB_site->query_first('SELECT COUNT(*) AS users,MAX(userid) AS max FROM user');
$numbermembers=number_format($numbersmembers['users']);


and down on line 193: paste this underneath it
makelabelcode('Total Members in DB:', $numbersmembers['users']);

[Josh Combs]

here is a shot of my admin quick stats with some modifications :)

[ElmGoodie]

i installed it... nice hack :)