Tool it may help spot abusers/alts | Bitcointalksearch.org

mdayonliner

copper member

Activity: 630

Merit: 420

We are Bitcoin!

Quote from: Piggy on July 04, 2018, 03:34:48 AM

I was thinking to make it in here because it may be a place where people doing investigations read and they could make the most out of it. In any case if it makes more sense to have it in Meta let's move it in there, as long as the "Merit investigators" have a chance to know there are tools to make their work easier.

May be this topic worth having both in Meta and this section.

If I am not wrong then most of the "merit investigators" do hangout in the meta section and they have notification on for that board. I recently activated my email notification for Reputation section where for the meta section, my email notification was on from the very beginning. I wanted to give you a real example, it's up to you to chose the right 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.

By the way, I forgot to mention - Good work again.

Piggy

hero member

Activity: 784

Merit: 1416

Look for example this case:

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

and found this:

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

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:

Quote

Done.

khufuking

sr. member

Activity: 840

Merit: 266

Wow man this is just amazing, this visualization is indeed can link accounts to each others too, this is a tool not just for bust Merit abusing but might be really helpful in connecting accounts with each others, in some cases if not most we will find that what lay behind Merit abuse is multi accounting, a blue circle surrounded by only red circles is a good indicating that this blue circle is even have a connection with a lot of tagged accounts (raise a red flag) or this blue circle is trying to boost its state with tagged bought accounts .

Piggy

hero member

Activity: 784

Merit: 1416

Quote from: mdayonliner on July 04, 2018, 03:24:35 AM

I am surprised to see it on the Reputation section. Isn't it more appropriate on the meta section?

I was thinking to make it in here because it may be a place where people doing investigations read and they could make the most out of it. In any case if it makes more sense to have it in Meta let's move it in there, as long as the "Merit investigators" have a chance to know there are tools to make their work easier.

mdayonliner

copper member

Activity: 630

Merit: 420

We are Bitcoin!

I am surprised to see it on the Reputation section. Isn't it more appropriate on the meta section?

Piggy

hero member

Activity: 784

Merit: 1416

Hi,

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

https://bitcointalksearch.org/topic/interact-explore-the-merit-network-4584759

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

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:

Example 2:

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 question 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,
'' || fromid || '' as Sender,
'' || toid || '' as Receiver,
merit,
'Link Merited post' 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,
'' || fromid || '' as Sender,
'' || toid || '' as Receiver,
merit,
'Link Merited post' as MeritedPost
FROM meritdata
Inner Join UserData on UserData.userid = meritdata.toid
WHERE UserData.Username like "theymos"

Topic: Tool it may help spot abusers/alts (Read 204 times)