how to delete inactive users

[RAMMSTEIN]

dose someone know 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

[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