members with 0 posts

[geniuscrew]

I don't exactly know if it's been done before but please excuse me if it has :D

You know if members have 0 posts, it doesn't necessarily mean they haven't posted at all, since you can disable post contribution in certain forums.

So i was thinking if you could somehow add an option to the admin panel, in the find user bit for users who have never posted - and then give the option to delete them :)


Thanks

[geniuscrew]

*bump*

[007]

Well I don't know how this would be coded, but I don't think you could do it for PAST users tha have never posted, but the idea I have would work for anyone in the future who doesn't post.

Idea:

- Post counts add normally in applicable forums, anything more than 1 means the user has posted and will not show up when searching for "non-posting" users.

- Post counts in forums that do not add to post counts will not be added to the postcount, BUT, they will be added to a new table that is created. This will not be seen publically in any way, but is simply for searching purposes.

- Then, any user who has both 0 postcount and 0 noncountingpostcount (long word lol) will be considdered a "has never posted" user.

It is a good idea. It wouldn't be terribly hard to do, but I don't really have time to look into it now. That's just my theory on how it could work.

:)

[filburt1]

FWIW this is very easy to code (at least the idea in the first post) but be warned that many, many users who sign up and don't post often sign up to make the forum more popular and to have their own preferences. It doesn't mean that they forgot about your forum. A better idea would be to prune users who haven't posted and weren't online at all for the last six months.

[geniuscrew]

Got it - but when I prune user who have 0 posts, will that delete members based on their post count, or based on if they've ever posted. That's what I want ideally

[filburt1]

It's extraordinarily simple to find out if somebody posted or not:

SELECT IF(COUNT(postid) > 0, 1, 0) FROM post WHERE userid = userid;

The IF is to immediately stop the query if even one post was made. It returns 1 (true) if they made a post, 0 (false) if they didn't.

[geniuscrew]

Thanks! Will try it out