Simple database driven web page

I need a simple database driven web page functionality implemented. It needs to work in Hostmonster but then again Hostmonster supports a wide variety of scripts. You can make the webpage using php, Joomla, Ruby or anything you like. Only the functionality matters to me.

This is a hobby project and thus I cannot pay very much. I'm hoping that this is still possible to do through the maker already having most of the needed components ready from previous projects. This is also for you guys who do not yet have a rating to bid in. You may also bid higher than the range if you think it cannot be made with less.

To bid in, let me know briefly what kind of similar projects you have worked on, how you would make the site and how I could later submit new databases of problems into it.

Attached is a powerpoint file with the site design (all states defined and a very simple visual design suggested). The site does not have to look exactly like this, but something similarly simple and clear. The explanation textboxes and related arrows are naturally just for you and not to be implemented on the site. The site texts are written in Finnish language as the site will function in finnish. I have explained the functionalities in english in the explanation boxes in the ppt file.

The webpage needs to have a login and registration. The user may register a username and a password. Beyond these, each registered user's data contains only two other variables: 'problemsSolved' (integer) and 'skipsRemaining' (integer). The initial values for these are 0 and 100. I'm assuming that the user database would use an SQL database but I'm open to ideas. It needs to be as light and simple as possible, but it also needs to be able to handle even over ten thousand registered users (if there would be surprising luck). Obviously no one should be able to access the contents of the user database file and read the passwords of other users. It would also be good if I could somehow delete a user if needed.

The main function of the webpage is to either pull a random problem or the next problem from a separate database of problems to solve. Each problem is a three word combination (for example 'askel mittari mato'). Two of the words (first and third in the example) are displayed as a problem to solve and the third word is the solution (it is a conjoined word task in Finnish language). The player can write a solution to a textbox and press a submit- button which then compares the submitted word against the database solution and either passes or fails the users solution depending on if its the the same as the one in the database or not (same obviously passes).

The problem database will contain 1000 three word pairs, but it should be able to contain more or less as well. The problems need to be indexed, so that a registered user may stop for the day while at problem N and continue from the same problem the next time he logs in. The current problem index is problemsSolved + (100-skipsRemaining). If the user cannot solve a specific problem he can press skip, which then proceeds to the next problem similarly than if the previous one would have been solved correctly but deducts 1 from the user's skipsRemaining- variable. If skipsRemaining is zero, pressing 'skip' will not proceed to the next problem anymore.

If the user has not logged in (as when entering the entry page), a random problem is pulled from the database. Even when not logged in, the user can solve the visible problem or skip it. Skipping as well as solving randomly pulls a new one from the database. If the user's solution is wrong that is notified and the current problem remains unchanged so that the user can try again.

I need to be able to create and edit the problem database, preferably as one file. You need to let me know how to do this and also in what kind of format the file needs to be in and if your solution needs any tags (#INDEX, #WORD1 etc.) attached to the data in the file. I can generate the file with any tags and in anyway needed, even with xml fields. Again, no one but the site addministrator should be able to read the contents of the file as the file contains all problems and answers.

When logged in and solving or skipping problems, the user's username, amount of problems solved, remaining skips and rank are always visible (as in the ppt) and updated based on actions (solving or skipping). The rank is a text field that changes at certain amounts of problems solved (e.g. beginner from 0 to 100, apperentice from 101 to 200 etc.). A code file should contain the ranges and rank titles so that I can write them in. You can initially make it change at every 100 problems solved.

I also need to be able to backup the user database file every now and then. Currently I'm not sure how to do this if its a Hostmonster SQL database, but I'm sure I should be able to find it and access it as a file somewhere?

There is also a community- section in the design. I left it's page empty in the ppt file as I can create the community myself later. If you have an easy to install community script available, I certainly won't object to it being included but its not required.

During the project: please do ask me questions when unclear of something.

Rights: Obviously I need to be able to do what I want with the site and edit it as needed.

Deliverables: files constituting the website and install instructions.

.NET Joomla PHP Ruby on Rails SQL

Rif. progetto: #578618

Info sul progetto