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

[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

[blazin]

I installed the hack and it works only with the threads that existed at the time of the hack install.

Any new threads that have been made after the install do not show a preview.

The firstpostid field is 0 on all new posts...if I change it manually to some value it works

Any ideas?

[rseidl]

Hope i dont get jailed for asking this but

1. would this hack work for vb3 also ?
and
2. does the zip file on page 1 of this thread include the "missing" $ sign and control panel on/off switch
Looks very useful ! Thanks

[MaDCaT75]

Nice hack

/me clicks install

[richier]

I am having an issue after installing this hack. I have VBportal installed and every thing is working fine except when a new thread is started it double posts the starters post

It's some where in here and I can't find it

// vBPortal Begin
// create first post
$DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmili e,showsignature,ipaddress,iconid,visible) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($ subject))."','".addslashes($po stusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($mess age)."','$allowsmilie','$signa ture','$ipaddress','$iconid','1')");
$DB_site->query("UPDATE thread SET firstpostid = '$postid' WHERE threadid = '$threadid'");
$DB_site->query("INSERT INTO post (postid,threadid,title,username,userid,dateline,at tachmentid,pagetext,allowsmili e,showsignature,ipaddress,iconid,visible,topic) VALUES (NULL,'$threadid','".addslashes(htmlspecialchars($ subject))."','".addslashes($po stusername)."','$bbuserinfo[userid]','".time()."','$attachmentid','".addslashes($mess age)."','$allowsmilie','$signa ture','$ipaddress','$iconid','1','$topic')");
// vBPortal End

$postid=$DB_site->insert_id();

indexpost($postid,1);

[Ludelover]

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

I get the same problem

[Ludelover]

yo how do i unistall this thing? When I ran tpinstall.php i got to step 2 and it hangs. Now the board is slow as funk. It's fast 99% of the time.

[klaattu]

Click "install"

Wow wonderful hack and so simple to implement, it works perfectly if anybody wants to check it go http://www.clioclub.com.mx

By the way since that forum is only 10 days old I made a backup of the database (it download to my computer with the _db_.sql way so here are a few questions:

If my tables get corrupted or something while running the tpinstall.php file how do I reupload the tables?

I am nervous because my other site has mor e time a lot of more posts and members so I dont want to kill my self because I killed my database, any recomendatiosn, procedures or ways to fix if th e unexpected happens??

Thanks again and best regards Juan Carlos

[alkatraz]

Originally Posted by Fazle

In the instructions > the threadpreview search .txt file > at the very bottom in the template change part, its missing a $ before fppreview

The original zip for this hack still HAS the $fppreview bug, can someone please update it.


Thanks for the hack! Excellent idea

[magnus]

I'm suprised there has been no attention paid to ~rc~'s post (https://vborg.vbsupport.ru/showpost....&postcount=127) about the exploit. I've tried to duplicate it, but I couldn't.. perhaps I'm doing something wrong.

Has anyone else had any success in duplicating this? Has it been fixed in 2.3.0, because in a Who's Online it doesn't provide any links for Mods/Admin's nor will it allow me to hijack a searchid.