TECK, there is a problem with your hack if one uses it with the German language system offered by vBulletin (works fine with default US English, of course):

This seems to happen, whenever a page is generated in less than 1 second.

These are the lines 1839 and 1840 in functions.php

Results for pages generated in less than 1 second:

The php warning doesn't appear if a page is generated in more than one second but the results still are inaccurate:

I assume this could be caused by the fact that German uses "," where English uses a "." and vice versa. Do you have a fix for this, please? One that works regardless if one selects English or German as language, preferrably? :)

For the division by zero, see the link about that in the first post :)

Installed and works fine with 3.0.1. Good job Tech :).

[high]* Intex clicks INSTALL[/high]

Nice. I had Erwin's installed thinking he was referring to your vB2 release (which I also had installed), but then I found this post. Might be a good idea to have it linked (in your first post) to this hack as this is a bit better.

Oh, I do have a question, though. I understand the caching part but I am a little confused about a little problem I am having. What if I add the template name to the cached list but it's still showing up as uncached? What could be the issue there?

Just so you know, the template is actually a hack template, so that's probably it. I'm just wanting confirmation. (It's Gary's "Who has been online today" hack. (separate page than the index, though))

same for me ;)
First installed Erwin's version and then installed TECK's much better version !
I've also the problem of the uncached "forumhome_todayloggedinuser" Template from Gary's Who was online today Hack.

Great hack, had it on vB2, much easier install on vB3 though :D

Below are some stats from my site from the last few minutes using vBindex3 - guess it's time to cut some of the info pulled to the front portal page to cut down on that SQL load!

Page generated in 0.35776806 seconds (55.02% PHP - 44.98% MySQL) with 11 queries
Page generated in 0.62210989 seconds (47.07% PHP - 52.93% MySQL) with 11 queries
Page generated in 0.20080590 seconds (74.33% PHP - 25.67% MySQL) with 11 queries
Page generated in 0.30024004 seconds (84.11% PHP - 15.89% MySQL) with 11 queries
Page generated in 2.15881801 seconds (25.50% PHP - 74.50% MySQL) with 11 queries :eek:

I had the same problem. But it's fine within the forums its self. so i don't think it should really matter, unless you have tons hitting up your portal page at one time.

I have the following problem:

Page generated in 75498605 seconds (10000% PHP - 0% MySQL) with 12 queries

Any help or ideas why?

Try rehacking the files. start clean.

Checked code and all is 100%.

Anyone?

Is it possible to add the hostname at the bottom? I am running mutiple web servers, it would help me out :)

This hack seems not work for vb 3.0.3
Any update for this?

Thank's...

I use also vB3.0.3 and have still this hack installed and works fine.

I don't have any problems with vB3.0.3 and this Hack either
What error are you getting?

I solved my problem.
Sorry for that, :D

Installed and works fine with 3.0.1. Thanks Tech .. clicked Install

Page generated in 0.25623298 seconds (90.58% PHP - 9.42% MySQL) with 12 queries on main page .. No uncached templates

Page generated in 0.29059601 seconds (81.53% PHP - 18.47% MySQL) with 25 queries on CMPS v1.0.0 portal .. 2 uncached templates

I am coming to my wits end with this script now,
Heres a quote of lines surround 1865, any advice would be good.

Thanks very much Teck. Have installed and clicked Install.

Using vB3.0.3 and had no problems following the version 1.2 text instructions.

I edited using EditPad Lite. It uses Tabs so that you can have two files open and tab between them for easy comparison.

I don't use a portal and the stats produced on the forum home page with 6 users and 2 spiders online were:

Page generated in 0.13130212 seconds (83.33% PHP - 16.67% MySQL) with 9 queries
DEBUG Mode OFF | GZIP ON (level 1) | 0.04 : 0.13 : 0.17 No uncached templates

That looks relatively normal for a lightly hacked site without a portal and using a shared server.

On one of the Forum Display pages with 6 users online:

Page generated in 0.19516301 seconds (79.20% PHP - 20.80% MySQL) with 14 queries

Server load: 0.06 : 0.23 : 0.21 No uncached templates

You can see that 5 extra queries has increased the server load slightly.

The Members List seems to be more server intensive still:
Server load: 0.33 : 0.31 : 0.24 with only 9 queries.

But still quick loading: Page generated in 0.16052389 seconds (81.20% PHP - 18.80% MySQL)

Apparently the hack produces invalid stats if MYSQL is compiled in a non-english language. This happens because MYSQL can be configured to use different 'lang_decimalsep' and 'lang_thousandsep' variable values which bothers the number formating through vb_number_format() function.

To fix it, I suggest to find:
in the hack code inside functions.php

and BEFORE that add:
This fix forces to use English seperators which the hack code depends so regardless of MYSQL configuration the formatting works fine. ;)

On forum home (Admin):
Page generated in 0.11859798 seconds (93.17% PHP - 6.83% MySQL) with 9 queries
Page generated in 0.11566091 seconds (92.98% PHP - 7.02% MySQL) with 9 queries
On forum home (Guest):
Page generated in 0.12545395 seconds (92.30% PHP - 7.70% MySQL) with 9 queries
Page generated in 0.11924601 seconds (93.99% PHP - 6.01% MySQL) with 9 queries
On vBAdvanced Homepage (Admin):
Page generated in 0.16185904 seconds (86.56% PHP - 13.44% MySQL) with 9 queries
Page generated in 0.09283090 seconds (91.52% PHP - 8.48% MySQL) with 9 queries
On vBAdvanced Homepage (Guest):
Page generated in 0.08898401 seconds (93.35% PHP - 6.65% MySQL) with 7 queries
Page generated in 0.10263205 seconds (93.28% PHP - 6.72% MySQL) with 7 queries

Looks pretty good so far... Let's see how this works later when I add more hacks to it ^^

Thanks Logician, I added a link in the fist post. :)

Regards,
Floren.

Should we install this modification regardless of server config ? or only in certain situations ?

Only if MYSQL is compiled in a non-english language.

I just installed RPG Integration Hack v2.5.1

and this is what I get

Page generated in 8.47130704 seconds (1.54% PHP - 98.46% MySQL) with 26 queries

O_o not good I gues =) full site is going slow

is there a way to check where the problem is ?

I suggest you need to look at each query in detail to see which ones are taking up most of the time. To do that you need to turn debug mode on as I did. Refer to my post: https://vborg.vbsupport.ru/showpost....3&postcount=39

I dint found anything with debug on
I uninstalled the hack but its still pretty high

Page generated in 26.25595188 seconds (1.57% PHP - 98.43% MySQL) with 26 queries

maybe a problem with my host ? :/

nice hack as always
*click install*

Everything running fine now seems it wasnt a problem with a script but with the host =)

I am getting

Parse error: parse error in /home/forum/public_html/forums/includes/functions.php on line 3876

Fatal error: Call to undefined function: devdebug() in /home/forum/public_html/forums/includes/functions.php on line 957


:((( Someone want to let me know what I have done wrong? I followed everything to a T...

Fixed LOL Cant believe I made that error.... Works great!

vBadvanced CMPS v1.0.0
Page generated in 0.35274100 seconds (85.77% PHP - 14.23% MySQL) with 25 queries
DEBUG Mode OFF | GZIP ON (level 1) | 0.11 : 0.24 : 0.30 | NO Uncached Templates

Forum home
Page generated in 0.15533590 seconds (87.42% PHP - 12.58% MySQL) with 17 queries
DEBUG Mode OFF | GZIP ON (level 1) | 0.18 : 0.25 : 0.30 | NO Uncached Templates

Very cool.

*Clicks Install*

After I moved to my new server...
Page generated in 0.33385205 seconds (49.31% PHP - 50.69% MySQL) with 17 queries
DEBUG Mode OFF | GZIP ON (level 1) | 0.13 : 0.31 : 0.27 | NO Uncached Templates

Jumps from 17 to 32 queries.. This is odd and the mysql % scares me.

I've just installed the hack on my vB 3.0.3 and with Logician's tip its running very well. Thanks for hack TECK!

/me clicks INSTALL

I get this for an error .

Parse error: parse error, unexpected T_STRING in c:\inetpub\wwwroot\vb\includes\functions.php on line 1865

Fatal error: Call to undefined function: is_browser() in c:\inetpub\wwwroot\vb\global.php on line 93

Great hack man! But how can i remove the admin info (gzip and such)? I tried and could manage to remove only the text and not the listbox.
thanks agian

Is this hack adapted for vB303? Caus the code modification is not up2date with the files on vB303

thx

I'm running it on vB3.0.3, with no problems.

Yes, perfectly possible :)

i want to point out that the txt file with instructions is not up to date...

Search for and replace with... can't replace what can't be searched. the code was ok in previous versions of vB, where I installed the hack myself without problems.

But now mysql_db.php seems to be changed in this version, and i want to be sure to have an updated instruction file, before i start replacing :)

thx if ya wanna update it Teck ;)

I don't have the 303 update, sorry.
I need to pay the VB update fee, soon next week.

If anyone have the step by step for the new code, post it here so I can update the txt file. Thanks guys.