Skip to content

Instantly share code, notes, and snippets.

View siliconmeadow's full-sized avatar

Richard Sheppard siliconmeadow

  • Nomensa Ltd
  • New York / Paris / Peckham
View GitHub Profile
@siliconmeadow
siliconmeadow / mailboxes_by_client.sql
Created November 4, 2013 14:41
To find mailboxes by client in Plesk
SELECT mail.mail_name,domains.name
FROM clients, domains, mail
WHERE clients.id = <integer>
AND clients.id = domains.cl_id
AND domains.id = mail.dom_id
ORDER BY domains.name;
@siliconmeadow
siliconmeadow / domains_by_client_in_plesk.sql
Created November 4, 2013 14:39
To find domain names and hosting types by client in Plesk.
SELECT domains.name, domains.htype, clients.cname
FROM domains, clients
WHERE clients.id = domains.cl_id
AND clients.id = <(an integer)>
ORDER BY domains.htype ASC;
@siliconmeadow
siliconmeadow / num_mailboxes_of_client.sql
Created November 4, 2013 14:47
To find the number of mailboxes a client has on a Plesk server
SELECT COUNT( mail.mail_name )
FROM clients, domains, mail
WHERE clients.id =2
AND clients.id = domains.cl_id
AND domains.id = mail.dom_id;
@siliconmeadow
siliconmeadow / string_replacement_files_path.sql
Created November 4, 2013 14:51
Code to do string replacement on columns in a table. Particularly useful for filename path changes in Drupal 6. Possibly D7?
UPDATE files
SET files.filepath
=
REPLACE(files.filepath,'sites/jarp.aroq.com/files','sites/default/files');
#!/bin/bash
vbox_interfaces=($(/sbin/ifconfig | grep -o 'vboxnet[0-9]\+'))
for interface in ${vbox_interfaces[@]}
do
echo "Restarting ${interface}"
sudo ifconfig $interface down
sudo ifconfig $interface up
done
@siliconmeadow
siliconmeadow / terms.xml
Created August 9, 2016 15:25
Term frequency
<?xml version="1.0" encoding="UTF-8"?>
<response>
<lst name="responseHeader"><int name="status">0</int><int name="QTime">14</int></lst><lst name="terms"><lst name="tm_title"><int name="manager">5810</int><int name="manger">3301</int><int name="mananger">3293</int><int name="senior">2077</int><int name="snr">1898</int><int name="sr">1898</int><int name="sr.">1898</int><int name="finance">1350</int><int name="accountant">1306</int><int name="accounting">1295</int><int name="business">1128</int><int name="financial">1093</int><int name="account">1087</int><int name="officer">999</int><int name="director">971</int><int name="sale">861</int><int name="executive">803</int><int name="head">782</int><int name="marketing">768</int><int name="analyst">746</int><int name="management">740</int><int name="tax">737</int><int name="audit">722</int><int name="development">633</int><int name="&amp;">611</int><int name="assistant">544</int><int name="commercial">514</int><int name="consultant">507</int><int name="project">415<
<?xml version='1.0' encoding='UTF-8'?>
<!--
Transform the term frequency reports to html tables.
-->
<xsl:stylesheet version='1.0'
xmlns:xsl='http://www.w3.org/1999/XSL/Transform'
>
GEM
remote: https://rubygems.org/
specs:
activesupport (4.2.8)
i18n (~> 0.7)
minitest (~> 5.1)
thread_safe (~> 0.3, >= 0.3.4)
tzinfo (~> 1.1)
addressable (2.5.2)
public_suffix (>= 2.0.2, < 4.0)

Keybase proof

I hereby claim:

  • I am siliconmeadow on github.
  • I am siliconmeadow (https://keybase.io/siliconmeadow) on keybase.
  • I have a public key ASAUw5ztBUbC0mDikds3k4qTFgzITxbhJtM-sCt9z-5UqAo

To claim this, I am signing this object: