MOD: DB Import check against WWF

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Something i didnt like about the Newsletter DB import is that it wouldnt check against a WWF database, so i modifed admin_import_subscribers.asp.

Around line 684 you will find:

'Initalise the strSQL variable with an SQL statement to query the database
            strSQL = "SELECT " & strDbTable & "Members.* " & _
                "FROM " & strDbTable & "Members " & _
                "WHERE " & strDbTable & "Members.Email = '" & strEmail & "';"

Right above that (dont replace it), add:
strSQL = "SELECT tblAuthor.Author_email FROM tblAuthor WHERE Author_email = '" & strEmail & "';"

            rsCommon.Open strSQL, adoCon

            If NOT rsCommon.EOF Then
                blnEmailExists = True

                'Increment the already imported number
                lngMemberAlreadyImported = lngMemberAlreadyImported + 1
            End If

            rsCommon.Close

Now if you import against another database and have it intergraded with WWF, it will check the Members table and WWF.