Change password class::method?

[AustinKalb]

Can anyone tell me the the Data Manager class::method I can use to change a users password? If there is none, what is the programmatic procedure?

Thanks in advance!
Austin

[Adrian Schneider]

PHP Code:

$db->query_write("
    UPDATE " . TABLE_PREFIX . "user
    SET password = md5(concat(md5('alphabet soup'), salt))
    WHERE userid = 777
"); 

... where 777 is the userid of the account you want to modify, and 'alphabet soup' is the new password.

[AustinKalb]

Originally Posted by SirAdrian

PHP Code:

$db->query_write("
    UPDATE " . TABLE_PREFIX . "user
    SET password = md5(concat(md5('alphabet soup'), salt))
    WHERE userid = 777
"); 

... where 777 is the userid of the account you want to modify, and 'alphabet soup' is the new password.

This works great! Thanks.

How would I check for errors? the query_write seems to return a 1 with a valid or an invalid userid.


Thanks again!
Austin

[Marco van Herwaarden]

Better use the datamanagers instead of a manual query.