Fermé

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

Compétences : Ingénierie, Design de jeux, Linux, MySQL, PHP, Architecture Logicielle, Tests de Logiciels

en voir plus : php script null, int size c, game codes html 5, find password email address, find correct email address, type of cookies, start contest, shirt contest, profile contest, football team, change to contest, ay, create update profile page php, pop window code html, html table jpg, edit user profile php mysql, football game prediction, enter address find phone number, pretty schedule, pop window html code

Concernant l'employeur :
( 0 commentaires ) United States

Nº du projet : #3158958

12 freelance font une offre moyenne de $140 pour ce travail

tomerocktt

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(31 Commentaires)
4.1
imagique

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(8 Commentaires)
4.0
alexracoti

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(6 Commentaires)
3.8
philpowellvw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(3 Commentaires)
3.7
parasoftvw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(10 Commentaires)
3.4
sergoovw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(16 Commentaires)
3.1
vlaervw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(9 Commentaires)
3.2
garynewelluk

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(11 Commentaires)
2.1
softartvw

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(1 Évaluation)
0.0
marcisb

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(1 Évaluation)
0.0
isynergyinfotech

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(0 Commentaires)
0.0
infoworkteam

See private message.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 30 jours
(0 Commentaires)
0.0