fnNetworkingViewableAlbums

Returns 1 if user @TargetUserID has albums with photos viewable to user @CurrentUserID

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@TargetUserID	int	IN
@CurrentUserID	int	IN

Definition

Copy



CREATE function dbo.fnNetworkingViewableAlbums(@TargetUserID int, @CurrentUserID int)
returns int
as begin
    declare @FriendID int;
    execute @FriendID = fnGetNetAccountRelationID @CurrentUserID, @TargetUserID;
    declare @ClientID int;
    select @ClientID = ClientUsersID from dbo.NetAccount where ID = @TargetUserID;
    declare @NumAlbums int;

    declare @Confirmed bit;
    select @Confirmed = Confirmation from dbo.NetAccountRelation where ID = @FriendID;

    if @Confirmed = 0
        select @FriendID = 0;

    if @FriendID > 0
    BEGIN
        select @NumAlbums = count(album.ID) from dbo.ImageAlbum album
        inner join dbo.ImageAlbum_Images images
            on images.ImageAlbumID = album.ID
        where (album.OwnerUserID = @ClientID) and ((album.Security = 0) OR (album.Security = 1)) and album.Deleted=0  and album.AlbumType = 1;            
    END
    else
    BEGIN
        select @NumAlbums = count(album.ID) from dbo.ImageAlbum album
        inner join dbo.ImageAlbum_Images images
            on images.ImageAlbumID = album.ID
        where (album.OwnerUserID = @ClientID) and (album.Security = 0) and album.Deleted=0  and album.AlbumType = 1;
    END
    return @NumAlbums
end