Fantasy Football Backbone
•Sean Brown
–Team Leader/Deployment Manager
•David Donatelli
–Web Guru/Lead Designer
•Alex Lauritson-Lada
–Documentation Czar/Build Manager
•Kent Porter
Comp190: Senior Design Project Team 2: /comp/190/TeamWorkAreas/Team2/
Professor Judith Stafford
–Change Control Czar/Test Manager
•Joe Travaglini
–Architect/Lead Coder
Presentation Outline
• • • • Project Requirement Overview Fantasy Football Demo Debugging Results What lies ahead
The Project: CONFIDENTIAL Fantasy Over/Under Fantasy Football Football
• Design a fully functional fantasy football website
– Full Back-End – No front end design (just php code) – Basic functions
• Join a league, select your players, challenge the expert
• Retrieve Statistics • Provide User-Login Environment
Technology
• Web: PHP Generates all HTML pages
– Interacts with database – 65 files of PHP
• Database: MySQL
– Hold all data for stats, players, leagues, users, etc – 9 tables between 2 and 15 columns wide
How it works
• PHP generates all HTML pages at access time
– Takes all data from MySQL database – Responsible for all calculations – Inserts/Updates/Modifies MySQL
• Basic Functionality
– Generate the pages when a user logs in
• Automatic Functionality
– Automatically get stats, calculate scores, determine winners
Development Problems
• Software out of date
– Tufts Server runs out of date MySQL – ……..so does IceCold
• Statistics Feed
– Response issues
• Server Decisions
Demonstration
• Let’s play football
Testing/Debug Results
• Simulation
– Running an entire season in one hour
• Dynamic Updating of Leagues/Teams
– User leaves, season continues
Lessons Learned
• Communication is CRITICAL to productivity
• Platform must be decided before anything else
– Need to know what you are using to build your system
• We are PHP Gods.
What’s next
• Validate statistics parser
• Package SQL into universal setup script
• Give to IceCold for UI buildout
Group Contributions
• • • • • Sean Brown David Donatelli Alex Lauritson-Lada Kent Porter Joe Travaglini
Questions
• http://overundersports.icecolddesign.com