Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2008, 05:43 PM
petteyg359 petteyg359 is offline
 
Join Date: Dec 2007
Posts: 57
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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).
Reply With Quote
  #2  
Old 02-06-2008, 11:45 PM
petteyg359 petteyg359 is offline
 
Join Date: Dec 2007
Posts: 57
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Bump this.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:31 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03616 seconds
  • Memory Usage 2,167KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete