[Release] Email Activate Code

[Kier]

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:

[color=blue]  $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");[/color]

and replace it with this:

[color=blue]  $users=$DB_site->query("SELECT userid,username,password,email[color=red],joindate[/color] 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);
    [color=red]
	$sendmessage=str_replace("\$userid",$user[userid],$sendmessage);
	$sendmessage=str_replace("\$activateid",$user[joindate],$sendmessage);
	$sendmessage=str_replace("\$bburl",$bburl,$sendmessage);
	[/color]

    mail($user[email],$subject,$sendmessage,"From: $from");[/color]

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:

  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]

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]

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.

[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"

[Kier]

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 )