MTG Nerd Stats

A Flask-based web application for tracking Magic: The Gathering Commander game data, statistics, colors, and more.
Built with Python, Flask, SQLAlchemy, and deployed using Passenger.

---

📌 Features

• Record new games with:
• Date (YYYY-MM-DD)
• Commander
• Decks
• MTG color combinations (multi-select)
• Wins
• Kills
• Deck Performance (I use a 0-3 scale but short strings will work)
• Opponents (This could be the number of opponents or how tough their decks are. I use a 0-3 scale but short strings will work)
• Comments
• View and edit existing game entries
• Delete entries with confirmation
• Client-side + server-side validation
• Table row click → form population
• Search on Commander or Deck to get a summary of games
• Analytics page displays most frequently used decks, least frequently used decks, decks with the most wins and the most kills, colors by deck appearances and by game appearances.
• Clean and responsive UI

---

🧰 Tech Stack

• Python 3.12
• Flask
• SQLAlchemy
• Jinja2 templates
• HTML5 + CSS + JavaScript
• Uses Waitress or Passenger WSGI servers
• SQLite / MySQL (depending on your setup)

---

🚀 Local Installation

git clone https://github.com/Skain-zf/CastleSkain/tree/main/nerdstats
cd nerdstats

python -m venv venv
source venv/bin/activate  # Windows: venv\Scripts\activate

pip install -r requirements.txt
````
---

## 🚀 Running Locally

```bash
python waitress_server.py

http://127.0.0.1:8080

---

🌐 Deployment (Host + Passenger)

The original installation of this application runs inside a subfolder under a WordPress site, using Passenger. The webhost uses cPanel. These directions are for that environment. You can ignore the .htaccess changes if you aren't under a Wordpress environment.

Steps to Deploy

• Upload project to your Namecheap hosting directory
• In cPanel → Setup Python App:
  • Python Version: 3.12.x
  • App Root: yourdomain.com/mtgnerdstats
  • App URL: /mtgnerdstats
  • Startup File: passenger_wsgi.py
  • Entry Point: application
• Install requirements:

/home/USER/virtualenv/APP/3.12/bin/pip install -r /home/USER/domain/mtgnerdstats/requirements.txt

• In Wordpress .htaccess (root) (you probably don't need this):

RewriteCond %{REQUEST_URI} ^/mtgnerdstats(/|$) [NC]
RewriteRule .* - [L]

---

🌐 Creating a User

MTG Nerd Stats is currently designed for a single user, or multiple users working with the same data set. To create a user, go to mtgnerdstats/letmein. This will let you create a user name and password. The form to edit data only appears on the Games page if the user is logged in.

---

🌐 Project Structure

project/
│
├── app.py
├── dbwrapper.py
├── passenger_wsgi.py
├── requirements.txt
├── stats.py
├── waitress_server.py
├── data/
│   ├── games.json
├── templates/
│   ├── about.html
│   ├── base.html
│   ├── games.html
│   ├── login.html
│   ├── signup.html
│   ├── stats.html
│   └── …
├── static/
│   └── stylesheets
│       └── games.json
└── README.md

---

🚀 Future Enhancements

• UI improvements
• Refactoring analytics charts to minimize repetition