| -- | |
| -- This is SQL query to extract AddressBook info from respective sqlite3 file from iOS backup. | |
| -- It has been tested only on my own backup, so, if anything is wrong, fork, edit, and stuff. | |
| -- | |
| -- # parse-manifest.py from http://stackoverflow.com/questions/3085153/how-to-parse-the-manifest-mbdb-file-in-an-ios-4-0-itunes-backup | |
| -- | |
| -- $ python ../parse-manifest.py | grep AddressBook.sqlitedb | |
| -- -rw-r--r-- 000001f5 000001f5 1654784 1312812502 1312812502 1287387943 (31bb7ba8914766d4ba40d6dfb6113c8b614be442)HomeDomain::Library/AddressBook/AddressBook.sqlitedb | |
| -- | |
| -- $ sqlite3 31bb7ba8914766d4ba40d6dfb6113c8b614be442 |
| # Nothing to see here | |
| shinyServer(function(input, output) { | |
| }) |
| -- Do a backup to iTunes and open "%APPDATA%\Apple Computer\MobileSync\Backup\*\3d0d7e5fb2ce288813306e4d4636395e047a3d28" as a SQLite database | |
| SELECT chat.chat_identifier, message.is_from_me, datetime(message.date + 978307201, 'unixepoch') as date, message.text | |
| FROM chat | |
| JOIN chat_message_join on chat.ROWID = chat_message_join.chat_id | |
| JOIN message on message.ROWID = chat_message_join.message_id | |
| order by message.date |
| #!/usr/bin/python | |
| import json | |
| import sys | |
| import os | |
| import datetime | |
| import codecs | |
| import sqlite3 | |
| import re | |
| import struct |
| admin account info" filetype:log | |
| !Host=*.* intext:enc_UserPassword=* ext:pcf | |
| "# -FrontPage-" ext:pwd inurl:(service | authors | administrators | users) "# -FrontPage-" inurl:service.pwd | |
| "AutoCreate=TRUE password=*" | |
| "http://*:*@www” domainname | |
| "index of/" "ws_ftp.ini" "parent directory" | |
| "liveice configuration file" ext:cfg -site:sourceforge.net | |
| "parent directory" +proftpdpasswd | |
| Duclassified" -site:duware.com "DUware All Rights reserved" | |
| duclassmate" -site:duware.com |
| FROM php:7.1.2-apache | |
| RUN docker-php-ext-install mysqli |
| # Converts an iPhone SMS.db file into HTML | |
| # Mac: Library > Application Support > MobileSync > Backup | |
| # Windows: C:\Users\<user name>\AppData\Roaming\Apple Computer\MobileSync\Backup | |
| # Find the folder with the most recently modified date and open it. | |
| # Locate the 3d0d7e5fb2ce288813306e4d4636395e047a3d28 file and copy it to the location of this script. | |
| # Rename the file to "db.sqlite" | |
| # Replace HANDLE_GOES_HERE with the phone number/etc identifying the other party in the DB. | |
| # Run the script. | |
| require "sqlite3" |
| #!/usr/bin/python3 | |
| import sys | |
| import sqlite3 | |
| import datetime | |
| import base64 | |
| def convert_ab_time(tmx): | |
| epoch = datetime.datetime(2001, 1, 1) | |
| return epoch + datetime.timedelta(seconds=float(tmx)) |
Note: This gist may be outdated, thanks to all contributors in comments.
adb is the Android CLI tool with which you can interact with your android device, from your PC
You must enable developer mode (tap 7 times on the build version in parameters) and install adb on your PC.
Don't hesitate to read comments, there is useful tips, thanks guys for this !
| curl "https://marketplace.atlassian.com/rest/2/addons?application=jira&filter=popular&limit=100" | jq '._embedded.addons[]| [.name, .key, ._embedded.distribution.totalUsers, ._embedded.distribution.downloads]|@csv'|sed 's/\\//g'|sed 's/^\"//'| sed 's/\"$//'|tee -a jira.addons.csv |
