Page 1 of 1

Blog Made Simple: Posting Order

Posted: Mon Nov 05, 2007 4:05 am
by mnapiork
I've installed Blog Made Simple and everything appears to be working fine except the ordering of the posts.  Newer posts appear after older posts. I've set the oldestfirst="false" and the oldestfirst="true" and neither parameter seems to affect the order of the posts. 

Does anyone know how to fix this problem?

Thanks in advance,
Michael

Re: Blog Made Simple: Posting Order

Posted: Thu Nov 08, 2007 4:46 am
by mnapiork
Found a solution. I ended up modifying the SQL statements in Blogs.module.php in the Blog module directory  to DESC instead of ASC.  I'm never going to want the blog in the reverse order so this works for me.

Michael

Re: Blog Made Simple: Posting Order

Posted: Thu Nov 15, 2007 4:23 pm
by blaquekaat
Hi Micheal

I'm having the same issue as you. I've changed every mention of ASC to DESC that I could find with no luck. Could you be more specific as to what you changed and where?

Blaquekaat

Re: Blog Made Simple: Posting Order

Posted: Fri Feb 08, 2008 3:02 pm
by swapdude
Hi mnapiork,

Find this statement in Blogs.Module.php

$query="SELECT DISTINCT entry.* FROM ".cms_db_prefix()."module_blogs_entries AS entry LEFT JOIN ".cms_db_prefix()."module_blogs_comments AS comment ON entry.id=comment.entry WHERE entry.category=? $active ORDER BY comment.createtime";

And change the last part from comment.createtime -> entry.createtime

That should do it.

Swap