One of my forums, gzipped length:

20448 - with preview
13791 - without preview

To drop the field:

ALTER TABLE `thread` DROP `firstpostid`

Hmm installed correctly to the letter but Im getting no popup with mouseover :(

I uninstalled Parker's version and installed this one with no problems. This one works well, and just a tad quicker.

Just a note: not sure if anyone else has pointed it out, but the instructions in "threadpreview-search.txt" has a minor mistake:

In step 12

It should be like this:

Just a missing $ in $fppreview.

:) Well done!

oooooooooooh yeah! typo!

ariaforums > make sure you leave your mouse on the link for a second without moving it...

if that doesn't work, you've done something incorrectly

so erwin, post your url :)

If someone has this working is it possible to post your vBulletin version? I have 2.2.4 and I constantly get this error, dots on or off.

Database error in vBulletin 2.2.4:

Invalid SQL:
SELECT DISTINCT post.userid, IF(votenum>=2,votenum,0) AS votenum,
IF(votenum>=2 AND votenum > 0,votetotal/votenum,0) AS voteavg, post2.pagetext as pagetext, icon.title as icontitle,icon.iconpath,
thread.threadid,thread.title,lastpost, forumid,pollid,open,replycount,postusername,postus erid,
lastposter,thread.dateline,views,thread.iconid,not es,thread.visible,sticky,votet otal,attach
FROM thread
LEFT JOIN icon ON (icon.iconid = thread.iconid)
LEFT JOIN post ON (thread.threadid = post.threadid AND post.userid = '1') LEFT JOIN post AS post2 ON (thread.firstpostid = post2.postid)
WHERE thread.threadid IN (0,411,399,363,322,331,313,77,78,28,95,286,280,245 ,148,217,200,163,160,129,112,1 13,114,106,103,81)
ORDER BY sticky DESC, lastpost DESC

mysql error: Unknown column 'thread.firstpostid' in 'on clause'

mysql error number: 1054

Date: Sunday 17th of March 2002 12:18:54 AM

yeah...ummmm...run the install script first or it won't work ;)

and please post your url too... i always like to see this in action

Hmmm just reporting I have the hack working correctly now with no noticble overheads, I think I uploaded the unedited forumdisplay.php by mistake the first time LOL

;) sounds good!

Installed it, works like a charm :)