Bitcoin Forum
September 19, 2019, 09:59:40 AM *
News: Latest Bitcoin Core release: 0.18.1 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Number of earned Merit during the last 120 days (counted automatically)  (Read 277 times)
1miau
Hero Member
*****
Offline Offline

Activity: 490
Merit: 1354


ChipMixer Miau


View Profile WWW
March 28, 2019, 01:05:23 AM
 #1

Does someone know about a tool where it's possible to count the received Merit for the last 120 days automatically? Counting all Merits manually is still possible but not very fast (depending on the number of earned Merit)

The only site I know is this one, but it's limited to a few accounts: https://bitcointalk.org/index.php?action=merit;stats=topusers

Someone asked this today in the German local board.

If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it.  Wink

1568887180
Hero Member
*
Offline Offline

Posts: 1568887180

View Profile Personal Message (Offline)

Ignore
1568887180
Reply with quote  #2

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

Posts: 1568887180

View Profile Personal Message (Offline)

Ignore
1568887180
Reply with quote  #2

1568887180
Report to moderator
tbct_mt2
Sr. Member
****
Offline Offline

Activity: 644
Merit: 395



View Profile
March 28, 2019, 01:52:55 AM
 #2

If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it.  Wink
You forgot about @Vod, who created the BPIP site for bitcointalk community months ago.
He can do it for sure if he want.

          ███████
      ██   ▀███▀   ██
  ▄█▄  ▄▄█████████▄▄  ▄█▄
 ▄███▄██▀▀       ▀▀██▄███▄
 ██▀███    ▄▄█▄█    ███▀██
    ██      █▀▀██    ██
██  ██     █████▀    ██  ██
    ██   ▄▄█▄▄▄██    ██
 ██▄███    █▀█▀▀    ███▄██
 ▀███▀██▄▄       ▄▄██▀███▀
  ▀██  ▀▀█████████▀▀  ██▀
      ██   ▄███▄   ██
          ███████
bspin   ███████████████████████
███████████████████████████
███████████████████████████
███████▀█▀    ▀▀▀██▀███████
███████            ▄███████
███████ ▄██▄▄▄▄▄▀ ▄████████
███ ▀  ▀  ██▀▀   ▄▀  ▀  ███
███▄▄█▀  █▀     █▄▄█▀  ████
█████   █▀       ██   █████
████▄▄▄▄█▄▄▄▄▄▄▄▄█▄▄▄▄█████
███████████████████████████
███████████████████████████
  ███████████████████████
       ▄▄█████████▄▄
    ▄█████████████████▄
  ▄█████████████████████▄
 ▄█████████  █  █████████▄
▄████████        █████████▄
███████████  ██  ██████████
███████████       █████████
███████████  ███  █████████
▀████████        ▄████████▀
 ▀█████████  █  █████████▀
  ▀█████████████████████▀
    ▀█████████████████▀
       ▀▀█████████▀▀
█████
██
██
██
██
██
██
██
██
██
██
██
█████
.
PLAY NOW
█████
██
██
██
██
██
██
██
██
██
██
██
█████
r1s2g3
Sr. Member
****
Offline Offline

Activity: 630
Merit: 387


I am alive but in hibernation.


View Profile
March 28, 2019, 02:00:44 AM
 #3

I guess I can put a custom query in Piggy sql tool but only issue is Piggy database is updated on Friday.(not the real time updates)

Did not checked DdmrDdmr Merit dashboard.

Unfortunately Vod is only displaying data and do not provide any privilege to do Data Analytics on it.


Does someone know about a tool where it's possible to count the received Merit for the last 120 days automatically? Counting all Merits manually is still possible but not very fast (depending on the number of earned Merit)

The only site I know is this one, but it's limited to a few accounts: https://bitcointalk.org/index.php?action=merit;stats=topusers

Someone asked this today in the German local board.

If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it.  Wink

These are recent merits, may be last 30 days, not 120 days as you thought.

.
Game that
pays for
Playing











A
blockchain
based game
Ask me anything
about the game
in Bitcointalk.











A game
that recognize
your ownership
Join the
exciting game
of splinterlands











              ▄▄▄▄▄▄██████▄▄▄▄▄▄
          ▄▄██████████████████████▄▄
        ███████▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀███████
     ████████▌    ▄▄▄▄▄▄▄▄    ▐████████
   ▄██████████▌  █████ ▀ ▀███  ▐██████████▄
  ▐███████████▌ ████▄▄ ██ ▐███ ▐███████████▌
  ████████████▌▐█████     ████▌▐████████████
 █████████████▌ ███▄▄ ██ ▐████ ▐█████████████
 █████████████▌  ███    ▄████  ▐█████████████
██████████████▌    ▀▀▀▀▀▀▀▀    ▐██████████████
██████████████████████████████████████████████
▀████████████████████████████████████████████▀
   ▐██████████████████████████████████████▌
   ▐█████████████▀▀▀▀▀▀▀▀▀▀▀▀█████████████▌
    ▀▀██████▀▀                  ▀▀██████▀▀
Vod
Legendary
*
Offline Offline

Activity: 2870
Merit: 2291


Licking my boob since 1970


View Profile WWW
March 28, 2019, 02:48:29 AM
 #4

If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it.  Wink
You forgot about @Vod, who created the BPIP site for bitcointalk community months ago.
He can do it for sure if he want.

Thx.  Smiley

Already done:
https://bpip.org/smerit.aspx?to=&from=&start=&end=&min=&max=

Just put profile name after to= and 120 days ago in start=

I'm into creating universes, smiting people, writing holy books and listening to Prayer Messages (PMs).
BitcoinTalk Public Information Project (BPIP)  - BPIP Reports
"Masturbation makes you feel good but doesn't do anything for the person you're thinking of.  Just like prayer."
DarkStar_
Legendary
*
Offline Offline

Activity: 1456
Merit: 2005


KnowNoBorders.io


View Profile WWW
March 28, 2019, 02:57:39 AM
 #5

If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it.  Wink
You forgot about @Vod, who created the BPIP site for bitcointalk community months ago.
He can do it for sure if he want.

Thx.  Smiley

Already done:
https://bpip.org/smerit.aspx?to=&from=&start=&end=&min=&max=

Just put profile name after to= and 120 days ago in start=

The site doesn't seem to include the sum of all merits in that 120 day period, which is what 1miau is asking for I believe. As a workaround, you can copy the output given by BPIP and it formats nicely in Google Sheets (and I assume Excel):



You can then easily sum the values.

tbct_mt2
Sr. Member
****
Offline Offline

Activity: 644
Merit: 395



View Profile
March 28, 2019, 03:45:41 AM
 #6

https://bpip.org/smerit.aspx?to=&from=&start=&end=&min=&max=

Just put profile name after to= and 120 days ago in start=
Did I search it right, Vod?
Results seems to be wrong, that is not the feature should show.
Please correct me if I made something wrong when searching.
https://bpip.org/smerit.aspx?to=Hhampuz&from=&start=120&end=&min=&max=

          ███████
      ██   ▀███▀   ██
  ▄█▄  ▄▄█████████▄▄  ▄█▄
 ▄███▄██▀▀       ▀▀██▄███▄
 ██▀███    ▄▄█▄█    ███▀██
    ██      █▀▀██    ██
██  ██     █████▀    ██  ██
    ██   ▄▄█▄▄▄██    ██
 ██▄███    █▀█▀▀    ███▄██
 ▀███▀██▄▄       ▄▄██▀███▀
  ▀██  ▀▀█████████▀▀  ██▀
      ██   ▄███▄   ██
          ███████
bspin   ███████████████████████
███████████████████████████
███████████████████████████
███████▀█▀    ▀▀▀██▀███████
███████            ▄███████
███████ ▄██▄▄▄▄▄▀ ▄████████
███ ▀  ▀  ██▀▀   ▄▀  ▀  ███
███▄▄█▀  █▀     █▄▄█▀  ████
█████   █▀       ██   █████
████▄▄▄▄█▄▄▄▄▄▄▄▄█▄▄▄▄█████
███████████████████████████
███████████████████████████
  ███████████████████████
       ▄▄█████████▄▄
    ▄█████████████████▄
  ▄█████████████████████▄
 ▄█████████  █  █████████▄
▄████████        █████████▄
███████████  ██  ██████████
███████████       █████████
███████████  ███  █████████
▀████████        ▄████████▀
 ▀█████████  █  █████████▀
  ▀█████████████████████▀
    ▀█████████████████▀
       ▀▀█████████▀▀
█████
██
██
██
██
██
██
██
██
██
██
██
█████
.
PLAY NOW
█████
██
██
██
██
██
██
██
██
██
██
██
█████
Vod
Legendary
*
Offline Offline

Activity: 2870
Merit: 2291


Licking my boob since 1970


View Profile WWW
March 28, 2019, 04:04:38 AM
Merited by 1miau (1)
 #7


120 days ago would be about this:
https://bpip.org/smerit.aspx?to=Hhampuz&from=&start=11/27/18&end=&min=&max=

I now show number of records on the bottom
still working on the summation.

I'm into creating universes, smiting people, writing holy books and listening to Prayer Messages (PMs).
BitcoinTalk Public Information Project (BPIP)  - BPIP Reports
"Masturbation makes you feel good but doesn't do anything for the person you're thinking of.  Just like prayer."
tbct_mt2
Sr. Member
****
Offline Offline

Activity: 644
Merit: 395



View Profile
March 28, 2019, 04:09:49 AM
 #8

120 days ago would be about this:
https://bpip.org/smerit.aspx?to=Hhampuz&from=&start=11/27/18&end=&min=&max=

I now show number of records on the bottom
still working on the summation.
It works fine, but I thought that it might be better if you add Search box, then searcher can type account name and start day to search, rather than directly typing it into the browser.

          ███████
      ██   ▀███▀   ██
  ▄█▄  ▄▄█████████▄▄  ▄█▄
 ▄███▄██▀▀       ▀▀██▄███▄
 ██▀███    ▄▄█▄█    ███▀██
    ██      █▀▀██    ██
██  ██     █████▀    ██  ██
    ██   ▄▄█▄▄▄██    ██
 ██▄███    █▀█▀▀    ███▄██
 ▀███▀██▄▄       ▄▄██▀███▀
  ▀██  ▀▀█████████▀▀  ██▀
      ██   ▄███▄   ██
          ███████
bspin   ███████████████████████
███████████████████████████
███████████████████████████
███████▀█▀    ▀▀▀██▀███████
███████            ▄███████
███████ ▄██▄▄▄▄▄▀ ▄████████
███ ▀  ▀  ██▀▀   ▄▀  ▀  ███
███▄▄█▀  █▀     █▄▄█▀  ████
█████   █▀       ██   █████
████▄▄▄▄█▄▄▄▄▄▄▄▄█▄▄▄▄█████
███████████████████████████
███████████████████████████
  ███████████████████████
       ▄▄█████████▄▄
    ▄█████████████████▄
  ▄█████████████████████▄
 ▄█████████  █  █████████▄
▄████████        █████████▄
███████████  ██  ██████████
███████████       █████████
███████████  ███  █████████
▀████████        ▄████████▀
 ▀█████████  █  █████████▀
  ▀█████████████████████▀
    ▀█████████████████▀
       ▀▀█████████▀▀
█████
██
██
██
██
██
██
██
██
██
██
██
█████
.
PLAY NOW
█████
██
██
██
██
██
██
██
██
██
██
██
█████
DdmrDdmr
Hero Member
*****
Offline Offline

Activity: 616
Merit: 2672

There are lies, damned lies and statistics. MTwain


View Profile WWW
March 28, 2019, 06:00:15 AM
Last edit: March 28, 2019, 08:11:32 AM by DdmrDdmr
Merited by 1miau (1)
 #9

The Merit Dashboard does that. Simply go to the "Received Merit" tab, and adjust the date range slider to the date interval required (i.e. between date x and date y), be it 120 days or other. By default it shows all history. Then enter the user name or user Id on the boxes on the right side of the screen.

You should see (data as of last Friday):
- the total amount of merits earned by the forum member in the timeframe (on the right side of the screen, under the name).
- the amount received per rank in that timeframe.
- a breakdown by month.
- a breakdown by day.
- a summary of the forum names that merited the profile, and amounts, in the timeframe.

To change the username or id, just click on the parameter box, press the "x’ to delete current parameter, and type in a new name.

Note that the software, Tableau Public will timeout after around four minutes of inactivity, so if that happens, the date range may need to be provided again.

You can also see (on the "Rankings" tab) the most merited profiles in a given timeframe and board.

LoyceV
Legendary
*
Offline Offline

Activity: 1610
Merit: 4625


Largest Merit Circle on BPIP!


View Profile WWW
March 28, 2019, 07:32:11 AM
Last edit: March 28, 2019, 03:33:47 PM by LoyceV
Merited by 1miau (1)
 #10

If there is no tool yet I'm sure that LoyceV or DdmrDdmr will do a good job in creating it.  Wink
I can make it, but does it have to be 100% accurate? A rough overview might be better for the purpose of assessing a signature campaign candidate. This is yours:
Image loading...
Data updated until last Friday's data dump, each column is 5 days, the maximum height is 100 Merit (in 5 days), if a user earned more, the top of the column gets darker.
To post it, insert userID in this code:
Code:
[img alt=Image loading...]http://loyce.club/Merit/history/img/userID_blue.gif[/img]
A campaign manager could even request candidates to post it. Note that I also provide BBCode for the full Merit history on http://loyce.club/Merit/history/2143453.html.

tranthidung
Hero Member
*****
Online Online

Activity: 588
Merit: 648


LiveCoin - is a modern stock exchange


View Profile
March 28, 2019, 02:09:12 PM
 #11

Using your code, then this is mine, that looks like a random walk.
Shocked
Image loading...

█████████▄           ▄█
▀██▄         ██
▀██▄    ▄▄ ██
▀███ ███ ██
█████████▄        ▀▀ ██
▀██▄      ▄▄ ██
▄█████████ ███ ██
▄██▀          ▀▀ ██
████
█▀            ▄▄ ██
▄██ ███ ██
▄██▀   ▀▀ ██
▄██▀        ██
███████████▀          ▀█




▄▄█
█████
█████
█████
█████
█████

█████

█████

█████


▄▄█
█████
█████
█████
█████
█████
█████
█████

█████

█████

█████
▄▄█
█████
█████
█████
█████
█████
█████
█████
█████
█████

█████

█████

█████
█▄           ▄█████████
██         ▄██▀
██ ▄▄    ▄██▀
██ ███ ███▀
██ ▀▀        ▄█████████
██ ▄▄      ▄██▀
██ ███ █████████▄
██ ▀▀          ▀██▄
██ ▄▄            ▀█████
██ ███ ██▄
██ ▀▀   ▀██▄
██        ▀██▄
█▀          ▀███████████
tbct_mt2
Sr. Member
****
Offline Offline

Activity: 644
Merit: 395



View Profile
March 28, 2019, 02:57:42 PM
 #12

I think I made a summary from all available solutions raised by some users, there:
Tools for managers to check quality of posts (both merited & unmerited posts)
Feel free to leave your comment if you think I should improve the topic's contents, please.

          ███████
      ██   ▀███▀   ██
  ▄█▄  ▄▄█████████▄▄  ▄█▄
 ▄███▄██▀▀       ▀▀██▄███▄
 ██▀███    ▄▄█▄█    ███▀██
    ██      █▀▀██    ██
██  ██     █████▀    ██  ██
    ██   ▄▄█▄▄▄██    ██
 ██▄███    █▀█▀▀    ███▄██
 ▀███▀██▄▄       ▄▄██▀███▀
  ▀██  ▀▀█████████▀▀  ██▀
      ██   ▄███▄   ██
          ███████
bspin   ███████████████████████
███████████████████████████
███████████████████████████
███████▀█▀    ▀▀▀██▀███████
███████            ▄███████
███████ ▄██▄▄▄▄▄▀ ▄████████
███ ▀  ▀  ██▀▀   ▄▀  ▀  ███
███▄▄█▀  █▀     █▄▄█▀  ████
█████   █▀       ██   █████
████▄▄▄▄█▄▄▄▄▄▄▄▄█▄▄▄▄█████
███████████████████████████
███████████████████████████
  ███████████████████████
       ▄▄█████████▄▄
    ▄█████████████████▄
  ▄█████████████████████▄
 ▄█████████  █  █████████▄
▄████████        █████████▄
███████████  ██  ██████████
███████████       █████████
███████████  ███  █████████
▀████████        ▄████████▀
 ▀█████████  █  █████████▀
  ▀█████████████████████▀
    ▀█████████████████▀
       ▀▀█████████▀▀
█████
██
██
██
██
██
██
██
██
██
██
██
█████
.
PLAY NOW
█████
██
██
██
██
██
██
██
██
██
██
██
█████
1miau
Hero Member
*****
Offline Offline

Activity: 490
Merit: 1354


ChipMixer Miau


View Profile WWW
March 28, 2019, 10:55:38 PM
 #13

The site doesn't seem to include the sum of all merits in that 120 day period, which is what 1miau is asking for I believe.
Exactly, someone asked it for the new signature campaigns of Hhampuz. xD


120 days ago would be about this:
https://bpip.org/smerit.aspx?to=Hhampuz&from=&start=11/27/18&end=&min=&max=

I now show number of records on the bottom
still working on the summation.
Thanks, looks great and if the total received Merit is implemented that would be a fast method for everyone to look it up.


The Merit Dashboard does that. Simply go to the "Received Merit" tab, and adjust the date range slider to the date interval required (i.e. between date x and date y), be it 120 days or other. By default it shows all history. Then enter the user name or user Id on the boxes on the right side of the screen.
I just tried it, works very well  Smiley





I can make it, but does it have to be 100% accurate?
Well, there are already a few variants posted above but it's always a good idea to have multiples ones. If you have time and want to go for some cycled Merits, why not.  Tongue

A campaign manager could even request candidates to post it. Note that I also provide BBCode for the full Merit history on http://loyce.club/Merit/history/2143453.html.
+1
Interesting how that would work out. The campaign manager posts a link and description how to do it: http://loyce.club/Merit/history/[your user-ID].html
And set is as requirement to join. Just a suggestion.
Maybe you can set it as requirement for your next campaign to select participants. Wink

Thx for your answers everyone!

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!