We’ve framed out the ‘Cluster’ game graphically (at least to a first approximation). Currently the cluster generation is handled in Unity and there are no game rules and no save games.
I’m in the process of roughing out the MySQL database structure that will hold persistent game data and convey it between players and looking at coding up the php code needed to manage this data and implement game turn logic and playing field generation.
Once the basics are sketched out, I expect to remove the generation logic from the Unity code-base and switch things over to use the layouts and turn management provided by the site based php code.
I’m expecting to see the database side layout break out into:
- System Data. Things that control game operation but do not change game to game or player to player.
- Player Data. Information about the players that is not related to a particular game. Name, picture or icon, other particulars.
- Game Data. Information that is a base part of a particular game run but does not change turn by turn.
- Turn Data. Turn and move data for the game.
System Data
- Star name list
- Planet types list
- Configuration such as number of stars per game and other similar items.
Player Data
- Player ID
- Player Name
- Player picture or icon
- Games played
- Wins/Losses
Game Data
- Stars Information
Table with color, location - Planets Information
Table with type, properties, max pop, orbit
Turn Data
- User Move
Fleets from -> to. Scouts from -> to. - Resource Production
Build Ship here, Build planetary resource here, Spend on research. Form and break fleets. - Combat Resolution
Combat results. Remove destroyed ships. Resolve ownership changes.