Web Wiz Forums - Watch this Forum -Groups

Print Page | Close Window

Watch this Forum -Groups

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=12803
Printed Date: 11 April 2026 at 4:34pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Watch this Forum -Groups

Posted By: rhamlin
Subject: Watch this Forum -Groups
Date Posted: 02 December 2004 at 12:30pm

Is there a way that as the admin of the forums, I can make sure that a specific "Group" receives email notification of new or updated posts in a particular forum.

If not, it would make a great addition to the member groups feature.

Just a thought.

Replies:

Posted By: dj air
Date Posted: 02 December 2004 at 2:16pm

no. they have to subscribe to it.

else it can be classed as a form of spam (i know silly) but its true.

unless they subscribe then no.

Posted By: rhamlin
Date Posted: 02 December 2004 at 2:33pm

I think we should be able to add it and then they can unsubscribe if they dont want it. It should be up to the admin to turn it on or not. If this isnt a public forum then It wouldn't be considered spam.

Posted By: dj air
Date Posted: 02 December 2004 at 2:37pm

if its not public.. why not set AN INSERT IN TO SQL

that adds a record automaticlly into the email notify table with the details of the forums.

do this when they are put into the Group.

Posted By: rhamlin
Date Posted: 02 December 2004 at 3:18pm

dj air wrote:

if its not public.. why not set AN INSERT IN TO SQL

that adds a record automaticlly into the email notify table with the details of the forums.

do this when they are put into the Group.

How?

BTW I am using an access DB, Not SQL

Posted By: dj air
Date Posted: 02 December 2004 at 3:40pm

sorry ment use SQL "INSERT INTO "

it would work in both versions.





    

    'Initalise the SQL string with a query to get the email notify topic details

    If strDatabaseType = "SQLServer" Then

        strSQL = "EXECUTE " &
strDbProc & "TopicEmailNotify @lngAuthorID = " &
lngLoggedInUserID & ", @lngTopicID= " & lngTopicID

    Else

        strSQL = "SELECT " & strDbTable & "EmailNotify.*  "

        strSQL = strSQL & "FROM " & strDbTable & "EmailNotify "

        strSQL = strSQL & "WHERE "
& strDbTable & "EmailNotify.Author_ID=" & lngLoggedInUserID
& " AND " & strDbTable & "EmailNotify.Topic_ID=" &
lngTopicID & ";"

    End If



    With rsCommon



        'Set the cursor type property of
the record set to Dynamic so we can navigate through the record set

        .CursorType = 2



        'Set the Lock Type for the
records so that the record set is only locked when it is updated

        .LockType = 3

        

        'Query the database

        .Open strSQL, adoCon



            'Check to see if the user is allowed to view posts in this forum

            Call
forumPermisisons(intForumID, intGroupID, intReadPermission, 0, 0, 0, 0,
0, 0, 0, 0, 0)

            

            'If the user can read in this forum the add them

            If blnRead Then

                'Add new rs

                .AddNew

    

                'Create new entry

                .Fields("Author_ID") = lngLoggedInUserID

                .Fields("Topic_ID") = lngTopicID

    

                'Upade db with new rs

                .Update

                

                'Set the return value

                strReturnValue = "&EN=TS"

            End If





        'Clean up

        .Close



    End With

alll you need to do is add this to the section that changes group, use an If groupID = x then

code
end if

all you need to do is specify lngTopicID

also you may want to ad dmultipals of it to allow for extra forums or do a loop