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!

[Thunderbird8]

Something that just came to mind, I don't think social groups or visitor messages are currently checked for duplicates, though I don't know how much it'd be needed with the registration IP check already in place.

[BirdOPrey5]

Yeah I don't expect they will be added anytime soon either. Looking at the database tables the IP addresses in those sections are stored in a different format then posts and user table.

I don't feel it is that much of an issue.

[liamwli]

Installled

But I get a mysql warning when I click the 'Run Now' button....

[ceho]

Would it be possible to add new reports to one thread as a new post instead of having a new thread for each report ? Great mod by the way. Gave me a lot of important information!

[BirdOPrey5]

Originally Posted by liamwli

Installled

But I get a mysql warning when I click the 'Run Now' button....

I would need to see a copy of the warning to attempt to fix the problem.

Originally Posted by ceho

Would it be possible to add new reports to one thread as a new post instead of having a new thread for each report ? Great mod by the way. Gave me a lot of important information!

It's something I will try to add to a future version.

[liamwli]

Originally Posted by BirdOPrey5

I would need to see a copy of the warning to attempt to fix the problem.



xxx

Attatched via image as well:

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in [path]/includes/cron/bop5_dupeip.php on line 126

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in [path]/includes/cron/bop5_dupeip.php on line 259

[AusPhotography]

Known problem https://vborg.vbsupport.ru/showpost....9&postcount=52

[BirdOPrey5]

Yes, that bug will be fixed in the next release. In the mean time it does not stop the mod from functioning.

[liamwli]

Originally Posted by BirdOPrey5

Yes, that bug will be fixed in the next release. In the mean time it does not stop the mod from functioning.

In the meantime you can stop talking to me like that.

[ForceHSS]

Originally Posted by liamwli

In the meantime you can stop talking to me like that.

I dont see his reply being rude in any way