vb.org Archive - Add Search/Sort/Order in thread view

Page 8 of 10

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Add Search/Sort/Order in thread view (https://vborg.vbsupport.ru/showthread.php?t=39947)

Edgar

06-22-2002 09:20 AM

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

06-22-2002 11:29 AM

Quote:

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:

Code:

$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

06-22-2002 11:35 AM

Quote:

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: Add.
- Code to find: </myhighlight>
- Code to insert:

Edgar

06-22-2002 01:05 PM

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

06-22-2002 07:58 PM

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

bad_madman

06-24-2002 09:16 PM

New version out: 1.20

Updates
- 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

Screenshots:
Screenshots in the first post.

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

Boofo

06-24-2002 10:00 PM

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

Quote:

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

bad_madman

06-24-2002 11:20 PM

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"...

Quote:

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

06-27-2002 01:29 PM

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:

Code:

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:

Code:

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

07-11-2002 04:42 PM

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

All times are GMT. The time now is 08:21 PM.

Page 8 of 10

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04536 seconds Memory Usage 1,752KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: