Club Records Snap

A WordPress plugin that maintains an athletics club's age-group records via a simple workflow: import legacy Ninja Tables records once, then keep them current by dropping Power of 10 screenshots into the plugin — Claude vision OCR extracts the new performances, you review and confirm, the records table updates.

Built for Brentwood Beagles AC after the agent-driven scraper approach proved fragile (CAPTCHA gates, stuck job queues, 200+ tool calls per session). This plugin replaces that complexity with: human-takes-screenshot → human-drops-into-plugin → AI-extracts → human-confirms.

Why not just scrape Power of 10?

Po10's ranking endpoints are protected by hCaptcha, the data is rendered client-side, and the page state machine doesn't expose deep links. Any server-side scraper gets blocked on first request. The previous plugin attempted to drive a Claude-in-Chrome agent through the queue manually but ran into stuck jobs, context exhaustion, and a slow grind for not-much-value-per-event.

Screenshots sidestep every one of those problems: you screenshot once per event/year/sex view that you care about, drop it in, and the plugin does the rest.

Architecture

Single records table, single workflow:

wp_crs_records          — one row per (sex, age_group, event) cell
wp_crs_uploads          — audit log of every screenshot processed

The UKA Competition Rules eligibility matrix (TR3 S2 + TR3 S4) is built in — disallowed cells like U14 Marathon, U14 Triple Jump, U16 race over 3000m, U18 Marathon never render in the public table.

Workflow

1. Settings → Claude API key (get one at console.anthropic.com). Defaults to Claude Haiku 4.5 — fast, accurate enough, ~$0.001 per screenshot.
2. Dashboard → Run seed — imports the legacy Ninja Tables records from beagles.org.uk (tables 9354 / 9359) into the new schema. Picks the best historical performance per cell.
3. Upload Screenshot → drop a Po10 rankings screenshot → Claude returns a JSON list of rows → the review screen shows CREATE / UPDATE / SKIP (UKA) / SKIP (wind) / SKIP (not better) for each candidate vs your existing records.
4. Records → manually edit, delete, or add. Tick "Lock" to mark a record as manual-override so screenshot updates can't overwrite it.
5. Public site → drop [crs_records] on any page. Built-in W/M/All radio filter and hide-empty toggle.

Installation

1. Download the latest club-records-snap-v1.0.0.zip.
2. wp-admin → Plugins → Add New → Upload Plugin → choose the zip → Install Now → Activate.
3. Navigate to "Club Records" in the admin menu.

Settings

File layout

club-records-snap/
├── club-records-snap.php           bootstrap, helpers, settings, UKA filter
├── readme.txt
├── README.md
├── uninstall.php
├── includes/
│   ├── class-crs-activator.php     DB schema
│   ├── class-crs-perfvalue.php     performance string parser
│   ├── class-crs-records.php       single-table CRUD
│   ├── class-crs-seeder.php        legacy Ninja Tables import (TESTED)
│   ├── class-crs-claude.php        Anthropic Messages API wrapper
│   ├── class-crs-snap.php          screenshot → candidates → review
│   ├── class-crs-admin.php         wp-admin menu + handlers
│   └── class-crs-shortcode.php     public renderer
├── admin/
│   ├── views/{dashboard,upload,review,records,settings}.php
│   └── assets/{admin.css,admin.js}
└── public/assets/public.css

Shortcodes

[crs_records]                    # default: both sexes with W/M/All radio
[crs_records gender="women"]     # women only
[crs_records gender="men"]       # men only
[crs_records hide_empty="0"]     # show every cell even when empty
[crs_records filter="0"]         # hide the text search box

Differences from the old plugin (Athletics Club Records)

Licence

GPL-2.0-or-later.