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]

[redacted.]

[AusPhotography]

Bug if using mysqli ... change the free results to:

$vbulletin->db->free_result($aillps);

[BirdOPrey5]

Thanks for the tip, it will be in the next update.

[DAMINK]

What a great mod BOP5! seriously this is great. Rated and voted.
Just ran this and got this result.

[replacer_a] - Used by 18 users.

Not worried about the duplicates. Shows the mod is working well
The [replacer_a] i get ?????

[Thunderbird8]

I think I made one of my fellow administrators drool when I asked for opinions on whether or not to install this .

Filling in the user whitelist for the size of ours is gonna be a royal pain though...

[BirdOPrey5]

Originally Posted by DAMINK

What a great mod BOP5! seriously this is great. Rated and voted.
Just ran this and got this result.

[replacer_a] - Used by 18 users.

Not worried about the duplicates. Shows the mod is working well
The [replacer_a] i get ?????

I don't understand the question?

I assume it shows a real IP address and not "[replacer_a]" ?

[DAMINK]

No it doesnt BOP5.
It literally shows [replacer_a] instead of the ip address.
But its not a big deal. It still works just fine.
Here is a screener, and i know i did a year back which is silly but i had to to get some duplicates as i removed the recent ones.

[BirdOPrey5]

Do you have some mod that has changed the IP addresses stored in the IP Address column of the user table?

The only way I could see this happening is if you viewed your user table via phpmyadmin (or whatever) and saw [replacer_a] as an actual value of several users's IP addresses.

"[replacer_a]" isn't code that is used in this mod at all.

[DAMINK]

Yep i do actually have a mod for Country flags that might be the cause.
I will investigate this further and let you know thanks BOP5.

[ceho]

Hi, what a great mod, something I have been looking for since ages . Thanks a lot!