thanks

working
it will help my users come back to my forum

Can anyone tell me what type of mail services or servers you are using? I'm working on a script to automate processing bounced mail. So far I've got information on IMAP and a little on the POP protocols... Any others would be nice. Anyone interested in helping with beta testing please shoot me a PM. I'd like to have a few that would be using each protocol.

Thanks! :)

Occasionally I get errors. Is it maybe caused by user names that include the '@' sign?

Database error in vBulletin 4.0.2:

Invalid SQL:
INSERT INTO inactiveuserlog (username,userid,dateline,validemail,email)
VALUES ('Bill 'C'','8323','1270189848','1','someemail@sky.com');

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'C'','8323','1270189848','1','someemail@sky.com')' at line 2
Error Number : 1064
Request Date : Friday, April 2nd 2010 @ 02:30:48 AM
Error Date : Friday, April 2nd 2010 @ 02:30:48 AM
Script : http://www.
Referrer : http://www.
Username : Unregistered
Classname : vB_Database

Looks like the extra quotes in the username are causing it. There are 2 places to change that should fix it. To fix this manually, do the following:

1. Open the reminderemail.php file in the {forumroot}/includes/cron folder
2. Scroll down and insert the following code after 361, just before the line where $sql = "INSERT INTO " is getting set:

$username = addslashes($username);

3. Save and close the file.

4. Open the inactivitylog.php file in your admincp folder
5. Scroll down to line 133 and replace it with the following line of code.

$username = stripslashes($log['username']);


That should do it. I'll upload a new zip with this fix this weekend.

Ok thanks! Will that also fix the error if an apostrophe is in the username like this:
Norman O'Neill

That username generated an error as well.

Btw if I remove your plugin and add the new version, will it resend all the inactive email reminders?

Yes, that will escape (add slashes) to special characters such as the apostrophe, single and double quotes, etc that may be in the username.
Stripslash will remove them.

No, all you will need to do is install it as usual, but make sure you use the overwrite so that any new features will be applied. I am doing some clean up in the code and back end such as renaming some of the table fields but the data won't be touched or deleted with exception to the email phrase templates. If you or anyone has customized the email templates that get sent out, I strongly recommend that you keep a copy of them because those will be overwritten. That's just the way the install works.

In the next release, I'm working on
1. Both automated (cron job) and manual processing (clicking on an embedded link) of bounced reminders.
2. Auto PM the user that bounces emails to request that they update their email address.
3. The ability to have the bouncing user moved to a usergroup of the admin's choice
4. The ability to send a reminder to users if they have not posted in x number of days.

I think thats about it unless anyone has any features they would like added.

EDIT: 4/7/2010 - I reread your post and I want to clarify that if you completely uninstall the mod.. yes, you will loose all previous data. If you are upgrading to a new version, just install over top of the current version using vbulletin's overwrite feature. Please let me know if you have additional questions. :)

Thanks for the detailed explanation! I have one more question. How do I edit the email templates myself? Every time I click them they open in a new window, but I don't see an edit link.

As for new version, please add the 'reset pwd' link to one of the emails. I believe the text version doesn't have it.