Text based MMORPG PHP/MySQL development

Description

OverviewWe are building a browser based text MMORPG. Focusing on long term island management, alliance interactions, and strategy. The game will be developed in PHP, using MySQL for data storage, and HTML/CSS/JS for the frontend.
Game ConceptPlayers start on a random island, collect resources (gold, stone, lumber), build structures, train units, form alliances, and eventually conquer or colonise other islands. The game is slow paced, requiring strategic planning over days and weeks.
Initial Player SetupStarting resources: 250 Gold, 250 Stone, 250 Lumber.Starting buildings: Level 1 Main House, level 0 other buildings.Starting location: Randomly assigned island within a grid (ocean system).
World StructureWorld: Contains 10 oceans.Ocean: Contains 100 grids (10×10).Grid: Contains up to 25 islands (5×5).Island: Player’s individual base, with buildings and troops.
BuildingsGeneralEach building has levels 1–20.
Upgrade costs and times increase by a factor of ~1.2 per level.
Core buildingsBuilding Prerequisite FunctionMain House None Controls build slots, unlocks new buildings.Gold Mine Main House Lvl 1 Produces gold.Stone Quarry Main House Lvl 1 Produces stone.Lumber Mill Main House Lvl 1 Produces lumber.Storehouse Main House Lvl 1 Stores resources, protects from plunder.Stone Wall Main House Lvl 1 Defense boost.Watch Tower Main House Lvl 1 Visibility, anti-espionage.Laboratory Main House Lvl 10 Research technologies.Harbour Main House Lvl 10 Build ships.Barracks Main House Lvl 5 Train ground units.