how to delete inactive users

[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

[vshare]

To delete users who have not logged in since last year, add this code into cron.php:

$sql = "DELETE FROM `users` WHERE `user_last_login_time`<'" . strtotime("last Year") . "'";
mysql_query($sql);

Thanks,

[frak]

i d like to send out a friendly reminder to users have not logged since a while(+months) similar to some forum scripts...any help? thanks

[WhyMan]

I've tried all of the above on a vShare 2.8.1 install and no joy? Is there something that will?

[WhyMan]

Hey there, I've tried all of the above in order to bulk remove inactive users and no joy.. is there something that will work with vShare 2.8.1? Thanks

[WhyMan]

Hey there, I've tried all of the above in order to bulk remove inactive users and no joy.. is there something that will work with vShare 2.8.1? Thanks

[WhyMan]

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