Quote:
Originally Posted by tamarian
Correct. It's best to not have it accessable through a browser.
|
Script works brilliantly. Have added the following sql updates which might be useful to others :
Find :
Code:
my $qry3 = db_execute("UPDATE subscribethread set emailupdate='$downgrade' where userid='$varname1'");
After, add :
Code:
my $qry4 = db_execute("UPDATE subscribeforum set emailupdate='$downgrade' where userid='$varname1'");
my $qry5 = db_execute("UPDATE user set usergroupid=19 where userid='$varname1' and usergroupid=2");
qry4 cleans up any subscribed forums (instead of just subscribed threads)
qry5 moves any user who's e-mails bounce that is currently in usergroup 2 into usergroup 19.
Now I'm off to play around with Perl, and perhaps try to do some automatic e-mail processing routines (such as e-mail messages triggering forum posts! ) - What fun.