Have one user whoe data causes problems

{"region": "EU", "homeRealmName": "Ревущий фьорд", "user_auctions": [{"price": 99100, "itemID": 191476}]}

the api is mapped to the english realm name so if forigen game versions mess with this we need the realm id

the only issue is that the in game realm id is different from the api realm id so we will have to remap everything to switch over

here are the eu and us/na realm names attached to ids from the api, all of our database tables are named after the realm id. for example all of the US-thrall market data is under the table 3678_singleMinPrices so we need the correct realm id to connect the data. Here are the list of realm names attached to the realm ids

realm-ids.zip

the problem is that when we look for realm ids ingame the int values linked to each realm is totally different. so we need to map the in game realm ids to the api realm ids and then we can stop using the realm names as that breaks for realm names in other languages and especially languages like russian that use different letter systems.