not updating correctly, completely wrong number

[AN-net]

bump!

[AN-net]

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]

bump it like its hot, bump it like its hot!

[sabret00the]

what is your query to insert the data into the database?

[AN-net]

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]

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]

here is the template:

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

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

$_Post[cellnum]

instead of globalizing the variables. It's easier to track and debug that way.

[AN-net]

so globalize could be messing everything up?

[AN-net]

ok tried it using $_POST but it still puts that same weird number into the database, i dont understand y!!!!