Member gallery showing in recent pictures

[Ronlx2]

I didn't find any setting to keep a members gallery showing on recents posts, most rated or any other. Is their a way to have members gallery all by itself and not show up on the front page of the main gallery?

[SMFHacks]

Good idea, this feature does not currently exist.
If you want I could come up with some code for you to alter to hide the user gallery images to show up on the main page blocks for the gallyer index.

[Ronlx2]

If you come up with some before and after code I can change that would be perfect. Otherwise I can wait till you come up with something for all your members.

By the way just want to say your gallery pro and the new look and layout of the links mod is just great.

[SMFHacks]

Open Gallery.template.php in function MainPageBlock around line 2391
Find

Code: [Select]

switch($type)
{
case 'recent':
$query = "SELECT p.ID_PICTURE, p.commenttotal, p.totalratings, p.rating, p.filesize, p.views, p.thumbfilename, p.title, p.ID_MEMBER, m.memberName, m.realName, p.date, p.description FROM {$db_prefix}gallery_pic as p, {$db_prefix}members AS m WHERE  p.ID_MEMBER = m.ID_MEMBER AND p.approved = 1 ORDER BY p.ID_PICTURE DESC LIMIT 4";
break;

case 'viewed':
$query = "SELECT p.ID_PICTURE, p.commenttotal, p.totalratings, p.rating, p.filesize, p.views, p.thumbfilename, p.title, p.ID_MEMBER, m.memberName, m.realName, p.date, p.description FROM {$db_prefix}gallery_pic as p, {$db_prefix}members AS m WHERE  p.ID_MEMBER = m.ID_MEMBER AND p.approved = 1 ORDER BY  p.views DESC LIMIT 4";
break;

case 'mostcomments':
$query = "SELECT p.ID_PICTURE, p.commenttotal, p.totalratings, p.rating, p.filesize, p.views, p.thumbfilename, p.title, p.ID_MEMBER, m.memberName, m.realName, p.date, p.description FROM {$db_prefix}gallery_pic as p, {$db_prefix}members AS m WHERE  p.ID_MEMBER = m.ID_MEMBER AND p.approved = 1 ORDER BY p.commenttotal DESC LIMIT 4";
break;

case 'toprated':
$query = "SELECT p.ID_PICTURE, p.commenttotal, p.totalratings, p.rating, p.filesize, p.views, p.thumbfilename, p.title, p.ID_MEMBER, m.memberName, m.realName, p.date, p.description FROM {$db_prefix}gallery_pic as p, {$db_prefix}members AS m WHERE  p.ID_MEMBER = m.ID_MEMBER AND p.approved = 1 ORDER BY p.rating DESC LIMIT 4";
break;
}
Change to

Code: [Select]

switch($type)
{
case 'recent':
$query = "SELECT p.ID_PICTURE, p.commenttotal, p.totalratings, p.rating, p.filesize, p.views, p.thumbfilename, p.title, p.ID_MEMBER, m.memberName, m.realName, p.date, p.description FROM {$db_prefix}gallery_pic as p, {$db_prefix}members AS m WHERE  p.ID_MEMBER = m.ID_MEMBER AND p.approved = 1 AND p.USER_ID_CAT = 0 ORDER BY p.ID_PICTURE DESC LIMIT 4";
break;

case 'viewed':
$query = "SELECT p.ID_PICTURE, p.commenttotal, p.totalratings, p.rating, p.filesize, p.views, p.thumbfilename, p.title, p.ID_MEMBER, m.memberName, m.realName, p.date, p.description FROM {$db_prefix}gallery_pic as p, {$db_prefix}members AS m WHERE  p.ID_MEMBER = m.ID_MEMBER AND p.approved = 1 AND p.USER_ID_CAT = 0 ORDER BY  p.views DESC LIMIT 4";
break;

case 'mostcomments':
$query = "SELECT p.ID_PICTURE, p.commenttotal, p.totalratings, p.rating, p.filesize, p.views, p.thumbfilename, p.title, p.ID_MEMBER, m.memberName, m.realName, p.date, p.description FROM {$db_prefix}gallery_pic as p, {$db_prefix}members AS m WHERE  p.ID_MEMBER = m.ID_MEMBER AND p.approved = 1 AND p.USER_ID_CAT = 0 ORDER BY p.commenttotal DESC LIMIT 4";
break;

case 'toprated':
$query = "SELECT p.ID_PICTURE, p.commenttotal, p.totalratings, p.rating, p.filesize, p.views, p.thumbfilename, p.title, p.ID_MEMBER, m.memberName, m.realName, p.date, p.description FROM {$db_prefix}gallery_pic as p, {$db_prefix}members AS m WHERE  p.ID_MEMBER = m.ID_MEMBER AND p.approved = 1 AND p.USER_ID_CAT = 0 ORDER BY p.rating DESC LIMIT 4";
break;
}


[Ronlx2]

No didn't work, got this error

2406:             case 'viewed':

[Ronlx2]

I got it and it seems to be working great. Thanks for your help.