A few years ago I created the website [url removed, login to view] .
The website consists of user-generated pictures and clues that visitors can use to guess the name of the movie.
At some point in the last couple of years something has been altered and the puzzle look-up has stopped working. The puzzle number is parsed into the URL correctly, but the look-up in the database always results in the same puzzle being presented to the visitor.
Somewhere the PHP/MySQL is creating a default value that it is using instead of the desired value. Your job will be to fix the PHP so the puzzles are correctly displayed again. You can either do this by ammending the existing code or by generating a new database query and eliminating the faulty code from my website - I don't mind the solution you choose to take, as long as it works and I'm left with tidy code.
The code was originally generated using Dreamweaver's PHP/SQL functions, so familiarity with how these SQL queries look will make your life easier.
You will have FTP access to the hosting of the website - this FTP store has several other of my sites and you are only to access the files in the StickScene folder.
You will also have access to a PHPMyAdmin control panel, through which you can view the database for the sites that I run. Again, by taking this job you are agreeing to only access the StickScene database.
You will be working with the live version of the site - it's already broken so errors during testing are not a problem as long as you can fix the main issue rapidly.
This job should be quite easy - a few lines of PHP/MySQL should be able to fix the problem once you've worked out where the issue lies.
Very good written English communication is highly desirable - bids written with bad grammar are likely to be ignored.
Bids that show no indication of having read this brief are also highly likely to be ignored.
This is a position of trust, giving you passwords and usernames to access files on my server. Copying of any data, website design, or any other materials that you are given access to is strictly forbidden for any purposes outside of this job. Likewise the sharing of any infomration that you are given is strictly prohibited. if detected then local law enforcement agencies will be contacted. Naturally, honest freelancers will have no problem with this.
I would like a very fast turnaround on this work - preferably by the end of the weekend if possible.