how to delete inactive users

dose someone know how to delete inactive users??

You can delete the Inactive Users through admin area

User Admin = > Inactive Users = > Delete

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

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

Code:

---

include ('include/config.php');

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

---

i used this for 2.7

PHP Code:

---

DELETE FROM users WHERE user_account_status='inactive' 


---

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

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?

Code:

---

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

---

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

Code:

---

delete from users where user_last_login_time<1262304000

---

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

Code:

---

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

---

Thanks,

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

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

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

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

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