[MOD] Dropdown options for custom database fields

[Warrior]

What would the drop down look like in the uploadform.html template?

[Warrior]

See... I want the field required, but that initial --- entry is being accepted.

[V@no]

What would the drop down look like in the uploadform.html template?

thats a basic HTML knowlege u should have

See... I want the field required, but that initial --- entry is being accepted.

that is controled by information u entered in db_field_definitions.php (read comments in that file for more info)

[Warrior]

Isn't working

Nothing I try with that db_field_definitions.php even gets put into the database

[Warrior]

Ok.. I should go ahead and take myself out behind the barn and beat myself with a 2x4... or shoot myself.

Database field had a space before its name.

...oye 

[drhtm]

great mod!

what if I want to add different language to display in the dropdown, for example, i want english and french so the options in the dropdown will conform to the language selected by the user. is this possible?

[V@no]

put your array into $lang['somename'] variable and put into your main.php files (language files)
so, the result would looks something like this:
db_field_definitions.php:

$additional_user_fields['user_gender'] = array($lang['user_gender'], "dropdown", 0, $lang['user_gender_array'], 0, 1, 5, 0);

main.php:

$lang['user_gender_array'] = array("---", "male", "female");

[drhtm]

put your array into $lang['somename'] variable and put into your main.php files (language files)
so, the result would looks something like this:
db_field_definitions.php:

$additional_user_fields['user_gender'] = array($lang['user_gender'], "dropdown", 0, $lang['user_gender_array'], 0, 1, 5, 0);

main.php:

$lang['user_gender_array'] = array("---", "male", "female");

that's beautiful.  it works as promised, however, one problem i notice is that if i edit my profile while my site is in english and I save the information, then if i switch to french, and view my profile, the english text is displayed instead of the french one.  any ideas?

[V@no]

it depence on how u save the information into the database.
I'd suggest to use multi-dimention arrays:

Code: [Select]

array(
  0 => "---",
  1 => "male",
  2 => "female"
);so in the database would save numbers (array keys) instead of values.
That way u can use trully mult-language text. (please read more about how to use multi-dim arrays in the original topic.)

[drhtm]

it depence on how u save the information into the database.
I'd suggest to use multi-dimention arrays:

Code: [Select]

array(
  0 => "---",
  1 => "male",
  2 => "female"
);so in the database would save numbers (array keys) instead of values.
That way u can use trully mult-language text. (please read more about how to use multi-dim arrays in the original topic.)

oh yes, i see.  I read the orginal topic and it makes sense now.  However, if the user selects male, then the '1' will be saved in the database.  How do I retrieve it in the members profile so it will display 'male' in english or french?  I don't think I understand that part...

[V@no]

something like:
$lang['user_gender_array'][$user_info['user_gender']]

[drhtm]

wait, now i'm confused.

Step by step.
from includes/db_field_definitions.php
I add

Code: [Select]

$additional_user_fields['user_gender'] = array($lang['user_gender'], "dropdown", 0, $lang['user_gender_array'], 1, 0, 0, 0);
In the language files (main.php)

I add in the english main.php

Code: [Select]

$lang['user_gender_array'] = array("0" => "------", "1" => "Male", "2" => "Female");
 I add in the french main.php

Code: [Select]

$lang['user_gender_array'] = array("0" => "------", "1" => "Mâle", "2" => "Femelle");
and then? in the members_profile.html template I add?????? So it will display 'female' when it's english and 'femelle' when its french...

Code: [Select]

$lang['user_gender_array'][$user_info['user_gender']] doesn't make sense to me. I'm sorry.

[V@no]

actualy in members_profile.html u should not change anything...update your pforile again and it should be ok.

[drhtm]

hmmm....

I use this in my template {user_gender} and it displays '1'...?

[Stryker]

I need make checkbox for custom database fields. Like this: <input type="checkbox" name="checkbox" value="checkbox">

Please, help me. Thanks