vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Add-On Releases - Live Search 1.0 (AJAX) (https://vborg.vbsupport.ru/showthread.php?t=154694)

rainyleaves 08-09-2007 10:36 AM

I got Another error.
Quote:

MySQL Error : Unknown column 'thread.forumid' in 'where clause'
Error Number : 1054
Then, I hard coded my table prefix...

Quote:

$results = $db->query_read("SELECT * FROM ". TABLE_PREFIX ."thread WHERE `title` LIKE '%$query%' AND `thread`.`forumid` NOT IN (0 $excludelist)");
---------->
$results = $db->query_read("SELECT * FROM ". TABLE_PREFIX ."thread WHERE `title` LIKE '%$query%' AND ". TABLE_PREFIX ."thread . forumid NOT IN (0 $excludelist)");
Now works fine.... :)

BTW, Awesome mod !!!!
Thanks, Coderphp :)

coderphp 08-09-2007 10:41 AM

Quote:

Originally Posted by rainyleaves (Post 1313479)
I got Another error.

Then, I hard coded my table prefix...


Now works fine.... :)

BTW, Awesome mod !!!!
Thanks, Coderphp :)

thanx ..

please click install if u like it :)

rainyleaves 08-09-2007 10:53 AM

Just Installed and MOTM :)

Crazy Serb 08-09-2007 11:27 AM

you do realize that this script behaves differently on Firefox and IE browsers... on Firefox it displays the results div either far left or far right on the page (NOT beside the search box), while on IE it does display it right beside the search box but it comes up with some JavaScript error (check your status bar).

Any way to make this work on FF the same way it does on IE?

StrifeX 08-09-2007 11:42 AM

Quote:

Originally Posted by rainyleaves (Post 1313479)
I got Another error.

Then, I hard coded my table prefix...


Now works fine.... :)

BTW, Awesome mod !!!!
Thanks, Coderphp :)

Wow, thanks for the solution to my problem :)

Btw coderphp, i downloaded the new version of your mod and i had the same problem, you might want to add rainyleaves' code into your php file... And you might also want to update the version of your hack to like 1.01 :p.

Also, how do i get the text to show "Searching..." instead of "???? ???????.." while searching?

Magnumutz 08-09-2007 12:55 PM

This is awesome... Thanks.
*Installed*

Regs 08-09-2007 01:00 PM

Someone asked earlier about queries... does this not query the server on every key press?

It's a very good idea but not too sure it is friendly for a large, busy site?

Cheers,

~Regs.

Magnumutz 08-09-2007 01:06 PM

There's only 1 (ONE) query: https://vborg.vbsupport.ru/showpost....5&postcount=16

Regs 08-09-2007 01:41 PM

Yes, I read that. But my question remains - is this one query on every keystroke?

Brew 08-09-2007 02:15 PM

In FireFox the mod looks great but it's a bit different in IE. The box comes up too small in IE.

EDIT:
I forgot to mention that the below pics were taken after adding the code for the div statement from another reply; overflow:auto; height:200px but the layout is the same with or without the change.

Examples below..The first image is FF the second is IE..


All times are GMT. The time now is 06:09 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.01240 seconds
  • Memory Usage 1,738KB
  • 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_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