how to delete inactive users

[buyscripts]

You can delete the Inactive Users through admin area

User Admin = > Inactive Users = > Delete

[RAMMSTEIN]

yes you can do that there deleting on by one but if someone have more than 7000 inactive users :(

[carefree2]

Save as user_delete.php, run once in browser. Set cron to run this once a year

include ('include/config.php');

$sql = mysql_query("DELETE FROM signup WHERE account_status='inactive'") or die(mysql_error());

[RAMMSTEIN]

i used this for 2.7

DELETE FROM users WHERE user_account_status='inactive' 

[bhanuprasad1981]

this should be a default option in admin control , i just checked my site there were 6000+ inactive users :(

[grynmoors]

Need same for inactive videos.

I would consider people who have not logged in for over a year as an inactive user. How do we delete people whos last log in was, say...sometime in 2009 or older?

DELETE FROM users WHERE user_last_login_time='???????????'

[bplex]

To delete users who have not logged in since 2009, you would use:

delete from users where user_last_login_time<1262304000

[WhyMan]

Is there something that will work with 2.8.1? I've tried all of the above