Referral URL

[robroscob]

I would like to keep the referral url from my old script, for example: pespro - mysite.com/?ref=1 to oldaffiliate url - mysite.com/?r=1

Any idea how to do this? do i need to change anything in the database, column etc?
Thanks in advance.