I’m currently developing a PC game in C# where you instantiate buildings to a terrain to build your own village. That works fine so far.
My problem: I would like to give those buildings different, specific tasks, e.g. building 1 is a bank and generates money (e.g. 100 money units per hour) which is used to build/ upgrade other buildings. But I would also like the bank to generate money while the player is offline. So I need something like a 24/7 online server that generates the money and the playerclient just gets this value from the server. This way I also prevent cheating, because the important stuff is handled not on the players local PC. I also thought about a register/ login system in future.
How can this be achived in the easiest way ? I don’t think SQL databases can e.g. add a certain amount of money/ units to a specific playeraccount every hour, or do they ?
Thank you for reading!