I need two main functions, link tracking and email open tracking, this will be done using a transparent gif, and link tracking, where UID's are passed.
## Deliverables
Email Opening Tracking
I need a php script written that allows me to track clicks from emails.
so I want to add links and it generate me a tracking url
eg:
I add:
[[login to view URL]][1]**!UID -> [[login to view URL]][2]!UID**
**
Then when people visit** [[login to view URL]][1]**!UID****
I want a php script run, that first Enters the UID date and time, and can run a series of other sql queries (I must be able to add quieries to run for each link, and reference the UID in the query.)**
**It needs to do a query to get the email address and info from that UID eg:**
**Select* FROM lm_users WHERE UID = ‘%UID%’**
**Add all this info into an array that can be read from by mycustom sql scripts**
**Example query to be run:**
** **
INSERT INTO <em>lm_users</em> (col1,col2,col3) VALUES($name,$email,$info);
**
The user is then taken to the final link.
If they click a second time, It will need to record this and have the option of running more queries.
The second php script I need is:
I want to place a small tracking gif in my emails, and when it loads it runs a php script, that records the email was opened (again UID will be included) each time image loads to register the fact. then once registered, it must be able to run a series of mysql quieries that i define. and return an image header.**