Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 22 Dec 2014, 15:07
karabaja3's Avatar
karabaja3 karabaja3 is offline
 
Join Date: Jan 2008
Updating Options en masse

I suppose this will not work on 4.1.4 and 4.2.2 versions?
http://www.vbulletin.com/forum/forum...tions-en-masse

I can not find a list of SQL commands for vB4. Can someone help?
Reply With Quote
  #2  
Old 22 Dec 2014, 15:14
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
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.
Reply With Quote
  #3  
Old 22 Dec 2014, 16:36
karabaja3's Avatar
karabaja3 karabaja3 is offline
 
Join Date: Jan 2008
Originally Posted by kh99 View Post
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
Reply With Quote
  #4  
Old 22 Dec 2014, 18:16
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
Those all look good.
Reply With Quote
  #5  
Old 23 Dec 2014, 00:43
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: 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.
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 11:39.

Layout Options | Width: Wide Color: