Hi,

May I know how can I change the way comments are displayed in the blog, profile and photo gallery? I want to display the latest comment on top instead of the oldest one as what we have by default.

Please advise. THanks/

Open the file inc/classes/BxDolCmtsQuery.php

FInd:

Code: Select all

      $a = $this->getAll("SELECT
            $sFields
            `c`.`cmt_id`,
            `c`.`cmt_parent_id`,
            `c`.`cmt_object_id`,
            `c`.`cmt_author_id`,
            `c`.`cmt_text`,
            `c`.`cmt_rate`,
            `c`.`cmt_rate_count`,
            `c`.`cmt_replies`,
            (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`c`.`cmt_time`)) AS `cmt_secs_ago`,
            `p`.`NickName` AS `cmt_author_name`,
            `m`.`med_file` AS `cmt_author_icon`
         FROM {$this->_sTable} AS `c`
         LEFT JOIN `Profiles` AS `p` ON (`p`.`ID` = `c`.`cmt_author_id`)
         LEFT JOIN `media` AS `m` ON (`m`.`med_id` = `p`.`PrimPhoto` AND `m`.`med_status` = 'active')
         $sJoin
         WHERE `c`.`cmt_object_id` = '$iId' AND `c`.`cmt_parent_id` = '$iCmtParentId'
         ORDER BY `c`.`cmt_time` ASC");

Replace it with:

Code: Select all

      $a = $this->getAll("SELECT
            $sFields
            `c`.`cmt_id`,
            `c`.`cmt_parent_id`,
            `c`.`cmt_object_id`,
            `c`.`cmt_author_id`,
            `c`.`cmt_text`,
            `c`.`cmt_rate`,
            `c`.`cmt_rate_count`,
            `c`.`cmt_replies`,
            (UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`c`.`cmt_time`)) AS `cmt_secs_ago`,
            `p`.`NickName` AS `cmt_author_name`,
            `m`.`med_file` AS `cmt_author_icon`
         FROM {$this->_sTable} AS `c`
         LEFT JOIN `Profiles` AS `p` ON (`p`.`ID` = `c`.`cmt_author_id`)
         LEFT JOIN `media` AS `m` ON (`m`.`med_id` = `p`.`PrimPhoto` AND `m`.`med_status` = 'active')
         $sJoin
         WHERE `c`.`cmt_object_id` = '$iId' AND `c`.`cmt_parent_id` = '$iCmtParentId'
         ORDER BY `c`.`cmt_time` DESC");

Thank you