Richard Sheppard siliconmeadow

## email_names_passwords_by_domain_in_plesk.sql
SELECT accounts.id, mail.mail_name, domains.name, SUBSTRING(accounts.password, 1) AS pw
FROM  accounts, mail, domains
WHERE  mail.account_id =  accounts.id
AND mail.dom_id = domains.id
AND mail.mail_name LIKE '%'
AND domains.name = '<domainName>';

## plesk_email_pwds.sql
SELECT accounts.id, mail.mail_name, domains.name, SUBSTRING(accounts.password, 1) AS pw
FROM  accounts, mail, domains
WHERE  mail.account_id =  accounts.id
AND mail.dom_id = domains.id
AND mail.mail_name = '<pop3UserName>'
AND domains.name = '<domainName>';

## 0_reuse_code.js
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
	SELECT accounts.id, mail.mail_name, domains.name, SUBSTRING(accounts.password, 1) AS pw
	FROM accounts, mail, domains
	WHERE mail.account_id = accounts.id
	AND mail.dom_id = domains.id
	AND mail.mail_name LIKE '%'
	AND domains.name = '<domainName>';
	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console