This script takes no input, recurses the known h-sphere table relations, looks for rows which do not have matching parent_child.child_id, outputs detail and overall stats at…
SLOG of Carl Heaton Posts
This script takes a h-sphere account_id and attempts to recurse the entire parent_child tree and fetch data from known associated tables. The list of associations is not complete but easily edited. Called with beast.php?account_id=123. It is intended only to give insight and a quick view of the H-Sphere account and associations.
Unwrap SSL http(s) communications using sslsplit and hosts file; for development / niche purposes only.
I route all of my non-work related home internet connectivity via an external jurisdiction (pfSense, openVPN and VPS based) which is great, however Amazon Video and Netflix traffic is significant and I don’t wish to abuse my “fair use” of the virtual server provider when the traffic is all SSL by default / only associates my connection as a user of Netflix. I use the following domains (pfsense host alias) and netblocks (pfsense net alias) to add custom routes to exclude Netflix traffic from the default route / going over VPN, but you can use the same list to include your traffic to VPN endpoints in other geographic regions.
Many members of parliament.uk choose to host their websites outside of the UK (or blindly follow their political parties choice of provider), I look at who they are.
As the subject suggests after parsing parliament.uk for a list of all MP websites and twitter accounts, I performed DNS queries against each websites domain…
I needed to get a list of all websites for UK members of parliament and have it update reasonably frequently / ability to repeat.
http://www.parliament.uk/mps-lords-and-offices/mps/ lists all the current members so a simple PHP script was written using http://simplehtmldom.sourceforge.net/ to parse the list of members, fetch each member profile and parse the name, website and twitter handles.
This script in all it’s hackyness may be found below (best run via php-cli to minimise timeout or memory issues) and example output at http://slog.carlheaton.co.uk/list-of-all-uk-members-of-parliament-name-website-twitter-handle/
Parsed contents of http://www.parliament.uk/mps-lords-and-offices/mps/ to CSV for name, website, twitter as of 2016/11/11.