alexbabo

 
if ($we_friends || $my_profile ){
     $allow_a = "";
    $allow_p = "";
      }else{
    $allow_a = "AND a.allow_who = 'all'";
    $allow_p = "AND p.allow_who = 'all'";
}
 
 
 

 
$usr = cmsUser::getShortUserData($user_id);
 
    $my_profile = ($inUser->id == $user_id) ? true : false;
    $we_friends = ($inUser->id && !$my_profile) ? cmsUser::isFriend($usr['id']) : 0;
     if ($we_friends && !$my_profile){
    $allow_a = "AND a.allow_who = 'friends'";
    $allow_p = "AND p.allow_who = 'friends'";
      }else{
      if($my_profile ){
    $allow_a = "";
    $allow_p = "";
     }else{
    $allow_a = "AND a.allow_who = 'all'";
    $allow_p = "AND p.allow_who = 'all'";}
    }
 
    $sql_userphotos = "SELECT p.id, p.pubdate, p.imageurl as file, p.hits, p.title
    FROM cms_user_photos p 
    INNER JOIN cms_user_albums a ON a.id = p.album_id {$allow_a}
    WHERE p.user_id = '{$user_id}' {$allow_p}
    ORDER BY id DESC LIMIT {$photos_n}";