query, how to set all email addresses.....

[SkuZZy]

I want to set the "Allow emails from administrators" option to YES for all users. What is the mysql query I run to do this again? I searched the forums for about a fricken hour and the new search on vb3 sucks, cause I can't find anything.

Thanks,
SkuZZy

[Jake Bunce]

UPDATE user SET adminemail=1

backup first!

[SkuZZy]

thanks jake, you da man!