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

[beemer]

Ok, I thought I had run the tpinstall file, but when I checked again, I see it isn't really running. I open it up in the browser and I can see the code that it is supposed to install but how do you actually get it to run? (It doesn't display as a clean web page they way I would think it is supposed to.) I see the two next hyperlinks If I click on them I get file not found on the first one and Nothing happends if I click on the second one?? Any suggestions on how to get this to run. I am using Windows 2000 if that helps.

[N!ck]

did you rename it?

[beemer]

Sorry, I figured it out. Didn't realize you have to run it through the web service. I was just opening it in a browser. When I ran it through the web service, everything worked. Will the version you have posted work with dots on or do they have to be off?

[N!ck]

it's not a normal HTML page!!!!! duh!!!!! upload it first!

[N!ck]

here's the vbHacker version

[BigJohnson]

im getting errors with the tpinstall.php file here it is

Database error in vBulletin Control Panel 2.2.4:

Invalid SQL: ALTER TABLE thread ADD firstpostid INT(10) UNSIGNED DEFAULT '0' NOT NULL
mysql error: Duplicate column name 'firstpostid'

mysql error number: 1060

[BigJohnson]

bump

[Velocd]

I'm having a problem with the search part of the hack right now. I'm getting this error:


Database error in vBulletin 2.2.4:

Invalid SQL:
SELECT DISTINCT post.userid,
thread.threadid,thread.threadid AS postid,thread.title AS threadtitle,thread.iconid AS threadiconid,thread.replycount,
thread.views,thread.pollid,thread.open,thread.last post AS postdateline,thread.lastpost,thread.lastposter,
forum.forumid,forum.title AS forumtitle,forum.allowicons,attach,
thread.postusername AS usrname,
user.userid AS postuserid, post2.pagetext as pagetext,
threadicon.iconpath AS threadiconpath,threadicon.title AS threadicontitle
FROM
thread,forum
LEFT JOIN user ON user.username=thread.postusername
LEFT JOIN icon AS threadicon ON thread.iconid=threadicon.iconid
LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '1') LEFT JOIN post AS post2 ON (thread.firstpostid = post2.postid)
LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '1')
WHERE
thread.forumid=forum.forumid AND thread.threadid IN (0,14)
ORDER BY
thread.lastpost DESC,thread.lastpost DESC
mysql error: Not unique table/alias: 'post'

mysql error number: 1066

Date: Sunday 24th of March 2002 10:06:49 PM
Script: http://www.diffusion4.com/search.php...der=descending
Referer:


Any clue?

[BigJohnson]

bump

[N!ck]

for big johnson: this has been added to the FAQ.

for velocd: not sure...i'll look into it