Web Wiz NewsPad - MOD: DB Import check against WWF

Print Page | Close Window

MOD: DB Import check against WWF

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz NewsPad
Forum Description: Support forum for the Web Wiz NewsPad application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24928
Printed Date: 28 March 2026 at 2:25am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: MOD: DB Import check against WWF

Posted By: MadDog
Subject: MOD: DB Import check against WWF
Date Posted: 01 December 2007 at 8:42pm

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.

-------------
http://www.iportalx.net" rel="nofollow">