ceremorphosis

As mentioned in my previous post, I am working on a database and Web GUI for tracking Rock Band scores. Yes, this seems like an undertaking for a game, but the wife has asked for something easier than an Excel spreadsheet. It’s also a challenge for me to shake off some rust (though I am not convinced I am fully oxidized).

So far I have…

My database is comprised of the following tables and fields. It will be the next part of wrapping a GUI around it that will be the most difficult for me. Any PHP expertise would be gladly welcomed.

Current tables:

band_info:
band_id (auto number)
band_name (up to 64 characters)

track_info:
track_id (auto number)
track_name
track_artist
guitar_difficulty
bass_difficulty
drums_difficulty
band_difficulty

track_scores:
play_id (auto number)
band_id (this is what I will link to above ID)
played_time (auto date and time)
track_id (this is what I will link to above ID)
play_level
guitar_percentage
bass_percentage
drums_percentage
vocals_percentage

play_level:
play_level (Easy, Medium, Hard, Expert)