Add Search/Sort/Order in thread view

Add sort, order, search, posts from user options at the end of the thread.

Latest version: 1.20 (6-27-2002)
- Bug fixed: at every search views counter is increased (link)

Features:

• The following options are available:
  - Display posts from previous xx days
  - Sorted by Post date, User name, Subject, Attachement, Post length
  - Show the post of all/definite users (with number posts)
  - ascending/descending
  - Search in Thread
    » Show only posts in which the search string was found (v1.20)
    » Own replacement for highlighted words possible (v1.20)
    » String search in words
    » Also mark parts of words
• Decide which options shall be shown (simple template change)!
• Show message instead of a empty thread, if the sort result = 0 posts (v1.10)
• This hack is compatible with:
  - TWTCommish's hack 'View All Attachments in Thread'
  - FireFly's beta hack 'Multiple Quotes'
• Tested with vBulletin 2.0.3, 2.2.5, 2.2.6
• It works with vBulletin 2.0.3 to 2.2.6 now.
• Very simple installation:
  - 2 Templates must be made
  - 1 Template must be changed
  - 2 Files (showthread.php, admin/functions.php) must be changed
• Look at the screenshot for more informations...

Updates 1.20 (6-24-2002):
- Show only posts in which the search string was found
- Own replacement for highlighted words possible
- String search in words
- Also mark parts of words
- Update instructions in download archive

Updates 1.10 (6-19-2002):
- Show message instead of a empty thread, if the sort result = 0 posts
- Now compatible with: FireFly's beta hack 'Multiple Quotes'
- Bug fixed: if you use the links 'Previous Thread' ... 'Next Thread' in thread...

Screenshots:
- Thread view

Installation:
- Read !readme.txt in ZIP-ARCHIV!

Download:

[Edgar]

I get a few erros as soon I uploaded my modified showthread.php file, can anybody help me?


Database error in vBulletin 2.2.6:

Invalid SQL:
SELECT post.postid FROM post
WHERE post.threadid='3351' AND post.visible=1 ORDER BY LIMIT 0,15

mysql error: You have an error in your SQL syntax near 'LIMIT 0,15
' at line 3

mysql error number: 1064

Date: Saturday 22nd of June 2002 06:11:46 AM
Script: http://www.avalancheonline.net/forum...&threadid=3351
Referer: http://www.avalancheonline.org/forum...p?s=&forumid=3

[bad_madman]

Originally posted by Edgar
...I get a few erros as soon I uploaded my modified showthread.php file, can anybody help me?...

Something seems to be missing there. Check the place still time. In the file showthread.php must be at this place:

$getpostids=$DB_site->query("
	SELECT post.postid FROM post
	WHERE post.threadid='$threadid' AND post.visible=1$threadadds
	ORDER BY $osofin $postorder LIMIT ".($limitlower-1).",$perpage
");

[bad_madman]

Originally posted by BigJohnson
Can you please help me with this.

Go to the vB admin CP area.
1st replacement:
- Click there on Replacements -> Add.
- Code to find: <myhighlight
- Code to insert: <b><i><font color="red"

2nd replacement:
- Click there on Replacements -> Add.
- Code to find: </myhighlight>
- Code to insert: </font></i></b>

[Edgar]

Ok, I found it, my showthread file was a little messed up and the quick reply box interfered somehow, I readded all the hacks in it and it seems to be working fine now.

Great hack madman and thanks!
Cheers.

[BigJohnson]

OK your thing worked great for the different templates. Thank you so much. You are the best.

[bad_madman]

New version out: 1.20

Updates
- Search in Thread
&nbsp; &raquo; Show only posts in which the search string was found (v1.20)
&nbsp; &raquo; Own replacement for highlighted words possible (v1.20)
&nbsp; &raquo; String search in words

Screenshots:
Screenshots in the first post.

Download:
The latest version is in the first post of this thread.

[Boofo]

Is there any update instruction if we have it installed already? You know how bad my template had to be redone.

Originally posted by bad_madman
[B]New version out: 1.20

[bad_madman]

Ok, I changed the download file again. The update instruction are contained in the download archive now ... run sqltodos.php and then select "Click here for an update installation from v1.10"...

Originally posted by Boofo
Is there any update instruction if we have it installed already? You know how bad my template had to be redone.

[bad_madman]

Somebody had complained that at every search the views counter one is increased :surprised: :nervous: This can be changed (is recommendable) :classic:

Search in showthread.php for:

if ($noshutdownfunc) {
  $DB_site->query("UPDATE thread SET views=views+1 WHERE threadid='$threadid'");
} else {
  $shutdownqueries[]="UPDATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='$threadid'";
}

and replace with:

if ($ownsearch!=1) {
  if ($noshutdownfunc) {
    $DB_site->query("UPDATE thread SET views=views+1 WHERE threadid='$threadid'");
  } else {
    $shutdownqueries[]="UPDATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='$threadid'";
  }
}

that's all

edit:
wrong code

[Birdie501]

Hi, nice hack!!

i installed the hack that shows the number of posts and direct link in that thread! If you search the thread and the result is shown the numbers change and start again with 1.
Is it possible to keep the original numbers?

So if a post is the third post in this thread (post #3), this number will also be shown in the search result?
Otherwise it is a little bit confusing.

Also how can i get back to the thread after searching? Because after the search there is no button where i can reset the search?

Hope you understand what i mean, is a little bit difficult for me to explain in english
Thanks