note 74532 added to ref.mysql
| From: | tomaszdotrupatgmaildotcom at osu1 dot php dot net | Date: | Mon, 16 Apr 2007 11:14:32 +0000 |
| Subject: | note 74532 added to ref.mysql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-125436@lists.php.net to get a copy of this message | ||
Correct algorithm to generate MySQL password hash is:
<?php
function mysql_password($passStr) {
$nr=0x50305735;
$nr2=0x12345671;
$add=7;
$charArr = preg_split("//", $passStr);
foreach ($charArr as $char) {
if (($char == '') || ($char == ' ') || ($char ==
'\t')) continue;
$charVal = ord($char);
$nr ^= ((($nr & 63) + $add) * $charVal) + ($nr << 8);
$nr &= 0x7fffffff;
$nr2 += ($nr2 << 8) ^ $nr;
$nr2 &= 0x7fffffff;
$add += $charVal;
}
return sprintf("%08x%08x", $nr, $nr2);
}
?>
----
Server IP: 83.64.128.68
Probable Submitter: 193.222.135.194
----
Manual Page -- http://www.php.net/manual/en/ref.mysql.php
Edit -- https://master.php.net/note/edit/74532
Del: integrated -- https://master.php.net/note/delete/74532/integrated
Del: useless -- https://master.php.net/note/delete/74532/useless
Del: bad code -- https://master.php.net/note/delete/74532/bad+code
Del: spam -- https://master.php.net/note/delete/74532/spam
Del: non-english -- https://master.php.net/note/delete/74532/non-english
Del: in docs -- https://master.php.net/note/delete/74532/in+docs
Del: other reasons-- https://master.php.net/note/delete/74532
Reject -- https://master.php.net/note/reject/74532
Search -- https://master.php.net/manage/user-notes.php