In summary: Need 3 extra features added to PHP script. Involves adding few more fields in User registration page (and) user edit page. And adding corresponding MySQL entries to store the field information.
Love programmers! :-)
Thank you so much.
Andre
## Deliverables
I need 3 extra addons to my PHP script. Here they are...
**1)** Add additional fields to "/db/admin/[login to view URL]" and to database: (See here in red box, what needs to be added: **[login to view URL]**)
A) "Account Status:"
1) None [This is default value for every user]
2) Suspended [If this is ticked, then if user logs in at: [login to view URL] - message will show "Account suspended. Contact support.". If it's unticked, then login will be possible again by the user.]
3) Expired [If this is ticked, then if user logs in at: [login to view URL] - message will show "Account expired. Contact support to renew.". If it's unticked, then login will be possible again by the user.]
B) "Signup Date:"
[This is called from database that was automatically added when user was registered at: [login to view URL]]
C) "Source:"
1) eBay
2) Website
3) Other [Text field]
D) "Plan Type"
[Text field]
**2)** Create file "/db/[login to view URL]" which is identical to "/db/admin/[login to view URL]" - except for these differences:
A) Admin login is not requiered.
B) Putting customers email in URL (EG: [login to view URL]@[login to view URL]) will automatically load up that customers details from the database. And pressing "Update Account" button will update the details if anything is changed.
**3)** Add additional fields to "/db/[login to view URL]" and to database: (See here in red box, what needs to be added: **[login to view URL]**)
A) When "Create Account" button is pressed, the current date is added into database. This date is shown as "Signup Date:" in "/db/admin/[login to view URL]" (AND) "/db/[login to view URL]".
B) "Source:"
1) eBay
2) Website
3) Other [Text field. Selected by default.]
C) "Plan Type"
[Text field]
**4)** Please also provide me what Queries to copy-paste inside PHPMYADMIN, in order to add the extra fields in my official live database.