Bitcoin Forum

Other => Meta => Topic started by: Piggy on July 04, 2018, 10:21:20 AM



Title: Tool it may help spot abusers/alts - Re-post from Reputation board
Post by: Piggy on July 04, 2018, 10:21:20 AM
(Opened initially this on Reputation with the idea most "Merit/alts investigators" would be in there but turn out they may be actually in here as well, if you are an Investigator, i suggest you read this, it may make your work easier)

Hi,

i had made this tool visualization of the Merit Network to find merit sources:

https://bitcointalk.org/index.php?topic=4584759.0

But actually found out it may be good to find abusers as well. This visualization show the merit connections happened between users and in one of these version i marked also the red trust level for each user:

In here you can see who was red trusted(red), who is not(azure) and who is trusted (green) Updated to Sunday 1st of July

Link to the tool below: https://albertoit.github.io/Merit-Network-Visualization/?config=config_Trust.json

https://albertoit.github.io/Merit-Network-Visualization/images/2a.png

Now if you move along the peripheral area of this circle you see in the picture, you will notice a lot of points (users) isolated from the rest, these could be transactions happened between alts or abuse in general(some in fact were already spotted as you can see):

Example 1:
https://i.imgur.com/7d4UX9w.png
Example 2:

https://i.imgur.com/y6WQPY7.png




If anybody has the time and will to go through these would be quite convenient as you can see immediately:

  • Suspicius exchanges of merits between users
  • If the user was already red trusted
  • If any people he had some exchange was red trusted
  • Clicking on the node you get information about rank - merit sent and received in general

If you have any questions ask.


More over: when you have identified some person of interest, you can use this other tool to output a list of the merit transactions with clickable links to the user profiles and message merited in the forum

Go here: https://albertoit.github.io/Merit-Explorer-SQL/

You can specify in the last line the name of the user you want to search for ( in this example theymos)

Code:
 WHERE UserData.Username like "theymos"

paste this in the box to see the merit sent from the user
Code:
SELECT 
date,
'<a href=https://bitcointalk.org/index.php?action=profile;u=' || fromid || '>' || fromid || '</a>' as Sender,
'<a href=https://bitcointalk.org/index.php?action=profile;u=' || toid || '>' || toid || '</a>' as Receiver,
merit,
'<a href=https://bitcointalk.org/index.php?topic=' || msg || '#' || substr(msg,instr(msg,'.')+1) || '>Link Merited post</a>' as MeritedPost
FROM meritdata
Inner Join UserData on UserData.userid = meritdata.fromid
WHERE UserData.Username like "theymos"

paste this in the box to see the merit received from theymos
Code:
SELECT 
date,
'<a href=https://bitcointalk.org/index.php?action=profile;u=' || fromid || '>' || fromid || '</a>' as Sender,
'<a href=https://bitcointalk.org/index.php?action=profile;u=' || toid || '>' || toid || '</a>' as Receiver,
merit,
'<a href=https://bitcointalk.org/index.php?topic=' || msg || '#' || substr(msg,instr(msg,'.')+1) || '>Link Merited post</a>' as MeritedPost
FROM meritdata
Inner Join UserData on UserData.userid = meritdata.toid
WHERE UserData.Username like "theymos"



One real case research example

i went here: https://albertoit.github.io/Merit-Network-Visualization

and found this user hrbt:
https://i.imgur.com/psAl11K.png

then go to see the same in here: https://albertoit.github.io/Merit-Network-Visualization/?config=config_Trust.json

https://i.imgur.com/equ02sa.png

Run this query in here: https://albertoit.github.io/Merit-Explorer-SQL/

Code:
SELECT 
date,
'https://bitcointalk.org/index.php?action=profile;u=' || fromid,
'https://bitcointalk.org/index.php?action=profile;u=' || toid,
merit,
'https://bitcointalk.org/index.php?topic=' || msg || '#' || substr(msg,instr(msg,'.')+1)
FROM meritdata
Inner Join UserData on UserData.userid = meritdata.fromid
WHERE UserData.Username like "hrbt"

Result, i display the links of: who sent, who received and a link to the message merited:

Quote
2018-02-17T16:20:47   https://bitcointalk.org/index.php?action=profile;u=340808   https://bitcointalk.org/index.php?action=profile;u=1349874   15   https://bitcointalk.org/index.php?topic=2495721.msg30181948#msg30181948
2018-02-16T13:50:44   https://bitcointalk.org/index.php?action=profile;u=340808   https://bitcointalk.org/index.php?action=profile;u=1031556   50   https://bitcointalk.org/index.php?topic=2728315.msg30370848#msg30370848
2018-02-15T21:15:19   https://bitcointalk.org/index.php?action=profile;u=340808   https://bitcointalk.org/index.php?action=profile;u=1005975   50   https://bitcointalk.org/index.php?topic=2728315.msg30354958#msg30354958
2018-02-14T16:33:51   https://bitcointalk.org/index.php?action=profile;u=340808   https://bitcointalk.org/index.php?action=profile;u=1192328   50   https://bitcointalk.org/index.php?topic=2211728.msg30188246#msg30188246

Done, the situation in here is pretty clear.



Title: Re: Tool it may help spot abusers/alts - Re-post from Reputation board
Post by: mdayonliner on July 04, 2018, 10:28:48 AM
(Opened initially this on Reputation with the idea most "Merit/alts investigators" would be in there but turn out they may be actually in here as well, if you are an Investigator, i suggest you read this, it may make your work easier)
Also I hope a mod can enlighten us in what condition/s a topic can be on more than one board.
However, I have seen somewhere a mod said you can have same topic in more than one board. May be - you want to look for the reference or if any mod gives a feedback in here then it would be nice.

Good to see the topic here as well.


Title: Re: Tool it may help spot abusers/alts - Re-post from Reputation board
Post by: locsta123 on July 04, 2018, 09:23:06 PM
wow this is pretty intense and interesting I don't quite understand it, but pretty cool none the less. So it is used to find people that are abusing the merit system? Because you will see merit sent over and over to the same user or something like that?


Title: Re: Tool it may help spot abusers/alts - Re-post from Reputation board
Post by: Piggy on July 05, 2018, 07:38:42 AM
wow this is pretty intense and interesting I don't quite understand it, but pretty cool none the less. So it is used to find people that are abusing the merit system? Because you will see merit sent over and over to the same user or something like that?

Yes, could be used to find people which potentially abused the merit system and their alts.
When you see a small group of nodes completely detached from the network having connections with each other or with one of the node in particular, maybe something is up. You can  have a confirmation eventually by looking at the comments merited as i did with the example above.



Title: Re: Tool it may help spot abusers/alts - Re-post from Reputation board
Post by: Jet Cash on July 05, 2018, 08:15:31 AM
I'm on the wrong computer at the moment, but I can see that there could be a positive use for this analysis, as well as the negative hunt for abusers.

I'll have a look later to see if I can improve my policy for awarding merits.


Title: Re: Tool it may help spot abusers/alts - Re-post from Reputation board
Post by: Piggy on July 06, 2018, 06:32:51 AM
Out of curiosity i just run a search for people using the same ETH address in the Location field in their account, these are probably alts.

Quote
https://bitcointalk.org/index.php?action=profile;u=1110734      1110734 rxthree Full Member     0: -0 / +0      0x326cbF5717f237105fdEdf539e874718AA002387
https://bitcointalk.org/index.php?action=profile;u=1323940      1323940 miang   Member  0: -0 / +0      0x326cbF5717f237105fdEdf539e874718AA002387
https://bitcointalk.org/index.php?action=profile;u=1250508      1250508 benhnghenghiep  Member  0: -0 / +0      0x3e2bDDe6a4698884655119D8bd5189d6737d1284
https://bitcointalk.org/index.php?action=profile;u=1295809      1295809 phieudu2601     Member  0: -0 / +0      0x3e2bDDe6a4698884655119D8bd5189d6737d1284
https://bitcointalk.org/index.php?action=profile;u=959415       959415  alexflow        Sr. Member      0: -0 / +0
0x7B2C6cB5bE1a99118ce38e373d58adF04d8e6719
https://bitcointalk.org/index.php?action=profile;u=1510954      1510954 Vetal1908       Member  0: -0 / +0      0x7B2C6cB5bE1a99118ce38e373d58adF04d8e6719
https://bitcointalk.org/index.php?action=profile;u=1099442      1099442 artmen007       Full Member     0: -0 / +0
0x85772Bd514F9eEcab0b845555DA432305C98aeB9
https://bitcointalk.org/index.php?action=profile;u=1218094      1218094 foggywhite007   Member  0: -0 / +0      0x85772Bd514F9eEcab0b845555DA432305C98aeB9
https://bitcointalk.org/index.php?action=profile;u=1293974      1293974 Asklepion       Member  0: -0 / +0      0x8B5Da3e29E968B743A8fb00914c5053bdf750e6e
https://bitcointalk.org/index.php?action=profile;u=1522872      1522872 ALAYBEY Jr. Member      0: -0 / +0      0x8B5Da3e29E968B743A8fb00914c5053bdf750e6e
https://bitcointalk.org/index.php?action=profile;u=1091878      1091878 kriticko29      Full Member     0: -0 / +0
0xD6Dd6860339352f244b1cdAF324e7d4e3b8Cc966
https://bitcointalk.org/index.php?action=profile;u=1302482      1302482 crisnel26       Member  0: -0 / +0      0xD6Dd6860339352f244b1cdAF324e7d4e3b8Cc966
https://bitcointalk.org/index.php?action=profile;u=1100640      1100640 QlooQl  Full Member     0: -0 / +0      0xE759cb63228F214AF6215E5BA3c9f3FA6CD35A8d
https://bitcointalk.org/index.php?action=profile;u=1179120      1179120 rehydrogenated  Full Member     0: -0 / +0
0xE759cb63228F214AF6215E5BA3c9f3FA6CD35A8d
https://bitcointalk.org/index.php?action=profile;u=1283924      1283924 daxix   Member  0: -0 / +0      0xF0FFf892cb0b7080141aF10859e646b1E0d02cbb
https://bitcointalk.org/index.php?action=profile;u=1381793      1381793 heroy235        Member  0: -0 / +0      0xF0FFf892cb0b7080141aF10859e646b1E0d02cbb
https://bitcointalk.org/index.php?action=profile;u=1394759      1394759 luchiy2 Jr. Member      0: -0 / +0      0xF0FFf892cb0b7080141aF10859e646b1E0d02cbb
https://bitcointalk.org/index.php?action=profile;u=1454895      1454895 supermozg12     Jr. Member      0: -0 / +0
0xF0FFf892cb0b7080141aF10859e646b1E0d02cbb
https://bitcointalk.org/index.php?action=profile;u=1015910      1015910 Jerzzz  Sr. Member      0: -0 / +0      0xF6cFe73CA1F8707a6D3506C7db36155a62BD6AeC
https://bitcointalk.org/index.php?action=profile;u=1044249      1044249 Boknoyz Full Member     0: -0 / +0      0xF6cFe73CA1F8707a6D3506C7db36155a62BD6AeC
https://bitcointalk.org/index.php?action=profile;u=1079028      1079028 Chefironside    Full Member     0: -0 / +0
0xa9e882B3bfE475B345A4F9e5EAcEC9C9dc1fC3B6
https://bitcointalk.org/index.php?action=profile;u=1229096      1229096 pstraene        Member  0: -0 / +0      0xa9e882B3bfE475B345A4F9e5EAcEC9C9dc1fC3B6
https://bitcointalk.org/index.php?action=profile;u=1061902      1061902 HALLASTERA      Member  -8: -3 / +0Warning: Trade with extreme caution! 0xaBd985DCf061dd1424C3b09891cB5BbA4C35e9d1
https://bitcointalk.org/index.php?action=profile;u=1257862      1257862 kinki32 Member  -8: -3 / +0Warning: Trade with extreme caution! 0xaBd985DCf061dd1424C3b09891cB5BbA4C35e9d1
https://bitcointalk.org/index.php?action=profile;u=218075       218075  Haunebu Hero Member     0: -0 / +0      0xf3D7382e4c425A609757C42170AD168DeC5c6869
https://bitcointalk.org/index.php?action=profile;u=1102101      1102101 3kpk3   Full Member     0: -0 / +0      0xf3D7382e4c425A609757C42170AD168DeC5c6869


daxix   heroy235         luchiy2
httsupermozg12

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?id=supermozg12
Quote
Sent by supermozg12
  • 2018-01-25T15:26:07Z: 1 to luchiy2 (https://bitcointalk.org/index.php?action=profile;u=1394759) for Биpжa Binance (https://bitcointalk.org/index.php?topic=2383355.msg28873221#msg28873221)
Total Merits 1

Received by supermozg12
  • 2018-01-25T15:22:31Z: 1 from daxix (https://bitcointalk.org/index.php?action=profile;u=1283924) for 1454895 (https://bitcointalk.org/index.php?topic=2809547.msg28874069#msg28874069)
  • 2018-01-25T15:13:37Z: 1 from heroy235 (https://bitcointalk.org/index.php?action=profile;u=1381793) for 1454895 (https://bitcointalk.org/index.php?topic=2809547.msg28874069#msg28874069)
Total Merits 2



trying to put some of these name into the graph network:

Haunebu and 3kpk3   direct connection
https://i.imgur.com/CbBMDsg.png


Jerzzz  and Boknoyz not direct connection but you can see is a couple of nodes away
https://i.imgur.com/0h1GpMQ.png


Title: Re: Tool it may help spot abusers/alts - Re-post from Reputation board
Post by: TheBeardedBaby on October 25, 2018, 06:43:18 AM
So sad that it's outdated now. I almost forgot about it.


Title: Re: Tool it may help spot abusers/alts - Re-post from Reputation board
Post by: Piggy on October 25, 2018, 07:44:49 AM
So sad that it's outdated now. I almost forgot about it.

I will update it again one of these days, the problem is that takes some time, as require few iterations and tools to come up with this result.


Title: Re: Tool it may help spot abusers/alts - Re-post from Reputation board
Post by: wwzsocki on May 18, 2019, 07:30:08 PM
I will update it again one of these days...

Sorry that I post in such an old thread but this tools seems to be very useful but are not updated from a very long time.

Merit Network Visualization tool still works with no problems (just checked) and maybe this is possible to update with the latest merit data.



Title: Re: Tool it may help spot abusers/alts - Re-post from Reputation board
Post by: Piggy on May 20, 2019, 05:23:36 AM
Sorry that I post in such an old thread but this tools seems to be very useful but is not updated from a very long time.

Merit Network Visualization tool still works with no problems (just checked) and maybe this is possible to update with the latest merit data.



Unfortunately is quite time consuming to get it updated, since it's involving working with different tools i wrote before and after having the all graph layout ready in gephi (https://gephi.org/). I don't have much time on my hands to do it.  :-\