Project Detail

Description

Alright guys, a buddy of mine and myself, have been working on a service to offer colleges. To do it, we need a user-friendly database. Without being able to find one, I had to create it myself. It's very tiresome, and although we're almost finished, we don't want to have to do this every year.

We don't know the cost of what it would be, so I'm going to put it at what we'd like to spend. 1k for right now, and if that's not enough, we'd be more than happy to include you in part of the sales until we get on our feet some more. I'm doing this free job thing, so I don't think I can respond to anyone's PMs, so if you could put maybe what the actual quote is, I'd be happy, or contacting me at southern webb 04 at yahoo dot com, taking out the spaces, & replacing the at and dots.. Here's pretty much everything we'd like, there might be some repeating in it. Please let us know, as we're looking to do this sometime in the next couple of months. Not sure on what code would even be needed, but I'm fairly sure php?

================================

System for Player Profiles
----------------------------

Firstly, accessable only by those with username and password, assigned by the administrator.

- Being able to click a link, Add Prospect/Player.

- A blank form being displayed, with information(his credentials) and a spot to upload a video file(or link to one).
----As far as his credentials, TBD

- Once submitted, the information will be turned into a page dedicated to that particular player/prospect. His information shown, using a uniform template, including an embedded video player for that player's highlights.

- If logged in as administrator, an option to edit that particular player's profile. Also, the ability to add/remove users, to add/remove coaches subscribed to our scouting report. Being able to edit a user's ability, IE Admin, to have more than one on the given database.

- Displayed on the player's profile, will be a catalog of changes made to his profile. If a player's height/weight changes, it shows it. If his speed changes, it shows it. If he had a school offer added or removed, it shows it. If there's a video added, it shows it. etc. etc. etc.


Database
---------------------

The fields used for the player profile, will also help for the database search function.

Being able to search for a prospect by these fields :

- Last name
- Graduating Class
- High School
- Region (Central, Northeast, Northwest, Southeast, Southwest)
- Offered School

For example, if the player's name was John Smith, you could search Smith, and it show all of the player's in the database with that last name. Next to all of those player's name, ending in Smith, it'd include their other fields, Graduating Class/H.S./Region/Offered Schools. That would apply likewise, if you were to search for the other fields (Grad Class, H.S., Region, Offered School.)

Once player is selected by user, it will take him to the Player's Profile, listed above. On each player profile, a 'back' button is key, as these coaches might not be internet/tech savvy, and will need to be babied through the site.


Embedded Video
-------------------

Including the most recent video, below will be a library with all of the videos for that particular player. Next to each video name(shown in Library), will be date added. This is to ensure ease of access, and the ability to watch multiple films for one player, without leaving the site.


Player/Coach Forms
---------------------

Included on the main page, seperate from the private user database, will be two forms. These forms to give a Player or a Coach, the option to submit themeselves or their player, to our database. The form, after submitted, will be emailed to an address to be determined later, not added into the system.

Player Forms Fields to include:
* needed field

- First Name*
- Last Name*
- High School*
- Graduating Class(4 digit, ex: 2011)*
- Address*
- City*
- State*
- Zip Code*
- Home Phone Number*
- Cell Phone Number
- Email
- Position(s)*
- Height (ft'inch")*
- Weight (lbs)*
- 40 time
- Max Bench Press
- Max Squat
- Pro Shuttle
- GPA*
- ACT Score
- High School Coach's Name*
- High School Coach's Phone Number*


Coach Forms Fields to include:
* needed field

- Prospect Name*
- High School*
- Prospect Graduating Class*
- Prospect Address*
- Prospect City*
- Prospect State*
- Prospect Zip Code*
- Prospect Home Number*
- Prospect Cell Number
- Prospect Email
- Prospect Height*
- Prospect Weight*
- Prospect 40 time
- Prospect GPA*
- Prospect ACT Score
- Comments about prospect(text box, no char limit)*
- Your Name*
- Your Phone Number*



==============================================================
!!!Amendments!!!

Once a coach logs in, he'll be taken to a site that shows :

The search database menu, and also, a list of the last 50/last 100 profiles edited or added, with a timestamp on that log. IE: June 21st : 'Matt Jones' profile added (Junior Saints High School, 2012) : 08:35pm. So, in this order : ' Date : Time : Name : Action performed (updated/added) : (High School/Grad Class).

------------------------

On the Player/Prospects profile, there needs to be a spot for admins to click, 'Add Evaluation.' There, we can type our evaluation out, and save, once saved, it will appear on the profile. Also, an option to edit that entry, or add another. showing the most recent as the top. This is so the coaches subscribed will be able to view the most recent evaluation, and take a look to see how that player's progression/regression over time has had. So for my idea, on what I'd think would be easier for you, and a good layout in general:

Left column : Player picture, below is the Video Bay, below is the numbers like 40-yard, squat, phone numbers, addresses.
Right column : The recent changes made to the profile(spoken about already), below that, a chronicle of the evaluations, with the most recent being at the top.

--------------------------

High School's address being added to both the player and coaches form.

--------------------------

On the Player/Prospects profile, there will be an aforementioned 'Offers' section. That will be a small table, placed in clear view, underneath the player's profile. It'll include two columns, with infinite rows. To add a row, you can choose 'add row' on table, as admin, and type in school's name, and have a drop down selection for the right column. Choices are : 'Verbal', 'Signed', 'None'. When editing the table, you can also delete rows, if for instance, that school decides to drop the offer.

--------------------------

Ability to create a web-site, that is a table for rankings. Being able to add a title to it, and then plug in players from the database. Also defining which/what information will show in that rankings page. Defining that it'll show Name - Height - Weight - School and Offers, by pulling that from the defintions in that player's profile.

--------------------------

An obvious directory to browse by high school. We'll have regions defined, when creating a player/school, so that when you select 'southwest' you'll be taken to those schools. Once clicking on a school, having it list the players in order of graduating class.


Additional files submitted:
codingneeds.txt