Plesk FTP passwords

use psa;
SELECT
domains.displayName,
sys_users.login,
accounts.password
FROM
hosting,
domains,
sys_users,
accounts
WHERE
hosting.dom_id = domains.id
AND
hosting.sys_user_id = sys_users.id
AND
sys_users.account_id = accounts.id
ORDER BY
domains.displayName
;


#get plesk email user's username, pw, and redirect.
use psa; select domains.displayname,mail.mail_name,accounts.password,mail.redir_addr from domains,mail,accounts where domains.id=mail.dom_id and accounts.id=mail.account_id;


Catchalls:

select d.name as
domain, p.value as catchall_address from Parameters p,
DomainServices ds, domains d where d.id = ds.dom_id and
ds.parameters_id = p.id and p.parameter = 'catch_addr' order by d.name


select count(distinct(domains.name)) from domains,DomainServices,Parameters where domains.id=DomainServices.dom_id and DomainServices.parameters_id=Parameters.id and Parameters.value<>"reject";