[RELEASE: Mass Email to users awaiting activation code]

[Scott MacVicar]

This provides an option to email all users who are in the Awaiting Email Confirmation usergroup again with their activation code. I used this on my forums as some people either accidently deleted the email or the mail servers were down.

Open /admin/index.php and after
<a href="user.php?s=<?php echo$session[sessionhash]; ?>&action=referrers"> Referrals </a><br>
around line 246
and add
<a href="user.php?s=<?php echo$session[sessionhash]; ?>&action=emailactive"> Mass Email Activation Code </a><br>

save index.php and open /admin/user.php

look for
if (isset($action)==0) {
$action="modify";
}
around line 44-46
and add
// ###################### Mass Email Activation Code #######################
if ($action=="emailactive") {
$query=$DB_site->query("SELECT userid,username,email,password,joindate FROM user WHERE usergroupid='3'");
while ($user=$DB_site->fetch_array($query)) {
$userid=$user[userid];
$username=$user[username];
$password=$user[password];
$activateid=$user[joindate];
eval("\$message = \"".gettemplate("email_activateaccount",1,0)."\";");
eval("\$subject = \"".gettemplate("emailsubject_activateaccount",1,0)."\";");
echo "Email sent to:<br>";
if(mail ($user[email],$subject,$message,"From: \"$bbtitle Mailer\" <$webmasteremail>")) {
echo "$user[email] <br>";
}
}
}

re-upload /admin/index.php and /admin/user.php to your site.

The options will now be present within the control panel.

[tubedogg]

You realize this is already in the stock code, right?
yoursite.com/admin/email.php?action=start

Also, please enter your license information in your profile (http://www.vbulletin.com/forum/member.php?action=editprofile). See the link in my sig for more info. Thanks!

[Lionel]

and I believe that the following line is wrong:
$activateid=$user[joindate];

a bunch of users could not be activated. Reason: they were getting the joindate for activation id.

[amykhar]

Kevin,
PPN couldn't have posted in this forum if his license information wasn't entered in his profile.

Amy

[Shenlong]

tried installing, didnt work for me, option is already there anyway so really not a useful hack, no offense

[Liz]

Tubbdog, when I go to that link...I don't see the spot for the mass email for inactivated users. Only for COPPA. Am I looking at the wrong place? I went to the address you posted.

I also tried searching for the first line and it couldn't be found in admin/index.php

Help?? I have a lot of inactivated users. For some reason the board keeps inactivating active users so I want to be able to get this hack....

[Kars10]

@ Tubedogg, i believe PPN is a licenced Member...his hacks are one of the greatest here on VB.org!!
And i think if he is not licensed he doesn?t release a hack here.... :p

[JoshFink]

I think you need to look at the dates on the post as well as the fact he is a moderator now.. :D

Josh

[Kars10]

Ok, ok....that?s a good idea!! ;) :)

[Dark Blaze]

This certainly is something using, I will keep it in mind and install it as soon as I find time.. Thanks PPN for your great work :)

[Genjuro-Sensei]

Hello

Can i use this in my vB 3.6.3 ? Or is there anything equivalent that i can use inmy vB 3.6.3 ?

Thx

[limey]

This is something I need for vb 3.5.7. We realized a mail error on our server and over 300 members have not received email confirmations. Instead of manually going through each one is there a way to MASS email all users awaiting confirmation their passwords??

thanks.

[dc pringle]

All i do is goto Users ---> Send Email to Users ---> then just type in the message and select the Users Awaiting Email Confirmation group as the only group to receive the email