First post here, so nice to meet you all. 🙂

I currently run a virtual football league on Discord, and we have all of our stats on our website. The website’s database is hosted by phpmyadmin. The league is played on a football game from PS2 using the PCSX2 emulator. I have a save file editor of the game that is run on JavaScript.

Since we started about 2 1/2 years ago, I’ve been manually updating every player’s stats based on the database reports. However, as more players have joined and we have our eyes on expanding, it’s getting to be too much work for me to manually update all player stats.

I’m thinking a way to solve this problem would be to have programs that do the upgrading and checking for me so that I can focus on other things in the league and thus lessen the amount of time I need to focus on upgrading all players. However, I wouldn’t know where to begin. I have a pretty basic understanding of Python and web-dev tools, but I know next to nothing about JavaScript.

What would you suggest are good ways to proceed? I’m not asking for a fully-fleshed out idea with code, but I’d particularly appreciate some good ideas that would be long-term and good to play around with. Maybe I could place the save file editor in my website and play around with it there (it has a GNU License so it should be alright)? Or maybe I’d need to create JavaScript code that would communicate with the save file editor, our website’s database and my computer to do the automation process? Or maybe there’s another way to go about it (Discord Bot, Python code, etc)?

I would appreciate any and all insight. Thank you in advance! 😀

In terms of JS code, I haven’t tried anything because I wouldn’t know where to begin. I’ve considered using PyAutoGUI, but it doesn’t seem like it would be a reliable and long-term solution (since player names may change, my computer resolution may change, where things are located may change, and I’d have to manually update any changes I’d make anyways).