Closed

Ip Check and Redirector Script

This project received 8 bids from talented freelancers with an average bid price of $159 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
8
Project Description

Hi,
I need a web page redirector script that will be compatible for me to INCLUDE on classic ASP landing pages as well as add to masterpages on ASPX landing pages:

1. Take value on the querystring (eg.?btag=TEST) as well as the IP address (refer_ip) as inputs to an SQL2005 stored proc
2. Open connection to the SQL server and execute stored proc with the 2 inputs above
3. The output of the proc will return 3 values:
a. RedirectUrl
b. Country
c. SubID
4. If rows are returned, then only return Top1:
a. it must redirect to the RedirectURL that is returned
b. As well as pass the other 2 additional output values into the querystring together with the initial btag value(eg. [url removed, login to view])
c. Close all DB connections etc
5. If NO rows are returned OR values are NULL then:
a. Close page and close connections

MANDATORY REQUIREMENTS FOR THE SCRIPT:
1. The script must only run ONCE within the same session, else it may cause looping issues
2. If there are SQL connection issues OR locks, there must be no error pages returned and the script must allow for a maximum of X amount of tries before it closes

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online