Miscellaneous Hacks - Quick search pre-populated results: give your visitors quick thread suggestions

Product video demo: http://www.youtube.com/watch?v=eOUq4Z6R7xI

This product integrates with the quicksearch drop down box in NAVBAR; and suggests popular threads while the visitor is typing in search keywords.

Read INSTRUCTIONS.txt for installation instructions.

NOTICE: To fine-tune and configure "relevancy threshold" you must edit /includes/cron/autocomplete-generate.php file. Default installation assumes you have a big discussion forums and suggests only threads which have more than 1000 replies or 1000 views. Edit this number, the query looks like this:

PHP Code:

// This query needs to be customized on a per site basis
$ac_sql = "SELECT * FROM ". TABLE_PREFIX ."thread where threadid between ".$startat." AND ".$endat." AND (views > 1000 OR replycount > 1000) AND visible = '1' ORDER by views DESC"; 


[ExplosiveGFX]

I don't understand this:

PHP Code:

/ This query needs to be customized on a per site basis
$ac_sql = "SELECT * FROM ". TABLE_PREFIX ."thread where threadid between ".$startat." AND ".$endat." AND (views > 1000 OR replycount > 1000) AND visible = '1' ORDER by views DESC"; 


the

PHP Code:

"thread where threadid between" 


Do I change this, or leave it like that? Hopefully I can get a response, you've replied to me in the past..

[ibautocommunity]

Originally Posted by ExplosiveGFX

I don't understand this:

PHP Code:

/ This query needs to be customized on a per site basis
$ac_sql = "SELECT * FROM ". TABLE_PREFIX ."thread where threadid between ".$startat." AND ".$endat." AND (views > 1000 OR replycount > 1000) AND visible = '1' ORDER by views DESC"; 


the

PHP Code:

"thread where threadid between" 


Do I change this, or leave it like that? Hopefully I can get a response, you've replied to me in the past..

See the number 1000?

This number means VIEWS/REPLIES need to be MORE THAN 1000 to get into the list. This works for BIG forums, but may not work on a small forum. If you have a small board you can change the 1000 to 100, and scale it even smaller to include all threads.

[ExplosiveGFX]

I changed it to "3" and tried it.. hmm, it's not working. I ran the scheduled task and it's saying on there, that it's not been run since january.

I'll try again tomorrow...

[ibautocommunity]

Originally Posted by ExplosiveGFX

I changed it to "3" and tried it.. hmm, it's not working. I ran the scheduled task and it's saying on there, that it's not been run since january.

I'll try again tomorrow...

You can look at the file system to physically verify that the cron task actually created the text file for you, in the directory you specified. Also have to make sure Jquery is included.

[ExplosiveGFX]

Well, actually, now I've looked for data.txt (I'd already looked, the code referenced it, I assumed it'd create it) it's not there.

DIR is CHMODDED to 777.

Could it be that I don't have SED on my server? How common is it on Linux/Unix Distros? This feature would be sweet for my site..

But Wait, RSS feeds and anything to do with scheduled tasks aren't working either.. looks like I have a conflict in mods.

[ibautocommunity]

When you press RUN NOW button on that specific cron job it has to build the data file; if its not - sed is missing or your cron system is not working for some reason. This is a really simple mod.

[ExplosiveGFX]

hmm, ok, so now the data_1256681036.txt files have appeared in my CHMOD'd dir, but still not autocompleting.

I'll go over the installation process and re-do it all..

[ibautocommunity]

Originally Posted by ExplosiveGFX

hmm, ok, so now the data_1256681036.txt files have appeared in my CHMOD'd dir, but still not autocompleting.

I'll go over the installation process and re-do it all..

Oh, I see the problem. You are using the vBNexus product which also loads jquery. In your head template, remove the jquery line you've added for autocomplete product.

Remove this first line:

<script src="autocompfiles/jquery-latest.min.js"></script>

[oddmud]

Ok,

I've got it creating the text file properly... now when I'm trying to use the search function nothing is happening.

I cut and paste the code in to the template, but still nothing.. it runs, but it does not work on the board.

[ExplosiveGFX]

Originally Posted by oddmud

Ok,

I've got it creating the text file properly... now when I'm trying to use the search function nothing is happening.

I cut and paste the code in to the template, but still nothing.. it runs, but it does not work on the board.

Same situation here.