Track all Duplicate IP Addresses via Admin CP

[Jolten]

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

[mr.gamesbay]

nice :)

*click install*

[misterfade]

Good, simple hack! *installed*

[MindTrix]

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

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

[Jolten]

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.

[neocorteqz]

wonder if this will work with 3.0.3?

Might try later.

Nice hack though.

[Jolten]

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

[Vevina]

Sweet Installed :)

[Jolten]

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

[rinkrat]

Nice! Can you do the same for passwords?

[Jolten]

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

[rh2004]

Excellent someone has made it :)

Thanks for this

[yoyoyoyo]

***clicks install***

[Revan]

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

* Revan clicks install

[achtungbaby]

Super hack.

[SIINSI]

Nice! Can you do the same for passwords?

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

[Slave]

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

:)

[sub_ubi]

Nevermind, misunderstood the hack.

[Ski-Whiz]

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

[Jolten]

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

[SVTOA]

Great stuff!!

[JustAskJulie]

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.

[Jolten]

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.

[JustAskJulie]

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.

[Tom1234]

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?

[Vevina]

Thanks for the update :)

[007]

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???

[Jolten]

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.

[Gunshot]

very nice

installed and working well

[djwins]

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

[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]

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*

[Snake]

There is just one problem with this hack. If 2 users are registered on the forums and are living nearby (neighbours I mean), there IP address will show up the same thing. Because they both live in the 'same' country so you won't notice properly if a user has multiple accounts or not. It may be a person who is so close to your country that will use the same IP as yours, or a person who has registered multiple accounts. That is the only problem with this hack. :tired:

[Jolten]

IP ranges may be similar. But IPs should never be identical just because users are neighbors unless they are using something like AOL.

[mkdevo]

There is just one problem with this hack. If 2 users are registered on the forums and are living nearby (neighbours I mean), there IP address will show up the same thing. Because they both live in the 'same' country so you won't notice properly if a user has multiple accounts or not. It may be a person who is so close to your country that will use the same IP as yours, or a person who has registered multiple accounts. That is the only problem with this hack. :tired:

that doesn't really make any sense...

[Snake]

What do you mean it doesn't make any sense?

Now your post doesn't make any sense and is pointless.

[osariase]

This is very good especially to flush out people that are using multiple names, however I want to ask is there anyway to to attache user names to these ips? so u will be able to know who is using more than one id in your forum.

is there?

thanks and by the way this is good hack

[mkdevo]

What do you mean it doesn't make any sense?

Now your post doesn't make any sense and is pointless.

as Jolten said, neighbors don't/shouldn't have the same ip address (unless one is taking advantage of the other's unencrypted wireless network. ;))

[tamarian]

Just installed. Looks good :up:

I have a suggestion for future release.

1. Add a page jump
2. Allow sorting by the number of duplicates.

I selected to disply 250 per page, and still got 67 pages :) So a page jump would be handy.

[SmartGnome]

Have installed the mod and in first view I like it much.

Install is clicked

[Jolten]

Just installed. Looks good :up:
1. Add a page jump
2. Allow sorting by the number of duplicates.



On the list.
I do not know that I'll be updating for v3.5 though. My site is fine at 3.0.7 and I see nothing in 3.5 that warrants my upgrading.

[BlackRabbit]

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

:)


Can anyone give an example of implementing this into the script?

TIA

BR ;)

[tamarian]

I do not know that I'll be updating for v3.5 though. My site is fine at 3.0.7 and I see nothing in 3.5 that warrants my upgrading.

Do you mind if I update it and release it fro 3.5?

[Jolten]

Feel free tamarian, just credit me.

[tamarian]

Feel free tamarian, just credit me.

Most definitly :)

[tamarian]

Version 3.5 has been released here:

https://vborg.vbsupport.ru/showthread.php?t=91633

[Snake]

You da man!

[BlackRabbit]

Originally Posted by 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.



Can anyone give an example of implementing this into the script?

TIA

BR ;)

PLEASE!!!

[ReZ]

Hmmm, you mention there are "Total Queries -- 3" wheres the information for these?

[Jolten]

What information? The queries are run in the php file that you must install.

[ReZ]

Ohhh...ok then, thanks alot Jolten.

[lazytown]

clicked install - nice hack

Couple of suggestions that shouldn't be hard to implement

It would be really useful if it did a reverse-ip lookup (or are they stored in the database already) and displayed it along with the highlighted account/ip. That way we can see right off if its a proxy/aol cache/etc.

If it could sort by any column heading (posts, last date, etc) but still show the duplicate ips grouped together as they are now.

If things could be restricted by user input in the the form, like only show with > x number of posts, or after x login date.

-V

[m0nde]

Great hack :up:

- Sid

[ZombieAndy]

how would i give super mods permission to trace duplicate IP's aswell?

[loftyasianz]

i guess you could in the modcp.php file add in the construct for the new option but put a if statement in there something like <if condition="$bbuserinfo['usergroupid']==XX"> where XX is the smod usergroup id so only the smod can see it o.o

[Jolten]

how would i give super mods permission to trace duplicate IP's aswell?

copy dupip.php to the modcp folder.

In the copy of dupip.php

find:

if (!can_administer('canadminusers'))


and change to:

if (!can_moderate('canviewips'))


in modcp/index.php

find:

construct_nav_option($vbphrase['search_ip_addresses'], 'user.php?do=doips');


immediately ABOVE that line add:

construct_nav_option("Dup Ips", 'dupip.php', '<br />');


This allows mods to see the duplicate IPS but ONLY if you allow the moderator usergroup to view them (via your usergroup settings in the admincp).

[ZombieAndy]

copy dupip.php to the modcp folder.

In the copy of dupip.php

find:

if (!can_administer('canadminusers'))


and change to:

if (!can_moderate('canviewips'))


in modcp/index.php

find:

construct_nav_option($vbphrase['search_ip_addresses'], 'user.php?do=doips');


immediately ABOVE that line add:

construct_nav_option("Dup Ips", 'dupip.php', '<br />');


This allows mods to see the duplicate IPS but ONLY if you allow the moderator usergroup to view them (via your usergroup settings in the admincp).

thanks alot jolten its working now :)

[NxTek]

Very odd. My admincp/index.php contains the following -

construct_nav_option($vbphrase['add_new_user'], 'user.php?do=add', '|');
construct_nav_option($vbphrase['dup_ip'], 'dupip.php', '|');

But it doesn't show up. It goes from Add New User to Search for Users.

[Jolten]

Very odd. My admincp/index.php contains the following -

construct_nav_option($vbphrase['add_new_user'], 'user.php?do=add', '|');
construct_nav_option($vbphrase['dup_ip'], 'dupip.php', '|');

But it doesn't show up. It goes from Add New User to Search for Users.


Add the phrases indicated in the install instructions.

[PyroChixRock]

thanks! this is a nice mod.

[Telegon80]

nice. is there a version for 3.5.0 already?

[Jolten]

Tamarian ported it for 3.5

https://vborg.vbsupport.ru/showthread.php?t=91633&highlight=Duplicate+Ips

[gigaenvy]

Cool hack. One step further would be to prevent duplicate IPs like how we use our forums. One hour lockout if breach attempted.

[defcon_420]

excellent! works great in 3.0.13

[JVRudnick]

trying to install same...but the Step 3 area I don't understand...

"Add 2 new phrases.." where to what?

in fact, in the Admin CP, I "see" the space where the new Title should be,
that is, there is an extra space there...but it's empty as I don't know where
to add the Step 3 items?

:-(

Jim

[Jolten]

Try reading the "installDupIP1.2.txt" file.