|
|
Posted by "William Stokes" on 01/03/06 11:34
Thanks!
-W
"M" <lists@gazelasport.sk> kirjoitti
viestissδ:43BA3C6F.8020908@gazelasport.sk...
> It seems the upgrade was from Mysql 4.0. PASSWORD() function changed
> between 4.0 and 4.1, it uses longer hashes now. You can still use
> OLD_PASSWORD() function instead.
>
> William Stokes wrote:
>> Hello,
>>
>> My ISP updated their MySQL DB to 5.0.18 and that killed my login
>> procedure which was OK yesterday. Any ideas how to start to debug this?
>>
>> The login updates 2 fields in users table row where username and password
>> macthes. This is the code:
>>
>>
>> if (!$query = mysql_query("update tbl_users set sess_id='$sess_id',
>> sess_id_start='$date'
>> where md5(usr_name)='$usr_name' and password=PASSWORD('$password')
>> ",$connection))
>> {
>> header("Location: http://www.domain.net/loginscreen.php");
>> exit;
>> }
>> else
>> {
>> Do Login and stuff...
>>
>> This worked until today. I called the ISP and they confirmed that there
>> was a database update yesterday.
>>
>> -Will
>>
Navigation:
[Reply to this message]
|