The Arcive of vBulletin Modifications Site.

AdminCP Quick Stats Improvement · **Released**: 07-04-2015

Improved AdminCP Quick Stats:

In admincp/index.php

CHANGE LINE 21 FROM:

Code:

$specialtemplates = array('maxloggedin', 'acpstats');

TO:

Code:

$specialtemplates = array('maxloggedin');

CHANGE LINE 177-179 FROM: (adds "New Window" link at top of AdminCP)

Code:

			<a href="<?php echo $forumhomelink; ?>" target="_blank"><?php echo $vbphrase['forum_home_page']; ?></a>
			|
			<a href="index.php?<?php echo $vbulletin->session->vars['sessionurl']; ?>do=cplogout" onclick="return confirm('<?php echo $vbphrase['sure_you_want_to_log_out_of_cp']; ?>');"  target="_top"><?php echo $vbphrase['log_out']; ?></a>
		</td>

TO:

Code:

			<a href="../<?php echo $vbulletin->options['forumhome']; ?>.php<?php echo $vbulletin->session->vars['sessionurl_q']; ?>" ><?php echo $vbphrase['forum_home_page']; ?></a>
			|
			<a href="../<?php echo $vbulletin->options['forumhome']; ?>.php<?php echo $vbulletin->session->vars['sessionurl_q']; ?>" target="_blank">Forum Home (new window)</a>
			|
			<a href="index.php?<?php echo $vbulletin->session->vars['sessionurl']; ?>do=cplogout" onclick="return confirm('<?php echo $vbphrase['sure_you_want_to_log_out_of_cp']; ?>');"  target="_top"><?php echo $vbphrase['log_out']; ?></a>
		</td>

FIND THIS STARTING AT LINE 817:

Code:

// ##### Messages to Moderate
$messagecount = $db->query_first("
	SELECT COUNT(*) AS count
	FROM " . TABLE_PREFIX . "moderation AS moderation
	INNER JOIN " . TABLE_PREFIX . "visitormessage AS visitormessage ON (visitormessage.vmid = moderation.primaryid)
	WHERE moderation.type = 'visitormessage'
");

$mailqueue = $vbulletin->db->query_first("
	SELECT COUNT(mailqueueid) AS queued FROM " . TABLE_PREFIX . "mailqueue
");

REPLACE WITH THIS:

Code:

// ##### Messages to Moderate
$messagecount = $db->query_first("
	SELECT COUNT(*) AS count
	FROM " . TABLE_PREFIX . "moderation AS moderation
	INNER JOIN " . TABLE_PREFIX . "visitormessage AS visitormessage ON (visitormessage.vmid = moderation.primaryid)
	WHERE moderation.type = 'visitormessage'
");

// ##### Server Load
if ($_REQUEST['show'] == 'serverload' || empty($_REQUEST['show'])) {
	$loadavg = @file_get_contents("/proc/loadavg");
	$method = '';
	if ($loadavg) {
		$regs = explode(" ",$loadavg);
		$serverload='Server Loads: <b>' . $regs[0] .'</b> ' . $regs[1] . ' : ' . $regs[2];
		$method = 'file_get_contents("/proc/loadavg")';
    } elseif ( $stats = @exec('uptime') ) {
        preg_match('/averages?: ([0-9\.]+),[\s]+([0-9\.]+),[\s]+([0-9\.]+)/',$stats,$regs);
        $serverload = '<b>Server Load:</b> ' . $regs[0] .' <font size="1">(1 min, 5 min, 15 min)</font>';
		$method = 'exec(uptime)';
	} else {
		$serverload = 'failed';
	}


	};

// ##### Users Online	
	$datecut = TIMENOW - $vbulletin->options['cookietimeout'];
	$guestsarry = $db->query_first("SELECT COUNT(host) AS sessions FROM " . TABLE_PREFIX . "session WHERE userid = 0 AND lastactivity > $datecut");
	$membersarry = $db->query_read("SELECT DISTINCT userid FROM " . TABLE_PREFIX . "session WHERE userid <> 0 AND lastactivity > $datecut");
	$guests = intval($guestsarry['sessions']);
	$members = intval($db->num_rows($membersarry));

$mailqueue = $vbulletin->db->query_first("
	SELECT COUNT(mailqueueid) AS queued FROM " . TABLE_PREFIX . "mailqueue
");

FIND IN LINE 868: (reorganizes stats and adds additional stats)

Code:

	print_cells_row(array(
		$vbphrase['mysql_max_packet_size'], vb_number_format($maxpacket, 2, 1),
		$vbphrase['new_posts_today'], vb_number_format($vbulletin->acpstats['newposts']),
		$vbphrase['queued_emails'], vb_number_format($mailqueue['queued'])
	), 0, 0, -5, 'top', 1, 1);
}
else
{

REPLACE WITH:

Code:

	print_cells_row(array(
		$vbphrase['mysql_max_packet_size'], vb_number_format($maxpacket, 2, 1),
		$vbphrase['users_online'], construct_phrase($vbphrase['x_y_members_z_guests'], vb_number_format($guests + $members), vb_number_format($members), vb_number_format($guests)),
		$vbphrase['new_posts_today'], vb_number_format($vbulletin->acpstats['newposts'])
	), 0, 0, -5, 'top', 1, 1);
	print_cells_row(array(
		'vBulletin Software Version', $vbulletin->options['templateversion'],
		'Server Load (1 min, 5 min, 15 min)', $loadavg = '' . $regs[1] .'  |  '. $regs[2] .'  |  '. $regs[3] .'',
		$vbphrase['queued_emails'], vb_number_format($mailqueue['queued'])
	), 0, 0, -5, 'top', 1, 1);
}
else
{

FIND IN LINE 910/911: (Adds Memory Usage data block)

Code:

print_table_footer();
($hook = vBulletinHook::fetch_hook('admin_index_main1')) ? eval($hook) : false;

REPLACE WITH:

Code:

print_table_footer();
if ($_REQUEST['show'] == 'memoryusage' || empty($_REQUEST['show'])) {
	print_form_header('', '');
	exec('free -m', $mem);
	print_table_header('Memory Usage');print_description_row('<pre>'.implode('<br />', $mem).'</pre>');
	print_table_footer();
	}
($hook = vBulletinHook::fetch_hook('admin_index_main1')) ? eval($hook) : false;

FIND IN LINE 1020:

Code:

				'http://www.vbulletin.com/docs/html/' => $vbphrase['reference_manual']

PLACE THIS DIRECTLY BELOW IT: (Adds vbulletin.org in the quick links)

Code:

				'http://www.vbulletin.org/' => 'vBulletin.org'

Add the attached file (server_info.php) to your AdminCP folder. (Edit line 116 to include your database information: "localhost", "dbuser", "dbpassword", "dbname")

See attached images for the enhancements.

Enjoy!

Manoel J?nior · #2 07-08-2015, 12:53 AM

Love this. Please plugin this.

Alan_SP · #3 07-08-2015, 06:08 PM

It can't be done. It requires editing files.

Plugins can do some useful staff, but can't touch files.

Darkman7030 · #4 07-17-2015, 09:09 PM

Can you help me vb 4.2.0?

Falcon Capt · #5 07-17-2015, 09:36 PM

Quote:

Originally Posted by Darkman7030

Can you help me vb 4.2.0?

Looks like you may have forgetten to add this part:

Code:

*************************************


FIND IN LINE 817:



// ##### Messages to Moderate

$messagecount = $db->query_first("

	SELECT COUNT(*) AS count

	FROM " . TABLE_PREFIX . "moderation AS moderation

	INNER JOIN " . TABLE_PREFIX . "visitormessage AS visitormessage ON (visitormessage.vmid = moderation.primaryid)

	WHERE moderation.type = 'visitormessage'

");




And place this directly after:


// ##### Server Load
if ($_REQUEST['show'] == 'serverload' || empty($_REQUEST['show'])) {
	$loadavg = @file_get_contents("/proc/loadavg");
	$method = '';
	if ($loadavg) {
		$regs = explode(" ",$loadavg);
		$serverload='Server Loads: <b>' . $regs[0] .'</b> ' . $regs[1] . ' : ' . $regs[2];
		$method = 'file_get_contents("/proc/loadavg")';
    } elseif ( $stats = @exec('uptime') ) {
        preg_match('/averages?: ([0-9\.]+),[\s]+([0-9\.]+),[\s]+([0-9\.]+)/',$stats,$regs);
        $serverload = '<b>Server Load:</b> ' . $regs[0] .' <font size="1">(1 min, 5 min, 15 min)</font>';
		$method = 'exec(uptime)';
	} else {
		$serverload = 'failed';
	}


	};

// ##### Users Online	
	$datecut = TIMENOW - $vbulletin->options['cookietimeout'];
	$guestsarry = $db->query_first("SELECT COUNT(host) AS sessions FROM " . TABLE_PREFIX . "session WHERE userid = 0 AND lastactivity > $datecut");
	$membersarry = $db->query_read("SELECT DISTINCT userid FROM " . TABLE_PREFIX . "session WHERE userid <> 0 AND lastactivity > $datecut");
	$guests = intval($guestsarry['sessions']);
	$members = intval($db->num_rows($membersarry));


**************************************

and this:

Code:

*************************************

FIND near Line 910:

print_table_footer();

($hook = vBulletinHook::fetch_hook('admin_index_main1')) ? eval($hook) : false;


REPLACE WITH:


print_table_footer();
if ($_REQUEST['show'] == 'memoryusage' || empty($_REQUEST['show'])) {
	print_form_header('', '');
	exec('free -m', $mem);
	print_table_header('Memory Usage');print_description_row('<pre>'.implode('<br />', $mem).'</pre>');
	print_table_footer();
	}
($hook = vBulletinHook::fetch_hook('admin_index_main1')) ? eval($hook) : false;


*************************************

Darkman7030 · #6 07-17-2015, 09:47 PM

Yes done everything exactly
here is my index.php have tried everything without success

Falcon Capt · #7 07-17-2015, 10:06 PM

Try this one, it is the full AdminCP index.php file minus the header and footer, just cut and paste it into yours and see if it works.

Let me know!

Darkman7030 · #8 07-17-2015, 10:28 PM

Unfortunately it did not work

Falcon Capt · #9 07-17-2015, 10:33 PM

Quote:

Originally Posted by Darkman7030

Unfortunately it did not work

Must be something with 4.2.0, if you upgrade to 4.2.2 or 4.2.3 it'll work.

Darkman7030 · #10 07-23-2015, 06:29 AM

Quote:

Originally Posted by Falcon Capt

Must be something with 4.2.0, if you upgrade to 4.2.2 or 4.2.3 it'll work.

so have now update made to 4.2.3
but still it does not work still same error

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07703 seconds Memory Usage 4,817KB Queries Executed 24 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (14)bbcode_code (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (9)postbit (6)postbit_attachment (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end postbit_factory postbit_display_start fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages: