Updating Options en masse

[karabaja3]

I suppose this will not work on 4.1.4 and 4.2.2 versions?
http://www.vbulletin.com/forum/forum/vbulletin-legacy-versions-products/legacy-vbulletin-versions/vbulletin-3-5-how-do-i-questions-and-troubleshooting/168438-updating-options-en-masse

I can not find a list of SQL commands for vB4. Can someone help?

[kh99]

Actually, most if not all of them probably will work for vb4 versions, but if you have any in particular you want to use, let us know and we can check to make sure.

[karabaja3]

Actually, most if not all of them probably will work for vb4 versions, but if you have any in particular you want to use, let us know and we can check to make sure.

Thanks for replying, kh99.

I'm currently interested in these:

DST Auto-Correct
On: UPDATE user SET options=options + 64 WHERE NOT(options & 64)
Off: UPDATE user SET options=options - 64 WHERE options & 64

DST On/Off
On: UPDATE user SET options=options + 128 WHERE NOT(options & 128)
Off: UPDATE user SET options=options - 128 WHERE options & 128

Get email for new PMs
On: UPDATE user SET options=options + 4096 WHERE NOT(options & 4096)
Off: UPDATE user SET options=options - 4096 WHERE options & 4096

Show New Private Message Notification Pop-up
On: UPDATE user SET pmpopup = 1;
Off: UPDATE user SET pmpopup = 0;

Popup on new PM
On: UPDATE user SET pmpopup=1
Off: UPDATE user SET pmpopup=0

Post Order
Newest first: UPDATE user SET options=options + 32768 WHERE NOT(options & 32768)
Oldest first: UPDATE user SET options=options - 32768 WHERE options & 32768

[kh99]

Those all look good.

[Lynne]

You can do most (all except the DST options, I think?) of those via admincp > Maintenance > Execute SQL Query and pick the option from the dropdown there.