most excellent... I had it up and running on my test site in about 5 minutes...and it worked great!

then I moved index.php to my production site... and ....too bad I forgot to add the cache table to my production site....but that only took about 10 seconds and I beat everyone before they saw the mysql error that I did...

it works great and I love it!

- jeff

thanks for the kind words :)

i found out it works nearly perfect, just a small thing i had to change before it will be moved into full releases :)

i think it will be there before next year ;)

:clicks on install:

It works very well and i have noticed that my forum home loads a lot quicker.

One for forumdispay and showthread would be really nice:)
This is the next best thing to microstats :p

Thanks to Xenon my forumhome:
Page generated in 0.09714496 seconds (75.75% PHP - 24.25% MySQL) with 13 queries.

Great hack! It = teh winnar. I now get 0.2-0.3 second forumhome generation times, with 18 queries if cached, 25 if not.

Since I have the persistent mark forums read hack by ethank installed I had to modify part of that in member.php to be able to get forum lights to turn off, but other than that, it looks to be working perfectly.

One for showthread would be HUGE :eek:

I noticed after installing this hack, total post count is off by 10... there are 111979 post records in the database but the sum of the replycount column is 111989.. there are 10 extra posts somehow (10 is how many forums I have which have posts in them, but I don't know why this would have any effect)

Running the counters again didn't help.

Just installed this, and it works great! My forum home page went from around 32 queries down to 19!

I'm wondering if there's any way to add this to vbHome for those (like me) who use that as their site's portal page?

Vote Xenon for vB Dev :-p

This is a great method, I would love this for the all of vb

*ggg* thx Arunan :)

@X-Fan: When i have more time and completly finished this beta, i will work with TECK on an inclusion into vBhom (lite) :)

@fury: There are two possibilities:
1. your counters are wrong (update your counters, be sure you'll do in the right order (first threads then forums)
2. you have orphan posts which don't appear in any threads...

Ok, uploaded a little modified file now
Moved the thread to Full Releases

thanks to all who helped me in the betaphase :)

i get a gzinflate parse error at the top of the forum index after replacing the old code with the new. (?)

Awesome i'll try this on my localhost tonite :p

@NuclioN: How old was your last version?
the last update justs changes a small if-clause nothing with the gzinflate function...

as a tip, just empty the whole forumcache table and it should work again

Wow this works wonders Xenon..

Reduced my testboard from 19queries to 14queries when dont on a fresh install :)

- miSt

How well does this work with hacks that are installed?

There's some that won't work very well (or at all) with it, that is why I had to un-install it. Great idea, though. :)

thats a shame.

Yep well i'm sure there's a way around it and Xenon will guid you all the way :p

@Smoothie: it depends on the hack, subforums on forumhome for example works perfect and has a huge effect on reducing queries.

if you are a little experience you can nearly make every hack to work with it.

but it doesn't work with this hack:
# of users browsing on Forumhome

Hmm...

I can't remember if I have that one installed:(

*damned script kiddies attacking my Hosts server:mad:*

I will test it out on DB when it gets back up:)

Satan

you'll like it chris :)

Hehe no doubt;) It will probably reduce my Forumhome queries considerably - At last check, I think I had 24 or 26:)

Satan

Don't have that one installed, but I do have a hack for Photo Post installed.

My counters were already updated like a billion times. Doing the orphan posts option didn't find anything either. :(

Xenon, it shouldn't work that way IMO.
It would be tons cleaner if it was only updated when a new mod is added.
Current version waits for a new post/new thread for being made and then updates the moderator db table.
Not so useful for busy boards. ;)

@Smoothie: Just test it out if it works :)

@fury: As i know the orphan post function just finds posts where threadid is 0.
but there can also be some posts where threadid > 0 but the thread they belong to is deleted.
my hack shows not the ammount of posts that are saved in the db, just the ammount of posts which can be viewed by at least the admin. So i'd say my method is better, normally the ammount should be the same, but if you've had a little problem some time ago you can have this difference :)

@nuno: It's an optimization of the loading time of the forumhome.
When you have a busy board the updated way is really enough, because you'll surely have a new post shortly after adding a new moderator.
just on not so busy boards the cache can be too old for you :)
For the hackinstructions i prefer the easier way, but of course you can add one query to the add moderator function to always update the cahce afterwards: [sql]DELETE FROM cache_forumhome[/sql]
As i say it's not needed, you have to modify other files, too, but you can do, without any negative aspects except of little more work ;)

It worked fine for some hours, then this:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 4081664 bytes) in .../index.php on line 408

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 45 bytes) in .../admin/db_mysql.php on line 77

Any ideas?

hmm, you don't have the zlib installed on your host have you?
if you have not, the whole html is saved uncompressed in the db, which will blow the table very fast. especiall when there are much users online.

try to contact your host to install zlib and allow more memory :)

i think that's the problem....

I do! (Or I think I do - I'm obviously no expert. :D) This is what phpinfo tells me:

zlib:
ZLib Support - enabled
'zlib:' fopen wrapper - enabled
Compiled Version - 1.1.3
Linked Version - 1.1.3

hmm, then the error seems a bit confusing to me...

maybe you can try this:
instead ofuse smaller values as the timespan:

heh Xenon, could it be some kind of caching proggie, Martin's problem?

i really have no idea what the problem could be...
4081664 < 8388608, so it shouldn't be an error....

You mean a caching proggie on the server right?
Well i haven't seen any till now, so i don't know how they work exactly, i wouldn't say this would be the problem, but i can't say for sure :)

Yup, something like php cache, apc used to do that, the memory errors.
Wild guess i think.

hmm, maybe you're right, i don't know these scripts.
but it could be, the hack is ok....
also if this is the bug with those cach?ng software, i can't do anything :)

Is there some way of finding out if this is the problem?

hmm, disable the software ;)

But WHAT software? :confused: What software is it that might cause these problems, and how can I check whether it is installed? (Sorry for all my whining ;))

Is it a dedicated or shared server?
FreeBSD, Linux, Windoze?
Upload this code into your forums folder
Save it as phpinfo.php
You should see something like

Nope. It just says And it's Linux, BTW.