Skip to content

Instantly share code, notes, and snippets.

@Snipa22
Snipa22 / gist:827b2b235310e018e350fd053b008a21
Created January 5, 2020 20:02
PGP Signature for Alexander Blair/Snipa
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
****************************************************************
Confirming ownership of key:
4872 77A8 BD0A 209C 16B7 00F3 C645 52D8 77C3 2479
Current Monero block hash for block 2004715:
0b8aa809884dbaa681269b6091dd719f05325df34ab05332aec08ba62545a11f
CADDY_DOWNLOAD_DIR=$(mktemp -d)
cd $CADDY_DOWNLOAD_DIR
curl -sL "https://caddyserver.com/download/linux/amd64?plugins=http.cors" | tar -xz caddy init/linux-systemd/caddy.service
sudo mv caddy /usr/local/bin
sudo chown root:root /usr/local/bin/caddy
sudo chmod 755 /usr/local/bin/caddy
sudo setcap 'cap_net_bind_service=+ep' /usr/local/bin/caddy
sudo groupadd -g 33 www-data
sudo useradd -g www-data --no-user-group --home-dir /var/www --no-create-home --shell /usr/sbin/nologin --system --uid 33 www-data
sudo mkdir /etc/caddy

Keybase proof

I hereby claim:

  • I am snipa22 on github.
  • I am snipa (https://keybase.io/snipa) on keybase.
  • I have a public key ASD4MtA466DljmN4ZOioyW3C83C5R6txm7ZtJtUtmz6hPQo

To claim this, I am signing this object:

>>> p.print_stats()
Tue Apr 5 00:50:34 2016 profile_data
980097047 function calls (958288563 primitive calls) in 3900.461 seconds
Ordered by: internal time
ncalls tottime percall cumtime percall filename:lineno(function)
8174838 629.375 0.000 1172.544 0.000 /usr/local/lib/python2.7/site-packages/numpy/core/arrayprint.py:543(fillFormat)
10896000 184.174 0.000 553.155 0.000 /usr/local/lib/python2.7/site-packages/pybrain/structure/connections/full.py:21(_backwardImplementation)
@Snipa22
Snipa22 / gist:3981705
Created October 30, 2012 17:28
Material Query
"""SELECT
t1.typeID,
(t1.volume * t1.portionSize) as Volume,
t1.portionSize,
SUM(CASE WHEN m1.materialTypeID = 34 THEN m1.quantity ELSE 0 END) AS Tritanium,
SUM(CASE WHEN m1.materialTypeID = 35 THEN m1.quantity ELSE 0 END) AS Pyerite,
SUM(CASE WHEN m1.materialTypeID = 36 THEN m1.quantity ELSE 0 END) AS Mexallon,
SUM(CASE WHEN m1.materialTypeID = 37 THEN m1.quantity ELSE 0 END) AS Isogen,
SUM(CASE WHEN m1.materialTypeID = 38 THEN m1.quantity ELSE 0 END) AS Nocxium,
SUM(CASE WHEN m1.materialTypeID = 39 THEN m1.quantity ELSE 0 END) AS Zydrine,