[Merit Analysis] Users ranked Sr. Member & up that have not earned any merit

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: Netflixseller110 on November 11, 2021, 07:13:13 AM

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

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.

Netflixseller110

newbie

Activity: 27

Merit: 0

Quote from: Upgrade00 on September 30, 2021, 06:03:59 PM

Quote from: Netflixseller110 on September 30, 2021, 05:17:11 PM

Tried to contact Admin many time but no reply from 4years
Sad

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.

Quote

If your account was hacked

Email [email protected], ideally from the account's email address. Include your username and a brief description of the details of how/when the account was hacked. A signature will likely be required (see below).

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

Upgrade00

legendary

Activity: 2030

Merit: 2174

Professional Community manager

Quote from: Netflixseller110 on September 30, 2021, 05:17:11 PM

Tried to contact Admin many time but no reply from 4years
Sad

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.

Quote

If your account was hacked

Email [email protected], ideally from the account's email address. Include your username and a brief description of the details of how/when the account was hacked. A signature will likely be required (see below).

Netflixseller110

newbie

Activity: 27

Merit: 0

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
Sad

mole0815

staff

Activity: 2310

Merit: 2632

Join the world-leading crypto sportsbook NOW!

Quote from: vlad230 on November 13, 2018, 06:43:48 AM

Quote from: mole0815 on November 13, 2018, 03:38:24 AM

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.

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.

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

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: vlad230 on November 13, 2018, 06:43:48 AM

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.

Sure you can Cheesy

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.

vlad230

sr. member

Activity: 616

Merit: 279

Quote from: mole0815 on November 13, 2018, 03:38:24 AM

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.

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.

mole0815

staff

Activity: 2310

Merit: 2632

Join the world-leading crypto sportsbook NOW!

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.

Direwolve735

full member

Activity: 448

Merit: 232

Quote from: dumedoiiph on November 04, 2018, 11:34:04 PM

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.

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.

dumedoiiph

member

Activity: 97

Merit: 12

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.

cryptovigi

hero member

Activity: 714

Merit: 611

Quote from: vlad230 on October 01, 2018, 10:59:47 AM

1. How many Sr. Member & up users exist that have not earned any merit?

Code:

1078 Sr. Members
476 Hero Members 
224 Legendary Members

There are 1778 users ranked Sr. Member & up that have not earned any merit, they just got "airdropped" merit from when the merit system was 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:

Rank	number of users	number of users received at least 1 merit	number of users with who didn’t earn any merit
Member	27 918	4 744 (17%)	23 174 (83%)
Full Member	18 181	3 173 (17,45%)	15 008 (82,55%)
Sr. Member	9 016	1 818 (20,16%)	7 198 (79,84%)
Hero Member	4 143	1 105 (26,67%)	3 038 (73,33%)
Legendary	2 145	1 133 (52,82%)	1 012 (47,18%)

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...

vphasitha01

full member

Activity: 196

Merit: 172

Quote from: vlad230 on October 02, 2018, 03:38:41 AM

Quote from: mu_enrico on October 02, 2018, 01:04:58 AM

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

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

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.

Quote from: DdmrDdmr on October 02, 2018, 02:32:10 AM

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).

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.

vlad230

sr. member

Activity: 616

Merit: 279

Quote from: manfredmann on October 02, 2018, 10:35:04 AM

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?

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/

manfredmann

member

Activity: 518

Merit: 21

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?

Veleor

legendary

Activity: 1484

Merit: 1653

Rêlêå§ê ¥ðµr MïñÐ

Quote from: vlad230 on October 01, 2018, 10:59:47 AM

4. Who are the Legendary users that have not earned any merit?

Code:

UserName	Rank
10000usdperbtc	Legendary
2double0	Legendary
50cent_rapper	Legendary
5ick3uffalo	Legendary
7788bitcoin	Legendary
A L I E N	Legendary
AcoinL.L.C	Legendary
Akka	Legendary
Amel	Legendary
Anarchy101	Legendary
AngusCanine	Legendary
Asatur	Legendary
BCEmporium	Legendary
Bimmerhead	Legendary
BitCoinNutJob	Legendary
BitNow	Legendary
BitcoinEXpress	Legendary
Boussac	Legendary
CrackedLogic	Legendary
DGulari	Legendary
Dewi Aries	Legendary
Dogedigital	Legendary
Dotto	Legendary
Dux2K	Legendary
Emerge	Legendary
FlensGold	Legendary
Geenstijl	Legendary
GhostPlayer	Legendary
Gianluca95	Legendary
Gizfreak	Legendary
Googlulinks	Legendary
GreatOrchid	Legendary
Griffith	Legendary
HappyS	Legendary
Hyperjacked	Legendary
IBGigglin	Legendary
IMZ	Legendary
Jasad	Legendary
Jayjay04	Legendary
Kepasa	Legendary
Kupsi	Legendary
Kushedout	Legendary
LastClingon	Legendary
Lebubar	Legendary
MaRSe	Legendary
Matt9301	Legendary
Mervyn_Pumpkinhead	Legendary
MickGhee	Legendary
Micky25	Legendary
MinermanNC	Legendary
Monnt	Legendary
MonsterV	Legendary
MsCollec	Legendary
Nahl	Legendary
ONLYfree	Legendary
Paraka	Legendary
Patel	Legendary
Pipesnake	Legendary
Prelude	Legendary
Republikcoin.com	Legendary
RoooooR	Legendary
Shkembe	Legendary
SmartIphone	Legendary
Snail2	Legendary
Southpaw0	Legendary
Strongkored	Legendary
SwingFirst	Legendary
Tauja	Legendary
Taxidermista	Legendary
TheKoziTwo	Legendary
Tony116	Legendary
Tyke	Legendary
Undermood	Legendary
Winner	Legendary
Wusolini	Legendary
YarkoL	Legendary
Zadicar	Legendary
Zicadis	Legendary
Zich	Legendary
Zombie123	Legendary
ZyTReX	Legendary
ahmedjadoon	Legendary
aikklond	Legendary
aistto	Legendary
aleandromagno	Legendary
andulolika	Legendary
anirgu	Legendary
anref	Legendary
anticlimax	Legendary
bassdude	Legendary
benthach	Legendary
bitcon	Legendary
bithalo	Legendary
bitmaster1x	Legendary
bittaitaliana	Legendary
bitwho	Legendary
bms2013	Legendary
boestin	Legendary
brian_nguyen	Legendary
bspus	Legendary
buygazprom	Legendary
cagrund	Legendary
chryspano	Legendary
corather	Legendary
crunck	Legendary
dadingsda	Legendary
danherbias07	Legendary
dave111223	Legendary
david1365	Legendary
dbt1033	Legendary
deblue	Legendary
dimox	Legendary
dinda22	Legendary
djnocide	Legendary
dload.1	Legendary
dnaleor	Legendary
dopecoindude	Legendary
dunfida	Legendary
e1ghtSpace	Legendary
edmundduke	Legendary
enhu	Legendary
eroxors	Legendary
escalicha	Legendary
etoque	Legendary
farl4web	Legendary
flower1024	Legendary
frankenmint	Legendary
gnargnar	Legendary
goxed	Legendary
grandFX	Legendary
guigui371	Legendary
hahay	Legendary
hazarun	Legendary
hdd3go	Legendary
helloge	Legendary
hiddensphinx	Legendary
hurricandave	Legendary
ifightformerkel	Legendary
innocent93	Legendary
ivan1975	Legendary
joele	Legendary
johny08	Legendary
joksim299	Legendary
keithers	Legendary
keyscore44	Legendary
killerjoegreece	Legendary
klf	Legendary
kondiomir	Legendary
koshgel	Legendary
kronkodil	Legendary
lionheart78	Legendary
liteon	Legendary
logocreator	Legendary
lolxxxx	Legendary
lottery248	Legendary
louiseth1	Legendary
lowbander80	Legendary
makishart	Legendary
malekbaba	Legendary
mamamae	Legendary
mastertrader777	Legendary
matveevka	Legendary
maxll	Legendary
maza5	Legendary
mettalmag	Legendary
michietn94	Legendary
moppang	Legendary
moxl	Legendary
nekochan05	Legendary
neolinkhati	Legendary
nizamcc	Legendary
numismatist	Legendary
ny2cafuse	Legendary
oli123123	Legendary
pandacoin	Legendary
pbleak	Legendary
pickupcoin	Legendary
piebeyb	Legendary
polynesia	Legendary
qwed	Legendary
rdnkjdi	Legendary
reb0rn21	Legendary
redjedievolution	Legendary
roadbits	Legendary
rodrigobitcoin	Legendary
s1ng	Legendary
sana54210	Legendary
sardokan	Legendary
schnötzel	Legendary
serje	Legendary
server	Legendary
shaklov	Legendary
silverbox	Legendary
snipsnoop	Legendary
splawik21	Legendary
srgkrgkj	Legendary
stahanovec	Legendary
supermoney	Legendary
sureshnsnet	Legendary
tair85	Legendary
takagari	Legendary
tarmi	Legendary
the_poet	Legendary
thefunkybits	Legendary
tiggytomb	Legendary
tiozes	Legendary
tobeaj2mer01	Legendary
toptek	Legendary
uki	Legendary
unamis76	Legendary
usao	Legendary
varanvaran	Legendary
viboracecata	Legendary
vladimirushev	Legendary
vokain	Legendary
wachtwoord	Legendary
wadili89	Legendary
winter	Legendary
wonko86	Legendary
wpalczynski	Legendary
wuqing78	Legendary
xsentus	Legendary
yslyung	Legendary
zork	Legendary

Three legendaries from the list have been banned:

[BPIP] 10000usdperbtc
[BPIP] chryspano
[BPIP] hdd3go

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: DdmrDdmr on October 02, 2018, 02:32:10 AM

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.

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.

vlad230

sr. member

Activity: 616

Merit: 279

Quote from: Quickseller on October 01, 2018, 07:49:02 PM

I think your list might be incomplete. See https://bitcointalksearch.org/user/acctseller-357263 a hero user who has not received any merit but is not on the list.

I suspect the number is far greater than what you say. If memory serves me correctly, well under 1% of all active accounts have received at least one merit as of a month or two ago.

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.

Quote from: cryptovigi on October 01, 2018, 06:01:21 PM

Man you are great!!! As I see you are really fan of stats!!!
Anyway great work and thanks for taking my challenge... I find this results quite interesting...

I'd like to play myself with such database... Few days ago i fonud only Bitcointalk Merit Dashboard by DdmrDdmr but the problem was i could download data to make some analysis on my own only in pdf format ;-( (which sucks for such purposes).
Today I read here about Piggy's SQL https://albertoit.github.io/Merit-Explorer-SQL/ - I understand that this is the source of your analysys?

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

Quote from: DdmrDdmr on October 02, 2018, 02:32:10 AM

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.

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.

Quote from: mu_enrico on October 02, 2018, 01:04:58 AM

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

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

DdmrDdmr

legendary

Activity: 2310

Merit: 10758

There are lies, damned lies and statistics. MTwain

Quote from: vlad230 on October 01, 2018, 05:03:40 PM

<…>I understand your concerns but I believe my queries are correct. I'm using a more complicated approach, research SQL JOINS.<...>

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.

mu_enrico

copper member

Activity: 2324

Merit: 2142

Slots Enthusiast & Expert

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

TeQuiero

member

Activity: 120

Merit: 38

Quote from: vlad230 on October 01, 2018, 10:59:47 AM

Please let me know what you think. Have you expected these results?
Also, if you have any ideas on what would be interesting to see related to users & merit, please let me know

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