We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Video Comment Order | Forum

Harry
Harry Dec 9 '14
Trying to get the order of video comments from newest to oldest but it is not cooperating.  I have amended, in ow_system_plugins/base/bol/comments_dao.php the following query to order in descending ( and have of course cleared the cache ), but still displays oldest at the top.


    public function findFullCommentList( $entityType, $entityId )    {        $query = "SELECT `c`.* FROM `" . $this->getTableName() . "` AS `c`LEFT JOIN `" . BOL_CommentEntityDao::getInstance()->getTableName() . "` AS `ce` ON ( `c`.`" . self::COMMENT_ENTITY_ID . "` = `ce`.`id` )WHERE `ce`.`" . BOL_CommentEntityDao::ENTITY_TYPE . "` = :entityType AND `ce`.`" . BOL_CommentEntityDao::ENTITY_ID . "` = :entityIdORDER BY `" . self::CREATE_STAMP . "` DESC";
        return $this->dbo->queryForObjectList($query, $this->getDtoClassName(), array('entityType' => $entityType, 'entityId' => $entityId));    }


ross Team
ross Dec 9 '14
Topic was moved from General Questions.