Grouping comments for the same pic in lastcom

[qdinar]

one more bug of last comments code that is in Reply #14 : when [you](?) open category or album, last comments stay as it is on the frontpage, while last comments' title says "last comments - category of something" and built-in (default,original,standard) code showed here only comments of images that are in currently being viewed category or album.

[dwo]

Finally I found one problem with the code.

"last comments" shows all comments. This means the comments on private albums, too. It should hide them.

Is there any way to fix that?

Thank you very much.

[TripleFi 10]

Thank you and best regards

[pilgrim13]

Hello, somebody knows how to adapt it for version 1.5.h. The problem stems from the fact that this version is used msg_id?

Thank you for your help!

[Cmaniac]

It is definitely something that CPG 1.5 needs 

[Cmaniac]

And I have implemented it.

In functions.inc.php after

Code Select Expand

if ($cat && $CURRENT_CAT_NAME) {
            $album_name = cpg_fetch_icon('comment', 2) . $album_name = $lang_meta_album_names['lastcom'] . ' - ' . $CURRENT_CAT_NAME;
        } else {
            $album_name = cpg_fetch_icon('comment', 2) . $lang_meta_album_names['lastcom'];
        }

The $query becomes

Code Select Expand

        $query = "SELECT COUNT(DISTINCT(r.pid))
                FROM {$CONFIG['TABLE_COMMENTS']} AS c
                INNER JOIN {$CONFIG['TABLE_PICTURES']} AS r ON r.pid = c.pid
                INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON a.aid = r.aid
                $RESTRICTEDWHERE
                AND r.approved = 'YES'
                AND c.approval = 'YES'";

And after

$select_columns = implode(', ', $select_column_list);

the $query becomes

Code Select Expand

        $query = "SELECT * FROM (SELECT $select_columns
                FROM {$CONFIG['TABLE_COMMENTS']} AS c
                INNER JOIN {$CONFIG['TABLE_PICTURES']} AS r ON r.pid = c.pid
                INNER JOIN {$CONFIG['TABLE_ALBUMS']} AS a ON a.aid = r.aid
                $RESTRICTEDWHERE
                AND r.approved = 'YES'
                AND c.approval = 'YES'
ORDER BY msg_id $DESC) AS c
GROUP BY c.pid
                ORDER BY msg_id $DESC
                $limit";

That's all. I am no coding expert but I've found out that it works and I'm happy to share it.

I take no responsibility if it doesn't work as expected.

[Cmaniac]

Well, it doesn't. I will come back later if I find any other solution.

[Αndré]

FYI: this meta album has been added to the "More Meta Albums" plugin in version 1.7.