Currently we have a rotator that is delivering people to a website from a link similar to
[url removed, login to view]
Right now the rotator is moving to the next person everytime the link is clicked even if the same person clicks the link.
TASK#1) We want to save every lead that clicks the link in a database and include their ip address and a date time stamp.
TASK#2) We want the rotator program to check the database for the email address and if it already exists in the database then we don't want it to rotate. We want it to redirect them to another website instead of doing anything else. Also we want the database to track how many times they click the link. (we never want the rotator to move unless it is a NEW email address)