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

173.224.120.87 47790 2011-08-04 17:44:16.613
184.154.209.234 47070 2011-08-04 17:42:19.560
188.165.236.34 46670 2011-08-04 17:56:21.113
188.138.103.153 40141 2011-08-04 15:58:09.180
173.224.120.249 32667 2011-08-04 12:46:33.817
217.174.250.168 20474 2011-08-04 08:54:05.427
173.224.124.212 10978 2011-08-04 04:55:51.077

2 comments:

  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

    ReplyDelete
  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?

    ReplyDelete