Bulk Change to User Avatar Overide

[clayt101]

Is there a way to change "Keep Custom Avatar" from "No" to "Yes" for all of my members instead of having to do it individually?

[clayt101]

I got this from the official site, and it worked....

These queries should work (if you have a table prefix, you will need to add that in):

*** Set 'Keep Custom Avatars' Admin override option

Yes: UPDATE user SET adminoptions=adminoptions + 1 WHERE NOT(adminoptions & 1);

No: UPDATE user SET adminoptions=adminoptions + 1 WHERE adminoptions & 1;

I would suggest you run the query as a test first on your test site to verify it works before you do so on your live site. And, as always, before running any query on your database, please do a backup!