Backend Affiliate website and database with user generated content PHP mySQL

Only bid if you know how to create the particular functions and you understand affiliate- You need to have worked on affiliate publisher websites before backend complete website and database with logic - where users sign up, login, upload content, links, share other merchant links, commenting, upload via mobile, mobile optimised. A backend database system will need to be developed. One of the main function where they could not do what I required which was a function to automatically convert the uploaded link by user to an affiliate link. E.g - if users upload a deal/voucher code of a merchant, with a link, then I would like that link to be automatically converted to my affiliate link instead of me manually having to change all of them. I know manually I would be able to change those links to my affiliate link, but how can that be done automatically if there are over 200 links and content being posted daily. Also I am registered to 3 affiliate networks currently. interview question - •What do you understand about affiliate? •How many projects have you worked on affiliate publisher websites? Mobile friendly and optimised? Show example •What do you understand about my website? •What functions do you need and can you make for my website? •What tools will you use to develop my website? php5 ajax MySQL