Index: trunk/kernel/include/searchitems.php
===================================================================
diff -u -r13 -r120
--- trunk/kernel/include/searchitems.php (.../searchitems.php) (revision 13)
+++ trunk/kernel/include/searchitems.php (.../searchitems.php) (revision 120)
@@ -140,7 +140,8 @@
{
$limit = "LIMIT $Start,$PerPage";
}
- $sql = "SELECT * FROM ".$this->ResultTable." ".$limit;
+ $sql = "SELECT * FROM ".$this->ResultTable." ".$limit;
+
$this->Clear();
$rs = $this->adodbConnection->Execute($sql);
return $this->Query_Item($sql);
@@ -436,7 +437,7 @@
$this->adodbConnection->Execute("DROP TABLE ".$this->ResultTable);
//$indexSQL = "(INDEX(Relevance), INDEX(ItemId), INDEX(ItemType), INDEX sorting (EdPick,Relevance)) ";
$full_sql = "CREATE TABLE ".$this->ResultTable." ".$indexSQL.$SelectSQL;
-// echo $full_sql."
\n";
+ //echo $full_sql."
\n";
$this->adodbConnection->Execute($full_sql);
//echo $this->adodbConnection->ErrorMsg()."
\n";
$objSession->SetVariable("Search_Keywords",$this->Phrase);
@@ -448,6 +449,8 @@
$this->adodbConnection->Execute($full_sql);
//echo $this->adodbConnection->ErrorMsg()."
\n";
}
+ //Here we need to remove found items which was found by HTML tags matching keywords
+ //$this->adodbConnection->Execute("DELETE FROM ".$this->ResultTable." WHERE ItemId = 13 AND ItemType = 4");
}
function BuildIndexes()