Joomla Templates Club 406,261 posts

[cre8 Friend cre8Join date: November 2009Posts: 16Downloads:0Uploads:2 Thanks: 4 Thanked: 3 times in 1 posts]

#326190

I don’t know if you figured it out and solved the problem but I kinda fixed it; as I had this problem also… I wanted every category that has the latest article to be first and so on….

I edited the query for the categories selection. The query is not perfect and if anyone has a better and more improved version of it in mind, please submit it here so I can use it too!

Anyway here’s the changes you have to make:

At the file: modules/mod_janews2/helper.php find the function named: loadCategories

In there change the query from:

[PHP]$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;[/PHP]

to:

[PHP]$query = “SELECT a.created, s.id, s.title, s.description, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(“:”, s.id, s.alias) ELSE s.id END as slug FROM #__categories s, #__content a WHERE a.catid = s.id AND s.published = 1 and s.section=” . ( int ) $sid . $where;
$query .= ” ORDER BY a.created DESC”;[/PHP]

In my site this works partially, so the code needs some cleaning up which i don’t know yet how to do it…

Merry Xmas & a Happy new year to all!

1 user says Thank You to cre8 for this useful post

1. teraysay

[kryptos Friend kryptosJoin date: November 2009Posts: 105Downloads:0Uploads:8 Thanks: 9 Thanked: 13 times in 9 posts]

#327254

<em>@zorroh 155565 wrote:</em><blockquote>ok, i’ll try to talk with my friend who can me help with this..</blockquote>

Hi,

did you find any solution for this problem?

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

#327264

See this thread, got a fix that works for me.
http://www.joomlart.com/forums/topic/ja_news2-only-show-categories-with-new-articles/

1 user says Thank You to sjmorris for this useful post

1. kryptos

[kryptos Friend kryptosJoin date: November 2009Posts: 105Downloads:0Uploads:8 Thanks: 9 Thanked: 13 times in 9 posts]

#327268

Thanx sjmorris, I’ll try that too.

[zorroh Friend zorrohJoin date: November 2006Posts: 422Downloads:20Uploads:43 Thanks: 88 Thanked: 80 times in 1 posts]

#353363

yes, my friend solved this problem.. so my site now works like it is supposed to..

[Author]

Posts