cdj-100s <-> cmx-3000

Reemski schreef:

Reemski schreef:

CREATE PROCEDURE SP_F_ListPosts
@UserId AS Int,
@TopicID as Int,
@Page int
AS
SET NOCOUNT ON
DECLARE
	@RecCount int,
	@RecsPerPage int,
	@Level int,
	@TotalRecords int

If @userID>0
	Begin
	DELETE From F_LastVisitList WHERE UserID=@UserID AND TopicID=@TopicID
	Update F_Users Set LastVisit=GetDate() Where UserId=@UserID
	End

SELECT @RecsPerPage=F_Users.PostsPerPage, @Level=F_Status.StatusLevel
FROM F_Status INNER JOIN F_Users ON F_Status.StatusID = F_Users.Status
WHERE F_Users.UserID=@UserID
SELECT @RecCount = @RecsPerPage * @Page + 1
CREATE TABLE #TempItems
(
	ID int IDENTITY Primary Key,
	PostID int
)
INSERT INTO #TempItems (PostId)
SELECT PostID
FROM F_Posts INNER JOIN F_Topics ON F_Posts.TopicId = F_Topics.TopicID
INNER JOIN F_Forums ON F_Topics.ForumID = F_Forums.ForumID 
WHERE F_Posts.TopicId = @TopicID AND F_Forums.Level <= @Level
ORDER BY PostID ASC
Select @TotalRecords=@@RowCount
If @Page=0 Select @Page=round(@TotalRecords/@RecsPerPage-1,0,1)+1
Select TotalRecords=@TotalRecords,
TotalPages=CAST(((@TotalRecords)+@RecsPerPage-1)/@RecsPerPage AS Int),
PostsPerPage=@RecsPerPage, Curpage=@Page;
DECLARE @FirstRec int, @LastRec int
SELECT @FirstRec = (@Page - 1) * @RecsPerPage
SELECT @LastRec = (@Page * @RecsPerPage + 1)
SELECT F_Users.UserID, F_Users.UserName, F_Users.EntryDate,
F_Users.MailVisible,
	F_Users.Email, F_Users.Homepage, F_Users.PostCount,
	F_Users.Quote, F_Status.StatusName, F_Status.StatusLevel,
	F_Posts.Icon, F_Posts.Date, F_Posts.PostID,
	F_posts.EditCount, F_posts.Message, F_Posts.EditDate,
	F_posts.RootMSG, F_Users_1.UserName AS EditName,
	F_Posts.PostIP, F_Users.Email
FROM ([#TempItems] INNER JOIN (F_Posts INNER JOIN 
	(F_Users INNER JOIN F_Status ON
	F_Users.Status = F_Status.StatusID) ON
	F_Posts.UserID = F_Users.UserID)
	ON [#TempItems].PostID = F_Posts.PostID)
	LEFT JOIN F_Users AS F_Users_1
	ON F_Posts.EditUserID = F_Users_1.UserID
WHERE ID > @FirstRec AND ID < @LastRec
Drop Table #TempItems
Return
GO

Reemski schreef:

Dré schreef:

DSalembier schreef: