Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 17 Apr 2011, 13:48
smooth-c smooth-c is offline
 
Join Date: Jan 2008
SQL Query for Profile Field

Okay. I have a profile field to allow members to chose what header they use on my forum. The option is titled 'Show legacy header' - The default option is No. I've recently changed my branding so I want to force the original header to everyone, even those that have changed their header to the legacy header by chosing 'Yes'

What SQL query could I use to change this for everyone? To change their option set to 'No' ?

Thank you!

Greg
Reply With Quote
  #2  
Old 17 Apr 2011, 14:09
YankForum's Avatar
YankForum YankForum is offline
 
Join Date: Mar 2010
Real name: alij
u cant get a aclear answer because nobody knows table's name and attribute but it should be similar to ;
update table xxxx set xxxx = 'No' ; // it does it for all and u may lose all ur saved data
__________________
No more signature for me , Tnx!
Reply With Quote
  #3  
Old 17 Apr 2011, 14:30
smooth-c smooth-c is offline
 
Join Date: Jan 2008
I'm not really sure how I could be more clear. The profile field I wish to change is numbered 21. I'm sure I've seen it somewhere before? I wasn't aware there'd be a table that'd need changing.

Thanks though.
Reply With Quote
  #4  
Old 17 Apr 2011, 17:50
YankForum's Avatar
YankForum YankForum is offline
 
Join Date: Mar 2010
Real name: alij

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

replace first xxxx with table's name and 2nd xxxx with fields title , More Info
__________________
No more signature for me , Tnx!
Reply With Quote
  #5  
Old 17 Apr 2011, 17:51
smooth-c smooth-c is offline
 
Join Date: Jan 2008
How do I find out which table to change? Thank you!
Reply With Quote
  #6  
Old 17 Apr 2011, 18:01
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
Table should be userfield. If you have a prefix, then it would be prefixuserfield.

So, something like

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

As always, test this on your test site first and do a backup of your database before running ANY query.
__________________
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 00:54.

Layout Options | Width: Wide Color: