What app are you using to modify functions.php? I use Dreamweaver, Notepad, and wordpad but get parse errors on upload.

Chemo

Hmm...:
error:

Can't locate DBI.pm in @INC

I guess I need some soft of perl DBI module or something? Just guessing... ?

Thanks-

I mostly use Quanta and Kate (Linux apps) on the desktop, or vi on the server.

I think many windows users use TextPad, or PHPEdit. Basically any programming editor, and make sure you upload as ASCII, not binary when using FTP.

Correct :)

Many many thanks for this fantastic hack. No more 500MB bounced email boxes! :D Took me awhile to get the perl DBD module installed correctly (with the correct --cflags and -lib options to point to my mysql source install), but it's working like a charm now.

Anyone figure out how to port this for Exim?

if ($vboptions['needfromemail'])
{
@mail($toemail, $subject, $message, trim($header), "-f $vboptions[webmasteremail]");
}
else
{
@mail($toemail, $subject, $message, trim($header));
}
} <-- remove

You need to take that extra code i have in bold out or else this script will give out some sort of functions error

Thanks for catching this :)

First post updated.

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....