[HOW-TO] 1 line mySQL QUERY to delete users inactive 6 months with 0 posts
#1
Lightbulb 
This is an easy SQL Query that you can run in phpMyAdmin

DELETE FROM mybb_users where postnum = '0' and lastvisit < '1229691992';

This query delete users from database with last visit in Dec.14 2008 or later and 0 posts...

Use this form to your needs: http://www.unixtimestamp.com/index.php



...
Reply


Messages In This Thread
[HOW-TO] 1 line mySQL QUERY to delete users inactive 6 months with 0 posts - by aglioeolio - 2009-05-15, 10:57 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)