I have a web based game and need the following addition made to my website:
At the moment the game saves the number of visitors to a home game in the database. But this is only for the last game. So every time a team has another home game, the previous info gets overwritten.
1. I need an addition to the backend where the number of visitors is calculated to add this number in a seperate table of the MySQL database for each game!
2. I need a php page for the frontend, that gets all this info out of the database.
3. I need a tpl page that displays this info from highest average visitors to lowest for each league.
4. The tpl page should also show the following.
a) The game with the highest number of visitors (including home and away team, date, league and season)
b) The game with the lowest number of visitors (including home and away team, date, league and season)
c) The team with the highest average per season (including their logo)
5. The number of visitors is calculated from five different numbers which also should be displayed individually in point 3 and 4 if selected!
I can provide the code for the original but your programming can only include the basics of this code. You can not just copy the code and create something. It needs to be original!!!
The game is in german but I have no problem translating. I need this done right, so time is not an issue!
Ask me if you have questions befor bidding.
DO NOT send any references until I ask or you bid will be deleted!