![elder scrolls online cross platform elder scrolls online cross platform](https://www.prosyscom.tech/wp-content/uploads/2018/08/Bethesda-to-only-release-The-Elder-Scrolls-Legends-on-Consoles-with-Cross-Play-Gaming.jpg)
And probably even more keys that are not obvious if we do not know details of database structure. And I am sure there is also an account_id.
#ELDER SCROLLS ONLINE CROSS PLATFORM UPDATE#
So you would not only have to give the transferred player a new character_id, but update all those related tables to have the new character_id. Someone on another megaserver, regardless of their character name, probably has character_id 67897895637 on that megaserver. There are probably dozens or hundreds of tables. And that 67897895637 is all over the place linking what inventory belongs to you, what achievements, what quest progression, what mounts, what pets, what guilds, what friends, your guild trader listings, what daily rewards you have claimed, and on and on and on. So your character named "Joe Schmo" might have character_id 67897895637. The various details in game are almost certainly not linked by character names but big gigantic numbers unique to each player. But with a fully populated database, the last thing you want to do is insert bad data that is going to potentially effect other players accounts.ĭestiny 2 went in with the mentality that they'd be doing cross-play, whereas I don't believe that was the case for ESO (obviously). When they had blank databases for Xbox and PS4, these were not big concerns as there wouldn't be any existing IDs that would cause constraint errors when inserting. That ID might be the primary key in one table and a foreign key in various other lookup/reference tables, and given how database constraints work if you try to simply update one value you're going to have reference errors. Every item in the game is going to have a unique identifier, and reconciling these duplicate entries between the different mega-servers when "transferring an account and all it's data to a different database" is a challenge. Names are just a small hurdle to cross, but who would have the right to the unique name? They would most likely have to append every duplicate name with -PC or -Xbox or -PS4, or else you'll get one platform saying they should have the right to the unique name while the other two get the extra text added to it (not going to fly).īut the real hurdle lies deeper in the data.