How to find all users with bmp avatars

[zylstra]

How can I find all users who have an avatar that is in bmp format?

[Gio~Logist]

AdminCP -> Maintenance -> Execute SQL Query

select userid from customavatar where filename LIKE '%bmp%'


If you have a table prefix, include your prefix before "customavatar". That will bring you back results with userid's for anyone with a bmp formatted avatar.

[zylstra]

Awesome! Thanks, Gio!

[Gio~Logist]

Awesome! Thanks, Gio!

You got it :up: