Well id really like to use this feature but it seems as though I have the version of MySQL that doesnt support it :(

I installed this hack and it looks real nice.

I really just wanted to have a way to email all those who are "awaiting email confirmation"

I notice it will not mail unless I select a forum. Is this the way it should work? I would think a lot of webmasters just want to email without having to select recent posts to include. I see there is a work around. Just delete that info from the message before you send it. I just don't know why it makes you select anything.

In any event...

I am at this point:

I have edited the message to be sent as follows and selected the group "awaiting email confirmation" to send it to. However, I do not see how this will help the people I am sending to since all it does is send their user name and password. Unless I am missing something, don't they still need to have the "confirmation link" to be registered? Will this hack generate that for them?

I may be missing something. If this works though, it will be awesome. I have about 800+ folks that never confirmed their registration.

Thanks!

Glen

Message as I have ready to send:

Yes-Its-Free! Community Bulletin

A while back

o Your username is: "$username"
o Your password is: "$password"
o You have $posts posts
o You registered on $joindate
o You were last active on the boards at $lastactivity

Best regards, The Yes-Its-Free!

The link to activate is generated randomly, so you couldn't send it through this script (without significant modification). However, you could tell them to visit http://yourdomain.com/register.php?action=requestemail to get another activation email.

This hack is specifically meant as an update email, so yes it is supposed to error if you haven't selected any forums. If you don't want that info, you could use the standard email function in vBulletin. (You can put their username and password in an email via that.)

No word on the error i receive?

Sorry...I missed that post. Anyway it seems that some versions of MySQL don't want to sort by SUBSTRING. I'm currently trying to figure out a way around it. For right now the workaround is to set birthdays to 0. :(

Kevin,
I hate to be a pest, but can you please put the necessary changes to member.php here?

I had to move servers, and accidentally deleted my modified members.php. commbull.php think's it's already installed because the database is configured. I just need to modify the php files.

Thank you,
Amy

Actually this is really simple. :) Just go to
http://www.epinionaddicts.com/forum/admin/commbull.php
in a browser, log in, and click "instructions" at the bottom of the first page. You will be given all the modification instructions. :)

Thank you. All fixed now. One suggestion though. The link to turn it on or off for users should also show up in the control panel when we search for a user. I get the occasional computer-phobe that asks me to turn things off for them.

Amy

I REALLY like this one!!
Thanks for your work and time!!

This morning when I went to run the community bulletin generator, it stalled when I went to run the second batch of 500 users. I never received one, but I had reports from several users that they received anywhere from 2-4 bulletins. Has anyone else had this problem??