63769 Affiliate Rotator Script

The software I want created consists of a few components including a fairly simple MySQL database and some php scripting. I would like to create a website to promote an internet service, but I would also like to be able to offer others the same opportunity to earn some affiliate commissions from the same system. So here is what I will need to accomplish this. I need a simple PHP form where the other affiliates can enter their: 1. First Name 2. Last Name 3. Affilate ID (EXAMPLE: 49138) 4. Email Address 5. Choose "Standard" or "Premium" Clicks (A tick box or drop down menu can be used for this purpose) If the "Premium" option is selected, the user should be redirected to a special payment link which I will setup and if the "Standard" option is selected, the user will be sent to directly to a (different) "Thank You" page (The "Standard" or "Premium" Clicks packages will be explained a little later in this description...) That form must write their details into a table in a MySQL database. Now Here's How The Rest Of The System Should Work... My normal "Order Link" looks something like this: a href=webaddress/billing/cgi-bin/[url removed, login to view] img border="0" src="images/[url removed, login to view]" width="302" height="91" /a The number "49138" at the end of the first line (above) is my affiliate ID. I need a script that will replace the affiliate ID part of that order link (49138) with a random/different affiliate ID which it extracts from the MySQL database every time the sales page is reloaded/refreshed. I would also like the script to include basic click tracking. In other words, the software should perform the following additional functions: 1. The database should also keep track of how many times a particular affiliate ID has been shown/served (impressions) and how many times the affiliate ID has been clicked on. 2. The script should also have a basic members "Login" area where the affiliates can view their impressions and click- through statistics AND upgrade their account if they desire If they click on the upgrade account option, the system should send them to the payment link and one their payment has been received, they would be redirected to the "Premium" member "Thank You" page which will automatically upgrade their account. (The "Premium" member thank you page must contain a tiny script which changes the value in the premium field to "yes" or "Y") 3. The script should also have an Administration Control Panel which can be used to view all member statistics and to manually upgrade/downgrade a user to or from a "standard" member status to a "premium" member status. What Are "Standard" or "Premium" Clicks? If the user selects the "Premium" option from the form we discussed earlier, then their affiliate ID should be shown more frequently as determined by the 'Administrator' EXAMPLE: If the Administrator logs into the Administration Control Panel and sets the ratio at 3/1 then each affiliate ID which is tagged as a "premium" account in the database will be shown 3 times for every 1 time that the "standard" members affiliate details are shown. The Administration Control Panel should therefore have a tiny text block (box) where the Administrator can enter the "premium" member ratio. EXAMPLE: Premium Ratio: [ ] / 1 The administrator should also be able to view all active members of the system in a table format with the option to delete/upgrade/downgrade the members accounts The table should preferably display 50-100 users per page. If possible the script should also have the ability to automatically archive and clear the old statistics every 90 days. (NOT the users, just the impressions and click-through) If you have any further questions about my software request please just let me know and I'll try to explain it more clearly. Thanks a million and I look forward to receiving your quotation on the abovementioned software :-) UPDATE… ********** By the way, I will also need to add one more level to the software I referred to "Standard" or "Premium" clicks, but I will also need to add (at least) one more level called "Partner" which will have a 10 to 1 ratio. So instead of having a "Premium" field and having Yes/No it might be better if the software allowed the Administrator to create up to five custom fields with different click ratios, like this. Package: [BLANK TEXT BOX] - Ratio: [] / 1 EXAMPLE: If the Aministrator logs into the Administration Control Panel he/she should have the option to set the ratio for Package: "Standard" - Ratio: [1] / 1 Package: "Premium" - Ratio: [3] / 1 Package "Partner" - Ratio: [10] / 1 Package "EMPTY" - Ratio: [] / 1 Package "EMPTY" - Ratio: [] / 1 (The "Standard", "Premium" and "Partner" labels in the example above should also be blank text boxes which the administrator can fill in with whatever name they choose for the packages to be called) I know that those little changes are a bit more tricky but they will give me a little more flexibility for future upgrades if I decide to offer a few different packages. I look forward to receiving your quotation. Thanks a million,

Odd Jobs PHP

Projektin tunnus: #1812234

Tietoa projektista