MyBB Community Forums

Hey all! I've been looking around these forums but couldn't find any info on this, so I thought I'd ask here.

Is there a plugin out there that allows admins to see:

1. How many avatars are being used?
2. Who is using these avatars?
3. Are there orphan avatars?

It would be great if all this could be seen from within the Admin CP. And of course admins should be able to delete avatars if they see fit and all.

Kinda like an Avatar CP in the Admin CP. So, is there a plugin out there that does this?

Interesting idea.

Here's a solution, not using a modification, so not from the AdminCP:

metalappie Wrote:1. How many avatars are being used?

Run the query:

SELECT COUNT(*) AS num_users_with_avatars FROM mybb_users WHERE avatar<>''

This will show you the number of users using an avatar. Note that this includes gallery and linked avatars, not just uploaded ones.

metalappie Wrote:2. Who is using these avatars?

?
You can see the avatar a particular user is using by editing them in the AdminCP.

metalappie Wrote:3. Are there orphan avatars?

It shouldn't occur, since when a user changes an avatar, any uploaded avatar is deleted.
Even if it's done (haven't checked, but I'm pretty sure editing a user's avatar from the AdminCP doesn't delete their avatar), it's not a big issue since a new uploaded avatar will override the old one.

Ah right. Thanks for the info, Zinga Burga