Skip to content

Instantly share code, notes, and snippets.

View y4rr's full-sized avatar
💭
Learning stuff

y4rr

💭
Learning stuff
View GitHub Profile
@y4rr
y4rr / sqldump_to_csv.py
Created June 12, 2019 02:16 — forked from krypted/gist:605e0fb776d8761750c068234811a842
Convert a SQL Dump to CSV/Excel
#
#
# Exports the contents of a flat sql dump to csv files with the name of the table.csv and a xls representation of the database
# Requires Python 3.7 (from a Mac, first - brew install python3)
# Prior to running python3 -m pip install pandas
# Prior to running python3 -m pip install openpyxl
# Usage python3 sqlcsvxlsexport.py <sql dump file> <target directory>
# Send accolades for the script to krypted@me.com or hatemail to <devnull>
#
#
@y4rr
y4rr / iCloud-AddressBook-Recovery.sql
Created June 15, 2019 07:55 — forked from idiamant/iCloud-AddressBook-Recovery.sql
SQL Query to extract contacts from iCloud Backup - AddressBook.sqlitedb
--
-- How to recover iPhone contacts from Backup files:
--
-- Recover contacts from AddressBook.sqlitedb of iCloud and iTunes backup
-- I used https://github.com/horrorho/InflatableDonkey in order to download AddressBook.sqlitedb from iCloud Backup the last backups made,
-- in order to recover some of my Wife's contacts that got lost while reconnecting her iPhone to her work's Exchange server.
-- * If you have 2FA for your Apple Account, you won't be able to login to the iCloud using the tool above,
-- without supplying the 6 digit token.
-- Use the following method in order to login from cURL, and by that get the Two step token on your Apple Device
-- (Copy the next 4 lines to bash shell, modify the APPLE_ID and APPLE_PASS env vars to your own details):
#!/usr/bin/env bash
source ./lib_sh/echos.sh
source ./lib_sh/requirers.sh
bot "Hi! I'm going to install tooling and tweak your system settings. Here I go..."
if ! sudo grep -q "%wheel ALL=(ALL) NOPASSWD: ALL" "/etc/sudoers"; then
bot "I need you to enter your sudo password so I can install some things:"
sudo -v
@y4rr
y4rr / No_New_Tabs.user.js
Last active September 15, 2019 02:19
Link Target blank removal userscript - don't open links in new tabs
// ==UserScript==
// @name No New Tabs
// @match *
// @grant none
// ==/UserScript==
(function() {
document.querySelectorAll('a[target]').forEach((link) => {
link.setAttribute('target', '_self');
link.setAttribute('rel', 'noopener noreferrer');
@y4rr
y4rr / esnextbin.md
Created October 26, 2019 14:43
esnextbin sketch
@y4rr
y4rr / ublock-resources.txt
Created November 20, 2019 09:42
ublock-resources.txt
# Resources to be used as redirect destinations.
#
# - Each distinct resource entry is separated by an empty line.
# - The first line in a resource entry is: token mime-type[;encoding]
# - All following lines are the data. An empty line signals the end of the
# data.
#
# If the encoding is absent, the data will be converted to base64, and the
# encoding will be set to `;base64`.
@y4rr
y4rr / README.MD
Last active January 23, 2020 16:08 — forked from nzec/README.MD
DeezLoader Offical Page

Deezloader Remix

(Recommended)

Available for macOS, Linux, Windows.

In the process of a rewrite. Final release will be v4.2.0. The repository might get DMCA' so, make Git Clones/Forks
You can compile yourself now to test for bugs (See rewrite branch in the Git repository)

@y4rr
y4rr / CSSValueKeywords.txt
Created January 7, 2021 02:40
WebKit CSSValueKeywords.in
//
// CSS value names
//
inherit
initial
unset
revert
//
// CSS_PROP_OUTLINE_STYLE
@y4rr
y4rr / anatomy-of-an-html-element.markdown
Created July 28, 2021 18:20
Anatomy of an HTML element

Anatomy of an HTML element

The main parts of our element are:

  1. The opening tag: This consists of the name of the element (in this case, p), wrapped in opening and closing angle brackets. This states where the element begins, or starts to take effect — in this case where the start of the paragraph is.
  2. The closing tag: This is the same as the opening tag, except that it includes a forward slash before the element name. This states where the element ends — in this case where the end of the paragraph is. Failing to include a closing tag is a common beginner error, and can lead to strange results.
  3. The content: This is the content of the element, which in this case is just text.
  4. The attribute: Contains the extra information about the element which you don't want to appear in the actual content (optional).
  5. The HTML element: The opening tag, plus the closing tag, plus the content, plus attributes (optional), equals the element.