Bungie.net Community
This topic has moved here: Subject: Why is the max amount of accounts the eighth Mersenne prime?
  • Subject: Why is the max amount of accounts the eighth Mersenne prime?
  • Pages:
  • 1
  • 2
  • of 2
Subject: Why is the max amount of accounts the eighth Mersenne prime?

Key


Posted by: Achronos
Bungie.net's database (and most of its application code) define a user id as a SQL bigint (a signed 64-bit integer). It is signed because sql doesn't natively understand unsigned numbers, and constantly casting it is annoying. However, in the forum software (which was not written by us, just heavily modified by us) defines member ids as SQL ints (signed 32-bit integers). As it was originally created to have its own member database, it is kind of bolted onto our system (which is why you have two ids - when you see "memberID" in the URL, you're using the forum one).

One of the many things changing when bungie.next comes along is that silly complexity.
Before you figure out what happens when we get up to 2 shmillion members on the site in the year 3057 and it all breaks, can we have a working search bar?

plzndthx.

©

  • 11.22.2012 8:19 PM PDT

"We live in a special time; the only time where we can observationally verify that we live in a very special time" - Lawrence Krauss.

I was a finalist :P

Imagine if the science behind this followed Bungie's and the community's obsession of the number 7. There would only be 524287 maximum accounts permissible before problems would occur.

[Edited on 11.23.2012 3:01 AM PST]

  • 11.23.2012 2:59 AM PDT

Who am I?

mah twitter


Posted by: King Dutchy

Posted by: Bungie Sam
Posted by: lVl e r c u r y
Wait, Bnet is getting 600 new accounts per day? That doesn't sound right...
You'd be surprised. That's an average made from recordings since last October.

Roughly 376 accounts have been made in the last 24 hours.
I want everyone who makes these accounts to say hi to us on the forums.

IS THAT TOO MUCH TO ASK
Clearly it is.

  • 11.23.2012 4:11 AM PDT

GT: j0sh291
"Gentlemen. I be placed at a bewilderment. There I were, resting, when I hear a frightful row on deck. What be that first mate?"
-"Mutiny. And what fate befalls mutineers? I think we know the answer to that, don't we? Mutineers...HANG!!!"

Twitter:@j0sh291
Follower of Christ!

][-][ //-\\ ][_ ((_))

**Does not computes**

  • 11.23.2012 8:59 AM PDT

i c u thar c' ing my signiture

Yours in _Kai_

That's pretty interesting, I never knew about that, or rather, never realized.

  • 11.23.2012 10:15 AM PDT
  • gamertag: [none]
  • user homepage:

It was once said that a million monkeys at a million keyboards could reproduce the works of shakespeare... Now thanks to the internet we know that this is not true
==============================================
No programmer can pick up a TV remote without thinking what it would take to add a stun gun. [...] Their motto is 'if it ain't broke, it doesn't have enough features yet


Posted by: Achronos
Bungie.net's database (and most of its application code) define a user id as a SQL bigint (a signed 64-bit integer). It is signed because sql doesn't natively understand unsigned numbers, and constantly casting it is annoying. However, in the forum software (which was not written by us, just heavily modified by us) defines member ids as SQL ints (signed 32-bit integers). As it was originally created to have its own member database, it is kind of bolted onto our system (which is why you have two ids - when you see "memberID" in the URL, you're using the forum one).

One of the many things changing when bungie.next comes along is that silly complexity.


the database should use bigot for that kind of thing. It is a type that will change form based on its own flawed beliefs.

  • 11.23.2012 10:18 AM PDT
  • gamertag: [none]
  • user homepage:


Posted by: catman6
Posted by: Achronos
which is why you have two ids - when you see "memberID" in the URL, you're using the forum one
What is the second ID. Is it our unique username?

The second id would be the the 64 bit signed version of your member id. It's used for querying the database for whatever data is linked to that ID.

  • 11.23.2012 10:18 AM PDT
  • gamertag: [none]
  • user homepage:


Posted by: Achronos
Bungie.net's database (and most of its application code) define a user id as a SQL bigint (a signed 64-bit integer). It is signed because sql doesn't natively understand unsigned numbers, and constantly casting it is annoying. However, in the forum software (which was not written by us, just heavily modified by us) defines member ids as SQL ints (signed 32-bit integers). As it was originally created to have its own member database, it is kind of bolted onto our system (which is why you have two ids - when you see "memberID" in the URL, you're using the forum one).

One of the many things changing when bungie.next comes along is that silly complexity.


Since you guys heavily modified the code for the Bungie.net forums from an existing code written by someone else, is the code for Bungie.next nearly written from scratch or is it just another modification (albeit a greater one) to the modified code you have already defined.

  • 11.23.2012 10:24 AM PDT
  • gamertag: [none]
  • user homepage:

GrownPrism is NOT my gt. Happened when signing into my xbox live account. My real gt is here:

http://www.bungie.net/Stats/Reach/Default.aspx?player=SYNTHES lS&sg=0

My head hurts.

  • 11.23.2012 3:56 PM PDT

The tide is turning, brothers! Let us take our kingdom back!


Posted by: CaptKrunch 96
My head hurts.
I was never much for Mersenne primes myself.

  • 11.23.2012 7:57 PM PDT

These kinds of threads make me feel stupid.

  • 11.23.2012 9:07 PM PDT

Posted by: spartain ken 15
I would say I am one of the most successful trolls in Bungie.net history.


Posted by: Bungie Sam
Posted by: defnop552
So what happens when it reaches that number? Do new members get deleted account numbers?
Bungie.net won't be here in the year 3967. Nobody will.
Challenge accepted.


Thread saved.

  • 11.23.2012 10:37 PM PDT

Gamers Anon

Achronos: And what's this about a "design team" I've been hearing? Apparently stosh is so awesome he's now considered a "team".

What I gathered from the post made by Achronos is that Bungie.next will not be building on the current website scaffold but will be an entire new one possibly made by Bungie themselves.

  • 11.24.2012 12:32 AM PDT
  • gamertag: [none]
  • user homepage:

SPOOOOOOOOOOOOOOOOOOON!

I was not even aware of the 2038 thing. So I learned something today, and its awesome this site can still do that for me.

Also, good to hear something about the .next, from the source.

[Edited on 11.24.2012 8:49 PM PST]

  • 11.24.2012 8:47 PM PDT

feartehstickman...
Posted by: toxicpanther615
the only problem i have with mine is that it's unstable,[very shakey],so you'd need a tripod for it.

Posted by: CJ Olvaid 360
Just drink a beer and everything will be ok

Will the large majority of computers not have moved past 32 bit OSs by the year 2038? Or just use a uint for a few more years of safety.

But a 64 bit int, signed, should last until the year 292,471,210,647, which is probably long enough, isn't it?

I'm not sure of all the complexities, but simply doubling the size of the value used to store the time would seem to completly solve the problem. Of course, this might be complicated slightly by the fact that you need to do it to EVERY COMPUTER EVERYWHERE.
Posted by: Muzza777
What I gathered from the post made by Achronos is that Bungie.next will not be building on the current website scaffold but will be an entire new one possibly made by Bungie themselves.
Could be why it has taken such a long time, if they are rebuilding everything from the ground up.

[Edited on 11.25.2012 12:38 AM PST]

  • 11.25.2012 12:36 AM PDT

<_QuAnTuM_>
What's your talent?
Posted by: DabilahroNinja
I can see through windows.

Posted by: WinyPit82
Like they always say, "You mess with the Helix Nebula, you get the WinyPit82."

Hi there! be sure to click that homepage link!


Posted by: King Dutchy

Posted by: Bungie Sam
Posted by: lVl e r c u r y
Wait, Bnet is getting 600 new accounts per day? That doesn't sound right...
You'd be surprised. That's an average made from recordings since last October.

Roughly 376 accounts have been made in the last 24 hours.
I want everyone who makes these accounts to say hi to us on the forums.

IS THAT TOO MUCH TO ASK
This is truly epic, we need more people actually active.

  • 11.25.2012 2:21 AM PDT

Posted by: Domi 233The concern (AFAIK) isn't with the OS or the computer's architecture, but rather the data types that have been used to represent a UNIX timestamp within the application. Unfortunately there are devices which contain software that cannot be upgraded, especially those with embedded systems (microwaves, calculators, car subsystems, etc...).

As far as using unsigned types, they will work, but since UNIX time is measured as the number of seconds from the 1st of January, 1970 (referred to as the epoch), any times before then are represented as negative numbers. Of course, you could alter the epoch to encompass more... relevant dates, but at the cost of interoperability with other systems (which would be a huge problem in regard to web services where UNIX timestamps are often used).

  • 11.25.2012 2:46 AM PDT

Rain, and Jazz.
Halo: Tactical

I'm either a fool or an inteligent man, depending on how sleepy or angry I am.

I originaly made an account on 07.27.2007 but I wanted to link my GT and made this account. Don't forget your passwords!

I have learned so much because of this thread and wikipedia. I think I spent about an hour just reading stuff.

  • 12.02.2012 3:43 PM PDT

Is anything you all are saying food? Cause it's making me hungry, I could use food.

  • 12.02.2012 5:28 PM PDT

  • Pages:
  • 1
  • 2
  • of 2