http://www.thesupportsystem.co.uk/?p=344

FTP ACCOUNTS

SELECT account_id AS ‘ID’, login AS ‘USERNAME’, password AS ‘PASSWORD’, home AS ‘HOMEDIR’ FROM sys_users S, accounts A WHERE S.account_id = A.id;

MAIL ACCOUNTS

For all Domains

SELECT account_id AS ‘ID’, mail_name AS ‘USERNAME’, password AS ‘PASSWORD’, postbox as ‘MAILBOX?’, name AS ‘DOMAIN’, redir_addr as REDIRECT FROM mail M, domains D, accounts A WHERE M.account_id = A.id AND M.dom_id = D.id ORDER BY name;

For a Specific Domain

SELECT account_id AS ‘ID’, mail_name AS ‘USERNAME’, password AS ‘PASSWORD’, postbox as ‘MAILBOX?’, name AS ‘DOMAIN’, redir_addr as REDIRECT FROM mail M, domains D, accounts A WHERE M.account_id = A.id AND M.dom_id = D.id AND D.name=’****DOMAIN_NAME****‘;

MySQL ACCOUNTS

Plesk 7

SELECT d.name AS DOMAIN, db.name AS DB, du.login as USER, du.passwd as PASS FROM db_users du, data_bases db, domains d WHERE du.db_id = db.id AND db.dom_id=d.id ORDER BY d.name, db.name;

Plesk 8 & 9

SELECT d.name AS DOMAIN, db.name AS DB, du.login as USER, a.password as PASS FROM db_users du, data_bases db, domains d, accounts a WHERE du.db_id = db.id AND db.dom_id=d.id and du.account_id=a.id ORDER BY d.name, db.name;

CLIENT ACCOUNTS

Plesk 7

SELECT id as ‘ID’, login as ‘USERNAME’, passwd as ‘PASSWORD’, cname as ‘COMPANY’ FROM clients  ORDER BY login;

Plesk 8 & 9

SELECT c.id as client, a.id as account, c.login, a.password from clients c, accounts a where a.id=c.account_id;