Football Pitchsync

Source: Dev.to

The Community

I built this project for my local football community in Ibadan, Nigeria — a growing network of grassroots teams, street footballers, campus players, and neighborhood leagues who organize matches weekly but lack proper structure, visibility, and digital coordination.

In my community, matches are often arranged manually through WhatsApp groups. There is no:

• Central system to track player performance
• Transparent way to organize leagues
• Verified team registration system
• Structured match statistics
• Platform to discover top‑performing players

Talented players go unnoticed. Community moderators struggle with coordination, and statistics are lost after every match. This platform was created to solve that, providing structure, transparency, competition, and visibility for local football communities.

What I Built

I built a full‑stack football community management platform where:

• Community moderators can create teams
• Players can request to join teams
• Moderators can approve, remove, or ban players
• Teams can invite other teams into leagues
• Real matches are recorded (not simulated)
• Goals, assists, cards, substitutions, and minutes are tracked
• Leaderboards and top player stats are automatically calculated
• Ongoing and upcoming matches are displayed on the homepage

Key Features

• Secure authentication system
• Community‑based team structure
• Player request and invite system
• League and competition management
• Real match event tracking (goal, assist, cards)
• Dynamic leaderboards from real database data
• Super Admin dashboard to oversee all communities
• Fully responsive modern UI

The homepage actively displays:

• Live and upcoming matches
• League standings
• Top‑performing players with images
• Community spotlight teams

The platform transforms informal football organization into a structured digital ecosystem.

Demo

• GitHub Repository: https://github.com/VoldeDoc/footbard

Code

The full project code is available on GitHub. Project structure includes:

/app            → Next.js App Router pages
/api            → Secure backend routes
/lib            → Authentication, Prisma, and middleware logic
/prisma         → Database schema
/components     → Reusable UI components
/super-admin    → Platform control dashboard

All match data is database‑driven — no simulated or mock data is used.

How I Built It

Frontend

• Next.js (App Router)
• Tailwind CSS
• Framer Motion
• React Toastify
• Drag‑and‑drop formation interface

Backend

• Next.js API Routes
• Prisma ORM
• Supabase (PostgreSQL)
• NextAuth
• bcrypt for secure password hashing
• Role‑based middleware for access control

Media and Communication

• ImageKit for player images and team logo uploads
• Nodemailer for email notifications (invites and approvals)

Database Structure

• Users (with role system: USER, ADMIN, COMMUNITY_MOD, SUPER_ADMIN)
• Communities
• Teams
• Team Members
• Leagues
• Matches
• Match Events (GOAL, ASSIST, CARD, SUBSTITUTION)
• Player Stats
• Join Requests
• Team Invites

Everything is connected relationally and calculated from real stored data.

Why This Matters

In many Nigerian communities, grassroots football is vibrant but unstructured. There is talent, passion, and competition, but no digital system preserving performance history or creating visibility. This platform solves that by:

• Giving players a digital identity and statistics record
• Helping communities organize properly
• Creating transparent league structures
• Enabling competitive tracking
• Allowing moderators to manage responsibly
• Providing platform‑wide oversight through a Super Admin system

It turns street football into a data‑driven competitive ecosystem.

The Bigger Vision

This is not just a weekend‑challenge project; it is a foundation for:

• Local league digitization
• Talent discovery
• Scouting visibility
• Structured grassroots tournaments
• Community‑powered football growth

I built this because I belong to this community and understand the real problems it faces.