• 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

Lookup Domain Passwords

B

b-nut

Guest
I have a script that I created to lookup domain(ftp) passwords for support purposes. The script was designed for plesk 7 but I recently migrated to a plesk 8 box and the script no longer works. The structure of the PSA database has changed and now I don't know how to lookup the passwords in the Plesk 8 database. It seems that the passwords are now stored in a different table in BLOB format and I don't know how to retrieve them.

Here is the query that I used on Plesk 7:
PHP:
$SQL = "SELECT d.name, d.cl_id, s.login, a.password, c.login as client_login, c.passwd as client_password
	FROM domains d, hosting h, sys_users s, accounts a, clients c
	WHERE d.id = h.dom_id 
	AND s.id = h.sys_user_id 
	AND a.id = s.account_id 
	AND c.id = d.cl_id
	AND d.name = '$domain'";

Does anyone know how to restructure this query for plesk 8?
 
Back
Top