Post
Topic
Board Beginners & Help
Re: What or how does it feels to grow in rank?!
by
DdmrDdmr
on 03/08/2020, 16:22:14 UTC
The Legendary rank has a special element of uncertainty associated to it, and that is the fact that the specific required Activity is unknown by the account, being somewhere in between the range of 775 and 1030 (*). That’s a pretty wide range, that leaves these legendary-to-be accounts wondering every fortnight if their Activity will surpass the threshold set for their account.

The longer the wait, the more the thrive I figure, although some accounts, for multiple reasons, seem to have dropped the towel in the process. This is a short list of some of those Hero Members that are waiting for their Activity to chime-in:
Code:
user_id   name                                    posts     activity  merit     DateCreate   DateLastAc   URL
1169179   BitCryptex                              1879      1022      1548      2017-09-25   2020-07-31   https://bitcointalk.org/index.php?action=profile;u=1169179
657268    Lionidas                                3305      1008      1012      2015-11-19   2019-03-02   https://bitcointalk.org/index.php?action=profile;u=657268
1339716   coinlocket$                             6251      994       1308      2017-11-22   2020-07-31   https://bitcointalk.org/index.php?action=profile;u=1339716
4839      fornit                                  987       987       1001      2011-02-20   2018-02-11   https://bitcointalk.org/index.php?action=profile;u=4839
245722    Bitcoinmeetups.org                      983       983       1002      2014-02-09   2020-07-12   https://bitcointalk.org/index.php?action=profile;u=245722
230980    patmast3r                               2897      980       1001      2014-01-27   2018-01-27   https://bitcointalk.org/index.php?action=profile;u=230980
238821    david123                                2018      966       1002      2014-02-04   2019-02-16   https://bitcointalk.org/index.php?action=profile;u=238821
120714    gdassori                                1002      966       1002      2013-05-20   2019-05-16   https://bitcointalk.org/index.php?action=profile;u=120714
185404    illodin                                 4838      966       1003      2013-12-09   2018-03-04   https://bitcointalk.org/index.php?action=profile;u=185404
34011     abracadabra                             956       956       1001      2011-07-14   2018-11-07   https://bitcointalk.org/index.php?action=profile;u=34011
35354     dancupid                                955       955       1002      2011-07-22   2020-07-20   https://bitcointalk.org/index.php?action=profile;u=35354
380642    bennana                                 952       952       1001      2014-09-23   2019-04-13   https://bitcointalk.org/index.php?action=profile;u=380642
394642    Cripto DeD                              3151      952       1002      2014-11-13   2019-05-16   https://bitcointalk.org/index.php?action=profile;u=394642
12346     Explodicle                              950       950       1001      2011-05-13   2020-06-03   https://bitcointalk.org/index.php?action=profile;u=12346
223359    noise23                                 942       942       1002      2014-01-19   2020-07-31   https://bitcointalk.org/index.php?action=profile;u=223359
493987    xRaVeNx                                 1614      938       1009      2015-03-26   2020-07-13   https://bitcointalk.org/index.php?action=profile;u=493987
1582324   DdmrDdmr                                5139      938       4013      2018-01-04   2020-07-31   https://bitcointalk.org/index.php?action=profile;u=1582324
182223    murderouskirk                           1354      938       1002      2013-12-06   2018-11-25   https://bitcointalk.org/index.php?action=profile;u=182223
56297     Bitware                                 937       937       1001      2012-04-19   2020-01-08   https://bitcointalk.org/index.php?action=profile;u=56297
3722      Unthinkingbit                           935       935       1008      2011-01-25   2019-11-15   https://bitcointalk.org/index.php?action=profile;u=3722
166737    JuanHungLo                              935       935       1001      2013-11-22   2020-07-13   https://bitcointalk.org/index.php?action=profile;u=166737
73326     elbill                                  970       924       1004      2012-11-24   2019-01-15   https://bitcointalk.org/index.php?action=profile;u=73326
1311641   tvplus006                               2496      924       1271      2017-11-14   2020-07-31   https://bitcointalk.org/index.php?action=profile;u=1311641
1554927   bitmover                                4777      924       1656      2017-12-31   2020-07-31   https://bitcointalk.org/index.php?action=profile;u=1554927
341982    mexxer-2                                4082      924       1003      2014-06-10   2019-10-04   https://bitcointalk.org/index.php?action=profile;u=341982
183495    otrkid70                                923       923       1014      2013-12-08   2018-05-09   https://bitcointalk.org/index.php?action=profile;u=183495
106965    TracerX                                 918       918       1002      2013-04-26   2018-06-01   https://bitcointalk.org/index.php?action=profile;u=106965
451278    leps                                    918       918       1001      2015-02-19   2020-07-16   https://bitcointalk.org/index.php?action=profile;u=451278
339196    yohannc                                 916       916       1012      2014-06-03   2020-07-29   https://bitcointalk.org/index.php?action=profile;u=339196
36319     SgtMoth                                 911       911       1004      2011-07-28   2019-06-26   https://bitcointalk.org/index.php?action=profile;u=36319
17928     piuk                                    1267      910       1001      2011-06-03   2015-06-19   https://bitcointalk.org/index.php?action=profile;u=17928
61493     CaptChadd                               1250      910       1005      2012-07-05   2020-04-09   https://bitcointalk.org/index.php?action=profile;u=61493
183158    JorgeStolfi                             7226      910       1002      2013-12-07   2019-11-30   https://bitcointalk.org/index.php?action=profile;u=183158
64396     Mapuo                                   909       909       1002      2012-08-16   2020-07-04   https://bitcointalk.org/index.php?action=profile;u=64396
That above is a list of Hero accounts that have already surpassed at least half of the required Activity interval, and have yet not reached their personal Activity requirement for Legendary (data as of last Friday).

Note how  @BitCryptex will need to wait until the next Activity window, which should be his last wait (his requires activity is therefore somewhere between 1023 and 1030).

(*) The specific value depends on your UserId:
Just to remind that the Activity required to reach the Legendary rank is a random value that depends on the UserId of the profile, and a secretSeed which, for obvious reasons, we do not have:

<…> Currently this randomness is done with a single SQL query, which is very convenient.

Code:
update smf_members
set ID_POST_GROUP=21
where ID_POST_GROUP=8
and activity>=775 and activity>=775+conv(substr(sha1(concatenate(ID_MEMBER,secretSeed)), 1, 2), 16, 10)
<…>
Note: I had to replace "concat" with "concatenate" in the above quote to be able to publish the post.