Just a quick meta script i wrote and wanted so share just in case somebody else ever needs it... It's a script that runs on my local PC, so i didn't make the script safe, readable, reusable or adaptable... It's just a quick-and-dirty script to run on a private machine.
Demo of my own trustlist, 2 levels deep
Why did i write the script? I'm tracking an althoarder who uses an army of alts to bump his own threads, self-vouch, discredit competitors, backstab, give himself positive trust,... while at the same time preaching against everything he's actually doing himself. This dude made a huge effort not to post any identifyable information ever, but he messed up by putting a lot of "untrustable" users in his trustlist (alts), giving +ve to alts, giving -ve to "enemies", removing "enemies" from his trustlist... So i needed a tool to visualise a trust network... Since it didn't existed, i wrote one myself
In order to use this one, you'll need
- A mysql database
- A pc/server running python 2.7
- R
I'm going to skip some of the most scripts (just do it yourself), i'll just provide a little walktrough and focus on the most difficult script
- download the latest trust dump (https://www.bitcointalk.org/trust.txt.xz)
- parse the textfile, import the dump into a mysql table...* the truster goes into "username", the person being trusted in "trustee" and if a person is actually removed from somebody's trustlist (by adding ~{username}), the relation_positive = 0
- run the script **
- open r
- source("path_output_pythonscript/trustlistnetwork.r")
- my_plot.png will be written to c:\tmp
*
+-------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+----------------+
| id | int(6) | NO | PRI | NULL | auto_increment |
| username | varchar(128) | YES | MUL | NULL | |
| relation_positive | int(1) | YES | MUL | NULL | |
| trustee | varchar(128) | YES | MUL | NULL | |
+-------------------+--------------+------+-----+---------+----------------+
**
bitcointalk is not allowing me to post the script... Cloudflare again... you can find the script here:
https://www.mocacinno.com/scripts/trustlistnetwork.txtEDIT: I release this script as an open source script, feel free to download it, adapt it, share it with others... As long as everybody understands that the script waswritten for private use on a private computer, and that i take no responsability for anything that might happen if you run this script