Piskvor

#!/bin/bash -e
# extract_cookies.sh:
#
# Convert from Firefox's cookies.sqlite format to Netscape cookies,
# which can then be used by wget and curl. (Why don't wget and curl
# just use libsqlite if it's installed?)

# USAGE:
#
# $ extract_cookies.sh > /tmp/cookies.txt

Piskvor

---
METHOD 1

This should roughly sort the items on distance in MySQL, and should work in SQLite.
If you need to sort them preciser, you could try using the Pythagorean theorem (a^2 + b^2 = c^2) to get the exact distance.
---
SELECT *
FROM table
ORDER BY ((lat-$user_lat)*(lat-$user_lat)) + ((lng - $user_lng)*(lng - $user_lng)) ASC

Piskvor

#!/bin/busybox sh

# 1) Download a prebuilt BusyBox binary here:
#    https://busybox.net/downloads/binaries/
#
# 2) Prepare your kernel
#    cp /boot/vmlinuz vmlinuz
#
# 3) Copy the files
#    install -Dm0755 busybox-x86_64 initramfs/bin/busybox

Piskvor

// [bbox:south,west,north,east]
[bbox:50.05,14.42,50.10,14.51]
[out:json];

area["name"="Žižkov"]["admin_level"="10"]->.administrativeBoundary;
(
  nwr["highway"]["name"](area.administrativeBoundary);
);
out center;
out count;

Piskvor

# find the new device 

lsusb -t

> Port 3: Dev 20, If 1, Class=Chip/SmartCard

# device number from lsusb "Dev"
lsusb -s 20

> Bus 001 Device 020: ID 32a3:3201  

Piskvor

PhpStorm + PhpStan watcher

PhpStorm - Settings - Tools - File Watchers (create new)

• File type: PHP
• Scope: Project files
• Program (wherever your phpstan is located, obvs.): $ContentRoot$/vendor/phpstan/phpstan/bin/phpstan
• Arguments: analyse $FilePath$
• Working directory (this is probably the directory with phpstan.neon): $ContentRoot$
• Show console: on error

Piskvor

#!/usr/bin/perl
my $dev = "/sys/class/leds/led0/brightness";
my $OFF = "1";
my $ON = "0";

my ($ip) = `ifconfig`=~/ddr:(.*?) /;
#print $ip;

# Strip out the .'s
$ip =~ s/\.//g;

Piskvor

#!/bin/bash
#set -e

# origin-source:  http://www.fars-robotics.net/install-wifi
# install-wifi - v9.4 - by MrEngman.
# After downloading this script:
#   $  sudo mv ./install-wifi /usr/bin/install-wifi
#   $  sudo chmod +x /usr/bin/install-wifi
#   $  sudo install-wifi -h
#

Piskvor

<?php

declare(strict_types=1);

/*
    Usage:
       start PHP devel server in this script's directory:
       php -S [::]:8888
       send requests to http://your-ip-address:8888/
       JSON events are logged to event.log

Piskvor

// ==UserScript==
// @name         Animate the Lines WebGL experiment automatically
// @namespace    https://gist.github.com/spite/90e3dbf8e117660f6788a5748ae06cad
// @version      0.2
// @description  Automatically drags the mouse, leading to a pleasant effect
// @author       spite, userscripted by Piskvor
// @match        https://lines.chromeexperiments.com/drag/
// @grant        none
// @updateURL    https://gist.github.com/Piskvor/41df1f68b44b43100552126c76e2f609/raw/experiments_lines_drag.user.js
// ==/UserScript==