ok , i searched the net again , and now i need to change the password through vpopmail database .!
i need encrpyted pass plus the clear(textual- none encrypted) pass , how do i write it in sql ?
i mean previously we were trying to use :
$sql = 'UPDATE mailaccount SET password=%c WHERE nname=%u LIMIT 1';
now instead of mailaccount database , i want to use the vpopmail database .
vpopmail database , has a vpopmail table , which again this table contains these fields of interest:
4.pw_gecos (whats this?)
UPDATE vpopmail.vpopmail SET pw_passwd='??',pw_clear_passwd='?' WHERE pw_name='?'LIMIT 1
because the pw_name only contains the username and not the emailaddress , i have no idea how i can make this work! let alone the pw_password and pw_clear_password
i'll be very thankful if you help me on this again .
and as an example , the contents of these fields for firstname.lastname@example.org
is as follows :
pw_name pw_password pw_domain pw_gecos pw_clear_passwd
test $1$rJWf8PFS$U2QiKbGM\GTU9NKsve1oz0 ustmb.ir test 12ust999
now , how can i fill the pw_assword and pw_clear_password fields in th query i posted previously .
i mean i have :
"UPDATE vpopmail.vpopmail SET pw_passwd = '?',pw_clear_passwd='?' WHERE pw_name = '?' LIMIT 1;
i have no idea what to put on those blanks , any idea ?
and by the way this is where i found about vpopmail :http://www.roundcubeforum.net/index.php/topic,4286.30.html