Publishing Categories

[bosshog001]

How can I get the Publishing Categories to show in alpha order?

[Sergey Hmelevsky]

Hot to sort articles categories in ABC order in 'Browse Categories' mode:
1. open file packages/publishing/includes/classes/sbr.front.category.php
2. find function getArticleCategories
3. Replace line

PHP Code:

$sql .= false === $aIdParent ?  false : "AND `id_parent`='{$aIdParent}' "; 


with next

PHP Code:

$sql .= false === $aIdParent ?  false : "AND `id_parent`='{$aIdParent}' ";
$sql .= "ORDER BY `title` "; 


[bosshog001]

Thanks for your help

[Sergey Hmelevsky]

Always at your service.

[bosshog001]

How do I get the sub-categories to show under the Publishing Category Block?

So Lets say I have a category called Stories and I have a sub-category called fictional what I would like to see is the following

Stories
Fictional Stories

[Sergey Hmelevsky]

open file plugins/pub_cats/install.xml find line

PHP Code:

    $result = $sbrDb->all('`title`, `path`', '`level`=1 AND `num_all_articles`>0', 0, 0, 'articles_categories'); 


and replace with

PHP Code:

    $result = $sbrDb->all('`title`, `path`', '`num_all_articles`>0', 0, 0, 'articles_categories');