1 Topic by hcgtv

  • hcgtv
  • hcgtv
  • Senior Member
  • Offline
  • From: Charlotte, NC
  • Registered: 2004-06-25
  • Posts: 1,991

Topic: Batch remove users who haven't acknowledged registration email

Looked in Punres.org but didn't find a plugin.

What I'd like to do is remove users that have signed up and haven't replied to the registration email.

Like get rid of anybody who has signed up and hasn't replied in the last 30 days.

PHPCrossRef . TXP Make . TXP Themes . TXP Tags . TXP Planet . We Love TXP

hcgtv's Website

2 Reply by XML

  • XML
  • Junior Member
  • Offline
  • From: Viet nam
  • Registered: 2006-04-17
  • Posts: 3

Re: Batch remove users who haven't acknowledged registration email

use the Database Manager Plugins - in the SQL textbox run this querry whenever you want:

sql:  delete from #__users where group_id=32000 and now()-registered> 2592000

need a look at the second expression