Bitcoin Forum
November 21, 2019, 05:28:58 AM *
News: 10th anniversary art contest
 
   Home   Help Search Login Register More  
Pages: « 1 2 3 [4] 5 6 »  All
  Print  
Author Topic: Full merit transaction history for any user - with GRAPHS, BANS and BBCode!  (Read 25294 times)
LoyceV
Legendary
*
Offline Offline

Activity: 1680
Merit: 5171


Largest Merit Circle on BPIP!


View Profile WWW
June 22, 2018, 05:18:37 AM
Last edit: June 26, 2018, 04:03:05 PM by LoyceV
Merited by JayJuanGee (1)
 #61

Nice, that does seem to work perfectly, very impressive Loyce! If it doesn't take that much storage or resources, it makes me wonder why theymos isn't doing that "officially".
Theymos generates the merit history "on the fly", and said the main reason not to keep it forever is because adding pagination is a lot of work.
Without pagination, it will eventually give time-outs, just like some people have a hard time viewing their ignore list, or loading long trust lists (I think that's why the trust page doesn't show the trust summary of other people anymore).


I still need to automate uploading, once done, I'll update the OP and this thread becomes obsolete a link to the real data.

1574314138
Hero Member
*
Offline Offline

Posts: 1574314138

View Profile Personal Message (Offline)

Ignore
1574314138
Reply with quote  #2

1574314138
Report to moderator
1574314138
Hero Member
*
Offline Offline

Posts: 1574314138

View Profile Personal Message (Offline)

Ignore
1574314138
Reply with quote  #2

1574314138
Report to moderator
1574314138
Hero Member
*
Offline Offline

Posts: 1574314138

View Profile Personal Message (Offline)

Ignore
1574314138
Reply with quote  #2

1574314138
Report to moderator
The Bitcoin Forum is turning 10 years old! Join the community in sharing and exploring the notable posts made over the years.
DdmrDdmr
Hero Member
*****
Offline Offline

Activity: 686
Merit: 2864


There are lies, damned lies and statistics. MTwain


View Profile WWW
June 22, 2018, 05:30:07 AM
 #62

<...>
Works nicely, well done. I would suggest editing the OP to reflect this change as it is important to see at the beginning of the thread.

mdayonliner
Sr. Member
****
Offline Offline

Activity: 490
Merit: 364


I always respected forum rules even private ones


View Profile WWW
June 22, 2018, 09:09:09 AM
Last edit: June 22, 2018, 09:19:17 AM by mdayonliner
 #63

Example: http://loycevsbasement.privatedns.org/Merit/history/459836.html is my full history. Change the userID to any other user that has either received or sent merit. Each user mentioned on the link has a link to his own history.
Fantastic work! It worked correct for me. Consider this as a confirmation. http://loycevsbasement.privatedns.org/Merit/history/1432468.html

PS: I wanted to merit you for the post but then again I thought not to waste one of my merit since you are both a Legendary member and a merit source. By the way, In your mind you can set a merit from me Tongue Good work again bud.

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.
LoyceV
Legendary
*
Offline Offline

Activity: 1680
Merit: 5171


Largest Merit Circle on BPIP!


View Profile WWW
June 26, 2018, 11:07:26 AM
Last edit: July 02, 2018, 11:54:37 AM by LoyceV
 #64

I'm experimenting with making a graph per user, showing the number of Merit sent and received per week.

bill gator
Legendary
*
Offline Offline

Activity: 1218
Merit: 1042


CryptoTalk.Org - Get Paid for every Post!


View Profile
June 26, 2018, 03:41:39 PM
 #65

Without pagination, it will eventually give time-outs, just like some people have a hard time viewing their ignore list, or loading long trust lists (I think that's why the trust page doesn't show the trust summary of other people anymore).

You've taught me a new word, had to look up "pagination". After doing a bit of reading I still don't particularly understand exactly what is lacking currently. Does that mean, in this case, that a more modular approach would be required? I'm trying to understand exactly what is causing the time-outs, and exactly what pagination means in this context.

Thanks for another tool on my bookmark list, Loyce. I also don't understand how this thread would become obsolete, if you are still accomplishing the original goal; just accomplishing it more efficiently. Maybe this is just going over my head, but I'd say this is anything but obsolete.

 
                                . ██████████.
                              .████████████████.
                           .██████████████████████.
                        -█████████████████████████████
                     .██████████████████████████████████.
                  -█████████████████████████████████████████
               -███████████████████████████████████████████████
           .-█████████████████████████████████████████████████████.
        .████████████████████████████████████████████████████████████
       .██████████████████████████████████████████████████████████████.
       .██████████████████████████████████████████████████████████████.
       ..████████████████████████████████████████████████████████████..
       .   .██████████████████████████████████████████████████████.
       .      .████████████████████████████████████████████████.

       .       .██████████████████████████████████████████████
       .    ██████████████████████████████████████████████████████
       .█████████████████████████████████████████████████████████████.
        .███████████████████████████████████████████████████████████
           .█████████████████████████████████████████████████████
              .████████████████████████████████████████████████
                   ████████████████████████████████████████
                      ██████████████████████████████████
                          ██████████████████████████
                             ████████████████████
                               ████████████████
                                   █████████
.CryptoTalk.org.|.MAKE POSTS AND EARN BTC!.🏆
LoyceV
Legendary
*
Offline Offline

Activity: 1680
Merit: 5171


Largest Merit Circle on BPIP!


View Profile WWW
June 26, 2018, 04:06:45 PM
 #66

You've taught me a new word, had to look up "pagination".
I got it from theymos too Tongue

Quote
After doing a bit of reading I still don't particularly understand exactly what is lacking currently. Does that mean, in this case, that a more modular approach would be required? I'm trying to understand exactly what is causing the time-outs, and exactly what pagination means in this context.
Pagination is what you see under this page:
Pages: « 1 2 3 [4]  All
Well, I don't think the "All" is pagination, the rest is.

I think the time-outs were caused by loading too much data at once (just guessing here).

Quote
I also don't understand how this thread would become obsolete
Good point. My original idea was to have a bot running in this thread, the obsolete means there's no point requesting data anymore, as it's already available.

Jet Cash
Legendary
*
Offline Offline

Activity: 1442
Merit: 1797


Trying to preserve our heritage.


View Profile WWW
June 26, 2018, 04:21:42 PM
 #67

Is there a way to back up the merit tree to try to detect merit rings?
I'll explain what I meant - A receives 5 sMerits from B, These were generated by awards of 10 sMerits from C, created by 20 sMerits from D, and so on. Of course any awards by merit sources will not have been created by awards. A, B. C, D and others may be the same member if it is part of a loop. I'm not sure if this sequence is trackable, as sMerits are not unique, but just go into a pool.

I've added a photography section to Fit to Talk -  The photography and content production board

Hopefully we can use this to help members earn from using budget photo kit whilst they practice their English
LoyceV
Legendary
*
Offline Offline

Activity: 1680
Merit: 5171


Largest Merit Circle on BPIP!


View Profile WWW
June 26, 2018, 04:29:22 PM
 #68

Is there a way to back up the merit tree to try to detect merit rings?
It has too too many variables, so I'll pass on this one.

Jet Cash
Legendary
*
Offline Offline

Activity: 1442
Merit: 1797


Trying to preserve our heritage.


View Profile WWW
June 26, 2018, 04:38:34 PM
 #69


It has too too many variables, so I'll pass on this one.

That was my feeling as well. I wondered if it was possible to create a cluster diagram based on a single post with high merit.

I've added a photography section to Fit to Talk -  The photography and content production board

Hopefully we can use this to help members earn from using budget photo kit whilst they practice their English
LoyceV
Legendary
*
Offline Offline

Activity: 1680
Merit: 5171


Largest Merit Circle on BPIP!


View Profile WWW
June 26, 2018, 05:29:58 PM
 #70

I'm experimenting with making a graph per user, showing the number of Merit sent and received per week.
Preliminary results: this would be satoshi's graph of Received Merit, which I want to publish on http://loycevsbasement.privatedns.org/Merit/history/3.html.

Image loading...

Current settings:
-column width: 10 pixels (5 days)
-"days" start the second the first Merit was transfered, and count exactly 5*3600*24 seconds after that. It has nothing to do with calendar days in any time zone
-column height: 3 pixel per Merit
-maximum of 200 Merit per period, darker color at the top if the bar has been cropped
It still needs something on the axes.

It has space to grow in width, but I think it's too high for the layout. I'm now thinking to make it a maximum of 200 pixels high, with 2 Merit per pixel. That means most users will have a few blue dots at the bottom only.

I need comments Cheesy

LoyceV
Legendary
*
Offline Offline

Activity: 1680
Merit: 5171


Largest Merit Circle on BPIP!


View Profile WWW
June 27, 2018, 11:20:01 AM
 #71

This looks better (height limited to 100 Merit per 5 days):
Image loading...

LoyceV
Legendary
*
Offline Offline

Activity: 1680
Merit: 5171


Largest Merit Circle on BPIP!


View Profile WWW
June 29, 2018, 07:15:05 PM
Last edit: June 29, 2018, 07:31:01 PM by LoyceV
 #72

I've added graphs to each user's Merit history. These are mine:
Merit sent by LoyceV:
Image loading...
Merit received by LoyceV:
Image loading...
I didn't expect such a large difference between "now" and when Merit was introduced!

Each column width is 5 days (10 pixels). "Days" start the second the first Merit was transfered, and count exactly 5*3600*24 seconds after that. It has nothing to do with calendar days in any time zone
The maximum is 100 Merit per column (2 pixels per Merit). If more than 100 Merit was transfered in a 5 day period, the top of the column gets darker.
It still needs something on the axes.

In a next run, I'll change the background from white to gray. That should make it easier to see the edges of the graph, especially for users with only a few Merit transactions.

mdayonliner
Sr. Member
****
Offline Offline

Activity: 490
Merit: 364


I always respected forum rules even private ones


View Profile WWW
June 29, 2018, 07:45:31 PM
 #73

~
Mine looks opposite  Tongue




Another good work mate. Seems like you are having fun with all these data analysis, graph drawing etc.

PS: May be we need an outside boarder line with legend for better visual. Like below:


If it's something too hard to waste your time then don't bother. Smiley

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.
LoyceV
Legendary
*
Offline Offline

Activity: 1680
Merit: 5171


Largest Merit Circle on BPIP!


View Profile WWW
June 29, 2018, 08:00:40 PM
 #74

Mine looks opposite  Tongue
I guess that means you're developing. I like the easy overview it gives.

Quote
Another good work mate. Seems like you are having fun with all these data analysis, graph drawing etc.
I got sucked in, and one thing led to another Tongue I still haven't completed my TODO, and it already takes several hours to process all data. I didn't need to worry about efficiency before, but it's a lot of data by now.

Quote
PS: May be we need a outside boarder line with legend for better visual.
I'm not really into graphics design, but if I have a design, I can easily merge it around my graph.
Horizontal lines look good too!

If you can make the graph look better, please do so and send me the changes to add.

mdayonliner
Sr. Member
****
Offline Offline

Activity: 490
Merit: 364


I always respected forum rules even private ones


View Profile WWW
June 29, 2018, 08:11:07 PM
 #75

If you can make the graph look better, please do so and send me the changes to add.
I have this admin panel theme. It has all sorts of demo charts including the Bar Chart.


I have both php and html version of the theme. Not sure if that's gonna help you in any way. If it does then I can PM you the zip of theme.

PS: Thanks for all these exclusive work you and other guys are doing for better visualization of merit transactions.

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.
LoyceV
Legendary
*
Offline Offline

Activity: 1680
Merit: 5171


Largest Merit Circle on BPIP!


View Profile WWW
July 05, 2018, 06:54:14 PM
Last edit: July 08, 2018, 08:45:22 AM by LoyceV
 #76

I have this admin panel theme. It has all sorts of demo charts including the Bar Chart.

That looks good, but it's too complicated to add. I just want something simple to show on the axes.

Quote
PS: Thanks for all these exclusive work you and other guys are doing for better visualization of merit transactions.
Thanks, I like doing it anyway Smiley

LoyceV
Legendary
*
Offline Offline

Activity: 1680
Merit: 5171


Largest Merit Circle on BPIP!


View Profile WWW
July 11, 2018, 12:27:23 PM
Last edit: July 13, 2018, 09:50:56 AM by LoyceV
 #77

The graphs make it easy to spot abuse. If someone suddenly sends and receives a large amount, such as this user (see reference), it's easy to follow where it came from and where his sMerits are going to.

tranthidung
Hero Member
*****
Offline Offline

Activity: 644
Merit: 850


Merit system boosts post quality in average !


View Profile
July 11, 2018, 01:14:33 PM
Merited by paxmao (1)
 #78

I recommend @LoyceV to use box plots to show the distributions of merits.
The type of plot help readers easier to see outliers.
I also give you link to see how to graph box plots using R-software.
StatMethods to graph BoxPlots using R



Boxplots are very relevant when you want to compare the average and outliers of merit distributions on different boards, ranks, etc.




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

#1 CRYPTO CASINO & SPORTSBOOK
  WELCOME
BONUS
.INSTANT & FAST.
.TRANSACTION.....
.PROVABLY FAIR.
......& SECURE......
.24/7 CUSTOMER.
............SUPPORT.
BTC      |      ETH      |      LTC      |      XRP      |      XMR      |      BNB      |     more
LoyceV
Legendary
*
Offline Offline

Activity: 1680
Merit: 5171


Largest Merit Circle on BPIP!


View Profile WWW
July 11, 2018, 02:35:49 PM
 #79

I recommend @LoyceV to use box
That's too much for creating graphs manually (pixel for pixel).

LoyceV
Legendary
*
Offline Offline

Activity: 1680
Merit: 5171


Largest Merit Circle on BPIP!


View Profile WWW
July 19, 2018, 08:51:30 AM
 #80

Bump for visibility, updated last Friday.

Pages: « 1 2 3 [4] 5 6 »  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!