[tamarian]

Originally Posted by Pseudomizer

Hi,

i would like to use this script but only for one reason: I got round about 10 registrations per day and 5 of them use invalid email addresses. :disappointed:

What i would need is a cron job which runs once a day one specific script which checks this bouncing emailaddress and afterwards deletes all invalid accounts from the usergroup "Awaing Email confirmation". :nervous:

Environment:
SuSe Linux 8.2, Perl 5.8.0, latest MySQL and latest Apach 1.x version and latest Qmail version mit POP3-before-SMTP installed.

Any help would be appreciated.

Cheers,

Should be easy to modify this script to do what you want.

The search can be restricted to only the usergroup awaiting email activation:

Change this qury:

"SELECT userid, username from user where email='$theemail'"

To:

"SELECT userid, username from user where email='$theemail' AND usergroupid=3"

And the unsubscribe query can be replaced with a user deletion query:

Change:

UPDATE subscribethread set emailupdate='$downgrade' where userid='$varname1'"

To:
DELETE from user where userid='$varname1'

This is a rough idea of how it can be done....