News 3.5 Module: How to re-order the posts by date?

[marcusalee]

I have the following problem. When I enter a number of my posts with different date at backend, the posts are not shown in order by date at frontend. Do anyone know how to set orderiing by DATE?
I will be graveful if anybody can help.

[Bug]

Look into the view.php of the newsmodule and search for a line that says order by position, change that into order by date.

[marcusalee]

hello bug,

thank so much for your great help. I had found the line, but dont know how to change the ORDER by DATE.
it is much appreciated if you could help me with the script.
i start learning PHP script. WB PHP-CMS is found to be so wonderful.
       

[Bug]

Give me day, I will post you the new line

[DarkViper]

this should solve your problem:

replace this code (about line 135 in /modules/news/view.php)

Code: (old)

<?php

// Query posts (for this page)
$query_posts = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_posts
WHERE section_id = '$section_id' AND active = '1' AND title != ''$query_extra
AND (published_when = '0' OR published_when <= $t) AND (published_until = 0 OR published_until >= $t)
ORDER BY position DESC".$limit_sql);

?>

with the code below:

Code: (new)

<?php

// Query posts (for this page)
$query_posts = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_posts
WHERE section_id = '$section_id' AND active = '1' AND title != ''$query_extra
AND (published_when = '0' OR published_when <= $t) AND (published_until = 0 OR published_until >= $t)
ORDER BY posted_when DESC".$limit_sql);

?>

[Bug]

There is version of the newsmodule with some more settings, in that version you can set the way to display in the backend settings. This means you can have several pages containing a news module all with different settings.

http://www.websitebaker2.org/forum/index.php/topic,20760.msg141627.html#msg141627

[marcusalee]

hello darkviper and buq,

i have tried it and it works successfully
thankyou very much.