vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Miscellaneous Hacks - Quick search pre-populated results: give your visitors quick thread suggestions (https://vborg.vbsupport.ru/showthread.php?t=222001)

ExplosiveGFX 10-27-2009 08:41 PM

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 10-27-2009 08:55 PM

Quote:

Originally Posted by ExplosiveGFX (Post 1907125)
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 10-27-2009 09:06 PM

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 10-27-2009 09:12 PM

Quote:

Originally Posted by ExplosiveGFX (Post 1907137)
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 10-27-2009 09:20 PM

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 10-27-2009 09:21 PM

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 10-27-2009 09:28 PM

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 10-27-2009 09:34 PM

Quote:

Originally Posted by ExplosiveGFX (Post 1907158)
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 10-27-2009 10:06 PM

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 10-28-2009 12:51 AM

Quote:

Originally Posted by oddmud (Post 1907170)
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.


All times are GMT. The time now is 08:49 AM.

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.01073 seconds
  • Memory Usage 1,749KB
  • 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
  • (4)bbcode_php_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