Edit PHP, MySQL backend to iOS app - 4 changes required.

We would like you to make the following changes to the backend for our iOS app. FIRST CHANGE - RECORD MULTIPLE CHOICE TIME The first change is for the time spent by each user doing each multiple choice question to be stored in our backend. This will also need to be able to be aggregated to create meaningful information (eg. total time per multiple choice session, total time per topic). We would like the time per question to be stored as a separate column in Test Log. Because we like to see attention to detail, please refer to the word "microscope" in your bid when responding to this brief. We are using the API "api/v1/update/test" for storing multiple choice test. We have an example of the JSON request. We need to add a parameter "time_spent" to the database to store how many seconds users spent on each question. Requirement: 1. Can save time_spent and display in the web admin, JSON response. 2. Database will not be restored with this update. { list = ( { "question_id" = 241; status = 0; }, { "question_id" = 262; status = 1; }, { "question_id" = 277; status = 1; }, { "question_id" = 258; status = 0; }, { "question_id" = 215; status = 0; } ); "user_id" = 467; } SECOND CHANGE - REORDER TOPICS AND ALLOW SELECTION OF 'TRIAL' TOPICS Currently the app is set to automatically allow users to download the first topic of each subject. The user may then only download the remaining topics if they purchase the content to that subject. We would like you to: 1. Allow the topics to be rearranged in any order (currently this cannot be done), but maintaining the integrity of multiple choice question numbering (which are indexed by topic number). 2. Allow us to select which topic/topics can be downloaded automatically for free. We would like to be able to choose these, not just have it automatically be the first topic only. THIRD CHANGE - APP PASSWORD RESET FUNCTION We need a way for users logging into the app to be able to reset their app password which is generated when they register their account on the website. There is currently a function to "reset" their password on the website ([login to view URL]). While this allows them to reset their password to login to the app, it does not also reset their password on the app, and we need a way to do this). FOURTH CHANGE - CHANGE ERROR MESSAGES Currently between 1 and 3 login-related error messages returned by the server when theh user attempts to login are inaccurate (eg. if no account has been registered with a particular email address, the message says, "invalid email or password" rather than something like "unregistered email address entered." We need these messages to be changed. We are expecting to pay approximately A$160-A$200 for this project. We intend to commence interviews today, and you would need to be ready to start ASAP. Thank you, looking forward to seeing your brief! Best wishes, Daniel