vb.org Archive - Admin Quick Stats

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Admin Quick Stats (https://vborg.vbsupport.ru/showthread.php?t=37193)

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

Here is what Opera Showed!

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 Code:


		
			
<?php



error_reporting(7);



require("./global.php");



cpheader();

and the bottom of the file add

PHP Code:


		
			
cpfooter();



?>

In admin/index.php find

PHP Code:


		
			
makenavoption("Back-up Database","backup.php?action=choose","<br>");

above it add

PHP Code:


		
			
makenavoption("Database Stats","adminquickstats.php?action=","<br>");

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.

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

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.

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.

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.

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

Works bootyfully :D.

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.

Quote:

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:

Quote:

Originally posted by eiSecure
Isn't that the vB3 admin CP theme? :bunny:

No, that is just my own vb2 forum.

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

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

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

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

freddie, i install this hack. But don't see how thread's want moderates in your hack... Please help me.
:)
Please :)

Love the hack!

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

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

(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

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

@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

PHP Code:


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

add

PHP Code:


		
			
$changedthreads = $DB_site->query_first("SELECT count(*) AS count FROM thread WHERE lastpost >= $starttime");

after freddie's

PHP Code:


		
			
makelabelcode('New Threads Today:', $newthreads['count']);

add

PHP Code:


		
			
makelabelcode('Modified Threads Today:', $changedthreads['count']-$newthreads['count']);

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

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

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

New Threads Today: 8605
Modified Threads Today: -8553

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

Working fine, well done :)

Here is my stats:

Quote:

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.

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

Code:

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

Very cool! Thanks :)

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?

nice stuff :) I will install

Nice hack freddie, works like a charm.

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

Great Hack :)

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

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:

Code:

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:

Code:

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

Code:

<?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. ;)

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

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

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

Quote:

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.

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

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01282 seconds Memory Usage 1,842KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_code_printable (8)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: