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.

[Okiewan]

Humm...

When searching in a thread, all it returns is a blank page ...
which is "http://domain.com/forums/newreply.php"

The only install issue I found was in search.php:

Find:

PHP Code:

 post.visible=1 AND thread.visible=1 AND $newpostsql $search[query] 


My file had:

PHP Code:

post.visible=1 AND $newpostsql $search[query] 


Regular searches work.
ver 2.2.1 (yes, I know )

Help?

[N9ne]

Erwin, guess what! vB3 IS USING SEARCH THREAD!!!!

I'm not sure if it's the same code as yours but it probably is! Congrats!

[Erwin]

2.2.1? May not work for that. As the title of this hack suggests, it works with 2.2.8.

I suggest you upgrade - 2.2.1 has security holes the size of the Titanic.

As for vB3 - great!!! No need to update this hack when it comes out! I did suggest this to them after I wrote it.

[Okiewan]

I'll be waiting to see 3.4 out of beta before upgrading 20,200 members. I've got two years of hacks to re-apply, no way am I taking an interum step.

Thanks for the reply.

[CRego3D]

good job .. works great

[CRego3D]

Erwin

on your "search results" .. we get a more detailed search with your hack then a regular forum search gives us (on your I see parts of the post and all) .. I rember there was a hack that did that for the main forum search .. do you know wich one is it ?

[Erwin]

My hack actually just uses the inbuilt vB functionality of searching for posts - you can do it for any forum, by clicking on Adcanced Search, then choosing "Show Posts" rather than "Show Threads". I just made it so that you can specify a forum from within the forum.

[SpeedStreet]

Erwin,

This hack was very well written, and very easy to follow!

/me installs

[BigJohnson]

Like the other X fan i am getting the same error

Database error in vBulletin 2.2.5:

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

The only time i get this error is when I click the button that says

See all posts made by this user.

The search thread hack works fine. It is just searching peoples posts it don't work. Please I don't know what to do.

Why is it doing this.

[Erwin]

I assume you are using 2.2.8. If so, then you need to uninstall the hack, and install it again. That error you are getting looks like an error with your search query - possibly one of the variables is written wrongly.

As you can see on this site which is using the same hack, and on many other sites, the hack works perfectly.