The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
New user profile field ("yes/no" radio buttons). How to make everyone a "yes"?
I have created 3 new user profile field. They are simple yes/no radio buttons.
Can anyone please explain how I can force all members to become "yes"? |
#2
|
|||
|
|||
You could do this db query:
Code:
UPDATE userfield SET fieldX='yes' Where X is the actual number of the field you want to set. Obviously this is a bit dangerous since it can't be undone - make sure you get the field id right, and that the part in quotes is one of your choices (capitalize it if necessary). |
#3
|
|||
|
|||
Thanks! Seems to work OK but, when I look at my own UCP settings the "yes/no" radio buttons are both blank. Is that normal?
|
#4
|
|||
|
|||
It should show what you have selected. You created a "single selection radio button" field and entered "Yes" and "No" for the choices, right? You have to make sure that the text in the query exactly matches one of the choices (or maybe I'm wrong about how you created your field?).
|
#5
|
|||
|
|||
Quote:
However, if you then click on one of the users you see this: Therefore the database is basically correct, but the radio buttons graphically are blank. It is the same situation in UCP > settings > general settings. The radio buttons are blank. Not a big problem for me, but it would be nice if there was a solution, or at the very least could you just confirm that is expected and is not a problem. |
#6
|
||||
|
||||
"yes" is not the same as "Yes". You need to do the query to set it to exactly what you want - Yes or yes.
|
#7
|
|||
|
|||
OK, that's what I thought you meant. And I think when you view your profile it should reflect what the database says. But when you mentioned the database you said "yes", and what I see for the choice in the picture is "Yes". Maybe you just did that when writing the post, but I was saying you should make sure the capitalization matches your choices (so maybe you have to run the query again with 'Yes' instead of 'yes'?).
|
#8
|
||||
|
||||
If he's already run the query, then what he would actually need to run now is something like:
Code:
UPDATE userfield SET fieldX='Yes' where fieldX='yes' |
#9
|
|||
|
|||
Sorry, I missed that you sneaked one in there, I was replying to his post. And you're right Lynne, good point. But the result would be the same either way unless someone has selected 'No' in the mean time.
|
#10
|
|||
|
|||
Quote:
Thanks all for the help with this. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|