[petteyg359]

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:

userabcd     user1234      userzy09
keyabcd      key1234       key zy09

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

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:

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).