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]

What's the error, Chris? What version vB are you using?

[Dany]

Hello Erwin,

I have this Error when trying to search the thread.

Database error in vBulletin 2.2.9:

PHP Code:

Invalid SQL: 
        SELECT
          post.postid, thread.visible
        FROM
          post LEFT JOIN thread ON thread.threadid=post.threadid
        WHERE
// REPLACED with search thread - Erwin
          post.visible=1 AND thread.visible=1 AND  post.threadid=59462 AND   post.postid IN (258360,0) AND   1=1  AND NOT (thread.forumid='19')
// search thread - Erwin
      //  post.visible=1 AND thread.visible=1 AND  post.postid IN (258360,0) AND   1=1  AND NOT (thread.forumid='19')
                    ORDER BY
          post.dateline DESC,post.dateline DESC
        LIMIT 0,20
        
mysql error: You have an error in your SQL syntax near '// REPLACED with search thread - Erwin
          post.visible=1 AND thread.visib' at line 7

mysql error number: 1064

Date: Tuesday 04th of February 2003 08:50:34 PM 


Any help?

[Erwin]

Just remove all the // lines and it will work. You cannot put // comments in the middle of a search query like that.

[Dany]

Thanks Erwinnow, now it works fine

try changing this:

<table cellpadding="2" cellspacing="0" border="0" width="95%"  align="center">
<tr valign="bottom">
	<td align="right">
	<table cellpadding="0" cellspacing="0" border="0"><tr>
	<form action="search.php" method="post">
	<td><smallfont><b>Search this Thread:</b>
		<input type="hidden" name="s" value="$session[sessionhash]"><input type="hidden" name="searchdate" value="-1">
		<input type="hidden" name="beforeafter" value="after"><input type="hidden" name="threadid" value="$threadid"><input type="hidden" value="1" name="showposts">
		<input type="hidden" name="action" value="simplesearch"><br><input type="text" class="bginput" name="query">$gobutton
	</smallfont></td>
	</form>
	</tr></table>
	</td>
</tr>
</table>

with this:

<table cellpadding="2" cellspacing="0" border="0" width="95%"  align="center">
<tr valign="bottom">
	<td align="right">
	<table cellpadding="0" cellspacing="0" border="0"><tr>
	<form action="search.php" method="post">
	<td><smallfont>
		<input type="hidden" name="s" value="$session[sessionhash]"><input type="hidden" name="searchdate" value="-1">
		<input type="hidden" name="beforeafter" value="after"><input type="hidden" name="threadid" value="$threadid"><input type="hidden" value="1" name="showposts">
		<input type="text" class="bginput" name="query" VALUE="Search this Thread" OnFocus="if (value == 'Search this Thread') {value =''}" OnBlur="if (value == '') {value = 'Search this Thread'}" size="20" dir="ltr">$gobutton
	</smallfont></td>
	</form>
	</tr></table>
	</td>
</tr>
</table>

[Chris M]

@Erwin -

Database error in vBulletin 2.2.9:

Invalid SQL: SELECT COUNT(*) AS posts FROM post
WHERE post.visible=1 AND post.threadid= AND 1=1 AND post.userid='1'
mysql error: You have an error in your SQL syntax near 'AND 1=1 AND post.userid='1'' at line 2

mysql error number: 1064

Thats the error I get

I use vB2.2.9

Satan

[Erwin]

You installed the hack wrongly.

Uninstall it, and install it again, following the instructions EXACTLY. It is very easy to make a mistake with this hack. It works as long as you make sure you follow the instructions word for word.

[Chris M]

Erwin - I did install the hack correctly - I have rechecked all the instructions from the file I had downloaded, and they are all as they should be

I will re-download the hack, and check to see if there are any differences

Satan

[Chris M]

Nope...Not a single one

Satan

[Erwin]

PM me your search.php and I'll take a look.

[Chris M]

Ok

Pm on the way

Satan