Konark Modi konarkmodi
konarkmodi
/ tracker_mapping.py
Created
July 15, 2019 12:18
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # 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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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-ad-preferences
Last active
August 26, 2016 11:13
To list what the trackers know about you.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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" |