ok ive done it i ran query on my test forum insted of main
it works thanx
when i edit profile and click the gender i want and save changes it resets to no gender chose
anyone no whats wrong?
i cannot find
<input type="hidden" name="oldbirthday" value="$bbuserinfo[birthday]" />
</td>
</tr>
</table>
</fieldset>
in modify templates my code looks like this see if you can spot it
<if condition="$bbuserinfo['coppauser']">
<!-- coppa text -->
<form action="register.php" method="post">
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="do" value="coppaform" />
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat">$vbphrase[coppa_information]</td>
</tr>
<tr>
<td class="panelsurround" align="center">
<div class="panel">
<div style="width:$stylevar[formwidth_usercp]" align="$stylevar[left]">
<p class="smallfont">
<phrase 1="$vboptions[contactuslink]">$vbphrase[make_changes_parent_notified]</phrase>
</p>
<p class="smallfont">
$vbphrase[print_new_permissions_form]
</p>
<input type="submit" class="button" style="font-weight:normal" value="$vbphrase[display_permissions_form]" />
</div>
</div>
</td>
</tr>
</table>
</form>
<br />
<!-- end coppa text -->
</if>
<form action="profile.php" method="post" id="profileform">
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="do" value="updateprofile" />
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="tcat">$vbphrase[edit_profile]<span class="normal">: $bbuserinfo[username]</span></td>
</tr>
<tr>
<td class="thead">$vbphrase[registration_required_information]</td>
</tr>
<tr>
<td class="panelsurround" align="center">
<div class="panel">
<div style="width:$stylevar[formwidth_usercp]" align="$stylevar[left]">
<fieldset class="fieldset">
<legend>$vbphrase[email_and_password]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td>$vbphrase[click_button_below_edit_email]</td>
</tr>
<tr>
<td>
<!-- don't remove -->
<input type="image" src="$vboptions[cleargifurl]" width="1" height="1" />
<!-- / don't remove -->
<input type="submit" class="button" style="font-weight:normal" value="$vbphrase[edit_email_and_password]" name="gotopassword" />
</td>
</tr>
</table>
</fieldset>
<if condition="$bbuserinfo['coppauser']">
<fieldset class="fieldset">
<legend><label for="tb_parentemail">$vbphrase[parent_guardian_email]</label></legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td>$vbphrase[if_under_13_provide_parent]</td>
</tr>
<tr>
<td>
$vbphrase[parent_guardian_email]:<br />
<input type="text" class="bginput" name="parentemail" id="tb_parentemail" size="50" maxlength="30" value="$bbuserinfo[parentemail]" />
<input type="hidden" name="coppauser" value="1" />
</td>
</tr>
</table>
</fieldset>
</if>
<if condition="$show['birthday_required']">
$birthdaybit
</if>
$customfields[required]
</div>
</div>
</td>
</tr>
</table>
<br />
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="thead">$vbphrase[optional_information_will]</td>
</tr>
<tr>
<td class="panelsurround" align="center">
<div class="panel">
<div style="width:$stylevar[formwidth_usercp]" align="$stylevar[left]">
<if condition="$show['customtitleoption']">
<fieldset class="fieldset">
<legend><label for="tb_customtext">$vbphrase[custom_user_title]</label></legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td colspan="2">$vbphrase[title_appears_beneath_your_name]</td>
</tr>
<tr>
<td>$vbphrase[your_current_user_title_is]:<br /><strong>$bbuserinfo[usertitle]</strong></td>
<td align="$stylevar[right]"><label for="cb_resettitle"><input type="checkbox" name="resettitle" value="yes" id="cb_resettitle" />$vbphrase[reset]</label></td>
</tr>
<tr>
<td>$vbphrase[custom_user_title]:<br /><input type="text" class="bginput" name="customtext" id="tb_customtext" value="" size="50" maxlength="$vboptions[ctMaxChars]" /></td>
</tr>
</table>
</fieldset>
</if>
<if condition="$show['birthday_optional']">
$birthdaybit
</if>
<fieldset class="fieldset">
<legend><label for="tb_homepage">$vbphrase[home_page_url]</label></legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td>$vbphrase[let_other_visitors_know_url]</td>
</tr>
<tr>
<td>$vbphrase[home_page_url]:<br /><input type="text" class="bginput" name="homepage" id="tb_homepage" value="$bbuserinfo[homepage]" size="50" maxlength="200" /></td>
</tr>
</table>
</fieldset>
<fieldset class="fieldset">
<legend>$vbphrase[instant_messaging]</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td colspan="2">$vbphrase[may_enter_identity_for_im]</td>
</tr>
<tr>
<td>$vbphrase[icq_number]:<br /><input type="text" class="bginput" name="icq" value="$bbuserinfo[icq]" size="25" maxlength="30" /></td>
<td>$vbphrase[aim_screen_name]:<br /><input type="text" class="bginput" name="aim" value="$bbuserinfo[aim]" size="25" maxlength="30" /></td>
</tr>
<tr>
<td>$vbphrase[msn_messenger_handle]:<br /><input type="text" class="bginput" name="msn" value="$bbuserinfo[msn]" size="25" maxlength="50" /></td>
<td>$vbphrase[yahoo_messenger_handle]:<br /><input type="text" class="bginput" name="yahoo" value="$bbuserinfo[yahoo]" size="25" maxlength="30" /></td>
</tr>
</table>
</fieldset>
<if condition="$customfields['regular']">
<!-- start if customfields -->
</div>
</div>
</td>
</tr>
</table>
<br />
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
<td class="thead">$vbphrase[additional_information]</td>
</tr>
<tr>
<td class="panelsurround" align="center">
<div class="panel">
<div style="width:$stylevar[formwidth_usercp]" align="$stylevar[left]">
$customfields[regular]
<!-- end if custom fields -->
</if>
</div>
</div>
<div style="margin-top:$stylevar[cellpadding]px">
<input type="submit" class="button" value="$vbphrase[save_changes]" accesskey="s" />
<input type="reset" class="button" value="$vbphrase[reset_fields]" accesskey="r" />
</div>
</td>
</tr>
</table>
</form>
i need to add this code below the 1st code
<!--- gender field by tnguy3n --->
<fieldset class="fieldset">
<legend>Gender</legend>
<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0" width="100%">
<tr>
<td colspan="2">Tell people about your gender.</td>
</tr>
<tr>
<td><select name="gender">
<option value="0" <if condition="$bbuserinfo[gender] == Unknown">selected</if>>----</option>
<option value="1" <if condition="$bbuserinfo[gender] == Female">selected</if>>Female</option>
<option value="2" <if condition="$bbuserinfo[gender] == Male">selected</if>>Male</option>
</select></td>
</tr>
</table>
</fieldset>
<!--- end gender field --->