vb.org Archive
Page 2 of 4 1 2 34
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   not updating correctly, completely wrong number (https://vborg.vbsupport.ru/showthread.php?t=72628)

AN-net 12-10-2004 08:15 AM
bump!

AN-net 12-10-2004 06:22 PM
is it possible that its getting put in wrong due to the cell phone fields being on the same page as edit password and edit email? because that is where its located

AN-net 12-11-2004 10:54 AM
bump it like its hot, bump it like its hot!

sabret00the 12-11-2004 01:48 PM
what is your query to insert the data into the database?

AN-net 12-11-2004 11:06 PM
the query is:
PHP Code:
$DB_site->query("UPDATE " . TABLE_PREFIX . "user SET $newpassword $newemail $newcellnum usergroupid = " . intval($bbuserinfo['usergroupid']) . " WHERE userid = $bbuserinfo[userid]"); 

amykhar 12-11-2004 11:19 PM
If it's always the same number going in, make sure your form is set up correctly and that it's not passing a constant value somehow.

It's really difficult to help people debug when you don't have access to the actual running code.

AN-net 12-13-2004 10:18 PM
here is the template:
HTML Code:
<script type="text/javascript" src="clientscript/vbulletin_md5.js"></script>
<script type="text/javascript">
function hash_passwords(currentpassword, currentpassword_md5, newpassword, newpassword_md5, newpasswordconfirm, newpasswordconfirm_md5)
{
        md5hash(currentpassword, currentpassword_md5);
        // do various checks
        if (newpassword.value != '')
        {
                md5hash(newpassword, newpassword_md5);
        }
        if (newpasswordconfirm.value != '')
        {
                md5hash(newpasswordconfirm, newpasswordconfirm_md5);
        }
}
</script>

<form action="profile.php" method="post" onsubmit="hash_passwords(currentpassword, currentpassword_md5, newpassword, newpassword_md5, newpasswordconfirm, newpasswordconfirm_md5)">
<input type="hidden" name="s" value="$session[sessionhash]" />
<input type="hidden" name="do" value="updatepassword" />
<input type="hidden" name="currentpassword_md5" />
<input type="hidden" name="newpassword_md5" />
<input type="hidden" name="newpasswordconfirm_md5" />

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
        <td class="tcat">$vbphrase[edit_email_and_password]</td>
</tr>

<tr>
        <td class="panelsurround" align="center">
        <div class="panel">
                <div style="width:$stylevar[formwidth_usercp]" align="$stylevar[left]">
               
                <if condition="$show['passwordexpired']">
                        <div class="smallfont">
                                <strong>$vbphrase[current_password_expired]</strong>
                        </div>
                </if>
               
                <div class="fieldset">
                        <div>$vbphrase[enter_password_to_continue]:</div>
                        <div><input type="password" class="bginput" name="currentpassword" size="50" maxlength="50" /></div>
                </div>
               
                <fieldset class="fieldset">
                        <legend>$vbphrase[edit_password]<if condition="$show['password_optional']"> ($vbphrase[optional])</if></legend>
                        <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
                        <tr>
                                <td>
                                        <div>$vbphrase[new_password]:</div>
                                        <div><input type="password" class="bginput" name="newpassword" size="50" maxlength="50" /></div>
                                </td>
                        </tr>
                        <tr>
                                <td>
                                        <div>$vbphrase[confirm_new_password]:</div>
                                        <div><input type="password" class="bginput" name="newpasswordconfirm" size="50" maxlength="50" /></div>
                                </td>
                        </tr>
                        </table>
                </fieldset>
               
                <fieldset class="fieldset">
                        <legend>$vbphrase[edit_email_address] ($vbphrase[optional])</legend>
                        <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
                        <tr>
                                <td>
                                        <div>$vbphrase[new_email_address]:</div>
                                        <div><input type="text" class="bginput" name="email" value="$bbuserinfo[email]" size="50" maxlength="50" /></div>
                                </td>
                        </tr>
                        <tr>
                                <td>
                                        <div>$vbphrase[confirm_new_email_address]:</div>
                                        <div><input type="text" class="bginput" name="emailconfirm" value="$bbuserinfo[email]" size="50" maxlength="50" /></div>
                                </td>
                        </tr>
                        </table>
                </fieldset>

                                <fieldset class="fieldset">
                        <legend>Edit Cell Phone Number ($vbphrase[optional])</legend>
                        <table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
                        <tr>
                                <td>
                                        <div>Cell Phone Number:</div>
                                        <div><input type="text" class="bginput" name="cellnum" value="" size="30" maxlength="10" /></div>
                                </td>
                        </tr>
                        <tr>
                                <td>
                                        <div>Confirm Cell Phone Number:</div>
                                        <div><input type="text" class="bginput" name="cellnumconfirm" value="" size="30" maxlength="10" /></div>
                                </td>
                        </tr>
                        </table>
                </fieldset>

                </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>
if your wondering, my fields are located in the same template as the edit password and edit email are;)

amykhar 12-14-2004 12:18 AM
Put in the values. Right now you have blanks. Do it just like the email and emailconfirm. Also, make sure you initialize those variables before you retrieve them from the post. When you use them in the script, you should be using
Code:
$_Post[cellnum]
instead of globalizing the variables. It's easier to track and debug that way.

AN-net 12-14-2004 11:41 AM
so globalize could be messing everything up?

AN-net 12-17-2004 03:13 AM
ok tried it using $_POST but it still puts that same weird number into the database, i dont understand y!!!!


All times are GMT. The time now is 08:46 PM.
Page 2 of 4 1 2 34
Show 40 post(s) from this thread on one page

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.02492 seconds
  • Memory Usage 1,770KB
  • 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
  • (1)bbcode_code_printable
  • (1)bbcode_html_printable
  • (1)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete