Bitcoin Forum
September 18, 2019, 12:20:57 PM *
News: If you like a topic and you see an orange "bump" link, click it. More info.
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Tool it may help spot abusers/alts  (Read 143 times)
Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1376



View Profile WWW
July 04, 2018, 07:16:51 AM
Last edit: July 04, 2018, 08:42:55 AM by Piggy
Merited by Micio (8)
 #1

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



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,
'<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"
1568809257
Hero Member
*
Offline Offline

Posts: 1568809257

View Profile Personal Message (Offline)

Ignore
1568809257
Reply with quote  #2

1568809257
Report to moderator
1568809257
Hero Member
*
Offline Offline

Posts: 1568809257

View Profile Personal Message (Offline)

Ignore
1568809257
Reply with quote  #2

1568809257
Report to moderator
PLAY NOW
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1568809257
Hero Member
*
Offline Offline

Posts: 1568809257

View Profile Personal Message (Offline)

Ignore
1568809257
Reply with quote  #2

1568809257
Report to moderator
mdayonliner
Sr. Member
****
Offline Offline

Activity: 490
Merit: 363


I always respected forum rules even private ones


View Profile WWW
July 04, 2018, 08:24:35 AM
 #2

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

I could not stand the lies against me anymore. I can not prove them wrong too. It's better I live in peace.
So, I am willingly locking mdayonliner. Thank you BitcoinTalk. Be addictive, be a Bitcoiner.
Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1376



View Profile WWW
July 04, 2018, 08:34:48 AM
 #3

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.
khufuking
Sr. Member
****
Offline Offline

Activity: 840
Merit: 266



View Profile WWW
July 04, 2018, 08:35:57 AM
 #4

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 .

████████              ████████
 ▀███████     █      ███████▀      ▄▄▄▄▄▄▄▄▄▄▄▄▄  ▄▄▄▄▄      ▄▄▄▄                               ▄▄         ▄▄▄        ▄▄▄▄▄▄▄▄▄▄▄▄▄   ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
   ▀██████   ███    ██████▀    ▄▄█████████████▀   █████      ████              ▄██▄             ███▄       ███    ▄▄█████████████▀    █████████████▀
     ▀███▌ ▄██ ██▄ █████▀     ██████▀▀▀▀▀▀▀▀▀     █████      ████            ▄██████▄           █████▄     ███   ██████▀▀▀▀▀▀▀▀▀      ████▀▀▀▀▀▀▀▀ 
       █▀▄███   █ ████▀      █████▀               ███████████████          ▄██████████▄         ███████▄   ███  █████▀     ▄▄▄▄▄▄▄▄   ████▄▄▄▄▄▄▄▄▄▄▄
       ▄████     ███▀▄       █████                ███████████████        ▄█████▀ ▀██████▄       ███ ▀████▄ ███  █████    ▄█████████   █████████████▀
     ▄█████ ▐█  ██▌▄███▄      █████▄              █████      ████      ▄█████▀     ▀██████▄     ███   ▀███████   █████▄        ████   ████
   ▄██████ ▐██ ██  ██████▄     ███████████████▀   █████      ████    ▄█████▀  ▄█████████████▄   ███     ▀█████    █████████████████   █████████████▀
 ▄██████     ███    ███████▄    ▀▀██████████▀     █████      ████  ▄█████▀  ▄█████████████████▄ ███       ▀███     ▀▀██████████████   ███████████▀
███████       █      ████████


▬▬▬▬▬▬▬▬▬▬▬▬▬▬
██████
██
██
██
██
██
██
██
██
██
██
██
██████
██████
██
██
██
██
██
██
██
██
██
██
██
██████
[
.BUY TOKEN!.
]██████
██
██
██
██
██
██
██
██
██
██
██
██████
        ▄▄████████▄▄
     ▄████████████████▄
   ▄████████████████████▄
  ███████████████▀▀  █████
 ████████████▀▀      ██████
▐████████▀▀   ▄▄     ██████▌
▐████▀▀    ▄█▀▀     ███████▌
▐████████ █▀        ███████▌
 ████████ ▄███▄   ███████
  ████████████████▄▄██████
   ▀████████████████████▀
     ▀████████████████▀
        ▀▀████████▀▀
██████
██
██
██
██
██
██
██
██
██
██
██
██████
Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1376



View Profile WWW
July 04, 2018, 09:16:23 AM
 #5

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.
mdayonliner
Sr. Member
****
Offline Offline

Activity: 490
Merit: 363


I always respected forum rules even private ones


View Profile WWW
July 04, 2018, 09:58:00 AM
Merited by Piggy (1)
 #6

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.

I could not stand the lies against me anymore. I can not prove them wrong too. It's better I live in peace.
So, I am willingly locking mdayonliner. Thank you BitcoinTalk. Be addictive, be a Bitcoiner.
Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!