A PHP clicktracking system and backend to be implemented on Apache WordPress-like affiliate sites that run everything through an index.php file. The click recording system is pretty simple -- code to use the Request URI server variable to figure out where to redirect the user. I expect the front-end to be, maximum, 2 hours of work. The harder part of this project is the backend which uses the click data.



The basic idea behind the backend is generate reports to help administrate the website. Obviously the goal is to maximize earnings and conversion so anything helpful is a desired part of the backend. See below for details.



I am attaching a database structure with some comments for each table and what it is for. I expect the database will be roughly based on my structure but I am okay with some changes if you feel like it will make the system faster or more efficient. I also might have forgotten something.