Question Default Settings for all users

[iraqiboy90]

Hello

I've noticed quickly that when I enabled the sound through the admincp, the sound didnt get enabled pr user. So I had to go into the usercp in order to activate it.

Is there an option to "set" the option on all users at the same time? If not, and I assume this would have to be done through phpmyadmin, how would I?

 

[Fillip H.]

Enable shout sounds for all users

UPDATE user SET options = options + 16384 WHERE NOT (options & 16384)

Enable invite sounds for all users

UPDATE user SET options = options + 32768 WHERE NOT (options & 32768)

Enable PM sounds for all users

UPDATE user SET options = options + 65536 WHERE NOT (options & 65536)