Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Duplicate IP Report by BOP5 (Checks for users sharing the same IP Addresses) VB3/VB4 Details »
Duplicate IP Report by BOP5 (Checks for users sharing the same IP Addresses) VB3/VB4
Mod Version: 2.1.2, by BirdOPrey5 (IB Staff) BirdOPrey5 is offline
Developer Last Online: Jun 2019 I like it Show Printable Version Email this Page

vB Version: 4.x.x Rating: (30 votes - 5.00 average) Installs: 328
Released: 06 May 2012 Last Update: 17 Dec 2012 Downloads: 1394
Supported Additional Files Translations  

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.
Nominate MOTM if you LOVE it!

Download Now

Only licensed members can download files, Click Here for more information.

Screenshots

Click image for larger version

Name:	dupecheck_settings.jpg
Views:	1109
Size:	133.8 KB
ID:	138294   Click image for larger version

Name:	dupecheck_vb3.jpg
Views:	1649
Size:	96.1 KB
ID:	138507   Click image for larger version

Name:	dupecheck_vb4.jpg
Views:	1066
Size:	78.3 KB
ID:	138508  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Track all Duplicate IP Addresses via Admin CP (by Jolten) tamarian vBulletin 3.5 Add-ons 66 21 Apr 2011 16:35
Track all Duplicate IP Addresses via Admin CP Jolten vBulletin 3.0 Full Releases 73 28 Jul 2006 05:04

  #16  
Old 08 May 2012, 12:10
Skyrider Skyrider is offline
 
Join Date: Feb 2006
Originally Posted by New Joe View Post
That one is for vB Version: 3.7.1
Some say it works on vB 4 some say it doesn't.
That one isn't supported, this one is, by a Moderator of vB org as well.

I actually use another old version for such as this, and it works fine, but in the future I will start to use this one
Isn't that one Cookie based, and this one IP based?

Also, installed!
Reply With Quote
  #17  
Old 08 May 2012, 13:10
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
Originally Posted by sweetpotato View Post
What this Mod different from Mod Multiple account login detector (AE Detector)?
Thanks,
Really apples and oranges- I use both. That mod doesn't look at IP addresses at all, it looks for a cookie that can be easily cleared by a user who knows what they are dong.

It doesn't create reports, it PMs or posts on a single detection.

One isn't better than the other- just different mods.
__________________
-Joe
Former vBulletin.org Staff Member

(@BirdOPrey5) Former vb.org Moderator. Fighting for a free & independent vb.org.
BirdOPrey5.com - Exclusive VB Mods! (Formerly Qapla.com) | Joe's Ultimate Off Topic
Note - I do not read my PMs often, do not expect quick replies.
Reply With Quote
  #18  
Old 08 May 2012, 13:48
DonosOdD DonosOdD is offline
 
Join Date: Mar 2011
This looks yummy.

Tagged for later!
Reply With Quote
  #19  
Old 08 May 2012, 15:33
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
What does this mean?

Invalid Day Back - Report Not Run.
Reply With Quote
  #20  
Old 08 May 2012, 16:31
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
How many "Days back" did you set for the report to run for both posts and users?

It should be a value between 0 and 5000 for both of those or else you get that error.
__________________
-Joe
Former vBulletin.org Staff Member

(@BirdOPrey5) Former vb.org Moderator. Fighting for a free & independent vb.org.
BirdOPrey5.com - Exclusive VB Mods! (Formerly Qapla.com) | Joe's Ultimate Off Topic
Note - I do not read my PMs often, do not expect quick replies.
Reply With Quote
  #21  
Old 08 May 2012, 17:16
Nirjonadda Nirjonadda is offline
 
Join Date: Dec 2011
Real name: Md Tajirul Islam
Press this button to manually run the report not working:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Reply With Quote
  #22  
Old 08 May 2012, 17:59
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
Originally Posted by BirdOPrey5 View Post
How many "Days back" did you set for the report to run for both posts and users?

It should be a value between 0 and 5000 for both of those or else you get that error.
I left them at the defaults:

How Many Days Back To Check? (Posts) = 7
Enter the number of days of previous posts to search for this report. Set to 0 to disable this report.

How Many Days Back To Check? (Users) = 30
Enter the number of days of previous registrations to search for this report. Set to 0 to disable this report.

Records Limit = 500
This is the absolute max number of IP Addresses that will be returned in any report. Even on large forums this usually would not be a very large number, this limit is like a safety check- if your reports return anywhere near this limit there are probably bigger issues.

Note that this was a manual run. The full output says this:

Duplicate IP Report by BOP5


Dupicate IP Check Start
Post Report - Valid numdays: 7
User Report - Valid numdays: 30
No Duplicates Found - No Report Created
Invalid Day Back - Report Not Run.

Go Back

Done
Reply With Quote
  #23  
Old 09 May 2012, 00:06
Razta's Avatar
Razta Razta is offline
 
Join Date: Dec 2011
Real name: Khalid
Thank you very much, works great with vBulletin 4.1.12 Patch Level 1
Reply With Quote
  #24  
Old 09 May 2012, 01:21
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
Originally Posted by Nirjonadda View Post
Press this button to manually run the report not working:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
What values are you setting for days back? Try setting them low- really low, like 1 and 1, and see if it works. It will give me an idea of the issue.

Originally Posted by djbaxter View Post
I left them at the defaults:

How Many Days Back To Check? (Posts) = 7
Enter the number of days of previous posts to search for this report. Set to 0 to disable this report.

How Many Days Back To Check? (Users) = 30
Enter the number of days of previous registrations to search for this report. Set to 0 to disable this report.

Records Limit = 500
This is the absolute max number of IP Addresses that will be returned in any report. Even on large forums this usually would not be a very large number, this limit is like a safety check- if your reports return anywhere near this limit there are probably bigger issues.

Note that this was a manual run. The full output says this:
Are you familiar with running manual SQL queries if I gave you a couple to run?

Originally Posted by Razta View Post
Thank you very much, works great with vBulletin 4.1.12 Patch Level 1
Please "Mark It as Installed"
__________________
-Joe
Former vBulletin.org Staff Member

(@BirdOPrey5) Former vb.org Moderator. Fighting for a free & independent vb.org.
BirdOPrey5.com - Exclusive VB Mods! (Formerly Qapla.com) | Joe's Ultimate Off Topic
Note - I do not read my PMs often, do not expect quick replies.
Reply With Quote
  #25  
Old 09 May 2012, 01:57
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
Originally Posted by BirdOPrey5 View Post
Are you familiar with running manual SQL queries if I gave you a couple to run?
Yes. Fire away.
Reply With Quote
  #26  
Old 09 May 2012, 02:28
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
#1)


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

That is the code for the 7 day look back of the posts table. You will have to put a table prefix in front of "post" if you use them.

#2)


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

That's the 30 day look back of the User table.

I'm curious if either of these produce any results (return any rows.)?

If they don't, let me know. if they do maybe you can PM me what it returns, you can edit/mess up the IP addresses for privacy if need be.
__________________
-Joe
Former vBulletin.org Staff Member

(@BirdOPrey5) Former vb.org Moderator. Fighting for a free & independent vb.org.
BirdOPrey5.com - Exclusive VB Mods! (Formerly Qapla.com) | Joe's Ultimate Off Topic
Note - I do not read my PMs often, do not expect quick replies.
Reply With Quote
  #27  
Old 09 May 2012, 11:27
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
SELECT ipaddress, GROUP_CONCAT(DISTINCT userid) AS userid, GROUP_CONCAT(DISTINCT postid) AS postid
FROM post
WHERE dateline > 1335925435 AND userid > 0 AND ipaddress != ''
GROUP BY ipaddress
HAVING COUNT(DISTINCT userid) > 1
ORDER BY COUNT(DISTINCT userid) DESC
LIMIT 500;


Result: MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0026 sec )


SELECT ipaddress, GROUP_CONCAT(DISTINCT userid) AS userid
FROM user
WHERE joindate > 1333938235 AND userid > 0 AND ipaddress != ''
GROUP BY ipaddress
HAVING COUNT(DISTINCT userid) > 1
ORDER BY COUNT(DISTINCT userid) DESC
LIMIT 500;


Result: MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0030 sec )
Reply With Quote
  #28  
Old 09 May 2012, 11:40
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
OK. Well the good news is you don't have any duplicates in your forum.

The bad news is... I have to fix my code to deal with that situation- it was the one situation I couldn't test because I was always seeing duplicates in one or the other.

I'll probably release a fix later today. I'm confident that if you did have a duplicate the report would run as expected.
__________________
-Joe
Former vBulletin.org Staff Member

(@BirdOPrey5) Former vb.org Moderator. Fighting for a free & independent vb.org.
BirdOPrey5.com - Exclusive VB Mods! (Formerly Qapla.com) | Joe's Ultimate Off Topic
Note - I do not read my PMs often, do not expect quick replies.
Reply With Quote
  #29  
Old 09 May 2012, 12:19
djbaxter djbaxter is offline
 
Join Date: Aug 2006
Location: Ottawa, Canada
Thanks BOP5.
Reply With Quote
  #30  
Old 09 May 2012, 15:53
RisingGlow RisingGlow is offline
 
Join Date: Feb 2012
Awesome mod! Something that I've been looking for. Many IP/multiple accounts reporting mods really only check on registering, and not posts, which is just as vital.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 08:15.

Layout Options | Width: Wide Color: