After 10K there will be some kind of exclusive membership.

A private board, only accessible for users with 10k Merit? That's going to be boring for a while.
Legendary: Somewhere between 775 and 1030 activity
does anyone know if that number determined when you sign up ~?
As far as I know: yes:
To make things more fun, the Legendary membergroup has no universal activity requirement. You are guaranteed to become Legendary somewhere between 775 and 1030 activity, but the exact point in this range at which you become Legendary is random per user.
That's very interesting! How is it implemented technically? Did you generate a new row for every user once-off (I suppose a few hundred k rows aren't too bad), or use something like the hash of UID + a salt to determine the point?
use something like the hash of UID + a salt to determine the point?
That's what I did. It just takes the first byte of the SHA-1 hash of UID+salt and adds it to 775. There aren't many users with more than 775 activity, so checking people for upgrades every 10 minutes doesn't cause any problems. I was able to do it with just one SQL statement because MySQL has a built-in SHA-1 function.