Gossamer Forum
Home : Products : Gossamer Mail : Development, Plugins and Globals :

Automatic emailing of users to their alternate address?

Quote Reply
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.

Jason
Quote Reply
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).

Cheers,

Alex
--
Gossamer Threads Inc.