Find Jobs
Hire Freelancers

Box Office Derby Site

$30-5000 USD

已完成
已发布将近 12 年前

$30-5000 USD

货到付款
**Objective**: Create a site where users go on a weekly basis and post predictions for movies' weekend grosses. The site keeps tabs on users' weekly prediction accuracy, displaying both weekly accuracy results and lifetime accuracy results. The detailed requirements contain a copious list of implementation details. ## Deliverables **Front-end requirements**: 1. A main page, which lists 10 movies that people can project for the week. From Monday at 12:01 a.m. PDT through Thursday at 11:59 p.m. PDT this page should read "Open for prediction." After that, the movie list should remain constant but the page should read, "Closed while box office returns come in," until Monday at 12:01 a.m. PDT, when the movie list is updated for the upcoming week. 2. A rules page, which contains some static text describing the rules of the contest. You can fill this page in with dummy text and I will edit it myself after you complete the project. 3. A signup page, which allows a user to sign up for an account. 4. A prediction page, which, when a user is logged in, allows the user to enter predictions for the week. Predictions are due by 11:59 p.m. PDT on Thursday. A user should be allowed to edit his predictions prior to 11:59 p.m. PDT on Thursday. 5. A results page, which lists the actual grosses for the most recent week and provides a ranked list of all users for the given week by Weekly Accuracy. This page should always contain the most recent week's list, but also provide links to the list for any past week. 6. A champions page, which lists all users sorted by Lifetime Accuracy. Only users who have appeared in at least N/2 contests (where N is the total number of contest weeks) should be displayed here. Each user's ID should be clickable. When clicked, it should bring up a page with a table containing the user's accuracy by week. Each user-level accuracy figure should also be clickable, and should bring up a page with the user's predictions for the week, the actual grosses, the accuracy by movie and the overall accuracy. 7. A forum with two sub-forums where people can make technical requests or discuss their predictions. Any open-source forum is fine, but user accounts should be shared across the forum and prediction parts of the site. I want user names in the forum to be recognizable in the prediction results. **Back-end requirements**: 1. MySQL tables * user (user ID, user name and account information). This should be updated automatically when a user signs up or edits his account. * movie (movie ID, movie name). This is a table containing all unique movie IDs and names. I will be updating this table by hand. * gross (movie ID, date of Friday, actual gross). This table contains the weekend grosses for every movie and date. I will be updating this table by hand. The weekend gross column is nullable, where the null values correspond to future grosses that are not yet available. Prior to Monday at 12:01 a.m. PDT, I will manually update this table with a list of movies for the upcoming Friday. Prior to Tuesday at 12:01 a.m. PDT, I will manually update this table to fill in the weekend grosses for every movie in the previous week. * prediction (user ID, movie ID, date of Friday, predicted gross). This table holds every user's predictions by movie and date. It should be updated automatically when a user makes or edits a prediction. * I will provide seed commands that initiate the four MySQL tables listed above with dummy data. You are also welcome to add additional tables or views containing Weekly Accuracy and Lifetime Accuracy, but this is not required. 2. Accuracy on an individual movie is defined as ABS(1 - prediction / actual). A user's Weekly Accuracy is defined as the average of his 10 movie accuracies over a given week. A user's Lifetime Accuracy is defined as the average of his Weekly Accuracies over all weeks in which he participated in the contest. **Additional requirements**:** ** I would like the design to look nice and have snazzy-looking widgets, but have no particular requirements with respect to programming language. Any Web framework is welcome. This will be hosted on my dedicated server where I have complete flexibility. The only requirement is that you use MySQL for the back-end database, and that the final product be able to be deployed on my dedicated server running Ubuntu Linux 10.04.** ** **Interview questions:** 1. What is the CMS or Web application framework software you intend to use, or do you plan to write the HTML from scratch? 2. What programming languages or JS libraries will you use? 3. To confirm that you are able to write the MySQL queries that are necessary for the core functionality of the site, please write a MySQL SELECT query using the four tables listed above that returns the accuracy of user ID 123 for the Friday "2012-05-18."
项目 ID: 2745503

关于此项目

3提案
远程项目
活跃12 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
See private message.
$300.05 USD 在14天之内
4.9 (349条评论)
7.9
7.9
3 freelancers are bidding on average $900 USD for this job
用户头像
See private message.
$1,200.20 USD 在14天之内
0.0 (0条评论)
0.0
0.0
用户头像
See private message.
$1,200 USD 在14天之内
0.0 (1条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
United States
5.0
1
付款方式已验证
会员自5月 28, 2012起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。