Bitcoin Forum
April 16, 2024, 09:01:25 PM *
News: Latest Bitcoin Core release: 26.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: « 1 [2] 3 4 5 6 7 »  All
  Print  
Author Topic: Tool to run online SQL queries over Full Merit Data  (Read 23312 times)
chiyenbtre
Jr. Member
*
Offline Offline

Activity: 45
Merit: 4


View Profile
July 08, 2018, 07:22:32 AM
 #21

Thank you, OP.
You made great guideline on how to use SQL to analyze merit data.
Honestly, I have never used SQL before, but I gonna learn it for sure after reading your helpful topic.
The forum was founded in 2009 by Satoshi and Sirius. It replaced a SourceForge forum.
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1713301285
Hero Member
*
Offline Offline

Posts: 1713301285

View Profile Personal Message (Offline)

Ignore
1713301285
Reply with quote  #2

1713301285
Report to moderator
Piggy (OP)
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1416



View Profile WWW
July 08, 2018, 09:26:23 AM
 #22

Thank you, OP.
You made great guideline on how to use SQL to analyze merit data.
Honestly, I have never used SQL before, but I gonna learn it for sure after reading your helpful topic.

Good, is always a nice idea learning new skills. And in this case it may be spendable elsewhere, in a working context.  Smiley
Piggy (OP)
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1416



View Profile WWW
July 11, 2018, 05:55:55 AM
Merited by TryNinja (2)
 #23

Script system

The scripting system is now ready, i may make still some small changes, in any case it can be used already. With this you can break down those few remaining limits coming from using SQL.

I was talking few days back about the problem of calculating the minimum amount of merits generated by simply receiving merits and not spent yet. That has proven to be quite difficult to be calculated solely with SQL, since trying to do many operations at the same time increase the complexity and generate convoluted queries which are hard to understand Sad
Now i can show you how this can be done in an easier and more understandable way with the new scripting system.

How it works?

It’s a mix of Javascript and SQL that get injected and executed.

How to use it:

With the scripting system you can basically use everything Javascript has to offer, i also added a set of functions to facilitate the interaction with the data:

  • PrintTableResult(query_result_data): Draw a tabulated version of the data coming from a SQL query.
  • RunSQLSynch(sql_command): Execute the SQL command specified and return an object containing the data
  • RunSQLAsynch(sql_command): Execute the SQL command in asynchronous mode, the output cannot be captured back and just show the result of the query on table
  • GetDataField(query_result_data,row_index,coulmn_index) given a query result get the field specified by row and column index
  • GetCoulmHeader(query_result_data,coulmn_index) given a query result get the header data name by column index
  • Length(query_result_data): number of rows we got from a  query result
  • WriteLine(text): output anything you want to show as a result of your operations
  • Clear(): clear the output, anything that was written or displayed

If you make some mistake in building up your script, you should get an error hinting where the problem is, however i recommend to look into the Console of your browser if you encounter some problem you cannot wrap your head around (you can open it with F12, Console tab).

In here you can find all the SQL/Script examples and info:
https://github.com/AlbertoIT/Merit-Explorer-SQL/blob/master/README.md

Link to the tool: https://albertoit.github.io/Merit-Explorer-SQL/

Any feedback appreciated, if you need help feel free to ask here



Here is an example on how to solve the problem stated above with an explanation (this is also the default script which will be loaded automatically as you select the Script tab):











Piggy (OP)
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1416



View Profile WWW
July 13, 2018, 09:50:45 AM
Last edit: July 13, 2018, 11:38:53 AM by Piggy
 #24

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

Activity: 784
Merit: 1416



View Profile WWW
July 20, 2018, 04:50:22 PM
Merited by Lakai01 (1)
 #25

The tool is updated with the data from today, 20th of July.
Lakai01
Legendary
*
Offline Offline

Activity: 2268
Merit: 2706


Top Crypto Casino


View Profile
July 24, 2018, 03:50:23 AM
 #26

Thank you very much for the effort you put into this project. I really appreciate it! I built a bunch of statements to get statistics about local boards, I am going to share them asap Smiley

█████████████████████████
████▐██▄█████████████████
████▐██████▄▄▄███████████
████▐████▄█████▄▄████████
████▐█████▀▀▀▀▀███▄██████
████▐███▀████████████████
████▐█████████▄█████▌████
████▐██▌█████▀██████▌████
████▐██████████▀████▌████
█████▀███▄█████▄███▀█████
███████▀█████████▀███████
██████████▀███▀██████████
█████████████████████████
.
BC.GAME
▄▄░░░▄▀▀▄████████
▄▄▄
██████████████
█████░░▄▄▄▄████████
▄▄▄▄▄▄▄▄▄██▄██████▄▄▄▄████
▄███▄█▄▄██████████▄████▄████
███████████████████████████▀███
▀████▄██▄██▄░░░░▄████████████
▀▀▀█████▄▄▄███████████▀██
███████████████████▀██
███████████████████▄██
▄███████████████████▄██
█████████████████████▀██
██████████████████████▄
.
..CASINO....SPORTS....RACING..
█░░░░░░█░░░░░░█
▀███▀░░▀███▀░░▀███▀
▀░▀░░░░▀░▀░░░░▀░▀
░░░░░░░░░░░░
▀██████████
░░░░░███░░░░
░░█░░░███▄█░░░
░░██▌░░███░▀░░██▌
░█░██░░███░░░█░██
░█▀▀▀█▌░███░░█▀▀▀█▌
▄█▄░░░██▄███▄█▄░░▄██▄
▄███▄
░░░░▀██▄▀


▄▄████▄▄
▄███▀▀███▄
██████████
▀███▄░▄██▀
▄▄████▄▄░▀█▀▄██▀▄▄████▄▄
▄███▀▀▀████▄▄██▀▄███▀▀███▄
███████▄▄▀▀████▄▄▀▀███████
▀███▄▄███▀░░░▀▀████▄▄▄███▀
▀▀████▀▀████████▀▀████▀▀
Piggy (OP)
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1416



View Profile WWW
July 24, 2018, 03:00:51 PM
 #27

Thank you very much for the effort you put into this project. I really appreciate it! I built a bunch of statements to get statistics about local boards, I am going to share them asap Smiley

Glad to hear it was of help. Feel free to share in here your finding, maybe other people may find it useful or get inspired Smiley
Piggy (OP)
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1416



View Profile WWW
July 27, 2018, 01:41:53 PM
 #28

Updated with the new merit data log, 27th of July

Total merits 197.570
Merit given in this last week: 3.864
Piggy (OP)
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1416



View Profile WWW
August 03, 2018, 07:29:10 AM
 #29

Updated with the latest data and few informations about the last week:

Total merit amount so far
201185

Top merit receivers in all boards in the last week:

Code:
Total Merit UserName Top merit receiver Local board
65 theyoungmillionaire Member Meta
63 dagarair Sr. Member Mining (Altcoins)
50 secousa Full Member Announcements (Altcoins)
40 BitCryptex Member Off-topic
29 ryanc Member Development & Technical Discussion
25 erguse Sr. Member Türkçe (Turkish)
22 Jet Cash Hero Member Beginners & Help
21 Spendulus Legendary Politics & Society
20 nullCoiner Sr. Member Deutsch (German)
20 DaveF Hero Member Marketplace
17 Kakmakr Legendary Bitcoin Discussion
17 yahoo62278 Legendary Trading Discussion
16 micgoossens Sr. Member Economics
15 finaleshot2016 Full Member Philippines
13 achow101 Staff Bitcoin Technical Support
12 malekcap Member Marketplace (Altcoins)
12 esmanthra Full Member Pyccкий (Russian)
10 Compiler Member Español (Spanish)
10 bittraffic Hero Member Speculation (Altcoins)
9 Steamtyme Full Member Mining
7 Shazam!!! Full Member
7 Nusa Platform Copper Member Bahasa Indonesia (Indonesian)
7 Halab Member Français
7 texgeek Jr. Member Português (Portuguese)
6 reypinyoko Newbie Altcoin Discussion
5 HostFat Staff Italiano (Italian)
4 andrew4 Jr. Member Eλληνικά (Greek)
3 slackovic Full Member Hrvatski (Croatian)
3 Vod Legendary Project Development
2 kenzawak Member Serious discussion
2 riosakamoto Full Member العربية (Arabic)
1 Arrrvin Member Nederlands (Dutch)
1 wego Sr. Member 中文 (Chinese)
1 sncc Full Member 日本語 (Japanese)

Merit distibuted per board the last week

Code:
Total Merit SubBoard
39 deleted
140 Altcoin Discussion
270 Announcements (Altcoins)
47 Bahasa Indonesia (Indonesian)
75 Beginners & Help
150 Bitcoin Discussion
16 Bitcoin Technical Support
133 Deutsch (German)
114 Development & Technical Discussion
186 Economics
31 Español (Spanish)
31 Français
14 Hrvatski (Croatian)
7 India
9 Italiano (Italian)
161 Marketplace
26 Marketplace (Altcoins)
606 Meta
45 Mining
129 Mining (Altcoins)
1 Nederlands (Dutch)
46 Off-topic
44 Philippines
76 Politics & Society
26 Português (Portuguese)
13 Project Development
8 Serious discussion
62 Speculation (Altcoins)
127 Trading Discussion
202 Türkçe (Turkish)
5 Eλληνικά (Greek)
331 Pyccкий (Russian)
6 العربية (Arabic)
2 中文 (Chinese)
2 日本語 (Japanese)


lukeburchill
Member
**
Offline Offline

Activity: 78
Merit: 17


View Profile
August 03, 2018, 08:15:36 AM
 #30

@Piggy
your tool is awesome, I tried to rebuild it in a local db (xampp).

btw,
You are a star on my local board  Grin

see one member on the local board, made a topic about the distribution of merit also he included your name with the title and said a special thank you in the last sentence.

Merit Analisis Local Indonesian (use a tool by Piggy)


Piggy (OP)
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1416



View Profile WWW
August 03, 2018, 01:23:20 PM
 #31

@Piggy
your tool is awesome, I tried to rebuild it in a local db (xampp).

btw,
You are a star on my local board  Grin

see one member on the local board, made a topic about the distribution of merit also he included your name with the title and said a special thank you in the last sentence.

Merit Analisis Local Indonesian (use a tool by Piggy)




Nice to see somebody is actually using it, i don't understand what is written, but i see there are quite interesting informations shown in there  Smiley
Piggy (OP)
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1416



View Profile WWW
August 10, 2018, 11:42:06 AM
Merited by babo (1)
 #32

Updated with the latest data of today 10th of August

Some information about last week merit distribution:

Top sender per board
Code:
Total Merit UserName Top merit sender Local board
170 chimk Full Member Pyccкий (Russian)
156 suchmoon Legendary Meta
106 suchmoon Legendary Development & Technical Discussion
83 suchmoon Legendary Economics
66 iCEBREAKER Legendary Announcements (Altcoins)
50 Vlad2Vlad Legendary Bitcoin Discussion
45 stingers Legendary Marketplace
40 dbshck Staff Bahasa Indonesia (Indonesian)
33 EFS Staff Türkçe (Turkish)
31 Halab Member Français
30 klf Legendary
25 paxmao Sr. Member Español (Spanish)
25 generalizethis Legendary Speculation (Altcoins)
22 qwk Donator Deutsch (German)
20 kellendil Hero Member Altcoin Discussion
20 grendel25 Legendary Mining (Altcoins)
19 LoyceV Legendary Beginners & Help
16 Micio Legendary Italiano (Italian)
16 Vod Legendary Project Development
16 Vod Legendary Trading Discussion
11 frodocooper Staff Mining
10 Jet Cash Hero Member Bitcoin Technical Support
10 Leonard2016 Hero Member Other languages/locations
10 theymos Administrator Serious discussion
9 Jurgen Sr. Member Nederlands (Dutch)
9 jacee Legendary Philippines
9 theymos_away Member Politics & Society
8 u9y42 Legendary Português (Portuguese)
7 RegulusHr Full Member Hrvatski (Croatian)
5 Aleister Crowley Hero Member Marketplace (Altcoins)
5 rekinthis Hero Member 中文 (Chinese)
3 irfan_pak10 Copper Member India
3 malevolent Staff Polski
3 hugeblack Sr. Member العربية (Arabic)
3 sncc Full Member 日本語 (Japanese)
2 tvbcof Legendary Off-topic
1 Spazzer Member Archival

Top receiver per board
Code:
Total Merit UserName Top merit receiver Local board
69 hilariousetc Hero Member Meta
53 satoshi Founder Bitcoin Discussion
48 Hhampuz Hero Member Marketplace
38 micgoossens Sr. Member Economics
37 MarcusMillstrom Full Member Announcements (Altcoins)
34 ICOEthics Newbie Trading Discussion
27 Jet Cash Hero Member Serious discussion
25 BitCryptex Member Development & Technical Discussion
25 yurimir Legendary Speculation (Altcoins)
21 achow101 Staff Bitcoin Technical Support
21 Cryptoshka Member Pyccкий (Russian)
19 abhiseshakana Member Bahasa Indonesia (Indonesian)
16 joulion86 Member Beginners & Help
14 squatz1 Hero Member Politics & Society
13 dagarair Sr. Member Mining (Altcoins)
13 finaleshot2016 Full Member Philippines
12 javierbaco Full Member Español (Spanish)
12 baba0000000000 Full Member Français
12 Halminer Newbie Mining
12 WaDa Full Member Türkçe (Turkish)
10 hilariousandco Global Moderator
10 BTCforJoe Hero Member Project Development
9 Valuyet Member Altcoin Discussion
9 SjoerdBakker Jr. Member Nederlands (Dutch)
8 mole0815 Full Member Deutsch (German)
6 Broon Jr. Member Archival
6 nngella Jr. Member Marketplace (Altcoins)
6 hakka Member 日本語 (Japanese)
4 RegulusHr Full Member Hrvatski (Croatian)
4 Ale88 Sr. Member Italiano (Italian)
4 texgeek Jr. Member Português (Portuguese)
2 hugeblack Sr. Member العربية (Arabic)
2 smileflowers Jr. Member 中文 (Chinese)
1 Decker Jr. Member Off-topic
1 wgd Legendary Polski
1 SergiuDemerji Member Română (Romanian)

Circulation per board

Code:
Total Merit SubBoard
10 Other languages/locations
9 Nederlands (Dutch)
3 India
10 日本語 (Japanese)
119 deleted
163 Altcoin Discussion
457 Announcements (Altcoins)
7 Archival
105 Bahasa Indonesia (Indonesian)
127 Beginners & Help
242 Bitcoin Discussion
38 Bitcoin Technical Support
77 Deutsch (German)
146 Development & Technical Discussion
415 Economics
62 Español (Spanish)
65 Français
21 Hrvatski (Croatian)
22 Italiano (Italian)
461 Marketplace
43 Marketplace (Altcoins)
644 Meta
76 Mining
114 Mining (Altcoins)
11 Off-topic
60 Philippines
32 Politics & Society
3 Polski
26 Português (Portuguese)
36 Project Development
1 Română (Romanian)
85 Serious discussion
49 Speculation (Altcoins)
127 Trading Discussion
105 Türkçe (Turkish)
617 Pyccкий (Russian)
6 العربية (Arabic)
8 中文 (Chinese)
babo
Legendary
*
Offline Offline

Activity: 3570
Merit: 4096



View Profile WWW
August 10, 2018, 01:58:44 PM
 #33

always good job and thank you for your tool and your work

Smiley

and another big bonus because your tool is opensource Wink

another merit to you

.
.BLACKJACK ♠ FUN.
█████████
██████████████
████████████
█████████████████
████████████████▄▄
░█████████████▀░▀▀
██████████████████
░██████████████
████████████████
░██████████████
████████████
███████████████░██
██████████
CRYPTO CASINO &
SPORTS BETTING
▄▄███████▄▄
▄███████████████▄
███████████████████
█████████████████████
███████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
███████████████████████
█████████████████████
███████████████████
▀███████████████▀
█████████
.
Piggy (OP)
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1416



View Profile WWW
August 17, 2018, 08:32:15 AM
Merited by babo (1)
 #34

Updated with today's data Friday 17th August, in here some weekly report to have a picture of what happened:

Top Sender last week
Code:
182 suchmoon Legendary Meta
167 chimk Full Member Pyccкий (Russian)
112 suchmoon Legendary Mining
95 bitpop Legendary Marketplace
62 suchmoon Legendary Trading Discussion
54 BobLawblaw Legendary Economics
40 Halab Member Français
37 pokerowned Legendary Announcements (Altcoins)
34 dbshck Staff Bahasa Indonesia (Indonesian)
34 paxmao Sr. Member Español (Spanish)
32 qwk Donator Deutsch (German)
25 grendel25 Legendary Mining (Altcoins)
25 EFS Staff Türkçe (Turkish)
22 Welsh Legendary Development & Technical Discussion
20 ImHash Hero Member Bitcoin Discussion
20 QuestionAuthority Legendary Off-topic
20 theymos_away Member Serious discussion
18 Svelto Sr. Member Altcoin Discussion
16 alexrossi Legendary Português (Portuguese)
14 Jet Cash Hero Member Beginners & Help
12 LoyceV Legendary Bitcoin Technical Support
10 batesresearch Legendary Marketplace (Altcoins)
10 Leonard2016 Hero Member Other languages/locations
8 RegulusHr Full Member Hrvatski (Croatian)
8 Steamtyme Full Member Politics & Society
7 suchmoon Legendary
7 Vod Legendary Project Development
6 Tipsters Sr. Member Philippines
6 adiebitsler Hero Member Speculation (Altcoins)
5 Micio Legendary Italiano (Italian)
4 hugeblack Sr. Member العربية (Arabic)
3 RAMSHIVDEEPAK Member India
3 malevolent Staff Polski
2 onlinedragon Hero Member Nederlands (Dutch)
1 Barcode_ Staff 中文 (Chinese)

Top Receiver last week
Code:
Total Merit UserName Top merit receiver Local board
105 hilariousetc Hero Member Meta
62 Hhampuz Hero Member Marketplace
53 Last of the V8s Hero Member Economics
53 crypmike Jr. Member Pyccкий (Russian)
49 MarcusMillstrom Full Member Announcements (Altcoins)
34 suchmoon Legendary Politics & Society
27 bob123 Sr. Member Development & Technical Discussion
22 friends1980 Full Member Serious discussion
20 abhiseshakana Member Bahasa Indonesia (Indonesian)
20 vit05 Full Member Off-topic
18 tyuner4 Full Member Altcoin Discussion
18 coinlocket$ Full Member Trading Discussion
13 mezzomix Legendary Deutsch (German)
13 sidehack Legendary Mining
13 finaleshot2016 Full Member Philippines
12 LoyceV Legendary Bitcoin Technical Support
12 dragonmike Hero Member Mining (Altcoins)
10 faceoff97 Full Member Beginners & Help
10 hatshepsut93 Hero Member Bitcoin Discussion
10 margoslend Full Member Marketplace (Altcoins)
10 Leteravian Member Türkçe (Turkish)
9 nysha90 Jr. Member
8 BTCHadzija Member Hrvatski (Croatian)
7 Speculatoross Member Italiano (Italian)
6 F2b Member Français
6 realknow Full Member Speculation (Altcoins)
5 MbyzIco Jr. Member Español (Spanish)
5 UmerIdrees Member Other languages/locations
4 vit05 Full Member Português (Portuguese)
3 Cryptosandy1987 Jr. Member India
3 NLNico Legendary Project Development
2 friends1980 Full Member Nederlands (Dutch)
2 samcoin Hero Member العربية (Arabic)
1 wgd Legendary Polski
1 nanna Full Member 日本語 (Japanese)

Sub boards merit circulation last week

Code:
3 India
2 Nederlands (Dutch)
70 Deleted
152 Altcoin Discussion
340 Announcements (Altcoins)
129 Bahasa Indonesia (Indonesian)
92 Beginners & Help
222 Bitcoin Discussion
67 Bitcoin Technical Support
120 Deutsch (German)
113 Development & Technical Discussion
544 Economics
46 Español (Spanish)
46 Français
27 Hrvatski (Croatian)
27 Italiano (Italian)
491 Marketplace
43 Marketplace (Altcoins)
634 Meta
78 Mining
105 Mining (Altcoins)
26 Off-topic
25 Other languages/locations
40 Philippines
82 Politics & Society
3 Polski
21 Português (Portuguese)
19 Project Development
111 Serious discussion
18 Speculation (Altcoins)
154 Trading Discussion
55 Türkçe (Turkish)
584 Pyccкий (Russian)
9 العربية (Arabic)
1 中文 (Chinese)
1 日本語 (Japanese)

Merits sent from each rank last week

Code:
Rank Total
Administrator 5
Copper Member 91
Donator 54
Full Member 576
Global Moderator 63
Hero Member 664
Jr. Member 65
Legendary 1636
Member 262
Newbie 6
Sr. Member 481
Staff 126
babo
Legendary
*
Offline Offline

Activity: 3570
Merit: 4096



View Profile WWW
August 17, 2018, 08:53:45 AM
 #35

In the russian local board i see more movimented merits
Its incredible
In italian board for example 27
In russian 590


Incredible

.
.BLACKJACK ♠ FUN.
█████████
██████████████
████████████
█████████████████
████████████████▄▄
░█████████████▀░▀▀
██████████████████
░██████████████
████████████████
░██████████████
████████████
███████████████░██
██████████
CRYPTO CASINO &
SPORTS BETTING
▄▄███████▄▄
▄███████████████▄
███████████████████
█████████████████████
███████████████████████
█████████████████████████
█████████████████████████
█████████████████████████
███████████████████████
█████████████████████
███████████████████
▀███████████████▀
█████████
.
Piggy (OP)
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1416



View Profile WWW
August 17, 2018, 09:41:27 AM
 #36

In the russian local board i see more movimented merits
Its incredible
In italian board for example 27
In russian 590


Incredible

The Russian board is not doing well only compared to any local board, but compared to any board  Smiley

Here is a detailed total recap of senders users in the Russian board for this last week

Total Merit   Sender
167   https://bitcointalk.org/index.php?action=profile;u=1202061
50   https://bitcointalk.org/index.php?action=profile;u=54484
39   https://bitcointalk.org/index.php?action=profile;u=62573
22   https://bitcointalk.org/index.php?action=profile;u=1764764
21   https://bitcointalk.org/index.php?action=profile;u=786044
15   https://bitcointalk.org/index.php?action=profile;u=830112
12   https://bitcointalk.org/index.php?action=profile;u=48075
11   https://bitcointalk.org/index.php?action=profile;u=399366
10   https://bitcointalk.org/index.php?action=profile;u=164938
10   https://bitcointalk.org/index.php?action=profile;u=186124
8   https://bitcointalk.org/index.php?action=profile;u=1083891
7   https://bitcointalk.org/index.php?action=profile;u=234771
7   https://bitcointalk.org/index.php?action=profile;u=906023
6   https://bitcointalk.org/index.php?action=profile;u=1299760
5   https://bitcointalk.org/index.php?action=profile;u=13137
5   https://bitcointalk.org/index.php?action=profile;u=498782
5   https://bitcointalk.org/index.php?action=profile;u=925231
5   https://bitcointalk.org/index.php?action=profile;u=1039323
5   https://bitcointalk.org/index.php?action=profile;u=1199798
5   https://bitcointalk.org/index.php?action=profile;u=1221497
5   https://bitcointalk.org/index.php?action=profile;u=1347520
5   https://bitcointalk.org/index.php?action=profile;u=1372318
5   https://bitcointalk.org/index.php?action=profile;u=1380108
5   https://bitcointalk.org/index.php?action=profile;u=1699073
5   https://bitcointalk.org/index.php?action=profile;u=1769892
5   https://bitcointalk.org/index.php?action=profile;u=2264347
4   https://bitcointalk.org/index.php?action=profile;u=978945
4   https://bitcointalk.org/index.php?action=profile;u=1090672
4   https://bitcointalk.org/index.php?action=profile;u=1117066
4   https://bitcointalk.org/index.php?action=profile;u=1855828
3   https://bitcointalk.org/index.php?action=profile;u=344996
3   https://bitcointalk.org/index.php?action=profile;u=485194
3   https://bitcointalk.org/index.php?action=profile;u=888882
3   https://bitcointalk.org/index.php?action=profile;u=897509
3   https://bitcointalk.org/index.php?action=profile;u=965234
3   https://bitcointalk.org/index.php?action=profile;u=1068464
3   https://bitcointalk.org/index.php?action=profile;u=1126486
3   https://bitcointalk.org/index.php?action=profile;u=1133335
3   https://bitcointalk.org/index.php?action=profile;u=1203125
3   https://bitcointalk.org/index.php?action=profile;u=1762404
2   https://bitcointalk.org/index.php?action=profile;u=220998
2   https://bitcointalk.org/index.php?action=profile;u=422621
2   https://bitcointalk.org/index.php?action=profile;u=485285
2   https://bitcointalk.org/index.php?action=profile;u=720415
2   https://bitcointalk.org/index.php?action=profile;u=899758
2   https://bitcointalk.org/index.php?action=profile;u=1064569
2   https://bitcointalk.org/index.php?action=profile;u=1071005
2   https://bitcointalk.org/index.php?action=profile;u=1101862
2   https://bitcointalk.org/index.php?action=profile;u=1110348
2   https://bitcointalk.org/index.php?action=profile;u=1117482
2   https://bitcointalk.org/index.php?action=profile;u=1299841
2   https://bitcointalk.org/index.php?action=profile;u=1324228
2   https://bitcointalk.org/index.php?action=profile;u=1334818
2   https://bitcointalk.org/index.php?action=profile;u=1412698
2   https://bitcointalk.org/index.php?action=profile;u=1511943
2   https://bitcointalk.org/index.php?action=profile;u=1548373
2   https://bitcointalk.org/index.php?action=profile;u=1671662
2   https://bitcointalk.org/index.php?action=profile;u=1772924
2   https://bitcointalk.org/index.php?action=profile;u=2097897
2   https://bitcointalk.org/index.php?action=profile;u=2145518
2   https://bitcointalk.org/index.php?action=profile;u=2223956
2   https://bitcointalk.org/index.php?action=profile;u=2245383
1   https://bitcointalk.org/index.php?action=profile;u=33631
1   https://bitcointalk.org/index.php?action=profile;u=188136
1   https://bitcointalk.org/index.php?action=profile;u=258051
1   https://bitcointalk.org/index.php?action=profile;u=289619
1   https://bitcointalk.org/index.php?action=profile;u=335282
1   https://bitcointalk.org/index.php?action=profile;u=392914
1   https://bitcointalk.org/index.php?action=profile;u=407174
1   https://bitcointalk.org/index.php?action=profile;u=459836
1   https://bitcointalk.org/index.php?action=profile;u=479945
1   https://bitcointalk.org/index.php?action=profile;u=488319
1   https://bitcointalk.org/index.php?action=profile;u=522297
1   https://bitcointalk.org/index.php?action=profile;u=539873
1   https://bitcointalk.org/index.php?action=profile;u=623643
1   https://bitcointalk.org/index.php?action=profile;u=642538
1   https://bitcointalk.org/index.php?action=profile;u=662400
1   https://bitcointalk.org/index.php?action=profile;u=749357
1   https://bitcointalk.org/index.php?action=profile;u=821756
1   https://bitcointalk.org/index.php?action=profile;u=845847
1   https://bitcointalk.org/index.php?action=profile;u=847576
1   https://bitcointalk.org/index.php?action=profile;u=896431
1   https://bitcointalk.org/index.php?action=profile;u=909172
1   https://bitcointalk.org/index.php?action=profile;u=933342
1   https://bitcointalk.org/index.php?action=profile;u=952198
1   https://bitcointalk.org/index.php?action=profile;u=990536
1   https://bitcointalk.org/index.php?action=profile;u=1037701
1   https://bitcointalk.org/index.php?action=profile;u=1064481
1   https://bitcointalk.org/index.php?action=profile;u=1096781
1   https://bitcointalk.org/index.php?action=profile;u=1100290
1   https://bitcointalk.org/index.php?action=profile;u=1112165
1   https://bitcointalk.org/index.php?action=profile;u=1165714
1   https://bitcointalk.org/index.php?action=profile;u=1291828
1   https://bitcointalk.org/index.php?action=profile;u=1302577
1   https://bitcointalk.org/index.php?action=profile;u=1378804
1   https://bitcointalk.org/index.php?action=profile;u=1525844
1   https://bitcointalk.org/index.php?action=profile;u=1616153
1   https://bitcointalk.org/index.php?action=profile;u=1627234
1   https://bitcointalk.org/index.php?action=profile;u=1694449
1   https://bitcointalk.org/index.php?action=profile;u=1711015
1   https://bitcointalk.org/index.php?action=profile;u=1711582
1   https://bitcointalk.org/index.php?action=profile;u=1740809
1   https://bitcointalk.org/index.php?action=profile;u=1813195
1   https://bitcointalk.org/index.php?action=profile;u=1832978
1   https://bitcointalk.org/index.php?action=profile;u=1837238
1   https://bitcointalk.org/index.php?action=profile;u=1853630
1   https://bitcointalk.org/index.php?action=profile;u=1896174
1   https://bitcointalk.org/index.php?action=profile;u=1918270
1   https://bitcointalk.org/index.php?action=profile;u=1951496
1   https://bitcointalk.org/index.php?action=profile;u=2002563
1   https://bitcointalk.org/index.php?action=profile;u=2287195
Piggy (OP)
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1416



View Profile WWW
August 24, 2018, 05:47:36 AM
 #37

  • Updated with the latest data from today Friday 24th of August
  • Updated the user information in the table UserData adding missing users which sent/received merits

Top Sender last week
Code:
Total Merit UserName Top merit receiver Local board
179 chimk Full Member Pyccкий (Russian)
142 suchmoon Legendary Meta
79 dbshck Staff Bahasa Indonesia (Indonesian)
63 _javi_ Hero Member Türkçe (Turkish)
56 qwk Donator Deutsch (German)
48 tomsmith26 Hero Member Announcements (Altcoins)
41 suchmoon Legendary Trading Discussion
40 Moloch Hero Member Politics & Society
39 suchmoon Legendary Mining
36 suchmoon Legendary Mining (Altcoins)
30 mymenace Legendary Economics
27 Jet Cash Hero Member Beginners & Help
26 Halab Member Français
25 Vod Legendary Project Development
21 suchmoon Legendary
21 Foxpup Legendary Bitcoin Technical Support
20 LoyceV Legendary Development & Technical Discussion
20 Micio Legendary Italiano (Italian)
18 Carlton Banks Legendary Bitcoin Discussion
14 quantum Sr. Member Altcoin Discussion
14 paxmao Sr. Member Español (Spanish)
14 RegulusHr Full Member Hrvatski (Croatian)
14 Lauda Legendary Marketplace
9 vit05 Full Member Português (Portuguese)
8 taxmanmt5 Legendary Other languages/locations
6 finaleshot2016 Full Member Philippines
6 DarkStar_ Legendary Serious discussion
4 vinbentrob Member Speculation (Altcoins)
3 adiebitsler Hero Member Marketplace (Altcoins)
3 aliashraf Sr. Member Off-topic
3 chairmanMao Member 中文 (Chinese)
2 RJX Legendary Nederlands (Dutch)
1 hopenotlate Legendary Archival
1 FlamingFingers Sr. Member العربية (Arabic)
1 Anon11073 Staff 日本語 (Japanese)

Top Receivers last week
Code:
Total Merit UserName Top merit receiver Local board
92 DdmrDdmr Full Member Meta
80 Katewind Member Announcements (Altcoins)
80 fine99 Sr. Member Bahasa Indonesia (Indonesian)
67 Matthias9515 Copper Member Türkçe (Turkish)
50 phantastisch Staff Deutsch (German)
31 micgoossens Sr. Member Economics
26 alphateam Hero Member Français
24 BitCryptex Member Bitcoin Technical Support
18 o_e_l_e_o Sr. Member Politics & Society
15 gmaxwell Staff Development & Technical Discussion
15 temarazin Member Pyccкий (Russian)
14 shorena Copper Member Beginners & Help
14 Hhampuz Hero Member Marketplace
14 Moloch Hero Member Off-topic
14 suchmoon Legendary Trading Discussion
11 Welsh Legendary Serious discussion
10 faetos Hero Member
10 Trofo Full Member Hrvatski (Croatian)
9 TheArchaeologist Jr. Member Bitcoin Discussion
9 Paolo.Demidov Member Italiano (Italian)
8 moshuk Jr. Member Marketplace (Altcoins)
8 VoskCoin Sr. Member Mining (Altcoins)
8 UmerIdrees Member Other languages/locations
8 finaleshot2016 Full Member Philippines
7 RadekG2 Newbie Mining
6 buwaytress Hero Member Project Development
5 TranslateIntoDutch Member Nederlands (Dutch)
4 iram1011 Hero Member Altcoin Discussion
4 sabotag3x Hero Member Português (Portuguese)
2 t1Zona Member Español (Spanish)
2 Astrilian Full Member Speculation (Altcoins)
1 CryptoGamblingSites Member Archival
1 hakka Member 日本語 (Japanese)

Sub boards merit circulation last week
Code:
Total Merit SubBoard
87 DELETED
71 Altcoin Discussion
299 Announcements (Altcoins)
1 Archival
263 Bahasa Indonesia (Indonesian)
52 Beginners & Help
118 Bitcoin Discussion
62 Bitcoin Technical Support
178 Deutsch (German)
85 Development & Technical Discussion
313 Economics
19 Español (Spanish)
116 Français
30 Hrvatski (Croatian)
57 Italiano (Italian)
204 Marketplace
27 Marketplace (Altcoins)
621 Meta
40 Mining
84 Mining (Altcoins)
6 Nederlands (Dutch)
26 Off-topic
9 Other languages/locations
25 Philippines
72 Politics & Society
15 Português (Portuguese)
34 Project Development
78 Serious discussion
13 Speculation (Altcoins)
167 Trading Discussion
220 Türkçe (Turkish)
469 Pyccкий (Russian)
1 العربية (Arabic)
6 中文 (Chinese)
2 日本語 (Japanese)

Piggy (OP)
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1416



View Profile WWW
August 31, 2018, 06:37:06 AM
 #38

Updated with the data from today Friday 31st August

Top Sender last week
Code:
Total Merit UserName Top merit receiver Local board
68 Micio Legendary Italiano (Italian)
64 qwk Donator Deutsch (German)
55 Vod Legendary Meta
52 frodocooper Staff Mining
35 DarkStar_ Legendary Development & Technical Discussion
35 BobLawblaw Legendary Economics
25 generalizethis Legendary Speculation (Altcoins)
24 BitcoinFX Legendary Bitcoin Discussion
24 suchmoon Legendary Serious discussion
24 EFS Staff Türkçe (Turkish)
24 Yaremi Legendary Pyccкий (Russian)
18 Flodner Full Member Announcements (Altcoins)
18 Ariess Sr. Member Bahasa Indonesia (Indonesian)
18 DdmrDdmr Full Member Politics & Society
17 Halab Member Français
16 CjMapope Legendary Mining (Altcoins)
16 suchmoon Legendary Trading Discussion
13 ETFbitcoin Legendary Bitcoin Technical Support
13 buckrogers Legendary Marketplace
10 WhiteShum Legendary Altcoin Discussion
9 RegulusHr Full Member Hrvatski (Croatian)
8 Foxpup Legendary Español (Spanish)
8 Vod Legendary Project Development
6 EbonHawk Hero Member Português (Portuguese)
6 hugeblack Sr. Member العربية (Arabic)
5 Steamtyme Full Member Beginners & Help
5 Simayi Member Off-topic
4 Flodner Full Member Other languages/locations
4 finaleshot2016 Full Member Philippines
3 Direwolve735 Full Member Marketplace (Altcoins)
2 Vod Legendary
2 DikkieD Member Nederlands (Dutch)
1 sgk Legendary India
1 malevolent Staff Polski
1 NeuroticFish Legendary Română (Romanian)
1 hakka Member 日本語 (Japanese)

Top Receivers last week


Code:
Total Merit UserName Top merit receiver Local board
40 Flodner Full Member Meta
37 Last of the V8s Hero Member Economics
34 Piggy Sr. Member Italiano (Italian)
33 fine99 Sr. Member Bahasa Indonesia (Indonesian)
29 xtraelv Sr. Member Off-topic
25 BitCryptex Member Development & Technical Discussion
24 satoshi Founder Bitcoin Discussion
23 LFC_Bitcoin Copper Member Marketplace
22 teramit Legendary Türkçe (Turkish)
21 LoyceV Legendary Bitcoin Technical Support
18 ICOEthics Newbie Trading Discussion
16 o_e_l_e_o Sr. Member Politics & Society
16 Juliya_D Jr. Member Pyccкий (Russian)
15 cryptolord2077 Member Altcoin Discussion
15 sidehack Legendary Mining
13 Direwolve735 Full Member Announcements (Altcoins)
12 mole0815 Full Member Deutsch (German)
12 guybrushthreepwood Legendary Serious discussion
10 zawawa Sr. Member Mining (Altcoins)
10 ozkraut Sr. Member Speculation (Altcoins)
9 r1s2g3 Member Beginners & Help
9 NadiaHel Member Español (Spanish)
8 Kate Beckett Member Marketplace (Altcoins)
7 CarlOrff Sr. Member Français
6 texgeek Jr. Member Português (Portuguese)
5 ovcijisir Member Hrvatski (Croatian)
5 zenrol28 Member Philippines
4 pugman Legendary
4 Flodner Full Member Project Development
2 meatfreak Jr. Member Nederlands (Dutch)
2 Ukraine2020 Sr. Member Other languages/locations
2 qwlsnow Jr. Member 中文 (Chinese)
1 sncc Full Member 日本語 (Japanese)

Sub boards merit circulation last week

Code:
Total Merit SubBoard
2 Nederlands (Dutch)
27
195 Altcoin Discussion
202 Announcements (Altcoins)
140 Bahasa Indonesia (Indonesian)
70 Beginners & Help
148 Bitcoin Discussion
49 Bitcoin Technical Support
115 Deutsch (German)
111 Development & Technical Discussion
269 Economics
30 Español (Spanish)
39 Français
32 Hrvatski (Croatian)
2 India
125 Italiano (Italian)
201 Marketplace
18 Marketplace (Altcoins)
361 Meta
79 Mining
103 Mining (Altcoins)
40 Off-topic
9 Other languages/locations
19 Philippines
61 Politics & Society
1 Polski
16 Português (Portuguese)
39 Project Development
1 Română (Romanian)
52 Serious discussion
102 Speculation (Altcoins)
126 Trading Discussion
50 Türkçe (Turkish)
325 Pyccкий (Russian)
12 العربية (Arabic)
4 中文 (Chinese)
1 日本語 (Japanese)

Merits sent from each rank last week
Code:
Rank Total
Administrator 53
Copper Member 73
Donator 84
Full Member 323
Global Moderator 16
Hero Member 387
Jr. Member 71
Legendary 1081
Member 237
Newbie 26
Sr. Member 272
Staff 114
DdmrDdmr
Legendary
*
Offline Offline

Activity: 2282
Merit: 10724


There are lies, damned lies and statistics. MTwain


View Profile WWW
September 01, 2018, 04:44:21 PM
 #39

Updated with the data from today Friday 31st August

Top Sender last week
Code:
Total Merit UserName Top merit receiver Local board
<...>
18 DdmrDdmr Full Member Politics & Society
<…>
There seems to be something wrong with this week’s update. I figure on one of the lists, but I only awarded 3 merits last week to Politics & Society ...
Piggy (OP)
Hero Member
*****
Offline Offline

Activity: 784
Merit: 1416



View Profile WWW
September 02, 2018, 05:40:33 AM
 #40

Updated with the data from today Friday 31st August

Top Sender last week
Code:
Total Merit UserName Top merit receiver Local board
<...>
18 DdmrDdmr Full Member Politics & Society
<…>
There seems to be something wrong with this week’s update. I figure on one of the lists, but I only awarded 3 merits last week to Politics & Society ...

Yes, i see there is some problem in the query itself i made to gather the data, when merits are given in multiple boards. The data itself is correct, i need to see and recheck how to get the those information out when i'm i bit more fresh in my mind  Smiley
Pages: « 1 [2] 3 4 5 6 7 »  All
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!