dose someone know how to delete inactive users??
Printable View
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:
Thanks,Code:$sql = "DELETE FROM `users` WHERE `user_last_login_time`<'" . strtotime("last Year") . "'";
mysql_query($sql);
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