Bitcoin Forum
August 21, 2019, 04:31:57 AM *
News: Latest Bitcoin Core release: 0.18.0 [Torrent] (New!)
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Almost 2.5M users registered but only 30k accounts  (Read 233 times)
seoincorporation
Legendary
*
Online Online

Activity: 1442
Merit: 1452


BtcBoss


View Profile
October 26, 2018, 03:03:11 PM
 #1

After having some fun with the nice Piggy's Merit Data SQL tool (https://bitcointalk.org/index.php?topic=4551881.0) i realized the total users on the 'UserData' table was a lil more than 30,000. But the last user ID was 2450245.

here the question is; did admin and mods ban 2,420,254 accounts? Or something is wrong with the DB query?

https://albertoit.github.io/Merit-Explorer-SQL/
Code:
SELECT count(UserName) FROM UserData;
Quote
count(UserName)
30858

.BitDice.               ▄▄███▄▄
           ▄▄██▀▀ ▄ ▀▀██▄▄
      ▄▄█ ▀▀  ▄▄█████▄▄  ▀▀ █▄▄
  ▄▄██▀▀     ▀▀ █████ ▀▀     ▀▀██▄▄
██▀▀ ▄▄██▀      ▀███▀      ▀██▄▄ ▀▀██
██  ████▄▄       ███       ▄▄████  ██
██  █▀▀████▄▄  ▄█████▄  ▄▄████▀▀█  ██
██  ▀     ▀▀▀███████████▀▀▀     ▀  ██
             ███████████
██  ▄     ▄▄▄███████████▄▄▄     ▄  ██
██  █▄▄████▀▀  ▀█████▀  ▀▀████▄▄█  ██
██  ████▀▀       ███       ▀▀████  ██
██▄▄ ▀▀██▄      ▄███▄      ▄██▀▀ ▄▄██
  ▀▀██▄▄     ▄▄ █████ ▄▄     ▄▄██▀▀
      ▀▀█ ▄▄  ▀▀█████▀▀  ▄▄ █▀▀
           ▀▀██▄▄ ▀ ▄▄██▀▀
               ▀▀███▀▀
        ▄▄███████▄▄
     ▄███████████████▄
    ████▀▀       ▀▀████
   ████▀           ▀████
   ████             ████
   ████ ▄▄▄▄▄▄▄▄▄▄▄ ████
▄█████████████████████████▄
██████████▀▀▀▀▀▀▀██████████
████                   ████
████                   ████
████                   ████
████                   ████
████                   ████
████▄                 ▄████
████████▄▄▄     ▄▄▄████████
  ▀▀▀█████████████████▀▀▀
        ▀▀▀█████▀▀▀
▄▄████████████████████████████████▄▄
██████████████████████████████████████
█████                            █████
█████                            █████
█████                            █████
█████                            █████
█████                     ▄▄▄▄▄▄▄▄▄▄
█████                   ▄█▀▀▀▀▀▀▀▀▀▀█▄
█████                   ██          ██
█████                   ██          ██
█████                   ██          ██
██████████████████▀▀███ ██          ██
 ████████████████▄  ▄██ ██          ██
   ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ ██          ██
             ██████████ ██          ██
           ▄███████████ ██████▀▀██████
          █████████████  ▀████▄▄████▀
[/]
1566361917
Hero Member
*
Offline Offline

Posts: 1566361917

View Profile Personal Message (Offline)

Ignore
1566361917
Reply with quote  #2

1566361917
Report to moderator
1566361917
Hero Member
*
Offline Offline

Posts: 1566361917

View Profile Personal Message (Offline)

Ignore
1566361917
Reply with quote  #2

1566361917
Report to moderator
1566361917
Hero Member
*
Offline Offline

Posts: 1566361917

View Profile Personal Message (Offline)

Ignore
1566361917
Reply with quote  #2

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

Posts: 1566361917

View Profile Personal Message (Offline)

Ignore
1566361917
Reply with quote  #2

1566361917
Report to moderator
TryNinja
Legendary
*
Offline Offline

Activity: 1106
Merit: 1432


CS <3


View Profile
October 26, 2018, 03:08:29 PM
 #2

I'm pretty sure this DB only has data about users who received or sent at least one merit (since the data is probably taken from theymos' weekly merit history file). If there is no merit transaction coming from your account, you can't be in that database.

So, 30858 accounts have received/sent merit at least once.

This is a tool that allow you to run full SQL queries over the merit data and is based on SQLite. If you are familiar with SQL you know the possibilities are basically endless or limited to your SQL knowledge.

DdmrDdmr
Hero Member
*****
Offline Offline

Activity: 588
Merit: 2571

There are lies, damned lies and statistics. MTwain


View Profile WWW
October 26, 2018, 03:31:01 PM
 #3

<…>
It’s as @TryNinja points out. The driver for the data is the cumulative of merit.txt files, so basically there are all the sMerit TXs since day one, along with the name of the board,  sub-board and thread involved.  In addition, all user profiles involved are provided (whether they are senders or receivers) , but no information is retrievable if there is no associated merit TX involved.

iasenko
Hero Member
*****
Offline Offline

Activity: 658
Merit: 1192


WYGIWYD


View Profile WWW
October 26, 2018, 04:07:36 PM
 #4

According to Vod's BPIP database, there are 326,673
Active Profiles.
That will say that those account have been active for the last 30 days.
Of course many people log in not so frequently, so those numbers are approximate

seoincorporation
Legendary
*
Online Online

Activity: 1442
Merit: 1452


BtcBoss


View Profile
October 26, 2018, 04:30:10 PM
 #5

So, 30858 accounts have received/sent merit at least once.
Thanks for the info, now all have sense, but I think 30k users active on the merit system still a low number.

<…>
It’s as @TryNinja points out. The driver for the data is the cumulative of merit.txt files, so basically there are all the sMerit TXs since day one, along with the name of the board,  sub-board and thread involved.  In addition, all user profiles involved are provided (whether they are senders or receivers) , but no information is retrievable if there is no associated merit TX involved.
My confusion comes from the two tables on the link I posted, there we see 'MeritData' and 'UserData' tables, i think the users one was the full user's list because the information we get from this table doesn't mention  Merits (It only give UserId, UserName and Rank)


According to Vod's BPIP database, there are 326,673
Active Profiles.
That will say that those accounts have been active for the last 30 days.
Of course many people log in not so frequently, so those numbers are approximate


Well, close to 10% of the total users are active, but let's remember a lot of people use multiple accounts, but 326k still a big number.

Thanks for the information guys  Cheesy

.BitDice.               ▄▄███▄▄
           ▄▄██▀▀ ▄ ▀▀██▄▄
      ▄▄█ ▀▀  ▄▄█████▄▄  ▀▀ █▄▄
  ▄▄██▀▀     ▀▀ █████ ▀▀     ▀▀██▄▄
██▀▀ ▄▄██▀      ▀███▀      ▀██▄▄ ▀▀██
██  ████▄▄       ███       ▄▄████  ██
██  █▀▀████▄▄  ▄█████▄  ▄▄████▀▀█  ██
██  ▀     ▀▀▀███████████▀▀▀     ▀  ██
             ███████████
██  ▄     ▄▄▄███████████▄▄▄     ▄  ██
██  █▄▄████▀▀  ▀█████▀  ▀▀████▄▄█  ██
██  ████▀▀       ███       ▀▀████  ██
██▄▄ ▀▀██▄      ▄███▄      ▄██▀▀ ▄▄██
  ▀▀██▄▄     ▄▄ █████ ▄▄     ▄▄██▀▀
      ▀▀█ ▄▄  ▀▀█████▀▀  ▄▄ █▀▀
           ▀▀██▄▄ ▀ ▄▄██▀▀
               ▀▀███▀▀
        ▄▄███████▄▄
     ▄███████████████▄
    ████▀▀       ▀▀████
   ████▀           ▀████
   ████             ████
   ████ ▄▄▄▄▄▄▄▄▄▄▄ ████
▄█████████████████████████▄
██████████▀▀▀▀▀▀▀██████████
████                   ████
████                   ████
████                   ████
████                   ████
████                   ████
████▄                 ▄████
████████▄▄▄     ▄▄▄████████
  ▀▀▀█████████████████▀▀▀
        ▀▀▀█████▀▀▀
▄▄████████████████████████████████▄▄
██████████████████████████████████████
█████                            █████
█████                            █████
█████                            █████
█████                            █████
█████                     ▄▄▄▄▄▄▄▄▄▄
█████                   ▄█▀▀▀▀▀▀▀▀▀▀█▄
█████                   ██          ██
█████                   ██          ██
█████                   ██          ██
██████████████████▀▀███ ██          ██
 ████████████████▄  ▄██ ██          ██
   ▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀ ██          ██
             ██████████ ██          ██
           ▄███████████ ██████▀▀██████
          █████████████  ▀████▄▄████▀
[/]
jackg
Copper Member
Legendary
*
Offline Offline

Activity: 1470
Merit: 1288


https://bit.ly/2FR9nyn - free python tutorials


View Profile
October 26, 2018, 05:43:25 PM
 #6

According to Vod's BPIP database, there are 326,673
Active Profiles.
That will say that those account have been active for the last 30 days.
Of course many people log in not so frequently, so those numbers are approximate


And only 30k sent or recieved merits?

Granted a lot of the rest will be alts/bounty or spammers but not receiving a single merit is a bit weird. That’s less than 10%.

Granted some will be bots parsing the forum or copy-pasting but still, that number is ridiculously low.

manfredmann
Member
**
Offline Offline

Activity: 420
Merit: 16

"I AM A TEACHER"


View Profile WWW
October 26, 2018, 06:15:47 PM
 #7


And only 30k sent or recieved merits?

only time will tell for this since this is the start of something good to bitcoin.Bitcoin os a global ctypto and so it will do also the same with the forum. It was forseen by admin that forum still continue to be global. So, the merit implementation with users receive or sent with more less 30k users is not that bad. Reminders than one should need to get at least 1 merit to rank up to jr. member. The forum users with 2m registered on it states that only few knew about forun.


dogtana
Member
**
Offline Offline

Activity: 532
Merit: 48


View Profile
October 28, 2018, 08:45:06 PM
 #8

Is there any statistic showing the total number of members of a particular rank? For example how many newbs, juniors, members, full members etc there are? That would be interesting to see.
Don Pedro Dinero
Sr. Member
****
Offline Offline

Activity: 490
Merit: 285



View Profile
October 28, 2018, 08:52:26 PM
 #9

Is there any statistic showing the total number of members of a particular rank? For example how many newbs, juniors, members, full members etc there are? That would be interesting to see.

Have a look at this: https://bitcointalk.org/index.php?topic=5057502.msg47358062#msg47358062
cryptovigi
Hero Member
*****
Offline Offline

Activity: 518
Merit: 501


Self-made Hero Member


View Profile
October 28, 2018, 08:56:42 PM
 #10

Is there any statistic showing the total number of members of a particular rank? For example how many newbs, juniors, members, full members etc there are? That would be interesting to see.

here you are but stats are from the end of september... if you want more data check full thread:

...
Merit system works about 8,5 month, since introducing 251.653 merits was given for the post writing, they came to 22.547 users (from 2,400,000 users registered what is less than 1%!!!).

Below you can see how many users and number of merit was awarded in each group of users.
You can see that the largest group of users 56,47% who have ever earn merit are users who start their posting career after introducing new system – what means… newbies!!! Looking at numbers of merit the situation is the same this group have earned the largest part of merit (for posting).
Of course you always can say that many of them didn’t get their merit in proper way – bought them, begged for them etc. but it still remains the largest group.
...

░░░░░░░░░░░░░░░░░░░░░░░░░
░░░░░░░░░░░░░░░░░░░░░░░████
░░░░░░░░░░░░░░░░░░░░░▐███████▌
░░░░░░░░░░░░░░░░░░░░███████▌▐██░░░░
░░░░░░░░░░░░░░░░░░▐███████░░████▌▐██▌
░░░░░░░░░░░░░░░░░███████▌░░████████████
░░░░░░░░░░░░░░░▐███████░░▐██████████████▌
░░░░░░░░░░░░░░████████░░██████████████████
░░░░░░░░░░░░▐█████▀▀░░░████████████████████▌
░░░░░░░░░░░█████░░░░░░███████████████████████
░░░░░░░░░▐██████░░░░░░░░██████████████████████▌
░░░░░░░░█████████░░░░░░░░░░█████████████████████
░░░░░░▐█████████░░░░███░░░░░░░███████████████████▌
░░░░░██████████░░░░███████░░░░░░░█████████▌▐██████
░░░▐██████████░░░░███████████░░░░░░░███████░░░░█████▌
░░███████████░░░░███████████████░░░░░░███████░░░░██████

PROSPECTORS    
X
    
X
   
X
   
X
[/td][/tr][/table]
mazdafunsun
Full Member
***
Offline Offline

Activity: 378
Merit: 121

(https://paymentporte.com/


View Profile
October 29, 2018, 11:11:31 AM
 #11

After having some fun with the nice Piggy's Merit Data SQL tool (https://bitcointalk.org/index.php?topic=4551881.0) i realized the total users on the 'UserData' table was a lil more than 30,000. But the last user ID was 2450245.

According to Vod's BPIP database, there are 326,673

30k accounts who have recived merit is not such a small number if you take in account how many users are actively posting in forum.

I have taken time to do user activity research in depth here: https://bitcointalk.org/index.php?topic=5046264.msg46655791#msg46655791
I analysed 2,37 Million users and used several criteria to evaluate user activity.

And one of them was, how many users have made a post in last 3 months. The result was: Including Newbies 137122 users, excluding newbies 31211

This activity criteria is more relavent if we talk about recived merits since non posting users will not recive merit ( except some special cases with very old posts).

Is there any statistic showing the total number of members of a particular rank? For example how many newbs, juniors, members, full members etc there are? That would be interesting to see.

Take a look at the end of the this post: https://bitcointalk.org/index.php?topic=5046264.msg46655791#msg46655791
I believe that this is the " freshest" user data with distrobution by rank.

▄▄▄        Payment Porte        |   digital payment solutions   ▄▄▄
||███      (((  SERNVI SES  )))  ▐ ███  JOIN OUR "Initial Exchange Offering"(IEO)   ███ ▌       ███||
|   WEB SITE  |  ANN  |  Facebook  |  Twitter  |  Telegram   |
iasenko
Hero Member
*****
Offline Offline

Activity: 658
Merit: 1192


WYGIWYD


View Profile WWW
October 29, 2018, 11:22:46 AM
 #12

@mazdafunsun

I was wrong about the active members, I was on a mobile I couldn't get the correct info from BPIP website.
Now, according to Vod, the BPIP's Active Profiles are those who have logged in at least once for the last 3 mounts.
Here is the final update from today > 322,676 Active Profiles

Pages: [1]
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!