Live Search 1.0 (AJAX) Specific Code

[Strife]

http://www.vbulletin.org/forum/showpost.php?p=1318566&postcount=124

Could someone get what that says for me? I have a DB prefix so the hack won't work unless I add that string of code.

 

[Mrquarter]

If your database uses prefix, then this script will cause DB Error

To fix, at line 23


Change to:

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

There is the quote that it says.

 

[Strife]

http://www.vbulletin.org/forum/showpost.php?p=1315519&postcount=108

Can you give me the content of that post as well?

Sorry if I'm being a bother. Thanks in advance.

 

[Mrquarter]

edit ajax_search.php file
search for:

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

replace with:

$results = $db->query_read("SELECT * FROM ". TABLE_PREFIX ."thread WHERE `title` LIKE '%$query%' AND `thread`.`forumid` NOT IN (0 $excludelist) ORDER BY `lastpost` DESC");

good to head that

There you go. Enjoy.

 

[Strife]

Thanks a lot.