Closed

Improve Highscore Most played and Hall of Fame - PHP work

This project was awarded to WikiSolutions for $40 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $40 USD
Total Bids
4
Project Description

Small job(s) to do (we are using granty, chronoforms (a formbuilder), openlayers (a kind of javascript, to display a map) and joomla). Please read carefully. Do not bid when you are not able to solve the task(s) and start immediately. I tryed to explain each task so good as possible. If you have any questions feel free to ask.

We have a Database containing all needed data.

Change database access in 2-3 scripts, so we can change the PW of database afterwards.

Improve "Highscores" - We have already "Highscores" running.
(All data has to come from table_stats!)

Bug 1 > User "blue" (424) had some games, but there are no scores in table
+ add colum "country" next to user (take data from chronoforms_data_fh)
+ add colum "besttime" next to score (take data from game_stats)
+ add colum "last played" (date= next to besttime) (take data from game_play)
Limit list to 30 results

Improve "Hall of fame"
All data has to come from table xxxx_xxxx
Bug 1 > counts wrong, because A. taking wrong table and not counting together
Bug 2 > not sorted by "(most) games played"
In "jos_user" is ID for user named player = 417
look now in table game_stats:

"user ID" for player = 417
count all entrys from 417 = 13
means "Games played" must be "13" not only "4"
count all entrys from 417 "won" = 4
means "Won" must be "4" not only "1"
count all entrys from 417 "lost" = 1
means "lost" must be "1" not only "0"
+ add colum "country" next to user (take data from chronoforms_data_fh)
+ add colum "member since" next to country (take data from jos_user)
Limit list to 30 results

Improve "Most played"
All data has to come from table game_stats
+ add colum "won" next to "times played" (count ALL from ALL players)
+ add colum "lost" next to "won" (count ALL from ALL players)
+ add colum "type" next to "lost" (take data from flashgame)
+ add colum "uploaded" next to "type" (take data from flashgame (if there is a vaild date)
Limit list to 30 results

You have to test your work on your own with lastest version of IE, Firefox and Chrome before telling me "job is done".

You get paid when job is done.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online