Search Thread

Search Thread - by Erwin Loh
-----------------------------

This hack will add a "Search This Thread" search box at the bottom of threads (similar to the "Search This Forum" search box at the bottom of Forum Display).

Should be useful for loooooooooooooong threads, especially for a forum like this one.


Demo
-------

This hack is installed here at vB.org - just use the Search This Thread box at the bottom right hand corner of this page.


Features
-----------

1. Only posts from the thread will be searched.
2. Uses that standard searchindex table.
3. Uses the same vB search algorithms.
4. This will add NO extra queries to your forum.
5. Uses the standard search and forum permissions set by you.


Installation
------------

1. Running 1 database query
2. Making 2 changes to showthread.php
3. Making 6 changes to search.php
4. Making 1 change to template "showthread"
5. Adding a new template "showthread_searchthread"

Enjoy!

Please click install if you want updates to this hack!

Dr. Erwin Loh

I've updated the installation text file to make things clearer, and made the search box visible to guests as well.

[Erwin]

It's incorporated in vB3.

[tamarian]

Today at 02:30 AM Erwin said this in Post #121
It's incorporated in vB3.

I think I've suggested it way back when

[S.Shady]

works perfect thanks

[DiscussAnything]

i really like this hack and it works fine, but i am having a side-effect and I'm not sure why. I did everything the instructions said, and it works fine. But if i go into a users profile and 'find all users posts' it gives me a database error:

PHP Code:

Invalid SQL: SELECT COUNT(*) AS posts FROM post 
LEFT JOIN thread ON thread.threadid=post.threadid WHERE post.visible=1 AND post.threadid= AND 1=1 AND NOT 
(thread.forumid='12' OR thread.forumid='10' OR thread.forumid='11') AND post.userid='2' 
mysql error: You have an error in your SQL syntax near 'AND 1=1 
AND NOT (thread.forumid='12' OR thread.forumid='10' OR thread.forumid='' at line 2 

mysql error number: 1064 


the post.threadid is empty there, which seems to cause the error. Why would a 'thread search' have that effect on a 'find users posts' function, and am i the only one that has this problem? As far as I'm aware this is the only change to my search.php

any help is apprecatied

[FleaBag]

Finally got around to adding this hack, should come in handy.

Thanks Erwin.