
[dbo].[Forum_Members_GetOnline]
CREATE PROCEDURE dbo.[Forum_Members_GetOnline] @PortalID INT
AS
SELECT U.[UserID],
[PostCount],
[EnableDisplayInMemberList],
[EnableOnlineStatus],
[EnablePM],
U.[PortalID],
[FirstName],
[LastName],
[Email],
[Username],
[PostCount],
( SELECT COUNT(UserID)
FROM dbo.Forum_vw_ForumUsers
) AS TotalRecords
FROM dbo.UsersOnline UO
INNER JOIN dbo.Forum_vw_ForumUsers U ON UO.UserID = U.UserID
WHERE U.PortalID = @PortalID
GO