Web Wiz Forums - Verify mail addresses in v.7.01?

Print Page | Close Window

Verify mail addresses in v.7.01?

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=5440
Printed Date: 02 April 2026 at 10:49pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Verify mail addresses in v.7.01?

Posted By: ask023
Subject: Verify mail addresses in v.7.01?
Date Posted: 02 September 2003 at 4:34am

Hello,

I have v7.01 SQL and there are a lot of users with old emails. I need to remove users who have incorrect emails in profiles...

Could you please recommend me best way to check all emails or remove uses with incorrect emails?

Thank you!
Best wishes,
Sergey

Replies:

Posted By: WebWiz-Bruce
Date Posted: 02 September 2003 at 4:51am

Apart from sending them an email and waiting to see if they reply to it there is no way of telling for sure if the email address is valid.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: ask023
Date Posted: 02 September 2003 at 5:05am

Thank you for reply!
Could you please tell me, can I batch delete members by emails addresses?
For example,
1) I'll export addresses and verify all by external program.
2) I'll have emails list with marked "bad" emails
3) What should I perform to delete members (in SQL) by specified emails?

Posted By: WebWiz-Bruce
Date Posted: 02 September 2003 at 6:08am

You can't you need to use the pages within the forum itself to delete members which currently don't support deleting by email.

If you try deleting a member who has posted in the past you will crash the forum as when posts are displayed it needs to be related to an author that has posted. The same with PM's and many other parts of the forum as it is using a relational database system.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: ask023
Date Posted: 02 September 2003 at 7:22am

Thank you, Bruce!
Probably I may
- verify emails
- add 1 to posts count for "valid" members
- next delete users w/o posts through forum interface...

Can I manually change posts count through SQL script for all users?

Posted By: WebWiz-Bruce
Date Posted: 02 September 2003 at 8:40am

You could yes.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting