m13253

#!/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

mill1000

About

This gist will show how to setup Raspbian Stretch as a headless Bluetooth A2DP audio sink. This will allow your phone, laptop or other Bluetooth device to play audio wirelessly through a Rasperry Pi.

Motivation

A quick search will turn up a plethora of tutorials on setting up A2DP on the Raspberry Pi. However, I felt this gist was necessary because this solution is:

• Automatic & Headless - Once setup, the system is entirely automatic. No user iteration is required to pair, connect or start playback. Therefore the Raspberry Pi can be run headless.
• Simple - This solution has few dependencies, readily available packages and minimal configuration.
• Up to date - As of December 2017. Written for Raspbian Stretch & Bluez 5.43

Prerequisites

hackerb9

#!/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

kmonsoor

#!/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
#

statickidz

---
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