Quote from: uki on October 11, 2016, 12:24:46 PM

Quote from: botany on October 09, 2016, 12:54:29 AM

Theymos has detailed how this is actually done. It depends on your id.
And of course, a secret seed

Quote from: theymos on August 11, 2014, 05:12:19 PM

...
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(concat(ID_MEMBER,
secretSeed)), 1, 2), 16, 10);

The required activity level per user is suitably random for betting, but anyone who can read my code (there are a few such people) will be able to exactly predict when someone will become Legendary, so I don't really recommend it.

Thanks for posting this. Now that I see the code, I am fine and waiting. I passed the 903 mark, meaning that the first bit of my converted hash was '1'. That is the unlucky half, who has to wait longer.
Shoudn't be that long any more, and hopefuly my substring isn't 'FF'.

And I finally got upgraded, when changing from 910 to 924. It means that the first two bytes of my hash were between 87 and 95. Good to get there and I wish all waiting members to become Legendary in the next activity upgrade.