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

[27RUS]

on my Style i must do this:

in headinclude

after line {vb:raw template_hook.headinclude_javascript}

put this:

<link rel="stylesheet" type="text/css" href="{vb:raw vbcsspath}lsa_css.css" />
<script type="text/javascript" src="clientscript/ajax_live_search_init.js?v={vb:raw vboptions.simpleversion}"></script>

it was does not work else, i dont know

[Baghira]

Does not work for me. I can enter words, but no live search, just normal search

[ckgb]

Got it to work on 4.2.2. Had to add a couple things to header and headerinclude. Tested in FF, IE and Chrome. Works the same everywhere but not all the way.

Works by topic name great. Option where search by an individual word inside posts was no good. Comes back empty every time. The following error comes up in the error log:

Database error in vBulletin 4.2.2:

Invalid SQL:

                                SELECT thread.threadid, thread.lastpostid, thread.forumid AS tforumid, thread.title AS ttitle, forum.title AS ftitle
                                FROM thread AS thread
                                LEFT JOIN forum AS forum ON(thread.forumid = forum.forumid)
                                WHERE MATCH(thread.title) AGAINST (' +seatt' IN BOOLEAN MODE)

                                AND thread.forumid NOT IN (0)
                                AND thread.lastpostid > 0
                                ORDER BY thread.lastpost DESC
                                LIMIT 50;

MySQL Error   : The used table type doesn't support FULLTEXT indexes
Error Number  : 1214
Request Date  : Thursday, January 2nd 2014 @ 07:55:35 AM
Error Date    : Thursday, January 2nd 2014 @ 07:55:35 AM
Script        : http://www.sitename.com/ajaxlivesearch.php?do=search
Classname     : vB_Database
MySQL Version : 5.5.34-cll

Also search should probably include blogs and groups.

Great potential but had to uninstall.

[btedition]

Thank you for this feature, it does however need to search for the string even if it was in-between some other words.

Example (I want to buy a dog)
Current Search: (to buy a) = No results
What needs to be done is get the search engine to look for the string in between other words.

Great work however

[ClaymanX]

Sorry but the search dont find words in the middle or end of an text

Fixed, turned the Fulltext search of in the Ajax Live search settings

[twista46]

Works not with vB Social have any Fixx??

[postcd]

Please how to exclude some categories or forums from the search?

[iyihost]

doesnt work on 4.2.2

edit: disable fulltext seach.

[dariyos]

Hello..

sometimes I get a db error:

Datenbankfehler in vBulletin 4.2.2:

Invalid SQL:

				SELECT thread.threadid, thread.lastpostid, thread.forumid AS tforumid, thread.title AS ttitle, forum.title AS ftitle
				FROM thread AS thread
				LEFT JOIN forum AS forum ON(thread.forumid = forum.forumid)
				WHERE MATCH(thread.title) AGAINST (' +verbindun' IN BOOLEAN MODE)
				AND thread.forumid IN (10lsasort=lastpost)
				AND thread.forumid NOT IN (0,18,52,6,16,17)
				AND thread.lastpostid > 0
				ORDER BY thread.lastpost DESC
				LIMIT 50;

MySQL-Fehler  : Unknown column '10lsasort' in 'where clause'
Fehler-Nr.    : 1054
Fehler-Zeit   : Thursday, 23.04.2015 @ 20:52:15
Datum         : Thursday, 23.04.2015 @ 20:52:15
Skript        : http://www.sps-forum.de/ajaxlivesearch.php?do=search
Referrer      : http://www.sps-forum.de/
IP-Adresse    : 
Benutzername  :
Klassenname   : 
MySQL-Version :

Datenbankfehler in vBulletin 4.2.2:

Invalid SQL:

				SELECT thread.threadid, thread.lastpostid, thread.forumid AS tforumid, thread.title AS ttitle, forum.title AS ftitle
				FROM thread AS thread
				LEFT JOIN forum AS forum ON(thread.forumid = forum.forumid)
				WHERE MATCH(thread.title) AGAINST (' +troggel' IN BOOLEAN MODE)
				AND thread.forumid IN (10lsasort=lastpost)
				AND thread.forumid NOT IN (0,18,52,6,16,17)
				AND thread.lastpostid > 0
				ORDER BY thread.lastpost DESC
				LIMIT 50;

MySQL-Fehler  : Unknown column '10lsasort' in 'where clause'
Fehler-Nr.    : 1054
Fehler-Zeit   : Sunday, 19.04.2015 @ 17:20:11
Datum         : Sunday, 19.04.2015 @ 17:20:11
Skript        : http://www.sps-forum.de/ajaxlivesearch.php?do=search
Referrer      : http://www.sps-forum.de/
IP-Adresse    : 
Benutzername  :
Klassenname   : 
MySQL-Version :

[dariyos]

Hello,

another DB Error:

Datenbankfehler in vBulletin 4.2.3:

Invalid SQL:

				SELECT thread.threadid, thread.lastpostid, thread.forumid AS tforumid, thread.title AS ttitle, forum.title AS ftitle
				FROM thread AS thread
				LEFT JOIN forum AS forum ON(thread.forumid = forum.forumid)
				WHERE MATCH(thread.title) AGAINST (' +BremswegLive +Search' IN BOOLEAN MODE)
				AND thread.forumid IN (28lsasort=lastpost)
				AND thread.forumid NOT IN (0,18,52,6,16,17)
				AND thread.lastpostid > 0
				ORDER BY thread.lastpost DESC
				LIMIT 50;

MySQL-Fehler  : Unknown column '28lsasort' in 'where clause'
Fehler-Nr.    : 1054
Fehler-Zeit   : Tuesday, 29.09.2015 @ 15:18:25
Datum         : Tuesday, 29.09.2015 @ 15:18:25
Skript        : http://www.sps-forum.de/ajaxlivesearch.php?do=search
Referrer      : http://www.sps-forum.de/
IP-Adresse    : 
Benutzername  : caveman
Klassenname   : vB_Database
MySQL-Version :

Datenbankfehler in vBulletin 4.2.3:

Invalid SQL:

				SELECT thread.threadid, thread.lastpostid, thread.forumid AS tforumid, thread.title AS ttitle, forum.title AS ftitle
				FROM thread AS thread
				LEFT JOIN forum AS forum ON(thread.forumid = forum.forumid)
				WHERE MATCH(thread.title) AGAINST (' +Live +Search' IN BOOLEAN MODE)
				AND thread.forumid IN (28lsasort=lastpost)
				AND thread.forumid NOT IN (0,18,52,6,16,17)
				AND thread.lastpostid > 0
				ORDER BY thread.lastpost DESC
				LIMIT 50;

MySQL-Fehler  : Unknown column '28lsasort' in 'where clause'
Fehler-Nr.    : 1054
Fehler-Zeit   : Tuesday, 29.09.2015 @ 15:18:21
Datum         : Tuesday, 29.09.2015 @ 15:18:21
Skript        : http://www.sps-forum.de/ajaxlivesearch.php?do=search
Referrer      : http://www.sps-forum.de/
IP-Adresse    : 
Benutzername  : caveman
Klassenname   : vB_Database
MySQL-Version :

how can I fix that?