2010-07-27, 12:12 PM
Cyanne Wrote:For some reason, when he was sent a wedding invite, it went to his first one instead of his second one, which he's now actively playing, but everything else works as he's logged on.
Consider the database:
| UserId | CharacterName |
|---|---|
| 1 | Bob |
| 2 | Bob |
Anytime you ask for Bob and only parse the first result you get, you're going to get #1 because the database is physically structured by the ID, which is a factor of creation date.
What's interesting is this means you can have two bobs on different accounts, which would then both be able to be logged in simultaneously due to these rollbacks. Imagine the damage that can cause.