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

nice :)

*click install*

Good, simple hack! *installed*

Brilliant release and works nice, installed so easily. One request.

Can it show how many pages of duplicate IP's there are, aswell???

I've updated to v1.1 to allow admin to select number of results per page and to show the total page count.

1 new query added and 1 new phrase added. Instructions are inside the zip file as well as in announcement above.

wonder if this will work with 3.0.3?

Might try later.

Nice hack though.

It should work fine with 3.0.3. But I haven't tried it.

Sweet Installed :)

Well this amazes me :) no problems anywhere. Thanks to everyone that installed :)

Nice! Can you do the same for passwords?

If I can figure out how to un-salt them, yes.

Excellent someone has made it :)

Thanks for this

***clicks install***

Brilliant hack! I have the IpInfo hack installed, but clicking every user to detect multiples are tedious :p

[high]* Revan clicks install[/high]

Super hack.

There was a hack that did this for vb2. It didn't actually show the real password itself, it just showed which members had the SAME password. The password was encrypted or something and appeared as a long # I believe.

This would be great as it worked very well for vb2.

Nice hack, hope to see this added!

Thanks,
Miguel

Installed on 3.0.3 .. works perfectly .. thanks for a great hack!

:)

Nevermind, misunderstood the hack.

Does it report when 2 users who have zero posts are sharing the same IP, or does this only query those IP's from the threads?

I'm looking for people who may have like 2-3 accounts with zero posts, yet the same IP.. :D

Post counts don't matter. It queries the IP at registration.

Great stuff!!

Anyway to also show email addresses in that list? Even tho I don't allow users to use the same email address for multiple accounts typically if they are the type trying to squeeze by their email addresses are also similar.

Sure I'll update tomorrow. Be aware that I will not track duplicate email addresses. Since vBulletin already allows you to limit registration to one email address per user there's no benefit in adding weight to my script to track duplicate email addresses. But I will add an email address column to display email addresses of users with duplicate IP addresses. This will only add a couple lines of code and won't cause any additional queries.

Look for it tomorrow.

Great. Thanks. I agree there's no reason to track duplicates.. I already have that set in my admin anyway... just nice to be able to compare for similar ones.

Jolten,

Could you consider using a smaller font for the dupe IP display now that more information was added (email addresses)?

Also, there was a hack in vB2 that displayed dupe IP's and also displayed whether each member listed could post or not. It was a good indicator to see those that are already banned. Maybe just display the usergroup for each member listed?

Thanks for the update :)

Wow... this doesn't work on 3.07 at all. It shows the same IP for tons of my members. People that I know don't even live near eachother.

Wait, looks like many of my AOL members have the same IP address... That's really stupid and annoying of AOL.. yet another reason I totally hate them.. :(

Ok it is probably just AOLers with screwed up IP addesses that will be a problem here. Anyone else notice this???

It's posted in the modification announcement that some service providers like AOL will assign duplicate IPs. There's nothing that can be done. This works fine in vb3.0.7.

very nice

installed and working well

A great (and simple) addition to this hack, would be the optional ability to NOT display users with an aol.com email address.

AWESOME!!! Too easy - well done mate :)

Thanks!

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

/me clicks install

Christine, would you mind sharing how you did that?

Thanks!

@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.

:)

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.

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.

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

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.

Nice hack!

*installs*