vBMicrostats

[TECK]

Finally, the vBMicroStats product for vBulletin 3.5.4 is here. :)
The previous versions of my mod were very solicited by vBulletin administrators...
I hope you will enjoy this new version as much you did the other ones.

Looking for VB 3.6.x version? It is here (https://vborg.vbsupport.ru/showthread.php?t=140449).

This mod with add at the bottom of each vBulletin (powered) page, the statistics listed below.
Also, it will help you troubleshoot and optimize your vBulletin board by viewing or comparing PHP/MySQL options and other statistics that are normally hidden in your forum pages.

Regular Users:
? Load time of specified page in microseconds
? Number of queries executed
? PHP percent page usage
? MySQL percent page usage

Administrators Only:
? Server memory usage per page (in Kb)
? DEBUG mode status
? Browser GZIP library compression status
? Server average loads (http://www.vbulletin.com/forum/showthread.php?action=showpost&postid=291831)
? Uncached templates (useful to troubleshoot the code)

The code modifications listed below were tested into a clean installed vBulletin board. They work 100%.
If you encounter any problems, feel free to post your questions here.

Step by step install instructions are posted into vbmicrostats.html file.
In order to perform an efficient modification of your files, I recommend you to use Dreamweaver (Coder Mode) or Textpad.
Both editors will allow you to complete all steps without any coding errors.

I tried to use the plugin system as much as I could, in order to avoid any unnecessary code modifications.
In order to set the right query execution time, you will need to perform 2 small code changes to each of the following files:
? class_core.php (folder /includes)
? init.php (folder /includes)

The code changes are very safe and designed not to interfere in any way with the vBulletin performance/functionality.
Make sure you modify, save and upload one file at the time to your server.
Then, simply run the product-plugin_vbmicrostats.xml file.

Once the product installed, don't forget to enable it.
Go to your vBulletin Options, click on BB MicroStats setting group and set all your options.

[TECK]

Division by Zero? View the fix (https://vborg.vbsupport.ru/showpost.php?p=999465&postcount=155).
Negative results? View the fix (https://vborg.vbsupport.ru/showpost.php?p=989193&postcount=123). I'm waiting a response from vBulletin Team (http://www.vbulletin.com/forum/bugs35.php?do=view&bugid=2481), for a better fix.
Stats not showing in PhotoPost? View the fix (https://vborg.vbsupport.ru/showpost.php?p=1005066&postcount=196).
Stats only for Administrators? View the fix (https://vborg.vbsupport.ru/showpost.php?p=1008083&postcount=195).

Also, if you get results like:
Page generated in 3.35731196 seconds (9.05% PHP - 90.95% MySQL) with 30 queries
every time you refresh your php page, you probably use a bad piece of code.
vBulletin will never generate those extreme results.
Imagine this: the code uses only 10% the resources to read the actual PHP code and the rest of 90% is used only to scan the tables... WOW!
That means the code forces to read into the database for each user who visits the site at this percentage... if you have 1000 users viewing the page in the same time.. you can get a picture of it...
If you compare this with vBulletin, the software does the opposite, 90% PHP and 10% MySQL... the right way.

[The Chief]

awesome, I'll check it out :)

[Boofo]

Excellent work, sir. Been waiting for this. And welcome back! ;)

[Kaleem]

awesome :)

[TECK]

Thank you Boofo (and all my vBFriends)! Good to be back in the house.
BTW, the VB3.5.4 code made me pull my hair few times, trickier then I thought... since it's so different from VB2.
Now, back to my vBlog product... :)

[Boofo]

Thank you Boofo (and all my vBFriends)! Good to be back in the house.
BTW, the VB3.5.4 code made me pull my hair few times, trickier then I thought... since it's so different from VB2.
Now, back to my vBlog product... :)

The new code and ways of doing things will do that at first but once you get used to it, it is better than you thought it could ever be. ;)

I will suggest downloading and installing mtha's Advanced Product Manger though. It is the only thing to use for putting hacks together. Everything all in one place to work with. You won't regret it. ;)

[DementedMindz]

ok question mine dont center and it makes a table... check the screen shot out.. also is there anyway to make it display like this mod does https://vborg.vbsupport.ru/showthread.php?t=82900 at the bottom of the footer without the table?

[firstimecaller]

hmmm. all code mods installed, double checked, template modified, enabled, shows up on page, but no value for time displayed
Page generated in seconds (85.50% PHP - 14.50% MySQL) with 10 queries

[DementedMindz]

i was just getting ready to say the same thing lol

[TECK]

Your request is simple to fill. :)

There is a template, hidden in the plugin code. It's the best/fastest way to load it, plus it does eliminate other extra code modifications in files.
All you have to do is edit the following code, present in your vBMicroStats Global Hook plugin:
$ms_output = '<tr align="' . $stylevar['right'] . '">' . "\n";
$ms_output .= ' <td class="tcat"' . iif($show['quickchooser'] OR $show['languagechooser'], ' colspan="' . $colspan . '"') . '>' . "\n";
$ms_output .= ' <span class="smallfont">Page generated in ' . $total_time . ' seconds (' . $php_percent . ' - ' . $sql_percent . ') with ' . $query_count . ' queries</span>' . "\n";
$ms_output .= ' </td>' . "\n";
$ms_output .= '</tr>' . "\n";

[... more code here, don't edit ...]

$ms_output .= '<tr align="' . $stylevar['right'] . '">' . "\n";
$ms_output .= ' <td class="alt1"' . iif($show['quickchooser'] OR $show['languagechooser'], ' colspan="' . $colspan . '"') . '>' . "\n";
$ms_output .= ' <span class="smallfont">' . $memory_status . $debug_status . $gzip_status . $server_status . $templates_status . '</span>' . "\n";
$ms_output .= ' </td>' . "\n";
$ms_output .= '</tr>' . "\n";
That's what makes the table rows you saw in my screenshots.
The first code segment will set the regular user options, the second will take care of the administrator ones.
If you edit this html code the way you like it, you will obtain the result you want.

BTW, you can place the code:
<if condition="$show['microstats']">{microstats}</if>
anywhere you want, in your templates. :)

EDIT: The best way to edit the plugin code is to copy it all and paste it into your favorite editor.
Do all html changes, then paste it back and save it.

[TECK]

hmmm. all code mods installed, double checked, template modified, enabled, shows up on page, but no value for time displayed
My bad, little typo in the code. :)
Open the vBMicroStats Global Hook plugin and find this code:
Page generated in ' . $totaltime . ' seconds
Replace it with:
Page generated in ' . $total_time . ' seconds
Sorry guys. I will upload the new version in a few moments...

[firstimecaller]

Thanks for sharing this TECK!

[TECK]

Version 1.0.1 released. Bug fixed.
You can uninstall/install the plugin if you like, instead of editing the code.

[Boofo]

I'm nor seeing anything for some reason. I dounble checked everything but nothing shows up. And it is all turned on.

EDIT: My fault. I added it to the wrong skin. Sorry. ;)

[Boofo]

Teck, is there any way to edit the html code for this so that it will make sense to us html dummies? I can't get it looking right on my site and I'm not sure what to do to fix it.

[TECK]

Sure, Bobby. :)
I will post an example here... in few minutes.

[Boofo]

Sure, Bobby. :)
I will post an example here... in few minutes.

Now that's what I call service. Thank you, sir. ;)

Here's my site URL so you can see my problem:

Fathers' Rights Forums (http://www.bearfacts2.com/forum/)

[DementedMindz]

yeah im playin with it to but im going crazy lol i have it where it centers the text but not the table... or i try and remove the table and the text goes poof

[DementedMindz]

also i see you have..
$ms_output = '<tr align="' . $stylevar['center'] . '">' . "\n";

now if i make it $ms_output = '<tr align="center">' . "\n"; is there any down fall? cause that makes it 100% html complaint... there is 2 spots where that is...

[TECK]

Ok, here it is an example:
$ms_output = '<span class="smallfont">';
$ms_output .= 'Page generated in ' . $total_time . ' seconds (' . $php_percent . ' - ' . $sql_percent . ') with ' . $query_count . ' queries';
$ms_output .= '</span><br />' . "\n";

[... code here, don't edit ...]

$ms_output .= '<span class="smallfont">';
$ms_output .= $memory_status . $debug_status . $gzip_status . $server_status . $templates_status;
$ms_output .= '</span>' . "\n";
The mod will remove the table rows and display it as 2 regular text lines.
If you want the $ms_output template code even simplier, use this:
$ms_output = 'Page generated in ' . $total_time . ' seconds (' . $php_percent . ' - ' . $sql_percent . ') with ' . $query_count . ' queries<br />';

[... code here, don't edit ...]

$ms_output .= $memory_status . $debug_status . $gzip_status . $server_status . $templates_status;
Then you can simply play with the regular template code:
<if condition="$show['microstats']">{microstats}</if>
the way you like it.
For example, to make your two new lines centered, use this:
<if condition="$show['microstats']">
<div style="text-align: center;">{microstats}</div>
</if>
Let me know if I was clear...
If you have any other questions, go ahead and post them. :)

[EasyTarget]

is there a way to track down which hacks are the troublesome ones using this?

[DementedMindz]

much easier thank you

[TECK]

Bob, I looked at your site, it looks fine?
If you want to place the microstats after the vBulletin copyright (for example), use my second $ms_output template, listed above.

[TECK]

much easier thank you
Now, post a better explained tutorial, since you done it.
And a screenshot. :)

[DementedMindz]

one sec im just moving around the text lol tryin to see where it looks best

[TECK]

is there a way to track down which hacks are the troublesome ones using this?
Unfortunatelly no. vBMicroStats analyses the php page in ensemble, then spits the results.
However, there is a tricky way to see what's the "bad" mod in your source.
You need to enable only one mod at the time. Then simply view your pages with the specific mod enabled/disabled.

Compare your stats between the original vBulletin unmodded page and the one with the mod enabled. You will notice rightaway and erratic number of extra queries or abnormal percentages.... and complain to the mod creator. :)

That's why the users loved so much vBMicroStats, it was the first mod that told you what's really going on with your PHP code...
If you find a better way, please share it with the users here.

[DementedMindz]

ok quick question here is what i have so far...

if ($vbulletin->options['vb_mstats_active'])
{
$colspan = 1;
if ($show['quickchooser'])
{
$colspan++;
}
if ($show['languagechooser'])
{
$colspan++;
}

$page_endtime = microtime();
$start_time = explode(' ', $pagestarttime);
$end_time = explode(' ', $page_endtime);
$total_time = vb_number_format($end_time[0] - $start_time[0] + $end_time[1] - $start_time[1], $vbulletin->options['vb_mstats_decimal']);

$query_time = $vbulletin->db->mstime_total;
$query_count = $vbulletin->db->querycount;

$php_percent = vb_number_format(((($total_time - $query_time) / $total_time) * 100), 2) . '% PHP';
$sql_percent = vb_number_format((($query_time / $total_time) * 100), 2) . '% MySQL';

$ms_output .= ' <span class="smallfont">Page generated in ' . $total_time . ' seconds (' . $php_percent . ' - ' . $sql_percent . ') with ' . $query_count . ' queries</span>' . "\n";

if ($vbulletin->options['vb_mstats_adminactive'] AND $vbulletin->userinfo['usergroupid'] == 6)
{
$memory_status = '';
if ($vbulletin->options['vb_mstats_memory'])
{
if (!function_exists('memory_get_usage'))
{
function memory_get_usage()
{
$mem_output = array();
if (strtolower(substr(PHP_OS, 0, 3)) == 'win')
{
exec('tasklist /FI "PID eq ' . getmypid() . '" /FO LIST', $mem_output);
return preg_replace( '/[^0-9]/', '', $output[5] ) * 1024;
}
else
{
$pid = getmypid();
exec("ps -eo%mem,rss,pid | grep $pid", $mem_output);
$mem_output = explode(' ', $mem_output[0]);
return $mem_output[1] * 1024;
}
}
}
$memory_status = vb_number_format((memory_get_usage() / 1024), 2) . 'KB Used | ';
}

$debug_status = '';
if ($vbulletin->options['vb_mstats_debug'])
{
$debug_status = 'DEBUG Mode OFF | ';
if ($vbulletin->debug)
{
$debug_status = 'DEBUG Mode ON | ';
}
}

$gzip_status = '';
if ($vbulletin->options['vb_mstats_gzip'])
{
$gzip_status = 'GZIP OFF | ';
if ($vbulletin->options['gzipoutput'] AND !$vbulletin->nozip)
{
$gzip_status = 'GZIP ON (level ' . $vbulletin->options['gziplevel'] . ') | ';
}
}

$server_status = '';
if ($vbulletin->options['vb_mstats_server'])
{
if ($stats = @exec('uptime 2>&1') AND trim($stats) != '' AND preg_match("#: ([\d.,]+),?\s+([\d.,]+),?\s+([\d.,]+)$#", $stats, $regs))
{
$regs[1] = vb_number_format($regs[1], 2);
$regs[2] = vb_number_format($regs[2], 2);
$regs[3] = vb_number_format($regs[3], 2);
$server_status = '<strong>' . $regs[1] . '</strong> : ' . $regs[2] . ' : ' . $regs[3] . ' | ';
}
}

$templates_status = '';
if ($vbulletin->options['vb_mstats_templates'])
{
$templates_status = 'NO Uncached Templates';
if ($_TEMPLATEQUERIES)
{
$templates_status = '<select class="smallfont" size="1">' . "\n";
$templates_status .= '<optgroup label="Uncached Templates: ' . sizeof($_TEMPLATEQUERIES) . '">' . "\n";
if (is_array($tempusagecache))
{
global $vbcollapse;

ksort($tempusagecache);
foreach ($tempusagecache AS $tempname => $times)
{
if ($_TEMPLATEQUERIES["$tempname"])
{
$templates_status .= '<option class="alt2" selected="selected">' . $tempname . ' (' . $times . ')</option>' . "\n";
}
else
{
$templates_status .= '<option>' . $tempname . ' (' . $times . ')</option>' . "\n";
}
}
}
$templates_status .= '</optgroup>' . "\n";
$templates_status .= '</select>';
}
}
$ms_output .= '<tr align="' . $stylevar['right'] . '">' . "\n";
$ms_output .= ' <td class="alt1"' . iif($show['quickchooser'] OR $show['languagechooser'], ' colspan="' . $colspan . '"') . '>' . "\n";
$ms_output .= ' <span class="smallfont">' . $memory_status . $debug_status . $gzip_status . $server_status . $templates_status . '</span>' . "\n";
$ms_output .= ' </td>' . "\n";
$ms_output .= '</tr>' . "\n";
}

$output = str_replace('{microstats}', $ms_output, $output);
}


ok now when i remove the bottom table it all groups in one line... im tryin to keep it 2 lines like you have it but when i remove the admins alt1
$ms_output .= ' <td class="alt1"' . iif($show['quickchooser'] OR $show['languagechooser'], ' colspan="' . $colspan . '"') . '>' . "\n";
thats when it all groups where should i add a break?

[Boofo]

Bob, I looked at your site, it looks fine?
If you want to place the microstats after the vBulletin copyright (for example), use my second $ms_output template, listed above.

Here's what I see.

EDIT: Ok, I now see what you mean. Am working on it now. Thank you, sir. ;)

[DementedMindz]

here is my screen shot so far of what i have going on... just tryin to figure out the admin table now

[DementedMindz]

here is what i mean if i remove the admin table the alt1 it groups both lines into one...

[TECK]

Bob, post here the actual html code from the page source, not footer template. Start from the beginning of microstats code to the end of footer.
I will fix it, something is wrong with the row colspan, in my mod.

[EasyTarget]

working good for me, though if I view the same exact page without any changes sometimes I'll get php close to 90% and every once in awhile I'll get the sql at like 70%.

[TECK]

here is my screen shot so far of what i have going on... just tryin to figure out the admin table now
Patience, you are almost there ... :)
First segment of code is ok, but try this instead.
Find:
$ms_output .= ' <span class="smallfont">Page generated in ' . $total_time . ' seconds (' . $php_percent . ' - ' . $sql_percent . ') with ' . $query_count . ' queries</span>' . "\n";
Replace it with:
$ms_output .= 'Page generated in ' . $total_time . ' seconds (' . $php_percent . ' - ' . $sql_percent . ') with ' . $query_count . ' queries<br />';
Next, find:
$ms_output .= '<tr align="' . $stylevar['right'] . '">' . "\n";
$ms_output .= ' <td class="alt1"' . iif($show['quickchooser'] OR $show['languagechooser'], ' colspan="' . $colspan . '"') . '>' . "\n";
$ms_output .= ' <span class="smallfont">' . $memory_status . $debug_status . $gzip_status . $server_status . $templates_status . '</span>' . "\n";
$ms_output .= ' </td>' . "\n";
$ms_output .= '</tr>' . "\n";
Replace it with:
$ms_output .= $memory_status . $debug_status . $gzip_status . $server_status . $templates_status;
Then, use this code in your footer template:
$vbphrase[powered_by_vbulletin]<if condition="$show['microstats']"><br />
{microstats}</if>

[Mr Chad]

Patience, you are almost there ... :)
First segment of code is ok, but try this instead.
Find:
$ms_output .= ' <span class="smallfont">Page generated in ' . $total_time . ' seconds (' . $php_percent . ' - ' . $sql_percent . ') with ' . $query_count . ' queries</span>' . "\n";
Replace it with:
$ms_output .= 'Page generated in ' . $total_time . ' seconds (' . $php_percent . ' - ' . $sql_percent . ') with ' . $query_count . ' queries<br />';
Next, find:
$ms_output .= '<tr align="' . $stylevar['right'] . '">' . "\n";
$ms_output .= ' <td class="alt1"' . iif($show['quickchooser'] OR $show['languagechooser'], ' colspan="' . $colspan . '"') . '>' . "\n";
$ms_output .= ' <span class="smallfont">' . $memory_status . $debug_status . $gzip_status . $server_status . $templates_status . '</span>' . "\n";
$ms_output .= ' </td>' . "\n";
$ms_output .= '</tr>' . "\n";
Replace it with:
$ms_output .= $memory_status . $debug_status . $gzip_status . $server_status . $templates_status;
Then, use this code in your footer template:
$vbphrase[powered_by_vbulletin]<if condition="$show['microstats']"><br />
{microstats}</if>
where are you putting this code?

[DementedMindz]

lol i just got it before i refreshed the page lol thank you very much here is my code in my vBMicroStats Global Hook if anyone wants it like this hope you dont mind if so ill remove it.... just remember members only see the top code not the bottom one...

also i placed my <if condition="$show['microstats']">{microstats}</if> in the copyright part of the footer like this

<div align="center">
<div class="smallfont" align="center">
<!-- Do not remove this copyright notice -->
<br />
$vbphrase[powered_by_vbulletin]
<br />
<!-- Do not remove this copyright notice -->
</div>

<div class="smallfont" align="center">
<!-- Do not remove $cronimage or your scheduled tasks will cease to function -->
$cronimage
<!-- Do not remove $cronimage or your scheduled tasks will cease to function -->

$vboptions[copyrighttext]
<if condition="$show['microstats']">{microstats}</if>
</div>
</div>

[TECK]

working good for me, though if I view the same exact page without any changes sometimes I'll get php close to 90% and every once in awhile I'll get the sql at like 70%.
Something is wrong with a mod installed, probably. :)
MySQL is a very smart language. If you run a query for the first time, it will execute it and also store it in the memory, in case you will need to perform it again. That saves server resources.
If you don't use it for a certain period of time, the process is dumped automatically.

This is where you see the critical points in your PHP pages. If every time you load a new page that have wierd mods enabled, MicroStats will warn you with the actual results, creating rightaway a question mark in your mind about the quality of the code you installed.

The best way to see what are the "clean" results of your PHP/MySQL code is to install MicroStats into an unmodded vBulletin test board. Then you can compare the clean results with your board results...

[TECK]

just remember members only see the top code not the bottom one...
Hmm 24 queries? That's a lot! vBulletin have only 9 queries on the main page.
Watch the server load, it's close to the sky. The bold numbers should not be higher then 1.00, yours are over 3.00.
Are you on a shared server? If you are, contact your host and let them know.
Someone is eating a lot of CPU there...

[DementedMindz]

lol im doing a backup thats why... but the queries you are seeing is from my vbadvanced page...

[TECK]

where are you putting this code?
The $ms_output code you place it into your vBMicroStats Global Hook plugin.
The second, into your footer template, or any other template you like. ;)

[TECK]

lol im doing a backup thats why... but the queries you are seeing is from my vbadvanced page...
I remember how many members complained about the high number of queries present into this portal.
Well, you are lucky that you have only 24, even if this is extremly high.
I saw people running over 100 queries on a page and asked why their server was shutdown...

Read more here, on my first version:
https://vborg.vbsupport.ru/showthread.php?t=35811
That will explain also why the file edits are needed...

LOL, VB2... Check the screenshot. Wow. They used to have 17 queries on the frontpage.
Things changed a lot... Much better now. :)
Haha, read this post:
https://vborg.vbsupport.ru/showpost.php?p=227383&postcount=54
Version 1.2 has problems with vBPortal...
Shows the message under every Block on vBPortal!!!

Any solution for that?

And shows me 199 queries!!! mmmm
Holly crap! 199 babies on the roll...

[Boofo]

Bob, post here the actual html code from the page source, not footer template. Start from the beginning of microstats code to the end of footer.
I will fix it, something is wrong with the row colspan, in my mod.

That's ok, I got it showing for now at least. I won't waste and more of your time tonight with it but if you do get some free time in the next few days I would like to have the code in the original spot, with the table fixed. ;)

And thanks for bringing back memories with this update, Floren. I really needed it right now. ;)

[TECK]

Go ahead and post it, I need it because I want to fix the colspan bug.
Thanks Bobby.

[Mr Chad]

The $ms_output code you place it into your vBMicroStats Global Hook plugin.
The second, into your footer template, or any other template you like. ;)
lol yea i messed up, first time i was looking at the plugins it clicked the same one twice and didnt see any of the code you were talking about :P

[Boofo]

Go ahead and post it, I need it because I want to fix the colspan bug.
Thanks Bobby.

You want access to the Admin CP so you can play with it?

[TECK]

Is Ok, I see where is the problem.
Working on it as we speak.

[Boofo]

Is Ok, I see where is the problem.
Working on it as we speak.

Boy that was quick! LOL

[packetattack]

I've edited the files multiple times and I keep getting this persistent error after I upload them back up the server.

Parse error: parse error, unexpected T_CLASS, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /home/packetattack/forums.nycmaximas.org/html/includes/class_core.php on line 989. I keep redoing the files to no avail.

I'm using UltraEdit 32 and uploading the files in ASCII mode.

I check line 989 and this is what I have:

985: * @package vBulletin
986:* @version $Revision: 1.183.2.9 $
987:* @date $Date: 2006/02/09 17:44:52 $
988:*/
989:class vB_Database_MySQLi extends vB_Database
990:{
991: /**
992: * Array of function names, mapping a simple name 993:to the RDBMS specific function name
994: *
995: * @var array
996: */

[Boofo]

Floren, would it be easier to see the problem first hand on the site in the Admin CP? The skin itself might be causing it.

[sensimilla]

Hmmm... I did it twice step by step and its looking like this...
Any ideas ? TIA

[Boofo]

Hmmm... I did it twice step by step and its looking like this...
Any ideas ? TIA

Floren is working on the column span problem now. ;)

[TECK]

Problem fixed, version 1.0.2 released. The colspan increments were not working properly, so the table looked broken...
This upgrade is for those who want to use the original/unmodified template code.
Uninstall old version and re-install the new one. You only need to run the plugin, no other changes are needed. Don't you love vBulletin?

Enjoy.

For the teckies who want to know exacly what I did. This is the added code segment:
$colspan = 1;
$language_count = 0;
$style_count = 0;
$style_id = -1;

if ($vbulletin->languagecache === null)
{
$vbulletin->languagecache = array();
}

foreach ($vbulletin->languagecache AS $language)
{
if ($language['userselect'])
{
$language_count++;
}
}

if ($language_count > 0)
{
$colspan++;
}

if ($vbulletin->options['allowchangestyles'])
{
if (is_array($vbulletin->stylecache["$style_id"]))
{
$style_cache =& $vbulletin->stylecache["$style_id"];
}
else if (is_array($vbulletin->stylecache[$style_id]))
{
$style_cache =& $vbulletin->stylecache[$style_id];
}
else
{
return;
}

foreach ($style_cache AS $x)
{
foreach ($x AS $style)
{
if ($style['userselect'] OR $vbulletin->userinfo['permissions']['adminpermissions'] AND $vbulletin->bf_ugp_adminpermissions['cancontrolpanel'])
{
$style_count++;
}
}
}

if ($style_count > 1)
{
$colspan++;
}
}

$show['colspan'] = iif($language_count > 0 OR $style_count > 1, true, false);

[Boofo]

Yes indeedy! Works like a charm. Just need to center it and do a tfoot instead of tcat and we are all set. Thank you, sir. You are still the Master to this old Grasshopper. ;)

[TECK]

I've edited the files multiple times and I keep getting this persistent error after I upload them back up the server.

Parse error: parse error, unexpected T_CLASS, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}'
Use Textpad? :)
Unfortunatelly, I cannot post the hole functions, modified, vBulletin copyright policies, unless they changed their mind?
I wish I could help you more, but I cannot.
Try to contact one of the users who installed the mod successfully, to send you the edited files.

[Oblivion Knight]

Welcome back TECK, it's great to see this released for 3.5.x!

[derekivey]

Thanks for releasing a vB 3.5 version TECK! I will install it after school.

Derek

[Logikos]

What a great way to start your first released 3.5 hack! Welcome back.

/me clicks install

[Logikos]

Welp, I'm getting the following error.

Fatal error: Cannot redeclare mstimer_start() in c:\apache\www\demo\forums\includes\class_core.php on line 987


Here is class_core.php lines 983-1002

983 var $mstime_total = 0;
984 var $mstime_before = array();
985 var $msmemory_before = array();
986 function mstimer_start()
987 {
988 $this->mstime_before[] = microtime();
989 }
990 function mstimer_stop()
991 {
992 $mstime_after = microtime();
993 $mspage_start = explode(' ', TIMESTART);
994 $mspage_start = $mspage_start[0] + $mspage_start[1];
995 $mstime_before = explode(' ', array_pop($this->mstime_before));
996 $mstime_before = $mstime_before[0] + $mstime_before[1] - $mspage_start;
997 $mstime_after = explode(' ', $mstime_after);
998 $mstime_after = $mstime_after[0] + $mstime_after[1] - $mspage_start;
999 $mstime_taken = $mstime_after - $mstime_before;
1000
1001 $this->mstime_total += $mstime_taken;
1002 }

Any idea? I've tried 3x's before posting this.

[Boofo]

That's strange. It works great for me.

[bang]

a little hard to believe that a hack with this kind of functionality cannot avoid using file edits... :confused:

[Logikos]

In order to get the accurate results, file edits are necessary. I never have a problem editing files. We've all had to do it up untill 3.5.0. :p

[Dan]

Nice one TECK :) Was waiting for one like this.

[TECK]

In order to get the accurate results, file edits are necessary. I never have a problem editing files. We've all had to do it up untill 3.5.0. :p
Hi Ken, did you solved the problem?
You get an error like that if the mstimer_start is called twice...
Did you previously edited class_core.php or init.php for other mods?

The process is quite simple.
In init.php, at the top, you start the microtime clock, that's what function mstimer_start() does. Then you need the stop the clock at the bottom, with function mstimer_stop(). That's the reason you really need to edit the files, no hooks are present before or after the database connection, queries exec, etc.

In class_core.php, you simply insert those functions into the vB_Database MySQL and MySQLi class. They are called only once, depending on what type of SQL language you chosed.

I hope I was clear with my explanation. :)
Ken, please install the mod into an unmodded test board and let me know if the problem is solved.

BTW, thank you all for the warm welcome back. I really appreciate it. :)

[yonglvnv]

Just installed and works great in the forum section. However, in my photopost pages I'm seeing "{microstats} where the actual stats should be. Any ideas?

[TECK]

PhotoPost does not use the vBulletin $output, then?
This code line (in vBMicroStats Global Hook) should help you:
$output = str_replace('{microstats}', $ms_output, $output);
$output is the vBulletin html code output and $ms_output is the MicroStats one.
The code line listed above with search in the $output for the {microstats} string and replace it with the actual $ms_output html code.
Probably you have a mod installed that merges PhotoPost with vBulletin?
I'm not familiar with this software, so unfortunatelly I could not support it.
I wish I could help you more.

Maybe other members who have experience with PhotoPost could help you better.
I would post this question in the vB3.5 Modification Questions (https://vborg.vbsupport.ru/forumdisplay.php?f=111) forum.
It shouldn't be hard to fix your problem.

If you have an answer, please post it here so I can link it in the first post.
Thanks. :)

BTW, 27 installs in 12 hours? Thank you! It really means a lot to me.

[Logikos]

hmmm, it shows that you have updated your file since my last post. I'll give it another shot.

[DementedMindz]

BTW, 27 installs in 12 hours? Thank you! It really means a lot to me.


i think the mod is great thats why you see so many people installing it... but not only that your support is amazing...

[TECK]

Version 1.0.3 released. If you have a previous version installed, all you have to do is uninstall the old product and re-install the new one.
No other code modifications in files are needed.

The new version improves the UNIX/Win32 Server Memory option. If fixes 2 bugs.
First bug: Originally the code was piping the entire process list through grep.
Instead, we should search only for what we are interested in... done.
This was tested on a Linux RedHat server. It should work with any UNIX systems.
Let me know if you have any wierd errors on the page.

Second bug: I fixed another little bug related to the Win32 part of code.
This was tested on Win XP Pro SP2 with IIS. It should work also with Win2003 Server.

[Snake]

Man I have been waiting for this goodie from a very long time. Thank you very much, sir! :D

[Boofo]

Version 1.0.3 released. If you have a previous version installed, all you have to do is uninstall the old product and re-install the new one.
No other code modifications in files are needed.

The new version improves the UNIX/Win32 Server Memory option. If fixes 2 bugs.
First bug: Originally the code was piping the entire process list through grep.
Instead, we should search only for what we are interested in... done.
This was tested on a Linux RedHat server. It should work with any UNIX systems.
Let me know if you have any wierd errors on the page.

Second bug: I fixed another little bug related to the Win32 part of code.
This was tested on Win XP Pro SP2 with IIS. It should work also with Win2003 Server.

If we are using that stats below the copyright, do we use the same code in your post or has that changed now?

[TECK]

It's the same code, in the hook template. You can keep the same code Bob.
I don't want you guys to scream ... :)

Version 1.0.4 released.
By fixing the server memory bugs I created a new one. Way to go Floren!
Anyway, it's fixed. Do the same thing, simply uninstall the old product and install the new one. No other code modifications are needed.

[Boofo]

It's the same code, in the hook template. You can keep the same code Bob.
I don't want you guys to scream ... :)

And you know I will be the one screaming the loudest. ;)

Version 1.0.4 released.
By fixing the server memory bugs I created a new one. Way to go Floren!
Anyway, it's fixed. Do the same thing, simply uninstall the old product and install the new one. No other code modifications are needed.

Thank you, sir. Always a pleasure. ;)

[DementedMindz]

here we go ill update mine lets see how long this takes me again lol can i still use my same code from last night? or is there a bug in that code?

[TECK]

You keep the same hook template code you edited.
I'm not going to make you post another screenshot. :)

Guys, I need you to test this mod into an unmodded board and a server with APC or eAccelerator installed.
Let me know if you have any wierd errors.

[DementedMindz]

thank you

[TECK]

Let me know if the memory usage it's displaying 0 or 0.20... I think not every server likes it... we might need to go back to Grep.
I just test it into another UNIX server and it shows 0Kb. grrr...

[DementedMindz]

mine is showing 0.20KB Used....

[TECK]

With 1.0.4? Please post the mod version and the memory used value. Anyone else?

[DementedMindz]

yes thats with 1.0.4... 0.20KB Used

[Logikos]

I think because i'm testing this on mt localhost is what my problem is. I'll install on my live board and see what the reslults are.

[Boofo]

On 1.04 this is waht I'm seeing for the memory:

2,834.64KB Used

Is that right? ;)

[DementedMindz]

LOL i hope not you sure your seeing it right and its not the old age creepin up?

[Boofo]

well, since we only have 1 GB of memory on the server, it might be off a few points, I think. I might be old but I can still do math. ;)

[DementedMindz]

hmmm yeah i have a gig on mine and im only using 0.20KB Used and my forum is pretty active

[Boofo]

We must be running something different somewhere on our servers then. Hopefully, Teck will get it figured out. ;)

[Zia]

Its Nice.....we are currently using Microstats, that shows Server Load too.

Could it show the Server Load too ?

umm one more thing...any way to show Gzip stats Too ??

/me klicks install

[Boofo]

Its Nice.....we are currently using Microstats, that shows Server Load too.

Could it show the Server Load too ?

umm one more thing...any way to show Gzip stats Too ??

* Zia klicks install

This already does that. You just have to turn them on in the options for them to show. ;)

[Zia]

Thankx Boofo :)

[TECK]

We must be running something different somewhere on our servers then. Hopefully, Teck will get it figured out. ;)
Yes there is. The normal results are like the ones you have on your forum Bobby.
That's why I asked you guys about the server memory.
I will release a new version that will fix this problem.
Those who get results like .20KB are having the wrong stats. Only results like 2,928.45KB are good.
That's the memory used by vBulletin for the specific page.

[RemiAlone]

Hi there,

I'm having a problem with this plugin. I've installed the plugin and edited the .php pages and it works well for me and my registered users but the guests/not registered users keep getting a blank page. They can however still get to the photopost page and login there but registering is out of the question.

Do you've got any idea what i did wrong?

[Zia]

DementedMindz showed an attachment..

https://vborg.vbsupport.ru/attachment.php?attachmentid=47841&d=1148019441
here he putted an scrn shot......interested abt this one...could any one tell me..how could we do it..

tia...
waiting for reply..

[Boofo]

DementedMindz showed an attachment..

https://vborg.vbsupport.ru/attachment.php?attachmentid=47841&d=1148019441
here he putted an scrn shot......interested abt this one...could any one tell me..how could we do it..

tia...
waiting for reply..

This post in this thread explains how to make it text to be able to put it after the copyright info. I have mine just above the copyright, but did what was in the post here to be able to do that. Hope this helps. ;)

https://vborg.vbsupport.ru/showpost.php?p=980572&postcount=21

[DementedMindz]

DementedMindz showed an attachment..

https://vborg.vbsupport.ru/attachment.php?attachmentid=47841&d=1148019441
here he putted an scrn shot......interested abt this one...could any one tell me..how could we do it..

tia...
waiting for reply..


or you could just upload everything how its suppose to be and follow my post here...

https://vborg.vbsupport.ru/showpost.php?p=980616&postcount=36

i have the code i used and where i put it... screen shot is attached to show what it looks like

[Zia]

thnx..boofo & DementedMindz :)
it really helps..

Thnx. take care

[DementedMindz]

no problem glad we could help :)

[Zia]

no problem glad we could help :)

:) u stay here 24/7 :p

[DementedMindz]

:) u stay here 24/7 :p


nah im just on mostly at night since my work schedule got flipped around a bit :) but if i have time durning the day i check things out... ;)

[TECK]

Version 1.0.5 released. Now, the query time is really acurate.
Another bug fixed, related to the colspan counter. This time, it really works!
The server memory problem is fixed.

Also, your microstats template is really easy to edit now. :)
The bad part: You will have to undo all code changes and uninstall the product, they are different now. However, they are still very easy to perform. ;)

Then start fresh with a new install.

[DementedMindz]

The bad part: You will have to undo all code changes and uninstall the product, they are different now. However, they are still very easy to perform. ;)

Then start fresh with a new install.


im going for the gold now lets see how long it takes me ;)

[DementedMindz]

well now i went from 20KB Used to 0KB Used...

[TECK]

Read what it says in the Microstats options, when you enable the Memory Server.
If you want, I could come up with a custom script to display the right Server memory... however, it might create some problems for other users.

So I said, I will disable the memory script for all servers, until everyone is happy.
So far, only those with the function memory_get_usage() compiled in PHP will see the stats.

[Boofo]

Read what it says in the Microstats options, when you enable the Memory Server.
If you want, I could come up with a custom script to display the right Server memory... however, it might create some problems for other users.

So I said, I will disable the memory script for all servers, until everyone is happy.
So far, only those with the function memory_get_usage() compiled in PHP will see the stats.

Did you add the (2.9MB) behind the KB memory usage in this version?

[Zia]

Version 1.0.5 released.

Thnx Man... Nice Shot-- Bulls Eye.

[Snake]

Nice! Thankies for the new update! =)

[TECK]

Did you add the (2.9MB) behind the KB memory usage in this version?
Your board should display the same results like before, Bobby.
You have PHP compiled with memory_get_usage(), the best way to display accurate memory usage.

I will make a little "mod", for those who are still interested having the memory usage, without memory_get_usage() function available.
Post here if you are interested on getting it. :)
I will let you know how to edit the Global Hook, in order to make it work.
Once we have enough people that tested the mod, we will include it into the regular version.

My goal with this version was to avoid any stress to the server by performing non needed operations.

[Boofo]

Your board should display the same results like before, Bobby.
You have PHP compiled with memory_get_usage(), the best way to display accurate memory usage.

I will make a little "mod", for those who are still interested having the memory usage, without memory_get_usage() function available.
Post here if you are interested on getting it. :)
I will let you know how to edit the Global Hook, in order to make it work.
Once we have enough people that tested the mod, we will include it into the regular version.

My goal with this version was to avoid any stress to the server by performing non needed operations.

So I can stay with version 1.0.4 then? Or should I upgrade anyway? ;)

[TECK]

Everyone should upgrade.
The code is better written, there is also a gain in performance, very little, but there is one. :)

[COBRAws]

Thanks Floren!

[Boofo]

Everyone should upgrade.
The code is better written, there is also a gain in performance, very little, but there is one. :)

Will do. Thank you, sir. ;)

[COBRAws]

A recommendation for future releases.

keep a txt with old changes made. Because some people dont save zips on their drives, but I do. And I had to take a look at what did I add to my PHP's ;)


Sorry for being a pain in the ass :P

[TECK]

No pain at all, it's a very good idea. :)
Btw, I'm counting on guys like you... that will post the actual code changes.
Go ahead and post them. Thank you for helping out.

EDIT: 26 queries on your front page.. aren't you affraid???

[Boofo]

Or you can do like I did and re-upload the 2 files and you won't have to remember the changes then. ;)

[Snake]

TECK, how do I change the class name from "page" to "tfoot"? And what's up with the debuge mod? It says it's currently off.

Take a look - http://www.bonethugsforums.com/

[TECK]

Edit this code, inside the vBMicroStats Global Hook:
// regular users template
$users_template = '<tr align="' . $stylevar['right'] . '">' . "\n";
$users_template .= ' <td class="tcat"' . iif($show['colspan'], ' colspan="' . $colspan . '"') . '>' . "\n";
$users_template .= ' <span class="smallfont">Page generated in ' . $total_time . ' seconds (' . $php_percent . ' - ' . $sql_percent . ') with ' . $query_count . ' queries</span>' . "\n";
$users_template .= ' </td>' . "\n";
$users_template .= '</tr>' . "\n";

// administrator template
$admin_template = '<tr align="' . $stylevar['right'] . '">' . "\n";
$admin_template .= ' <td class="alt1"' . iif($show['colspan'], ' colspan="' . $colspan . '"') . '>' . "\n";
$admin_template .= ' <span class="smallfont">' . $memory_status . $debug_status . $gzip_status . $server_status . $templates_status . '</span>' . "\n";
$admin_template .= ' </td>' . "\n";
$admin_template .= '</tr>' . "\n";
Debug mode is always OFF, unless you add this line into your config.php file:
$config['Misc']['debug'] = true;

This is more like a security feature, in case you forget about it...

[Snake]

Oh thanks for your support! :)

[Boofo]

Is it normal for this:

(33.50% PHP - 66.50% MySQL)

to flucuate to this:

(76.21% PHP - 23.79% MySQL)

constantly? That is the report bad post page (with 7 queries) and it seems to go back and forth with almost every page refresh, or two. Not complaining, Teck, just curious. ;)

EDIT: Well, I just had this one show up on the same page:

(-10.93% PHP - 110.93% MySQL)

;)

[Raptor]

what are my numbers like re: performance

Page generated in 1.18516898 seconds (49.02% PHP - 50.98% MySQL) with 14 queries
4,182.56KB Used | DEBUG Mode OFF | GZIP ON (level 1) | NO Uncached Templates

[TECK]

Bob, do you have a cache installed? That's what it generates a SQL spike...
I actually opened a ticket for this matter to vBulletin, their own code generates the same results...
http://www.vbulletin.com/forum/bugs35.php?do=view&bugid=2481

So far Scott and Freddie are looking for a solution, the bug was confirmed.
The issue we are dealing with is the following:
Once a query is cached, the SQL execution time (%) gets low, only the connection time and other non cached SQL processes are filtered by vBMicroStats. Then, once the queries are not in the cache anymore, BOOM, a heavy SQL demand is passed to the server.

That explains the high SQL % you get sometimes. I'm in the same boat, no fix possible in my eyes, that's the way caches work.
I hope vB Team will find a trick in their hat. read more in the bug thread I opened.

[Boofo]

No, sir, no cache installed at all. I didn't notice it on the earlier versions of this hack but then I didn't really check it that closely then. I'll wait to hear what you find out. ;)

[TECK]

Hmm. It should be stable then, except when the VB default query cache is performed.

Do this: Open a support ticket with vBulletin and ask why the query time and php time are not at all stable, all the time.
They will ask you to show them the exact probem...
Enable Debug Mode then let them see the explained queries. You will notice (at the end of the page in bold) that the query execution time at the end varies in a similar way, maybe a little higher then vBMicroStats.

Post the ticket results for all of us. IMO, it's someting related to the server? vBMicroStats actually reads what is fed into the script, that's all.

[Boofo]

But it shouldn't be going into negative numbers should it? And I also notice when they get really high, the page takes forever to load.

[DementedMindz]

Is it normal for this:



to flucuate to this:



constantly? That is the report bad post page (with 7 queries) and it seems to go back and forth with almost every page refresh, or two. Not complaining, Teck, just curious. ;)

EDIT: Well, I just had this one show up on the same page:



;)


i seen that too i think its vbulletin itself.... cause mine is doing the same thing every so many pages loads too it never really reads the same...

[TECK]

But it shouldn't be going into negative numbers should it?
Yes, it should go into negative values Bobby, because we only count the query execution time.
Once we have that specific value, we deduct from it the script start time, in order to obtain the the PHP execution time.

Let's don't count the DB connection time, first. In init.php, find this line:
$db->mstimer_stop();
Replace it with:
$db->mstimer_stop(false);

Then let me know if the time is also erratic. The code mod will not add anymore how long it takes to do the DB connection to the total SQL/query execution time. I belive the time will still be erratic, only smaller values will be processed for SQL.
One more time, vBMicroStats reads ONLY what is happening behind the script, it does not affect in anyway the vBulletin functionment.

Make me a favor. Disable vBMicroStats (code, etc.), enable the debug mode and look at the explained pages, while refreshing the page several times, the same way you do now with vBMicroStats enabled.

Post the results here. On my forums, they are almost identical in both cases.
However, we need to find out why we get SQL spikes once in a while.
With SQL is simple, you cannot have SOMETIMES certain results. Is either NEVER or ALL THE TIME.

[HakkieDEV]

Great mod!

But, how come the server avarages aren't showing up? I have it setup correctly in the adminCP.

Also, on vb3.0.x it always did show.

(to clearify, all other functions seem to be working allright)

[TECK]

You used my vBMicroStats for VB 3.0? It should show, it's the same code.
Let me know... maybe you changed the server software since then?
I will post a fix once I have more info from you.

[Raptor]

Great mod!

But, how come the server avarages aren't showing up? I have it setup correctly in the adminCP.

Also, on vb3.0.x it always did show.

(to clearify, all other functions seem to be working allright)

i have the very same problem

using 3.5.4 - didnt use any previous hacks

[TECK]

In vBMicroStats Global Hook, find:
if ($vbulletin->options['vb_mstats_server'] AND $stats = @exec('uptime 2>&1') AND trim($stats) != '' AND preg_match("#: ([\d.,]+),?\s+([\d.,]+),?\s+([\d.,]+)$#", $stats, $regs))
{
$regs[1] = vb_number_format($regs[1], 2);
$regs[2] = vb_number_format($regs[2], 2);
$regs[3] = vb_number_format($regs[3], 2);
$server_status = '<strong>' . $regs[1] . '</strong> : ' . $regs[2] . ' : ' . $regs[3] . ' | ';
}
Replace it with:
if ($vbulletin->options['vb_mstats_server'])
{
if ($stats = @exec('uptime 2>&1') AND trim($stats) != '' AND preg_match("#: ([\d.,]+),?\s+([\d.,]+),?\s+([\d.,]+)$#", $stats, $regs))
{
$regs[1] = vb_number_format($regs[1], 2);
$regs[2] = vb_number_format($regs[2], 2);
$regs[3] = vb_number_format($regs[3], 2);
$server_status = '<strong>' . $regs[1] . '</strong> : ' . $regs[2] . ' : ' . $regs[3] . ' | ';
}
}
The original code works. Let me know if that fix it.

[Raptor]

not for me

here is what my output is with ALL options set to yes

Page generated in 0.44428802 seconds (91.86% PHP - 8.14% MySQL) with 7 queries
3,737.15KB Used | DEBUG Mode OFF | GZIP ON (level 1) | NO Uncached Templates

[TECK]

Raptor, if I understand correctly, you see the server loads into your Admin CP, but not into every page?
It just doesn't make sense. It was working perfectly for everyone, all of the sudden we have 2 members letting me know the server loads are not showing.
The original version should work perfectly, no code mod needed.

It's working perfectly on my server.
Anyone else have the server loads showing with the latest version?

[Tulsa]

Possibly not ticked in the admincp to show?

[TECK]

Tulsa, do you have the latest version installed and the server loads are displaying correctly?

[Tulsa]

Yes, I started with this latest version and it works great. Now I don't get the memory stats with php4 but I do with php5. So everything appears to be functioning properly on my site.

I think this hack is great. Couldn't tell you how many things I've gone in and tweaked to make everything more efficient because of this little jewel.

[Darwinist]

Anyone else have the server loads showing with the latest version?
Everything works 100% perfectly for me. :up:

[COBRAws]

Everything works 100% perfectly for me. :up:
Same here :up:

[Mario.D]

Im getting this

Page generated in 0.06948209 seconds (70.36% PHP - 29.64% MySQL) with 12 queries
2,421.72KB Used | DEBUG Mode OFF | GZIP ON (level 1) | NO Uncached Templates

goin to enable php5 and se if there are any diference.

[Mario.D]

No change, there do i find the setting to enable vb debug mode?

[TECK]

Now I don't get the memory stats with php4 but I do with php5.
Stay with PHP5.
You don't see the memory stats in PHP4 because it was not compiled with enable-memory-limit option.

[kellyandmike]

I downloaded the zip file and in it were two things:
1 • product-plugin_vbmicrostats and
2 • vbmicrostats (an html file, instructions)
• class_core.php (folder /includes) was NOT in the zip
• init.php (folder /includes) was NOT in the zip

Am I missing something or is the zip???

[TECK]

Look into your forum /includes folder. ;)

[kellyandmike]

Duh, Thanks. I will leave that post just so others who are having brain farts won't have to post...

[kellyandmike]

I installed it and here is what it says at the bottom of the page for two different page loads...

Page generated in 1.477 seconds (23.55% PHP - 76.45% MySQL) with 9 queries

Page generated in 2.044 seconds (-3.44% PHP - 103.44% MySQL) with 11 queries

Page generated in 4.277 seconds (-19.53% PHP - 119.53% MySQL) with 12 queries

What do these numbers mean?

[Boofo]

I installed it and here is what it says at the bottom of the page for two different page loads...

Page generated in 1.477 seconds (23.55% PHP - 76.45% MySQL) with 9 queries

Page generated in 2.044 seconds (-3.44% PHP - 103.44% MySQL) with 11 queries

Page generated in 4.277 seconds (-19.53% PHP - 119.53% MySQL) with 12 queries

What do these numbers mean?

Follow the instructions in this post. That fixed this problem for me, so far.

https://vborg.vbsupport.ru/showpost.php?p=989193&postcount=123

[kellyandmike]

Wow, Just did it and that helped the speed of the page loads immediately!

[kellyandmike]

I think I spoke too fast. It was really fast at first and now it's slow again. This just stinks! Any other suggestions?

[kissythecutie]

sorry iam a newbie but what is the reak benefit of this hack

[TECK]

I think I spoke too fast. It was really fast at first and now it's slow again.
This mod does not modify the time it takes to load a page. It reads it only.

[phkk]

If you get results like:
Page generated in 3.35731196 seconds (9.05% PHP - 90.95% MySQL) with 17 queries
You probably use a bad piece of code, because vBulletin will never generate those extreme results.
Imagine this: the code uses only 10% the resources to read the actual PHP code and the rest of 90% is used only to scan the tables... WOW!
That means the code forces to read into the database for each user who visits the site at this percentage... if you have 1000 users viewing the page in the same time.. you can get a picture of it...
If you compare this with vBulletin, the software does the opposite, 90% PHP and 10% MySQL... the right way.


how can we fix it?

I have bad piece of code

Page generated in 2.74304891 seconds (62.81% PHP - 37.19% MySQL) with 22 queries

:down: :down: :down: :down: :down:

[TECK]

Follow the instructions in this post. That fixed this problem for me, so far.

https://vborg.vbsupport.ru/showpost.php?p=989193&postcount=123
It looks like the wierd times are comming from future. Scott and Freddie are looking into this problem...
It might be related to the time it takes to count the connection execution, that's the reason I asked you to disable it for now.

I'm waiting on Scott to give more feedback on vBulletin's behaviour.
http://www.vbulletin.com/forum/bugs35.php?do=view&bugid=2481

[Boofo]

It looks like the wierd times are comming from future. Scott and Freddie are looking into this problem...
It might be related to the time it takes to count the connection execution, that's the reason I asked you to disable it for now.

I'm waiting on Scott to give more feedback on vBulletin's behaviour.
http://www.vbulletin.com/forum/bugs35.php?do=view&bugid=2481

Well, it seems to be working right for now with that disabled. ;)

[CP,]

Hi its ive installed it without any errors or anything but for me nothing is showing, ive enabled it also :(

[NeRilkA]

hi,

i installed the hack on my test forum, and it works but i have errors at the top on the page :

Warning: Division by zero in /includes/functions.php(4367) : eval()'d code on line 63

Warning: Division by zero in /includes/functions.php(4367) : eval()'d code on line 64

i attached a capture of my screen

thanks for your help

[apn3a]

hi, i've installed vBMircostats, excellent work TECK.

I'm getting a high number regarding queries. i see everyone is getting 5-15 but i'm getting 30+ most of the times, especially when i browse my forum's threads.

Page generated in 1,14650702 seconds (46,75% PHP - 53,25% MySQL) with 32 queries

does anyone know how to fix this?

thank you in advance

[Boofo]

hi, i've installed vBMircostats, excellent work TECK.


I'm getting a high number regarding queries. i see everyone is getting 5-15 but i'm getting 30+ most of the times, especially when i browse my forum's threads.

Page generated in 1,14650702 seconds (46,75% PHP - 53,25% MySQL) with 32 queries

does anyone know how to fix this?

thank you in advance

The only way to fix that is un-install some of the hacks you have installed.

[Boofo]

PhotoPost does not use the vBulletin $output, then?
This code line (in vBMicroStats Global Hook) should help you:
$output = str_replace('{microstats}', $ms_output, $output);
$output is the vBulletin html code output and $ms_output is the MicroStats one.
The code line listed above with search in the $output for the {microstats} string and replace it with the actual $ms_output html code.
Probably you have a mod installed that merges PhotoPost with vBulletin?
I'm not familiar with this software, so unfortunatelly I could not support it.
I wish I could help you more.

Maybe other members who have experience with PhotoPost could help you better.
I would post this question in the vB3.5 Modification Questions (https://vborg.vbsupport.ru/forumdisplay.php?f=111) forum.
It shouldn't be hard to fix your problem.

If you have an answer, please post it here so I can link it in the first post.
Thanks. :)

BTW, 27 installs in 12 hours? Thank you! It really means a lot to me.

Mine isn't working in Photopost either. It just shows the {microstats} instead of the infornation. I have my Photopost directory set up in the same dirctory as the forums, not underneath it, though, so could that be it?

[TECK]

hi,

i installed the hack on my test forum, and it works but i have errors at the top on the page :
... Division by zero ...
i attached a capture of my screen

thanks for your help
Try this. Open the vBMicroStats Global Hook and find this code:
$total_time = vb_number_format($end_time[0]
Replace it with:
$total_time = number_format($end_time[0]
Let me know if that fixed the problem.

[TECK]

Mine isn't working in Photopost either. It just shows the {microstats} instead of the infornation...
Bobby and others, the problem we are dealing with is the following:
$output = str_replace('{microstats}', $microstats_output, $output);
There is no $output processed by PhotoPost, in order to find {microstats} and replace it with the $microstats_output.
Since I don't have PhotoPost, the best way is to ask other PhotoPost coders how the output is processed.
All you have to do is add there the replacement line listed above, adapted to their code...

[NeRilkA]

yes it works ! thanks a lot !

[TECK]

Excellent, alors... clique sur le piton pour montrer aux gens que tu utilise ce mod. :)

[CP,]

Hi its ive installed it without any errors or anything but for me nothing is showing, ive enabled it also :(

Id be greatfull if somebody can help me with my query..., the hack installed without any errors or anything..., but i dont see anything...., no footer page stats or anything, not even topic stats on the category bar as show... :confused:

[Tulsa]

vbulletin options > bbmicrostats > Enable the vBMicroStats plugin > yes


Now I do believe we have a typo in the vbulletin options title. ;)

[TECK]

No, there is another BB there (Bulletin Board)... I wanted to look good. :)

[Boofo]

Bobby and others, the problem we are dealing with is the following:
$output = str_replace('{microstats}', $microstats_output, $output);
There is no $output processed by PhotoPost, in order to find {microstats} and replace it with the $microstats_output.
Since I don't have PhotoPost, the best way is to ask other PhotoPost coders how the output is processed.
All you have to do is add there the replacement line listed above, adapted to their code...

Wouldn't replacing {microstats} with $microstats_output in the footer solve the problem?

[Oblivion Knight]

Hmm.. 1.0.5 is showing my memory usage as 0KB on every page, 1.0.4 didn't.

[Boofo]

Bobby and others, the problem we are dealing with is the following:
$output = str_replace('{microstats}', $microstats_output, $output);
There is no $output processed by PhotoPost, in order to find {microstats} and replace it with the $microstats_output.
Since I don't have PhotoPost, the best way is to ask other PhotoPost coders how the output is processed.
All you have to do is add there the replacement line listed above, adapted to their code...

Floren, if you would like Admin CP access to help figure this out, please PM me and I will set it up for you, sir. ;)

[CP,]

vbulletin options > bbmicrostats > Enable the vBMicroStats plugin > yes


Now I do believe we have a typo in the vbulletin options title. ;)

Yes its enabled i did all that, but i dont see anything...., no footer page stats or anything, not even topic stats on the category bar as show... ?

[Snake]

Hmm.. 1.0.5 is showing my memory usage as 0KB on every page, 1.0.4 didn't.
Same here!

[TECK]

Hmm.. 1.0.5 is showing my memory usage as 0KB on every page, 1.0.4 didn't.
You are right, I was cheating using a tricky way to calculate the memory, without get_memory_usage() compiled in PHP.
It was showing the right values, except it was divided to much.... the right results are 2,985KB not 0.20KB.

Since I did not wanted to get into extra calculations, I simply removed the process to ease the server and stop piping through grep the hole activity log.
Trust me, it's better this way now.

If you guys really want it, I could post the mod here, but I will not insert it into the original code. Performance wise is not recommended.
Floren, if you would like Admin CP access to help figure this out, please PM me and I will set it up for you, sir.
In a bit, Bobby. I will look into it next week, I promise.
Send me by email: webmaster AT adolympics DOT com
the php files that give you trouble.

[Oblivion Knight]

You are right, I was cheating using a tricky way to calculate the memory, without get_memory_usage() compiled in PHP.
It was showing the right values, except it was divided to much.... the right results are 2,985KB not 0.20KB.

Since I did not wanted to get into extra calculations, I simply removed the process to ease the server and stop piping through grep the hole activity log.
Trust me, it's better this way now.

If you guys really want it, I could post the mod here, but I will not insert it into the original code. Performance wise is not recommended.I guess I'd have had my answer sooner if I actually looked at the Admin CP setting description for the memory usage display, huh? ;)

Display the server memory usage, per page.
If you display results like 0KB Used, you need to compile PHP with enable-memory-limit option.

[apn3a]

hi, i've installed vBMircostats, excellent work TECK.


I'm getting a high number regarding queries. i see everyone is getting 5-15 but i'm getting 30+ most of the times, especially when i browse my forum's threads.

Page generated in 1,14650702 seconds (46,75% PHP - 53,25% MySQL) with 32 queries

does anyone know how to fix this?

thank you in advance

The only way to fix that is un-install some of the hacks you have installed.


well, i only have 7 hacks installed.. is that really the case that i'm getting so many queries or it could be something else too?

thank you :)

[Boofo]

well, i only have 7 hacks installed.. is that really the case that i'm getting so many queries or it could be something else too?

thank you :)

Depends on the hacks you have installed.

[Snake]

You are right, I was cheating using a tricky way to calculate the memory, without get_memory_usage() compiled in PHP.
It was showing the right values, except it was divided to much.... the right results are 2,985KB not 0.20KB.

Since I did not wanted to get into extra calculations, I simply removed the process to ease the server and stop piping through grep the hole activity log.
Trust me, it's better this way now.

If you guys really want it, I could post the mod here, but I will not insert it into the original code. Performance wise is not recommended.

In a bit, Bobby. I will look into it next week, I promise.
Send me by email: webmaster AT adolympics DOT com
the php files that give you trouble.
So how do I fix it eh?

[Boofo]

So how do I fix it eh?

Have your host do this:

get_memory_usage() compiled in PHP

[Snake]

Alrighty thanks...

[apn3a]

Depends on the hacks you have installed.


i uninstalled all my hacks and from the 40 queries i was getting, now i'm getting like 30-34 which looks still high.. :confused:

[Boofo]

i uninstalled all my hacks and from the 40 queries i was getting, now i'm getting like 30-34 which looks still high.. :confused:

Where are you getting 30-34 queries at? And what are you getting on the forumhome now?

[TECK]

Probably from a frontpage like vbAdvanced, not vBulletin ...

[TECK]

Id be greatfull if somebody can help me with my query..., the hack installed without any errors or anything..., but i dont see anything...., no footer page stats or anything, not even topic stats on the category bar as show... :confused:
CP, go to Admin CP and disable completly vBMicroStats.
Do you see {microstats} displayed at the bottom of your page?
If you do, ask any fellow vb.org members that they know you to PM you the modified files.

You tried this on an unmodified forum?

[Tulsa]

Probably from a frontpage like vbAdvanced, not vBulletin ...


I'm using vbadvanced and my home page is only running 15 queries. Of course all I have is the header and the login, but it is down to 15 queries. :cool:

[CP,]

CP, go to Admin CP and disable completly vBMicroStats.
Do you see {microstats} displayed at the bottom of your page?
If you do, ask any fellow vb.org members that they know you to PM you the modified files.

You tried this on an unmodified forum?

i disabled it and dont see it, i then enabled it and i see it only in my default skin it is showing at the bottom left corner, but not on my current live skin? i also applied the template changes to all the skins and still no work? only dosent show on current live customised skin.

[TECK]

Ok, so we know at least that the variable {microstats} is there, in some of the skins.
Now we know for sure it's related to code editing the files. I would strongly recommend to install in your PC an unmodified board, then apply the code changes in the order mentioned into the help file.

Bobby, aka Boofo, had this instal;led into his forums with several skins, no problems. I remember he was mentioning a similar problem, stats not displaying... it was simply not adding the {microstats} into the right template.

[Boofo]

Yep, a Boofo mistake. ;)

I have the fix for Microstats and Photopost for you, Floren. Want me to PM it to you?

[TECK]

Special thanks to Revan and Boofo for being the guinea pig. :)
To have vBMicroStats working with PhotoPost, follow those simple steps.

Open pp-inc.php file and find:
if ( !empty($vbfooter) && $headers != "no" )
{
Replace it with:
if ( !empty($vbfooter) && $headers != "no" )
{
require_once(DIR . '/includes/class_hook.php');
($hook = vBulletinHook::fetch_hook('global_complete')) ? eval($hook) : false;
Then install the attached plugin.

[Boofo]

Are you going to add the plug-in to your hack? You could add that in the next version and just make an option to enable it in the settings. ;)

[TECK]

I will not add it Bobby, it's not a vbulletin hack.
I will leave it as optional. It's listed in the first post. :)

[Boofo]

Well, I added it to mine, but I can see your point.

[TECK]

Ya, not everyone have PhotoPost.
So for those who have it, they can download the plugin and run it.

[James T Brock]

Here are my stats from the first page of the forum.

'Page generated in 0.39097905 seconds (19.32% PHP - 80.68% MySQL) with 11 queries'

I wonder why it's using so much MySQL even though it's just 11 queries???

nevermind... I figured it out. It's because of two of my hacks on the forum index page. One of which is the who has visited today feature.

[TECK]

You mean the init.php file?

[TECK]

The first replacement set is for MySQL, the second one is for MySQLi... you only use one type of connection so that's why it's working.
Notice that the 2 segments are not identical, there is a few bytes difference between them.
In first type of connection you find ($this->sql, $link), then in second you find ($link, $this->sql) in the function.
It's the only difference between the 2 functions.

You probably copied and pasted the same code in both places, thinking they are the same. That results into a parse error. ;)

[TECK]

If you want to display all stats for administrators only, follow the same readme steps.
Install the plugin attached below, instead.

[Delphiprogrammi]

hi people,

the fix for Photopost doesn't work


Warning: ksort() expects parameter 1 to be array, null given in /photopost/pp-inc.php(630) : eval()'d code on line 351

Warning: Invalid argument supplied for foreach() in /photopost/pp-inc.php(630) : eval()'d code on line 353


hmmmz

[Mike-D]

hi people,
the fix for Photopost doesn't work


Warning: ksort() expects parameter 1 to be array, null given in /photopost/pp-inc.php(630) : eval()'d code on line 351

Warning: Invalid argument supplied for foreach() in /photopost/pp-inc.php(630) : eval()'d code on line 353


hmmmz
Really strange. I have PhotoPost too and Tecks fix works excellent! -Mike

[Mosh]

Hey TECK,

I am testing v 1.0.5 of your mod and I have this problem (see attachment)

Any way of fixing it so the colomns go straight across the screen?

[Mike-D]

Hey TECK,
I am testing v 1.0.5 of your mod and I have this problem (see attachment)
Any way of fixing it so the colomns go straight across the screen?
I have had the same problem. There exists a fix from Teck regarding DementedMindz's post. See Post No 34 (https://vborg.vbsupport.ru/showpost.php?p=980611&postcount=34). That should help. If not then I can help you too because I modified my footer template so that I get the same result like in Teck's Attachment (https://vborg.vbsupport.ru/attachment.php?attachmentid=47860&d=1148057918) ;) -Mike

[Delphiprogrammi]

Really strange. I have PhotoPost too and Tecks fix works excellent! -Mike

if it works you then it must be something on my end (obvious) i'll try to dig it out

[TECK]

Hey TECK,

I am testing v 1.0.5 of your mod and I have this problem (see attachment)

Any way of fixing it so the colomns go straight across the screen?
It should not do it, that's why I built a column counter inside.
I just reinstalled again a brand new test board (3.6) with vBMicroStats and it's spanning properly the columns.

BTW, the hack changes in vBulletin 3.6 version. :)
I will release a new version when 3.6 is final.

[Mosh]

OK, I have narrowed it down.

When viewing as a guest it spans fine.

However when logged in, it does what it does in the what shows in the attachment I posted previously, with or without admin stats (ie spans across the length of the style selector and that is it).

EDIT: When logged out there is no style selector available.

[lillylissy]

Hello!

I use PhotoPost too.
PHP and MySQL are not displayed in PhotoPost. (Page generated in 0,19557405 seconds (0% PHP - 0% MySQL) with 18 queries)
It operates only sporadically?!

-> PhotoPost (http://www.handwerk-weiterbildung.com/galerie/index.php)

In vBulletin the hack works perfectly. (Page generated in 0.18732309 seconds (91,50% PHP - 8,50% MySQL) with 16 queries)

-> vBulletin (http://www.handwerk-weiterbildung.com/vbulletin/index.php)

Any way of fixing this Problem?

Thank you!

[Mike-D]

Hello!
I use PhotoPost too. PHP and MySQL are not displayed in PhotoPost. (Page generated in 0,19557405 seconds (0% PHP - 0% MySQL) with 18 queries) It operates only sporadically?!

-> PhotoPost (http://www.handwerk-weiterbildung.com/galerie/index.php)

In vBulletin the hack works perfectly. (Page generated in 0.18732309 seconds (91,50% PHP - 8,50% MySQL) with 16 queries)

-> vBulletin (http://www.handwerk-weiterbildung.com/vbulletin/index.php)

Any way of fixing this Problem?Thank you!
Did you tried Teck's PhotoPost Fix (https://vborg.vbsupport.ru/showpost.php?p=1005066&postcount=182)? Does it works for you? -Mike

BTW: Hi German fellow ;) Nice homepage. Which hack did you installed to get a better overview about your sub forums? I like it really ;) -Micha, K?ln

[lillylissy]

Hallo Michael!

Did you tried Teck's PhotoPost Fix?

Yes of course! :(


Which hack did you installed to get a better overview about your sub forums?

-> CSS - Sub-Forum-List in Columns (https://vborg.vbsupport.ru/showthread.php?t=91299)

Kind Regards - viele Gr??e :)


// Edit: Okay, now I tried Teck's "Division by Zero" Fix in the ?vbmicrostats-plugin_photopost.xml? too.
Now it runs! :banana:

Thank you!

[Surviver]

Thank you very much for this nic modification :)

works perfectly ;)

mfg Surviver

[Mosh]

Hey TECK,

I am testing v 1.0.5 of your mod and I have this problem (see attachment)

Any way of fixing it so the colomns go straight across the screen?It should not do it, that's why I built a column counter inside.
I just reinstalled again a brand new test board (3.6) with vBMicroStats and it's spanning properly the columns.

BTW, the hack changes in vBulletin 3.6 version. :)
I will release a new version when 3.6 is final.

OK, I have narrowed it down.

When viewing as a guest it spans fine.

However when logged in, it does what it does in the what shows in the attachment I posted previously, with or without admin stats (ie spans across the length of the style selector and that is it).

EDIT: When logged out there is no style selector available.

Just bumping this, as I still need help on this.

[Delphiprogrammi]

hmmmmz,


Warning: ksort() expects parameter 1 to be array, null given in /photopost/pp-inc.php(630) : eval()'d code on line 355

Warning: Invalid argument supplied for foreach() in /photopost/pp-inc.php(630) : eval()'d code on line 357



and if you put


@ksort($tempusagecache);


the error should not be displayed but still it's there so it must be something else PHP reports lines 355 / 357 line 357 is a comment and should be ignored by PHP am i getting nuts here ??????

line 355 is code about the vb3 integration maybe that has something todo with it

[Delphiprogrammi]

hmmmmz,



and if you put


@ksort($tempusagecache);


the error should not be displayed but still it's there so it must be something else PHP reports lines 355 / 357 line 357 is a comment and should be ignored by PHP am i getting nuts here ??????

line 355 is code about the vb3 integration maybe that has something todo with it

problem solved those two PHP errors are gone and the stats are showing up !

if you want to know how i did that give me a yell :D

[TECK]

Please post it, others will have it as reference. :)

[TECK]

Just bumping this, as I still need help on this.
JD, look at the html code and tell me if you see a colspan in the microstats template.
It has to be there, it's working fine for all boards, so far.
Is this an original board, unhacked?

This is the code it needs to be examined:
// regular users template
$users_template = '<tr align="' . $stylevar['right'] . '">' . "\n";
$users_template .= ' <td class="tcat"' . iif($show['colspan'], ' colspan="' . $colspan . '"') . '>' . "\n";
$users_template .= ' <span class="smallfont">Page generated in ' . $total_time . ' seconds (' . $php_percent . ' - ' . $sql_percent . ') with ' . $query_count . ' queries</span>' . "\n";
$users_template .= ' </td>' . "\n";
$users_template .= '</tr>' . "\n";

// administrator template
$admin_template = '<tr align="' . $stylevar['right'] . '">' . "\n";
$admin_template .= ' <td class="alt1"' . iif($show['colspan'], ' colspan="' . $colspan . '"') . '>' . "\n";
$admin_template .= ' <span class="smallfont">' . $memory_status . $debug_status . $gzip_status . $server_status . $templates_status . '</span>' . "\n";
$admin_template .= ' </td>' . "\n";
$admin_template .= '</tr>' . "\n";
Let me know what you see in your page source.
Thanks.

[Delphiprogrammi]

hello,

To solve the problem with those two errors about ksort() and foreach() follow this steps


install vbmicrostats with the instructions provided
install this (https://vborg.vbsupport.ru/showpost.php?p=1005066&postcount=196)Photopost fix
edit pp-inc (instructions below)
edit forum/includes/xml/hooks_vbulletin.xml


in photopost file pp-inc.php find


if ( !empty($vbfooter) && $headers != "no" )
{


replace with


if ( !empty($vbfooter) && $headers != "no" )
{
require_once(DIR . '/includes/class_hook.php');
($hook = vBulletinHook::fetch_hook('photopost_displaymicros tats')) ? eval($hook) : false;
print $vbfooter;
}


in forum/includes/xml/hooks_vbulletin.xml at the bottom


<hooktype type="photopost">
<hook>photopost_displaymicrostats</hook>
</hooktype>


make sure you change the hook location to the new one (step 2 in the list) upload all changed files in acsi mode

also make sure that your photopost admin => edit integration has been turned on

[Mosh]

JD, look at the html code and tell me if you see a colspan in the microstats template.
It has to be there, it's working fine for all boards, so far.
Is this an original board, unhacked?

This is the code it needs to be examined:
// regular users template
$users_template = '<tr align="' . $stylevar['right'] . '">' . "\n";
$users_template .= ' <td class="tcat"' . iif($show['colspan'], ' colspan="' . $colspan . '"') . '>' . "\n";
$users_template .= ' <span class="smallfont">Page generated in ' . $total_time . ' seconds (' . $php_percent . ' - ' . $sql_percent . ') with ' . $query_count . ' queries</span>' . "\n";
$users_template .= ' </td>' . "\n";
$users_template .= '</tr>' . "\n";

// administrator template
$admin_template = '<tr align="' . $stylevar['right'] . '">' . "\n";
$admin_template .= ' <td class="alt1"' . iif($show['colspan'], ' colspan="' . $colspan . '"') . '>' . "\n";
$admin_template .= ' <span class="smallfont">' . $memory_status . $debug_status . $gzip_status . $server_status . $templates_status . '</span>' . "\n";
$admin_template .= ' </td>' . "\n";
$admin_template .= '</tr>' . "\n";
Let me know what you see in your page source.
Thanks.

The code you posted above is exactly the same as in the vBMicroStats Global Hook.


OK, not logged in I see this:
<tr align="right">
<td class="tcat">
<span class="smallfont">Page generated in x.xxxx seconds (xx.xx% PHP - xx.xx% MySQL) with xx queries</span>
</td>
</tr>

Logged in I see:
<tr align="right">
<td class="tcat">
<span class="smallfont">Page generated in X.XXXX seconds (XX.XX% PHP - XX.XX% MySQL) with XX queries</span>
</td>
</tr>
<tr align="right">
<td class="alt1">
<span class="smallfont">DEBUG Mode OFF | GZIP ON (level 1) | <strong>X.XX</strong> : X.XX : X.XX | NO Uncached Templates</span>

</td>
</tr>

But the code is aligned on the left side, like the pic I posted in my original post, it's width is the width of the style chooser.

Guests do not have access to choosing style, and only certain senior groups have access to choose a style, normal members can not choose style either.

That is what the situation is, hope you can help.

[TECK]

Only certain senior groups have access to choose a style, normal members can not choose style either.
Is this normal behaviour or a hack? I'm still not used to VB3.5.x version.
If normal behaviour, in your board the colspan counter is set to 0, making the code tossed to the left.
Something is not right, since you are the only one experiencing this problem.
It's all related to the condition you display the dropdowns for style and language.

[Mosh]

Is this normal behaviour or a hack? I'm still not used to VB3.5.x version.
If normal behaviour, in your board the colspan counter is set to 0, making the code tossed to the left.
Something is not right, since you are the only one experiencing this problem.
It's all related to the condition you display the dropdowns for style and language.
It was a combination of a have of Andreas's and one of mine.

I just hard coded in the colspan and got rid of your checks which fixed the problem for me :)

Thanks for porting this great hack :)

[TECK]

Try to fix it. It's not good the hardcode the colspan because in some browsers like Opera it will show a gap (nasty one) to the right.
That's the reason I gave myself the trouble to make the colspan counter. :)

[Mosh]

Try to fix it. It's not good the hardcode the colspan because in some browsers like Opera it will show a gap (nasty one) to the right.
That's the reason I gave myself the trouble to make the colspan counter. :)
Tested in IE, Firefox and Opera and it works for me fine. But will look into it :)

[Tulsa]

I just reinstalled again a brand new test board (3.6) with vBMicroStats and it's spanning properly the columns.

BTW, the hack changes in vBulletin 3.6 version. :)
I will release a new version when 3.6 is final.


To those of us running 3.6 test sites, this would be a great tool to have prior to it going gold. Not supported of course, until it goes gold.

[gothicuser]

Yes, would be very useful to see this updated for 3.6.0bx sooner rather than later

[kofoid]

The world's most stupid question.................................

what's with the "uncached Templates" on the stats? And how do I get them cached?

[kofoid]

dummy says "bump"

[Snake]

Okay I'm having a problem here. I don't know what I have done to my forums but this is how my micro stats shows up. It's kinda messed up as you can see...

http://img423.imageshack.us/img423/6516/prob6kd.jpg

It happened to me suddenely! Weird.

Here's a link to my forums - http://www.finalfantasyforums.net/

[TECK]

what's with the "uncached Templates" on the stats? And how do I get them cached?
Check:
$globaltemplates = array(
In index.php for example.

[Snake]

TECK, could you please take a moment and look into my problem where I have posted above?

[TECK]

The column counter does not calculate the extra column. What hack did you installed?
You are the second person who have this problem, all of the sudden...

[cheesegrits]

Yes, would be very useful to see this updated for 3.6.0bx sooner rather than later

"Me too"

And I don't mind beta testing the 3.6 version. I'd really like to get this going on 3.6.

-- hugh

[Snake]

The column counter does not calculate the extra column. What hack did you installed?
You are the second person who have this problem, all of the sudden...
What do you mean what hack I installed? Your hack of course.

[TECK]

Sorry Dark, I was not clear. :)
Did you installed another hack, beside mines?
Or you had your style/language dropdown disabled before?

It does not make sense to me because I installed several test boards, in various configurations and they all work without any problems.
I'm not saying is your fault, I'm trying to identify where is located the problem.

Thanks.

[Snake]

Yes I've got loads of hacks installed already on my forums and yeah I think the style dropdown was disabled before. You should see it now though because I've removed the if condition statement which means you will be able to view the style chooser even if it was disabled in the vB Options.

[TECK]

Dark, you have a test board, right?
Make me a big favor, install the hack into a clean test board, enable both dropdowns (style and language - or only one of them) and let me know if it does the same thing. If it doesn't break the page, then, one by one, install your hacks, until the page is broken.
I think there is a another hack that is conflicting with my column counter...

[Snake]

Okay I'ma see what I can do and will get back to you. Yeah I'm pretty sure some other hack is causing this problem but I wonder why one is it.

Thanks for your reply!

[snake-boy]

I'd like everyone to be able to see ALL the stats, all the time regardless of usergroup. How could I acomplish this?

[chrisj8221]

downloaded the file today and it installed beautifully, but my results are the following for all pages...

Page generated in 0.18792105 seconds (100.00% PHP - 0% MySQL) with 9 queries

the time will change on page loads as well the the number of querries but the 100% php is always the same. I imagine it may be bad code, but I went directly off of the instructions, three times with the same result.

any ideas where the goof may be?

[snake-boy]

I'm still trying to figure out how to allow everyone to see all the stats?

Any help please? Anyone?

-snake

[Surviver]

Hello, thank you for this Hack, i installed it until i graded up to 3.6.

Do you know, when you will release a version for 3.6 ?

Thank you very much !

mfg Surviver

[cheesegrits]

I'm still trying to figure out how to allow everyone to see all the stats?

Any help please? Anyone?

-snake

I haven't tested this, as I'm running 3.6 and so have MicroStats disabled, but you could try the following:

In the Plugin Manager, find and edit the Microstats "global_complete" hook.

Find the line that says:

$show['adminoptions'] = iif($vbulletin->options['vb_mstats_adminactive'] AND $vbulletin->userinfo['usergroupid'] == 6, true, false);

... and change it to ...

// $show['adminoptions'] = iif($vbulletin->options['vb_mstats_adminactive'] AND $vbulletin->userinfo['usergroupid'] == 6, true, false);
$show['adminoptions'] = 1;

You may or may not have formatting issues because of the "style_count" stuff, but it's worth a try, if you really really want to do this. Personally I don't recommend it, but it's your board.

To undo this change, simply delete the second line above, and remove the comment (//) from the original line.

-- hugh

[DementedMindz]

would you know how to get the stats to work on this mod here Teck https://vborg.vbsupport.ru/showthread.php?t=125947

[MRGTB]

Any news on this being ported over for vBullten 6.0.0

[Wired1]

3.6.0 you mean, and I second that question :)

[Surviver]

I'm very interested of this Hack for 3.6.0, too ;)

[Snake]

Me either. Please release it as soon as you can. :)

[snake-boy]

Thanks hugh! This DID work perfectly :) It's now displayed to all users, regardless of usergroup.

-snake


I haven't tested this, as I'm running 3.6 and so have MicroStats disabled, but you could try the following:

In the Plugin Manager, find and edit the Microstats "global_complete" hook.

Find the line that says:

$show['adminoptions'] = iif($vbulletin->options['vb_mstats_adminactive'] AND $vbulletin->userinfo['usergroupid'] == 6, true, false);

... and change it to ...

// $show['adminoptions'] = iif($vbulletin->options['vb_mstats_adminactive'] AND $vbulletin->userinfo['usergroupid'] == 6, true, false);
$show['adminoptions'] = 1;

You may or may not have formatting issues because of the "style_count" stuff, but it's worth a try, if you really really want to do this. Personally I don't recommend it, but it's your board.

To undo this change, simply delete the second line above, and remove the comment (//) from the original line.

-- hugh

[sabret00the]

Add himself to 3.6 request list.

[BMamba]

I'm waiting for version 3.6.x too :)

[Delphiprogrammi]

/me wants this for vb 3.6.x

jelsoft changed some stuff in class_core.php "query_wrapper" function is gone

[succo]

it works on 3.6.x, you only have to change completely the changes in class_core.php as the function name (and how it works) changed

i did it, but of course can't give others the changes to do without authorization from the author... anyway, try to look @ function &execute_query, that's the one to be modified (but of course NOT like in 3.5.x and vbmicrostats 1.05) :)

[Snake]

If you can't give it to others then why bother post here?

[succo]

i can't (and of course won't) without TECK's authorization, as he is the coder for this hack, but anyone can try to change that function by himself, and i was only giving a clue on what to change to make it work on 3.6.x, that's all

i didn't want to say 'i did it' as i didn't, i only used TECK's work and modified it to my purposes, but, as many ask for a port of this mod on 3.6.x and none gave any clue yet (and i don't know if anyone really did it), i'm only saying 'it can be done, look at this function', that's all :)

[G_Man]

I'm waiting for version 3.6.x too :)

Gets in line. :D

[Inferno Dragon]

I also want it for vb3.6

[maxicep]

vbulletin.org using same hack on 3.6.4
can give admins to us ?

[mcyates]

when will this be released for vb 3.6

[grecostimpy]

jumps in line for 3.6.X hack

[TECK]

I did not forget about you guys. I`m working on a site.
So I will release soon the version for 3.6.x

Patince, it could take a month, depending on what I have to do first.
But I need this hack, so it will be done for the latest version.

[sduckie2k5]

Add me to the list, would like this for 3.6.4. Thanks