Topic: [Merit Analysis] Users ranked Sr. Member & up that have not earned any merit (Read 1004 times)

What is the account name? 4 years is too much for my own archives, but for instance archive.org might have what you're looking for.

i mailed through old mail but they asking a post with my btc adress posted ..
but hacker deleted all my such type of post

How did you try contacting the admin? If through PM, it's not the most effective way to get their attention to your issue.

---

Do you still have access to the email address you used to register?
Can you sign a message from an old address posted on your account?

The support for lost or hacked accounts is moving again and you can now quickly recover your lost accounts.

nice to see my old.id in your list .Actually iam.old senior.member but my account got hacked so never used my merit or not I got any single.
Tried to contact Admin many time but no reply from 4years

Thanks for the info. I didn't know that.
will you still update the data (as noted by LoyceV)?

i only ask because i posted a part of your data in the german subforum for information

Sure you can Piggy created Open scraped data of all the users - SQL Lite DB - 2.437.064 users last week. I'd be very interested to see your statistics updated.

The stats listed in the OP are about users that have interacted in some way with merit (either sent or received).

You can't really tell how many users there are since there is no complete data base that holds all the users, to be able to cross reference and get everything.

it is of course also a lot harder to get merit if you have a high rank. but it is also good if the sMerits are given to low ranks so that you can be promoted.

would it be possible to only consider users who have been online since the introduction of the merits (i.e. at the beginning of 2018) and also posted something?
i think the statistics might be somewhat falsified by orphaned profiles.

Those seniors and heroes, who for almost a year couldn`t earn at least 1 merit, don`t worry about it at all. These are users who see their goal on the forum in participating in bounty campaigns. Senior and hero rank allows you to earn pretty good money. And since the majority of signature campaigns don`t require a certain amount of merit to participate (they pay attention only to the rank), its participants are well settled without merites, and see no reason to strive, since they are already in fairly good conditions.

The results of merit data analyis made by @cryptovigi, shown that there are un-significant difference between lower- and higher-ranked users in the forum in terms of ability to earn at least one merit via their really construtive stuffs.
Only Ledgendary rank is different from other ranks.
It means there are so many shitty Senior and Hero users around the forum. They have been unable to earn at least 1 merit point almost 10 months after the day merit system and new rank requirements implemented.

As you know I was the one who challenged vlad230 to make this analysis.

Unfortunately I’ve read that this results due to a limited only data source (only given and received merits) its results may be far from the reality.
I was really interested in the results, so I was looking for a way to make this analysis in a more appropriate way. I didn’t find a database which contains all users who was airdropped a merit, I didn’t find also a database with current number of users and their ranks and the number of merits held…. But I found some further threads by mazdafunsun who scraped first 2 million users of Bitcointalk in July this year https://bitcointalk.org/index.php?topic=4901670.0;all and decided to take take this numbers to make some comparison….

I took this number than checked how many users has ranked up since July. To check it I took all users who has received any merit from https://albertoit.github.io/Merit-Explorer-SQL/ than checked current merit number on the bitcointalk.com site. After deduction I got the number of airdropped merit to each user (who have received at least one merit). Then I checked once again on merit explorer number of merit given till July. Thanks to that I was able to correct mazdafunsun’s result with rank promotions
by merit since July (there still be some inaccuracy because probably some users has been promoted since July by activity, unfortunately I have no way to check it...)

After comparing these results with given merit in merit explorer I’ve received such set of data:


As you can see, my results differ significantly from vlad230's and the numbers are few times bigger.

@vlad230: I think that case you should update numbers or description in your opening post...

It looks like there are really plenty of high ranked users who hasn't earn even one merit yet. Probably some of them are "dead souls" - users who aren't active for many month or even years, but for sure there are as well a lot of "ranked" users who simply didn't deserved any merit yet. This number decreases (percentage) with the increase of rhe rank, but its level in all groups (maybe exept Legendary) remains high.

So  guys look at these numbers and be little more lenient for newbies and jr. members  as you see the rank not always it determines their value...

I don't agree with both of you because just hanging on here but not giving anything to other members for years wouldn't mean anything at all to me.

Demoting them back to the newbies by just simply disregarding the activity they achieved through their career is not an option too.

What I think is the answer is laying between above two options. How about if we implement a system for trigger( having opptunity to award merits)the airdrop merits only when a user earned some predefined merits. By that way we can reduse most of the merit abuse cases where users tends to giving away merits for their alt accounts.

I don't know why people are so worrying and anylizing about the never sent portion since it's nothing to do with the number of users ranked Sr. Members &  up that have not earned any merit. Why we just couldn't consider the received sMerits part only because I have seen that some members still didn't shared their intial airdrop merits at least once.

There is a public data dump which was published (it gets refreshed every Friday). Piggy took it and created a MySQL DB from it & a basic UI to query it here: https://albertoit.github.io/Merit-Explorer-SQL/

If you're not familiar with SQL you can find a lot about it online. It's the most common DB querying language available right now.
A good place to start would be: https://www.w3schools.com/sql/

I was really inspired by your post especially in technical aspects. If you may I would like to ask you on how did you extract the data for this forum? Is it really alright for the admin if one will going to do like this? I am not against this type of post taking some technical aspects of the forum in fact I was curios on one how to extract data for this forum? Is the forum not secured and could be access its system or breaching the system?

This makes sense. It also means my initial assumption that I expected much higher numbers was correct.

I could quite easily produce a complete list of all higher ranked accounts with no Merit, especially since the number of accounts involved will never go up again, but I don't really want to download 2.5 million profiles just for this. It doesn't feel right to download 120 GB from the forum for something that isn't really important.
Maybe @Vod can provide a list of all user ranks since the Merit system, it would be easy to cross-reference this list with the list of merit receivers.

Yeah, please refer to the previous posts.

I have checked the UserData table, as DdmrDdmr said, it has only 29039 records which is a lot less that the current 2 mil members. @Piggy, any chance we could have a more detailed UserData table to be able to extract more information? I can also help with this task.
So, indeed, a lot of users are missing from the DB and this could only reflect a small portion of the users. I have updated the disclaimer.

Thanks a lot! Yes, that's where I'm getting the stats from.

Ok, I understand what you're saying now and yes, you are correct. The SQL is correct but the DB is not listing every user, I wasn't aware of this.

Anyways, even if this is a subset of the data here, we still have an idea on what is going on.

I wouldn't go that far... They hanged on here for years and raised the activity. That has to be worth something.

Maybe I didn’t explain my point clear enough. Let’s put it this way:

What your OP wants to list:
“Ranked Members - Member and above who was given merit airdrop (while introducing merit system) according to their ranks and didn't earn even one "by themself" this one maybe interesting!!!”

What you are really listing:
Members in the UserData table, that have not earned a single merit. Now the key is in understanding what is in the UserData table:

I use a very similar table as @Piggy’s, with exactly the same number of records: 29.039.Those 29.039 people in the table are those involved in a sMerit TX at any point in history. That is, those that have either sent sMerit, receives sMerit, or both.
Any user that has never sent nor received sMerit is not in the UserData table, which is likely the majority of cases that you are looking for.
So my point is that you are listing a different set of users to the intended objective (a subset really).

Note: There’s nothing wrong with Piggy’s database (it's rather similar to mine). It’s a good starting point for people that want to query and not download data themselves, buy we need to understand exactly what the tables hold. It is not a SQL issue, but a comprehension on the data in the DB.

You know what is more interesting? Demoting them back to newbie

It took me 20-minute surfing some topics in Altcoin Discussion and I found this result. All are hero-ranked, established citizens of Altcoin Discussion board, without a single merit from default and not included in your list:
https://bitcointalksearch.org/user/lobo13hf-332316
https://bitcointalksearch.org/user/nonbody-370057
https://bitcointalksearch.org/user/kasabus-849498
https://bitcointalksearch.org/user/maydna-524153
https://bitcointalksearch.org/user/pungopete468-194388
https://bitcointalksearch.org/user/ice098-105609
https://bitcointalksearch.org/user/babylon-454
https://bitcointalksearch.org/user/jayc89-142423
https://bitcointalksearch.org/user/crypto-549786
https://bitcointalksearch.org/user/poodle63-290496
https://bitcointalksearch.org/user/btcjoin14-372130
https://bitcointalksearch.org/user/jack1111-539927
https://bitcointalksearch.org/user/jjdub7-91051

I believe the real numbers are much more larger than your result. Besides, I think there should be a demoting policy to these members. Look at their post histories, you'll see that all of their posts are in mega spam threads.