vb.org Archive - Multiple selection profile field using MySQL data

I need a user-selectable profile field via a list of names grabbed from MySQL. I have a seperate database containing information for characters in a game. This info is retrieved from a script that reads 2-6 other profile fields (only the first two are required). Each of these user/key sets can reference up to three characters. I have another script that counts the character in the set, and grabs the data for each individual. Now I need another set of profile fields (up to three), in which the user can select which character (if there are multiple characters) should be used for the user/key set.

Say a user has all the user/key fields filled in (these are all for a single forum user). I then have:

Code:

userabcd     user1234      userzy09

keyabcd      key1234       key zy09

Then say that every one of these account has three characters:

Code:

Fooey        Alpha         123

Booey        Beta          456

Chooey       Gamma         789

I then need to have three more profile fields (or two or one, if they only have two or one user/key combos filled in), that display the list of character for the user/key combo, and allow a selection of one character per user/key combo via three sets of radio buttons. These don't necessarily have to be in the user CP, if I have to just make three hidden uneditable profile fields and a seperate page with a cutom form is fine. If that is the case, how does one code a form that allows alteration of profile fields? Do I just need to change $vbulletin->userinfo or do I need to run a MySQL UPDATE?

Preferred way would be to somehow in the User CP have underneath the user/key fields add a box such as:

Code:

Account 1 Characters:

[0] Fooey

[0] Booey

[0] Chooey

Account 2 Characters:

[1] Alpha

[1] Beta

[1] Gamma

Account 3 Characters:

[2] 123

[2] 456

[2] 789

where [0], [1], and [2] are sets of radio buttons.

Character names are retrieved from MySQL with 'SELECT charactername FROM userinfo WHERE apiuser = "'.$vbulletin->userinfo['field6'].'" ORDER BY charactername' (and field10 and field11 for the other two sets. The database containing userinfo is eveit (same host as the vB database).

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02059 seconds Memory Usage 1,709KB 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 (3)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (2)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: