# DnD listings

by Jaxon Rainbow

---

## Project Description

This project will allow members of the schools DnD club to see what campaigns are open and get contact info of DMs

- Allows members of the school DnD club to view a list of campaigns and info about them
- lets admins login to edit and add new campaigns
- Provides a way for members to contact DMs of campaigns in order to join
- shows users the current players in the party and the max amount the DM would like 

---

## Project Links

- [GitHub repo for the project](https://github.com/waimea-jrainbow/200DTD-DnD-listings)
- [Live web app](https://two00dtd-dnd-listings.onrender.com)
- [Project Documentation](https://waimea-jrainbow.github.io/200DTD-DnD-listings/)
---

## Project Files

- Program source code can be found in the [app](app/) folder
- Project documentation is in the [docs](docs/) folder, including:
  - [Project requirements](docs/0-requirements.md)
  - Development sprints:
    - [Sprint 1](docs/1-sprint-1-prototype.md) - Development of a prototype
    - [Sprint 2](docs/2-sprint-2-mvp.md) - Development of a minimum viable product (MVP)
    - [Sprint 3](docs/3-sprint-3-refinement.md) - Final refinements
  - [Final review](docs/4-review.md)
  - [Setup guide](docs/setup.md) - Project and hosting setup

---

## Project Details

This is a digital media and database project for **NCEA Level 2**, assessed against standards [91892](docs/as91892.pdf) and [91893](docs/as91892.pdf).

The project is a web app that uses [Flask](https://flask.palletsprojects.com) for the server back-end, connecting to a SQLite database. The final deployment of the app is on [Render](https://render.com/), with the database hosted at [Turso](https://turso.tech/).

The app uses [Jinja2](https://jinja.palletsprojects.com/templates/) templating for structuring pages and data, and [PicoCSS](https://picocss.com/) as the starting point for styling the web front-end.

The project demonstrates a number of **advanced database techniques**:

- Linking data in related tables or nodes using queries or keys
- Writing custom queries to filter and/or sort data
- Using logical, mathematical and/or wildcard operators
- Customizing presentation of the data
- Using custom forms to add user input to the database
- Setting validation rules for data entry

The project demonstrates a number of **advanced digital media (web) techniques**:

- Creating or customizing scripts, code or presets
- Using a combination of steps to manipulate or enhance elements
- Using a third-party library
- Using composite effects

** EDIT THESE LISTS ABOVE TO MATCH YOUR PROJECT**