The Arcive of vBulletin Modifications Site.

Thug · #1 02-22-2005, 11:47 PM

i isntalled gender hack but i got this error when i selecting my gender
what did i not do right?

PHP Code:


			
Database error in vBulletin 3.0.3:



Invalid SQL: UPDATE user SET

        birthday = '11-14-1987',

        birthday_search = '1987-11-14',

        usertitle = '<b><font color= blue>[AngEL-StYlEz GuaRdIaN]</font></b>',

        customtitle = 1,

        parentemail = '',gender='2',

        homepage = 'http://www.oh-twadi.com',

        icq = '',

        aim = '',

        yahoo = '',

        msn = '',

        usergroupid = 6

        WHERE userid = 1

    

mysql error: Unknown column 'gender' in 'field list'



mysql error number: 1054



Date: Tuesday 22nd of February 2005 08:43:37 PM

Script: [url]http://www.oh-twadi.com/forum/profile.php[/url]

Referer: [url]http://www.oh-twadi.com/forum/profile.php?do=editprofile[/url]

Username: MC G

IP Address: xxxxxxxxxxx

what did i not do?

deathemperor · #2 02-23-2005, 02:36 AM

you missed the query they ask you to run, run it will fix this problem.

Thug · #3 02-23-2005, 08:59 AM

How do i run this query?and where?

sabret00the · #4 02-23-2005, 09:47 AM

what hack is it from?

Thug · #5 02-23-2005, 10:04 AM

gender hack

https://vborg.vbsupport.ru/showthrea...ht=gender+hack

sabret00the · #6 02-23-2005, 10:50 AM

[sql]#### QUERY ####
ALTER TABLE user ADD gender varchar(7) NOT NULL[/sql]

run that query, although you could actually do this with templates as released over at vBT

Marco van Herwaarden · #7 02-23-2005, 10:54 AM

Quote:

Originally Posted by Thug

gender hack

https://vborg.vbsupport.ru/showthrea...ht=gender+hack

Then post your question in that thread if you want to have help on that hack.

This will get you a quicker response form the coder i think.

Thug · #8 02-23-2005, 11:05 AM

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

PHP Code:


			


<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

PHP Code:


			
<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

PHP 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 --->

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06698 seconds Memory Usage 4,851KB 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 (4)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (8)post_thanks_box (8)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (8)post_thanks_postbit_info (8)postbit (8)postbit_onlinestatus (8)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
Messages: