database fix

On the sign up process, in step 1 i want user to have also to upload one picture (only one), i want it to be mandatory, they cannot move to second step without uploading a picture. This is urgent Once this is done we will work on a copy of the database located on another server from another domain i own -Modifications on sign up In specifications (step 3) after « J'ai des photos prises en studio? » add also this question : « Je suis membre de l’UDA ou ACTRA? » with « oui » « non » as options (yes or no) , they can only chose one option. Accounts that already exist will have a “non” value by default. So this question needs to be included in sign up and database. As you can see in database. There is a rating system from 1 to 10. This is a coding that helps admin to categorize models. Currently there is no script on it but I need one. This script will trigger the access to the gallery you’ve created. When admin change one model rating to « 10/10 ». model will recieve an email with their account info and link to access the gallery you’ve created. Also their gallery will be created. Gallery will be empty with no pictures (even if they’ve loaded pictures in the sign up process since those pictures are not professional they’ll be erased or desactivated and they will need to upload the new professional pictures by themselves) The rest of info. Size, eye color etc will be transferred automatically since that info will be already available. So the model will be able to acess that gallery and upload his gallery pics and also change some of the info (he wont be able to change height,breast size…all available gallery info) but he will be able to change email,phone number, address. As soon as they receive link to create their portfolio I want also to add in their profile info, the date their gallery was created. One year later I want their gallery to automatically desactivate. admin will be able to reactivate it from panel if needed but they have normally a “1 year subscription”. In the model gallery panel, I want to be able to sort out models by name and also by date of subscription As you can see in database, admin is able to search models based on all features. I still want this to work. It means that if a user changes his phone number in his gallery profile, phone number will be changed in old database too. That is why I want you to connect them together so they work in combination. About the gallery you created, models enter the info the way they want while in the old sign up. Info has options. For example eye color, they can write wathever they want, even colors that don’t [login to view URL] makes it hard to use search engine. I need it to be like old database meaning that they have options for eyes color. Blue,Grey, Green and they need to choose that option. So that is basically what I need