Add-On Releases - [AJAX] Live Search

Description: Search without reload pages: by threads, by users with many sort criteria.

Features:

• search only, if typed >= 3 symbols;
• header to window with button close;
• message about no result;
• limit number of threads;
• highlight words in result
• trim title of thread, if it large (optional)
• edit position of pop-up window
• work with vBadvanced
• limit the number of displayed results
• group permission
• search by your own forums
• sort results of search
• mod makes only one query to db
• full compatibility with styles and browsers
• search by individual words
• integrate option into standard search
• search only the specified length of each word
• users search
• interval requests
• wrote 2 js class
• able to drag'n'drop window
• Search by threads now produced on an index table thread (fulltext - optional), which increases the speed of search
• Changed the type of floating window (refused vbmenu)
• popup transplanted to the div's in tact vb4 (tried to get the maximum sync with the style and API)
• (for non english users) offer the ability to change the keyboard layout: if by the word search returns zero results, it will try to verify whether the correct layout are the words, checking every word of the existence of the database as a dictionary. In functions_livesearch.php you can find table of characters

Installation:
Upload all files from folder upload to forum folder.
Import product.

History:
4.0.0 - initial release
4.0.1 - fixed some issues, compatibility with 4.0.x
4.0.5 - rewrote js engine
4.0.6 - fix bug with chrome, fix overlay, some js optimization

If you like this hack, please, click INSTALL and Nominate for MOTM

[BadgerDog]

Questions:

1. Why do I have to re-import XML file every time I change the width setting in order to make it actually change the width?

2. If I set search to return just 50 matches, how does the user get to find any matches on other posts or threads that may exist beyond 50? Shouldn't there ne a NEXT 50 button so users can scroll through ALL occurrences of their search request in the whole database?

3. What has been the user experience here in setting the search to 100 or beyond?

Great mod so far... seems to be working well in beta testing with just Moderators using it ... thanks for developing it and fixing earlier problems.

Regards,
Badger

[BadgerDog]

Originally Posted by Bankfodder

This is a sensational search facility.

But what I don't think that Mad@Max has told everyone is that you can also use * ? AND NOT OR w/n as part of your search terms.

What's w/n used for?

I modified the language string to show the use of operators.

<div align="center"><b>Please type keyword<br>Wildcards Accepted ie: * ? AND NOT OR w/n<\/b><\/div><div align="center">Minimum word length: {1}<br \/>Maximum character: {2}<br \/>Maximum output results: {3}<\/div>

Regards,
Badger

[BadgerDog]

Any chance this will ever work with the articles in vBulletin CMS?

Thanks ..

Regards,
Badger

[Cherkez]

it is not working at my forum too. it has no result when i type words

[RobbieZ]

Originally Posted by Leica.Robbiani

Hi there,


All selected tabs are affected. Open up the "lsa_css.css"-Template and search for "#lsa_cont {". I don't know anymore if I had created this by myself, if you don't find it, create it. Put in the paratheses "z-index: 100;" and all goes fine.

#lsa_cont {
z-index: 100;
}

Best regards

L.R.

Excellent fix. Thanks

[andreamarucci]

Just a question. The search work but I've tried this and I don't know if this depends from your mod or from VB.

If I try to search for the word "dunlop" for example, the results are shown only when I've finished to type the entire word and not as I type. When I've typed "dunlo" no results are shown but as soon as I type the remaining letter "p" all the results are show.

It's not possible to make that the search is done not on the entire word but also on part of it?

[PaintSplasher]

Hm,

i get some sql-errors several times, but i can not reproduce it exactly.

Datenbankfehler in vBulletin 4.0.6:

Invalid SQL:

				SELECT thread.threadid, thread.lastpostid, thread.forumid AS tforumid, thread.title AS ttitle, forum.title AS ftitle
				FROM new_forum_thread AS thread
				LEFT JOIN new_forum_forum AS forum ON(thread.forumid = forum.forumid)
				WHERE MATCH(thread.title) AGAINST (' +Tachol' IN BOOLEAN MODE)
				AND thread.forumid IN (24lsasort=lastpost)
				AND thread.forumid NOT IN (0,58,5,26,29,52,56)
				AND thread.lastpostid > 0
				ORDER BY thread.lastpost DESC
				LIMIT 50;

MySQL-Fehler  : Unknown column '24lsasort' in 'where clause'
Fehler-Nr.    : 1054
Fehler-Zeit   : Sunday, 05.09.2010 @ 15:35:37
Datum         : Sunday, 05.09.2010 @ 15:35:37
Skript        : http://www.fiesta-ka-forum.de/ajaxlivesearch.php?do=search
Referrer      : http://www.fiesta-ka-forum.de/fiesta-mk4-mk5-24/
IP-Adresse    : ******
Benutzername  : *****
Klassenname   : vB_Database
MySQL-Version :

The search seems to work correctly.

[Bankfodder]

Originally Posted by andreamarucci

Just a question. The search work but I've tried this and I don't know if this depends from your mod or from VB.

If I try to search for the word "dunlop" for example, the results are shown only when I've finished to type the entire word and not as I type. When I've typed "dunlo" no results are shown but as soon as I type the remaining letter "p" all the results are show.

It's not possible to make that the search is done not on the entire word but also on part of it?

use dun*

that will get what you want

[BadgerDog]

Well, after some pretty thorough testing, I've decided to un-install this mod.

There are some graphics artifacts being complained of by members, including the "live search" phrase appearing behind the search box on some browsers, even though we patched the mod with the "tab" fix mentioned earlier.

Also, we're getting inconsistencies in the search results that don't match what we get with vBulletin's standard search. For example, we search for P14 or P13 and nothing appears in "Live Search" results, whereas in vBulletin's search we get all kinds of hits.

Anyway, thanks again to the author for his efforts. :up:

We'll check back in a few months and see if there's been any refinement of the code.

Regards,
Badger

[Kraxell]

anyone know, how i can change the background-color of the results?