Search the Community

I run a Soccer management game, which is currently run by email. The player receives a text file, loads it into a client which parses the file, updates it and sends it back to me. I need to rewrite the game since the game itself is over 20 years old and the email method is time-consuming at my end. Here's my plan, I'm not sure if this is correct or if there are better ways, so please offer any advice. I'll put the game online, with a database and it will be processed using PHP scripts (I don't like PHP, I'm much happier in BASIC, but I'll get used to it). The user will log into a web-based client, communicate through middleware (PHP scripts), which will contact the database and send the info back to the client. I think that part is correct? A couple of problems. For the client itself, I don't know which language to use. I'm happiest in BASIC (I'm not actually a very good programmer, though I have completed quite a few games). I'm tempted to use Construct 2 or some other game-maker, to simplify the creation of screens in the script (it's a management game, so it's closer to a spreadsheet than a game, but it does still need to look gamey - i.e like the CM games). But game-makers always seem a bit weak when it comes to listboxes, buttons etc and I'm finding it a bit clumsy. The way it would work would be, when the client logs on, the server sends back the whole team which are stored in C2 as objects, and then every update would just be a call to a PHP script on the server (that part I can handle easily enough). My other issue is the processing of the game itself. Since it's turn-based (a turn being a week in the game), when it's processed, everything needs to be done in one go. So all the matches, training, transfers etc. This is quite a big job (around 30,000 lines long in my existing game) and I'd prefer to do it in BASIC, but that will need an extra step, e.g a tool at my end to download the database, process the turn, then upload it again. I assume the sensible way would just be to process the entire thing in PHP (something I've started but I'm finding very difficult). Any tips or advice?