News.php Modification: How do I modify this code related to attachments?

[sfnet]

Currently, there are three options listed under 'Enable Attachments'

Turn this option on to display the attachments associated with each news post.

* - No
* - Yes, First Attachment Only
* - Yes, All Attachments

Is there a slight modification or tweak I could make to the News Module so that when I select "Yes, First Attachment Only", it actually displays the First Three Attachments only??

I appreciate any feedback/advice anybody can give. I am a totally novice when it comes to reading/interpreting PHP.

[sfnet]

Answer:

After the following code in news.php:

SELECT attachmentid, filename, filesize, dateline, postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, counter, attachment.thumbnail, attachment.thumbnail_dateline, LENGTH(attachment.thumbnail) AS thumbnailsize, newwindow, visible
* *FROM " . TABLE_PREFIX . "attachment AS attachment
* *LEFT JOIN " . TABLE_PREFIX . "attachmenttype AS attachmenttype ON (attachment.extension = attachmenttype.extension)
* *WHERE postid IN(" . implode(',', $newspids) . ")
* * AND visible = 1
* *" . iif($mod_options['portal_news_showattachments'] != 2, 'GROUP BY attachment.postid') . "
* *ORDER BY attachmentid

Add

Limit 0,3

Save and Enjoy!