-snip-
Sorry, I found it. But still, you need to know how to read this code ...
-snip-
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.
The problem is that we dont know what the "secretSeed" is, thus a proper prediction on the exact result in only available for those that have access to the full code.
We just need to pay off some mod. Question is if that secretSeed is account specific or global.
I think I saw that it was specific for each account (but I may be mistaken).
The exact amount of activity required to become legendary varies from user to user, however the secret seed is global.
In theory, if you were to monitor when enough users are promoted to legendary status, it would be possible to reverse engineer what the secret seed is (you would however need to take into consideration that the required activity for each member may not be divisible by 14), although it would probably take more effort/work then it is really worth.
Aha, yes, if the secret seed is global then, as you say, the secret seed is the only missing variable if you track exactly when users become legendary---you'd just have to solve that equation for secretseed. However, you're also right that, uh, who cares? Legendary doesn't get you any further forum rights, as far as I know it's just a cute title.
Well there are roughly 440 legendary members (as of when I checked yesterday) and roughly 1880 (as of just now) (both may be off by up to 40), so there is a bit of an additional prestige level to have a legendary account verses having a hero account.
You are right though, a legendary account does not have any additional forum permissions or features that are not available to hero accounts.
Can I ask you how do you know the secretSeed is univocal for all the forum users? Is it only your supposition or have you asked someone from the staff?
That is what a secret seed is, it needs to be the same for multiple people/bets Actually no it doesn't now that I think about it.
Although theymos has said that it is possible to reverse engineer when each user will become legendary if you can read his code, which would imply that the secret seed is the same for each person. Also I really don't think it would really be worth the trouble to be creating a new secret seed for each user as there is really nothing at stake and the fact that the client seed (aka the UID #) cannot be changed by the user.
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.