Little PHP problem

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
gd77
Forum Newbie
Posts: 20
Joined: Sat Feb 26, 2011 6:11 pm

Little PHP problem

Post by gd77 »

function create_account($user,$pass,$email)
{
global $db_translation,$db,$a_user;
global $tempID,$email,$pass_enc; //////////

$pass = preg_replace( "/[^A-Za-z0-9]/", "", $pass ); //only letters and numbers
$user = preg_replace( "/[^A-Za-z0-9]/", "", $user ); //only letters and numbers

$pass_enc=sha1(strtoupper($user).':'.strtoupper($pass));
$db->query("INSERT INTO ".$db_translation['accounts']." (".$db_translation['login'].",".$db_translation['encrypted_password'].",".$db_translation['banned'].",".$db_translation['email'].",".$db_translation['flags'].") VALUES ('".$user."','".$pass_enc."','0','".$db->escape($email)."','2')") or ($report = 'Error: '.mysql_error());
$sel="select * from ".$db_translation['accounts']." order by id desc limit 1"; //////////
$tempID=mysql_result(mysql_query($sel), 0, 0); //////////
$forumpass=md5(strtoupper($user).':'.strtoupper($pass)); //////////



if (!$report)
return false;
else
return $report;
}

///////
Main problem is the PASSWORD returning empty value to the db.
why?
Post Reply