Date: 2018-02-03 15:55
Posted By: KLaus Kügler (Lucy)
Yea I have the same thought.
And a suggestion: How about someone who is subscribed and wants to get
unsubscribed simply have him write him an other comment with the
notification-checkbox unchecked?
In other words, only notify him, if his last comment to this subject was sent
with a checked notify-me-checkbox?
The user can be informed about this behavior in his notify-e-mail.
I guess one only need to change a query for this?
Date: 2018-02-03 15:58
Posted By: KLaus Kügler (Lucy)
PS: In the form, we could label the checkbox like this: "Notify me (or keep me
notified) if new comments..."
Date: 2018-02-04 14:13
Posted By: KLaus Kügler (Lucy)
Query that works (replace line 78 in class.comment_notifier.php)
$query = 'SELECT author_email,author_name FROM '.CGFEEDBACK_TABLE_COMMENTS.' AS
A
INNER JOIN (SELECT MAX( id ) AS id
FROM '.CGFEEDBACK_TABLE_COMMENTS.' WHERE key1 = ? AND key2 = ? AND key3 = ? AND
status = ? AND author_email != ?
GROUP BY author_email) AS B ON A.id = B.id WHERE author_notify =1';