Thanks for explanation guys, it really makes sense. I never noticed it was the int limit since I was mostly transferring large sums to planet so never really saw how much it took from my account, but when I tried to withdraw 3b the other day I saw it took like 2,214,xxx,xxx whatever it is..
Hope you can come up with a workaround for the re-coded version
I am "hoping" to reduce the cost of everything, I was thinking the other day about the economy, had a chat with a few friends how they would do it and most of us chose the following:
The database still stores the currency in the database as a Signed INT, however it displays it an Copper, Silver, Gold and maybe Platinum.
So if it had 116G 38S 91C that would store in the database as 1,173,891, so it would stay the same in the database but its displayed the new way if you get me.
So a player would in theory be able to have a currency of 2,147,483,647 stored in the database but display as 214P 748G 36S 47C.
So the following:
100 Copper = 1 Silver
100 Silver = 1 Gold
1000 Gold = 1 Platinum
But I plan to make the game not be able to get that high.
Basically a BIG INT is just so over the top, +18,446,744,073,709,551,615 come on.
So that's what I am "thinking" of doing.