this hack will save you a huge amount of space. rather than storing the beginning of the first post of a thread, it stores only the ID of the first post!

if you DO want to change back over, you'll need to drop the extra field in your "thread" table and do some modifications to newthread.php and forumdisplay.php (and perhaps some un-modifications to other files as well ;)), then run the install script. really all the install script does is creates the new field ("firstpostid") and goes through each thread (this may take some time and bandwidth depending on the number of threads you have - my fairly new board had about 20 threads and the install script still went as fast as lightning), getting the ID of the first post and storing it.

nick:

Nice way of doing this. When you get it all together with freddie's and Overgrow's suggestions and the search function finished could you put it all together in one file to download?

Thanks for idea of adding this to the search page though. I never thought of that!

Since I have over 200G of storage space on my server space is not an issue. :)

Parker

Parker, the search page previews are Overgrow's idea :)

The instructions for the search page will be in version 3.0 of the hack...probably to be released tonight because I think I'll just steal Overgrow's entire post (and give him credit for that of course) and put it in a text file.

The search page instructions have been added. :)

bump :D

:D

is it easy to uninstall this biatch? :D

I had Parker's one for a while, but i reverted back to the original php files

Fazle:

Did you have problems with it on your board? So far so good for me using either version.

Parker

oh no, not at all.... my board has 350-420 users online usually around peak times and gets 22k-25k posts a day...so the extra queries were making things a little slow :)

there's a new version with no extra queries ;) download it, make the appropriate changes to your forumdisplay.php, and (if you want), do the modifications to search.php