Forums

Forum_ThreadMove.ascx.vb (around line 193)

Private Sub cmdMove_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdMove.Click

Try

' See if user selected a forum to move thread to.

' Get the forumID where the user is moving the thread to

Dim newForumID As Integer = Int32.Parse(ctlForumLookup.ResultItems.TrimStart(";"c))

' If the new forumID is the same as the old ForumID

If newForumID = mOldForumID Then

' Show user error message

MessageCell.Controls.Add(UI.Skins.Skin.GetModuleMessageControl("", DotNetNuke.Services.Localization.Localization.GetString("OldForumSeleted.Text", Me.LocalResourceFile), DotNetNuke.UI.Skins.Controls.ModuleMessage.ModuleMessageType.RedError))

Exit Sub

Else

' It is not the same forumID, Move it

Dim ctlThread As New ThreadController

' return to new forum page

Dim params As String() = New String(2) {"scope=threads", "forumid=" & newForumID.ToString, "mid=" & ModuleId}

Dim strURL As String = NavigateURL(TabId, "", params)

End If

'Else

' ' User did not select a forum to move post to, show an error validator.

' lblInfo.Visible = True

'End If

Catch ex As Exception

Dim x As String

End Try

End Sub

Data Changes, Be Very Careful!!!

FOR-2260

This is taken from a new dataprovider file, but i recomend replacing proper items and running manually.  Otherwise, you could cause future upgrade conflicts.

"if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}Forum_UserDeleteReads') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}Forum_UserDeleteReads
GO

if exists (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}Forum_UserThreadsDelete') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure {databaseOwner}{objectQualifier}Forum_UserThreadsDelete
GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}Forum_UserDeleteReads
 @UserId int
AS

DELETE FROM {objectQualifier}Forum_UserThreads
WHERE UserID = @UserId

DELETE FROM {objectQualifier}Forum_UserForums
WHERE UserID = @UserId

GO

CREATE PROCEDURE {databaseOwner}{objectQualifier}Forum_UserThreadsDelete
 @UserID int,
 @ThreadID int
AS

DELETE FROM {objectQualifier}Forum_UserThreads
WHERE
 UserID = @UserID
 AND
 ThreadID = @ThreadID

GO"