**I added some important points below in red.
We are in need of some php/mysql help.
We are designing a website that will be a membership site. Some of the content will be able to be viewed by everyone and some of it is for members only. So we need to have people be able to pay to sign up and then have them choose a username and password to login to the members only area. We need to be able to have their membership expire after a certain time (depending on if they paid for 1 year, 2 year, etc.) and notify them when their membership does expire.
We also want to generate a referral code to each new member, so they can tell a friend to use enter that code when they sign up and users can earn cash or points (still figuring that out) by signing up their friends. Also, members can choose to receive a monthly newsletter. There would need to be a way for members to look up their membership info and be able to track their referrals and edit their preferences.
Here is some clarification so you can make a final bid. We have changed our minds and would need to have 3 Tier referrals, so that makes things more complicated.
As for the preferences, that would involve name, email, address, newsletter option, and an option to "cash out" their referral money. How the "cash out" works may change as we develop the site more, but to start it can just send an email to one of us that tells us that someone wants their money. They are going to be able to choose a money option or a company points system toward merchandise instead of cash. For instance, they may have earned $8 cash but if they want they can use it for merchandise and that $8 is now worth $12. These aren't exact figures of how it will work, but we need to be prepared to set up a system like that at some point. For now, it can send an email on cashout option.
I think accounts should be automatically activated using a script.
As we go along, I am sure we will think of more things to add, we can make those additions a new project or keep adding to this one and keep adding to the price. We will be very fair about this, we understand as we go there may be some things that come up and that these additions will cost you time and therefore money. This could become an ongoing project for the winning bidder.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
We were thinking using PHP/MySql, but are open to any suggestions.