Outline: The system will be used for a 2 level affiliate scheme where visitors to our website will be able to enter in basic details, such as name address etc, click submit and will then be automatically emailed a welcome email (which we can change in the system) that will include their website address, e.g., [url removed, login to view] where 0000123 is that affiliates "ID" number so we can track any sales they have done. The commission structure will be 2 level, i.e., affiliate A refers affiliate B, affiliate B makes and sale and earns £20 and because of this affiliate A also earns £20.
We see 2 systems being required. 1 for the affiliates to join and then log in and see stats on their downline, sales, news from us, a forum that only affiliates can use, change their details, reset the minimum payment amount, e.g., if they want to be paid when they reach a £200 balance.
The 2nd is a "backend" system for ourselves to see overall stats, commission that should be paid where we can enter that it's been paid and it will be shown on the affiliates system, a place to add news to appears in the affiliate system, be able to ban / delete / users and also set up "super users" that don't have any downline - these people will be financial brokers that obtain a different commission structure and will not belong in the "affiliate" group.
We would also like a feature where we can get the system to email us a backup of the mysql database as the db will be very important and we need to protect this in the event of server issues etc.
We would like to have the system use a cookie, set for 1000 days which retains the affiliate information. We will eventually have around 20 different sites that we would like to use the same cookie with and this cookie data will need to be past to another system via a form (this other system is already live and operated by a 3rd party)
We also require the ability for us, via the "admin" panel to add new product / services names, so when we add new products we can select the new product when we enter an affiliates commission. Affiliate commission will be entered manually by ourselves once a sale is confirmed.
Our main goals are to ensure commission and stats are always correct, and the data is secure by means of backups and our primary focus is to provide the affiliates with a top of the range, feature packaged affiliate control panel. If you could offer any additional features that would be useful to the affiliates these would be most welcomed.
1) We wish to see the system working either on our or your systems
Unix / PHP / MySQL