• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Editing User/Password Lookup

KrazyBob

Regular Pleskian
I'm in a jam.

How can I append to this mysql code so that it takes its password - if plain text - and writes it back over itself. But leaves it alone if it encrypted?

Your help is appreciated.

Code:
select CONCAT(mail_name,"@",name) as email_address,accounts.password from mail left join domains on domains.id=mail.dom_id left join accounts on accounts.id=mail.account_id;
 
Back
Top