Vbscript Screen Scraping forum member list

Have the feeling that everybody is staring at you in the other forums? Then look here, in this forum nobody does care what you say ;-)

Moderator: Project members

Post Reply
Message
Author
User avatar
ronczap
503 Bad sequence of commands
Posts: 18
Joined: 2018-02-20 00:13
First name: Ron
Last name: Czapala
Location: Kentucky
Contact:

Vbscript Screen Scraping forum member list

#1 Post by ronczap » 2018-02-24 04:49

I noticed a lot of new forum members being added where the first name and last name were the same. It looked like a BOT was responsible.

I contacted Tim and he banned the IP address and deleted about 30,000 bogus members. I was manually checking the member list and found more.

I decided to automate the process, so I wrote a vbscript which creates two InternetExplorer.Application objects.

It opens the member list in one IE window (sorted in descending Date Joined sequence).
The vbscript loops thru the HTML table on the page and opens the user profile for each username in the other IE window.
It captures the first and last names and the date joined and creates a .htm file containing username where the last name matched the first.

I set a limit of five pages (50 names on a page).

I also made a YouTube video of the script running (just one page of 50 members)
https://www.youtube.com/watch?v=dcoIxdq0Ros

User avatar
ronczap
503 Bad sequence of commands
Posts: 18
Joined: 2018-02-20 00:13
First name: Ron
Last name: Czapala
Location: Kentucky
Contact:

Re: Vbscript Screen Scraping forum member list

#2 Post by ronczap » 2018-02-26 15:03

I tweaked the vbscript to also check the "Most active forum" to see if a member has ever visited any forum.

More bogus members are being added - here is the latest result (looking at the 200 most recent added users)
Results.jpg
Results.jpg (110.46 KiB) Viewed 13907 times

User avatar
ronczap
503 Bad sequence of commands
Posts: 18
Joined: 2018-02-20 00:13
First name: Ron
Last name: Czapala
Location: Kentucky
Contact:

Re: Vbscript Screen Scraping forum member list

#3 Post by ronczap » 2018-04-22 19:39

Koweitta wrote:
2018-04-22 19:22
Is the vid deleted? I can't watch it.
Yes, I deleted it. It appears the bogus members are being filtered out now or the spammers moved on...

User avatar
botg
Site Admin
Posts: 31510
Joined: 2004-02-23 20:49
First name: Tim
Last name: Kosse
Contact:

Re: Vbscript Screen Scraping forum member list

#4 Post by botg » 2018-04-22 21:45

And there you actually replied to a spammer yourself.

User avatar
ronczap
503 Bad sequence of commands
Posts: 18
Joined: 2018-02-20 00:13
First name: Ron
Last name: Czapala
Location: Kentucky
Contact:

Re: Vbscript Screen Scraping forum member list

#5 Post by ronczap » 2018-04-22 21:52

botg wrote:
2018-04-22 21:45
And there you actually replied to a spammer yourself.
LOL - they are everywhere!

Tim, I assume you instituted some mechanism for identifying and purging these people (or bots)...

User avatar
botg
Site Admin
Posts: 31510
Joined: 2004-02-23 20:49
First name: Tim
Last name: Kosse
Contact:

Re: Vbscript Screen Scraping forum member list

#6 Post by botg » 2018-04-23 06:02

Common sense. A new user, posting only in off-topic, giving unhelpful replies only vaguely connected to the topic, that's a spambot or worse.

User avatar
boco
Contributor
Posts: 24118
Joined: 2006-05-01 03:28
Location: Germany

Re: Vbscript Screen Scraping forum member list

#7 Post by boco » 2018-04-23 07:37

Neither of those we want and need here. Spamming human or spamming bot, doesn't matter.
### BEGIN SIGNATURE BLOCK ###
No support requests per PM! You will NOT get any reply!!!
FTP connection problems? Do yourself a favor and read Network Configuration.
All FileZilla products fully support IPv6. http://worldipv6launch.org
### END SIGNATURE BLOCK ###

User avatar
botg
Site Admin
Posts: 31510
Joined: 2004-02-23 20:49
First name: Tim
Last name: Kosse
Contact:

Re: Vbscript Screen Scraping forum member list

#8 Post by botg » 2018-04-23 13:03

It feels like every country with a capital >25°E with the exception of Japan, South Korea, Australia and New Zealand is inhabited solely by spammers.

User avatar
ronczap
503 Bad sequence of commands
Posts: 18
Joined: 2018-02-20 00:13
First name: Ron
Last name: Czapala
Location: Kentucky
Contact:

Re: Vbscript Screen Scraping forum member list

#9 Post by ronczap » 2018-04-23 13:33

botg wrote:
2018-04-23 13:03
It feels like every country with a capital >25°E with the exception of Japan, South Korea, Australia and New Zealand is inhabited solely by spammers.
I also find it amazing how many attempts to logon to my FileZilla server I get every day.
I have added a bunch of CIDR ranges to my IP Filter.

Been using https://whatismyipaddress.com/ip-lookup to see what country/location they are coming from and https://www.ipaddressguide.com/cidr to convert the IP Range To CIDR

Post Reply