SQL Query - customavatar table
 

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:

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.