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: Jul 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: 1397
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:	1114
Size:	133.8 KB
ID:	138294   Click image for larger version

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

Name:	dupecheck_vb4.jpg
Views:	1070
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

  #181  
Old 03 Oct 2014, 17:27
Skyrider Skyrider is offline
 
Join Date: Feb 2006
Originally Posted by BirdOPrey5 View Post
I'm may not be fully understanding the question- but looking at the SQL query it is clear the only IP addresses being checked in the posts report are the post IP addresses. It would be impossible for that query to check against registration IPs as those IPs are never returned/mentioned in the query.

If "Boo" is being returned in the post report it means the other username returned with boo has also posted posts with the same IP boo has posted from during the report period.
I'll give an example.

We currently found 2 forum profiles, of which we are sure that they are the same person, but the duplicate IP report isn't showing it in the report.

I'll replace Boo with Person A and the other profile with Person B.

Person A has a post count of 0, and the registration IP address in the AdminCP (of the profile) is 123.456.789 (not showing real IP address for obvious reasons). When I check his IP address through the AdminCP, it shows:

Registration IP Address - 123.456.789
Post IP Addresses - No Matches Found
Registration IP Addresses - No Matches Found

Awesome, lets continue!

Now, when I look at Person B

Has 3 post counts, and the registration IP address in the AdminCP is 987.654.321

Now, you can see that Person A and Person B don't have a matching IP address. However, when I use the AdminCP to View the IP address of Person B.

Registration IP Address - 987.654.321
Post IP Addresses - 123.456.789 [Find More Users with this IP Address]

Clicking "[Find More Users with this IP Address]" results in:

123.456.789 [host information here]

Post IP address:
Person B 123.456.789

Registration IP address:
Person A 123.456.789

As you can see. Person B with 3 posts, at least used the Post IP address of person A once. I can't find any IP reports from user A, but when I search through the IP results of Person B, I can find Person A.

I was wondering if this plugin can be extended a little bit so it can include the registration/post IP address match, regardless if it cannot be found in 1 profile, but can be found through another.

Hope you understand it a bit now.

(in this example I might have switched the IP's, 123 with 987 at the end. If that's the case, just swap them). Was using 2 example IP addresses and it is possible I mixed them up with one and other. But I think you'll get the general idea.

Last edited by Skyrider; 03 Oct 2014 at 17:48.
Reply With Quote
  #182  
Old 04 Oct 2014, 10:40
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
Oh, I did misunderstand. I thought you were reporting a bug because registration IPs were not only being checked against registration IPs...

Indeed it was by design registration IPs only check against other registration IPs and post IPs only check against other post IPs.

You want a report that checks across both...

Unfortunately that was not an intended option and it is not something I will be adding- it would be a more difficult query and honestly one I think would be of limited use- as is these queries can take a big hit on the server- making them more complex will increase the chance of timeout/db errors.

Sorry.

If I had an idea I'd give you a hint on how to make the change yourself- the query code is in the php file- but I'm not sure how to go about combining the two- as is these were about as complex a mysql query I can handle.
__________________
-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
  #183  
Old 08 Nov 2014, 17:10
Amenadiel's Avatar
Amenadiel Amenadiel is offline
 
Join Date: Sep 2006
+1 for supporting wildcards and or IP blocks in the IP whitelist field. I want to add Cloudflare's IP ranges.
Reply With Quote
  #184  
Old 08 Nov 2014, 17:58
Kesha Kesha is offline
 
Join Date: Apr 2010
Hey BOP!

I just installed your mod and I'm currently attempting to run it from the Admin CP (Options section) to try it out. I have a private forum set up, which is only accessible by Moderators and Admins. The issue is, when I click the Run Now button, the resulting page is simply "Duplicate IP Report by BOP5" followed by the word "Done" on a new line.

I saw a similar issue in this thread by another user so I decided to try some of what you asked him to do, with no luck. (disabling the Spam-O-Matic plugin, setting days to check to 1 & 1, etc.)

MySQL Version is 5.5.40-0ubuntu0.14.04.1, and PHP version is 5.5.9-1ubuntu4.5.

The forum itself is a large forum. Over 100,000 accounts are registered and over 1.9 million posts are in the database.

Any suggestions?

EDIT: Just figured it out... Apparently, the file that I uploaded did not have the correct permissions. After setting +rw on the file, it runs as promised and this mod runs now. Sorry about that!

Last edited by Kesha; 08 Nov 2014 at 18:05.
Reply With Quote
  #185  
Old 14 Nov 2014, 10:43
BJJBJ BJJBJ is offline
 
Join Date: Mar 2010
Originally Posted by Kesha View Post
Hey BOP!

I just installed your mod and I'm currently attempting to run it from the Admin CP (Options section) to try it out. I have a private forum set up, which is only accessible by Moderators and Admins. The issue is, when I click the Run Now button, the resulting page is simply "Duplicate IP Report by BOP5" followed by the word "Done" on a new line.

I saw a similar issue in this thread by another user so I decided to try some of what you asked him to do, with no luck. (disabling the Spam-O-Matic plugin, setting days to check to 1 & 1, etc.)

MySQL Version is 5.5.40-0ubuntu0.14.04.1, and PHP version is 5.5.9-1ubuntu4.5.

The forum itself is a large forum. Over 100,000 accounts are registered and over 1.9 million posts are in the database.

Any suggestions?

EDIT: Just figured it out... Apparently, the file that I uploaded did not have the correct permissions. After setting +rw on the file, it runs as promised and this mod runs now. Sorry about that!
I've got the exact same problem as above but his fix didn't work.
Reply With Quote
  #186  
Old 14 Nov 2014, 17:35
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
Originally Posted by BJJBJ View Post
I've got the exact same problem as above but his fix didn't work.
If you are having issue with the Gold version (the free one doesn't have Admin CP interface) please post in the mod thread on qapla.com or PM me on Qapla.com- I can't provide support for the paid mod here on vbulletin.org.
__________________
-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
  #187  
Old 15 Nov 2014, 17:17
Kesha Kesha is offline
 
Join Date: Apr 2010
Just wanted to provide another update. I've had a chance to install and use this mod now, and let me just say that it works surprisingly well with my forum (being a larger forum). The only thing that I wish this modification had, is a duplicate account checker upon registration (with similar style alerts as this mod) but for the price I paid (nothing), this mod does it all for me.

Thank you kindly to BOP5 for this wonderful mod.
Reply With Quote
  #188  
Old 15 Nov 2014, 18:15
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
Originally Posted by Kesha View Post
Just wanted to provide another update. I've had a chance to install and use this mod now, and let me just say that it works surprisingly well with my forum (being a larger forum). The only thing that I wish this modification had, is a duplicate account checker upon registration (with similar style alerts as this mod) but for the price I paid (nothing), this mod does it all for me.

Thank you kindly to BOP5 for this wonderful mod.
Thanks for the kind words. I couldn't "Like" this post because I liked an earlier one. But to your "wishes" if someone registers with an IP address already used (and within the time window specified) they will show up in the report the next say.

If you wanted to actually prevent someone with the same IP from registering again that is possible with the Recent Registration Check mod which is free with the purchase of the paid version of this mod. It doesn't make a report, just blocks the registration (or moderates it) based on your settings.
__________________
-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
  #189  
Old 17 Jan 2015, 21:33
Snowhog's Avatar
Snowhog Snowhog is offline
 
Join Date: Oct 2011
Real name: Paul L
The mod posts the report to a specified Forum. I'd like to be able to choose between posting to a Forum or sending the report to an email address.
__________________
"It is a capital mistake to theorize in advance of the facts." - Sherlock Holmes
Kubuntu Forums . Net | ZB BLOCK | StopForumSpam
Reply With Quote
  #190  
Old 01 Jan 2016, 18:32
Faskis's Avatar
Faskis Faskis is offline
 
Join Date: Jul 2008
Real name: Chris
I've found that the scheduled task for this only runs if done manually, but does not run at the scheduled time (it does list a future date/time). I can't find anything about it in the error logs. Any help would be appreciated.
__________________
Reply With Quote
  #191  
Old 01 Jan 2016, 20:06
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Real name: Mark
Originally Posted by Faskis View Post
I've found that the scheduled task for this only runs if done manually, but does not run at the scheduled time (it does list a future date/time). I can't find anything about it in the error logs. Any help would be appreciated.
I have this set to run on the first day of each month, and it has always done so without fail.

Any additional information regarding how you have the product scheduled to run will be helpful to the mod author when providing support.
__________________
Former vBulletin.org Staff Member



Support for my products (as well as updates/new product publishing) has been moved to MHB - vBulletin Products and TAZ - Add-ons
Reply With Quote
  #192  
Old 01 Jan 2016, 20:32
CAG CheechDogg's Avatar
CAG CheechDogg CAG CheechDogg is offline
 
Join Date: Feb 2012
It also runs as it should for me ...
Reply With Quote
  #193  
Old 02 Jan 2016, 14:32
the one the one is offline
 
Join Date: Nov 2013
Real name: malcolm
Works great for me
Reply With Quote
  #194  
Old 02 Jan 2016, 17:23
Faskis's Avatar
Faskis Faskis is offline
 
Join Date: Jul 2008
Real name: Chris
Originally Posted by MarkFL View Post
I have this set to run on the first day of each month, and it has always done so without fail.

Any additional information regarding how you have the product scheduled to run will be helpful to the mod author when providing support.
I have it set to run at midnight each day at the moment. Next runtime is listed as 1/3/2016 @ 12:00AM. This is how the settings look at the moment: http://puu.sh/mh58u/49266da7d2.png


The scheduled task log only shows the 3 instances that I'd ran the task manually: http://puu.sh/mh5dD/ee096d632c.png



Any idea on how the scheduled tasks actually run? Does it cue the server to run a command-line instance of PHP to execute the task, via cron or whatever have you? I was thinking if it attempts to do something like a cURL request that maybe Cloudflare could be interfering with the connection (I had that issue recently with a script that I was working on).
__________________
Reply With Quote
  #195  
Old 05 Jan 2016, 15:02
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
It adds a scheduled task to vBulletin's list of scheduled tasks that can be seen in the Admin CP under Scheduled Task Manager.

Like all scheduled tasks they are only triggered if there is regular traffic to the forum because they are initiated on a page load where the cronimage is triggered which is in the footer template.

If no one visits the site at night the task never gets triggered.

There is a window of course, if someone comes soon after it should trigger, but at some point it just won't trigger.

Try setting it to run during a busier time of the day on your forum perhaps.
__________________
-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
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 11:37.

Layout Options | Width: Wide Color: