X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=lib%2Fattachmentnoticesection.php;h=7a22bd0e9d271cb626d26e3af734bebff3c1d941;hb=refs%2Fheads%2Fupstream-changes%2Fgoogle-analytics-removal;hp=25e64adf9efdc2d2e139485f476135b886e2f77b;hpb=e36399974e6ccd1ee3e53bfffa3c34edaf8bd488;p=quix0rs-gnu-social.git diff --git a/lib/attachmentnoticesection.php b/lib/attachmentnoticesection.php index 25e64adf9e..7a22bd0e9d 100644 --- a/lib/attachmentnoticesection.php +++ b/lib/attachmentnoticesection.php @@ -52,9 +52,10 @@ class AttachmentNoticeSection extends NoticeSection function getNotices() { $notice = new Notice; - $f2p = new File_to_post; - $f2p->file_id = $this->out->attachment->id; - $notice->joinAdd($f2p); + + $notice->joinAdd(array('id', 'file_to_post:post_id')); + $notice->whereAdd(sprintf('file_to_post.file_id = %d', $this->out->attachment->id)); + $notice->orderBy('created desc'); $notice->selectAdd('post_id as id'); $notice->find(); @@ -69,6 +70,6 @@ class AttachmentNoticeSection extends NoticeSection function divId() { - return 'popular_notices'; + return 'attachment_section'; } }