Joomla Templates Club 406,261 posts

[charyzma Friend charyzmaJoin date: January 2008Posts: 6Downloads:0Uploads:0]

#126231

Hello
I set up JA Barite from the quickstart and then renamed the category names to what I would like.
Right now the category list displays the category names but in reverse alphabetical order. How can I make it so that the categories display in a predefined order or in alphabetical order?

Ok so I’ve changed the joomla version to 1.5 and it works ok

[cd1999 Friend cd1999Join date: March 2008Posts: 19Downloads:18Uploads:3 Thanks: 4]

#242385

I’m also having little issue with ja categorylist ordering. It seems, it is being ordered by Category ID and not by predefined order of categories. Is there any way to rearrange that list? Renaming categories to keep certain order could probably be the answer, but I’m wondering if there is a better way. I’m using ver 1.5. Thanks.

[Fernando Friend FernandoJoin date: September 2014Posts: 21Downloads:0Uploads:0 Thanks: 3]

#249230

Can someone please look at this…All we want to do is order that categories like we do in the category section…this way we can have the order we need it to be

Thanks

[cd1999 Friend cd1999Join date: March 2008Posts: 19Downloads:18Uploads:3 Thanks: 4]

#256531

Did anyone found the solution to this issue (category menu orderig) or know where to go for help? Also, I’m having the same problem which was earlier reported by someone else. After selecting category number of articles is limited to 3. Is there any way to change it?
Thank you in advance.
Chris

[Sherlock Friend SherlockJoin date: September 2014Posts: 11453Downloads:0Uploads:88 Thanks: 221 Thanked: 2478 times in 2162 posts]

#257567

Hi
you can edit mod_ja_categorieslist.php (modulesmod_ja_categorieslist folder)
search those lines:

switch ( $ordering ) {
case 'alpha':
$order = 'a.name ASC';
break;

case 'category':
case 'popular':
case 'newest':
case 'oldest':
default:
$order = 'a.name DESC';
}
$where = ($secid) ? "n AND a.section IN (".$secid.")" : "";

$query = "SELECT a.id,a.title, a.description AS text, '' AS created,"
. " '2' AS browsernav,"
. " s.id AS secid, a.id AS catid,"
. " CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug"
. "n FROM #__categories AS a"
. "n INNER JOIN #__sections AS s ON s.id = a.section"
. "n LEFT JOIN #__menu AS m ON m.componentid = a.id"
. "n WHERE a.published = 1"
. "n AND s.published = 1"
. ' AND a.access <= '.(int) $user->get('aid')
. ' AND s.access <= '.(int) $user->get('aid')
. $where
. "n ORDER BY $order"
. "n LIMIT 0, $limit";

Here is sql to get categories
If you want to change sort of categories, you must edit

$order = 'a.name DESC';
as you want

And in each category,you should create more than 5 articles

[Author]

Posts