saynotojava

Let me put this way - let's say you are webmaster, and i am advertiser. I give you a link to advertise on your site, you checked it and it is fine. But i added a setting to redirect to bad url which is different then your browser, and wouldn't you want to know what is really happening? I dont need to know what exactly is user doing it after url is loaded, but i do need to know does he see same thing when i load url in my browser.

Purpose of this is to detect malware/bad links in redirect url - when you have a redirect url which redirect based on criteria, url might be fine when you check with your browser, but could be malware/bad link with other browser. Method does not need to be iframe(this is just idea to do it), nor user need to stay on site, i just need to see what happening with user when he leave site. At the moment i need to use different browsers manually to do such checks, but when you have tons of links to check it become a tedious job.

How do i record with php when user loads external url which redirect , what urls's he loaded by using invisible iframe(so the user still stay at my site) ? I do know this can be done with curl and i tested it, but problem with curl how it access url redirect by using server, while it should access as user.

But where is Tags in Video? That one is in list form (Dogs,Cats) and cannot be changed as it used already. That look fine if i would start with fresh table structure but i need to find solution to make it work with Tags in list form at table Video.

Ok let me give entry example: Table Name: Videos VideoId - 12345 Tags - Dogs,Cats Clicks - 150 So this is current table, where problem is when i order by Clicks, there will be same video showed on both tags(tags is same thing as categories). Video should have separate clicking statistic for each Tag listed in Tags, so there could be different videos listed when clicking on Tag ordered by clicks. I was thinking about removing Clicks from structure of table videos, then creating table called Clicks which will contain Videoid, Tag and Clicks. So Videoid should be same value as relevant videoid in table Videos, so we can know to which video entry is related clicking statistic. And here is example: Table name:clicks Videoid:12345 Tag:Dogs Clicks:150 Hopefully now is more clear.Can post more examples if needed.

I have a table which currently contain data like Videoid,Tags,and clicks. As table Tags contain multiple tags, this causing problem where a same video will show a top clicked video on each tag section which it contain. What it should be,is how each tag have it's own clicks. At the moment solutions which i have but dont find it suitable are following: 1.To put a single tag instead list of tags, this is problem as then i would have to copy same data for every tag 2.To create another table called Clicks, and everytime when it is clicked on video in new tag, copy all relevant data from first table and then call UNION query. Problem with this how we also have duplicates(tho alteast not big as in first case, as new data is inserted only when click occur) and second is how same videos could show, as first it will show one which contain click stats and single tag, and then same video which dont contain click stats from first table. Closest to solution was using CROSS JOIN query, but problem with that query is how is simply pulling all data id by id, and it need to be linked, for example both tables have Videoid table which is same, and then order by Clicks which is in second table.