Thursday, August 4, 2011

Some spammers are freaking persistent

I wonder why some spammers are so freaking persistent that they would request the same video from multiple computers gizillion times per second.

select IP, count(SessionID), max(dtCreated) from RepeaterSessions
where SessionID in (select distinct SessionID from RepeaterVideoRequests
where VideoID=1106567 and dtCreated > '2011-08-04')
group by IP
order by count(SessionID) DESC 47790 2011-08-04 17:44:16.613 47070 2011-08-04 17:42:19.560 46670 2011-08-04 17:56:21.113 40141 2011-08-04 15:58:09.180 32667 2011-08-04 12:46:33.817 20474 2011-08-04 08:54:05.427 10978 2011-08-04 04:55:51.077


  1. hi got this WM 8650 Notebook Laptop Android 2.2, and tried to put a new firmware but does not recognize the keyboard could send me a website or a way of recognizing the keyboard Firmware

  2. Hello, thank you for making the Youtube Repeater.
    On Firefox, I have pinned four tabs of youtube repeater each with a difference music link. However when I open the browser, three of the four play automatically. Is there a way to have none of them play on startup?