Bitcoin Forum
July 23, 2019, 08:34:40 AM *
News: Latest Bitcoin Core release: 0.18.0 [Torrent] (New!)
 
   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 19379 times)
LoyceV
Legendary
*
Online Online

Activity: 1554
Merit: 4322


Self-made Legendary outside Meta!


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.

1563870880
Hero Member
*
Offline Offline

Posts: 1563870880

View Profile Personal Message (Offline)

Ignore
1563870880
Reply with quote  #2

1563870880
Report to moderator
1563870880
Hero Member
*
Offline Offline

Posts: 1563870880

View Profile Personal Message (Offline)

Ignore
1563870880
Reply with quote  #2

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

Posts: 1563870880

View Profile Personal Message (Offline)

Ignore
1563870880
Reply with quote  #2

1563870880
Report to moderator
1563870880
Hero Member
*
Offline Offline

Posts: 1563870880

View Profile Personal Message (Offline)

Ignore
1563870880
Reply with quote  #2

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

Activity: 560
Merit: 2452

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: 363


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
*
Online Online

Activity: 1554
Merit: 4322


Self-made Legendary outside Meta!


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
Copper Member
Legendary
*
Offline Offline

Activity: 1120
Merit: 1026



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

Activity: 1554
Merit: 4322


Self-made Legendary outside Meta!


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: 1316
Merit: 1700


TEMP and VOM member and monderator.


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.

££&$$>  Find out about rail biking in the Jet Cash coffee lounge thread on the Ivory Tower board. <££&$$.
LoyceV
Legendary
*
Online Online

Activity: 1554
Merit: 4322


Self-made Legendary outside Meta!


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: 1316
Merit: 1700


TEMP and VOM member and monderator.


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.

££&$$>  Find out about rail biking in the Jet Cash coffee lounge thread on the Ivory Tower board. <££&$$.
LoyceV
Legendary
*
Online Online

Activity: 1554
Merit: 4322


Self-made Legendary outside Meta!


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
*
Online Online

Activity: 1554
Merit: 4322


Self-made Legendary outside Meta!


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
*
Online Online

Activity: 1554
Merit: 4322


Self-made Legendary outside Meta!


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: 363


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
*
Online Online

Activity: 1554
Merit: 4322


Self-made Legendary outside Meta!


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: 363


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
*
Online Online

Activity: 1554
Merit: 4322


Self-made Legendary outside Meta!


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
*
Online Online

Activity: 1554
Merit: 4322


Self-made Legendary outside Meta!


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

Activity: 532
Merit: 407


★Bitvest.io★ Play Plinko or Invest!


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.



BIG WINNER!
[15.00000000 BTC]


▄████████████████████▄
██████████████████████
██████████▀▀██████████
█████████░░░░█████████
██████████▄▄██████████
███████▀▀████▀▀███████
██████░░░░██░░░░██████
███████▄▄████▄▄███████
████▀▀████▀▀████▀▀████
███░░░░██░░░░██░░░░███
████▄▄████▄▄████▄▄████
██████████████████████
▀████████████████████▀
▄████████████████████▄
██████████████████████
█████▀▀█▀▀▀▀▀▀██▀▀████
█████░░░░░░░░░░░░░▄███
█████░░░░░░░░░░░░▄████
█████░░▄███▄░░░░██████
█████▄▄███▀░░░░▄██████
█████████░░░░░░███████
████████░░░░░░░███████
███████░░░░░░░░███████
███████▄▄▄▄▄▄▄▄███████
██████████████████████
▀████████████████████▀
▄████████████████████▄
███████████████▀▀▀▀▀▀▀
███████████▀▀▄▄█░░░░░█
█████████▀░░█████░░░░█
███████▀░░░░░████▀░░░▀
██████░░░░░░░░▀▄▄█████
█████░▄░░░░░▄██████▀▀█
████░████▄░███████░░░░
███░█████░█████████░░█
███░░░▀█░██████████░░█
███░░░░░░████▀▀██▀░░░░
███░░░░░░███░░░░░░░░░░
▀██░▄▄▄▄░████▄▄██▄░░░░
▄████████████▀▀▀▀▀▀▀██▄
█████████████░█▀▀▀█░███
██████████▀▀░█▀░░░▀█░▀▀
███████▀░▄▄█░█░░░░░█░█▄
████▀░▄▄████░▀█░░░█▀░██
███░▄████▀▀░▄░▀█░█▀░▄░▀
█▀░███▀▀▀░░███░▀█▀░███░
▀░███▀░░░░░████▄░▄████░
░███▀░░░░░░░█████████░░
░███░░░░░░░░░███████░░░
███▀░██░░░░░░▀░▄▄▄░▀░░░
███░██████▄▄░▄█████▄░▄▄
▀██░████████░███████░█▀
▄████████████████████▄
████████▀▀░░░▀▀███████
███▀▀░░░░░▄▄▄░░░░▀▀▀██
██░▀▀▄▄░░░▀▀▀░░░▄▄▀▀██
██░▄▄░░▀▀▄▄░▄▄▀▀░░░░██
██░▀▀░░░░░░█░░░░░██░██
██░░░▄▄░░░░█░██░░░░░██
██░░░▀▀░░░░█░░░░░░░░██
██░░░░░▄▄░░█░░░░░██░██
██▄░░░░▀▀░░█░██░░░░░██
█████▄▄░░░░█░░░░▄▄████
█████████▄▄█▄▄████████
▀████████████████████▀




Rainbot
Daily Quests
Faucet
LoyceV
Legendary
*
Online Online

Activity: 1554
Merit: 4322


Self-made Legendary outside Meta!


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
*
Online Online

Activity: 1554
Merit: 4322


Self-made Legendary outside Meta!


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!