Administrative and Maintenance Tools - Duplicate IP Report by BOP5 (Checks for users sharing the same IP Addresses) VB3/VB4

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

[djbaxter]

Strange issue:

I have this installed on four 4.2.0 PL2 forums. On three, everything works as expected. On the fourth, for some reason all posts from this mod are placed in the moderation queue.

Forum permissions look fine (no moderation required for posts in that forum and it's only used for Duplicate IP reports).

Admin permissions look fine and the author of the Dup IP posts is set to me. If I manually start a new thread in that forum, it is NOT moderated.

Not a critical error I know but it's driving me nuts trying to figure out why it's happening. I should note that this forum is on the same dedicated server as one of the others which is working, so it's not a server configuration issue.

[Snowhog]

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.

[BirdOPrey5]

Originally Posted by It's Damn Real!

Automatic report didn't run.

Out of ideas. If you want to PM me Admin CP / FTP / phpmyadmin details i'll take a look but not even sure where I'd start.

Originally Posted by Superorb

I ran the report from the Scheduled Tasks section and it returned these errors. The post was created and looks good though.

Duplicate IP Report by BOP5

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in [path]/includes/cron/bop5_dupeip.php on line 126

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in [path]/includes/cron/bop5_dupeip.php on line 259

Done

known bug, thank you.

[Robbed]

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.

[TheSupportForum]

Originally Posted by Snowhog

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.

why would you have you need a post sent via more than 1 user to a thread ?
it is designed as an automatic thread creator by 1 user to report duplicate IP's creating a post under 2 or more different usernames

[TheSupportForum]

Originally Posted by Robbed

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

[Robbed]

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.

[BirdOPrey5]

Originally Posted by Snowhog

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

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.

[Jennifer2010]

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 :

[ForceHSS]

<a href="http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway" target="_blank">http://www.vbulletin.com/docs/html/t...mysql_goneaway</a>