Since its founding in 2017, OokiiSoraCon has hosted a convention-wide, weekend-long House Cup. When attendees pick up their badge at registration, they also receive a house assignment. Throughout the weekend, attendees can participate in activities around the convention to earn points for their house. At the end of the weekend, the house with the most points wins, and the MVPs for each house win a prize. The House Cup is a tradition OokiiSoraCon plans to continue.
Overview
This application consists of two parts. First, an administrative website allows OokiiSoraCon staff to log in and enter the points, badge name/number, and house for attendees as they win points. Admins can view the current standings of the four houses, the top ten players for each house, and the history of points entered into the database. Super admins also have an area to create new and edit existing admin accounts and view a log of created, edited, and deleted points. This piece of the application has a PHP and MySQL backend, and I used Bootstrap 4 to style the frontend.
The second half of the application displays the house standings and newly earned points in a fun way. It retrieves the current standings from the administrative website through a simple API. During the convention, this application is displayed in a central location. Attendees can also find a web version online. I built this visualization with Unity 3D and C# for Desktop computers and the Unity Web Player.
Convention Appearances
This framework has supported OokiiSoraCon 2019’s Ookiimon League House Cup and OokiiSoraCon 2022’s and 2023’s House Cup. I created the web app in 2019 and added support for multiple years of data in 2022. In 2023, a new feature allowed the reason points were rewarded to be recorded and displayed to attendees. Sydney Schell created artwork to theme the visualizations for each year.
The publicly available areas of the administrative website can be viewed here. The visualizers for all previous House Cups are viewable here:
- 2019 Ookiimon League House Cup Visualization
- 2022 House Cup Visualization
- 2023 House Cup Visualization
Reception
The application has received great reviews. Attendees enjoy seeing their points tip the scales, and staff members find the administrative area easy to use. OokiiSoraCon plans to continue improving the application and modifying the visualization to match the theme of each year’s House Cup.