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: Nov 2019 I like it Show Printable Version Email this Page

vB Version: 4.x.x Rating: (30 votes - 5.00 average) Installs: 327
Released: 06 May 2012 Last Update: 17 Dec 2012 Downloads: 1398
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:	1116
Size:	133.8 KB
ID:	138294   Click image for larger version

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

Name:	dupecheck_vb4.jpg
Views:	1071
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 17:35
Track all Duplicate IP Addresses via Admin CP Jolten vBulletin 3.0 Full Releases 73 28 Jul 2006 06:04

  #106  
Old 06 Oct 2012, 15:06
TheSupportForum TheSupportForum is offline
 
Join Date: Jan 2007
Originally Posted by Robbed View Post
Great addon.

just a suggestion when report for registration ip addresses runs could you add an option where any users found will be moved to (COPPA) Users Awaiting Moderation.
in some countries you will have shared IP's due to the limitation a country would have on ISP

for example Serbia and Montenegro, they both share the same ISP's and their IP's are duplicated, so i think its not a good idea
__________________
http://www.multihunters.co.uk - all your coding needs
Reply With Quote
  #107  
Old 06 Oct 2012, 16:35
Robbed Robbed is offline
 
Join Date: Oct 2005
that why it would be an option to turn on or off, everyone on my registration ip list is a spammer it would be easier to have them in moderation and have to approve these accounts.
Reply With Quote
  #108  
Old 06 Oct 2012, 20:48
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
Originally Posted by Snowhog View Post
BoP5@

Is it possible to designate more than one userID in Report by User ID? The description for this field doesn't indicate you can.
This doesn't send the report to the user, it is who the report gets posted by so only 1 id.

Originally Posted by Robbed View Post
Great addon.

just a suggestion when report for registration ip addresses runs could you add an option where any users found will be moved to (COPPA) Users Awaiting Moderation.
I will think about this, not really a direction I intended to take this mod.
__________________
-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
  #109  
Old 08 Oct 2012, 03:14
Jennifer2010 Jennifer2010 is offline
 
Join Date: Mar 2011
I get a database error when trying to run a report.

After clicking Run report, after about 15 seconds:

Database error in vBulletin 4.2.0:

Invalid SQL:

(SELECT permissions, permissions2, FIND_IN_SET(forumid, '53,8,-1') AS pos, forumid
FROM moderator
WHERE userid = 16 AND forumid IN (53,8,-1)
ORDER BY pos ASC
LIMIT 1)
UNION
(SELECT permissions, permissions2, 0, forumid
FROM moderator
WHERE userid = 16 AND forumid = -1
);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Sunday, October 7th 2012 @ 08:13:06 PM
Error Date : Sunday, October 7th 2012 @ 08:13:20 PM
Script : http://www.CENSORED.com/x1admincp/cr...check&manual=1
Referrer : http://www.CENSORED.com/x1admincp/op...roup=bopdupeip
IP Address : CENSORED
Username : CENSORED
Classname : vB_Database
MySQL Version :
Reply With Quote
  #110  
Old 08 Oct 2012, 03:27
ForceHSS's Avatar
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
http://www.vbulletin.com/docs/html/t...mysql_goneaway
Reply With Quote
  #111  
Old 08 Oct 2012, 14:52
TheSupportForum TheSupportForum is offline
 
Join Date: Jan 2007
@BirdOPrey5

a few questions

1) i set the Reports to be in a private forum, no other usergroups see the forum accept administrators

on activity.php for 4.2.0 PL2 it appears for all users

i was just wondering whether this mod works with the the activity stream as unregistered users can see the post as


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

this is shown to all usergroups including unregistered even though they should not have permission to view it
__________________
http://www.multihunters.co.uk - all your coding needs
Reply With Quote
  #112  
Old 08 Oct 2012, 17:45
Snowhog's Avatar
Snowhog Snowhog is offline
 
Join Date: Oct 2011
Real name: Paul L
Not so here. If I look at the Activity Stream as a guest (not logged in to the forum), I do not see the generated report, and I have it written to a sub-forum accessible only by the Administrator usergroup.
__________________
"It is a capital mistake to theorize in advance of the facts." - Sherlock Holmes
Kubuntu Forums . Net | ZB BLOCK | StopForumSpam
Reply With Quote
  #113  
Old 08 Oct 2012, 17:56
TheSupportForum TheSupportForum is offline
 
Join Date: Jan 2007
Originally Posted by Snowhog View Post
Not so here. If I look at the Activity Stream as a guest (not logged in to the forum), I do not see the generated report, and I have it written to a sub-forum accessible only by the Administrator usergroup.
for soem ready it shows, but found a fix using a plugin, strange but i hope that they implement a feature to not include certain forums
__________________
http://www.multihunters.co.uk - all your coding needs
Reply With Quote
  #114  
Old 08 Oct 2012, 20:46
BirdOPrey5's Avatar
BirdOPrey5 BirdOPrey5 is offline
 
Join Date: Jun 2008
Real name: Joe D.
Originally Posted by Jennifer2010 View Post
I get a database error when trying to run a report.

After clicking Run report, after about 15 seconds:
MySQL Has Gone Away Error probably means the query is overloading your database... How many users and how many posts do you have? You could try lowering the number of days back to look for each report.


Originally Posted by simonhind View Post
@BirdOPrey5

a few questions

1) i set the Reports to be in a private forum, no other usergroups see the forum accept administrators

on activity.php for 4.2.0 PL2 it appears for all users

i was just wondering whether this mod works with the the activity stream as unregistered users can see the post as


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

this is shown to all usergroups including unregistered even though they should not have permission to view it
That would be a problem with the permissions on your forum, not this mod- this mod uses standard code to create a new thread- it is up to the VB 4.2.0 code to decide what goes in the activity stream and what doesn't.
__________________
-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
  #115  
Old 09 Oct 2012, 04:19
TheSupportForum TheSupportForum is offline
 
Join Date: Jan 2007
Originally Posted by BirdOPrey5 View Post
MySQL Has Gone Away Error probably means the query is overloading your database... How many users and how many posts do you have? You could try lowering the number of days back to look for each report.




That would be a problem with the permissions on your forum, not this mod- this mod uses standard code to create a new thread- it is up to the VB 4.2.0 code to decide what goes in the activity stream and what doesn't.
Thank you

but i found it rather strange that the forum was visible to me only "set as admin view only" but activity stream showed the threads to all users

i found a solution posted in vbulletin.com

using example in a template hook postdata_presave


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

__________________
http://www.multihunters.co.uk - all your coding needs
Reply With Quote
  #116  
Old 09 Oct 2012, 12:26
Hostboard's Avatar
Hostboard Hostboard is offline
 
Join Date: May 2002
Real name: Steven
Fresh install on 4.2.0pl2
Ran the report after configuring it.
Report generated and posted but also got:


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

Reply With Quote
  #117  
Old 09 Oct 2012, 12:33
TheSupportForum TheSupportForum is offline
 
Join Date: Jan 2007
Originally Posted by Hostboard View Post
Fresh install on 4.2.0pl2
Ran the report after configuring it.
Report generated and posted but also got:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.
have you se the forums you want the reports sent to

e.g.


also ensure that the userid that reports it has access to that forum
__________________
http://www.multihunters.co.uk - all your coding needs
Reply With Quote
  #118  
Old 09 Oct 2012, 13:21
Hostboard's Avatar
Hostboard Hostboard is offline
 
Join Date: May 2002
Real name: Steven
As noted, the reported ran and it posted properly.
Reply With Quote
  #119  
Old 09 Oct 2012, 13:53
TheSupportForum TheSupportForum is offline
 
Join Date: Jan 2007
Originally Posted by Hostboard View Post
As noted, the reported ran and it posted properly.
Hmm i can only think its how the query is formed for your MYSQL version
seeing that you received the threads in your chosen forum, the script works
__________________
http://www.multihunters.co.uk - all your coding needs
Reply With Quote
  #120  
Old 09 Oct 2012, 15:12
Hostboard's Avatar
Hostboard Hostboard is offline
 
Join Date: May 2002
Real name: Steven
Originally Posted by simonhind View Post
Hmm i can only think its how the query is formed for your MYSQL version
seeing that you received the threads in your chosen forum, the script works
Running MySQL version:: 5.1.63-0ubuntu0.10.04.1
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 23:53.

Layout Options | Width: Wide Color: