https://www.icyphoenix.com/viewtopic.php?f=26&t=1100&p=9366#p9366
-----------------------------------
Artie
Thu 01 Mar, 2007 23:38

Re: Personal Galery Images Mix With Public
-----------------------------------
You are correct. Unfortunately when doing these type of modifications, you often break something else. 

You can try this fix:

OPEN [b]album_mod/album_hierarchy_sql.php[/b]

LOOK WITHIN
[codeblock]function album_build_recent_pics[/codeblock]
FIND
[codeblock]if ( !empty($cats)  )[/codeblock]
BEFORE ADD
[codeblock]####################################################################	

$where = (!empty($_GET['user_id']))? "WHERE p.pic_cat_id IN ($cats) AND ( p.pic_approval = 1 OR ct.cat_approval = 0 )" : "WHERE ( p.pic_approval = 1 OR ct.cat_approval = 0 )";

##############################################################[/codeblock]

FIND
[codeblock]WHERE ( p.pic_approval = 1 OR ct.cat_approval = 0 )[/codeblock]
REPLACE WITH
[codeblock]".$where."[/codeblock]

I did notice that after applying this that the Recent Pics block in users profile, only showed personal pics, but I think it may have been that way before....dunno


