Prunning Members

[merk_aus]

Okay to cut a long story short.

I acquired a website recently and merged their member database with our current one, this gave us over 13 000 members however on looking at things it seems many of those members almost 10 000 were just one time registrants who haven't come back, bots or spammers.

I have attempted to mass prune/move members through the admincp to delete members with a post count of "zero" however it continues to time out and doesn't get done.

I was wondering if there was an sql query I could run that would go through and remove every member with a post count of zero?

[borbole]

Originally Posted by merk_aus

Okay to cut a long story short.

I acquired a website recently and merged their member database with our current one, this gave us over 13 000 members however on looking at things it seems many of those members almost 10 000 were just one time registrants who haven't come back, bots or spammers.

I have attempted to mass prune/move members through the admincp to delete members with a post count of "zero" however it continues to time out and doesn't get done.

I was wondering if there was an sql query I could run that would go through and remove every member with a post count of zero?

Run this query at the SQL box at the phpmyadmin in the CP of your host.

DELETE FROM user WHERE posts = 0;

If your db tables have a prefix, don''t forget to include it at the query as well. Hope it helps.