Administrative and Maintenance Tools - Duplicate IP Report by BOP5 (Checks for users sharing the same IP Addresses) VB3/VB4

Brought to you by BirdOPrey5
www.Qapla.com

Version 2.1.2 - Fixed MySQLi bug - Introduced GOLD/Premium Version
Version 2.1 - Added BBCode to Banned Users and Post Count Options, better debug info
Version 2.0 - Added report for Registration (User) IP Address Checking

Check out the GOLD Version for these additional features:

• Run reports directly from the Admin CP anytime you want
• Post daily report as a "New Post" into an existing thread rather than a "New Thread" each night
• Access to another Gold Mod- Recent Registration Check- will block spammers and scammers trying to register multiple accounts from the same IP address

This mod will run a nightly scan of your "post" and/or "user" table. It will report if it finds any users sharing the same IP address. You choose in the options how many days back you want to look. (Max of 5000 days, but please use more reasonable limits.)

If any "duplicate use" is found the IP addresses, usernames and optionally the posts themselves will be reported.

See a real report: Report Demo at Qapla.com

The report takes the form of a new thread posted to the forum of the Admin's choosing (A private forum for mods or admins is strongly recommended.)

There are options for whitelisting (ignoring) specific IP Addresses and/or userids so if you or your mods post as other users you can prevent that from being reported. If you use the Zoints Anonymous Posting mod you will want to put that userid on the whitelist else the report will out whoever posted "Anonymously."

NOTE: There are PERFECTLY valid reasons 2 or more users may share the same IP address. This report in and of itself is not proof of malicious activity. Users that connect by mobile devices, work in same offices, or go to the same schools for example would likely share the same IP address on some posts. So would too any users connecting from the same home or public Wi-Fi network.

As of version 2.0 there is a report for both the "post" and "user" table. The "user" table will find when 2 or more users register with the same IP address.

Tested and working on VB 3.8.7 and VB 4.1.12/4.2.0 and should work on all 3.7 / 3.8 / 4.x versions.

------------------------------------------------------

Please "Mark as Installed" if you use this.
Donations always appreciated. :up:
Nominate MOTM if you LOVE it!

[BirdOPrey5]

I'm sorry I don't know why. It may be your MySQL version is too old, I have only tested this on MySQL 5.x.x never got a chance to test on MySQL 4.1.21.

[Bubble #5]

Is there a way to have it send an e-mail to the admin, instead of posting a thread?

Would be so much easier to manage, and would catch most peoples attention sooner.

[ozzy47]

I suppose you could subscribe to the forum that you have the mod posting in and choose, Instant notification by email, then you would get a email that a new thread was made.

[Bubble #5]

Yes, but then you'd also have to go in and clean up 30 threads per month

Would be so much more straight forward to not make the threads and just send the e-mail. Just say'in

[ozzy47]

What do you mean by clean up threads?

IMO it is better to have the threads, so you have a record of the report, and if you or your mods took action on it, you can post in there what you did or did not due.

With that being said, I am sure it is very possible to have it as a email, but that will have to wait till Joe can get around to adding such a feature if he wishes to, or has the time to do.

[Bubble #5]

Originally Posted by ozzy47

What do you mean by clean up threads?

Clean up, as in delete them because they aren't needed anymore.

IMO it is better to have the threads, so you have a record of the report

You can save a e-mail just as easily, and mods on my site don't have access to this section of the forum. If someone is away from their site, say they are out shopping, they would still be made aware of what was happening on their site by getting an e-mail about it.

I am sure it is very possible to have it as a email, but that will have to wait till Joe can get around to adding such a feature if he wishes to, or has the time to do.

Yes, fully understand

[iraqiboy90]

Let's say;
- I have 200 users
- There are many duplicated IPs
- No more posts has been added or registration for a week.

then, does this mod create the same report 7 times?

ps. I have the gold version

[Bubble #5]

Once per night you'll get a report.

[iraqiboy90]

Originally Posted by Bubble #5

Once per night you'll get a report.

In other words; The same report 7 times....
Is there any option to exclude those numbers/IPs from showing on further reports if nothing new happens to them?

[ozzy47]

According to the original post: There are options for whitelisting (ignoring) specific IP Addresses and/or userids.