vb.org Archive
Page 19 of 22 « First 91718 19 2021 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Fulltext boolean search v.2.2 for vB (https://vborg.vbsupport.ru/showthread.php?t=62282)

ImportPassion 08-20-2004 12:14 PM
i only have one problem, but it works fine in 3.0.3 for me.

if ppl search for 17" rims, it will blow up cause of the ". I should be able to fix it tho.

nexialys 08-20-2004 01:44 PM
the " is easy to deal with, it's a tag... point actually is the install instructions... 3.0.0 is really different from 3.0.3, because of the new fulltext search propriety... is someone updating the install so we can drive it cool ?!

M1th 09-04-2004 03:21 PM
Yep, that'd be cool. It's quite confusing to follow the instructions for 3.0.3.

ImportPassion 09-15-2004 11:30 PM
ok, this thing is now killing my site for some reason, especially when some one searches for say 17" rims.
The vb3 one also kills it, but even worse.

I don't know what to do anymore.

WotC_Tech 09-22-2004 11:15 PM
I've installed this hack and are having good luck with it on vB 3.0.3 with 3 million posts. I did have a performance problem when searching for posts in forums rather than searching against all posts. It appears that Erwin's Add-On helped us a great deal when searching against all posts, but queries against specific forums would often take 30 or more seconds to complete.

We resolved this issue by modifying Erwin's Add-On a bit:

PHP Code:
// Erwin's Add-On

$searchlimit = " WHERE";
$searchforumadd = "";

if ($searchthread) {
$searchlimit = " WHERE post.threadid=$searchthreadid AND";
}

if ($forumchoice) {
$searchforumadd = ", forumid";
// Modified by WotC_Tech
//$searchlimit = " LEFT JOIN thread AS thread ON post.threadid=thread.threadid WHERE forumid IN($forumchoice) AND";
$searchlimit = " LEFT JOIN thread AS thread ON post.threadid=thread.threadid AND thread.forumid IN($forumchoice) WHERE";
}

$fulltext_sql = "SELECT postid$searchforumadd FROM post$searchlimit MATCH (".$what_field.") AGAINST ('$query".$isboolean.") LIMIT 0, ".$vboptions['maxresults'];

// Erwin's Add-On 
It appears that the MySQL optimizer isn't doing its job and running the query as fast as it could.

nexialys 10-08-2004 01:10 PM
diguidi bump! -- want news for this !!!

alexi 11-29-2004 02:25 AM
I'm with nexialys, any chance of getting an updated version of this for 3.03? I'm missing something trying to tie all of these threads together with the changes

Steve St.Lauren 12-27-2004 02:58 PM
With this hack when you search on entire posts it won't search the titles as well. I was searching for a thread on my board and if I did the search on titles only it would come up but if I did the same search on entire posts it won't. Any ideas?

nexialys 02-20-2005 11:02 AM
as msimplay released his new hack for this tool (https://vborg.vbsupport.ru/showthread.php?t=76678), can someone update the install script for 3.0.6 ???

there is a completely different file structure after 3.0.1+, so this would be more than efficient to update the script install process...

someone ?!

msimplay 02-20-2005 11:33 AM
Quote:
Originally Posted by nexialys
as msimplay released his new hack for this tool (https://vborg.vbsupport.ru/showthread.php?t=76678), can someone update the install script for 3.0.6 ???

there is a completely different file structure after 3.0.1+, sothiswould be more than efficient to update the script install process...

someone ?!
Someone has already used the same hack with vb3.06 its installed


All times are GMT. The time now is 11:30 AM.
Page 19 of 22 « First 91718 19 2021 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01353 seconds
  • Memory Usage 1,745KB
  • 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
  • (1)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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