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.

[ViewMy.biz]

While I have installed a couple of hacks before I don't think I have ever:

"1. Running 1 database query"

How do I do this?

[ViewMy.biz]

What does "Running 1 database query" mean?

[Erwin]

Today at 09:23 AM 4326692027f8 said this in Post #112
What does "Running 1 database query" mean?

It means running a database query in phpMyAdmin or any other MySQL database manager. If you don't know how to do this, there are online tutorials on this site - search for them.

[Oblivion Knight]

Working like a charm..

Thankyou Erwin!
[high]* Oblivion Knight clicks install.[/high]

[shungo]

Hi there

After installing this hack i got the following error when i tried to view new forum messages :

Database error in vBulletin 2.3.0:

Invalid SQL: INSERT INTO search (searchid,query,postids,dateline,querystring,showp osts,userid,ipaddress,threadid) VALUES (NULL,'1=1 AND thread.lastpost>=1051757847 AND thread.open<>10','',1051762224,'','0',1,'80.13.127 .83',)
mysql error: You have an error in your SQL syntax near ')' at line 1

mysql error number: 1064

Date: Thursday 01st of May 2003 06:10:24 AM
Script: search.php?s=&action=getnew

Can anyboddy help me please ??

Best regards

[Erwin]

You installed the hack wrongly - uninstall, and do it again. Like I said in the instructions, one wrong cut and paste, and it won't work.

[shungo]

Ok, it works very nice now !

Sorry and thx for your answer

Congratulations for all your hacks, you make a really good job

[PhoenixBB]

Has anybody got this working with 2.26? I don't want to upgrade as it took me all my time to install various hacks and I can't face it again.

I've compared my current search php with the original 2.26 and it's unchanged. There is changed code obviously in the 2.30 search file. Could it work if I just did a straight swap? Or could that do bad things to the board?

[WEForums]

Today at 01:23 AM PhoenixBB said this in Post #118
Has anybody got this working with 2.26? I don't want to upgrade as it took me all my time to install various hacks and I can't face it again.

I've compared my current search php with the original 2.26 and it's unchanged. There is changed code obviously in the 2.30 search file. Could it work if I just did a straight swap? Or could that do bad things to the board?

https://vborg.vbsupport.ru/showthread.php?s=&threadid=38545 (How to upgrade hacked boards)

I recommend you do that and don't swap any files. Any code alterations in one file means other files have been changed as well (most likely anyway).

[tamarian]

Great hack Erwin!!!

This should be a feature in stock vB