MyBB Community Forums

Hello,

How can I prune members without activated account and without any post?
Is this possible?


Regards
Jarek

I know it's either a default feature or a plugin.

OK I found this, and it's work fine.
DELETE FROM mybb_users WHERE usergroup = '5';

But what with 0 post members?

Well if your ok you use phpmyadmin again.

DELETE FROM 'mybb_users' WHERE 'posts' = '0';

However that's assuming posts is the correct name for the field.(I don't have access to a mybb database right now)

There is no posts fileld, only postnum - it this am I looking for?

What about the Prune Members (2.0) plugin by Jesse Labrocca ?

It's says that don work with mybb 1.4.

It says it does work with 1.4.
http://www.mybbcentral.com/thread-1710.h...ight=prune

(2010-01-21, 09:36 PM)JarekMk Wrote: [ -> ]There is no posts fileld, only postnum - it this am I looking for?

I would imagine so.

And, see I knew there was a plugn. Didn't know labrocca was the one who released it though so didn't check mybbcentral.

(2010-01-22, 12:11 AM)NetSage Wrote: [ -> ]

(2010-01-21, 09:36 PM)JarekMk Wrote: [ -> ]There is no posts fileld, only postnum - it this am I looking for?

I would imagine so.

And, see I knew there was a plugn. Didn't know labrocca was the one who released it though so didn't check mybbcentral.

Yeah i was just going through the plugin section and came across it. then i saw this thread and thought i know that plugin lool.