Unique Last comments mod

[RadioErewan]

getLastImagesWithComments returns non unique result. So, it is often strip or table full of same pictures.
We struggled with this problem, and now we have good working solution.
Replace function getLastImagesWithComments($limit) with following version, and all lastComments will be unique across selection.
Thanks Cra3y!
This verison is "optimized", and configurable.
Working model you can find here: http://forum.olympusclub.pl

Code Select Expand

function getLastImagesWithComments($limit) {
   $resultset = array();
   if (is_numeric($limit)) {
       $sqlcode = "SELECT {$this->sqlPostSelect} " . $this->sqlSelect
           . ", m.msg_body AS mMsg_body, m.msg_author AS mMsg_author "
           . " FROM "
           . $this->sqlTableSelect. ", "
           . "(SELECT MAX( msg_id ) AS latest, pid AS pido "
           . "FROM ". $this->cfg['table_prefix'] . "comments "
           . "GROUP BY pid"
           . ") AS x "
           . "INNER JOIN " . $this->cfg['table_prefix'] . "comments AS m ON m.pid = pido "
           . "AND m.msg_id = x.latest"
           . " WHERE m.pid = p.pid "
           . $this->sqlUserDataLink
           . $this->filetypefilter
           . " AND p.approved='YES' {$this->privacyfilter}"
           . " ORDER BY m.msg_date DESC LIMIT 0,$limit";
           
       $resultset = $this->dbExecuteSql($sqlcode);
       $this->addPathInfo($resultset);
   }   
Regards

[RadioErewan]

Forgot, this function comes from cpmfetch_dao.php.

Regards