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

[Leica.Robbiani]

Hi there,

Originally Posted by Kraxell

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

Watch out for the lsa_css.css template, in this template search for #lsa_results { and change the background color to whatever you like.

Best regards

L.R.

[Kraxell]

i have the follow now:

#lsa_results {
    height: {vb:raw vboptions.lsa_height}px; 
    background-color: #FFF;
    overflow: auto

but doesnt work

[lubbie]

Its not working 100% in 4.0.7. The Ajax Window is very small and CMS search is not included ( i dont know if that was before)

[luan7749]

It's woking for me before but now It's not working. Demo : http://tuoitrenangdong.net/forum

[goycarden]

Is it possible to make it work for 4.0.8 ?
Are there some alternatives?

[W!cKeD]

Thanks, but please fix it it dont work in 4.0.8 it say "searching" not more..

[hiker]

Great addon.

Is there a way to search the post contents as well, rather than just thread titles?

I've also noticed in IE8 that I can't refine my search to just one forum. The search will go for all forums but when I hit "Search again" for just one forum, it does not refine or change the search criteria.

Firefox seems to work just fine.

I am running vb 4.0.2

[hiker]

bump

[MonsterDK]

Originally Posted by 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.

I also experience this kind of error. Does not happen allot, but every so often.

[cravendale]

Anyone know how to resolve these errors?

Database error in vBulletin 4.0.6:

Invalid SQL:

SELECT p.*
FROM post AS p
WHERE p.postid IN (.);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 3
Error Number : 1064
Request Date : Sunday, February 6th 2011 @ 10:53:30 AM
Error Date : Sunday, February 6th 2011 @ 10:53:31 AM
Script : http://private/forum/search.php?searchid=1684
Referrer : http://private/forum/search.php
IP Address : 196.215.82.29
Username : Defjam33
Classname : vB_Database
MySQL Version :

thanks