Url Rotator And Web Form
I need a URL rotator and Website Form that will operate on my domain (Domain1) and can be embedded on other domains and pages. This will operate with a mysql database. The idea behind this is to force users to sign up for an account at my other domain (Domain2).
The page will look as follows:
1. Title
2. Description
3. Sign up now for Domain2 (This will be the URL Rotator Link)
and complete the form below.
a. This will open another window
(www.Domain2.com/{username})
b. {username} will be a rotation of User Names currently
in the mysql URL database (URL_Rotations_DB).
i. This database will be built from the form
below.
c. New users need to complete this step to obtain a
sponsor from Domain2 in order to complete the
following form and be added to the url rotation.
4. Form.
a. Data that will be collected is as follows:
i. First Name
ii. Last Name
iii. Email Address
iv. Phone Number
v. User Name
vi. Sponsors First Name
vii. Sponsors Last Name
viii. Sponsors Email Address
ix. Sponsors Phone Number
x. Sponsors User Name
b. In order to verify that the data obtained is correct
the sponsor information must already be in the
Members database (Members_Database) and accurate.
i. This will be done by searching for the
Sponsors User Name in the Members Database
and verifying the new user entered a valid
Sponsor User Name, then it will need to
verify the Sponsors other information (First
Name, Last Name, Phone Number, and Email)
matches that Sponsors User Name entered.
c. If the new user entered valid sponsor information the
new users’ information (First Name, Last Name, Email,
Phone Number, User Name, and sponsors info) will now
be added to the Members database (Members_Database)
and their User Name to the URL Rotation Database.
5. URL Rotation Maintenance
a. After a user has sponsored 5 new users his username
will be deactivate from the URL Rotation Database.
This can be done by setting database value at 0 and
ending them in the rotation at 5, or similar formula.
b. They will still be able to be used as a sponsors on
the form, therefor need to remain in the members
database.
6. My information will be the first set in the members database
and on the url rotation.
7. My User Name will remain in the URL rotation and not limited
to the 5 as listed above.
8. I will need an embed code for this page so members can embed
it on their own domains and pages.
9. If possible I would also like to be able to pull the
databases off of the server into a csv file. I am sure there
is a simple way to do this on my server.
This project will need to be done to specifications and operate as listed above.
Once the sponsor gets the message they can go see the athletes profile page and his stats and if he wants to sponsor that athlete the sponsor clicks the Yes or No button on the athletes request and will send their contract to the athlete.
