Order backend news items by publishing date (descending)

Nethawk · 09.11.2004, 04:30

Greetings

I've got a little problem here.

Like many others I have a section called "News" which contains many sub-categories like "life", "games", "work" etc.

After a new news-item is published the mambo admin backend sorts and displays it first by category and afterwards by ID (descending).

For Example:

Title: News 3 -- Category: Games -- ID 3
Title: News 2 -- Category: Games -- ID 2
Title: News 1 -- Category: Games -- ID 1
Title: News 4 -- Category: Work -- ID 4
Title: News 5 -- Category: Life -- ID 5

Unfortunately I don't want it to behave like this!

I just want mambo to order the items by its ID (descending).

For Example: (Sames as above but reordered)

Title: News 5 -- Category: Life -- ID 5
Title: News 4 -- Category: Work -- ID 4
Title: News 3 -- Category: Work -- ID 3
Title: News 2 -- Category: Games -- ID 2
Title: News 1 -- Category: Games -- ID 1

Does anybody know how I can achieve this?
Please note: The frontend ordering is okay! It's just that backend which drives me crazy.

I searched the whole board and found some threads like this one:
Changing the content listing sort order

Unfortunately the content.php hack doesn't work with Mambo 4.5.1a stable.

Any ideas?

Help would be appreciated.

Thanks a lot

Nethawk · 09.11.2004, 16:48

Okay, I fixed it quick and dirty.

For those who are interested:

Open /administrator/components/com_content/admin.content.php

Jump to line 167 and replace the following

Code:

$order = "\n ORDER BY cc.ordering, cc.title, c.ordering";

with

Code:

$order = "\n ORDER BY created DESC, cc.ordering, cc.title, c.ordering";

Tested on mambo 4.5.1a

It would be great if the next release of mambo would support backend reordering options for specific sections/categories out of the box, because this hack modifies the backend section display globally

Thanks

Bi4a · 14.02.2005, 01:18

thanks mate i also was lookin for that solution.
Tested on mambo 4.5.1

doc · 06.03.2005, 21:34

Quote:

Originally Posted by Nethawk

Okay, I fixed it quick and dirty.

For those who are interested:

Open /administrator/components/com_content/admin.content.php

Jump to line 167 and replace the following

Code:

$order = "\n ORDER BY cc.ordering, cc.title, c.ordering";

with

Code:

$order = "\n ORDER BY created DESC, cc.ordering, cc.title, c.ordering";

Tested on mambo 4.5.1a

It would be great if the next release of mambo would support backend reordering options for specific sections/categories out of the box, because this hack modifies the backend section display globally

Thanks

Hi! I am wrestling with the same problem, but I do not understand some basic aspects of MOS. At the backend, there are to options to assign an order to an item. One is available underder Parameter when one is editing an item. The other by using the up and down arrows in the list. How come that MOS does not pick up these settings and stick to it.

Do you know any hack that would do just that if MOS misses out on it?

Thanks,

--doc