Mildly tedious yet simple project for people with strong wordpress knowledge.
Goal:
To have NFL game(s) and player statistics available on my wordpress website in a clean polished interface (use jqgrid if it's easier) (similar to the content area here --> [login to view URL] and here [login to view URL] ). Pages to be created using wordpress templates within existing site design (I have samples pre-made). Pages created for every player and team in database - links created to player pages site wide for all players in database, this is to be done for past articles and automatically for new articles published (plugin maybe?). Stats will be pulled from remote server (via http behind login) weekly to create / update database with new weekly stats.
Phase One:
Create mysql database using Indexes / ID's - weekly data sample found here [login to view URL] - I'm searching for another data provider that will just export the data for me so we won't have to import it from website, but it's not looking good.
Each of the links are samples for one week data - there are 17 weeks in an NFL season - I want all weeks dating back to 1998 - a process for future weeks data to be imported will have to be documented and automated if possible.
PM me with subject "I understand NFL Football" - to be considered for this bid
Phase Two:
Create Page for every player and team in database - hyper links and content just like the content area found here [login to view URL] and here [login to view URL] - links to past years totals - past years weekly view with totals on bottom - depth charts - game schedule - game results - these items will be links on pages - just like sample links above - data lives in data obtained in phase 1
Pages should be able to be auto created using wordpress tags maybe? Whatever process is chosen it must be automated so future additions of players into the database will also generate pages on website. I know wordpress allows this type of functionality.