[HOW-TO] 1 line mySQL QUERY to delete users inactive 6 months with 0 posts
#6
you can use UNIX_TIMESTAMP() to convert the date for you, assuming you are using MySQL or another RDBMS that supports that function.

DELETE FROM mybb_users where postnum = '0' and lastvisit < UNIX_TIMESTAMP('2010-10-30 00:00:00')
Lost interest, sold my sites, will browse here once in a while. It's been fun.
Reply


Messages In This Thread
RE: [HOW-TO] 1 line mySQL QUERY to delete users inactive 6 months with 0 posts - by pavemen - 2011-04-03, 04:01 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)