How to change number of thumbnails to show in Social Groups?

[smirkley]

v4.2.0pl3


I wish to change the number of thumbnail pictures that show up at the top of a social group discussion home page, from 5 to 6, or any other number for that matter.

I cannot find the setting that allows me to adjust that number. It is stuck at 5.

I am even ok to hardcode it if that is how it is done, but I cant find that either.

Any assistance appreciated.

Thanks

[smirkley]

edit to add: I didnt mean the discussion group home page, I meant the home page of a particular discussion group. Sorry.

[Lynne]

It's hardcoded in the groups.php file (I think the query around like 2233).

[smirkley]

Thank you Lynne, I found it. I also changed the ordering.

group.php

$pictures_sql = $db->query_read_slave("
SELECT
a.attachmentid, a.userid, a.caption, a.dateline,
fd.filesize, fd.thumbnail_filesize, fd.thumbnail_dateline, fd.thumbnail_width, fd.thumbnail_height, IF(fd.thumbnail_filesize > 0, 1, 0) AS hasthumbnail,
user.username
$hook_query_fields
FROM " . TABLE_PREFIX . "attachment AS a
INNER JOIN " . TABLE_PREFIX . "filedata AS fd ON (a.filedataid = fd.filedataid)
INNER JOIN " . TABLE_PREFIX . "socialgroupmember AS socialgroupmember ON
(socialgroupmember.userid = a.userid AND socialgroupmember.groupid = $group[groupid] AND socialgroupmember.type = 'member')
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = a.userid)
$hook_query_joins
WHERE
a.contentid = $group[groupid]
AND
a.contenttypeid = $contenttypeid
$hook_query_where
ORDER BY a.dateline ASC
LIMIT 3
");

Posted here if anyone else wants to see where and how to change the ordering from DESC to ASC, as well as qty 5 to qty 3.

Thanks again.

[ywwz]

Thank you Lynne, I found it. I also changed the ordering.

group.php



Posted here if anyone else wants to see where and how to change the ordering from DESC to ASC, as well as qty 5 to qty 3.

Thanks again.

Thank you so much man.

[hurricane_sh]

Thanks, I wondered about this as well.