Improved Thread Preview Hack

The idea for this hack was originally that of Parker Clack, a regular here on vBulletin.org.

What this hack does:
Basically, this hack pops up a little box/window when the mouse is run over a thread title that shows the first three hundred characters of the first post in the thread (that is, the post that started the thread).

Improvements to Parker Clack's hack:

• Far, far less code...
• Easier installation (one file edit, one template edit)...
• Less space usage...the beginning of the first post in each thread is not stored twice - only once now!...

Versions:
3.0: Overgrow's search page thread preview instructions.
2.1: Added some necessary instructions.
2.0 Reduced MySQL queries significantly.
1.0 Initial release.

Comments appreciated...

A version for vbHacker is available here - note: some files may need fixing afterward if they present parse errors!

How to Censor Previews (by nakkid)
See page seven of this thread.

A very important security fix is available here - I have not updated the ZIP, so install it after you install the hack

[memdy]

I get this error every time that I try to post. If I press back and then go it will
take.
---------------------------------
Database error in vBulletin 2.2.9:

Invalid SQL: SELECT title FROM thread WHERE threadid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Monday 08th of December 2003 02:44:09 AM
Script: http://www.offshoreonly.com/forums/forums/newthread.php
Referer:
http://www.offshoreonly.com/forums/n...=newthread&for
umid=56
-----------------------------------
The part of the error that reads Script: is an incorrect URL where is it getting that second /forums from ? Why does it work the on the second try? I'ved edited the newthread.php script and see no error in syntax at line 1, this must be a symptom of the real error. Anyone have any suggestions before I rip this hack out and start over.

[spick]

I Installed It But Its Not Working....Help

[imageconstrux]

This is a bit of a side issue, but I thought I'd bring it up. This hack appears to be really handy, and for the vB sites that have it, I use it often. However, if your site generates ad revenues, isn't this a hack that reduces impressions, and opportunities for click-throughs?

It's handy as heck, but seems like it might work against your revenue generation. Just my $.02.

[Dan Collins]

Originally Posted by TheCaver

Is it supposed to take forever to do the tpinstall step2? It seems like it just hangs.....

Board is 50k> threads, 450K posts.....

JC

Check the max execution time setting in your php.ini file. IIRC, the default is 30 sec, which could be insufficient for a large-ish database. The effect would be that the script would just end, with no "Installation finished" message.

[Adi211]

one bug in threadpreview-search.txt

12) Replace with:

PHP Code:

############################################################
<a href="showthread.php?s=$session[sessionhash]&threadid=$searchresult[threadid]$highlightwords" title="fppreview">$searchresult[threadtitle]</a>
############################################################ 


before fppreview, there is missing a "$"

--->
12) Replace with:

PHP Code:

############################################################
<a href="showthread.php?s=$session[sessionhash]&threadid=$searchresult[threadid]$highlightwords" title="$fppreview">$searchresult[threadtitle]</a>
############################################################