SQL Query - customavatar table

[Tommm]

Hi :)

I was looking for a SQL query to remove any avatar with either a height or width of over 100 pixels. I'm using vBulletin 3.5.4

I recently allowed all members to sample the benefits of a paid subscription and now need to remove the avatars over the standard registered user limits.

Any help would be greatly appreciated.

Thanks! :banana:

[Alan @ CIT]

DELETE FROM vb_customavatar WHERE width > 100 OR height > 100

That should work, but it will delete the custom avatars for all users that are over the limits, including the paid subscription ones if you have any, so go careful :)

Thanks,
Alan.