Skip to content

Instantly share code, notes, and snippets.

@alexsorokoletov
alexsorokoletov / Helpers.sql
Last active February 9, 2022 08:00
Helpful functions when you need to find out what is going on on SQL Server
/* TOP SLOW REQUESTS */
/* time is in microseconds */
SELECT creation_time
,last_execution_time
,total_physical_reads
,total_logical_reads
,total_logical_writes
, execution_count
, total_worker_time
, total_elapsed_time
@kolisn
kolisn / set.py
Last active September 21, 2022 04:00
JSON tool for pogo spawnscan
import urllib2
import sqlite3
import pip
import os
import json
import pymysql.cursors
#inFile: SQL databse filename string (assuming .db) #outFile: JSON filename string
def getDataFromDBFile(inFile, outFile):
try:
conn=sqlite3.connect(inFile)
import cfscrape
import json
import sys
import argparse
import requests
import logging
import time
import random
from pgoapi import PGoApi
@jjensn
jjensn / grouped_light.py
Last active March 6, 2018 19:47 — forked from hordurk/grouped_light.py
Grouped light platform for Home Assistant
import logging
# Import the device class from the component that you want to support
from homeassistant.components import light
from homeassistant.const import (STATE_OFF, STATE_ON, SERVICE_TURN_ON,
SERVICE_TURN_OFF, ATTR_ENTITY_ID)
from homeassistant.components.light import (SUPPORT_BRIGHTNESS,
SUPPORT_RGB_COLOR,
SUPPORT_COLOR_TEMP,
SUPPORT_TRANSITION)
@aallan
aallan / mac-vendor.txt
Last active February 20, 2025 07:59
List of MAC addresses with vendors identities
000000 Officially Xerox
000001 SuperLAN-2U
000002 BBN (was internal usage only, no longer used)
000003 XEROX CORPORATION
000004 XEROX CORPORATION
000005 XEROX CORPORATION
000006 XEROX CORPORATION
000007 XEROX CORPORATION
000008 XEROX CORPORATION
000009 powerpipes?
@alwynpan
alwynpan / 11-seven.md
Last active May 23, 2023 11:12
Mock location on LineageOS 16/17 with GPS Joystick

Mock location on LineageOS 16/17 with GPS Joystick

Prerequisite

  • A computer (tested on Windows 10, but I don't see any reason it won't work with macOS or Linux).

  • A LineageOS 16/17 compatible phone (LineageOS 16 is recommended, some users reported random crash on LineageOS 17).

  • Download the minimal ADB from XDA Developers Forum and unzip it.