you should be be able to hook into our filter on the query and change the orderby… beware that ordering by date may be a significant performance penalty… mysql just isnt set up to handle that efficiently… where as ordering by the ID (which is the same as the date in simple press) is quite efficient in mysql…

do you understand filters?

for the code you posted, a few lines lower is a filter on the $spdb object… you can just change the orderby element and return the object to sort how you like…

Thanks for your response. I tried to do that by adding SFPOSTS.post_date to the fields and have:

$spdb->orderby = SFPOSTS.’ post_date DESC’;

but it didn’t work. It kept saying it was an invalid database query.

I agree that it would be better to have it done by id. Is there a way to redo the ids of the posts table (and subsequently the topic table) so that the ids are in the same order as the date?

can you post the code you used?

you would want something like the following in your spFunctions.php file…

add_filter(‘sph_topicview_query’, ‘my_topic_query’, 2);
function my_topic_query($spdb, $obj) {
    $spdb->orderby = ‘post_pinned DESC, ‘.spdb_zone_datetime(‘post_date’).’ DESC’;
    return $spdb;
}

now, I have not tried this…

You shouldn’t need to wrap it in the spdb_zone_datetime() function as the ordering will still be the same whether it is manipulated for local time zone or not. May as well save the extra overhead.

ah, good point…