Joomla! Discussion Forums

Hi guys,

I have to encrypt the manually uploaded jos_users table. At the moment i run the following script via SQL on the table:

update `jos_users` set password=md5(password);

but this does not add salt.

Can someone with experience in SQL/php write a script that will run in the field (as typed as i have minimal coding skills)
that will ($password+$salt).

I wish to have salt instead of basic MD5 encryption. But i've tried changing it to MD5($password+$salt) and the script fails.

please help


ps; Attached is a screenshot of my SQL input.