Bitcoin Forum
April 09, 2020, 02:57:42 PM *
News: Latest Bitcoin Core release: 0.19.1 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1] 2 3 4 »  All
  Print  
Author Topic: Swiss army knife Tool to query Merit data online - Full History  (Read 19287 times)
Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1407



View Profile WWW
June 11, 2018, 02:55:46 PM
Last edit: August 03, 2018, 01:25:13 PM by Piggy
Merited by Welsh (11), LoyceV (5), redsn0w (5), finaleshot2016 (4), bones261 (2), Avirunes (2), Cyrus (1), JayJuanGee (1), franckuestein (1), EastSound (1), Coin-1 (1), DdmrDdmr (1), Makkara (1), fillippone (1)
 #1

I created a tool to query the all history of merit transactions, for any need you may find useful.
There are a series of parameter that can be passed into the url to get the data you want. It could also be used in here as a way to show some transaction simply by posting a link.

The data is updated to the 8th of June. Give it a try, the instructions are below with some ready example.

The result table has embedded links for users, which are pointing back to the full merit history within the tool itself, to the user profile page in bitcointalk  and a ready link to jump to the comment merited as well:

Update: copy to clipboard and forum formatting:
https://bitcointalk.org/index.php?topic=4456438.msg40512247#msg40512247


Latest Layout


Full Merit data history visualization per user


Query data visualization (can be based on merits,time,users)




Some example that can help you to get started on how to use it:

Show a single merit transaction:

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?tx=42723

Filter by users: Username need to be accurate and exactly as you see them in the forum, in case a username is not mapped you can simply use the user id.

Full merit history for Jet Cash:

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?id=Jet%20Cash

Merit sent from Jet Cash to bitmover

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?fromuser=Jet%20Cash&touser=bitmover

Filter by date:

Merit given by TMAN to TheUltraElite starting from 2018-06-01

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?fromuser=TMAN&touser=TheUltraElite&dategreater=2018-06-01

Merit given by TMAN to TheUltraElite going backward from 2018-06-01

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?fromuser=TMAN&touser=TheUltraElite&datelower=2018-06-01

Merit given by TMAN to TheUltraElite between (dates included) 2018-04-01 and 2018-05-01

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?fromuser=TMAN&touser=TheUltraElite&datelower=2018-05-01&dategreater=2018-04-01

Filter by Merit:

merit given by suchmoon >= 10

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?fromuser=suchmoon&meritgreater=10

merit given by suchmoon <= 2

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?fromuser=suchmoon&meritlower=2

merit given by suchmoon between 5 and 7 (>= 5 and <= 7)

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?fromuser=suchmoon&meritlower=7&meritgreater=5

merit given by suchmoon = 6

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?fromuser=suchmoon&meritequal=6

A combination of everything:

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?fromuser=TMAN&touser=yogg&datelower=2018-06-01&dategreater=2018-05-01&meritegreater=5&meritlower=10

Bonus:
https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?meritgreater=50

1586444262
Hero Member
*
Offline Offline

Posts: 1586444262

View Profile Personal Message (Offline)

Ignore
1586444262
Reply with quote  #2

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

Posts: 1586444262

View Profile Personal Message (Offline)

Ignore
1586444262
Reply with quote  #2

1586444262
Report to moderator
1586444262
Hero Member
*
Offline Offline

Posts: 1586444262

View Profile Personal Message (Offline)

Ignore
1586444262
Reply with quote  #2

1586444262
Report to moderator
DdmrDdmr
Hero Member
*****
Offline Offline

Activity: 826
Merit: 3672


Fuck the Coronavirus -> #StayAtHome #QuedateEnCasa


View Profile WWW
June 11, 2018, 05:54:46 PM
 #2

Looks like we've now got at least four different options to download Merit TXs surpassing the 120 day limit, so as long as some of them keep on being updated we won’t be left in the dark.

Just a couple of quick comments:

1.   The parameters are case sensitive (i.e. DdmrDdmr gives us results but not ddmrddmr when using the ToUser parameter: https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?id=DdmrDdmr) -> You have mentioned in on your post, but I dived straight in before re-reading it all... perhaps place it in bold.

2.   The links to the users once the list is brough up do not seem to work, giving a 404 (file not found) error. The Msg does work nevertheless.

Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1407



View Profile WWW
June 12, 2018, 05:22:39 AM
 #3

Looks like we've now got at least four different options to download Merit TXs surpassing the 120 day limit, so as long as some of them keep on being updated we won’t be left in the dark.

Just a couple of quick comments:

1.   The parameters are case sensitive (i.e. DdmrDdmr gives us results but not ddmrddmr when using the ToUser parameter: https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?id=DdmrDdmr) -> You have mentioned in on your post, but I dived straight in before re-reading it all... perhaps place it in bold.

2.   The links to the users once the list is brough up do not seem to work, giving a 404 (file not found) error. The Msg does work nevertheless.


Thank you for the feedback!   Wink

I made some changes to fix the missing link, now is also possible look up a user name without worrying about capital letters in it, this will give the same results:

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?id=DDMRDDMR
https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?id=ddmrddmr

I also did some improvement on the visual presentation, now it looks a bit more modern and perhaps easier to read:




DdmrDdmr
Hero Member
*****
Offline Offline

Activity: 826
Merit: 3672


Fuck the Coronavirus -> #StayAtHome #QuedateEnCasa


View Profile WWW
June 12, 2018, 06:10:53 AM
 #4

<...>
I also did some improvement on the visual presentation, now it looks a bit more modern and perhaps easier to read:
<...>
It works fine now, and it’s very fast to give the response. I like the fact that clicking on the From /To user from the list takes you to that clicked user’s history.
If you plan on enhancing it, perhaps a direct access to the profiles (such as when clicking the Msg link) would come in handy for some, but the current functionality is nice too.

Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1407



View Profile WWW
June 12, 2018, 12:35:14 PM
 #5

I just added direct link to the personal page in bitcointalk as well and a link to each single transaction within the tool itself.

If there are any other good  suggestions for some other functionality to implement i'm open to it.
Coin-1
Hero Member
*****
Online Online

Activity: 966
Merit: 898



View Profile
June 13, 2018, 07:37:51 AM
 #6

Good work, topic starter! I wonder, where have you got the list of the BitcoinTalk users? Have you parsed the forum for that? As far as I know, there is no user names in the file "merit.txt.xz".
Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1407



View Profile WWW
June 13, 2018, 01:28:36 PM
 #7

Good work, topic starter! I wonder, where have you got the list of the BitcoinTalk users? Have you parsed the forum for that? As far as I know, there is no user names in the file "merit.txt.xz".

Yes you need to parse the user profile page for each user. This job was already done by LoyceV, so i took the ready list from him
Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1407



View Profile WWW
June 16, 2018, 03:19:38 PM
 #8

This is now updated with the new merit data - 15th June, i'm planning to add directly the topic name as well, beside the link pointing directly to the merited message.
Makkara
Full Member
***
Offline Offline

Activity: 714
Merit: 123


View Profile
June 17, 2018, 11:39:29 AM
 #9

Quite a cool piece of software indeed. I see this could be quite usefull in spotting anomalies and abuses, it took me literally 1 minute to spot some shitty things going on by looking at the transactions carried out over a certain amount of merits and over a certain period of time.

It could be even more powerful if it could support full SQL like query commands, so that you can chain togheter multiple request and run more detailed searches.

Puppa!
LoyceV
Legendary
*
Offline Offline

Activity: 1820
Merit: 6138


Thick-Skinned Gang Leader


View Profile WWW
June 17, 2018, 12:08:32 PM
 #10

i'm planning to add directly the topic name as well, beside the link pointing directly to the merited message.
I can get you a list if you want.

Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1407



View Profile WWW
June 17, 2018, 06:09:14 PM
 #11

i'm planning to add directly the topic name as well, beside the link pointing directly to the merited message.
I can get you a list if you want.

I should have the information already, if i remember correctly, since i'm using it in another graph. If needed i'll ask you, thanks.


It could be even more powerful if it could support full SQL like query commands, so that you can chain togheter multiple request and run more detailed searches.

It may make sense looking into it, for performance reasons as well, as the json file become bigger it could make the access slower.
Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1407



View Profile WWW
June 18, 2018, 11:40:38 AM
 #12

Released another improvement, now you can see the title of the thread where the merits where given.

This is an example of the result you get at the moment by running a query:

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?id=suchmoon

Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1407



View Profile WWW
June 20, 2018, 10:52:43 AM
Merited by DarkStar_ (10), LoyceV (1)
 #13

Now you can export the results of a query or full merit history of a user, just click the icon to copy the results in the clipboard and they are ready to be pasted here in a message.

For example for:

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?fromuser=suchmoon&meritgreater=10

this is the formatted ouput:

Result Custom QueryTotal Merits 90

Or:

https://albertoit.github.io/Visualization/Merit%20js%20tool/filterMeritLocal.html?id=stompix

Sent by stompixTotal Merits 38

Received by stompixTotal Merits 102

Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1407



View Profile WWW
June 25, 2018, 06:06:54 AM
 #14

Updated with the latest data, Friday 22th of June
Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1407



View Profile WWW
July 08, 2018, 09:23:40 AM
 #15

Updated with the latest data from Friday 6th of July
Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1407



View Profile WWW
July 13, 2018, 11:38:43 AM
 #16

Updated with the latest data (Friday 13th of July)
Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1407



View Profile WWW
July 20, 2018, 01:23:06 PM
 #17

The tool is updated with the data from today, 20th of July.
Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1407



View Profile WWW
July 27, 2018, 04:08:22 PM
 #18

The tool is updated with the data from today, 27th of July.
Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1407



View Profile WWW
August 03, 2018, 01:24:44 PM
 #19

The tool is updated with the data from today, 3th of August.
Piggy
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1407



View Profile WWW
August 11, 2018, 05:05:52 AM
 #20

The tool is updated with the data from yesterday, 10th of August.
Pages: [1] 2 3 4 »  All
  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!