PDA

View Full Version : Email Activate Code


Kier
25 Apr 2001, 23:10
This tiny hack is in response to a request from Sharg - I would put it into the 2.0 code, but understandably, John doesn't want to make any further modifications to the code unless they are absolutely necessary.

It allows you to use the admin email function to send an email which will remind users in the 'Users awaiting bla bla bla' group of the link for their activation code.

In admin/email.php, find this code: $users=$DB_site->query("SELECT userid,username,password,email FROM user WHERE $condition AND userid>='$startat' AND userid<'$finishat' AND adminemail=1 ORDER BY userid DESC");
while ($user=$DB_site->fetch_array($users)) {

$userid=$user[userid];
$sendmessage=$message;
$sendmessage=str_replace("\$email",$user[email],$sendmessage);
$sendmessage=str_replace("\$username",$user[username],$sendmessage);
$sendmessage=str_replace("\$password",$user[password],$sendmessage);

mail($user[email],$subject,$sendmessage,"From: $from"); and replace it with this: $users=$DB_site->query("SELECT userid,username,password,email,joindate FROM user WHERE $condition AND userid>='$startat' AND userid<'$finishat' AND adminemail=1 ORDER BY userid DESC");
while ($user=$DB_site->fetch_array($users)) {

$userid=$user[userid];
$sendmessage=$message;
$sendmessage=str_replace("\$email",$user[email],$sendmessage);
$sendmessage=str_replace("\$username",$user[username],$sendmessage);
$sendmessage=str_replace("\$password",$user[password],$sendmessage);

$sendmessage=str_replace("\$userid",$user[userid],$sendmessage);
$sendmessage=str_replace("\$activateid",$user[joindate],$sendmessage);
$sendmessage=str_replace("\$bburl",$bburl,$sendmessage);


mail($user[email],$subject,$sendmessage,"From: $from"); The variables $userid and $activateid are now available for you in the mail message, allowing you to construct the link to the activation page like this:

$bburl/register.php?a=act&u=$userid&i=$activateid

Sharg
26 Apr 2001, 00:43
Yeeepiiiii !!!!
Thanks Kier !! Thanks alot !
I got 200 users in the user waiting group i'll send them the activation code now so i'm sure I will have more increased real subscribtion than ever before !!

(So much easier for them just to click on a link to activate their account on a reminder Email) .

Well, I hope this is going to make it in the official next release.

Kier
26 Apr 2001, 01:32
I'll make sure it's in 2.1... or something nicer. ;)

RobAC
26 Apr 2001, 02:03
Kier,

Thanks, this will definitely come in handy.

Joshs
28 Apr 2001, 19:27
What exactly does this do?

SteveK
31 May 2001, 18:55
You may also want to add this to remind you of the new variables that are available.

find this:
maketextareacode("Message:<p><font size='1'>In the message, you may use \$username, \$password and \$email.</font></p>","message","",10,40);

and replace with this:
maketextareacode("Message:<p><font size='1'>In the message, you may use \$userid, \$activateid, \$username, \$password and \$email.</font></p>","message","",10,40);

SteveK

Black Tiger
02 Jun 2001, 16:06
I've got a little problem with this one in VB2.0 final.

I made changes to email.php like Kier said.
Now I use the option "email users" in the control panel.

I write the email, then I've got to select who to send to and I select "users awaiting email confirmation" (we've got 82 of them).

After submitting I see:
userid:
done

But no mail is send, even not when I select the option to mail users in this usergroup which post is <1 nothing is send.
In vb1.16 if I selected only a usergroup, an email was send to the entire group.

1.) Am I doing something wrong or forgetting something?
2.) What does the "joindate" added in the first line exactly do?
Please help.

p.s. It seems it only works if I send an email to the usergroup "administrators", then I see the userid's, on any other group I see no id's flying over my screen.

Black Tiger
04 Jun 2001, 01:42
Nobody any idea?

Raptor
25 Jun 2001, 20:53
this works fantastic on vb 2.01

we have over 3970 members on the awaiting confirmation list because our sendmail function corrupted and they've just been sitting there doing nothing

this should sort that out :)

thanks again

Byron
24 Jul 2001, 19:46
Thank you so much Kier.

I have 265 members waiting for confirmation.
Can't imagine doing it one by one.

Thanks a lot.

Hope this feature will be in the next vb version.

Byron
24 Jul 2001, 19:53
Found a something/bug

I use the original template which contains $contactaddress and $bbtitle in my mail to members but the two variable didn't work

"If you are still having problems signing up please contact a member of our support staff at $contactaddress

Thanks very much,
$bbtitle team"

Kier
28 Jul 2001, 00:54
Originally posted by Byron
Found a something/bug

I use the original template which contains $contactaddress and $bbtitle in my mail to members but the two variable didn't work

"If you are still having problems signing up please contact a member of our support staff at $contactaddress

Thanks very much,
$bbtitle team" I'm not sure where you've got $bbtitle and $contactaddress from - the only variables available are $email, $password, $username, $userid,$activateid and $bburl...

In any case, this hack is now included by default in vB 2.0.2 (along with $bbtitle ;))