Update Avatar Post Count Check

[Sylvus]

v2.3.4.

I have changed the option for users to be able to use an avatar under the vB options and put it BACK to 0. It was set at 201 posts.

The problem it that the 400+ avatars I have already imported into the database are all set up for an X number of posts still.

What command can I run in the database to set each avatar minimum post # back to 0, without having to re-add all of the avatars?

Thanks.

[Steve Machol]

I believe this query will work but backup your database just in case:

UPDATE avatar SET minimumposts=0;

[Sylvus]

Thank-you. Worked like a charm.