vb.org Archive - Profile fields

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Profile fields (https://vborg.vbsupport.ru/showthread.php?t=256708)

ProFifaLeagues

01-07-2011 02:48 PM

Profile fields

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

01-07-2011 04:00 PM

You'll have to go into the database and do a query to do this.

ProFifaLeagues

01-07-2011 04:28 PM

Thanks Lynne any ideas what the query i would need to run would be?

Lynne

01-07-2011 04:34 PM

Something to do with the userfield table. Something *like*

Code:

UPDATE userfield

SET fieldx=yyy 

WHERE fieldx=''

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

01-07-2011 04:35 PM

Ok thanks for the advise Lynne i will make sure to do so!

All times are GMT. The time now is 02:39 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01214 seconds Memory Usage 1,710KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: