clearing unlimited rep?

I'd like to clear everyone who bought unlimited rep so they no longer have it. How would I go about doing this?

Thanks!

[lordofgun]

BTW, the reason I'm asking is because I set unlimited rep to expire one day after purchase, but it's not expiring. And I just figured out it was happening.

[CMX_CMGSCCC]

I found out why it wasnt expiring, and will have it fixed in the next release.

As far as resetting it globally for everyone, run this query.

UPDATE (TABLE_PREFIX)user SET vbp_otherflags = vbp_otherflags & -3;

-CMX

[lordofgun]

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'user SET vbp_otherflags = vbp_otherflags & -3' at line 1



NM...just forgot to clear out the prtefix.

[CMX_CMGSCCC]

Kool.

-CMX