hmm... it should not. turn the poll on and let me go to the url you posted in the pm.. let me know when i can go.
also, 20 queries? is impossible. you should have max 17 with all options turned on.

it is on now.

I can also reinstall vB and vBhome again just incase i missed something. Just let me know and I'll just reinstall

Hi! This looks amazing!
Can I have the password?
It will be installed at www.scifichat.net by the end of October.
I am in the midst of reopening SFC using VB. (just converted from UBB! best move ever)

Thankyou so much!

obiwan, i pm you the password.
thanks for trying my hack.

Hi Teck,

I am using vbHome (lite) version 2 and i would like to update it to the new version. My site is: http://www.ekklesiaviva.com

Could I have the password?

Thank you very much in advance.

lapiba, i send you the password.

everyone please redownload the zip file, i think i fixed a problem with the performance.. in my server it's running v fast but for some reasons in older version of php it's a little slow.

for those who installed 3.1, the change is here:
https://vborg.vbsupport.ru/showthrea...050#post304050

nokia let me know how is the speed now? when i went before on your site it was slow, even on forums page, not only on vbhome lite. let me know if the change fix it.
this is what i get me now, with all options enabled:
you have something there very wrong.. it pulls 3 extra queries from nowhere... if you count all queries they add to 17, not 20.
i want to know if anyone else have the same problem, loading slow the page with all options enabled. thanks.

I am in the process of reinstalling vB 2.2.8 and just re downloaded the vbhome 3.1.

I will let you know what happens

ok.. i'm here. i get a email notification every time someone posts on the thread, so i will know when you answer.
make sure you use the new query i posted instead of the previous one. i changed again the LEFT JOIN to reduce the search in tables.

take a look again here:
https://vborg.vbsupport.ru/showthrea...050#post304050

if your file contains the query you see there, then you have the latest updated files. if not, delete all your temporary files and redownload again the file. vbulletin have a prob with attachments in combination with IE. IE wont download the file if is in temp folder, even if it looks like.

I reinstalled vB and vbhome but now my front page is blank. I will try the older version of the vbhome index file to see if it shows up.

Putting the old index file allows the vbhome index page to show but putting in the new file makes it appear blank?

no do not!
is the path probably... take you time and check all steps, why do you rush it??? that's why you endup with 20queries on your page because you mix everything there.

HAHAHA sorry TECK the chdir was commented out. I un commented it now it pulls up.

ok.. but i noticed also that it takes forever to load even your main page???? not the vbHome one? isnt that a server problem?
and make me happy, don't rush it. take your time. you make little mistake and is all screwed. some files are changed some code is altered in a different way to squeeze more out of performance.

so take you time and check all properly.

Here is the microstats from a fresh install of vb2.2.8 with the latest d/l of vbhome 3.1 with the fix already in the index page

Page generated in 13.17248702 seconds (0.70% PHP - 99.30% MySQL) with 20 queries

My test area is running off my @home cable modem so pulling it up outside will be slow.

Pulling up the forums locally gets me

Page generated in 0.16096699 seconds (83.25% PHP - 16.75% MySQL) with 16 queries

Sorry for being such a trouble for you but I really do appreciate all the help you have given :)

so, on the local server it shows at 16queries? the vbHome or the forums? i didnt get you.
it doesnt make sense to add 4 extra queries... from where?? is not possible.

the first stat with 20 is for vbhome the second stat is for the forum page itself

is impossible, look at my stats... and i have all options turned on:

I will try again and let you know :)

remember that you had before 14queries? on the old vbHome?
now if you turn on the polls that's 2 queries and the pm's that's another one, for a total of 17, exacly what i have me.

i use the same file, so there is no magic in there... :)
hmm on your home page, it took like 15seconds to load the nuke portal or what ever it is...

do you have a server online? through your cable? how it is setup your site?

is it possible for you to get all of those templates in to a collapsed folder thing? cause i mean i ahev about 100 custom templates and stuff and having them un collapsed is just more of a mess..

and if you can, how? cause i have a whole bunch i would like to get collapsed

ya it is possible.
open [high]/admin/template.php[/high] and find:
below this, add:
you are done, now all home templates are grouped toghether.

heh that was simple

now how can i move my custom templates down to where you put yours?

you still have old custom templates from previous vbHL?????????
remove them asap.
also, how is the performance on your server? the page loads fast?

TECK,

Im not sure what I'm doing wrong. Did fresh install of both vB and vbhome and with all options on (pm and poll) and placing the get_microstats template in the $templateused area Im pulling 22 queries.

Turning off pm and poll gives me 20 (I know that doest add up since pm is 1 and poll is 2) turning on just pm still leaves it at 20.

Turning off pm and turning on poll gives me 22 and turning on pm and poll off gives me 20.

And you are correct vbhome 3 gave me like 14 log in and 13 as guest. I am unsure where these additional queries are coming from.

I will mess around a little more and figure out what im doing wrong.

Thanks for all your help, it is very thoughtfull of you. :)

it intrigues me to. it doesnt make sense...
i just looked at pimpy's page and it's loading lightning fast...

i dont understand why it's adding extra queries. the only way it adds extra queries if you add new code to your vbHL file, wich is not the case right?
i want you to pm me attached the vbHL file that you have now on the server, i will compare it with mines, ok?

pimpy? please turn on your poll option and pm's temporary. i need to compare the performance.. thanks.

TECK,

pm is sent.

thank you!!!

hehe, no wonder you have 20queries. :)

first, you added there the template microstats, that is already cached in the /forum/global.php file (i hope you did add it there).
second you forgot to put a comma after the word microstats, so all the templates after that are not cached anymore... in other words for every template listed after microststs it will load a a query instead, because is not saved in the server memory anymore... :)

do this nokia, remove the microstats. your list of templates should look like this:
then, just to be safe, open /forum/global.php and make sure your microstats template is listed like that there:
never NEVER, add the template like that, without the comma, if it is in a link string. let me know what's the number of queries you have after... it will be 14 i quarantee you.

and the page will load fast, the way you like it. :)
enable all options and let me know how it does it on your server...

TECK,

Thanks for the check. I did as you stated and yes it dropped 2 queries with both pm and poll turn off from 20 to 18. And the microstats is listed in globals :)

I still dont know what the other 4 queries are.

I enabled all options and my queries are 20. which if funny cuz if pm and poll add 3 together it should be 21?

Page generated in 12.92232895 seconds (0.76% PHP - 99.24% MySQL) with 20 queries

did you pasted my list of templates above?

yep :)

just to be on the safe side i did :)

With the poll option off my page loads under .2 sec but with it on thats when it bogs down to 12 sec.

I still wonder where all these extra queries are coming from.

it's not the query, orelse it would load really slow on everyone's page. i will ask my friend PPN, who is really good with queries if it's ok everything.

from my knowledge, it looks solid like the way it is now.

umm ya i'll check it soon, but the old custom templates are not for this i ment templates for OTHER things..

k i turned on polls and i found NO difference

still did it at same speed, i think it was like .001 secs diff , avg, some times i got less :P

but whats this about turnning on pms? how/where do i do that? its not in the index.php

is not the query. i check it in EMS mysql manager and it returned the results in 0.02sec...
redownload the file pimpy. you dont have the "latest" version...
i added like 5min later the private messages, when i released the 3.1.
so go ahead and download it, the password is the same... then read the uninstall procedure for the older version you have:
https://vborg.vbsupport.ru/showthrea...785#post303785

Hmm, just tested vbHome on my home computer. It works correctly as far as I can tell, but I'll have to heavily edit the templates in order to get a somewhat decent page :)

This might take a while with my current amount of free time :(

you know.. ya really should tell people of this.. :P

ug i hate heaving to un-install and re-install and edit again and UG!

I would like to install the hack. My website is www.warcraft3.it

pimpy, please, be mature.. i said to people this several times.. if you dont read the thread, that's not my problem.
if you are not happy, please dont install my hack. thank you.

intinig, turn your pm's ON, so i can send you the password.

In, vbHL index.php, find this code:
replace it with:
That will avoid the table poll to be scanned entirely to get the poll information you need, increasing the performance.
If your file does not contain the latest query, please update it asap.

Also, still in vbHL index.php, find:
DELETE that line, it will drop your queries to 14 (17 with all options enabled).

where do we post to let you know we want the pwd to the zip.. there is no link on the first thread.... you cant click where it says "click here"