Track all Duplicate IP Addresses via Admin CP

Duplicate IP tracking v1.2 by Jolten

Be gentle, this is my first release.

What's this do?
This hack is an admin control panel addition. It will render a complete list of all users with duplicate IP addresses in your forums. And adds very little in terms of queries and sever load. This is designed to help those site admins, who wish to, to track users which may have duplicate accounts.

Be aware that many internet service providers (AOL, JUNO, NetZero) may assign the same IP to many different users. A duplicate listing is not an immediate indication of a duplicate account by the same user.



Installation
Files to edit -- 1
Phases to add -- 2
Files to upload -- 1
Database alterations -- None
Total Queries -- 3

Time to install -- Less than 5 minutes

Support
I can't promise full support but I will do all I can to fix any bugs or answer all questions. All support must be done strictly through this thread. If you are using this hack, please click the INSTALL button to be informed of any future updates, add-ons and bug fixes.


Enjoy!

Screenshot Below
It should be noted (since the screenshot doesn't show it due to my censorship of the names) that the list of usernames links directly to the adminCP user options for that user, allowing easy access to the users information.


Version log

version log
-------------------------------------------------------------

v1.0 --
Initial release


v1.0.1 --
small bug when clicking usernames fixed

UPGRADE INSTRUCTIONS:
Replace dupip.php

v1.1 --
added per page selection option
1 phrase added
1 query added

UPGRADE INSTRUCTIONS:
Replace dupip.php

Add 1 new phrase:
Phrase type: Control Panel Global
Varname: dup_ip_max
Text: Maximum Usernames Per Page

v1.2 --
Added display of email addresses for users who match IP addresses
Changed default per page numbers to greater quantities
Altered display to show first line of match more prominently.

UPGRADE INSTRUCTIONS:
Replace dupeip.php in your admin directory

[topten]

AWESOME!!! Too easy - well done mate

[Christine]

Thanks!

For our needs, I excluded all AOL and WebTV IPs in the script and it is working like a charm.

/me clicks install

[djwins]

Christine, would you mind sharing how you did that?

Thanks!

[Christine]

@djwins - add an exclude in the WHERE statement on the query and include these LIKES:

64.12.%,
152.163.%,
205.188.%,
202.67.%,
149.174.%,
195.93.%,
198.81.%
209.240.%

The first 7 are AOL banks and the last one is WebTV.

[Thomas Heretic]

Doesn't appear to catch all duplicate users. Just some spot checks show that it is missing some users that share more than one IP in common.

[Jolten]

It catches all users to the best of my knowledge. If the IP is recorded in the Database then it catches them.

[Thomas Heretic]

Originally Posted by Jolten

It catches all users to the best of my knowledge. If the IP is recorded in the Database then it catches them.

I believe I see the problem. It only catches IPs from the USER table. Since very few posters, from my experience, have static IPs this will not get a complete list of users that are posting from the same IPs.
The problem with an IP search on the POST table is it will not catch duplicate IPs from people that have never posted.
A combination of your mod and the default IP search would catch all users with duplicate IPs.
The screen shots I have attached show an example of the problem with vBulletin's default IP search and your mod. In the screen shots 4 users share IPs but not all 4 show on either method of checking.
Both catch some but not all users with duplicate IPs.

[hitmanuk2k]

Can someone provide a way to ignore people with 0 posts from the check.

[Tom1234]

Jolten,

Does this not check the POST table in addition to the USER table for IP's? If it doesn't, this should be made clear in the description of this hack.

[Snake]

Nice hack!

*installs*