Referral URL tracking script

I require a script or application that has the ability to do the following in order(must be in .php): 1. Input all referring URLs to any site I produce into my MySQL database. 2. Each referring URL must then be assigned a number or code. Example: [login to view URL],GGLJ:2006-22,GGLJ:en&q=online+gaming This referring URL is assigned a code of **5564** [login to view URL], this assigned code is then appended to the end of any **subID or campaign identifier** within my websites links that I need it appended to through way of **cookies**. Example: [login to view URL](assigned code, in this example would be **5564**) or [login to view URL]**5564**. 4. Also, if a visitor came to my site from [login to view URL] and then left the site, only to come back to my site later from <[login to view URL],GGLJ:2006-22,GGLJ:en&q=online+gaming>. The **LAST visited URL** assigned code should be appended to the end of any links that apply. In this example, the visitor would be assigned a code for the google URL and then that code would be appended to the subID of any links I need it for. 5. I have to have the ability to add or change **subIDs** that identify where the appended code is attached to. Each site may have different SubIds. 6. I must have the ability to delete old, stored URLs from the database. 7. The appended links must be cloaked. ** NOTE:** This code will need to be installed on several sites, so I need to be able to install this or have instructions. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. ## Platform The script will need to work within the .php language and the database will operate on MySQL and phpMyadmin.