Rally Bonus Planner — Admin

⬇ Download Database Backup A complete SQL dump of every table — restorable via phpMyAdmin's Import tab. Includes every rider's data, so store the downloaded file as securely as the database itself.

Reading the columns: Logins is the total number of times that rider has ever logged in — a longer-running measure of engagement than Last seen, which only shows their most recent visit. Rallies is the total number of rallies that rider has created, and Legs the total legs across all of them. Bonuses is the total number of bonuses that rider has created across all their rallies, however they added them — typed in by hand or via one of the file-import options — the app doesn't track which; Flagged is the subset of those bonuses currently carrying a ⚠ import flag (low-confidence OCR reads, missing fields, and similar) still worth the rider double-checking. Routes is how many saved Route Planner scenarios they've built. Rider Profile is Y once a rider has ever saved 🏍 Rider Profile (N if they never have, regardless of how long they've used the app) — it doesn't reflect what they set it to, just whether they've set it at all. Motorcycles is how many ⛽ My Motorcycles profiles they've created (0 if none). Each API type shows "hits · misses" — hits are served free from the cache, misses are live calls that actually cost against your quota: Timezone through TimeZoneDB, Geocode through Google (via gproxy.php), Weather through Visual Crossing, and OCR through Google Cloud Vision (PDF import's bonus-reading step — OCR has no cache, so every OCR call is a miss). "Online" is based on activity in the last 5 minutes (any request to the app counts), not a real-time connection — this app doesn't use websockets, so it's the closest available approximation. Lookup access is separate — it's who's allowed to use the timezone/geocode/OCR and weather buttons at all, not how much they've used them (Geo/OCR is one combined toggle — PDF import's OCR reuses the same permission as the timezone/geocode buttons). New riders start with both on; admins always have full access regardless of these toggles. Click a rider's name to see their login history.