ssokolow

-- Reasonably efficient pagination without OFFSET
-- SQLite version (Adapted from MS SQL syntax)
-- Source: http://www.phpbuilder.com/board/showpost.php?p=10376515&postcount=6

SELECT foo, bar, baz, quux FROM table
 WHERE oid NOT IN ( SELECT oid FROM table
                    ORDER BY title ASC LIMIT 50 )
 ORDER BY title ASC LIMIT 10

ssokolow

Disaster Plans for Firefox XUL Sunset

Public URL:	Github Gist
Status:	Incomplete
Last Updated:	2017-06-01 05:08 EDT

Threat Summary

ssokolow

#!/usr/bin/env python
# -*- coding: utf-8 -*-
"""[application description here]"""

__appname__ = "[application name here]"
__author__  = "Stephan Sokolow (deitarion/SSokolow)"
__version__ = "0.0pre0"
__license__ = "GNU GPL 3.0 or later"

import logging

ssokolow

#!/usr/bin/env python
"""Simple wrapper to update Transmission's IPv4 binding on startup for use with VPNs.

(For Linux systems. Tested on Ubuntu 14.04 LTS)
"""

import json, os, subprocess

VPN_IF = "tun0"
TRANSMISSION_CFG = os.path.expanduser('~/.config/transmission/settings.json')

ssokolow

import shlex

def lex_shellscript(script_path, statement_cb):
    """Given a file-like object, use a POSIX-mode shlex.shlex object to split 
       it into statements and call the given statement processor to convert 
       statements into dicts.
    """
    fields = {}

    with open(script_path, 'r') as fobj:

ssokolow

#!/usr/bin/env python
"""python-xlib example which reacts to changing the active window/title.

Requires:
- Python
- python-xlib

Tested with Python 2.x because my Kubuntu 14.04 doesn't come with python-xlib
for Python 3.x.

ssokolow

#!/usr/bin/env python
# -*- coding: utf-8 -*-
"""Check if all processes matching a name were started after a config
file's mtime.

--snip--

Tested under Python 2.7 and 3.4
"""

ssokolow

@echo off
REM Usage:
REM 1. Set up your DOS network and packet drivers
REM 2. Install sftpd386.exe
REM 3. Edit the line which calls sftpd386.exe for path/credentials/IP address
REM 4. Run "sftpget file1 file2 file3 ..."

REM Write sftp script
(
@echo off

ssokolow

#!/bin/sh
# Sources:
# - https://stackoverflow.com/questions/30931/register-file-extensions-mime-types-in-linux
# - https://www.freedesktop.org/wiki/Specifications/AddingMIMETutor/

echo "* Adding file-type icons..."
for SIZE in 16 32 64; do
	echo "* Adding ${SIZE}px icon"
	xdg-icon-resource install --context mimetypes --size "$SIZE"  "/usr/share/icons/hicolor/${SIZE}x${SIZE}/apps/mpv.png" application-x-mpv-edl
done

ssokolow

#!/usr/bin/env python2
# -*- coding: utf-8 -*-
"""Wrapper script for scheduling an alarm within the desktop session so
MPV has access to the audio and video outputs.

See --help output for more details.

Requirements:
- python-dateutil
- pytimeparse