CMS MADE SIMPLE FORGE

Newsletter Made Simple

 
Back Back to List

[#9965] Purge old unconfirmed email addresses

avatar
Created By: Jurrie Overgoor (jurrie)
Date Submitted: 2014-04-23 05:52

Assigned To:
Resolution: Fixed
State: Open
Summary:
Purge old unconfirmed email addresses
Detailed Description:
Sometimes I get users / bots that register an email address and never confirm
it. I would like to purge such addresses after some time. It seems to me the
CGJobMgr module could easily do this using a query like:

"DELETE FROM ".NMS_USERS_TABLE." WHERE confirmed = 0 AND dateadded <
date_sub(now(), interval 8 hour)"

This would delete all unconfirmed email addresses that are older than eight
hours.

As a bonus, the 'eight hours' could be made configurable.

History

Comments
avatar 
Date: 2016-06-23 16:18
Posted By: Robert Campbell (calguy1000)

Done from another module, soon to be released
Updates

Updated: 2016-06-23 16:18
resolution_id: 5 => 7

Updated: 2014-04-23 08:23
description: Sometimes I get users / bots that register an email address and never confirm it. I would like to purge such addresses after some time. It seems to me the CGJobMgr module could easily do this using a query like: "DELETE FROM ".NMS_JOBS_TABLE." WHERE co => Sometimes I get users / bots that register an email address and never confirm it. I would like to purge such addresses after some time. It seems to me the CGJobMgr module could easily do this using a query like: "DELETE FROM ".NMS_USERS_TABLE." WHERE c
resolution_id: => 5