So you want a drop down field right?
Alrighty.
Part 1
First of all we will take care of the modifyprofile template.
In there, add something like this:
Code:
<tr>
<td bgcolor="{secondaltcolor}"><normalfont><b>Are you a male of a female?</b></normalfont></td>
<td bgcolor="{secondaltcolor}"><smallfont>
<select name="sex">
<option value="dunno" $sexsel[dunno]>I don't know yet.</option>
<option value="male" $sexsel[male]>Male.</option>
<option value="female" $sexsel[female]>Female.</option>
</select></smallfont></td>
</tr>
(But of course change {secondaltcolor} to {firstaltcolor}, depends on where you put this, what's before, what's after, etc.)
See the $sexsel[xxx] variable I put in each option?
This is so that when a use comes back to the profile page, what he selected before will show up selected on this page. So he won't have to change this value every time he changes his profile.
The $sexsel[xxx] (sex+selected) is set in the member.php page.
Where?
Somewhere in this block:
PHP Code:
// ############################### start modify profile ###############################
if ($action=="editprofile") {
...
...
...
eval("dooutput(\"".gettemplate("modifyprofile")."\");");
}
So we're gonna add this:
PHP Code:
if ($bbuserinfo[sex]) {
$sexsel[$bbuserinfo[sex]]="selected";
} else {
$sexsel[dunno]="selected";
}
right after this:
PHP Code:
if ($allowsmilies) {
$smiliesonoff=$ontext;
} else {
$smiliesonoff=$offtext;
}
(the IF is just in case the field is empty when the user changes his profile. Not really necessary, but we all like things organized()
What will this do?
$bbuserinfo[sex] is what the user currently has in his profile for the sex field.
So, if he has selected 'male' before, $sexsel[male] will contain the word "selected".
So when we put this in the <option> tag, it will cause that and only that option to be selected.
Note that the $sexsel[xxx] MUST match the value="xxx", or it just won't work.
Ok, so we took care of the end user stuff.
But how are we gonna insert this info into the database?
Part 2
So first of all, we need to create the field for that, in the user table.
For this example, we'll run this query:
Code:
ALTER TABLE user ADD sex VARCHAR(8) not null
I went for 8 since in this case the max value that can be is 'female' (6).
So, we need to add something to the query that updates the user profile, right?
This is the query, as it is now:
Code:
$DB_site->query("UPDATE user SET birthday='".addslashes($birthday)."',signature='".addslashes($signature)."',customtitle='$customtitle',usertitle='".addslashes($customtext)."',email='".addslashes(htmlspecialchars($email))."',parentemail='".addslashes(htmlspecialchars($parentemail))."',coppauser='$coppauser',homepage='".addslashes(htmlspecialchars($homepage))."',icq='".addslashes(htmlspecialchars($icq))."',aim='".addslashes(htmlspecialchars($aim))."',yahoo='".addslashes(htmlspecialchars($yahoo))."',usergroupid='$bbuserinfo[usergroupid]' WHERE userid='$bbuserinfo[userid]'");
So let's add this to the query:
Code:
$DB_site->query("UPDATE user SET birthday='".addslashes($birthday)."',signature='".addslashes($signature)."',customtitle='$customtitle',usertitle='".addslashes($customtext)."',email='".addslashes(htmlspecialchars($email))."',parentemail='".addslashes(htmlspecialchars($parentemail))."',coppauser='$coppauser',homepage='".addslashes(htmlspecialchars($homepage))."',icq='".addslashes(htmlspecialchars($icq))."',aim='".addslashes(htmlspecialchars($aim))."',yahoo='".addslashes(htmlspecialchars($yahoo))."',usergroupid='$bbuserinfo[usergroupid]',sex='".addslashes($sex)."' WHERE userid='$bbuserinfo[userid]'");
This will insert $sex ('dunno', 'male' or 'female') into the sex field in the user table.
Part 3
Now, let's take care of the registration process.
This is optional. You need to decide whether you want to include this when people register, or not. Your choice.
If you do want this, tell me and I'll explain this as well.
I hope you understand everything. If you still got questions, just ask.
(sorry about the width of this. Long queries, you know :P)
More Information