madeon (madeon) wrote in changelog,
madeon
madeon
changelog

[livejournal] r21003: LJSUP-11063: sorting order has been chan...

Committer: sbelyaev
LJSUP-11063: sorting order has been changed.
U   trunk/cgi-bin/LJ/DelayedEntry.pm
Modified: trunk/cgi-bin/LJ/DelayedEntry.pm
===================================================================
--- trunk/cgi-bin/LJ/DelayedEntry.pm	2012-01-26 09:23:13 UTC (rev 21002)
+++ trunk/cgi-bin/LJ/DelayedEntry.pm	2012-01-26 11:22:34 UTC (rev 21003)
@@ -793,12 +793,12 @@
         $sql_limit = "LIMIT $skip, $show";
     }
 
-    my $sticky_sql = $sticky_on_top ? 'is_sticky DESC, ' : '';
+    my $sticky_sql = $sticky_on_top ? 'is_sticky ASC, ' : '';
 
     my $journalid = $journal->userid;
     return $dbcr->selectcol_arrayref("SELECT delayedid " .
                                      "FROM delayedlog2 WHERE journalid=$journalid  $sql_poster".
-                                     "ORDER BY $sticky_sql revptime ASC $sql_limit");
+                                     "ORDER BY $sticky_sql revptime DESC $sql_limit");
 }
 
 sub get_first_entry {

Tags: livejournal, madeon, pm, sbelyaev
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 0 comments