heheh what you talking bout willis, im my own host hehehe\
but how would i keep queries under 40

reduce the number of queries by removing any unnecessary hacks.
vbPortals is known for adding a huge amount of queries to your main page. the optimal no. of queries for a board is max. 40. after that you start to get your server on the red side. immagine that you have 1000 users and they proccess 60queries at the same time. that's 60,000 queries in the same fraction of time. that can double easy if they do a mix between the frontpage (average 90 queries for vbPortal) and vBulletin.
wajones did an excellent job with the portal, but in my personal oppinion i think it puts alot of stress on the server.

try this, place {getmicrostats} in your homepage. let me know the results. ;)

also keep in mind that an unhacked board have only 17queries.

I'm getting no where with this hack :(

Would it be posible for someone to send me the changed files so I could compare them with what I've got?

I know I'm doing something wrong, I just can see what! I've followed all the instructions and tried 20+ times to get this hack working on a non-hacked board.

Thanks In Advance,
Lee

that was my forums homepage

well this is what I got on the acutal main page ( vbportals )

Page generated in 0.5270550 seconds (92.09% PHP - 7.91% MySQL) with 9 queries.
PHP version 4.0.6 (Debug mode) with GZIP library compression enabled (level 1). [details]

wow.. that's great, wajones changed the code structure?? i used to see people here posting that they got 120queries... i never installed vbPortals.

NTLDR, add me to your messenger. i will help you. ;)

yeah vbportals has been nothing but succes for my site

ok I will add you to my buddy list

Sorry its taken me so long to get back to you nakkid, I ended up falling asleep before I read your reply last night :)

If the offer of help still stands I've added you to my Messenger contact list.

Thank You
Lee

np lee. just contact me. i will help you install this hack. is my pleasure to give you a hand on this issue.

Thank you nakkid,

Its peope like you that make this such a great community to be part of :D

I've just had a thought, I tried to run repair.php, I can't use that as it requires MySQL 3.23 or higher, I have MySQL 3.22.23 and PHP 4.1.2, could this be the problem, that this hack won't work with those versions?

According to vBulletin.com vBulletin shouldn't even run on that low of a version... I'd upgrade ASAP.

I've got vBulletin working fine, I haven't had any problems with it, I've got to change host as my current one has provided me v.bad service lately.

Anyway, thanks to nakkid, I have got this hack working on my forums :D

He's a real creadit to the vb.org community, great hack and even better support, thank you nakkid.

credit? no. but thanks for the nice words. as for the help, i try to do as much as i can. i'm glad we got it working. ;)

This is a very cool hack thanks!

glad you like it. ;)

Just installed it, looks great :D

But, I dont understand this part of the install instructions:It works fine without it, but im confused to what it does, and what 'no template' Mod means...

Anyway, keep up the good work :)

Alan (DWZ)

is for people who dont want to add a template, but instead to hard code it.. i do this all the time, i dont add templates. so i made it in 2 ways: for those who want a template based code or for those who want the actual php code. that's all. :)

oh, ok cool :)

Thanks for your help :D

Hi could someone maybe help me... I am trying to get this to display on my main page. I am using vBPortal and it only shows the amount of queries everything else is blank if I use what is in the getmicrostats template. Anyone else try doing this yet or what? I have to insert this into the VBP config.php file in the footer section I know just dunno how to get it to display :). I don't have a footer template for VBP from what I can gather sifting thru my templates. Anyhoo thx for any help and nakkid you did a fine job.

I'm trying to install this hack, but I'm running into a problem with the first edit. :ermm: In global.php I'm supposed to change
But in my global.php I have the following:
Before I proceeded, I wanted to check here and see what I should be replacing.

replace:with:you probably dont have 225 installed. in the install file, read below the 225 segment, it will tell you how to install it for other versions.

Nakkid - thanks for the fast reply.

According to my control panel, I have 2.2.5 installed. I always keep up with the latest version of vB. However, now that I'm adding hacks to the mix, I may delay installing them so fast and wait until I know that my small collection of hacks will work.

The point is, I do have the latest version of vB installed. So, if this code does not look kosher, then perhaps it did not install correctly?

I'm going ahead with the code snippet you gave me and proceed from there and I'll let you know how it goes. Everything else appears like it will work just fine.

Thanks again Nakkid.

ok.. let me know. i'm sure you will get it working perfectly. :)
just make sure you follow at letter the instructions, there is alot of code to be changed.

all the best,
nakkid.

Nakkid,

Yes, thanks to your input the hack worked just fine. However, I've run into another bug with the register process, so I un-installed the hack just to make sure it wasn't your hack. It wasn't. :knockedout:

But it appears that the Country Flag Hack I installed the day before is the cultprit. So, once I track down the bug, I plan on re-installing your hack.

Thanks again for all your help and I'll let you know how it goes.

you are welcome mashby. ;)

hi nakkid,

I'm having the same problems NTLDR was having, my templates arent working anymore, as soon as I upload the new function.php. What was the fix for NTLDR - was it a provider problem?

greetings Tina

he wasnt sure how to insert the code into the files.
also he had a problem with the PHP version, he was running a really old one on his localhost. read more in the thread here. about what version he had.

contact your host and ask him to upgrade asap. older php code have bugs.

Well, I found part of my problem. I re-installed 2.2.5 to clear out all the hacks and to make sure that everything was hack free.

I re-installed the Welcome Panel hack and then this hack. Everything appears to be ok, except now when I go into the Control Panel, I get nothing. No page renders at all.

Everything else appears to be working just perfectly. The stats are appearing on each page as expected, all other sections of the site are great, but I simply cannot access the Control Panel.

This is the source from the Control Panel

Hi Nakkid,
thanks for your reply. I've read all that, but he doesnt really go into detail. Well, the newest verison of PHP is installed on my server, so that's not the problem. I do admit I have some hacks installed on 2.2.5 and I guess that's what's causing the problems. However, I dont want to miss out on those hacks. The hacks I have installed are the same ones FireFly has here and he's obviously got the vbmicrostats working, so theoretically there must be some way that it should also work for me ... It's really a pity that it's such a senstive, although cool script.

greetings Tina.

you edited admin/global.php
read carefully the install instructions.

Hi,

thanks for this hack, great stuff. :)
cu,
-Tom


Hack installed in 0.87553499 minutes (80.31% Copy - 19.69% Paste) with 0 queries. ;)

tina, the hack should not interfere with any other one.. it's all related to microtime.

I've got over a hundred hacks on my forum, and this hack does not interfere with any of them.

nakkid, you are using an undefined constant in your code (DEBUG). This causes the "Debug Mode" flag to be on no matter what.

you are referring at $PHP_SELF? it doesnt really matter since i want to read the actual file i view. let me know if i'm correct.

No, I am talking about DEBUG - a constand. You have in your code something like this:
Which is not correct, because there is no such constant. Not in PHP nor in vBulletin.
And since vBulletin runs on error reporting level of 7, PHP doesn't warn you and treats it as a string. And since that string always evaluates to TRUE, you will always get 'Debug Mode'.

you are right firefly... doughh.. :cross-eyed:
here it is what i did:
---------------------------------
in functions.php add $debug, before $microstats, like that:then i inserted this code:should i use the define();? all i want to do is check what is the DEBUG mode on the apache server. let me know if the code is reliable. thanks.

Apache's configuration has nothing to do with PHP. $debug is a variable set by vBulletin (well, the admin sets it in config.php if he wants to use debugging options). Debug mode refers to vBulletin, not PHP / the server.