Changeset 13134
- Timestamp:
- 11/03/09 02:42:53 (3 weeks ago)
- Files:
-
- trunk/inc/classes/BxDolCmtsQuery.php (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/inc/classes/BxDolCmtsQuery.php
r13070 r13134 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)"; 36 36 } 37 37 38 38 $a = $this->getAll("SELECT 39 39 $sFields … … 53 53 $sJoin 54 54 WHERE `c`.`cmt_object_id` = '$iId' AND `c`.`cmt_parent_id` = '$iCmtParentId' 55 ORDER BY `c`.`cmt_time` " . ( 'ASC' == $sCmtOrder? 'ASC' : 'DESC') . ($iCount != -1 ? ' LIMIT ' . $iStart . ', ' . $iCount : ''));55 ORDER BY `c`.`cmt_time` " . ( strcasecmp('ASC', $sCmtOrder) ? 'ASC' : 'DESC') . ($iCount != -1 ? ' LIMIT ' . $iStart . ', ' . $iCount : '')); 56 56 57 57 //LEFT JOIN `media` AS `m` ON (`m`.`med_id` = `p`.`Avatar` AND `m`.`med_status` = 'active')

