create_schemaverse.sql is dead, long live create_schemaverse.sql
… database structure is now built from a sqitch project found in the schema directory.
Adding round visualizer to TrainingWheels
* Returning the session_user_id in the map_tic.php * Using the session_user_id when checking planets
* Adding stop, start, restart and exit functionality to the visualizer * Using the SV trust relationship and taking out user names and passwords * Making the setup.php use the trust relationship and the session user
* Adding the visualizer inline * Making a start and stop function to it * Need to figure out which connection credentials it should use
reconciliation against production, various optimization changes and bug fixes
Basic idea is to do bulk operations on ships rather than operating on them individually in a fine-grained loop
…es not lead to overflows. Also, delete out ships_near_* tables upon round start. And truncate a bunch of relevant tables; that will reset them quite totally.
…lanets that have not got much fuel left.
… things up.
…t right away.
…single sweep against the ship table, updating everything.
…at will cause there to be fewer altered tuples.
Do not set no-longer-existent x+y coordinates upon moving a ship
a) Changes in player_creation(), which autogenerates a bunch of planets if there aren't already any. b) Add last_move_tic to player table c) Revised update_ships_near_ships() that uses temp tables d) create_ship() needs to use location rather than location_x/location_y e) Sundry changes to fleet_script_update() f) Add query_store table used to capture queries used in web front end g) Changed distance_travelled, avg_ship_upgrades, avg_fuel_mined from integer to bigint to avoid overflow h) Triggers enable/disable changed to 'all' level from 'user' level i) Add missing archive_events() function
Tweaks to master to fix loading
… and FLEET_FAIL