"cross links" problem in hot and top-rated listings

[zhisede]

Problem:

With the increase of categories, you may get cross links in hot and top-rated listings, i.e. links are listed under the wrong categories, all in a mess.

Solution:

1. Open category.class.php file in the lib folder

2. Find the following code:

function GetChildren($cat) {

$query = "select category_id from idx_category_path
where parents like '%$cat;%'";
$result = $this->db_connect->Execute($query);
if($result) $total = $result->RecordCount();

$children[] = $cat;

$i = 0;
while($i<$total) {
$children[] = $result->Fields("category_id");
$result->MoveNext();
$i++;
}

return $children;

3. Replace the above red code with following blue code,

where parents like '%;$cat;%' or parents like '$cat;%'";


That's it.