Verify mail addresses in v.7.01?

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
ask023 Members Profile Find Members Posts Groupie Joined: 16 February 2003 Status: Offline Points: 130	Post Options Post Reply Quote ask023 Report Post Thanks(0) Quote Reply Topic: Verify mail addresses in v.7.01? 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

ask023 Members Profile Find Members Posts Groupie Joined: 16 February 2003 Status: Offline Points: 130	Post Options Post Reply Quote ask023 Report Post Thanks(0) Quote Reply 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?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

ask023 Members Profile Find Members Posts Groupie Joined: 16 February 2003 Status: Offline Points: 130	Post Options Post Reply Quote ask023 Report Post Thanks(0) Quote Reply 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? Edited by ask023

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 02 September 2003 at 8:40am
	You could yes.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.