Gold Drop Telemetry System

Vengeance Admin

Today we completed and deployed the live Gold Drop Telemetry System.

Every instance of gold dropped in-game is now recorded in the database via the GoldDropInstances audit table. This includes:

  • Drop timestamp
  • Drop type
  • Amount
  • Source monster name
  • Source character (if applicable)
  • Map title
  • Pickup timestamp
  • Expiry status

This gives us full visibility over the in-game gold economy for the first time.

What We Can Now Track

We can now monitor:

  • Total gold dropped (today / 7 days / 30 days / all time)
  • Gold dropped per map (MapTitle)
  • Gold dropped per monster (SourceMonsterName)
  • Total number of gold drop events

This allows us to move from guesswork to real data when evaluating balance.

Why This Matters

Historically, private servers often rely on assumptions when tuning drop rates and economy flow.

With this system in place, we can:

  • Identify maps generating disproportionate gold
  • Identify monsters contributing heavily to inflation
  • Track overall gold injection into the economy
  • Detect potential balance issues early
  • Make targeted adjustments instead of global nerfs

This is part of our broader move toward a fully SQL-backed, audit-driven server architecture.

Technical Notes

  • Drops are INSERTed into GoldDropInstances at spawn.
  • Pickup updates the same row via PickedUpAt.
  • Expired drops are marked via ExpiredAt.
  • No deletion occurs — full audit history is preserved.
  • WordPress is connected directly to the live database to display public statistics.

This continues the transition away from legacy flat-file logic toward a fully instrumented, data-first backend.

Next step: expand telemetry to additional economy metrics and introduce per-map balancing reports.

Categories: