Joomla Templates Club 406,261 posts

[pferrol Friend pferrolJoin date: September 2014Posts: 59Downloads:41Uploads:4 Thanks: 6 Thanked: 2 times in 1 posts]

#144371

In frontpage i need view all catgories for secction, i can select all by de usertool but i need this by default, is posible??

[Anonymous Moderator JA DeveloperJoin date: September 2014Posts: 9914Downloads:207Uploads:152 Thanks: 1789 Thanked: 2008 times in 1700 posts]

#321675

Open modules/ja_news2/helper.php file, find following code:


function loadCategories($sid) {
$categories = array ();
$catids = $this->getUserSetting ( $sid, 'categories' );

$where = '';
$limit = 0;
if ($catids) {
if (is_array ( $catids ))
$where .= " AND `id` in (" . implode ( ',', $catids ) . ")";
} else {
if (is_array ( $this->getUserSetting ( $sid ) ))
$where = " AND 0";
else
$limit = ( int ) $this->get ( 'cols', 2 );
}

$db = & JFactory::getDBO ();
$query = "SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END as `slug` FROM `#__categories` s WHERE published = 1 and section=" . ( int ) $sid . $where;
$db->setQuery ( $query, 0, $limit );
$rows = $db->loadObjectList ( 'id' );
foreach ( $rows as $cid => $row ) {
$obj = new stdclass ( );
$obj->category = $row;
$categories [] = $obj;
}
return $categories;
}


and change to:


function loadCategories($sid) {
$categories = array ();
$catids = $this->getUserSetting ( $sid, 'categories' );

$where = '';
$limit = 0;
if ($catids) {
if (is_array ( $catids ))
$where .= " AND `id` in (" . implode ( ',', $catids ) . ")";
} else {
if (is_array ( $this->getUserSetting ( $sid ) ))
$where = " AND 0";
else
$limit = ( int ) $this->get ( 'cols', 2 );
}

$db = & JFactory::getDBO ();
$query = "SELECT `id`, `title`, `description`, CASE WHEN CHAR_LENGTH(`alias`) THEN CONCAT_WS(":", `id`, `alias`) ELSE `id` END as `slug` FROM `#__categories` s WHERE published = 1 and section=" . ( int ) $sid . $where;
$db->setQuery ( $query );
$rows = $db->loadObjectList ( 'id' );
foreach ( $rows as $cid => $row ) {
$obj = new stdclass ( );
$obj->category = $row;
$categories [] = $obj;
}
return $categories;
}


1 user says Thank You to JA Developer for this useful post

1. alekoocio

[idsfac Friend idsfacJoin date: October 2009Posts: 1Downloads:0Uploads:0]

#323553

Great that I can increase the number of categories showing under each ja_news2 section.

Question: Can I choose to show all categories for only some sections or do I have to have the code change apply to all?

i.e. – I want:

SECTION 1
category 1 category 2 category 3

SECTION 2
category 1 category 2 category 3
category 4 category 5 category 6

SECTION 3
category 1 category 2 category 3

Thanks.

[sjmorris Friend sjmorrisJoin date: March 2009Posts: 22Downloads:0Uploads:3 Thanks: 5 Thanked: 2 times in 1 posts]

#323805

I would love to do this as well. Thoughts?

[Anonymous Moderator JA DeveloperJoin date: September 2014Posts: 9914Downloads:207Uploads:152 Thanks: 1789 Thanked: 2008 times in 1700 posts]

#323941

Hi sjmorris

This module does not support your idea. I am sorry for not being of much help in the case.

[Fokstrot Friend FokstrotJoin date: August 2009Posts: 87Downloads:0Uploads:0]

#331436

Very good. It works.

[nawdin Friend nawdinJoin date: January 2010Posts: 21Downloads:0Uploads:0 Thanks: 4]

#350038

Well this works. It shows all categories in a section by default. Thanks for that.

Now I need another help, just little expansion of the code above, I think. 😀

In my section I have the following categories.
1,2,3,4,5,6,7,8,9

I would like to only show my choice of categories for eg. 1,3,4,7,8 etc…
How would this possible?

I found another good solution here, but it doesn’t solve the way I want yet.
http://www.joomlart.com/forums/topic/ja-news-2-multiple-rows/

Thanks

PS. I’m using JA News II 1.0.1

[Saguaros Moderator SaguarosJoin date: September 2014Posts: 31405Downloads:237Uploads:471 Thanks: 845 Thanked: 5346 times in 4964 posts]

#350789

ok, pls make done with my solution in there http://www.joomlart.com/forums/topic/ja-news-2-multiple-rows/

2) and then you try to re-sort order of categories with your expeclty order . 1,3,4,7,8 etc…

GOodluck

[Author]

Posts