We are looking for some PHP & MySQL development
The Overall Outline
We are looking to create a secure membership site which has pre-paid PIN code access. The membership pages will initially hold access to a series of links to Adult content which is being licensed (2257 Certified)
The site which has been mocked up is a non adult generically branded front page ([url removed, login to view])
The End User purchases a pre-paid membership card and comes to the site for the card/membership activation, they scratch off the security foil to reveal the 6 character alphanumeric Activation Number (AN) on the back of the card, they enter it into the activation page, to complete the process of activation they also create a 4 digit PIN code.
The card also has a unique serial number (Card Serial Number) printed on it for batch management (this is sequential and linked to the Activation Number)
Once activated the End User is then allocated XX days of membership for the membership area (specific content) The user will now go to the login section to enter the Activation Number (printed on the card) and PIN code they have created as part of the activation process.
Every time the user logs on through the WIACP site they will be initially presented with a page detailing the summary of their account, numbers of days left of membership, expiry date and content they are subscribed to.
When the user logs in we allow them access to our members area, we would like to hold logs of logins against ‘accounts’ – We need to pass the user to the licensed content.
Please have a look at [url removed, login to view] this is a non working version of the site we are creating, and should give you an idea of the processes involved – We are looking to integrate the new code in to this website to make it fully functional.
[url removed, login to view] - Main Site
[url removed, login to view] - Admin Area
We are looking for a developer/development team to achieve the following:
• Create a secure membership area around current mock up ([url removed, login to view])
• Integrate website with membership database
• Website Optimisation
• Create Secure Admin Area with:
2. Account management features
Creation of Accounts (Activation Numbers and Card Serial Number)
Exporting of new account and card serial info in CSV format
Addition of Distributor Info against Card Serial Number – this may have multiple tables as a distributor may have sub distributors
Ability to add Membership days, Content Name, Page URL to Card Serial Number batches
Ability to suspend or delete individual or batches of Card Serial Number
3. DB Backup tool – Ability to backup the entire DB to CSV or similar recovery file.
• Pin Code Access requirements
1. Creation of ‘Accounts’
Activation Number (6 Character alphanumeric with checksum digit or similar)
Card Serial Number (Sequential Serial Number from 10m)
2. Activation Time/Date Stamp
3. Creation of Expiry Date
4. Write to DB new PIN Code (on Activation) Associated to ‘Account’
We will provide hosting environment for final product and development environment if required, Windows Server, MySQL & PHP.
Time Scale for Project
The time scale is FULL delivery by 23rd August or before.
25% on 50% Completion and sign-off of Work
50% on Full Completion and sign-off of Work
GAF Escrow Payment Account
Further extensions of the site/project could be handled via separate projects on this freelancer site or directly. We envisage a long-time relationship with the correct supplier.
When responding to this project, please provide specific explanatory notes with your bid, not only general / standard statements
Any queries please let me know ASAP
we sould be able to take up the project, given our vast experience with online applications involving login management and backend db processing. pls see pm for details. thanks, viv