vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   gender hack help (https://vborg.vbsupport.ru/showthread.php?t=76870)

Thug 02-22-2005 11:47 PM
gender hack help
 
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 02-23-2005 02:36 AM
you missed the query they ask you to run, run it will fix this problem.

Thug 02-23-2005 08:59 AM
How do i run this query?and where?

sabret00the 02-23-2005 09:47 AM
what hack is it from?

Thug 02-23-2005 10:04 AM
gender hack

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

sabret00the 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 02-23-2005 10:54 AM
Quote:
Originally Posted by Thug
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 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 ---> 


All times are GMT. The time now is 06:57 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03758 seconds
  • Memory Usage 1,886KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (8)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete