340198 URL Shortner and Hits tracker

. . We provide brandable ebooks/products to our members which includes a link to a review site which has different reivews with link to the reviewed product, but we want to shorten/encrypt the link and track the hits We must be able to - track hits from ebook - redirect to our review site - and track hits from review site to those affiliate product so we know, which ebook got how many clicks and then from that hit how many clicked on the affiliate product on review site and finally see which member / user brought-in those clicks Admin should be able to create affiliate networks and products that need to be tracked… and can see unique / raw hits to those products Admin should be able to see which member, ebook/product brought in those hits. Stats should be taken down deep such as yearly/monthly/weekly/daily Memberwise / ebookwise / affiliateproduct wise REQUIRED 1. Robust link tracking 2. htaccess url rewriting is must 3. Optimized coding without putting much load on the server even if there are millions of entries 4. Hacker safe – the coding should not have any loopholes or a backdoor open for any hacker eg. xss attacks, link injection, sql injection, malicious code injection, javascript etc… 5. Clean, simple and user friendly Admin Area / Design (we may show a sample design) 6. Easy to add / edit / modify (should be userfriendly) 7. Fast loading PREFERRED: 1. Use of ajax in admin area 2. Use of graphs 3. Self expandable database which means after a year or so if we hit the single database capacity, it will create another database and start storing data in the new NOTE: 1. Place your bid only if you understand the requirement and only if you understand how link tracking / cloaking / cookies work 2. Place bid only if you can deliver the fully working script within 1 week 3. You should not use any cookie-cutter solution or any other existing script 4. We own full copyright of the script and you should not use full / part of it for any other the project FULL Details will be given only to the winning bidder including the actual flow eg. Database structure etc.. If you have any question feel free to PM All the best. . .