Scheduled Task

[Snowhog]

I would like a new Scheduled Task that deletes entries in the usergroup Users Awaiting Email Confirmation where current date minus Last Activity date is equal to or greater than five days (or user defined). That, or an SQL Query that does the same thing.

This is an SQL Query I wrote a long time ago to identify users in Users Awaiting Email Confirmation:

select username, usergroupid, from_unixtime(joindate), from_unixtime(lastvisit), posts from user where usergroupid = 3 and lastvisit <= (unix_timestamp() - (86400 * 0)) order by from_unixtime(lastvisit);

What modification to this query would be required to delete matched records?

[glennrocksvb]

Which usergroup should the users be moved to? Users must always have a usergroup assigned to them

[Snowhog]

I don’t want to move them. I want to delete them.

[glennrocksvb]

Oh you want to delete the users?

[Snowhog]

Well, never mind. I keep forgetting about AdminCP > Users > Prune / Move Users. That does what I want.

[glennrocksvb]

Yeah but you'll have to keep doing it manually.

[Mitch]

I would also like to have an auto delete for the usergroup "users awaiting email confirmation". I've been manually deleting after 4-5 days if they do not confirm. The AdminCP > Users > Prune / Move Users., won't do that from what I see.

[Snowhog]

The AdminCP > Users > Prune / Move Users., won't do that from what I see.

This is how it's done.Then check Delete and click Go.

[Mitch]

Thanks for the reply. Is this an advantage over just going into the usergroup manager and deleting them there? Neither way is automatic

[Snowhog]

Doing it this way allows you to delete all matches at once. Doing it via Usergoup Manager, you can only delete one at a time.

[Mitch]

Roger that. I'll try it out. Thanks for posting the screen shots

[Snowhog]

Still thinking on this, and I would still like to see a Scheduled Task (cron job) or a MOD (if that is doable). If it is a Schedule Task, that means writing a custom .php for it (./includes/cron/deleteusersawaitingemailconfirmation.php).



It would compare the Last Activity date to the Task/MOD execution date. If the number of days since Last Activity is equal to or greater than a definable value, the user is deleted.

Our forum; and I'm sure almost all others; get a fair number of new registrations that never confirm, and never contact a site Administrator seeking help on their registration. These are what I call 'drive-by' registrations and/or BOT registrations. In either case, I don't need or want them just sitting in the queue.

[Mitch]

I give those user 4 days to confirm, then delete. So my delete list is never that large. Never had someone bitch

[Snowhog]

And I do the same thing, but it would be nice to have an automated process that does this for you.

[glennrocksvb]

I will add this mod to my todo list.