Author

Topic: visualise trustlists (Read 148 times)

legendary
Activity: 2268
Merit: 18509
March 22, 2018, 07:35:54 AM
#2
This would also be very useful for user "Annon001" to use in his thread regarding the Default Trust network.

Thanks for sharing.
legendary
Activity: 3388
Merit: 4919
https://merel.mobi => buy facemasks with BTC/LTC
March 22, 2018, 06:58:06 AM
#1
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

*
Code:
+-------------------+--------------+------+-----+---------+----------------+
| 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.txt

EDIT: 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 Smiley
Jump to: