Email Activate Code

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]

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]

I'll make sure it's in 2.1... or something nicer.

[RobAC]

Kier,

Thanks, this will definitely come in handy.

[Joshs]

What exactly does this do?

[SteveK]

You may also want to add this to remind you of the new variables that are available.

find this:

PHP Code:

  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:

PHP Code:

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


SteveK

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.

Nobody any idea?

[Raptor]

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]

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.