- Achronos
- |
- Bungie.net Overlord
Tom Achronos
Bungie.net Overlord
twitter: http://twitter.com/Achronos
"I have no words that would do justice to the atrocities you commit to the English language, as well as your continued assaults on the concepts of basic literacy and logical reasoning."
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.