Here is the situation:
I made an affiliate program for a search engine.
it logs each searches, all click on the results. We now need a fraud prevention system. I want to log only click that have been made for a given keyword only once per 24h period as well as all clicks within a resonable time (let's say 1 min between each click). So as an exemple,
if a user would search for 'casino' and clicks 2 results then get out of the site.. and come back a few hours later and again, search for 'casino' and clicks 3 other results, none of the 3 clicks would have been recorded, but the first 2 would have been recorded. follow me?!
So I guess I need to use session to do that, along with IP/Cookie.. correct? we got about 100k searches done per day.. so it logs 100k searches, 40k clicks, queries the data base to get some info of the affiliates to put in the DB along with the logging of the searches/clicks .. so that's a hell of a lot stuff being stored into the DB.
My question, what would be the best way to put a fraud protection as mentionned above? Session?
if so.. can you provide me with the basement of such a class? Thanks!