Changeset 13134

Timestamp:

11/03/09 02:42:53 (2 years ago)

Author:

Alexander Ermashev

Message:

• ticket #1397;

File:

• trunk/inc/classes/BxDolCmtsQuery.php (modified) (2 diffs)

trunk/inc/classes/BxDolCmtsQuery.php

@@ -35 +35 @@
             $sJoin = "LEFT JOIN {$this->_sTableTrack} AS `r` ON (`r`.`cmt_system_id` = ".$this->_aSystem['system_id']." AND `r`.`cmt_id` = `c`.`cmt_id` AND `r`.`cmt_rate_author_id` = $iAuthorId)";
         }       
-                
+
         $a = $this->getAll("SELECT 
                 $sFields
@@ -53 +53 @@
             $sJoin
             WHERE `c`.`cmt_object_id` = '$iId' AND `c`.`cmt_parent_id` = '$iCmtParentId'
-            ORDER BY `c`.`cmt_time` " . ('ASC' == $sCmtOrder ? 'ASC' : 'DESC') . ($iCount != -1 ? ' LIMIT ' . $iStart . ', ' . $iCount : ''));
+            ORDER BY `c`.`cmt_time` " . ( strcasecmp('ASC', $sCmtOrder) ? 'ASC' : 'DESC') . ($iCount != -1 ? ' LIMIT ' . $iStart . ', ' . $iCount : ''));
 
         //LEFT JOIN `media` AS `m` ON (`m`.`med_id` = `p`.`Avatar` AND `m`.`med_status` = 'active')