[waynne]

I have a fix and hack for this to be applied to functions_remindermail.php

This fixes the lack of userid in the unsubscribe email link and log files...
Find

$sql = "SELECT username, email, ".
           "usergroupid, ".

Replace with

$sql = "SELECT username, email, userid, ".
           "usergroupid, ".

The following restricts reminder emails to members who have been active in the last year. This is helpful to reduce the risk of spamming old defunct addresses.

Find (3 instances)

 "AND options & 16 ".  
           "AND rmoptout = 0 ";

Replace with

 "AND options & 16 ". 
		   "AND TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastactivity), FROM_UNIXTIME(UNIX_TIMESTAMP())) <= '365'". 
           "AND rmoptout = 0 ";

(Caution :- You must add this code in all 3 places or you'll end up repeatedly emailing the same user.)