Finding inactive games with search function

Hi there,

Maybe someone has a sollution for this. When I use the search function it also find inactive games. So when people click on the one of the games in the searchresults which is inactive it sees an error.

ProArcadeScript DB ERROR!
Query failed.
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 'LIMIT 1' at line 1 - 1064.
QUERY: SELECT id, title, latin_title FROM categories WHERE id= LIMIT 1

Any help would be appreciated.

Regards,

try to edit the query string in the "search.php" file (near 60th line) by adding

Code:

AND active=1

right before "WHERE".

I tried, but maybe I am doing something wrong. I changed the code to this:

}
$searchstr = mysql_escape_string($_REQUEST['searchstr']);
$query = "SELECT * FROM " . $cMain['dbPrefix'] . "games AND active=1 WHERE title LIKE '%$searchstr%' OR MATCH(description) AGAINST ('$searchstr') OR keywords LIKE '%$searchstr%' LIMIT ".$cB["SEARCH"]["max"];
$arGames = $db->super_query( $query, true );
if( count($arGames) > 0 )
{

But getting the following error for all my search queries now.

ProArcadeScript DB ERROR!
Query failed.
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 'AND active=1WHERE title LIKE '%sewer%' OR MATCH(description) AGAINST ('sewer') O' at line 1 - 1064.
QUERY: SELECT * FROM games AND active=1WHERE title LIKE '%sewer%' OR MATCH(description) AGAINST ('sewer') OR keywords LIKE '%sewer%' LIMIT 20

sorry, "AND active=1" must be right before LIMIT, not WHERE

Thanks! It works..