konarkmodi

# Make sure you run curl 'https://whotracks.me/data/trackerdb.json' > orig_whotracksme.json
import json

company_mapping = {}
f = json.loads(open('orig_whotracksme.json').read())
for tracker_name, details in f['trackers'].items():
	company_id = details['company_id']
	company_name = f['companies'].get(company_id, {'name': 'unknown'})['name']
	for each_hostname in details['domains']:
		company_mapping[each_hostname] = company_name

konarkmodi

sqlite3 ~/Library/Messages/chat.db 'select datetime(message.date + strftime("%s", "2001-01-01 00:00:00"), "unixepoch", "localtime") as "DATE", message.text as "Message", chat.chat_identifier as "Recipient", CASE(message.is_from_me) when 0 THEN "No" WHEN 1 THEN "Yes" END as "Me" from (select chat_id, message_id from chat_message_join) as 'master' INNER JOIN message ON  message.ROWID = master.message_id INNER JOIN chat ON chat.ROWID = master.chat_id;';

konarkmodi

Tracker	    : URL
Bluekai	    : http://www.bluekai.com/registry/
Facebook	  : https://www.facebook.com/ads/preferences
Yahoo	      : https://aim.yahoo.com/aim/us/en/optout/
Google	    : http://www.google.com/ads/preferences/view

konarkmodi

import pyodbc
connection_string = "DRIVER=FreeTDS;SERVER=;DATABASE=;UID=;PWD=;tds_version=8.0;port=1433"
conn = conn=pyodbc.connect(connection_string)
result_fetch = conn.execute(sql_query)

konarkmodi

PYTHON=/usr/bin/python2.6    # set this to whichever python version you want to install for.

mkdir -p $HOME/bin $HOME/lib $HOME/src $HOME/tmp

export TMPDIR=$HOME/tmp
export PATH="$HOME/bin:$PATH"
export C_INCLUDE_PATH="$HOME/include:$C_INCLUDE_PATH"
export LIBRARY_PATH="$HOME/lib:$LIBRARY_PATH"
export LD_LIBRARY_PATH="$HOME/lib:$LD_LIBRARY_PATH"