COS 333
Intramurals Website Progress Worksheet
Cody May '07 (SQL Senior) [project manager]
James An '08 (GUI Groundbreaker/Guardian)
Jonathan Sweemer '08 (Java Junky)
Michael Ye '09 (PHP Phenom)
*********************
Wednesday, April 4th:
sweemer and cqmay met late at night to try to get svn working and to talk a bit about the MySQL database.  cqmay called Matt Plough '07 over in order to show him how to set up svn (and how to follow basic instructions lol).
********************
Thursday, April 5th:
sweemer and cqmay met at 10 AM in Friend 017 to get svn working and to figure out MySQL a bit more.  They tried to see the PHP code made by ye in order to make the PHP code for basic SQL queries to the MySQL database, but they had access only to the HTML created by ye's PHP rather than the PHP files themselves.
All 4 members of the group met around 3:00 PM in Friend 017 in order to get the PHP code integrated with the MySQL DB.  We were able to get form.php to send basic SQL queries to our DB (success!) and then met with our TA.

We all 4 met again in the evening around 9:00-10:00 for around 2 hours.  We made significant progress in desiging the MySQL tables and seeing how they should relate to each other along with getting a more coherent vision for the functionality of the website.

********************
Tuesday, April 10th:
cqmay created the SQL queries (using the userID data acquired by sweemer) needed in order to insert 5 or 6 men's softball teams' worth of data into the relevant tables (Sports, Teams, Rosters).
ye made significant progress on form.php which now allows users to input new teams directly into the DB.
an found [INSERT NAME HERE] which should really help make the GUI look clean and "pretty enough".
**********************
Saturday, April 14th:
ye renamed two files; form.php -> user.php and action.php -> useraction.php. These two insert user-created
teams into the Teams_Pending table. Also created admin_teams.php, which displays the contents of the
Teams_Pending table (incomplete, needs a mechanism to also display players on each team) and allows the
admin to confirm teams, deleting them from Teams_Pending and adding them to Teams. This is done through
admin_confirm.php, which takes HTML POST data from HTML generated by admin_teams.php.
**********************
Saturday, April 25th:
an worked on navigation within sport pages and individual team pages.  began using SESSION cookies.