Skip to content
← All projects

// Personal ·

TSO Leaderboards

Bhop, Surf, Climb and Deathrun record leaderboards and per-player profile pages for TSO Network.

  • Astro
  • TypeScript
  • Tailwind CSS
  • PHP
  • MySQL

Ranked leaderboards and per-player profile pages for four Garry’s Mod gamemodes, backed by a read-only MySQL database queried through three small PHP endpoints. Because map and gamemode table names can’t be passed as SQL parameters, every table name is checked against a live, cached INFORMATION_SCHEMA allowlist before being used in a query — the entire SQL-injection defense for that endpoint layer. The PHP layer has its own PHPUnit test suite.