category revert

[aladdin]

Hello,

Hack request!!. From the category table "getting" the full category path. In idx_category one got the parent category as well as the category name. I am working on an update of my site, it will now have 2200 categories and I need the full path of each category /from my Indexu directory/parent/category/child category/grand child category/grand grand child category/ etc. Creating a new field in idx_category for this data would be nice but not necessary, being able to copy and paste should works. How much for such hack?

[esm]

there is a category function that returns the categpry path ( well, sort of ). It could probably be mofified.

what format do you need it?

how and where do you plan to use it?

[aladdin]

I want to use it for title tag. As for the format, I am not sure, I can always edit what is given to me.
Go to:
http://www.scriptsandstuffs.com/Indexu/
Look at the source after clickin on any category and yu will have a better idea about what I want to do. I did get my category path using MS Access but it is time consuming and not very efficient.

[esm]

Originally posted by aladdin
I want to use it for title tag. As for the format, I am not sure, I can always edit what is given to me.

the reason I ask is, in order get the path, I need the catetory ID. So this would be all sub-categories.

I'll do one later this evening.

[esm]

in category.class.php, make the following change in red

  function GetCleanCategoryPath($cat) { 

    $parent_id = 10;
    while($parent_id) {
      $query = "select parent_id, name from $this->table_name where category_id=$cat";
      $result = $this->db_connect->Execute($query);
      if ($result){
        $name = $result->Fields("name");
        if ($parent_id != 10) $name .= ", " ;
        $path = $name . $path;
        $parent_id = $result->Fields("parent_id");
        $cat = $parent_id;
      }
    }

    return $path;
  }  

}
?>

in browse.php toward the top make the following change in red:

$category_obj = new clsCategory;
$category_obj->InitDB($dbServer, $dbHostname, $dbUsername, $dbPassword, $dbName);
$category_obj->table_name = "idx_category";
$category_obj->separator = $category_separator;
$cat_path = $msg["10011"].$category_separator.$category_obj->GetCategoryPath($cat);
$cat_path2 = $category_obj->GetCategoryPath($cat);
$cat_path_clean = $category_obj->GetCleanCategoryPath($cat);


in browse.php toward the top make the following change in red:

DisplayTemplate($theme_path."cat_header.html", "\$page_title, \$cat, \$cat_path_clean, $meta_keywords,\$meta_description,\$login_box");

then in browse.html use <%cat_path_clean%>

you can see it here:
http://www.indexuhelp.com/indexu/browse.php?cat=119