[HOW-TO] 1 line mySQL QUERY to delete users inactive 6 months with 0 posts

[aglioeolio]

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



...

[*~Kamran Saleem~*]

Nice Tutorial thanks great man

[jameel225]

This user has been denied support.

can u provide for me command for last active..one year..

[Yaldaram]

Run this;

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

[themem]

Nice tutorials, thanks

[pavemen]

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')

[Sajuuk]

This tutorial is redundant for MyBB 1.6 as the new version supports User Pruning.

[Lo.]

This tutorial is redundant for MyBB 1.6 as the new version supports User Pruning.

So you had to go and find it just to state it?

Some people, such as myself, prefer queries then backend edits.

[Scoutie44]

This tutorial is redundant for MyBB 1.6 as the new version supports User Pruning.

Some people, such as myself, prefer queries then backend edits.

>>as the new version supports User Pruning.

wat

[Sajuuk]

So you had to go and find it just to state it?

No, someone bumped this 2 year old thread, that's why I stated it...

@Scoutie: Yep.