Announcement
Collapse
No announcement yet.
How to change number of thumbnails to show in Social Groups?
Collapse
X
-
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.
Leave a comment:
-
It's hardcoded in the groups.php file (I think the query around like 2233).
- 1 like
Leave a comment:
-
edit to add: I didnt mean the discussion group home page, I meant the home page of a particular discussion group. Sorry.
Leave a comment:
-
How to change number of thumbnails to show in Social Groups?
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.
ThanksTags: None
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Leave a comment: