Skip to content

Instantly share code, notes, and snippets.

View siliconmeadow's full-sized avatar

Richard Sheppard siliconmeadow

46 followers · 128 following
  • Silicon Meadow Ltd
  • New York / Paris / Peckham
  • 11:33 (UTC +01:00)
View GitHub Profile
@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');
@siliconmeadow
siliconmeadow / book_wishlist.md
Created November 18, 2013 21:13
List of books I'd like
@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 / reset-vbox-adapters.sh
Created June 8, 2016 16:55
#!/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<
@siliconmeadow
siliconmeadow / terms.xsl
Last active August 10, 2016 16:33
<?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'
>
@siliconmeadow
siliconmeadow / Gemfile.lock
Created October 4, 2017 10:53
Our Gemfile.lock at https://capgemini.github.io
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)
@siliconmeadow
siliconmeadow / keybase.md
Created June 5, 2018 10:29

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: