Piggy (OP)
|
|
November 08, 2018, 08:11:39 PM |
|
If you are able to add "ToUsername" and "Fromusername" in the Meritdata table than it will be great because we rarely recognize anybody with their userids (ToID and FromID).
I'm trying to keep it the database as light as possible so that it doesn't take much space, so i need to avoid redundant informations This other tool does that https://bitcointalk.org/index.php?topic=4456438.0 is in general more user friendly, but has limited query capabilities compared to this one.
|
|
|
|
mainconcept
|
|
November 09, 2018, 01:45:52 PM |
|
I get an error when I use this query: SELECT MAX(result.total) as "Total Merit", result.toID as "Top merit receiver", result.SubBoard as "Board" FROM ( SELECT toid, SubBoard, SUM(Merit) AS total FROM meritdata as m WHERE m.SubBoard in (SELECT SubBoard FROM meritdata GROUP BY SubBoard) GROUP BY toid, SubBoard ORDER BY SubBoard,total Desc) AS result GROUP BY SubBoard ORDER BY result.total Desc; Error: Uncaught abort("Cannot enlarge memory arrays. Either (1) compile with -s TOTAL_MEMORY=X with X higher than the current value 16777216, (2) compile with -s ALLOW_MEMORY_GROWTH=1 which allows increasing the size at runtime but prevents some optimizations, (3) set Module.TOTAL_MEMORY to a higher value before the program runs, or (4) if you want malloc to return NULL (0) instead of this
The local section query works fine. Probably a too resource intensive task.
|
|
|
|
Piggy (OP)
|
|
November 09, 2018, 01:53:09 PM Last edit: November 09, 2018, 06:06:13 PM by Piggy Merited by mainconcept (1) |
|
I get an error when I use this query: SELECT MAX(result.total) as "Total Merit", result.toID as "Top merit receiver", result.SubBoard as "Board" FROM ( SELECT toid, SubBoard, SUM(Merit) AS total FROM meritdata as m WHERE m.SubBoard in (SELECT SubBoard FROM meritdata GROUP BY SubBoard) GROUP BY toid, SubBoard ORDER BY SubBoard,total Desc) AS result GROUP BY SubBoard ORDER BY result.total Desc; Error: Uncaught abort("Cannot enlarge memory arrays. Either (1) compile with -s TOTAL_MEMORY=X with X higher than the current value 16777216, (2) compile with -s ALLOW_MEMORY_GROWTH=1 which allows increasing the size at runtime but prevents some optimizations, (3) set Module.TOTAL_MEMORY to a higher value before the program runs, or (4) if you want malloc to return NULL (0) instead of this
The local section query works fine. Probably a too resource intensive task. Try to run it this way and refresh the page first, as i see after that error not even a normal query seems to be working anymore (probably cannot recover from it): SELECT MAX(result.total) as "Total Merit", result.SubBoard as "Non-Local board" FROM ( SELECT toid, SubBoard, SUM(Merit) AS total FROM meritdata as m GROUP BY toid, Board ORDER BY Board,total Desc) AS result GROUP BY SubBoard ORDER BY result.total Desc
The data is updated to the 9th of November
|
|
|
|
Saint-loup
Legendary
Offline
Activity: 2758
Merit: 2421
|
|
November 10, 2018, 05:36:22 PM |
|
The data is now updated to Friday 2th of November
Here is some general numbers about the last week:
Top Sender per board last week [...]
Hello No scores for this week? I tried to execute some sql queries in your tool to get them, but I got this error message instead Uncaught Error: no such table: meritdata
|
|
|
|
Piggy (OP)
|
|
November 11, 2018, 07:14:46 AM |
|
The data is now updated to Friday 2th of November
Here is some general numbers about the last week:
Top Sender per board last week [...]
Hello No scores for this week? I tried to execute some sql queries in your tool to get them, but I got this error message instead Uncaught Error: no such table: meritdata Not sure about the error what i may be, however when you see the list of the table specifications when you first load the page you are good to go and run the queries. Here are the usual queries for the past week: Top Sender per board last week 102 frodocooper Staff Mining 80 chimk Full Member Pyccкий (Russian) 77 dbshck Staff Bahasa Indonesia (Indonesian) 68 qwk Donator Deutsch (German) 60 QuestionAuthority Legendary Economics 58 Flying Hellfish Staff Marketplace 38 Flying Hellfish Staff Politics & Society 36 Foxpup Legendary Trading Discussion 35 paxmao Sr. Member Español (Spanish) 32 Halab Staff Français 30 Vod Legendary Meta 24 suchmoon Legendary Serious discussion 21 NoNetwork Sr. Member Bitcoin Discussion 20 marcus_of_augustus Legendary Announcements (Altcoins) 19 Piggy Hero Member Italiano (Italian) 18 teramit Legendary Türkçe (Turkish) 16 dbshck Staff Beginners & Help 15 RegulusHr Full Member Hrvatski (Croatian) 12 Foxpup Legendary Development & Technical Discussion 12 BitCryptex Sr. Member Polski 11 dbshck Staff 11 Foxpup Legendary Bitcoin Technical Support 10 Vod Legendary Off-topic 10 chek2fire Legendary Eλληνικά (Greek) 9 Vod Legendary Project Development 6 KeyJockey Hero Member Speculation (Altcoins) 6 hugeblack Sr. Member العربية (Arabic) 5 Haunebu Hero Member Altcoin Discussion 5 italianMiner72 Hero Member Marketplace (Altcoins) 5 vapourminer Legendary Mining (Altcoins) 3 Heisenberg_Hunter Full Member India 3 Barcode_ Staff 中文 (Chinese) 2 friends1980 Full Member Nederlands (Dutch) 2 siddu67 Full Member Other languages/locations 2 Lassie Member Philippines 2 sabotag3x Hero Member Português (Portuguese) 2 Anon11073 Staff 日本語 (Japanese) Top Receivers per board last week 53 Last of the V8s Legendary Economics 50 TNM1WPCK Newbie Pyccкий (Russian) 33 mu_enrico Copper Member Bahasa Indonesia (Indonesian) 27 OgNasty Donator Meta 27 sidehack Legendary Mining 24 Vod Legendary Trading Discussion 21 Jcabudx Member Bitcoin Discussion 20 karakozov Newbie Announcements (Altcoins) 20 laszlo Full Member Marketplace 19 squatz1 Hero Member Politics & Society 18 aundroid Full Member Deutsch (German) 15 arulbero Hero Member Development & Technical Discussion 15 wwzsocki Sr. Member Polski 13 BitCryptex Sr. Member Bitcoin Technical Support 13 Raja_MBZ Hero Member Serious discussion 11 duesoldi Sr. Member Italiano (Italian) 10 ureticy Newbie Türkçe (Turkish) 10 MAR 85 Newbie Eλληνικά (Greek) 9 poloniex777 Jr. Member Español (Spanish) 8 CarlOrff Sr. Member Français 8 slackovic Full Member Hrvatski (Croatian) 7 mu_enrico Copper Member Beginners & Help 7 Loki11 Newbie Project Development 6 lightlord Donator Off-topic 5 3kpk3 Full Member Altcoin Discussion 5 Krishniche Jr. Member Marketplace (Altcoins) 4 Febo Legendary Speculation (Altcoins) 4 HAKHALI Jr. Member العربية (Arabic) 3 HCP Hero Member 3 Hiranand Newbie India 3 todxx Jr. Member Mining (Altcoins) 3 sncc Sr. Member 日本語 (Japanese) 2 kabirhusen Jr. Member Other languages/locations 2 OptimusFries Jr. Member Philippines 2 #BitcoinCore Sr. Member Português (Portuguese) 1 FIEX Sr. Member Nederlands (Dutch) 1 Canadabiter Jr. Member 中文 (Chinese) Sub boards merit circulation last week 10 Eλληνικά (Greek) 2 Other languages/locations 34 53 Altcoin Discussion 228 Announcements (Altcoins) 195 Bahasa Indonesia (Indonesian) 59 Beginners & Help 135 Bitcoin Discussion 11 Bitcoin Technical Support 206 Deutsch (German) 103 Development & Technical Discussion 484 Economics 45 Español (Spanish) 71 Français 38 Hrvatski (Croatian) 10 India 59 Italiano (Italian) 267 Marketplace 13 Marketplace (Altcoins) 297 Meta 199 Mining 28 Mining (Altcoins) 3 Nederlands (Dutch) 16 Off-topic 5 Philippines 123 Politics & Society 30 Polski 6 Português (Portuguese) 49 Project Development 88 Serious discussion 20 Speculation (Altcoins) 168 Trading Discussion 67 Türkçe (Turkish) 330 Pyccкий (Russian) 11 العربية (Arabic) 6 中文 (Chinese) 7 日本語 (Japanese) Merits sent from each rank last week Copper Member 102 Donator 107 Full Member 346 Hero Member 299 Jr. Member 65 Legendary 1316 Member 210 Newbie 25 Sr. Member 457 Staff 549
|
|
|
|
Piggy (OP)
|
|
November 16, 2018, 08:36:59 AM |
|
The tool is now updated with the latest data from today Friday 16th of November Here is the usual snapshot about the last week: Top Sender per board last week 154 chimk Full Member Pyccкий (Russian) 71 suchmoon Legendary Meta 57 paxmao Sr. Member Español (Spanish) 56 DarkStar_ Legendary Development & Technical Discussion 50 adroitful_one Legendary Altcoin Discussion 50 DECENT Hero Member Announcements (Altcoins) 50 fr4nkthetank Legendary Bitcoin Discussion 50 ziomik Legendary Italiano (Italian) 47 Flying Hellfish Staff Politics & Society 40 dbshck Staff Bahasa Indonesia (Indonesian) 40 BitCryptex Sr. Member Polski 39 LFC_Bitcoin Copper Member Economics 38 Flying Hellfish Staff Marketplace 37 qwk Donator Deutsch (German) 35 bg002h Donator Trading Discussion 32 dbshck Staff Beginners & Help 30 Halab Staff Français 28 suchmoon Legendary Serious discussion 24 Leteravian Full Member Türkçe (Turkish) 20 olkah Hero Member Marketplace (Altcoins) 16 suchmoon Legendary Off-topic 13 RegulusHr Full Member Hrvatski (Croatian) 13 dbshck Staff Mining (Altcoins) 12 frodocooper Staff Mining 10 3x2 Legendary 8 LoyceV Legendary Bitcoin Technical Support 8 suchmoon Legendary Project Development 8 3x2 Legendary 日本語 (Japanese) 4 Flying Hellfish Staff Archival 4 cAPSLOCK Legendary Speculation (Altcoins) 2 Heisenberg_Hunter Full Member India 2 bitmover Sr. Member Português (Portuguese) 2 hugeblack Sr. Member العربية (Arabic) 2 Barcode_ Staff 中文 (Chinese) 1 Dzeronimo Member Other languages/locations 1 Kemarit Legendary Philippines Top Receivers per board last week 60 DECENT Marketing Newbie Announcements (Altcoins) 58 gmaxwell Staff Trading Discussion 54 Hal VIP Bitcoin Discussion 51 satoshi Founder Development & Technical Discussion 50 Devawnm367 Member Altcoin Discussion 50 gallisiardi Member Italiano (Italian) 46 karimushkin Jr. Member Pyccкий (Russian) 45 DdmrDdmr Sr. Member Meta 43 Kylapoiss Member Economics 43 1Dq Copper Member Marketplace 34 coins4commies Member Politics & Society 30 cryptovigi Member Polski 25 Hilde X Member Deutsch (German) 23 seoincorporation Legendary Español (Spanish) 21 ranchi Jr. Member Marketplace (Altcoins) 19 mu_enrico Copper Member Bahasa Indonesia (Indonesian) 12 asche Full Member Français 11 Jet Cash Legendary Serious discussion 10 duma18 Newbie 10 acarli Member Mining 10 Cemlik Member Türkçe (Turkish) 9 TrailingStop Newbie Mining (Altcoins) 9 Flying Hellfish Staff Off-topic 9 arulbero Hero Member Project Development 8 AverageGlabella Full Member Beginners & Help 8 Choco99 Newbie 日本語 (Japanese) 7 Dzeronimo Member Hrvatski (Croatian) 4 dazedfool Legendary Archival 4 BitCryptex Sr. Member Bitcoin Technical Support 4 lrvjvt Jr. Member 中文 (Chinese) 3 Locotoni Copper Member Speculation (Altcoins) 2 amicrypto Newbie India 2 Keeshan Member Other languages/locations 1 eldrin Full Member Philippines 1 Mamaecrypto Member Português (Portuguese) 1 Gamals Jr. Member العربية (Arabic) Sub boards merit circulation last week 8 日本語 (Japanese) 5 Archival 48 176 Altcoin Discussion 464 Announcements (Altcoins) 112 Bahasa Indonesia (Indonesian) 149 Beginners & Help 214 Bitcoin Discussion 25 Bitcoin Technical Support 196 Deutsch (German) 265 Development & Technical Discussion 437 Economics 74 Español (Spanish) 69 Français 34 Hrvatski (Croatian) 3 India 122 Italiano (Italian) 300 Marketplace 87 Marketplace (Altcoins) 359 Meta 54 Mining 37 Mining (Altcoins) 21 Off-topic 1 Other languages/locations 1 Philippines 155 Politics & Society 66 Polski 3 Português (Portuguese) 36 Project Development 199 Serious discussion 13 Speculation (Altcoins) 267 Trading Discussion 77 Türkçe (Turkish) 510 Pyccкий (Russian) 6 العربية (Arabic) 5 中文 (Chinese) Merits sent from each rank last week Administrator 1 Copper Member 107 Donator 115 Full Member 413 Global Moderator 1 Hero Member 563 Jr. Member 151 Legendary 1788 Member 269 Newbie 47 Sr. Member 562 Staff 581
|
|
|
|
Piggy (OP)
|
|
November 23, 2018, 12:52:57 PM |
|
The tool is now updated with the latest data from today Friday 23th of November Here is the usual snapshot about the last week: Top Sender per board last week 102 qwk Donator Deutsch (German) 100 suchmoon Legendary Meta 81 chimk Full Member Pyccкий (Russian) 76 QuestionAuthority Legendary Economics 72 dbshck Staff Bahasa Indonesia (Indonesian) 53 Foxpup Legendary Politics & Society 51 Jeremycoin Legendary Bitcoin Discussion 51 EFS Staff Türkçe (Turkish) 50 lyka Legendary Altcoin Discussion 45 bones261 Legendary Development & Technical Discussion 41 Halab Staff Français 40 Vlad2Vlad Legendary Announcements (Altcoins) 37 Micio Legendary Italiano (Italian) 31 paxmao Sr. Member Español (Spanish) 30 Flying Hellfish Staff Marketplace 28 suchmoon Legendary Trading Discussion 20 suchmoon Legendary Serious discussion 19 Real14Hero Hero Member Other languages/locations 18 suchmoon Legendary Bitcoin Technical Support 16 Foxpup Legendary Beginners & Help 14 dbshck Staff Mining (Altcoins) 14 Vod Legendary Off-topic 14 hugeblack Sr. Member العربية (Arabic) 13 RegulusHr Full Member Hrvatski (Croatian) 12 suchmoon Legendary Mining 11 Barcode_ Staff 中文 (Chinese) 10 sabotag3x Hero Member Português (Portuguese) 9 el kaka22 Legendary 8 Vod Legendary Project Development 8 suchmoon Legendary Speculation (Altcoins) 4 Whiteness Copper Member Marketplace (Altcoins) 1 Heisenberg_Hunter Full Member India 1 cryptoaddictchie Member Philippines 1 Tytanowy Janusz Member Polski Top Receivers per board last week 68 goldkingcoiner Member Economics 51 satoshi Founder Bitcoin Discussion 50 lybship53 Sr. Member Altcoin Discussion 47 SaltySpitoon Legendary Meta 38 SaltySpitoon Legendary Politics & Society 36 deadsea33 Jr. Member Announcements (Altcoins) 34 PHI1618 Sr. Member Türkçe (Turkish) 32 roycilik Sr. Member Bahasa Indonesia (Indonesian) 30 minerjones Copper Member Marketplace 25 HeRetiK Hero Member Development & Technical Discussion 25 Plutosky Member Italiano (Italian) 22 philipma1957 Legendary Mining 20 Ultramarine Member Pyccкий (Russian) 19 IggySe7ven Member Other languages/locations 17 acarli Member Serious discussion 15 siulynotb Jr. Member Español (Spanish) 15 asche Full Member Français 14 chenille Newbie Deutsch (German) 13 KingZee Sr. Member Bitcoin Technical Support 11 marlboroza Hero Member Trading Discussion 8 DdmrDdmr Sr. Member Beginners & Help 8 Sk_Ezaz Copper Member Marketplace (Altcoins) 8 QuestionAuthority Legendary Off-topic 8 Summation Jr. Member 中文 (Chinese) 6 andrucrypt Member Mining (Altcoins) 6 xtraelv Sr. Member Speculation (Altcoins) 5 Godplan Newbie 4 bernardos Newbie Hrvatski (Croatian) 4 texgeek Member Português (Portuguese) 3 ibminer Legendary Project Development 3 HAKHALI Jr. Member العربية (Arabic) 1 drmilind2004 Member India 1 Maus0728 Member Philippines 1 Tytanowy Janusz Member Polski Sub boards merit circulation last week 16 中文 (Chinese) 29 112 Altcoin Discussion 211 Announcements (Altcoins) 205 Bahasa Indonesia (Indonesian) 66 Beginners & Help 148 Bitcoin Discussion 34 Bitcoin Technical Support 240 Deutsch (German) 279 Development & Technical Discussion 751 Economics 60 Español (Spanish) 106 Français 23 Hrvatski (Croatian) 1 India 83 Italiano (Italian) 264 Marketplace 20 Marketplace (Altcoins) 466 Meta 43 Mining 33 Mining (Altcoins) 58 Off-topic 35 Other languages/locations 2 Philippines 255 Politics & Society 3 Polski 14 Português (Portuguese) 12 Project Development 71 Serious discussion 32 Speculation (Altcoins) 150 Trading Discussion 139 Türkçe (Turkish) 298 Pyccкий (Russian) 19 العربية (Arabic) Merits sent from each rank last week Administrator 12 Copper Member 92 Donator 141 Full Member 313 Global Moderator 31 Hero Member 450 Jr. Member 82 Legendary 2012 Member 226 Newbie 40 Sr. Member 499 Staff 380
|
|
|
|
tranthidung
Legendary
Offline
Activity: 2422
Merit: 4249
Farewell o_e_l_e_o
|
|
November 25, 2018, 01:27:51 AM Last edit: November 25, 2018, 02:14:21 AM by tranthidung |
|
Highly appreciated your time to do it, keep it update weekly. Would you mind spending your precious time to scrap data and give me and others the sort of weekly merits sent from each rank over weeks, since the start of merit system, please. Additionally, if you have intention to do this, I suggest you to do the same for total weekly merit received from each rank over weeks, since the start of merit sytem. I asked this because I have a topic, which shows the observations of distributed merits over days, weeks, and months, since the start of merit system. By now, I use LoyceV's data source, which has not had the sort of data mentioned above. My topic is here: Time Series Analysis on Distributed Merits in the forum (daily, weekly, monthly)Merits sent from each rank last week Administrator 12 Copper Member 92 Donator 141 Full Member 313 Global Moderator 31 Hero Member 450 Jr. Member 82 Legendary 2012 Member 226 Newbie 40 Sr. Member 499 Staff 380
|
|
|
|
Piggy (OP)
|
|
November 25, 2018, 07:04:04 AM |
|
Highly appreciated your time to do it, keep it update weekly. Would you mind spending your precious time to scrap data and give me and others the sort of weekly merits sent from each rank over weeks, since the start of merit system, please. Additionally, if you have intention to do this, I suggest you to do the same for total weekly merit received from each rank over weeks, since the start of merit sytem. I asked this because I have a topic, which shows the observations of distributed merits over days, weeks, and months, since the start of merit system. By now, I use LoyceV's data source, which has not had the sort of data mentioned above. My topic is here: Time Series Analysis on Distributed Merits in the forum (daily, weekly, monthly)Merits sent from each rank last week Administrator 12 Copper Member 92 Donator 141 Full Member 313 Global Moderator 31 Hero Member 450 Jr. Member 82 Legendary 2012 Member 226 Newbie 40 Sr. Member 499 Staff 380 To extract the information you need you can use this query for the merit sent from each rank: SELECT UserData.Rank, SUM(MeritData.Merit) as Total FROM MeritData INNER JOIN UserData ON UserData.UserId = MeritData.fromid WHERE date between '2018-11-16' AND '2018-11-23' GROUP BY UserData.Rank;
And this one for the merit received from each rank: SELECT UserData.Rank, SUM(MeritData.Merit) as Total FROM MeritData INNER JOIN UserData ON UserData.UserId = MeritData.toid WHERE date between '2018-11-16' AND '2018-11-23' GROUP BY UserData.Rank;
Then you can select the time range corresponding to the range you need to extract the weekly data
|
|
|
|
Piggy (OP)
|
|
November 30, 2018, 07:47:59 AM |
|
The tool is now updated with the latest data from today Friday 30th of November Here is the usual snapshot about the last week: Top Sender per board last week183 chimk Full Member Pyccкий (Russian) 141 qwk Donator Deutsch (German) 124 suchmoon Legendary Meta 63 Halab Staff Français 60 suchmoon Legendary Serious discussion 55 klintay Legendary Announcements (Altcoins) 50 cryptohunter Legendary Bitcoin Discussion 50 monocolor Hero Member Development & Technical Discussion 50 sammy007 Legendary Economics 42 klintay Legendary Mining 29 Flying Hellfish Staff Politics & Society 25 EFS Staff Türkçe (Turkish) 23 dbshck Staff Bahasa Indonesia (Indonesian) 22 Vlad2Vlad Legendary Altcoin Discussion 21 bitkilo Legendary Marketplace 20 Jet Cash Legendary Beginners & Help 18 paxmao Sr. Member Español (Spanish) 11 Micio Legendary Italiano (Italian) 11 nutildah Legendary Trading Discussion 10 sabotag3x Hero Member Português (Portuguese) 9 LoyceV Legendary Bitcoin Technical Support 9 RegulusHr Full Member Hrvatski (Croatian) 8 suchmoon Legendary 8 Anon11073 Staff 日本語 (Japanese) 7 dbshck Staff Mining (Altcoins) 5 batesresearch Legendary Marketplace (Altcoins) 4 amishmanish Sr. Member India 4 suchmoon Legendary Off-topic 4 joshua123 Full Member Philippines 4 Vod Legendary Project Development 4 hugeblack Sr. Member العربية (Arabic) 2 pawel7777 Legendary Polski 2 Hueristic Legendary Speculation (Altcoins) 2 Barcode_ Staff 中文 (Chinese) 1 sbogovac Legendary Nederlands (Dutch) 1 Dzeronimo Member Other languages/locations Top Receivers per board last week62 satoshi Founder Bitcoin Discussion 54 realr0ach Full Member Economics 50 VeilDango Copper Member Announcements (Altcoins) 50 dreamhouse Hero Member Development & Technical Discussion 39 suchmoon Legendary Meta 33 phantastisch Staff Deutsch (German) 25 abhiseshakana Full Member Bahasa Indonesia (Indonesian) 24 o_e_l_e_o Sr. Member Serious discussion 22 vh Hero Member Mining 21 zazarb Legendary Marketplace 20 CoinHoarder Legendary Altcoin Discussion 20 Nomad88 Legendary Türkçe (Turkish) 19 Smartprofit Full Member Pyccкий (Russian) 17 Flying Hellfish Staff Politics & Society 15 HeRetiK Hero Member Bitcoin Technical Support 12 kenzawak Full Member Français 10 gbianchi Legendary Italiano (Italian) 9 big_daddy Full Member Hrvatski (Croatian) 7 jstefanop Legendary Mining (Altcoins) 7 coinlocket$ Sr. Member Trading Discussion 6 kingpin4321 Newbie Beginners & Help 6 Zarg0n Member Español (Spanish) 5 geostima Newbie Marketplace (Altcoins) 5 DireWolfM14 Member Off-topic 5 mcnocon2 Jr. Member Philippines 5 hakka Member 日本語 (Japanese) 4 ETFbitcoin Legendary 4 Vod Legendary Project Development 3 TryNinja Hero Member Português (Portuguese) 3 Summation Jr. Member 中文 (Chinese) 2 amicrypto Newbie India 2 BitCryptex Sr. Member Polski 2 johnalan Member Speculation (Altcoins) 2 hugeblack Sr. Member العربية (Arabic) 1 bit my coin Newbie Nederlands (Dutch) 1 CryptoLavlu Jr. Member Other languages/locations Sub boards merit circulation last week42 98 Altcoin Discussion 348 Announcements (Altcoins) 81 Bahasa Indonesia (Indonesian) 67 Beginners & Help 216 Bitcoin Discussion 29 Bitcoin Technical Support 315 Deutsch (German) 142 Development & Technical Discussion 656 Economics 23 Español (Spanish) 112 Français 39 Hrvatski (Croatian) 5 India 40 Italiano (Italian) 220 Marketplace 18 Marketplace (Altcoins) 364 Meta 128 Mining 20 Mining (Altcoins) 1 Nederlands (Dutch) 20 Off-topic 3 Other languages/locations 6 Philippines 113 Politics & Society 3 Polski 13 Português (Portuguese) 21 Project Development 145 Serious discussion 8 Speculation (Altcoins) 92 Trading Discussion 90 Türkçe (Turkish) 377 Pyccкий (Russian) 7 العربية (Arabic) 4 中文 (Chinese) 13 日本語 (Japanese) Merits sent from each rank last weekAdministrator 1 Copper Member 82 Donator 165 Full Member 400 Global Moderator 13 Hero Member 439 Jr. Member 58 Legendary 1787 Member 189 Newbie 53 Sr. Member 395 Staff 297 Merits received from each rank last weekAdministrator 7 Brand new 3 Copper Member 131 Donator 35 Founder 65 Full Member 473 Global Moderator 29 Hero Member 532 Jr. Member 311 Legendary 933 Member 422 Newbie 262 Sr. Member 536 Staff 139 VIP 1
|
|
|
|
Piggy (OP)
|
|
December 07, 2018, 09:50:05 AM |
|
The tool is now updated with the latest data from today Friday 7th of December Here is the usual snapshot about the last week: Top Sender per board last week90 Micio Legendary Italiano (Italian) 70 dbshck Staff Bahasa Indonesia (Indonesian) 65 DarkStar_ Legendary Development & Technical Discussion 64 GRAND EX Hero Member Pyccкий (Russian) 57 qwk Donator Deutsch (German) 53 BitSler support Hero Member Marketplace 52 paxmao Sr. Member Español (Spanish) 50 notsofast Legendary Economics 46 Halab Staff Français 45 OgNasty Donator 45 frodocooper Staff Mining 42 dbshck Staff Bitcoin Discussion 40 suchmoon Legendary Meta 36 Vlad2Vlad Legendary Announcements (Altcoins) 34 Foxpup Legendary Politics & Society 28 suchmoon Legendary Beginners & Help 28 suchmoon Legendary Trading Discussion 28 mitzie Staff Eλληνικά (Greek) 23 EFS Staff Türkçe (Turkish) 20 paxmao Sr. Member Serious discussion 17 LoyceV Legendary Bitcoin Technical Support 14 krogothmanhattan Hero Member Project Development 13 RegulusHr Full Member Hrvatski (Croatian) 9 vapourminer Legendary Mining (Altcoins) 8 Vlad2Vlad Legendary Altcoin Discussion 6 Foxpup Legendary Off-topic 5 rahmanrock Full Member Marketplace (Altcoins) 5 kodtycoon Legendary Speculation (Altcoins) 5 hugeblack Sr. Member العربية (Arabic) 5 Anon11073 Staff 日本語 (Japanese) 4 amishmanish Sr. Member India 4 sabotag3x Hero Member Português (Portuguese) 3 Barcode_ Staff 中文 (Chinese) 2 Iced Full Member Nederlands (Dutch) 2 BitCryptex Sr. Member Polski 1 Incomelocker Jr. Member Other languages/locations 1 BlackMambaPH Hero Member Philippines Top Receivers per board last week89 JagerBeen Jr. Member Pyccкий (Russian) 59 micgoossens Sr. Member Economics 52 LV5ME Member Announcements (Altcoins) 38 Baryom Hero Member Marketplace 38 fisheater Hero Member Trading Discussion 30 Flying Hellfish Staff Politics & Society 28 coinlocket$ Sr. Member Italiano (Italian) 24 roycilik Sr. Member Bahasa Indonesia (Indonesian) 22 aliashraf Sr. Member Development & Technical Discussion 20 panagot Sr. Member Eλληνικά (Greek) 19 hold-coins Newbie Bitcoin Discussion 19 HCP Hero Member Bitcoin Technical Support 17 kenzawak Full Member Français 17 friends1980 Full Member Serious discussion 16 DdmrDdmr Sr. Member Español (Spanish) 16 ekiller Hero Member Türkçe (Turkish) 15 nullCoiner Sr. Member Deutsch (German) 14 SaltySpitoon Legendary Meta 14 canton Sr. Member Project Development 12 Last of the V8s Legendary Off-topic 11 mgoz Member Mining 10 phitan Member 10 hashbook Copper Member Mining (Altcoins) 7 Jet Cash Legendary Beginners & Help 5 nix1977 Jr. Member Marketplace (Altcoins) 5 Cacingkemi Hero Member Speculation (Altcoins) 4 capableuwa1 Copper Member Altcoin Discussion 4 Pmalek Hero Member Hrvatski (Croatian) 3 Jewel2895 Jr. Member India 3 cryptovigi Member Polski 3 outsidertrader Jr. Member Português (Portuguese) 3 miswo Newbie 日本語 (Japanese) 2 sbogovac Legendary Nederlands (Dutch) 2 Simayi Member 中文 (Chinese) 1 R.I.F Newbie Other languages/locations 1 harizen Legendary Philippines 1 Kavelj22 Newbie العربية (Arabic) Sub boards merit circulation last week38 Eλληνικά (Greek) 2 Nederlands (Dutch) 5 Polski 5 日本語 (Japanese) 91 36 Altcoin Discussion 335 Announcements (Altcoins) 110 Bahasa Indonesia (Indonesian) 79 Beginners & Help 138 Bitcoin Discussion 73 Bitcoin Technical Support 149 Deutsch (German) 151 Development & Technical Discussion 657 Economics 63 Español (Spanish) 85 Français 23 Hrvatski (Croatian) 12 India 122 Italiano (Italian) 424 Marketplace 10 Marketplace (Altcoins) 195 Meta 69 Mining 28 Mining (Altcoins) 24 Off-topic 2 Other languages/locations 2 Philippines 158 Politics & Society 11 Português (Portuguese) 24 Project Development 109 Serious discussion 19 Speculation (Altcoins) 123 Trading Discussion 89 Türkçe (Turkish) 438 Pyccкий (Russian) 7 العربية (Arabic) 3 中文 (Chinese) Merits sent from each rank last weekAdministrator 2 Copper Member 79 Donator 128 Full Member 262 Global Moderator 6 Hero Member 511 Jr. Member 70 Legendary 1514 Member 196 Newbie 54 Sr. Member 624 Staff 462 VIP 1 Merits received from each rank last weekAdministrator 6 Brand new 5 Copper Member 200 Donator 32 Founder 23 Full Member 356 Global Moderator 5 Hero Member 446 Jr. Member 380 Legendary 880 Member 481 Newbie 338 Sr. Member 667 Staff 69 VIP 21
|
|
|
|
Piggy (OP)
|
|
December 17, 2018, 06:40:33 AM |
|
The tool is now updated with the latest data from today Friday 14th of December Here is the usual snapshot about the last week: Top Sender per board last week144 chimk Full Member Pyccкий (Russian) 88 suchmoon Legendary Meta 81 dbshck Staff Bahasa Indonesia (Indonesian) 75 frodocooper Staff Mining 67 Halab Staff Français 50 template Hero Member Announcements (Altcoins) 42 JayJuanGee Legendary Economics 40 Flying Hellfish Staff Politics & Society 40 bomberb17 Hero Member Eλληνικά (Greek) 38 fisheater Hero Member Development & Technical Discussion 36 suchmoon Legendary Beginners & Help 35 Welsh Staff Serious discussion 32 suchmoon Legendary Bitcoin Technical Support 25 Welsh Staff Trading Discussion 20 Micio Legendary Italiano (Italian) 20 scryptr Legendary Mining (Altcoins) 19 EFS Staff Türkçe (Turkish) 17 paxmao Sr. Member Español (Spanish) 17 polymerbit Full Member Marketplace 14 Foxpup Legendary 14 RegulusHr Full Member Hrvatski (Croatian) 14 Vod Legendary Off-topic 12 Vod Legendary Project Development 11 willi9974 Legendary Deutsch (German) 9 JayJuanGee Legendary Bitcoin Discussion 6 halisakal Hero Member Altcoin Discussion 6 tudor_simion Member Română (Romanian) 5 Flying Hellfish Staff Archival 4 scarface-T Full Member Speculation (Altcoins) 3 Heisenberg_Hunter Full Member India 3 KLoUN287 Member Marketplace (Altcoins) 3 sbogovac Legendary Nederlands (Dutch) 3 hugeblack Sr. Member العربية (Arabic) 2 bitart Hero Member Other languages/locations 2 alegotardo Full Member Português (Portuguese) 2 Anon11073 Staff 日本語 (Japanese) 1 Barcode_ Staff 中文 (Chinese) Top Receivers per board last week72 DdmrDdmr Sr. Member Meta 62 micgoossens Sr. Member Economics 50 techbytes Legendary Announcements (Altcoins) 40 MZ4 Newbie Eλληνικά (Greek) 38 dreamhouse Hero Member Development & Technical Discussion 34 sidehack Legendary Mining 31 mu_enrico Copper Member Bahasa Indonesia (Indonesian) 30 Xprim777 Legendary Marketplace 23 Hc01 Full Member Türkçe (Turkish) 22 TryNinja Hero Member Beginners & Help 20 theymos Administrator Politics & Society 17 nutildah Legendary Off-topic 16 Coding Enthusiast Sr. Member Bitcoin Technical Support 15 Saint-loup Sr. Member Français 14 TheFuzzStone Hero Member Pyccкий (Russian) 13 gbianchi Legendary Italiano (Italian) 12 Macadonian Member Serious discussion 10 Miner.Hosting Newbie Deutsch (German) 10 kerney666 Jr. Member Mining (Altcoins) 9 Locotoni Copper Member Trading Discussion 8 Kakmakr Legendary Bitcoin Discussion 7 Trofo Sr. Member Hrvatski (Croatian) 6 AlexSimion Full Member Română (Romanian) 5 AlexSG Full Member 5 basty03 Jr. Member Altcoin Discussion 5 Hhampuz Hero Member Archival 5 seoincorporation Legendary Español (Spanish) 5 crabby Member Project Development 4 TwSeventh Full Member Speculation (Altcoins) 3 ambeo Jr. Member Marketplace (Altcoins) 3 QuadsPoker Copper Member Nederlands (Dutch) 2 amicrypto Newbie India 2 TryNinja Hero Member Português (Portuguese) 2 hakka Member 日本語 (Japanese) 1 Fenya96 Jr. Member Other languages/locations 1 hesham51 Member العربية (Arabic) 1 baobao2000 Member 中文 (Chinese) Sub boards merit circulation last week6 Română (Romanian) 45 Eλληνικά (Greek) 7 Archival 2 日本語 (Japanese) 49 59 Altcoin Discussion 191 Announcements (Altcoins) 134 Bahasa Indonesia (Indonesian) 171 Beginners & Help 102 Bitcoin Discussion 136 Bitcoin Technical Support 79 Deutsch (German) 175 Development & Technical Discussion 556 Economics 22 Español (Spanish) 125 Français 30 Hrvatski (Croatian) 3 India 47 Italiano (Italian) 216 Marketplace 15 Marketplace (Altcoins) 598 Meta 144 Mining 32 Mining (Altcoins) 5 Nederlands (Dutch) 54 Off-topic 4 Other languages/locations 99 Politics & Society 7 Português (Portuguese) 22 Project Development 110 Serious discussion 14 Speculation (Altcoins) 89 Trading Discussion 59 Türkçe (Turkish) 302 Pyccкий (Russian) 4 العربية (Arabic) 1 中文 (Chinese) Merits sent from each rank last weekAdministrator 18 Copper Member 79 Donator 32 Full Member 373 Global Moderator 11 Hero Member 438 Jr. Member 70 Legendary 1428 Member 200 Newbie 29 Sr. Member 362 Staff 673 VIP 1 Merits received from each rank last weekAdministrator 84 Brand new 3 Copper Member 177 Donator 24 Founder 6 Full Member 332 Global Moderator 9 Hero Member 452 Jr. Member 351 Legendary 929 Member 427 Newbie 250 Sr. Member 580 Staff 89 VIP 1
|
|
|
|
Piggy (OP)
|
|
December 21, 2018, 06:51:34 AM |
|
The tool is now updated with the latest data from today Friday 21st of December Here is the usual snapshot about the last week: Top Sender per board last week237 dbshck Staff Bahasa Indonesia (Indonesian) 115 Flying Hellfish Staff Marketplace 79 chimk Full Member Pyccкий (Russian) 60 dragonmike Hero Member 54 JayJuanGee Legendary Economics 52 suchmoon Legendary Meta 52 suchmoon Legendary Trading Discussion 50 hv_ Hero Member Bitcoin Discussion 47 Halab Staff Français 46 paxmao Sr. Member Español (Spanish) 44 frodocooper Staff Mining 40 Foxpup Legendary Off-topic 32 suchmoon Legendary Development & Technical Discussion 20 MarketMagic Hero Member Announcements (Altcoins) 20 Flying Hellfish Staff Politics & Society 20 teramit Legendary Türkçe (Turkish) 18 paxmao Sr. Member Serious discussion 15 dbshck Staff Bitcoin Technical Support 13 paxmao Sr. Member Beginners & Help 12 n00b3rt Sr. Member Altcoin Discussion 10 n00b3rt Sr. Member Speculation (Altcoins) 8 o_solo_miner Legendary Deutsch (German) 8 sabotag3x Hero Member Português (Portuguese) 7 RegulusHr Full Member Hrvatski (Croatian) 6 Vod Legendary Project Development 5 oscar2000 Legendary עברית (Hebrew) 4 suchmoon Legendary Mining (Altcoins) 4 hugeblack Sr. Member العربية (Arabic) 3 Piggy Hero Member Italiano (Italian) 2 friends1980 Full Member Nederlands (Dutch) 2 aleksej996 Sr. Member Other languages/locations 1 Dobrii Sr. Member Marketplace (Altcoins) Top Receivers per board last week66 GameKyuubi Sr. Member Economics 61 satoshi Founder Bitcoin Discussion 57 joniboini Sr. Member Bahasa Indonesia (Indonesian) 50 victorhing Legendary Marketplace 47 achow101 Staff Development & Technical Discussion 42 theymos Administrator Meta 40 saginaw32 Newbie 24 achow101 Staff Bitcoin Technical Support 24 Nikisa Member Pyccкий (Russian) 20 ICOEthics Full Member Trading Discussion 17 logfiles Copper Member Beginners & Help 15 thierry4wd Newbie Mining 14 kenzawak Full Member Français 12 DdmrDdmr Sr. Member Español (Spanish) 12 cestmoi Newbie Politics & Society 12 eddie13 Hero Member Serious discussion 11 SynchrotronCoinDev Jr. Member Announcements (Altcoins) 11 nullCoiner Sr. Member Deutsch (German) 10 cryptomaster420 Member Altcoin Discussion 10 NoMoreForksPls Member Speculation (Altcoins) 9 RodeoX Legendary Off-topic 6 omer-jamal Member العربية (Arabic) 5 Dammitt Hero Member Türkçe (Turkish) 4 Plutosky Member Italiano (Italian) 4 vapourminer Legendary Mining (Altcoins) 4 Adeilton Newbie Português (Portuguese) 3 Dzeronimo Member Hrvatski (Croatian) 3 Vod Legendary Project Development 2 temple93 Newbie Other languages/locations 1 Leva Jr. Member Marketplace (Altcoins) 1 Janportfolio Newbie Nederlands (Dutch) 1 EndryoBit Newbie עברית (Hebrew) Sub boards merit circulation last week91 67 Altcoin Discussion 139 Announcements (Altcoins) 314 Bahasa Indonesia (Indonesian) 98 Beginners & Help 175 Bitcoin Discussion 40 Bitcoin Technical Support 79 Deutsch (German) 203 Development & Technical Discussion 454 Economics 57 Español (Spanish) 106 Français 12 Hrvatski (Croatian) 14 Italiano (Italian) 489 Marketplace 2 Marketplace (Altcoins) 360 Meta 98 Mining 13 Mining (Altcoins) 2 Nederlands (Dutch) 72 Off-topic 3 Other languages/locations 55 Politics & Society 18 Português (Portuguese) 14 Project Development 75 Serious discussion 19 Speculation (Altcoins) 142 Trading Discussion 37 Türkçe (Turkish) 352 Pyccкий (Russian) 5 עברית (Hebrew) 12 العربية (Arabic) Merits sent from each rank last weekAdministrator 2 Brand new 5 Copper Member 89 Donator 73 Full Member 250 Global Moderator 10 Hero Member 389 Jr. Member 97 Legendary 1355 Member 198 Newbie 60 Sr. Member 373 Staff 715 VIP 1 Merits received from each rank last weekAdministrator 44 Brand new 8 Copper Member 166 Donator 5 Founder 61 Full Member 392 Global Moderator 41 Hero Member 262 Jr. Member 336 Legendary 868 Member 458 Newbie 314 Sr. Member 544 Staff 113 VIP 5
|
|
|
|
mikeywith
Legendary
Offline
Activity: 2380
Merit: 6579
be constructive or S.T.F.U
|
|
December 25, 2018, 02:15:53 AM |
|
just for fun ,generous members who gave newbies more than 10 merits. select username ,1.0* date as dt ,rank,toid,fromid ,Merit from MeritData inner join UserData on UserData.userid = meritdata.fromid where toid in (select userid from userdata where rank = 'Newbie') and merit >10 and dt = 2018 order by username ,merit desc limit 1000 @piggy , can you add post count to user table? thanks
|
|
|
|
Piggy (OP)
|
|
December 25, 2018, 09:42:36 AM |
|
Hi I prefer to keep the size of this database as small as possible. Otherwise would be nice to have all the possible data coming along with each user. However In here you can find a recent snapshot taken for all the users in the forum with all the infos publicly available https://bitcointalk.org/index.php?topic=5066192.0
|
|
|
|
mikeywith
Legendary
Offline
Activity: 2380
Merit: 6579
be constructive or S.T.F.U
|
|
December 25, 2018, 01:15:17 PM |
|
Hi I prefer to keep the size of this database as small as possible. Otherwise would be nice to have all the possible data coming along with each user. However In here you can find a recent snapshot taken for all the users in the forum with all the infos publicly available https://bitcointalk.org/index.php?topic=5066192.0 I have that db as well, i want to make a report of ( received merit to post ration) which in the link you provided is not possible, since there is no way to know whether the merit was airdropped or received. and on this database the post count is not there. do you have any other db that contains both post count and received merit ? thanks
|
|
|
|
Piggy (OP)
|
|
December 25, 2018, 02:19:46 PM Last edit: December 25, 2018, 09:19:00 PM by Piggy |
|
Hi I prefer to keep the size of this database as small as possible. Otherwise would be nice to have all the possible data coming along with each user. However In here you can find a recent snapshot taken for all the users in the forum with all the infos publicly available https://bitcointalk.org/index.php?topic=5066192.0 I have that db as well, i want to make a report of ( received merit to post ration) which in the link you provided is not possible, since there is no way to know whether the merit was airdropped or received. and on this database the post count is not there. do you have any other db that contains both post count and received merit ? thanks I think there may be some way to export a table from a db file to another using SQL lite, ill have a look later and see if i find some guide or resources. Edit: perhaps this can help ( i have not tried this myself) https://tableplus.io/blog/2018/07/sqlite-how-to-copy-table-to-another-database.htmlUsing SQLite command-line toolOpen the old database then dump the table sqlite> .output table_dump.sql sqlite> .dump table_name sqlite> .quit Then open the new database and read the dump: sqlite> .read table_dump.sql
|
|
|
|
mikeywith
Legendary
Offline
Activity: 2380
Merit: 6579
be constructive or S.T.F.U
|
|
December 26, 2018, 09:33:53 PM |
|
will try that later on , thanks piggy
|
|
|
|
|
Piggy (OP)
|
|
December 30, 2018, 09:45:32 AM |
|
Sorry, I couldn't update the merit data this week due to holidays and no access to my pc, it will be updated alltogheter the next Friday
|
|
|
|
|