Kurdanak Posted April 6, 2017 Share Posted April 6, 2017 Does this explain why the total amount of money in the game went from about 98 billion to 149 billion?You can thank Rose's economics team for that one. We had been saving our craftiest stuff for the post 2500 member stage. 1 Link to comment Share on other sites More sharing options...
Shakyr Posted April 6, 2017 Share Posted April 6, 2017 (edited) Was trying to move my nation into Rose so that I could easily deposit some stuff into their bank for the bank bug. Accidentally moved every nation, instead of just mine.Thank you for the laugh As a web developer myself, I know how easily it can be to screw up an SQL query. I am curious though how your database is setup, that you would need to run an SQL query to "move" a nation to an alliance, as opposed to just simply directly editing your existing nation record (a much safer way). I do the latter sometimes for work, in order to move my user from one account to another. EDIT: You may also want to think about creating a script to "deposit" money into or "withdraw" money from an alliance bank and lock it to your user account, within the code. Stick a simple UI on it, where you can select the alliance, the amount of money and whether to deposit or withdraw, and you can stay out of the database entirely. There's a bunch of other stuff for work that I do on a regular basis, that have scripts setup with a basic UI, quite simply so I don't have to !@#$ about with the database. Especially in the cases where a dozen or two values are being changed across half a dozen tables. Edited April 6, 2017 by Shakyr Link to comment Share on other sites More sharing options...
Administrators Alex Posted April 6, 2017 Author Administrators Share Posted April 6, 2017 Thank you for the laugh As a web developer myself, I know how easily it can be to screw up an SQL query. I am curious though how your database is setup, that you would need to run an SQL query to "move" a nation to an alliance, as opposed to just simply directly editing your existing nation record (a much safer way). I do the latter sometimes for work, in order to move my user from one account to another. EDIT: You may also want to think about creating a script to "deposit" money into or "withdraw" money from an alliance bank and lock it to your user account, within the code. Stick a simple UI on it, where you can select the alliance, the amount of money and whether to deposit or withdraw, and you can stay out of the database entirely. There's a bunch of other stuff for work that I do on a regular basis, that have scripts setup with a basic UI, quite simply so I don't have to !@#$ about with the database. Especially in the cases where a dozen or two values are being changed across half a dozen tables. I could've done it the way you suggested, it's normally just quicker to type out my query rather than write a query to select my nation, then another to update it. And yeah, I should write a UI for a lot of admin stuff, it would make my life easier in the long run, but in the short run it's a lot of work May be necessary if something like this ever happens again. Is there a bug? Report It | Not understanding game mechanics? Ask About It | Got a good idea? Suggest ItForums Rules | Game Link Link to comment Share on other sites More sharing options...
hadesflames Posted April 6, 2017 Share Posted April 6, 2017 Was trying to move my nation into Rose so that I could easily deposit some stuff into their bank for the bank bug. Accidentally moved every nation, instead of just mine. WHERE `nationid` = 6; For next time. Link to comment Share on other sites More sharing options...
Bluebear Posted April 7, 2017 Share Posted April 7, 2017 (edited) Is no one else worried about the effects that a 50% increase in the money supply will have? Edited April 7, 2017 by Bluebear Link to comment Share on other sites More sharing options...
Zaxon Posted April 7, 2017 Share Posted April 7, 2017 Was trying to move my nation into Rose so that I could easily deposit some stuff into their bank for the bank bug. Accidentally moved every nation, instead of just mine. This pales in comparison to the Test server money bug that gave everyone a Quintillion dollars. "Greatest glitch of all time !" Link to comment Share on other sites More sharing options...
Yang Posted April 8, 2017 Share Posted April 8, 2017 Is no one else worried about the effects that a 50% increase in the money supply will have? Not really. It just goes into more cities, watchest, infra. Link to comment Share on other sites More sharing options...
Kamea Arano Posted April 8, 2017 Share Posted April 8, 2017 "It just works." - Todd Howard, Bethesda Terms of Service | Wiki | Contact Me Link to comment Share on other sites More sharing options...
Lail Das Posted April 8, 2017 Share Posted April 8, 2017 (edited) This pales in comparison to the Test server money bug that gave everyone a Quintillion dollars. "Greatest glitch of all time !"Please tell me about that. I would like to know how it happened so that I can duplicate it be knowledgable. Edited April 8, 2017 by Lail Das "Realism is irrelevant unless it's the real world" - Lail Das Link to comment Share on other sites More sharing options...
Administrators Alex Posted April 10, 2017 Author Administrators Share Posted April 10, 2017 Does this explain why the total amount of money in the game went from about 98 billion to 149 billion? Just an FYI, I mentioned it elsewhere but I'll say it here as well. When I was fixing things (depositing money into alliance banks) I had thrown about 50 billion into my nation, and then after I was done I removed it. That's why you saw the 'total money in-game' fluctuate the way it did. Is there a bug? Report It | Not understanding game mechanics? Ask About It | Got a good idea? Suggest ItForums Rules | Game Link Link to comment Share on other sites More sharing options...
Vladamir Putin Posted April 10, 2017 Share Posted April 10, 2017 Just an FYI, I mentioned it elsewhere but I'll say it here as well. When I was fixing things (depositing money into alliance banks) I had thrown about 50 billion into my nation, and then after I was done I removed it. That's why you saw the 'total money in-game' fluctuate the way it did. ... note to self, when you see Alex is online, invite a friend to play the game, have him 0 his infra, declare war on alex, give him enough money for 5 cities and a military, and have a chance of stealing billions. (I really wonder how you'd respond to this ) Link to comment Share on other sites More sharing options...
Administrators Alex Posted April 10, 2017 Author Administrators Share Posted April 10, 2017 ... note to self, when you see Alex is online, invite a friend to play the game, have him 0 his infra, declare war on alex, give him enough money for 5 cities and a military, and have a chance of stealing billions. (I really wonder how you'd respond to this ) I generally don't do this, and I generally have between $0-$10,000 on-hand at any given time, due to frequent raiding. Is there a bug? Report It | Not understanding game mechanics? Ask About It | Got a good idea? Suggest ItForums Rules | Game Link Link to comment Share on other sites More sharing options...
Recommended Posts