How libuna2005/tabulation-system works
This is a PHP/MySQL tabulation system for school competitions. Its public workflow serves live scoreboard data, computes section and overall totals and ranks, then displays standings and a winners reveal. Separate admin and secretary workflows manage competition setup and encode scores; the judge panel records criterion-based event scores. The source excerpts show the scoreboard and shared scoring logic, but not the secretary implementation or the full admin/API query flow, so those links are limited to documented or visible relationships.
Main entry points: lib.php Database and helpers · index.php Live scoreboard · admin.php Admin management · login.php Secretary login
Components 15
Public Results
- Live scoreboard
index.php - Results API
api.php
Scoring and Tabulation
- Totals and ranking
lib.php - Judge scoring
judge.php - Secretary encoding
secretary.php
Competition Operations
- Admin management
admin.php - Secretary login
login.php - Competition setup
install.php - Cultural game setup
update_cultural.php - Frisbee game update
split_frisbee.php - Photo game update
split_photo.php
Shared Infrastructure
- Database and helpers
lib.php - Database configuration
config.php
Other components
- Scoreboard viewer
- MySQL database
Connections 17
- Scoreboard viewer → Live scoreboard: opens
README.md - Live scoreboard → Results API: fetches results
index.php - Results API → Totals and ranking: requests board data
api.php - Totals and ranking → Live scoreboard: returns ranked data
index.php - Judge scoring → MySQL database: writes scores
judge.php - Secretary encoding → MySQL database: encodes results
- Admin management → Database and helpers: uses helpers
admin.php - Admin management → MySQL database: manages competitions
admin.php - Secretary login → Database and helpers: uses helpers
login.php - Secretary login → Secretary encoding: redirects on login
login.php - Competition setup → Database and helpers: uses helpers
install.php - Competition setup → MySQL database: creates scoring tables
install.php - Cultural game setup → MySQL database: replaces cultural games
update_cultural.php - Frisbee game update → MySQL database: updates sports games
split_frisbee.php - Photo game update → MySQL database: updates cultural games
split_photo.php - Database and helpers → Database configuration: loads settings
lib.php - Database and helpers → MySQL database: queries data
lib.php