Football Prediction

A prediction program that allows users to predict an upcoming football game as well as enter a score for a single game for a tie-breaker. The user must register to participate and they will need to have a profile page that they can update ay anytime. I need the program to start the contest at a certain date and time and end at a certain date and time. The user must be able to edit their picks at anytime during the week until the contest closes. The teams must be a link that will open in a pop-up window describing the teams record, division, region and so forth. I have already set up a database with the teams and information entered already so the program will have to work within these parameters (see below). It must also use cookies or sessions so a user may not just bookmark the actuall contest without signing in first. The user must input an address, city, state, phone number, email address. The HTML is already done for the site, I need pretty much, all the processing codes. I need the scripts for the sign-up page for new users, a profile page for the users as well as the script to insert the data that the user picks into the database. I would also need a admin script to insert the winner from each game into the database. I would like to have a script that would find the winner(user) of each week to display for the users. I will also need the script to award points (1) to the winner each week.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) User must be able to view any and all members.

3) User must be able to change picks before deadline.

4) Almost everything must link to another.

5)

#

# Table structure for table `metadata`

#

CREATE TABLE `metadata` (

`currentWeek` int(11) default NULL

) TYPE=MyISAM;

# --------------------------------------------------------

#

# Table structure for table `pick`

#

CREATE TABLE `pick` (

`pickSetID` int(11) default NULL,

`gameID` int(11) default NULL,

`teamID` int(11) default NULL,

`correct` int(11) default NULL

) TYPE=MyISAM;

# --------------------------------------------------------

#

# Table structure for table `pickset`

#

CREATE TABLE `pickset` (

`userName` varchar(50) default NULL,

`homeTeam` varchar(11) default NULL,

`week` int(11) default NULL,

`awayTeam` varchar(11) default NULL,

`tiebreakerScore` varchar(100) NOT NULL default ''

) TYPE=MyISAM;

# --------------------------------------------------------

#

# Table structure for table `schedule`

#

CREATE TABLE `schedule` (

`weekID` varchar(50) NOT NULL default '',

`date` varchar(50) NOT NULL default '',

`team1` varchar(50) NOT NULL default '',

`place` varchar(50) NOT NULL default '',

`team2` varchar(50) NOT NULL default '',

`scores` varchar(50) NOT NULL default ''

) TYPE=MyISAM;

# --------------------------------------------------------

#

# Table structure for table `team`

#

CREATE TABLE `team` (

`teamID` int(11) NOT NULL auto_increment,

`teamName` varchar(50) default NULL,

`teamDivision` varchar(20) default NULL,

`teamRegion` varchar(100) default NULL,

`teamRecord` varchar(10) default '0-0',

`teamAddress` varchar(50) default NULL,

`teamNickname` varchar(50) default NULL,

`teamCounty` varchar(50) default NULL,

`teamLogo` varchar(50) default '[url removed, login to view]',

`teamWebsite` varchar(50) NOT NULL default '',

`teamColors` varchar(50) NOT NULL default '',

`background` varchar(50) NOT NULL default '',

`text` varchar(50) NOT NULL default '',

PRIMARY KEY (`teamID`)

) TYPE=MyISAM AUTO_INCREMENT=734 ;

# --------------------------------------------------------

#

# Table structure for table `user`

#

CREATE TABLE `user` (

`id` int(11) NOT NULL auto_increment,

`firstName` varchar(30) NOT NULL default '',

`lastName` varchar(30) NOT NULL default '',

`email` varchar(100) NOT NULL default '',

`address` varchar(50) NOT NULL default '',

`city` varchar(50) NOT NULL default '',

`state` varchar(25) NOT NULL default '',

`phone` varchar(15) NOT NULL default '',

`userName` varchar(50) NOT NULL default '',

`passWord` varchar(50) NOT NULL default '',

`shirt` varchar(50) NOT NULL default '',

`size` varchar(15) NOT NULL default '',

PRIMARY KEY (`id`)

) TYPE=MyISAM AUTO_INCREMENT=7 ;

5) Program will be owned by federalleaguefootball.com.

## Platform

PHP, MySQL

Ingeniería Diseño de juegos Linux MySQL PHP Arquitectura de software Verificación de software

Nº del proyecto: #3158958

Sobre el proyecto