Custom code of yaf_usergroup · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

smikkel
51.2% (Neutral)
YAF Forumling Topic Starter

15 years ago

Hi,

I made a little customisation to set specific groups for some users using an external vb.net aspx page.

I'm logged on with a user, when I run the code it works, I'm redirected to the "yaf_forumlink.aspx" page where I don't have access normally, when I look into my profile I see that I'm a member of the new group.

When I wait some time and refresh the page I'm no longer a member of the new group.

What am I missing here?

What is causing the deletion if the record?

Running 1.94 RC1

forum.SetUserGroup(forum.GetUserID(theuser), 4)
Response.Redirect("yaf_forumlink.aspx")

  Public Shared Sub SetUserGroup(ByVal userid As Integer, ByVal groupid As Integer)
        Dim myyaf As New YafDBConnManager
        Dim sqlcom As New SqlCommand
        Try
            sqlcom.CommandType = CommandType.Text
            sqlcom.Connection = myyaf.OpenDBConnection
            sqlcom.CommandText = "insert into yaf_usergroup(groupid,userid) values (@groupid,@userid)"
            sqlcom.Parameters.AddWithValue("@groupid", groupid)
            sqlcom.Parameters.AddWithValue("@userid", userid)
            sqlcom.ExecuteNonQuery()

            myyaf.CloseConnection()
        Catch ex As Exception
        End Try
        sqlcom.Dispose()
        sqlcom = Nothing
        myyaf.Dispose()
        myyaf = Nothing
    End Sub

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Sponsor

smikkel
51.2% (Neutral)
YAF Forumling Topic Starter

15 years ago

I figured it out, I needed to add this code after the database update:

    If Not (UserMembershipHelper.IsGuestUser(userid)) Then
                username = UserMembershipHelper.GetUserNameFromID(userid)
                RoleMembershipHelper.AddUserToRole(username, "Myrole")
            End If

Important Information: