CLIENT DELIVERY

Sports fan picks — Speed Skating Fan Picks & Admin

NSC Race Picks (Sports fan picks / pronsc) is a sports engagement platform where fans log in via Facebook, submit race picks and compete on leaderboards — backed by a Charisma Bootstrap admin for athletes, seasons, events, race types, drag-drop placement, news, products and invoicing.

PHP MVCFacebook APICharisma UISportsMySQL
Industry
Speed skating · fan engagement
Type
Pick'em platform + admin CMS
Roles
Admin · Facebook fan
Stack
PHP · MySQL (pronsc) · TCPDF · TinyMCE
Proof
4 screens · 2:47 product demo

The problem

Speed-skating fans wanted pick’em contests and race results on one site — admins needed athlete registry and drag-drop placement without custom CMS cost.

Constraints

Delivery stayed inside the client's stack, tenancy, compliance and media-ownership boundaries. Where a choice was forced (suite vs owned plane, BYOC vs CPaaS, local vs cloud models), the architecture section below records the trade-off rather than a marketing rewrite.

Business requirements

Facebook login for fans, athlete/event registry, pick submission and Charisma admin for race placement publishing.

Architecture

PHP MVC + MySQL with Facebook auth bridge and admin placement desk.

Engineering challenges

  • Live event updates — placement publish without breaking fan picks history.
  • Social login — map Facebook identity to local fan rows.

The solution

Sports fan picks platform with fan picks and admin athlete/placement modules — demo linked from this site.

My role

Full-stack PHP and admin UX for sports engagement.

Technology stack

PHP MVCFacebookCharisma UI

Production considerations

  • Rate-limit pick submissions during live events.
  • Admin publish locks after results go public.

Screenshots

Admin dashboard

Sports fan picks admin dashboard with new athletes events and most visited fans widgets

Athletes registry

Sports fan picks athletes list with Facebook profile links photos penalties and active status

Each athlete links to a Facebook profile and photo — penalties and active flags feed the public pick sheets.

Race placement

Sports fan picks drag and drop race placement list with publish and reset controls

Operators reorder skaters per race, then publish results to the fan-facing site.

Events management

Sports fan picks events admin grid with season duration and add event action

Working-system video

Watch on YouTube → · 2:47 · Dedicated watch page →

Architecture diagram

flowchart LR
  FAN[Facebook fan]
  PICKS[Race picks UI]
  ADM[Charisma admin]
  DB[(MySQL pronsc)]
  PUB[Published results]
  FAN --> PICKS --> DB
  ADM --> DB --> PUB --> FAN

Outcomes

Restored or delivered system documented with screenshots and local demo — portfolio write-up only.

FAQ — buyer & architecture questions

Ten common questions about this case study, fit, and engagement.

If you need tenant admin, billing hooks and a serious ops console—yes. Consumer apps differ.

Both. Phase 1 proves the workflow; later phases harden tenancy and integrations.

Yes. Rescue begins with audit and test coverage on critical paths.

AWS, GCP, Azure and on-prem/VPS depending on data residency.

We document shipped features and architecture; we do not invent revenue or uptime claims.

Use the project brief with roles, integrations and timeline.

Share the current stack (PBX, CRM, cloud), the failure or goal in one paragraph, peak call volume, carriers, and any deadline. Screenshots, a pcap, or a short Loom beat a 40-page RFP. Use the project brief or email hello@unifiedpbx.in.

Yes. Delivery is remote-first from Delhi with scheduled overlap for EU, UK, US and APAC stand-ups. Production changes use written runbooks, rollback steps and agreed maintenance windows.

Yes. Many engagements begin with a 1–2 week SIP trace review, tenant-isolation audit, or architecture assessment. If the fit is good, scope expands from evidence—not from a generic sales deck.

Founders, CTOs, telecom leads, MSPs and product teams building or fixing UCaaS, CCaaS, CRM+voice, AI voice, or vertical SaaS—not buyers who only need seats on a mass-market suite.