Index: trunk/kernel/include/parseditem.php =================================================================== diff -u -N -r1025 -r1063 --- trunk/kernel/include/parseditem.php (.../parseditem.php) (revision 1025) +++ trunk/kernel/include/parseditem.php (.../parseditem.php) (revision 1063) @@ -2825,15 +2825,16 @@ $LoadOnlyPrimary = false; } - $sql .= $this->GetJoinedSQL($p,NULL,$where, $LoadOnlyPrimary); - $sql .= " ORDER BY EdPick DESC,Relevance DESC "; - - $tmp = $this->QueryOrderByClause(FALSE,TRUE,TRUE); - $tmp = substr($tmp,9); + $sql .= $this->GetJoinedSQL($p,NULL,$where, $LoadOnlyPrimary); + $tmp = $this->QueryOrderByClause(FALSE,TRUE,TRUE); + //echo "TMP: $tmp
"; + //$tmp = substr($tmp,9); if(strlen($tmp)) { - $sql .= ", ".$tmp." "; - } + $sql .= $tmp.", "; + } + + $sql .= " EdPick DESC,Relevance DESC "; //echo "SQL Search Items: $sql

"; return $sql; } Index: trunk/kernel/parser.php =================================================================== diff -u -N -r1041 -r1063 --- trunk/kernel/parser.php (.../parser.php) (revision 1041) +++ trunk/kernel/parser.php (.../parser.php) (revision 1063) @@ -1634,14 +1634,20 @@ } else $acl_where = "(FIND_IN_SET(0,acl))"; + + $order_by = "EdPick DESC,Relevance DESC"; + + if ($objSession->GetVariable("Category_Sortfield") != "") { + $order_by = $objSession->GetVariable("Category_Sortfield")." ".$objSession->GetVariable("Category_Sortorder"); + } $CAT_VIEW = $objPermissions->GetPermId("CATEGORY.VIEW"); $ctable = $objCatList->SourceTable; $stable = $objSession->GetSearchTable(); // $objSearchCats->SourceTable; $ptable = GetTablePrefix()."PermCache"; $sql = "SELECT * FROM $stable INNER JOIN $ctable ON ($stable.ItemId=$ctable.CategoryId) "; $sql .= "INNER JOIN $ptable ON ($ctable.CategoryId=$ptable.CategoryId) "; - $sql .="WHERE ItemType=1 AND Status=1 AND $acl_where AND PermId=$CAT_VIEW ORDER BY EdPick DESC,Relevance DESC "; + $sql .="WHERE ItemType=1 AND Status=1 AND $acl_where AND PermId=$CAT_VIEW ORDER BY $order_by "; $objSearchCats->Page = $m_var_list["p"]; if($objSearchCats->Page<1) $objSearchCats->Page=1;