Skip to content

Instantly share code, notes, and snippets.

View siliconmeadow's full-sized avatar

Richard Sheppard siliconmeadow

36 followers · 124 following
  • Nomensa Ltd
  • New York / Paris / Peckham
View GitHub Profile
@siliconmeadow
siliconmeadow / proxy_switch.sh
Last active August 29, 2015 14:07 — forked from tsphethean/proxy_switch.sh
#!/bin/sh
if [[ -z "$1" ]]; then
echo "Usage: proxy_switch.sh en 1.1.1.1:8080.
proxy_switch.sh dis"
exit 2;
fi
if [[ "$1" == "en" ]]; then
export http_proxy=http://$2
@siliconmeadow
siliconmeadow / chart_gauge.html
Last active October 7, 2015 10:55
<html>
<head>
<link href="/css/c3.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<div id="chart"></div>
<div id="chart1"></div>
<div id="chart2"></div>
<div id="chart3"></div>
@siliconmeadow
siliconmeadow / 0_reuse_code.js
Created November 4, 2013 11:33
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
@siliconmeadow
siliconmeadow / plesk_email_pwds.sql
Created November 4, 2013 14:21
Get password of plesk email user
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>';
@siliconmeadow
siliconmeadow / email_names_passwords_by_domain_in_plesk.sql
Created November 4, 2013 14:27
Plesk users and their passwords from a specific domain in Plesk
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>';
@siliconmeadow
siliconmeadow / sftp_passwords_on_plesk.sql
Created November 4, 2013 14:31
To find the passwords for an SFTP user on Plesk
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>';
@siliconmeadow
siliconmeadow / client_password.sql
Created November 4, 2013 14:33
To find a Plesk client's password, providing you know their login name.
SELECT clients.login , SUBSTRING(accounts.password, 1)
FROM clients, accounts
WHERE clients.login LIKE '<loginname>'
AND clients.account_id = accounts.id;
@siliconmeadow
siliconmeadow / database_creds_in_plesk.sql
Created November 4, 2013 14:36
To find the database names, database usernames and passwords which belong to a database in Plesk
SELECT domains.name, data_bases.name, db_users.login, SUBSTRING(accounts.password, 1)
FROM domains, data_bases, db_users, accounts
WHERE domains.name LIKE '%<domain.dom>%'
AND db_users.account_id = accounts.id
AND db_users.db_id = data_bases.id
AND data_bases.dom_id = domains.id
ORDER BY data_bases.id;
@siliconmeadow
siliconmeadow / protected_directories_in_plesk.sql
Created November 4, 2013 14:37
To find details about protected directories in Plesk.
SELECT domains.name, protected_dirs.path, protected_dirs.realm, pd_users.login, SUBSTRING(accounts.password, 1), `protected_dirs`.`ssl`, protected_dirs.non_ssl
FROM protected_dirs, pd_users, domains, accounts
WHERE domains.name LIKE '%<domain.dom>%'
AND protected_dirs.dom_id = domains.id
AND pd_users.pd_id = protected_dirs.id
AND pd_users.account_id = accounts.id;
@siliconmeadow
siliconmeadow / traffic_by_client_in_plesk.sql
Created November 4, 2013 14:45
To find traffic by client per month in Plesk.
SELECT SUM(DomainsTraffic.http_out), SUM(DomainsTraffic.ftp_in), SUM(DomainsTraffic.ftp_out), SUM(DomainsTraffic.smtp_in), SUM(DomainsTraffic.smtp_out), SUM(DomainsTraffic.pop3_imap_in), SUM(DomainsTraffic.pop3_imap_out)
FROM DomainsTraffic, domains, clients
WHERE DomainsTraffic.date < '2008-07-10'
AND DomainsTraffic.date > '2008-05-31'
AND clients.id =1
AND clients.id = domains.cl_id
AND domains.id = DomainsTraffic.dom_id