Developer postOriginal post (opens in a new tab)

Major Systems & Stability Update

This update includes client fixes, vehicle and audio improvements, portal updates, colony and territory fixes, database performance work, and several server-side stability improvements.

Client Updates

Audio and Sound Devices

  • Added left and right channel test buttons to the Configuration dialog.
  • Fixed relative wind sound effect calculations.
  • Corrected audio panning based on head turn.
  • Fixed default sound device selection.

Vehicles, Flight, and Navigation

  • Fixed automatic transmissions for ground vehicles.
  • Fixed surface friction behavior for all vehicles.
  • Fixed AGL mode behavior above 10 km MSL.
  • Fixed an issue with clearing old turn-by-turn route information.

Airports and World Data

  • Removed the closed Runway 9/27 from Deois Airport.
  • Fixed harvest schedule handling.

UI and Controls

  • Fixed a duplicate screen issue in the P-13 Prowler.
  • Fixed arrow key, Home, End, highlight, and copy behavior in the Communications dialog.
  • Prevented normal release users from accessing F2 developer functionality.

Client Stability and Logging

  • Added a logging improvement so Log() can now accept an HRESULT.
  • Reduced unnecessary "not released" error messages.
  • Added a fix intended to resolve one of the unusual client exceptions that had been appearing.

Server Updates

Portal, Website, and Sister Page Updates

  • Added caching for sister pages, including vBay, CPOC, Veridian Bank, City of Deois, Easydock, Yonmaran Sentinel, and REVS.
  • Fixed a colony deletion bug affecting colony messages.
  • Fixed runtime bindings for the Deois and CPOC websites.
  • Removed price from the portal plots list.
  • Fixed bad input handling from the player portal.
  • Improved unsubscribe, delete, and colony territory merging behavior.

Colonies, Buildings, and Territory

  • Fixed issue where a territory building for a new colony had no fuel.
  • Added ConstructBuilding and DestrictBuilding stored procedures.
  • Fixed laborAvailable so it can no longer go negative.
  • Fixed the 65,535 workers issue caused by farms with partial laborers.
  • Broke down district populations with AI assistance.
  • Improved handling of exposed-to-elements weather updates. Areas exposed to the elements now receive updated weather information, while protected areas can continue using cached weather data.

Vehicles, Pilots, and Player State

  • Fixed an odometer rollback bug with AI assistance.
  • Improved the integrity check for pilots of inactive vehicles.
  • Prevented NextLogbookLeg from being called on a player who is not online.
  • Added the ability to load a deleted player into memory for ejection and related cleanup cases.
  • Reduced the severity of Zebra no-net-change logging.

Salvage and Player Actions

  • Menus no longer treat salvage operations as stealing.

Auctions, Contracts, and Timers

  • Fixed an auction timer overflow that could cause a recursive processing loop.
  • Added logging and fixes for contract fulfillment.

Database Performance and Query Safety

  • Parameterized dynamic SQL in morale and territory updates.
  • Parameterized VLM queries.
  • Fixed morale update SQL parameter overflow.
  • Fixed CalculatePlotPrice parameterization.
  • Fixed the roads query for VLM.
  • Added query shape improvements using a SQL type for plots data.
  • Replaced string concatenation with string interpolation where appropriate.
  • Completed extensive query parameterization and indexing work for database performance.
  • Removed unnecessary sorting from SQL Server queries.
  • Fixed a bad input case that could cause a stack overflow exception. Thanks to @crypto for reporting it.