Automatic emailing of users to their alternate address?
Could a plugin be created that would email the users alternate address, say if there had been a couple of months of no activity? This could act as a gentle reminder and to keep users interested in their account.
Re: [wickedmoon] Automatic emailing of users to their alternate address?In reply to
Hmm, you could grab a list of email addresses by doing:
SELECT dgraph_email FROM gmail_dgraph, gmail_users WHERE dgraph_userid = userid AND users_last_login < UNIX_TIMESTAMP() - 86400 * 31 * 3
May need to replace the 'gmail_' with whatever your table prefix is, and the 31 * 3 will grab people who haven't logged in in 93 days (approx 3 months ago).