Categories tree

[swaper]

1) install sql cache query
2) delete category_tree class
3)edit tpl_categories.php sidebox in your template directory
- write own categories_query
- fetch result query
Example:

$content = "";
  
   echo '<div id="' . str_replace('_', '-', $box_id . 'Content') . '" >' . "\n";
   $categories_query = "select c.categories_id, cd.categories_name, c.parent_id, c.categories_image
                               from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd
                               where c.parent_id = 0
                               and c.categories_id = cd.categories_id
                               and cd.language_id=" . (int)$_SESSION['languages_id'] . "
                               and c.categories_status= 1";
  $dotaz = $db->execute($categories_query);
  while(!$dotaz->EOF) {
    
   
        echo '<a  href="' . zen_href_link(FILENAME_DEFAULT, "cPath=".$dotaz->fields['categories_id']) . '"><div class=radek>';
        echo  $dotaz->fields['categories_name'];  
       echo '<br /></div></a>';
        echo  "\n"; 
        $dotaz->MoveNext();
                                                                     
      

      
    }
   echo $content . '</div>'; 

4) edit category_row in modules directory
Example:

if (!defined('IS_ADMIN_FLAG')) {
  die('Illegal Access');
}
//$title = '';
$num_categories = $categories->RecordCount();


if ($num_categories > 0) {
  echo "<table><tr>";
  while (!$categories->EOF) {
   if($col%5==0) echo "</tr><tr>";
  echo '<td><div class="categoryListBoxContents"><a href="' . zen_href_link(FILENAME_DEFAULT, "cPath=".$_GET['cPath'].'_'.$categories->fields['categories_id']) . '">' . zen_image(DIR_WS_IMAGES . $categories->fields['categories_image'], $categories->fields['categories_name'], SUBCATEGORY_IMAGE_WIDTH, SUBCATEGORY_IMAGE_HEIGHT) . '<br />' . $categories->fields['categories_name'] . '</a></div></td>' . "\n"; 
     $col ++;
    $categories->MoveNext();
  }
  echo "</tr></table>";
} 

The above codes are not optimal, I wrote it quickly. You have to create your own class, etc. But it works:)))