Then you might want to take your own advice and do the same in the future, when you start to ramble elsewhere in a thread. ;) And unless I missed something somewhere, I don't think you were made a moderator here, yet. If that sad day ever happens, I guess I'll have to "find a new place to dwell, uh-huh!" :)

'Nuff said. I'm done.

np. i will pay attention to this. thanks.
so far i discussed only issues related to the specific thread, anywhere. btw, that's have nothing to do with being a moderator, is with being efficient. basically you save time if you do a search and if you dont find it, simply ask. people will answer you. i know i will, even if you dont believe it.
as for your query question, try this search: "tie pm query", you will be amased...

Doesn't work. pm is only 2 letters. Thanks, anyway. :)

i send you a pm with all the info you need.

Are we all friends again? Don't let it happen again.

Seems like a very useful hack - I'll give it a shot. :)

Installed and works like a charm :). This is probably the most useful hack I have on my boards, and I think a lot of fellow vBulletin owners agree with that, especially if they are using servers that are being pushed to their limits. This is perfect, now I can keep an eye on the server load and at the same time browse the boards. :D

martin64, i looked at your site and i noticed you didnt hacked properly the db_mysql.php file, that's why you have 100% and 0% values. please double check the steps in that file.

Okay, thanks. I overwrote some files and had to re-add my 3 most recently added hacks so that's probably why I missed it. I don't know what went wrong, but I had to download the 2.2.6 package again and overwrite my old files. :hurt:

It was working earlier, I just hadn't noticed yet. Thanks once again. :D

Edit: fixed. :cool:

Oh, I missed the last few juicy posts! ;)

It is possible, but only if you remove a few standard features.

I took out invisibility (that's 1), and forumjump (that's 2). The hacks in my showthread did not do queries.

Since then though, I have moved servers, and with a faster server I have put back forumjump, and reinstalled who is browsing this thread. I also reinstalled the "Users Online in Header".

This has brought my showthread back up to 23. (Page generated in 1.00907195 seconds (67.16% PHP - 32.84% MySQL) with 23 queries.)

My index is now at 17 queries. (Page generated in 0.29747605 seconds (82.73% PHP - 17.27% MySQL) with 17 queries.) - I did this by combining the PM queries, removing the query to count threads (I only display posts), and also keeping invisibility off. But using the "Users Online in Header" adds an extra 2 queries to every page.