PDA

View Full Version : Profile fields


ProFifaLeagues
07 Jan 2011, 16:48
When adding new profile fields and in this instance having 3 different options to choose from,Ive set a default option to be checked but how can i update so that all users have this option updated as its only adding the default option as checked on the new sign ups we have rather then members in the database already!

Lynne
07 Jan 2011, 18:00
You'll have to go into the database and do a query to do this.

ProFifaLeagues
07 Jan 2011, 18:28
Thanks Lynne any ideas what the query i would need to run would be?

Lynne
07 Jan 2011, 18:34
Something to do with the userfield table. Something *like*



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

I would backup the database first whenever doing something to the database. I would also do this on your test site first to make sure you have the query correct.

I have NOT run this query and have no idea if it is correct! Use at your own risk.

ProFifaLeagues
07 Jan 2011, 18:35
Ok thanks for the advise Lynne i will make sure to do so!