Fantasy Football

Fantasy Football is one of the leading football websites in the world, concentrating on presenting the: fixtures, results, and tables; for the English football clubs, from professional grades, right down to step 7. Fantasy Football also carries Scottish, Irish, and many European, and even Australian leagues.

The main draw card for Fantasy Football is its absolutely fantastic and addictive football game. Its unique format making predicting the outcome of football games, from United Kingdom and Europe, both fun and competitive. The game, free to play, is designed to allow players to join in a public competition, or form their own private competition.

Anglo Sunshine's senior consultant, Gary, came on board with this project during a time of flux. Fantasy Football was having problems with its contracted web designers, and asked Gary to come in and see what he could do. As Fantasy Football is a hobby website of a friend, Gary used this unpaid opportunity to develop his own skills in web design and server side programming.

Before Gary came on board, there was no: (a) fixtures, results, and tables displayed; (b) the matches for the game were manually entered; (c) the results of the matches were manually entered; (d) the cups were manually calculated and displayed; (e) coding was duplicated for each competition.

Gary has completely rebuilt the website, and all of the server side code (including the SQL data-base). Gary has: (a) redesigned all the SQL tables, normallising where appropriate, and added proper keys and secondary indices, (b) automated the data gathering, to eliminate time consuming manual processes, (c) created the league fixtures, results, and tables data collection and display, (d) automated the prediction games, (e) removed duplicate coding, (f) moved as much processing out of Cold Fusion, by utilising SQL to carry out table joins et al.

The administration side of the website is where the brunt of the programming logic lies. The data collection, and display, carries advanced error checking logic. The game scoring and updates have a backout facility, to roll back the scored prediction game incase of errors the the predicted match results.

The website owner now concentrates on new initiatives, and changing the looks of pages, rather than concentrating on keeping the game running week after week. The saving in administration time has been tremendous. Fixtures, results, and tables; are updated every day extremely quickly and with minimal fuss.

Fantasy Football uses Cold Fusion version 9 and MySQL version 5.1 as its driving engine. This website is now hosted on a dedicated server instead of a shared one.

Fantasy Football